From a 500-row sample across 39 columns.
hydrant_violationregistration_stateviolation_legal_code+38hydrant_violationregistration_stateviolation_legal_code+38Has 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1484697303 | JER1863 | NY | PAS | 2022-06-10T00:00:00.000 | 67 | SDN | TOYOT | P | 34330 | 179 | 0 |
| 1484697315 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summons_number | integer | — | 0% | 100171626710017163091001716358 |
plate_id | text | — | 0% | BLANKPLATEAT376A82752PC |
registration_state | text | — | 0% | NYNJPA |
plate_type | text | — | 0% | PASCOMOMT |
issue_date | datetime | — |
GET /api/datasets/869v-vr48 GET /api/datasets/869v-vr48/quality GET /api/datasets/869v-vr48/related GET /api/columns?dataset=869v-vr48
issuing_agencyissue_datesummons_number+1| KEV4487 |
| NY |
| PAS |
| 2022-06-13T00:00:00.000 |
| 51 |
| SUBN |
| JEEP |
| K |
| 34310 |
| 16400 |
| 11010 |
| 1484697625 | H73NYD | NJ | PAS | 2022-06-19T00:00:00.000 | 63 | SDN | JEEP | N | 30640 | 13015 | 28540 |
| 1484697674 | GJC9296 | NY | PAS | 2022-06-19T00:00:00.000 | 63 | SUBN | LEXUS | N | 30640 | 13015 | 28540 |
| 1484697686 | M51PUV | NJ | PAS | 2022-06-19T00:00:00.000 | 63 | SDN | HYUND | N | 30640 | 13015 | 28540 |
| 1484697698 | H73NYD | NJ | PAS | 2022-06-23T00:00:00.000 | 63 | — | JEEP | K | 30640 | 13015 | 28540 |
| 1484697728 | M51PUV | NJ | PAS | 2022-06-23T00:00:00.000 | 63 | — | HYUND | K | 30640 | 13015 | 28540 |
| 1484698204 | KJJ8637 | NY | PAS | 2022-06-20T00:00:00.000 | 67 | SUBN | TOYOT | N | 11585 | 26390 | 15010 |
| 1484698381 | JEC8631 | NY | PAS | 2022-06-19T00:00:00.000 | 98 | SUBN | NISSA | N | 0 | 0 | 0 |
| 1484698721 | K21PNH | NJ | PAS | 2022-06-25T00:00:00.000 | 10 | SUBN | JEEP | K | 33190 | 25190 | 31990 |
Showing 12 of 36 columns. All of them are listed below.
| 0% |
2022-08-04T00:00:00.0002022-08-05T00:00:00.0002022-08-02T00: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% | 01021013610 |
street_code2 | integer | — | 0% | 04040410410 |
street_code3 | integer | — | 0% | 04040410510 |
vehicle_expiration_date | integer | — | 0% | 08888888820238888 |
violation_location | integer | — | 46% | 19136 |
violation_precinct | integer | — | 0% | 01913 |
issuer_precinct | integer | — | 0% | 01913 |
issuer_code | integer | — | 0% | 0362237355542 |
issuer_command | text | — | 46% | T103T102T302 |
issuer_squad | text | — | 49% | ANH |
violation_time | text | — | 0% | 0836A0839A0906A |
time_first_observed | text | — | 94% | 000001100A1000A |
violation_county | text | — | 1% | NYQNBK |
violation_in_front_of_or | categorical | — | 46% | FOIof 6 |
house_number | text | — | 46% | NSE |
street_name | text | — | 0% | BroadwayWB N CONDUIT AVE @ S3rd Ave |
intersecting_street | text | — | 47% | STPRINGFIELD BLVDAVE |
date_first_observed | integer | — | 0% | 02022101820220824 |
law_section | categorical | — | 0% | 40811801111of 8 |
sub_division | text | — | 0% | BH1C |
violation_legal_code | categorical | — | 54% | T70of 4 |
days_parking_in_effect | text | — | 46% | YYYYYYYYYYYYYY Y |
from_hours_in_effect | text | — | 69% | 0800A0700A0900A |
to_hours_in_effect | text | — | 69% | 0700P0600P0100P |
vehicle_color | text | — | 9% | GYWHBK |
unregistered_vehicle | integer | — | 98% | 0of 1 |
vehicle_year | text | — | 0% | 020212019 |
meter_number | text | — | 88% | -469232469275 |
feet_from_curb | categorical | — | 0% | 053of 18 |
violation_post_code | text | — | 51% | 019906 |
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% | — |