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:
