Sample Tables

BigQuery provides a limited number of sample tables that you can run queries against. These tables are contained in the bigquery-public-data:samples dataset in the BigQuery web UI. Click the name of the table to see additional information, such as field information and table size.

Name Description
gsod Contains weather information collected by NOAA, such as precipitation amounts and wind speeds from late 1929 to early 2010.
github_nested Contains a timeline of actions such as pull requests and comments on GitHub repositories with a nested schema. Created in September 2012.
github_timeline Contains a timeline of actions such as pull requests and comments on GitHub repositories with a flat schema. Created in May 2012.
natality Describes all United States births registered in the 50 States, the District of Columbia, and New York City from 1969 to 2008.
shakespeare Contains a word index of the works of Shakespeare, giving the number of times each word appears in each corpus.
trigrams Contains English language trigrams from a sample of works published between 1520 and 2008.
wikipedia Contains the complete revision history for all Wikipedia articles up to April 2010.

Other public datasets

See the following resources for additional public datasets:

Send feedback about...

BigQuery Documentation