Analyze NYC 311 Data with Google Bigquery

The entire NYC 311 service request data is also available as a public dataset on Google BigQuery: the dataset is automatically updated every hour and enables you to run arbitrary SQL-like queries over the entire dataset in seconds. To get started:

  1. If you don't already have a Google project...
    1. Login into the Google Developer Console
    2. Create a project and activate the BigQuery API
  2. Open dataset:
    1. You can use the public dataset:
    2. Or our augmented dataset:
  3. Execute your first query...

Service Request Intake Process

User Interview Guide