From a 500-row sample across 45 columns.
incident_ziplocation_typevehicle_type+45incident_ziplocation_typevehicle_type+37Mappable — Socrata point column `location`.
Open on the map →| unique_key | created_date | agency | agency_name | complaint_type | descriptor | incident_zip | incident_address | street_name | cross_street_1 | cross_street_2 | address_type |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 70745840 | 2026-10-14T01:54:42.000 | DOT | Department of Transportation | Street Condition | Pothole | 11415 | PARK LANE | PARK LANE | 80 ROAD | PARK LANE SOUTH | BLOCKFACE |
The machine field names SoQL needs, with the publisher's own description of each. Profiling runs nightly; null rates and sample values appear once it has.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
unique_key | text | Unique identifier of a Service Request (SR) in the open data set | — | — |
created_date | datetime | Date SR was created | — | — |
closed_date | datetime | Date SR was closed by responding agency | — | — |
agency | text | Acronym of responding City Government Agency | — | NYPDHPDDSNYof 21 |
agency_name | text | Full Agency name of responding City Government Agency | — | — |
complaint_type |
GET /api/datasets/erm2-nwe9 GET /api/datasets/erm2-nwe9/quality GET /api/datasets/erm2-nwe9/related GET /api/columns?dataset=erm2-nwe9
incident_ziplocation_typevehicle_type+37incident_ziplocation_typevehicle_type+37incident_ziplocation_typevehicle_type+37incident_ziplocation_typevehicle_type+37incident_ziplocation_typevehicle_type+37:@computed_region_yeji_bk3q:@computed_region_sbqj_enih:@computed_region_f5dn_yrer+8| 70748884 |
| 2026-10-14T01:53:51.000 |
| DOT |
| Department of Transportation |
| Street Condition |
| Pothole |
| 11375 |
| QUEENS BOULEVARD |
| QUEENS BOULEVARD |
| GREG STEIN WAY |
| 78 AVENUE |
| BLOCKFACE |
| 70741197 | 2026-10-14T01:53:03.000 | DOT | Department of Transportation | Street Condition | Pothole | 11434 | ROCKAWAY BOULEVARD | ROCKAWAY BOULEVARD | 144 AVENUE | 157 STREET | BLOCKFACE |
| 70745734 | 2026-10-14T01:51:26.000 | DSNY | Department of Sanitation | Litter Basket Request | Replacement Basket | — | — | — | — | — | — |
| 70747554 | 2026-10-14T01:49:27.000 | DEP | Department of Environmental Protection | Noise | Air Conditioner/Ventilation | 10025 | 953 AMSTERDAM AVENUE | AMSTERDAM AVENUE | WEST 106 STREET | WEST 107 STREET | ADDRESS |
| 70739944 | 2026-10-14T01:49:14.000 | NYPD | New York City Police Department | Noise - Residential | Loud Music/Party | 10468 | 2685 CRESTON AVENUE | CRESTON AVENUE | EAST KINGSBRIDGE ROAD | EAST 196 STREET | ADDRESS |
| 70739470 | 2026-10-14T01:48:59.000 | NYPD | New York City Police Department | Noise - Street/Sidewalk | Loud Music/Party | 10032 | AMSTERDAM AVENUE | AMSTERDAM AVENUE | AMSTERDAM AVENUE | WEST 159 STREET | INTERSECTION |
| 70743073 | 2026-10-14T01:48:52.000 | NYPD | New York City Police Department | Noise - Residential | Loud Music/Party | 11234 | TROY AVENUE | TROY AVENUE | TROY AVENUE | AVENUE I | INTERSECTION |
| 70747176 | 2026-10-14T01:48:20.000 | NYPD | New York City Police Department | Noise - Park | Loud Music/Party | 10034 | 4901 BROADWAY | BROADWAY | WEST 204 STREET | WEST 207 STREET | ADDRESS |
| 70743894 | 2026-10-14T01:47:55.000 | NYPD | New York City Police Department | Illegal Parking | Blocked Hydrant | 11435 | LIVERPOOL STREET | LIVERPOOL STREET | LIVERPOOL STREET | LAKEWOOD AVENUE | INTERSECTION |
Showing 12 of 40 columns. All of them are listed below.
| text |
| This is the first level of a hierarchy identifying the topic of the incident or condition. Problem (formerly Complaint Type) broadly describes the topic of the incident or condition and are defined by the responding agencies. New Problems may be added in response to changes in customer demand. |
| — |
| — |
descriptor | text | This is associated to the Problem (formerly Complaint Type), and provides further detail on the incident or condition. Problem Detail (formerly Descriptor) values are dependent on the Problem, and are not always required in the service request. | — | — |
descriptor_2 | text | A third level of detail about the Problem (formerly Complaint Type) beyond the Problem Detail (formerly Descriptor). This is not used by every category of issue. | — | — |
location_type | text | Describes the type of location used in the address information | — | Street/SidewalkRESIDENTIAL BUILDINGResidential Building/Hou… |
incident_zip | text | Incident location zip code, provided by geo validation. | — | — |
incident_address | text | House number of incident address provided by submitter. | — | — |
street_name | text | Street name of incident address provided by the submitter | — | — |
cross_street_1 | text | First Cross street based on the geo validated incident location | — | — |
cross_street_2 | text | Second Cross Street based on the geo validated incident location | — | — |
intersection_street_1 | text | First intersecting street based on geo validated incident location | — | — |
intersection_street_2 | text | Second intersecting street based on geo validated incident location | — | — |
address_type | text | Type of incident location information available. | — | — |
city | text | City of the incident location provided by geovalidation. | — | — |
landmark | text | If the incident location is identified as a Landmark the name of the landmark will display here | — | — |
facility_type | text | If available, this field describes the type of city facility associated to the SR | — | N/ADSNY Garageof 2 |
status | text | Status of SR submitted | — | ClosedIn ProgressOpenof 8 |
due_date | datetime | 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 | text | Describes the last action taken on the SR by the responding agency. May describe next or future steps. | — | — |
resolution_action_updated_date | datetime | Date when responding agency last updated the SR. | — | — |
community_board | text | Provided by geovalidation. | — | — |
council_district | text | The City Council district where the service request is located. | — | — |
police_precinct | text | The NYPD precinct where the service request is located. | — | — |
bbl | text | Borough Block and Lot, provided by geovalidation. Parcel number to identify the location of location of buildings and properties in NYC. | — | — |
borough | text | Provided by the submitter and confirmed by geovalidation. | — | — |
x_coordinate_state_plane | numeric | Geo validated, X coordinate of the incident location. | — | — |
y_coordinate_state_plane | numeric | Geo validated, Y coordinate of the incident location. | — | — |
open_data_channel_type | text | Indicates how the SR was submitted to 311. i.e. By Phone, Online, Mobile, Other or Unknown. | — | ONLINEPHONEMOBILEof 5 |
park_facility_name | text | If the incident location is a Parks Dept facility, the Name of the facility will appear here | — | — |
park_borough | text | The borough of incident if it is a Parks Dept facility | — | — |
vehicle_type | text | If the incident is a taxi, this field describes the type of TLC vehicle. | — | — |
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 | text | If the incident is identified as a taxi, this field displays the taxi pick up location | — | — |
bridge_highway_name | text | If the incident is identified as a Bridge/Highway, the name will be displayed here. | — | — |
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 | text | If the incident location was Bridge/Highway this column differentiates if the issue was on the Road or the Ramp. | — | — |
bridge_highway_segment | text | Additional information on the section of the Bridge/Highway were the incident took place. | — | — |
latitude | numeric | Geo based Lat of the incident location | — | — |
longitude | numeric | Geo based Long of the incident location | — | — |
location | coordinate | Combination of the geo based lat & long of the incident location | — | — |