From a 500-row sample across 29 columns.
street_code3issuer_commandviolation_location+39street_code3issuer_commandviolation_location+40Has street addresses (`house_number, street_name`) — needs geocoding before it can be drawn.
| summons_number | plate_id | registration_state | plate_type | issue_date | violation_code | vehicle_body_type | vehicle_make | issuing_agency | street_code1 | street_code2 | street_code3 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 4966660087 | KET9602 | NY | PAS | 2025-09-29T00:00:00.000 | 36 | PICK | RAM | V | 0 | 0 | 0 |
| 4966660099 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summons_number | integer | — | 0% | 105567528010556753221055675334 |
plate_id | text | — | 0% | BLANKPLATEBLANK80771ND |
registration_state | text | — | 0% | NYNJPA |
plate_type | text | — | 0% | PASCOMOMT |
issue_date | datetime | — |
GET /api/datasets/9mwx-gamw GET /api/datasets/9mwx-gamw/quality GET /api/datasets/9mwx-gamw/related GET /api/columns?dataset=9mwx-gamw
street_code3issuer_commandviolation_location+40street_code3issuer_commandviolation_location+40street_code3issuer_commandviolation_location+40street_code3issuer_commandviolation_location+40street_code3issuer_commandviolation_location+38street_code3issuer_commandviolation_location+38| GDH4206 |
| NY |
| PAS |
| 2025-09-29T00:00:00.000 |
| 36 |
| SUBN |
| NISSA |
| V |
| 0 |
| 0 |
| 0 |
| 4966660105 | KLU1841 | NY | ORG | 2025-09-29T00:00:00.000 | 36 | 4DSD | ME/BE | V | 0 | 0 | 0 |
| 4966660117 | KTX7880 | NY | PAS | 2025-09-29T00:00:00.000 | 36 | SUBN | MAZDA | V | 0 | 0 | 0 |
| 4966660129 | LTE8413 | NY | PAS | 2025-09-29T00:00:00.000 | 36 | VAN | FORD | V | 0 | 0 | 0 |
| 4966660130 | KXZ2247 | NY | PAS | 2025-09-29T00:00:00.000 | 36 | SUBN | HONDA | V | 0 | 0 | 0 |
| 4966660142 | JHA4911 | NY | PAS | 2025-09-29T00:00:00.000 | 36 | 4DSD | AUDI | V | 0 | 0 | 0 |
| 4966660154 | C53MTG | NJ | PAS | 2025-09-29T00:00:00.000 | 36 | UT | ME/BE | V | 0 | 0 | 0 |
| 4966660166 | JCJ7739 | NY | PAS | 2025-09-29T00:00:00.000 | 36 | 4DSD | FORD | V | 0 | 0 | 0 |
| 4966660178 | MYD2177 | PA | PAS | 2025-09-29T00:00:00.000 | 36 | SDN | CHEVR | V | 0 | 0 | 0 |
Showing 12 of 29 columns. All of them are listed below.
| 0% |
2026-06-04T00:00:00.0002026-03-24T00:00:00.0002026-03-31T00:00:00.000 |
violation_code | integer | — | 0% | 362138 |
vehicle_body_type | text | — | 0% | SUBN4DSDVAN |
vehicle_make | text | — | 0% | TOYOTHONDAFORD |
issuing_agency | text | — | 0% | TVM |
street_code1 | integer | — | 0% | 01361010210 |
street_code2 | integer | — | 0% | 04040410410 |
street_code3 | integer | — | 0% | 04040410510 |
vehicle_expiration_date | integer | — | 0% | 08888888820258888 |
violation_location | text | — | 43% | 191413 |
violation_precinct | integer | — | 0% | 01914 |
issuer_precinct | integer | — | 0% | 01914 |
issuer_code | integer | — | 0% | 0371705355542 |
issuer_command | text | — | 43% | T103T302T102 |
issuer_squad | text | — | 46% | AMH |
violation_time | text | — | 0% | 0906A0908A0840A |
time_first_observed | text | — | 94% | 000001100A1000A |
violation_county | categorical | — | 3% | NYQNKof 19 |
violation_in_front_of_or | categorical | — | 43% | FOIof 8 |
house_number | text | — | 44% | NSE |
street_name | text | — | 0% | Broadway3rd Ave5th Ave |
intersecting_street | text | — | 49% | STTH STAVE |
date_first_observed | integer | — | 0% | 02026040920260325 |
law_section | categorical | — | 0% | 40811801111of 10 |
sub_division | text | — | 0% | BH1C |
violation_legal_code | categorical | — | 57% | T04of 3 |
days_parking_in_effect | text | — | 44% | YYYYYYYYYYYYYYYYYY |
from_hours_in_effect | text | — | 67% | 0800A0700A0900A |
to_hours_in_effect | text | — | 67% | 0700P0600P0100P |
vehicle_color | text | — | 10% | WHGYBK |
unregistered_vehicle | text | — | 98% | 0of 1 |
vehicle_year | integer | — | 0% | 020242025 |
meter_number | text | — | 86% | -469232109735 |
feet_from_curb | integer | — | 0% | 053 |
violation_post_code | text | — | 49% | 990109 |
violation_description | text | — | 2% | PHTO SCHOOL ZN SPEED VIO…21-No Parking (street cl…38-Failure to Dsplay Met… |
no_standing_or_stopping | text | — | 100% | — |
hydrant_violation | text | — | 100% | — |
double_parking_violation | text | — | 45% | 20of 1 |
fiscal_year | integer | — | 0% | 2026of 1 |