From a 500-row sample across 39 columns.
sub_divisiondate_first_observedtime_first_observed+40sub_divisiondate_first_observedtime_first_observed+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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1471497410 | HZH8177 | NY | PAS | 2020-07-02T00:00:00.000 | 20 | SUBN | NISSA | P | 62200 | 33525 | 33640 |
| 1471497630 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summons_number | integer | — | 0% | 102059609010303908361030414506 |
plate_id | text | — | 0% | BLANKPLATE12125MJ86145MM |
registration_state | text | — | 0% | NYNJPA |
plate_type | text | — | 0% | PASCOMOMT |
issue_date | datetime | — |
GET /api/datasets/kvfd-bves GET /api/datasets/kvfd-bves/quality GET /api/datasets/kvfd-bves/related GET /api/columns?dataset=kvfd-bves
sub_divisiondate_first_observedtime_first_observed+38sub_divisiondate_first_observedtime_first_observed+40sub_divisiondate_first_observedtime_first_observed+38sub_divisiondate_first_observedtime_first_observed+40sub_divisiondate_first_observedtime_first_observed+38sub_divisiondate_first_observedtime_first_observed+38| JCX5781 |
| NY |
| PAS |
| 2020-06-27T00:00:00.000 |
| 20 |
| P-U |
| DODGE |
| P |
| 60790 |
| 34190 |
| 34240 |
| 1471497641 | HEK2391 | NY | PAS | 2020-06-27T00:00:00.000 | 20 | SUBN | KIA | P | 60790 | 40404 | 40404 |
| 1471497653 | GWY9859 | NY | PAS | 2020-06-27T00:00:00.000 | 20 | SUBN | JEEP | P | 60790 | 34190 | 34240 |
| 1471497665 | HEZ5501 | NY | PAS | 2020-06-27T00:00:00.000 | 20 | SUBN | SUBAR | P | 60790 | 34190 | 34240 |
| 1471497677 | JCG3480 | NY | PAS | 2020-06-27T00:00:00.000 | 20 | SDN | ME/BE | P | 60790 | 34190 | 34240 |
| 1471497689 | HPE5961 | 99 | PAS | 2020-07-02T00:00:00.000 | 10 | SUBN | FORD | P | 64151 | 49295 | 48795 |
| 1471497835 | GHP8476 | NY | PAS | 2020-06-28T00:00:00.000 | 10 | SDN | TOYOT | P | 64151 | 15635 | 49295 |
| 1471497847 | JRE7501 | NY | PAS | 2020-06-28T00:00:00.000 | 10 | SUBN | TOYOT | P | 64151 | 15635 | 49295 |
| 1471497859 | JDN9663 | NY | PAS | 2020-06-28T00:00:00.000 | 10 | SUBN | BMW | P | 64151 | 65617 | 15635 |
Showing 12 of 35 columns. All of them are listed below.
| 0% |
2020-11-27T00:00:00.0002020-08-20T00:00:00.0002020-09-04T00:00:00.000 |
violation_code | integer | — | 0% | 362138 |
vehicle_body_type | text | — | 0% | SUBN4DSDVAN |
vehicle_make | text | — | 0% | HONDATOYOTFORD |
issuing_agency | categorical | — | 0% | TVSof 18 |
street_code1 | integer | — | 0% | 01361010210 |
street_code2 | integer | — | 0% | 04040410410 |
street_code3 | integer | — | 0% | 04040410510 |
vehicle_expiration_date | integer | — | 0% | 08888008888888888 |
violation_location | integer | — | 34% | 1911418 |
violation_precinct | integer | — | 0% | 019114 |
issuer_precinct | integer | — | 0% | 01918 |
issuer_code | integer | — | 0% | 0346199362237 |
issuer_command | text | — | 34% | T103T302T401 |
issuer_squad | text | — | 35% | MA0000 |
violation_time | text | — | 0% | 0836A0806A0840A |
time_first_observed | text | — | 96% | 000001200P1100A |
violation_county | categorical | — | 0% | NYKQof 17 |
violation_in_front_of_or | categorical | — | 34% | FOIof 6 |
house_number | text | — | 35% | NSE |
street_name | text | — | 0% | Broadway3rd Ave5th Ave |
intersecting_street | text | — | 56% | STTH ST |
date_first_observed | integer | — | 0% | 02020101420201021 |
law_section | categorical | — | 0% | 40811801111of 9 |
sub_division | text | — | 0% | BD1C |
violation_legal_code | categorical | — | 66% | T01of 4 |
days_parking_in_effect | text | — | 34% | YYYYYYYYYYYYYYYYYY |
from_hours_in_effect | text | — | 63% | 0800A0700A0900A |
to_hours_in_effect | text | — | 63% | 0700P0600P1000A |
vehicle_color | text | — | 5% | GYWHBK |
unregistered_vehicle | categorical | — | 96% | 02of 2 |
vehicle_year | integer | — | 0% | 020192020 |
meter_number | text | — | 91% | -469232101342 |
feet_from_curb | categorical | — | 0% | 053of 17 |
violation_post_code | text | — | 39% | 0199C |
violation_description | text | — | 26% | 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% | — |