From a 500-row sample across 38 columns.
plate_idstreet_code2issuer_precinct+40plate_idstreet_code2issuer_precinct+40Has street addresses (`street_name, house_number`) — 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1055675255 | DVA1093 | NY | PAS | 2026-06-13T00:00:00.000 | 17 | SUBN | BUICK | P | 31190 | 36670 | 36690 |
| 1076851186 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summons_number | integer | — | 0% | 515104103449952947039294753311 |
plate_id | text | — | 0% | BLANKPLATEBLANK80771ND |
registration_state | text | — | 0% | NYNJPA |
plate_type | text | — | 0% | PASCOMOMT |
issue_date | datetime | — |
GET /api/datasets/pvqr-7yc4 GET /api/datasets/pvqr-7yc4/quality GET /api/datasets/pvqr-7yc4/related GET /api/columns?dataset=pvqr-7yc4
plate_idstreet_code2issuer_precinct+40plate_idstreet_code2issuer_precinct+40plate_idstreet_code2issuer_precinct+38plate_idstreet_code2issuer_precinct+38plate_idstreet_code2issuer_precinct+40plate_idstreet_code2issuer_precinct+38| KYA2145 |
| 99 |
| PAS |
| 2025-08-06T00:00:00.000 |
| 14 |
| SDN |
| — |
| F |
| 0 |
| 0 |
| 0 |
| 1135102170 | LRM3618 | NY | PAS | 2026-06-20T00:00:00.000 | 40 | VAN | ME/BE | P | 53970 | 11930 | 86430 |
| 1154362073 | MCT2559 | NY | OMT | 2026-06-27T00:00:00.000 | 41 | SDN | INFIN | P | 0 | 40404 | 40404 |
| 1154362103 | JEY6252 | NY | OMT | 2026-06-27T00:00:00.000 | 98 | SDN | TOYOT | P | 0 | 40404 | 40404 |
| 1154851977 | 515ZNP | AR | PAS | 2026-06-21T00:00:00.000 | 37 | SDN | FORD | P | 42820 | 26490 | 26490 |
| 1154852003 | 441AMU | NY | PAS | 2026-06-21T00:00:00.000 | 20 | P/U | TESLA | P | 42820 | 26490 | 26490 |
| 1154852015 | D65VSF | NJ | PAS | 2026-06-21T00:00:00.000 | 37 | SDN | NISSA | P | 42820 | 26490 | 26490 |
| 1154852027 | KPT3679 | PA | PAS | 2026-07-04T00:00:00.000 | 14 | SDN | KIA | P | 26490 | 98260 | 61490 |
| 1154852039 | CJZ8825 | NY | PAS | 2026-07-04T00:00:00.000 | 14 | SDN | HONDA | P | 26490 | 98260 | 61490 |
Showing 12 of 37 columns. All of them are listed below.
| 0% |
2026-07-16T00:00:00.0002026-07-14T00:00:00.0002026-07-07T00:00:00.000 |
violation_code | integer | — | 0% | 36217 |
vehicle_body_type | text | — | 0% | SUBN4DSDVAN |
vehicle_make | text | — | 0% | TOYOTHONDAFORD |
issuing_agency | text | A-PORT AUTHORITY, B-TRIBOROUGH BRIDGE AND TUNNEL POLICE, C-CON RAIL, D-DEPARTMENT OF BUSINESS SERVICES, E-BOARD OF ESTIMATE, F-FIRE DEPARTMENT, G-TAXI AND LIMOUSINE COMMISSION, H-HOUSING AUTHORITY, I-STATEN ISLAND RAPID TRANSIT POLICE, J-AMTRAK RAILROAD POLICE, K-PARKS DEPARTMENT, L-LONG ISLAND RAILROAD, M-TRANSIT AUTHORITY, N-NYS PARKS POLICE, O-NYS COURT OFFICERS, P-POLICE DEPARTMENT, Q-DEPARTMENT OF CORRECTION, R-NYC TRANSIT AUTHORITY MANAGERS, S-DEPARTMENT OF SANITATION, T-TRAFFIC, U-PARKING | 0% | TVM |
street_code1 | integer | — | 0% | 01361010210 |
street_code2 | integer | — | 0% | 04040410410 |
street_code3 | integer | — | 0% | 04040410510 |
vehicle_expiration_date | text | — | 0% | 08888888820268888 |
violation_location | text | — | 47% | 191413 |
violation_precinct | integer | — | 0% | 01914 |
issuer_precinct | integer | — | 0% | 01914 |
issuer_code | integer | — | 0% | 0363998355542 |
issuer_command | text | — | 47% | T103T302T102 |
issuer_squad | text | — | 52% | ADE |
violation_time | text | — | 0% | 0839A0841A0840A |
time_first_observed | text | — | 93% | 000001100A1000A |
violation_county | categorical | — | 3% | NYQNBKof 13 |
violation_in_front_of_or_opposite | categorical | — | 47% | FOIof 5 |
house_number | text | — | 48% | NSW |
street_name | text | — | 0% | Broadway3rd AveWB N. CONDUIT AVE @ |
intersecting_street | text | — | 46% | STTH STAVE |
date_first_observed | integer | — | 0% | 02026072320260722 |
law_section | categorical | — | 0% | 40811801111of 7 |
sub_division | text | — | 0% | BDH1 |
violation_legal_code | text | — | 53% | Tof 1 |
days_parking_in_effect | text | — | 48% | YYYYYYYYYYYYYY Y |
from_hours_in_effect | text | — | 67% | 0800A0700A0900A |
to_hours_in_effect | text | — | 67% | 0700P0600P0100P |
vehicle_color | text | — | 11% | WHGYBK |
unregistered_vehicle | text | — | 98% | 0of 1 |
vehicle_year | integer | — | 0% | 020252024 |
meter_number | text | — | 88% | -469232434252 |
feet_from_curb | categorical | — | 0% | 053of 18 |
violation_post_code | text | — | 54% | 990109 |
violation_description | text | — | 2% | PHTO SCHOOL ZN SPEED VIO…21-No Parking (street cl…FAILURE TO STOP AT RED L… |
no_standing_or_stopping_violation | text | — | 100% | — |
hydrant_violation | text | — | 100% | — |
double_parking_violation | text | — | 100% | — |
fiscal_year | integer | — | 0% | 2027of 1 |