Beta NYC 2017: # Team 7

How can 311 data be used with performance data in the Mayor’s Management Report to help inform and improve agency performance by providing predictive insight or highlighting equity issues?

Full Detail

Amit Bhatia | [email protected] | github.com/amiglobe

Anela Chan | [email protected] | http://anela.co

Frank Donnelly | [email protected] | github.com/frankpd

Claire Gerson | [email protected] | github.com/cgerson

Lizette Leano | [email protected] | github.com/lizleano

Robin Newman | [email protected] |robinerinnewman.com/ saynomoregame.com

Kevin Nguyen | [email protected] | github.com/Kvn219

Nidhin pattaniyil | [email protected] | http://npatta01.github.io/

Sophie Rand | [email protected] |

Justin Ryan | [email protected] | github.com/carillonator

Eric Schles | [email protected] | github.com/EricSchles

Matthew Ström | [email protected] | matthewstrom.com

• FY16
• FY17

Example Query

# MMR FY - July 1, 2016 through June 30, 2017
SELECT
 unique_key,
 created_date,
 closed_date,
 agency,
 agency_name,
 complaint_type,
 descriptor,
 location_type,
 incident_zip,
 incident_address,
 street_name,
 school_name,
 school_code,
 address_type,
 city,
 landmark,
 facility_type,
 status,
 due_date,
 resolution_description,
 resolution_action_updated_date,
 community_board,
 borough,
 latitude,
 longitude,
 location
FROM
 `bigquery-public-data.new_york.311_service_requests`
WHERE
 created_date BETWEEN TIMESTAMP("2016-07-01 00:00:00.000")
 AND TIMESTAMP("2017-07-01 00:00:00.000")