From a 500-row sample across 38 columns.
vehicle_yearviolation_timeplate_type+40vehicle_yearviolation_timeplate_type+38Has street addresses (`house_number, street_name`) — 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1477633194 | J58JKX | NJ | PAS | 1972-05-08T00:00:00.000 | 16 | SDN | HONDA | P | 8730 | 5130 | 5280 |
| 1449715424 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summons_number | integer | — | 0% | 105311037610539089571053908970 |
plate_id | text | — | 0% | BLANKPLATE270481986107MM |
registration_state | text | — | 0% | NYNJPA |
plate_type | text | — | 0% | PASCOMOMT |
issue_date | datetime | — |
GET /api/datasets/p7t3-5i9s GET /api/datasets/p7t3-5i9s/quality GET /api/datasets/p7t3-5i9s/related GET /api/columns?dataset=p7t3-5i9s
vehicle_yearviolation_timeplate_type+40vehicle_yearviolation_timeplate_type+40vehicle_yearviolation_timeplate_type+38vehicle_yearviolation_timeplate_type+40vehicle_yearviolation_timeplate_type+38vehicle_yearviolation_timeplate_type+38| KRE6058 |
| PA |
| PAS |
| 1977-08-29T00:00:00.000 |
| 98 |
| SUBN |
| ME/BE |
| P |
| 86530 |
| 71800 |
| 73110 |
| 1455779155 | 444326R | NJ | PAS | 1988-10-03T00:00:00.000 | 20 | SDN | LEXUS | P | 27030 | 41330 | 69230 |
| 1458800908 | F728330 | OH | PAS | 1990-01-03T00:00:00.000 | 21 | SDN | CHEVR | P | 33030 | 93630 | 58730 |
| 1466038676 | FMY9090 | NY | PAS | 1990-02-14T00:00:00.000 | 21 | SUBN | JEEP | S | 45130 | 23930 | 68130 |
| 1440657920 | KDG0693 | PA | PAS | 1990-07-21T00:00:00.000 | 14 | SUBN | HYUN | P | 33440 | 62200 | 0 |
| 1460987810 | 79928MG | NY | COM | 1990-09-19T00:00:00.000 | 48 | DELV | INTER | P | 0 | 0 | 0 |
| 1449130203 | JJJ8186 | NY | PAS | 1990-10-14T00:00:00.000 | 14 | SUBN | BMW | P | 10020 | 27480 | 27540 |
| 1451300189 | DKD6024 | NC | PAS | 1991-07-25T00:00:00.000 | 98 | SDN | FORD | P | 11280 | 54137 | 5430 |
| 1464768973 | 6542FR | 99 | PAS | 2000-01-01T00:00:00.000 | 40 | SUBN | CMCKU | P | 18070 | 25390 | 27790 |
Showing 12 of 36 columns. All of them are listed below.
| 0% |
2019-11-29T00:00:00.0002019-09-03T00:00:00.0002019-08-01T00:00:00.000 |
violation_code | integer | — | 0% | 362138 |
vehicle_body_type | text | — | 0% | SUBN4DSDVAN |
vehicle_make | text | — | 0% | TOYOTHONDAFORD |
issuing_agency | text | — | 0% | TVP |
street_code1 | integer | — | 0% | 01361010210 |
street_code2 | integer | — | 0% | 04040410410 |
street_code3 | integer | — | 0% | 04040410510 |
vehicle_expiration_date | integer | — | 0% | 08888008820190088 |
violation_location | integer | — | 36% | 191418 |
violation_precinct | integer | — | 0% | 01914 |
issuer_precinct | integer | — | 0% | 01914 |
issuer_code | integer | — | 0% | 0346199347607 |
issuer_command | text | — | 36% | T103T302T201 |
issuer_squad | text | — | 36% | 0000AM |
violation_time | text | — | 0% | 0836A1136A0840A |
time_first_observed | text | — | 96% | 1200P1100A1000A |
violation_county | categorical | — | 0% | NYKBXof 14 |
violation_in_front_of_or | categorical | — | 36% | FOIof 6 |
house_number | text | — | 37% | NSE |
street_name | text | — | 0% | Broadway3rd Ave5th Ave |
intersecting_street | text | — | 55% | STH STAVE |
date_first_observed | integer | — | 0% | 02020031120200205 |
law_section | categorical | — | 0% | 40811801111of 4 |
sub_division | text | — | 0% | BD1C |
violation_legal_code | categorical | — | 64% | T0of 2 |
days_parking_in_effect | text | — | 36% | YYYYYYYYYYYYYYYYYY |
from_hours_in_effect | text | — | 62% | 0800A0700A0900A |
to_hours_in_effect | text | — | 62% | 0700P0600PALL |
vehicle_color | text | — | 3% | WHGYBK |
unregistered_vehicle | integer | — | 94% | 0of 1 |
vehicle_year | integer | — | 0% | 020192018 |
meter_number | text | — | 93% | -201-3010144-3387 |
feet_from_curb | categorical | — | 0% | 053of 17 |
violation_post_code | text | — | 42% | 0199A |
violation_description | categorical | — | 64% | PHTO SCHOOL ZN SPEED VIO…FAILURE TO STOP AT RED L…BUS LANE VIOLATIONof 5 |
no_standing_or_stopping | text | — | 100% | — |
hydrant_violation | text | — | 100% | — |
double_parking_violation | text | — | 100% | — |