From a 500-row sample across 37 columns.
feet_from_curbunregistered_vehiclestreet_code1+40feet_from_curbunregistered_vehiclestreet_code1+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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1457617912 | JEB5683 | NY | PAS | 2021-06-25T00:00:00.000 | 40 | VAN | FORD | P | 63430 | 69230 | 13490 |
| 1457617924 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summons_number | integer | — | 0% | 105311032710767942571076848515 |
plate_id | text | — | 0% | BLANKPLATE55219MMAT460E |
registration_state | text | — | 0% | NYNJPA |
plate_type | text | — | 0% | PASCOMOMT |
issue_date | datetime | — |
GET /api/datasets/7mxj-7a6y GET /api/datasets/7mxj-7a6y/quality GET /api/datasets/7mxj-7a6y/related GET /api/columns?dataset=7mxj-7a6y
feet_from_curbunregistered_vehiclestreet_code1+40feet_from_curbunregistered_vehiclestreet_code1+38feet_from_curbunregistered_vehiclestreet_code1+38feet_from_curbunregistered_vehiclestreet_code1+40feet_from_curbunregistered_vehiclestreet_code1+38feet_from_curbunregistered_vehiclestreet_code1+38| JAN2986 |
| NY |
| PAS |
| 2021-06-25T00:00:00.000 |
| 20 |
| SUBN |
| DODGE |
| P |
| 13490 |
| 40404 |
| 40404 |
| 1457622427 | FJH6630 | TX | PAS | 2021-06-17T00:00:00.000 | 98 | SDN | AUDI | P | 79430 | 47130 | 11750 |
| 1457638629 | RD1Y5N | MO | PAS | 2021-06-16T00:00:00.000 | 98 | SDN | TOYOT | P | 53130 | 23230 | 23930 |
| 1457639580 | T503814C | NY | OMT | 2021-07-04T00:00:00.000 | 40 | TAXI | HONDA | P | 81030 | 23930 | 40030 |
| 1457643042 | JLN5490 | NY | PAS | 2021-06-28T00:00:00.000 | 98 | SDN | HONDA | P | 0 | 40404 | 40404 |
| 1457663909 | UMB4505 | VA | PAS | 2021-07-02T00:00:00.000 | 98 | SDN | SUBAR | P | 42130 | 58330 | 59640 |
| 1457670471 | JPS7544 | NY | PAS | 2021-06-19T00:00:00.000 | 40 | SDN | NISSA | P | 85330 | 55730 | 73050 |
| 1457670537 | UPS7544 | NY | PAS | 2021-06-19T00:00:00.000 | 70 | SDN | NISSA | P | 85330 | 55730 | 73050 |
| 1457677623 | 07027R5 | TX | PAS | 2021-07-03T00:00:00.000 | 74 | SUBN | LEXUS | P | 46820 | 65320 | 15920 |
Showing 12 of 36 columns. All of them are listed below.
| 0% |
2021-11-26T00:00:00.0002021-07-15T00:00:00.0002022-05-05T00:00:00.000 |
violation_code | integer | — | 0% | 362138 |
vehicle_body_type | text | — | 0% | SUBN4DSDVAN |
vehicle_make | text | — | 0% | HONDATOYOTFORD |
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% | 08888888820218888 |
violation_location | integer | — | 39% | 1911418 |
violation_precinct | integer | — | 0% | 019114 |
issuer_precinct | integer | — | 0% | 019114 |
issuer_code | integer | — | 0% | 0362237353177 |
issuer_command | text | — | 39% | T103T401T302 |
issuer_squad | text | — | 42% | AME |
violation_time | text | — | 0% | 0836A0839A0838A |
time_first_observed | text | — | 95% | 000001100A1059A |
violation_county | categorical | — | 0% | NYQNBXof 19 |
violation_in_front_of_or | categorical | — | 40% | FOIof 5 |
house_number | text | — | 40% | NSE |
street_name | text | — | 0% | Broadway3rd Ave5th Ave |
intersecting_street | text | — | 52% | STETH AVE |
date_first_observed | integer | — | 0% | 02021092920210810 |
law_section | categorical | — | 0% | 40811801111of 6 |
sub_division | text | — | 0% | BCH1 |
violation_legal_code | categorical | — | 61% | T0of 2 |
days_parking_in_effect | text | — | 40% | YYYYYYYYYYYYYYYYYY |
from_hours_in_effect | text | — | 68% | 0800A0700A0900A |
to_hours_in_effect | text | — | 68% | 0700P0600P1000A |
vehicle_color | text | — | 7% | GYWHBK |
unregistered_vehicle | integer | — | 98% | 0of 1 |
vehicle_year | integer | — | 0% | 020192020 |
meter_number | text | — | 88% | -469232221102 |
feet_from_curb | categorical | — | 0% | 053of 17 |
violation_post_code | text | — | 44% | 0199C |
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% | — |