From a 500-row sample across 40 columns.
violation_legal_codefeet_from_curbsummons_number+40violation_legal_codefeet_from_curbsummons_number+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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 5092469481 | GZH7067 | NY | PAS | 2016-07-10T00:00:00.000 | 7 | SUBN | TOYOT | V | 0 | 0 | 0 |
| 5092451658 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summons_number | integer | — | 0% | 100288844010028884511005796452 |
plate_id | text | — | 0% | BLANKPLATE96087MA85848MD |
registration_state | text | — | 0% | NYNJPA |
plate_type | text | — | 0% | PASCOMOMT |
issue_date | datetime | — |
GET /api/datasets/2bnn-yakx GET /api/datasets/2bnn-yakx/quality GET /api/datasets/2bnn-yakx/related GET /api/columns?dataset=2bnn-yakx
violation_legal_codefeet_from_curbsummons_number+40violation_legal_codefeet_from_curbsummons_number+38violation_legal_codefeet_from_curbsummons_number+40violation_legal_codefeet_from_curbsummons_number+38violation_legal_codefeet_from_curbsummons_number+38violation_legal_codefeet_from_curbsummons_number+38| GZH7067 |
| NY |
| PAS |
| 2016-07-08T00:00:00.000 |
| 7 |
| SUBN |
| TOYOT |
| V |
| 0 |
| 0 |
| 0 |
| 4631633384 | AVM7975 | NY | PAS | 2017-03-09T00:00:00.000 | 36 | SUBN | GMC | V | 0 | 0 | 0 |
| 8196557280 | GWB7054 | NY | PAS | 2017-01-18T00:00:00.000 | 70 | SUBN | TOYOT | T | 59590 | 8590 | 57790 |
| 4631184358 | EXZ9820 | NY | PAS | 2017-03-02T00:00:00.000 | 36 | 4DSD | HONDA | V | 0 | 0 | 0 |
| 4007039033 | GZE1511 | NY | PAS | 2017-03-06T00:00:00.000 | 5 | 4DSD | TOYOT | V | 0 | 0 | 0 |
| 7662736064 | 83485MH | NY | COM | 2016-07-20T00:00:00.000 | 48 | VAN | FRUEH | T | 0 | 40404 | 40404 |
| 8539360652 | GEH9367 | NY | PAS | 2017-05-04T00:00:00.000 | 70 | 4DSD | DODGE | T | 31830 | 5430 | 5580 |
| 8293544302 | FYP7892 | NY | PAS | 2016-10-03T00:00:00.000 | 14 | SUBN | TOYOT | T | 14380 | 35980 | 36030 |
| 8525962235 | HHM1058 | NY | PAS | 2017-04-20T00:00:00.000 | 21 | 4DSD | ME/BE | T | 35720 | 34020 | 22020 |
Showing 12 of 37 columns. All of them are listed below.
| 0% |
2016-09-16T00:00:00.0002016-09-27T00:00:00.0002016-10-07T00:00:00.000 |
violation_code | integer | — | 0% | 213638 |
vehicle_body_type | text | — | 0% | SUBN4DSDVAN |
vehicle_make | text | — | 1% | FORDTOYOTHONDA |
issuing_agency | categorical | — | 0% | TVPof 17 |
street_code1 | integer | — | 0% | 01361010210 |
street_code2 | integer | — | 0% | 04040410410 |
street_code3 | integer | — | 0% | 04040410510 |
vehicle_expiration_date | integer | — | 0% | 08888008888888888 |
violation_location | text | — | 19% | 001900140001 |
violation_precinct | integer | — | 0% | 01914 |
issuer_precinct | integer | — | 0% | 01914 |
issuer_code | integer | — | 0% | 0355542351966 |
issuer_command | text | — | 19% | T103T302T401 |
issuer_squad | text | — | 19% | 0000AB |
violation_time | text | — | 0% | 0836A1140A1136A |
time_first_observed | text | — | 92% | 1200P1100A1000A |
violation_county | categorical | — | 0% | NYKQof 12 |
violation_in_front_of_or_opposite | categorical | — | 20% | FOIof 6 |
house_number | text | — | 21% | NSE |
street_name | text | — | 0% | Broadway3rd AveMadison Ave |
intersecting_street | text | — | 69% | H STAVEST |
date_first_observed | integer | — | 0% | 02016090720160831 |
law_section | categorical | — | 0% | 40811801111of 8 |
sub_division | text | — | 0% | h1Bd1 |
violation_legal_code | categorical | — | 81% | T01of 4 |
days_parking_in_effect | text | — | 25% | YYYYYYYYYYYYY |
from_hours_in_effect | text | — | 50% | 0800A0900A0700A |
to_hours_in_effect | text | — | 50% | 0700PALL0600P |
vehicle_color | text | — | 1% | GYWHBK |
unregistered_vehicle | text | — | 90% | 0of 1 |
vehicle_year | integer | — | 0% | 020152016 |
meter_number | text | — | 83% | -126-4950411-3113 |
feet_from_curb | categorical | — | 0% | 056of 17 |
violation_post_code | text | — | 30% | 01CC1C |
violation_description | text | — | 10% | PHTO SCHOOL ZN SPEED VIO…21-No Parking (street cl…38-Failure to Display Mu… |
no_standing_or_stopping_violation | text | — | 100% | — |
hydrant_violation | text | — | 100% | — |
double_parking_violation | text | — | 100% | — |