Sample Tables

BigQuery provides a limited number of sample tables that you can run queries against. Each sample table is listed here, and you can find more information about each table by visiting the corresponding pages. In the case of the M-Lab sample tables, these are collected in a M-Lab public project that contains monthly M-Lab logs.

Name Summary # Rows
gsod Samples from US weather stations since 1929 115M
mlab Measurement data of broadband connection performance 240B
natality Birth information for the United States from 1969 to 2008 68M
shakespeare Word index for works of Shakespeare 164K
wikipedia Revision information for Wikipedia articles 314M