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: https://bigquery.cloud.google.com/table/bigquery-public-data:new_york_311.311_service_requests
    2. Or our augmented dataset: https://bigquery.cloud.google.com/table/nodal-component-204421:311_complaints.complaints
  3. Execute your first query...

Service Request Intake Process

User Interview Guide