From a 500-row sample across 37 columns.
latitudecitybbl+8latitudebblcouncil_district+3latitudebblcouncil_district+3street_nameMappable — Socrata point column `location`.
Open on the map →| unique_key | created_date | agency | agency_name | complaint_type | descriptor | additional_details | location_type | incident_zip | incident_address | street_name | cross_street_1 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 70753066 | 2026-10-14T23:26:53.000 | NYPD | New York City Police Department | Illegal Parking | Parking Permit Improper Use | Not Provided | Street/Sidewalk | 11385 | 72 STREET | 72 STREET | 72 STREET |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
unique_key | text | Unique identifier of a Service Request (SR) in the open data set | 0% | 455051714550578345506000 |
created_date | datetime | Date SR was created | 0% | 2023-05-27T10:45:06.0002025-01-11T10:15:37.0002020-06-24T08:00:45.000 |
closed_date | datetime | Date SR was closed by responding agency | 0% | 2026-08-27T13:39:13.0002026-08-07T20:14:51.0002026-08-20T00:12:54.000 |
agency | text | Acronym of responding City Government Agency | 0% |
GET /api/datasets/cwy2-px8b GET /api/datasets/cwy2-px8b/quality GET /api/datasets/cwy2-px8b/related GET /api/columns?dataset=cwy2-px8b
street_namelatitudecitybbl+3| 70762296 | 2026-10-14T22:33:51.000 | NYPD | New York City Police Department | Illegal Parking | Parking Permit Improper Use | Parked In Front Of Fire Hydrant | Street/Sidewalk | 10017 | 25 TUDOR CITY PLACE | TUDOR CITY PLACE | EAST 41 STREET |
| 70750833 | 2026-10-14T22:14:24.000 | NYPD | New York City Police Department | Illegal Parking | Parking Permit Improper Use | Double Parked | Street/Sidewalk | 11236 | 969 EAST 84 STREET | EAST 84 STREET | FLATLANDS AVENUE |
| 70759908 | 2026-10-14T21:58:44.000 | NYPD | New York City Police Department | Illegal Parking | Parking Permit Improper Use | Blocking Driveway | Street/Sidewalk | 11228 | 819 70 STREET | 70 STREET | 8 AVENUE |
| 70751615 | 2026-10-14T21:54:00.000 | NYPD | New York City Police Department | Illegal Parking | Parking Permit Improper Use | Blocking Driveway | Street/Sidewalk | 11367 | 61-29 156 STREET | 156 STREET | HORACE HARDING EXPRESSWAY |
| 70752226 | 2026-10-14T21:47:58.000 | NYPD | New York City Police Department | Illegal Parking | Parking Permit Improper Use | Parked On Sidewalk | Street/Sidewalk | 10469 | 3020 YOUNG AVENUE | YOUNG AVENUE | ADEE AVENUE |
| 70753065 | 2026-10-14T21:31:29.000 | NYPD | New York City Police Department | Illegal Parking | Parking Permit Improper Use | Parked In Front Of Fire Hydrant | Street/Sidewalk | 11385 | 77-44 79 PLACE | 79 PLACE | 77 AVENUE |
| 70758557 | 2026-10-14T21:09:09.000 | NYPD | New York City Police Department | Illegal Parking | Parking Permit Improper Use | Blocking Driveway | Street/Sidewalk | 11217 | 556 SACKETT STREET | SACKETT STREET | NEVINS STREET |
| 70751559 | 2026-10-14T21:07:44.000 | NYPD | New York City Police Department | Illegal Parking | Parking Permit Improper Use | Blocking Driveway | Street/Sidewalk | 11421 | 80-19 89 AVENUE | 89 AVENUE | 80 STREET |
| 70761335 | 2026-10-14T21:06:22.000 | NYPD | New York City Police Department | Illegal Parking | Parking Permit Improper Use | Parked On Sidewalk | Street/Sidewalk | 11223 | 2374 WEST 11 STREET | WEST 11 STREET | AVENUE W |
Showing 12 of 37 columns. All of them are listed below.
NYPDagency_name | text | Full Agency name of responding City Government Agency | 0% | New York City Police Dep…of 1 |
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. | 0% | Illegal Parkingof 1 |
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. Descriptor may have a corresponding Additional Details (below) or may stand alone. | 0% | Parking Permit Improper …of 1 |
additional_details | categorical | This is associated to the Descriptor, and provides further detail on the incident or condition. Additional Details values are dependent on the Descriptor, and are not always required in SR. | 0% | Parked On SidewalkParked In 'No Standing' …Parked In Front Of Fire …of 11 |
location_type | text | Describes the type of location used in the address information | 1% | Street/Sidewalkof 1 |
incident_zip | text | Incident location zip code, provided by geo validation | 0% | 112171110111201 |
incident_address | text | House number of incident address provided by submitter | 0% | 100 MESEROLE AVENUE71-01 PARSONS BOULEVARD5-47 50 AVENUE |
street_name | text | Street name of incident address provided by the submitter | 0% | MESEROLE AVENUEPARSONS BOULEVARD50 AVENUE |
cross_street_1 | text | First cross street based on the geo validated incident location | 0% | LORIMER STREET6 AVENUE71 AVENUE |
cross_street_2 | text | Second cross street based on the geo validated incident location | 0% | MANHATTAN AVENUE72 AVENUECARLTON AVENUE |
intersection_street_1 | text | First intersecting street based on geo validated incident location | 0% | LORIMER STREET6 AVENUE71 AVENUE |
intersection_street_2 | text | Second intersecting street based on geo validated incident location | 0% | MANHATTAN AVENUE72 AVENUECARLTON AVENUE |
address_type | categorical | Type of incident location information available | 12% | ADDRESSINTERSECTIONBLOCKFACEof 5 |
city | text | City of the incident location provided by geo validation | 5% | BROOKLYNNEW YORKBRONX |
landmark | text | If the incident location is identified as a Landmark the name of the landmark will display here | 5% | MESEROLE AVENUEPARSONS BOULEVARD50 AVENUE |
status | categorical | Status of SR submitted | 0% | ClosedIn ProgressUnspecifiedof 3 |
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) | 100% | — |
resolution_description | text | Describes the last action taken on the SR by the responding agency. May describe next or future steps | 0% | The Police Department re…The Police Department re…The Police Department re… |
resolution_action_updated | datetime | Date when responding agency last updated the SR | 0% | 2023-01-02T23:18:28.0002022-05-05T09:46:59.0002022-05-04T09:29:05.000 |
community_board | text | Provided by geo validation | 0% | 02 BROOKLYN01 BROOKLYN02 QUEENS |
council_district | text | Provided by geo validation | 0% | 333526 |
bbl | text | Borough Block and Lot, provided by geo validation. Parcel number to identify the location of location of buildings and properties in NYC | 10% | 302619000140679700404000320006 |
borough | categorical | Provided by the submitter and confirmed by geo validation | 0% | BROOKLYNQUEENSMANHATTANof 6 |
x_coordinate_state_plane | integer | Geo validated, X coordinate of the incident location | 0% | 9972829964241036658 |
y_coordinate_state_plane | integer | Geo validated, Y coordinate of the incident location | 0% | 204143210017205328 |
open_data_channel_type | categorical | Indicates how the SR was submitted to 311, i.e. By Phone, Online, Mobile, Other or Unknown | 0% | MOBILEONLINEPHONEof 4 |
latitude | float | Geo based lat of the incident location | 0% | 40.726698840.72669940.7430719 |
longitude | float | Geo based long of the incident location | 0% | -73.954735-73.9531803-73.95318 |
location | coordinate | Combination of the geo based lat & long of the incident location | 0% | {'coordinates': [-73.953…{'coordinates': [-73.953…{'coordinates': [-73.954… |