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.
|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.|