Fork this notebook to get started on accessing data in the BigQuery dataset by writing SQL queries using the BQhelper module.

Context

The Patent Claims Research Dataset contain detailed information on claims from U.S. patents granted between 1976 and 2014 and U.S. patent applications published between 2001 and 2014. The dataset is derived from the Patent Application Publication Full-Text and Patent Grant Full Text files, available at https://bulkdata.uspto.gov/, to which the Office of Chief Economist (OCE) applied a Python algorithm to identify individual claims as well as the dependency relationship between claims. From the parsed claims text, OCE created six data files containing individually-parsed claims, claim-level statistics, and document-level statistics, including newly-developed measures of patent scope.

Content

USPTO OCE Patent Claims Research data contains detailed information on claims from U.S. patents granted between 1976 and 2014 and U.S. patent applications published between 2001 and 2014.

Acknowledgements

"USPTO OCE Patent Claims Research Data" by the USPTO, for public use. Marco, Alan C. and Sarnoff, Joshua D. and deGrazia, Charles, "Patent Claims and Patent Scope" (October 2016). USPTO Economic Working Paper 2016-04.

Data Origin: https://bigquery.cloud.google.com/dataset/patents-public-data:uspto_oce_claims

Banner photo by William Iven on Unsplash

TheLook is a fictitious eCommerce clothing site developed by the Looker team. The dataset contains information about customers, products, orders, logistics, web events and digital marketing campaigns. The contents of this dataset are synthetic, and are provided to industry practitioners for the purpose of product discovery, testing, and evaluation. This public dataset is hosted in Google BigQuery and is included in BigQuery's 1TB/mo of free tier processing. This means that each user receives 1TB of free BigQuery processing every month, which can be used to run queries on this public dataset. Watch this short video to learn how to get started quickly using BigQuery to access public datasets.What is BigQuery .

The EUMETSAT Spinning Enhanced Visible and InfraRed Imager (SEVIRI) rapid scanning service (RSS) takes an image of the northern third of the Meteosat disc every five minutes (see the EUMETSAT website for more information on SEVIRI RSS ). The original EUMETSAT dataset contains data from 2008 to the present day from 12 channels, and for a wide geographical extent covering North Africa, Saudi Arabia, all of Europe, and Western Russia. This Google Cloud Dataset covers the full geographical extant, nearly full temporal extant, and all 12 channels up to the present. Some individual timesteps might be missing. This dataset is slightly transformed: It does not contain the original numerical values. See the "samples" section for more technical detail about the dataset. The original data is copyright EUMETSAT . EUMETSAT has given permission to redistribute this transformed data. The data was transformed by Open Climate Fix using satip . This public dataset is hosted in Google Cloud Storage and available free to use. Use this quick start guide to quickly learn how to access public datasets on Google Cloud Storage. Learn more

The EUMETSAT Spinning Enhanced Visible and InfraRed Imager (SEVIRI) rapid scanning service (RSS) takes an image of the northern third of the Meteosat disc every five minutes (see the EUMETSAT website for more information on SEVIRI RSS ). The original EUMETSAT dataset contains data from 2008 to the present day from 12 channels, and for a wide geographical extent covering North Africa, Saudi Arabia, all of Europe, and Western Russia. This Google Cloud Dataset covers the full geographical extant, nearly full temporal extant, and all 12 channels up to the present. Some individual timesteps might be missing. This dataset is slightly transformed: It does not contain the original numerical values. See the "samples" section for more technical detail about the dataset. The original data is copyright EUMETSAT . EUMETSAT has given permission to redistribute this transformed data. The data was transformed by Open Climate Fix using satip . This public dataset is hosted in Google Cloud Storage and available free to use. Use this quick start guide to quickly learn how to access public datasets on Google Cloud Storage. 了解详情

The EUMETSAT Spinning Enhanced Visible and InfraRed Imager (SEVIRI) rapid scanning service (RSS) takes an image of the northern third of the Meteosat disc every five minutes (see the EUMETSAT website for more information on SEVIRI RSS ). The original EUMETSAT dataset contains data from 2008 to the present day from 12 channels, and for a wide geographical extent covering North Africa, Saudi Arabia, all of Europe, and Western Russia. This Google Cloud Dataset covers the full geographical extant, nearly full temporal extant, and all 12 channels up to the present. Some individual timesteps might be missing. This dataset is slightly transformed: It does not contain the original numerical values. See the "samples" section for more technical detail about the dataset. The original data is copyright EUMETSAT . EUMETSAT has given permission to redistribute this transformed data. The data was transformed by Open Climate Fix using satip . This public dataset is hosted in Google Cloud Storage and available free to use. Use this quick start guide to quickly learn how to access public datasets on Google Cloud Storage. 瞭解詳情

ISO 3166-1 (Codes for the representation of names of countries and their subdivisions – Part 1: Country codes) is a standard defining codes for the names of countries, dependent territories, and special areas of geographical interest. It is the first part of the ISO 3166 standard published by the International Organization for Standardization. It defines three sets of country codes: ISO 3166-1 alpha-2 – two-letter country codes which are the most widely used of the three[citation needed], and used most prominently for the Internet's country code top-level domains (with a few exceptions). ISO 3166-1 alpha-3 – three-letter country codes which allow a better visual association between the codes and the country names than the alpha-2 codes. ISO 3166-1 numeric – three-digit country codes which are identical to those developed and maintained by the United Nations Statistics Division, with the advantage of script (writing system) independence, and hence useful for people or systems using non-Latin scripts. This dataset contains country names and their alpha-2 and alpha-3 encodings.Learn more

The EUMETSAT Spinning Enhanced Visible and InfraRed Imager (SEVIRI) rapid scanning service (RSS) takes an image of the northern third of the Meteosat disc every five minutes (see the EUMETSAT website for more information on SEVIRI RSS ). The original EUMETSAT dataset contains data from 2008 to the present day from 12 channels, and for a wide geographical extent covering North Africa, Saudi Arabia, all of Europe, and Western Russia. This Google Cloud Dataset covers the full geographical extant, nearly full temporal extant, and all 12 channels up to the present. Some individual timesteps might be missing. This dataset is slightly transformed: It does not contain the original numerical values. See the "samples" section for more technical detail about the dataset. The original data is copyright EUMETSAT . EUMETSAT has given permission to redistribute this transformed data. The data was transformed by Open Climate Fix using satip . This public dataset is hosted in Google Cloud Storage and available free to use. Use this quick start guide to quickly learn how to access public datasets on Google Cloud Storage. Saiba mais

The EUMETSAT Spinning Enhanced Visible and InfraRed Imager (SEVIRI) rapid scanning service (RSS) takes an image of the northern third of the Meteosat disc every five minutes (see the EUMETSAT website for more information on SEVIRI RSS ). The original EUMETSAT dataset contains data from 2008 to the present day from 12 channels, and for a wide geographical extent covering North Africa, Saudi Arabia, all of Europe, and Western Russia. This Google Cloud Dataset covers the full geographical extant, nearly full temporal extant, and all 12 channels up to the present. Some individual timesteps might be missing. This dataset is slightly transformed: It does not contain the original numerical values. See the "samples" section for more technical detail about the dataset. The original data is copyright EUMETSAT . EUMETSAT has given permission to redistribute this transformed data. The data was transformed by Open Climate Fix using satip . This public dataset is hosted in Google Cloud Storage and available free to use. Use this quick start guide to quickly learn how to access public datasets on Google Cloud Storage. Más información

The EUMETSAT Spinning Enhanced Visible and InfraRed Imager (SEVIRI) rapid scanning service (RSS) takes an image of the northern third of the Meteosat disc every five minutes (see the EUMETSAT website for more information on SEVIRI RSS ). The original EUMETSAT dataset contains data from 2008 to the present day from 12 channels, and for a wide geographical extent covering North Africa, Saudi Arabia, all of Europe, and Western Russia. This Google Cloud Dataset covers the full geographical extant, nearly full temporal extant, and all 12 channels up to the present. Some individual timesteps might be missing. This dataset is slightly transformed: It does not contain the original numerical values. See the "samples" section for more technical detail about the dataset. The original data is copyright EUMETSAT . EUMETSAT has given permission to redistribute this transformed data. The data was transformed by Open Climate Fix using satip . This public dataset is hosted in Google Cloud Storage and available free to use. Use this quick start guide to quickly learn how to access public datasets on Google Cloud Storage. Weitere Informationen

The Library of Integrated Network-Based Cellular Signatures (LINCS) Program is a national research consortium funded by the NIH to generate a diverse and extensive reference library of cell-based perturbation-response signatures, along with novel data analytics tools to improve our understanding of human diseases at the systems level. The LINCS project helps to gain a more detailed understanding of cell pathways and aids efforts to develop therapies that might restore perturbed pathways and networks to their normal states by generating and providing public data that indicate how cells respond to various molecular, genetic, and environmental stressors. The LINCS Data Portal , contains details about assays, cell types, perturbagens, and datasets that are part of the library, as well as links to the consortium sites, raw data, processing pipelines, and data citations. LINCS is an NIH Common Fund project. The Data Coordination and Integration Center (DCIC,grant number: U54HL127624), is awarded by the National Heart, Lung, and Blood Institute (NHLBI) through funds provided by the trans-NIH LINCS project and the trans-NIH Big Data to Knowledge (BD2K) initiative. See the LINCS Terms of Use for information on how to properly cite the dataset. This public dataset is hosted in Google BigQuery and is included in BigQuery's 1TB/mo of free tier processing. This means that each user receives 1TB of free BigQuery processing every month, which can be used to run queries on this public dataset. Watch this short video to learn how to get started quickly using BigQuery to access public datasets. What is BigQuery .