From a 500-row sample across 22 columns.
jurisdiction_codeoffense_descriptionlongitude+19jurisdiction_codelongitudelatitude+6jurisdiction_codelongitudelatitude+7Mappable — Socrata point column `geocoded_column`.
Open on the map →| summons_key | summons_date | offense_description | law_section_number | law_description | summons_category_type | age_group | sex | race | jurisdiction_code | boro | precinct_of_occur |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 318168810 | 2025-12-31T00:00:00.000 | SMOKING IN TRAIN STATION | 1050.7 | (null) | (null) | 25-44 | M | BLACK | 1 | BROOKLYN | 78 |
| 318192847 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summons_key | text | Randomly generated persistent ID for each violation | 0% | 1489680831364291426754670 |
summons_date | datetime | Exact date of violation for the reported event | 0% | 2010-07-03T00:00:00.0002009-07-04T00:00:00.0002010-07-04T00:00:00.000 |
offense_description | text | Description of the violation committed | 0% | CONSUMPTION OF ALCOHOLURINATING IN PUBLICFAILURE TO COMPLY WITH S… |
law_section_number | text | NYS Penal Law and local law section number | 1% |
GET /api/datasets/sv2w-rv3k GET /api/datasets/sv2w-rv3k/quality GET /api/datasets/sv2w-rv3k/related GET /api/columns?dataset=sv2w-rv3k
jurisdiction_codelongitudelatitude+7longitudelatitude:@computed_region_yeji_bk3q+4longitudelatitude:@computed_region_yeji_bk3q+4jurisdiction_codelongitudelatitude+5longitudelatitude| 2025-12-31T00:00:00.000 |
| FEDERAL MOTOR VEH. SAFETY REG |
| CFR 49 |
| NYS Transportation |
| NYS TRANS |
| UNKNOWN |
| (null) |
| (null) |
| 0 |
| QUEENS |
| 107 |
| 318208133 | 2025-12-31T00:00:00.000 | OTHER TRANSIT REG | 9999 | ABC | OTHER ABC | 25-44 | M | WHITE HISPANIC | 1 | BRONX | 40 |
| 318169021 | 2025-12-31T00:00:00.000 | OTHER TRANSIT REG | 9999 | ABC | OTHER ABC | (null) | (null) | BLACK | 1 | QUEENS | 110 |
| 318213442 | 2025-12-31T00:00:00.000 | MOTOR VEHICLE; ENGINE ON/KEY IN IGNITION (THERE IS NO TIME REQUIREMENT) | 10-111(A) | (null) | (null) | (null) | (null) | UNKNOWN | 0 | BROOKLYN | 60 |
| 318215607 | 2025-12-31T00:00:00.000 | OTHER TRANSIT REG | 9999 | ABC | OTHER ABC | (null) | (null) | WHITE HISPANIC | 1 | QUEENS | 108 |
| 318213152 | 2025-12-31T00:00:00.000 | CREATES A HAZARDOUS OR PHYSICALLY OFFENSIVE CONDITION WITHOUT A LEGITIMATE PURPO | 240.20(7) | (null) | (null) | (null) | (null) | WHITE | 0 | BRONX | 44 |
| 318196484 | 2025-12-31T00:00:00.000 | POSS. OF KNIFE | 10-133 | Administrative Code | KNIFE | (null) | (null) | BLACK HISPANIC | 0 | NEW YORK | 32 |
| 318207353 | 2025-12-31T00:00:00.000 | DISOBEY TRANSIT SIGN | 1050.6 | (null) | (null) | (null) | (null) | WHITE HISPANIC | 1 | MANHATTAN | 14 |
| 318213137 | 2025-12-31T00:00:00.000 | ALCOHOLIC BEVERAGE IN PUBLIC | 10-125(2B) | (null) | (null) | 18-24 | M | BLACK | 0 | BROOKLYN | 79 |
Showing 12 of 22 columns. All of them are listed below.
10-12599991-03law_description | text | Description of the law dictionary where the cited violation came from. Blank fields represent errors in the database | 2% | Administrative CodePenal LawPark Regs |
summons_category_type | text | General description of the violation category | 2% | ALCOHOLDISORDERLY CONDUCTVTL |
age_group | text | Perpetrator’s age within a category | 1% | 25-4418-2445-64 |
sex | categorical | Perpetrator’s sex code. M(Male), F(Female), U(Unknown or violation issued to a business) | 2% | MFDof 5 |
race | categorical | Perpetrator’s race description. U(Unknown or violation issued to a business) | 7% | UNKNOWNBLACKWHITE HISPANICof 10 |
jurisdiction_code | categorical | Jurisdiction responsible for the issued violation. Jurisdiction codes 0(Patrol), 1(Transit) and 2(Housing) represent NYPD whilst codes 3 or more represent non NYPD jurisdictions | 0% | 021of 3 |
boro | categorical | New York City Boroughs | 10% | BROOKLYNMANHATTANBRONXof 6 |
precinct_of_occur | integer | Precinct where the violation was issued | 0% | 407573 |
x_coordinate_cd | integer | Midblock X-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | 0% | 9940101017141990922 |
y_coordinate_cd | integer | Midblock Y-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | 0% | 224718183798149184 |
latitude | float | Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 0% | 40.78347805500004640.6711069110000440.576157300000034 |
longitude | float | Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 0% | -73.96475834099994-73.88143295699997-73.97598379999994 |
geocoded_column | coordinate | Longitude and Latitude coordinates for mapping | 0% | {'coordinates': [-73.964…{'coordinates': [-73.881…{'coordinates': [-73.975… |