From a 500-row sample across 22 columns.
jurisdiction_codesummons_category_type:@computed_region_f5dn_yrer+19jurisdiction_code:@computed_region_f5dn_yrer:@computed_region_sbqj_enih+7jurisdiction_code:@computed_region_f5dn_yrer:@computed_region_sbqj_enih+6Mappable — 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 318283441 | 2026-01-02T00:00:00.000 | SMOKING IN TRAIN STATION | 1050.7 | (null) | (null) | 45-64 | M | BLACK | 1 | MANHATTAN | 014 |
| 318516896 |
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% | 321683803321978250319090066 |
summons_date | datetime | Exact date of violation for the reported event | 0% | 2026-02-04T00:00:00.0002026-01-14T00:00:00.0002026-01-08T00:00:00.000 |
offense_description | text | Description of the violation committed | 0% | FEDERAL MOTOR VEH. SAFET…RECKLESS DRIVINGRED LIGHT (DISOBEY) |
law_section_number | text | NYS Penal Law and local law section number | 0% |
GET /api/datasets/mv4k-y93f GET /api/datasets/mv4k-y93f/quality GET /api/datasets/mv4k-y93f/related GET /api/columns?dataset=mv4k-y93f
jurisdiction_code:@computed_region_f5dn_yrer:@computed_region_sbqj_enih+7:@computed_region_f5dn_yrer:@computed_region_sbqj_enih:@computed_region_efsh_h5xi+4:@computed_region_f5dn_yrer:@computed_region_sbqj_enih:@computed_region_efsh_h5xi+4:@computed_region_f5dn_yrer:@computed_region_sbqj_enih:@computed_region_yeji_bk3q+6:@computed_region_f5dn_yrer:@computed_region_sbqj_enih:@computed_region_efsh_h5xi+4| 2026-01-07T00:00:00.000 |
| STOP SIGN |
| 1172 |
| VTL |
| VTL |
| 25-44 |
| M |
| OTHER |
| 0 |
| BROOKLYN |
| 081 |
| 318242408 | 2026-01-01T00:00:00.000 | UNLICENSED OPERATOR | 509 | VTL | VTL | 25-44 | M | BLACK | 0 | MANHATTAN | 013 |
| 318321090 | 2026-01-04T00:00:00.000 | PERMIT UNLICENSED | 19-506(B) | (null) | (null) | 25-44 | M | BLACK | 0 | QUEENS | 113 |
| 323761212 | 2026-04-20T00:00:00.000 | MOTOR VEHICLE; ENGINE ON/KEY IN IGNITION (THERE IS NO TIME REQUIREMENT) | 10-111(A) | (null) | (null) | 25-44 | M | BLACK HISPANIC | 0 | NEW YORK | 028 |
| 323493839 | 2026-04-15T00:00:00.000 | FEDERAL MOTOR VEH. SAFETY REG | CFR 49 | NYS Transportation | NYS TRANS | UNKNOWN | (null) | (null) | 0 | BRONX | 045 |
| 324599697 | 2026-05-06T00:00:00.000 | Enter w/o payment 1st offense | CRR1050.4A1 | (null) | (null) | 45-64 | M | WHITE HISPANIC | 1 | MANHATTAN | 013 |
| 325868772 | 2026-05-30T00:00:00.000 | ALCOHOLIC BEVERAGE IN PUBLIC | 10-125(2B) | (null) | (null) | 18-24 | M | WHITE | 0 | BROOKLYN | 060 |
| 323761616 | 2026-04-21T00:00:00.000 | CONSUMPTION OF ALCOHOL IN VEHICLE | 1227 | VTL | VTL | 18-24 | M | BLACK | 0 | BROOKLYN | 069 |
| 323773818 | 2026-04-12T00:00:00.000 | Obstruction seating/facility | CRR1050.7J | (null) | (null) | 45-64 | M | WHITE HISPANIC | 1 | BROOKLYN | 078 |
Showing 12 of 22 columns. All of them are listed below.
CFR 4999991212law_description | categorical | Description of the law dictionary where the cited violation came from. Blank fields represent errors in the database | 0% | (null)VTLAdministrative Codeof 15 |
summons_category_type | text | General description of the violation category | 0% | (null)VTLNYS TRANS |
age_group | categorical | Perpetrator’s age within a category | 0% | 25-4445-6418-24of 6 |
sex | categorical | Perpetrator’s sex code. M(Male), F(Female), U(Unknown or violation issued to a business) | 0% | M(null)Fof 4 |
race | categorical | Perpetrator’s race description. U(Unknown or violation issued to a business) | 0% | BLACKWHITE HISPANICBLACK HISPANICof 9 |
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% | 012of 3 |
boro | categorical | New York City Boroughs | 0% | BROOKLYNBRONXMANHATTANof 6 |
precinct_of_occur | text | Precinct where the violation was issued | 0% | 018014075 |
x_coordinate_cd | integer | Latitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 0% | 99044410143431042167 |
y_coordinate_cd | integer | Longitude coordinate for Global Coordinate System, WGS 1984, decimal degrees (EPSG 4326) | 0% | 188607211311226584 |
latitude | float | Midblock X-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | 0% | 40.6843673640.7466346640.78840706 |
longitude | float | Midblock Y-coordinate for New York State Plane Coordinate System, Long Island Zone, NAD 83, units feet (FIPS 3104) | 0% | -73.97766721-73.89139413-73.79084756 |
geocoded_column | coordinate | — | 0% | {'coordinates': [-73.977…{'coordinates': [-73.891…{'coordinates': [-73.790… |