From a 500-row sample across 40 columns.
street_nameissuer_precinctfeet_from_curb+40street_nameissuer_precinctfeet_from_curb+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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 9139716661 | LKS7820 | NY | PAS | 2024-07-02T00:00:00.000 | 38 | SUBN | TOYOT | T | 26790 | 28590 | 12810 |
| 4903865265 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summons_number | numeric | — | — | — |
plate_id | text | — | 0% | BLANKPLATE80771ND18389BR |
registration_state | text | — | 0% | NYNJPA |
plate_type | text | — | 0% | PASCOMOMT |
issue_date | datetime | — | 0% | 2024-11-29T00:00:00.000 |
GET /api/datasets/m5vz-tzqv GET /api/datasets/m5vz-tzqv/quality GET /api/datasets/m5vz-tzqv/related GET /api/columns?dataset=m5vz-tzqv
street_nameissuer_precinctfeet_from_curb+38street_nameissuer_precinctfeet_from_curb+40street_nameissuer_precinctfeet_from_curb+40street_nameissuer_precinctfeet_from_curb+38street_nameissuer_precinctfeet_from_curb+40street_nameissuer_precinctfeet_from_curb+38| Y23UMS |
| NJ |
| PAS |
| 2024-06-21T00:00:00.000 |
| 36 |
| VAN |
| ME/BE |
| V |
| 0 |
| 40404 |
| 40404 |
| 9140510268 | N76NJN | NJ | PAS | 2024-07-08T00:00:00.000 | 14 | SUBN | HYUND | T | 24890 | 17910 | 17930 |
| 9136561575 | 42UD91 | NY | MCL | 2024-07-12T00:00:00.000 | 71 | MCY | HONDA | T | 47030 | 58730 | 85730 |
| 9139621832 | 76925NE | NY | COM | 2024-07-11T00:00:00.000 | 14 | VAN | ISUZU | T | 51090 | 64790 | 23070 |
| 1493975122 | JRV5673 | NY | PAS | 2024-07-14T00:00:00.000 | 20 | SDN | SUBAR | P | 0 | 40404 | 40404 |
| 4906336322 | AM37769 | AZ | PAS | 2024-07-05T00:00:00.000 | 36 | Carg | Ram | V | 0 | 0 | 0 |
| 5604629856 | 1AK8791 | MS | PAS | 2024-07-11T00:00:00.000 | 12 | PK | FORD | V | 0 | 0 | 0 |
| 4909404478 | LLE1741 | NY | PAS | 2024-07-26T00:00:00.000 | 36 | SUBN | JEEP | V | 0 | 0 | 0 |
| 4909200216 | DXR7198 | NY | PAS | 2024-07-25T00:00:00.000 | 36 | SUBN | JEEP | V | 0 | 0 | 0 |
Showing 12 of 39 columns. All of them are listed below.
2024-10-01T00:00:00.0002024-09-12T00:00:00.000violation_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% | 08888888820248888 |
violation_location | text | — | 47% | 191413 |
violation_precinct | integer | — | 0% | 01914 |
issuer_precinct | integer | — | 0% | 01914 |
issuer_code | integer | — | 0% | 0355542371705 |
issuer_command | text | — | 47% | T103T302T201 |
issuer_squad | text | — | 50% | AMH |
violation_time | text | — | 0% | 0836A0906A0840A |
time_first_observed | text | — | 94% | 000001100A1000A |
violation_county | text | — | 3% | NYQNBK |
violation_in_front_of_or | categorical | — | 47% | FOIof 6 |
house_number | text | — | 47% | NSE |
street_name | text | — | 0% | Broadway3rd AveWB N CONDUIT AVE @ 8 |
intersecting_street | text | — | 46% | STESt |
date_first_observed | integer | — | 0% | 02024111320240815 |
law_section | categorical | — | 0% | 40811801111of 8 |
sub_division | text | — | 0% | BH1C |
violation_legal_code | categorical | — | 53% | T06of 3 |
days_parking_in_effect | text | — | 47% | YYYYYYYYYYYYYYYYYY |
from_hours_in_effect | text | — | 69% | 0800A0700A0900A |
to_hours_in_effect | text | — | 69% | 0700P0600P0100P |
vehicle_color | text | — | 10% | GYWHBK |
unregistered_vehicle | text | — | 98% | 0of 1 |
vehicle_year | integer | — | 0% | 020232024 |
meter_number | text | — | — | — |
feet_from_curb | categorical | — | 0% | 053of 17 |
violation_post_code | text | — | 65% | 9916 |
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 | — | 100% | — |