From a 500-row sample across 37 columns.
issuer_commandviolation_countyviolation_post_code+40issuer_commandviolation_countyviolation_post_code+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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1363745270 | GGY6450 | 99 | PAS | 2015-07-09T00:00:00.000 | 46 | SDN | HONDA | P | 0 | 40404 | 40404 |
| 1363745293 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summons_number | integer | UNIQUE IDENTIFIER OF SUMMONS | 0% | 100579605110057960631005796075 |
plate_id | text | REGISTERED PLATE ID | 0% | BLANKPLATEN/A56207MG |
registration_state | text | STATE OF PLATE REGISTRATION | 0% | NYNJPA |
plate_type | text | TYPE OF PLATE | 0% | PASCOMOMT |
issue_date | datetime |
GET /api/datasets/kiv2-tbus GET /api/datasets/kiv2-tbus/quality GET /api/datasets/kiv2-tbus/related GET /api/columns?dataset=kiv2-tbus
issuer_commandviolation_countyviolation_post_code+38issuer_commandviolation_countyviolation_post_code+40issuer_commandviolation_countyviolation_post_code+38issuer_commandviolation_countyviolation_post_code+40issuer_commandviolation_countyviolation_post_code+38issuer_commandviolation_countyviolation_post_code+38| KXD355 |
| SC |
| PAS |
| 2015-07-09T00:00:00.000 |
| 21 |
| SUBN |
| CHEVR |
| P |
| 55730 |
| 67030 |
| 58730 |
| 1363745438 | JCK7576 | PA | PAS | 2015-07-09T00:00:00.000 | 21 | SDN | ME/BE | P | 42730 | 26730 | 26830 |
| 1363745475 | GYK7658 | NY | OMS | 2015-07-09T00:00:00.000 | 21 | SUBN | NISSA | P | 58130 | 18630 | 67030 |
| 1363745487 | GMT8141 | NY | PAS | 2015-07-09T00:00:00.000 | 21 | P-U | LINCO | P | 58130 | 67030 | 58730 |
| 1363745517 | GYK3760 | NY | PAS | 2015-07-09T00:00:00.000 | 21 | SUBN | HONDA | P | 46730 | 58730 | 85730 |
| 1363745529 | GYK3760 | NY | PAS | 2015-07-09T00:00:00.000 | 75 | SUBN | HONDA | P | 46730 | 58730 | 85730 |
| 1363745542 | GWL9925 | NY | PAS | 2015-07-09T00:00:00.000 | 71 | SDN | TOYOT | P | 85730 | 59530 | 32030 |
| 1363745554 | GPH9963 | PA | PAS | 2015-07-09T00:00:00.000 | 21 | SDN | MITSU | P | 55730 | 67030 | 58730 |
| 1363745578 | GWF8627 | NY | PAS | 2015-07-09T00:00:00.000 | 21 | SUBN | LINCO | P | 31530 | 58730 | 85730 |
Showing 12 of 35 columns. All of them are listed below.
| ISSUE DATE |
| 0% |
2015-09-22T00:00:00.0002015-10-16T00:00:00.0002015-10-13T00:00:00.000 |
violation_code | integer | — | 0% | 213638 |
vehicle_body_type | text | VEHICLE BODY TYPE WRITTEN ON SUMMONS (SEDAN, ETC.) | 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% | 0E-888888888.088880088.0 |
violation_location | text | — | 18% | 001900180014 |
violation_precinct | integer | — | 0% | 01918 |
issuer_precinct | integer | — | 0% | 01918 |
issuer_code | integer | — | 0% | 0355542347615 |
issuer_command | text | — | 17% | T103T302T401 |
issuer_squad | text | — | 17% | 0000AB |
violation_time | text | — | 0% | 0836A1136A1140A |
time_first_observed | text | — | 89% | 1200P1100A1000A |
violation_county | categorical | — | 16% | NYKQof 16 |
violation_in_front_of_or_opposite | categorical | — | 18% | FOIof 6 |
house_number | text | — | 19% | NSE |
street_name | text | — | 0% | Broadway3rd Ave5th Ave |
intersecting_street | text | — | 71% | H STSTULES DR |
date_first_observed | integer | — | 0% | 02015091520160428 |
law_section | categorical | — | 0% | 40811801111of 5 |
sub_division | text | — | 0% | h1d1B |
violation_legal_code | categorical | — | 83% | T08of 3 |
days_parking_in_effect | text | — | 27% | YYYYYYYYYYYYY |
from_hours_in_effect | text | — | 47% | 0800A0900A0700A |
to_hours_in_effect | text | — | 47% | 0700PALL0600P |
vehicle_color | text | — | 1% | GYWHWHITE |
unregistered_vehicle | categorical | — | 89% | 025of 4 |
vehicle_year | integer | — | 0% | 020152014 |
meter_number | text | — | 82% | -126-4950126-4957 |
feet_from_curb | categorical | — | 0% | 056of 17 |
violation_post_code | text | — | 28% | 99 6CC1C 77 |
violation_description | text | — | 11% | 21-No Parking (street cl…PHTO SCHOOL ZN SPEED VIO…38-Failure to Display Mu… |
no_standing_or_stopping_violation | text | — | 100% | — |
hydrant_violation | text | — | 100% | — |
double_parking_violation | text | — | 100% | — |