From a 500-row sample across 37 columns.
meter_numbersub_divisionto_hours_in_effect+40meter_numbersub_divisionto_hours_in_effect+40Has 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1361929741 | FCJ5493 | NY | PAS | 1970-12-18T00:00:00.000 | 20 | SUBN | GMC | S | 35030 | 89180 | 32600 |
| 1366962000 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summons_number | integer | — | 0% | 100237596410023760751002881493 |
plate_id | text | — | 0% | BLANKPLATEN/A49839JG |
registration_state | text | — | 0% | NYNJPA |
plate_type | text | — | 0% | PASCOMOMT |
issue_date | datetime | — |
GET /api/datasets/jt7v-77mi GET /api/datasets/jt7v-77mi/quality GET /api/datasets/jt7v-77mi/related GET /api/columns?dataset=jt7v-77mi
meter_numbersub_divisionto_hours_in_effect+40meter_numbersub_divisionto_hours_in_effect+38meter_numbersub_divisionto_hours_in_effect+40meter_numbersub_divisionto_hours_in_effect+38meter_numbersub_divisionto_hours_in_effect+38meter_numbersub_divisionto_hours_in_effect+38| 63540MC |
| NY |
| COM |
| 1971-02-02T00:00:00.000 |
| 46 |
| DELV |
| FRUEH |
| P |
| 58830 |
| 11430 |
| 11450 |
| 1342296187 | GCY4187 | NY | SRF | 1971-09-18T00:00:00.000 | 21 | VAN | FORD | S | 11790 | 35780 | 57890 |
| 1342296199 | 95V6675 | TX | PAS | 1971-09-18T00:00:00.000 | 21 | — | GMC | S | 11790 | 35780 | 57890 |
| 1342296217 | FYM5117 | NY | SRF | 1971-09-18T00:00:00.000 | 21 | SUBN | NISSA | S | 28190 | 55690 | 11590 |
| 1356906515 | GFM1421 | NY | PAS | 1971-09-18T00:00:00.000 | 40 | SDN | MAZDA | X | 13610 | 37270 | 37290 |
| 1337077380 | 18972BB | NY | 999 | 1971-10-10T00:00:00.000 | 14 | BUS | INTER | P | 8440 | 19190 | 19290 |
| 1364523796 | WNJ4730 | VA | PAS | 1973-04-05T00:00:00.000 | 14 | SDN | TOYOT | P | 50830 | 48330 | 56230 |
| 1359914924 | 68091JZ | NY | COM | 1973-07-22T00:00:00.000 | 46 | DELV | TOYOT | P | 10610 | 34030 | 34050 |
| 1355498326 | EWV4127 | NY | PAS | 1973-08-12T00:00:00.000 | 21 | SUBN | ACURA | X | 42630 | 10030 | 10080 |
Showing 12 of 35 columns. All of them are listed below.
| 0% |
2013-11-29T00:00:00.0002013-10-03T00:00:00.0002013-10-08T00:00:00.000 |
violation_code | integer | — | 0% | 382114 |
vehicle_body_type | text | — | 1% | SUBN4DSDVAN |
vehicle_make | text | — | 1% | FORDTOYOTHONDA |
issuing_agency | categorical | — | 0% | TPVof 17 |
street_code1 | integer | — | 0% | 01361010210 |
street_code2 | integer | — | 0% | 04040410410 |
street_code3 | integer | — | 0% | 04040410510 |
vehicle_expiration_date | integer | — | 0% | 08888888888880088 |
violation_location | text | — | 7% | 001900180014 |
violation_precinct | integer | — | 0% | 01918 |
issuer_precinct | integer | — | 0% | 01918 |
issuer_code | integer | — | 0% | 0355542357092 |
issuer_command | text | — | 7% | T103T401T302 |
issuer_squad | text | — | 7% | 0000AM |
violation_time | text | — | 0% | 0836A1136A0806A |
time_first_observed | text | — | 89% | 1200P0100P1000A |
violation_county | categorical | — | 8% | NYKQof 12 |
violation_in_front_of_or_opposite | categorical | — | 8% | FOIof 5 |
house_number | text | House Number | 9% | NSE |
street_name | text | Street Name | 0% | Broadway3rd Ave5th Ave |
intersecting_street | text | — | 79% | STON AVE.W.-LV-4 |
date_first_observed | integer | — | 0% | 02013103020140611 |
law_section | categorical | — | 0% | 40811111180of 4 |
sub_division | text | — | 0% | h1d1c |
violation_legal_code | categorical | — | 93% | T0of 2 |
days_parking_in_effect | text | — | 16% | YYYYYYYYYYYYY |
from_hours_in_effect | text | — | 37% | 0800A0900AALL |
to_hours_in_effect | text | — | 37% | 0700PALL0600P |
vehicle_color | text | — | 1% | WHITEGYWH |
unregistered_vehicle | text | — | 86% | 0of 1 |
vehicle_year | integer | — | 0% | 020132012 |
meter_number | text | — | 78% | -126-4950124-4034 |
feet_from_curb | categorical | — | 0% | 056of 16 |
violation_post_code | text | — | 21% | CC199 -01 - |
violation_description | text | — | 14% | 38-Failure to Display Mu…21-No Parking (street cl…14-No Standing |
no_standing_or_stopping_violation | text | — | 100% | — |
hydrant_violation | text | — | 100% | — |
double_parking_violation | text | — | 100% | — |