Branch: master
Find file History
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Type Name Latest commit message Commit time
Failed to load latest commit information.

Exploring Open Data with BigQuery

Thanks for the great conference everyone! Here's the code from the presentation that I gave.

Slides can be found here.

How to use these queries

All of these queries use publicly accessible data sets hosted on Google BigQuery.

running a query

To run them for yourself, follow these steps:

  1. Go to
  2. If you're new to Google Cloud Platform, create your first project. This may take you to the Google Developer Console. If so, return to
  3. Click 'Compose Query', paste the query in, and run it.

About Usage

You get 1TB of free query usage per month on BigQuery. Because I was trying to demonstrate how well BigQuery scales, some of these example queries use a lot more than that.