Query Data Commons using SQL with BigQuery

The Data Commons repository is available as BigQuery tables in the Analytics Hub. If you have a Google Cloud Platform account, you can use Analytics Hub to issue SQL queries against the Data Commons tables. For more information, see the Analytics Hub introduction.

Tip: Before you start, you may find it helpful to review Data Commons key concepts.

In these pages are sample SQL queries grouped together by category. You can copy and paste the queries into the BigQuery Studio in the Cloud Console. In addition, all Data Commons visualization tools include a Get BigQuery SQL button, so you can also form queries by using the interactive tools on the website. For example: