From a 500-row sample across 40 columns.
vehicle_yearplate_idstreet_code1+40vehicle_yearplate_idstreet_code1+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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 9058484970 | KPX6651 | NY | PAS | 2023-07-17T00:00:00.000 | 71 | 4DSD | TOYOT | T | 14690 | 14840 | 8630 |
| 9002272637 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summons_number | integer | — | 0% | 403198271990792055159081036233 |
plate_id | text | — | 0% | BLANKPLATE96091MA54239MN |
registration_state | text | — | 0% | NYNJPA |
plate_type | text | — | 0% | PASCOMOMT |
issue_date | datetime | — |
GET /api/datasets/8zf9-spf8 GET /api/datasets/8zf9-spf8/quality GET /api/datasets/8zf9-spf8/related GET /api/columns?dataset=8zf9-spf8
vehicle_yearplate_idstreet_code1+40vehicle_yearplate_idstreet_code1+40vehicle_yearplate_idstreet_code1+40vehicle_yearplate_idstreet_code1+40vehicle_yearplate_idstreet_code1+38vehicle_yearplate_idstreet_code1+38| KYF6667 |
| NY |
| PAS |
| 2023-07-15T00:00:00.000 |
| 71 |
| SUBN |
| VOLKS |
| T |
| 60535 |
| 0 |
| 0 |
| 9065683781 | KYY3128 | NY | PAS | 2023-07-23T00:00:00.000 | 40 | PICK | CHEVR | T | 18530 | 10010 | 45590 |
| 1491974643 | KMK9140 | NY | PAS | 2023-06-30T00:00:00.000 | 98 | SUBN | CHEVR | P | 23520 | 54420 | 74720 |
| 4852339752 | MYGLOK26 | NY | SRF | 2023-07-16T00:00:00.000 | 36 | SUBN | BMW | V | 0 | 0 | 0 |
| 4852333877 | LAK7088 | NY | PAS | 2023-07-16T00:00:00.000 | 36 | 4DSD | TOYOT | V | 0 | 0 | 0 |
| 9064964178 | LCP8944 | NY | PAS | 2023-07-19T00:00:00.000 | 74 | 4DSD | HYUND | T | 58590 | 42850 | 51590 |
| 4848396797 | KYV5923 | NY | PAS | 2023-06-24T00:00:00.000 | 36 | 4DSD | ME/BE | V | 0 | 0 | 0 |
| 4849319828 | J95RZF | NJ | PAS | 2023-06-30T00:00:00.000 | 36 | SPOR | KIA | V | 0 | 0 | 0 |
| 4852872272 | KJL7113 | NY | PAS | 2023-07-19T00:00:00.000 | 36 | SUBN | NISSA | V | 0 | 0 | 0 |
Showing 12 of 39 columns. All of them are listed below.
| 0% |
2023-11-24T00:00:00.0002023-07-20T00:00:00.0002023-07-06T00:00:00.000 |
violation_code | integer | — | 0% | 362138 |
vehicle_body_type | text | — | 0% | SUBN4DSDVAN |
vehicle_make | text | — | 0% | TOYOTHONDAFORD |
issuing_agency | text | — | 0% | TVS |
street_code1 | integer | — | 0% | 01361010210 |
street_code2 | integer | — | 0% | 04040410410 |
street_code3 | integer | — | 0% | 04040410510 |
vehicle_expiration_date | integer | — | 0% | 08888888820238888 |
violation_location | text | — | 45% | 191146 |
violation_precinct | integer | — | 0% | 019114 |
issuer_precinct | integer | — | 0% | 019114 |
issuer_code | integer | — | 0% | 0362237355542 |
issuer_command | text | — | 45% | T103T302T401 |
issuer_squad | text | — | 48% | AHL |
violation_time | text | — | 0% | 0836A0840A1140A |
time_first_observed | text | — | 94% | 000001100A1000A |
violation_county | text | — | 1% | NYQNBK |
violation_in_front_of_or | categorical | — | 45% | FOIof 5 |
house_number | text | — | 45% | NSE |
street_name | text | — | 0% | WB N CONDUIT AVE @ 8Broadway3rd Ave |
intersecting_street | text | — | 48% | ST8TH STH ST |
date_first_observed | integer | — | 0% | 02023092720231011 |
law_section | categorical | — | 0% | 40811801111of 7 |
sub_division | text | — | 0% | BH1C |
violation_legal_code | text | — | 55% | Tof 1 |
days_parking_in_effect | text | — | 45% | YYYYYYYYYYYYYY Y |
from_hours_in_effect | text | — | 68% | 0800A0700A0900A |
to_hours_in_effect | text | — | 68% | 0700P0600P0100P |
vehicle_color | text | — | 9% | GYWHBK |
unregistered_vehicle | text | — | 98% | 0of 1 |
vehicle_year | integer | — | 0% | 020232022 |
meter_number | text | — | 87% | -469232444673 |
feet_from_curb | categorical | — | 0% | 053of 19 |
violation_post_code | text | — | 66% | 1993 |
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% | — |