Sample Tables

BigQuery provides a limited number of sample tables that you can run queries against. These tables are contained in the publicdata: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.
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.
wikipedia Contains the complete revision history for all Wikipedia articles up to April 2010.