Data Commons to BigQuery: Sample Queries

BQ Query in Data Commons (DC) Tools

For every visualization in the Map and Timeline tools, you can use the Get BigQuery SQL button at the bottom of the page to get the SQL query for generating the data used in that visualization. For an example, see this timeline chart and notice the Get BigQuery SQL button at the bottom.

Categories of Queries

Use the following categories of queries in BigQuery about the data in DC:

Places

Properties of Places

More Complex Queries

Joining with External Data