All 311 Service Requests from 2010 to present. This information is automatically updated daily. Click here to download data from 2011 - https://data.cityofnewyork.us/dataset/311-Service-Requests-From-2011/fpz8-jqf4 Click here to download data from 2012 - https://data.cityofnewyork.us/dataset/311-Service-Requests-From-2012/as38-8eb5 Click here to download data from 2013 - https://data.cityofnewyork.us/dataset/311-Service-Requests-From-2013/hybb-af8n Click here to download data from 2014 - https://data.cityofnewyork.us/dataset/311-Service-Requests-From-2014/vtzg-7562 Click here to download data from 2015 - https://data.cityofnewyork.us/dataset/311-Service-Requests-From-2015/57g5-etyj
This dataset has the following 41 columns:
| Column Name | API Column Name | Data Type | Description |
|---|---|---|---|
| Unique Key | unique_key | text | Unique identifier of a Service Request (SR) in the open data set |
| Created Date | created_date | calendar_date | Date SR was created |
| Closed Date | closed_date | calendar_date | Date SR was closed by responding agency |
| Agency | agency | text | Acronym of responding City Government Agency |
| Agency Name | agency_name | text | Full Agency name of responding City Government Agency |
| Complaint Type | complaint_type | text | This is the first level of a hierarchy identifying the topic of the incident or condition. Complaint Type may have a corresponding Descriptor (below) or may stand alone. |
| Descriptor | descriptor | text | This is associated to the Complaint Type, and provides further detail on the incident or condition. Descriptor values are dependent on the Complaint Type, and are not always required in SR. |
| Location Type | location_type | text | Describes the type of location used in the address information |
| Incident Zip | incident_zip | text | Incident location zip code, provided by geo validation. |
| Incident Address | incident_address | text | House number of incident address provided by submitter. |
| Street Name | street_name | text | Street name of incident address provided by the submitter |
| Cross Street 1 | cross_street_1 | text | First Cross street based on the geo validated incident location |
| Cross Street 2 | cross_street_2 | text | Second Cross Street based on the geo validated incident location |
| Intersection Street 1 | intersection_street_1 | text | First intersecting street based on geo validated incident location |
| Intersection Street 2 | intersection_street_2 | text | Second intersecting street based on geo validated incident location |
| Address Type | address_type | text | Type of incident location information available. |
| City | city | text | City of the incident location provided by geovalidation. |
| Landmark | landmark | text | If the incident location is identified as a Landmark the name of the landmark will display here |
| Facility Type | facility_type | text | If available, this field describes the type of city facility associated to the SR |
| Status | status | text | Status of SR submitted |
| Due Date | due_date | calendar_date | Date when responding agency is expected to update the SR. This is based on the Complaint Type and internal Service Level Agreements (SLAs). |
| Resolution Description | resolution_description | text | Describes the last action taken on the SR by the responding agency. May describe next or future steps. |
| Resolution Action Updated Date | resolution_action_updated_date | calendar_date | Date when responding agency last updated the SR. |
| Community Board | community_board | text | Provided by geovalidation. |
| BBL | bbl | text | Borough Block and Lot, provided by geovalidation. Parcel number to identify the location of location of buildings and properties in NYC. |
| Borough | borough | text | Provided by the submitter and confirmed by geovalidation. |
| X Coordinate (State Plane) | x_coordinate_state_plane | number | Geo validated, X coordinate of the incident location. |
| Y Coordinate (State Plane) | y_coordinate_state_plane | number | Geo validated, Y coordinate of the incident location. |
| Open Data Channel Type | open_data_channel_type | text | Indicates how the SR was submitted to 311. i.e. By Phone, Online, Mobile, Other or Unknown. |
| Park Facility Name | park_facility_name | text | If the incident location is a Parks Dept facility, the Name of the facility will appear here |
| Park Borough | park_borough | text | The borough of incident if it is a Parks Dept facility |
| Vehicle Type | vehicle_type | text | If the incident is a taxi, this field describes the type of TLC vehicle. |
| Taxi Company Borough | taxi_company_borough | text | If the incident is identified as a taxi, this field will display the borough of the taxi company. |
| Taxi Pick Up Location | taxi_pick_up_location | text | If the incident is identified as a taxi, this field displays the taxi pick up location |
| Bridge Highway Name | bridge_highway_name | text | If the incident is identified as a Bridge/Highway, the name will be displayed here. |
| Bridge Highway Direction | bridge_highway_direction | text | If the incident is identified as a Bridge/Highway, the direction where the issue took place would be displayed here. |
| Road Ramp | road_ramp | text | If the incident location was Bridge/Highway this column differentiates if the issue was on the Road or the Ramp. |
| Bridge Highway Segment | bridge_highway_segment | text | Additional information on the section of the Bridge/Highway were the incident took place. |
| Latitude | latitude | number | Geo based Lat of the incident location |
| Longitude | longitude | number | Geo based Long of the incident location |
| Location | location | location | Combination of the geo based lat & long of the incident location |