From a 500-row sample across 39 columns.
violation_precinctdate_first_observedhouse_number+38violation_precinctdate_first_observedhouse_number+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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 7560453867 | AN921T | NJ | PAS | 2015-02-07T00:00:00.000 | 84 | DELV | PETER | T | 10810 | 34110 | 34130 |
| 8030010837 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summons_number | integer | — | 0% | 113160607311316123101131602523 |
plate_id | text | — | 0% | BLANKPLATEN/A44491JW |
registration_state | text | — | 0% | NYNJPA |
plate_type | text | — | 0% | PASCOMOMT |
issue_date | datetime | — |
GET /api/datasets/c284-tqph GET /api/datasets/c284-tqph/quality GET /api/datasets/c284-tqph/related GET /api/columns?dataset=c284-tqph
violation_precinctdate_first_observedhouse_number+40violation_precinctdate_first_observedhouse_number+38violation_precinctdate_first_observedhouse_number+38violation_precinctdate_first_observedhouse_number+40violation_precinctdate_first_observedhouse_number+38violation_precinctdate_first_observedhouse_number+38| 94866JA |
| NY |
| COM |
| 2015-04-29T00:00:00.000 |
| 42 |
| DELV |
| INTER |
| T |
| 17570 |
| 10410 |
| 25390 |
| 8002993251 | 77936JY | NY | COM | 2014-10-06T00:00:00.000 | 13 | VAN | WORKH | T | 45440 | 32910 | 28870 |
| 8014184210 | T651285C | NY | OMT | 2015-03-24T00:00:00.000 | 38 | 4DSD | TOYOT | T | 73220 | 0 | 0 |
| 7463033090 | GRD6305 | NY | OMS | 2014-08-16T00:00:00.000 | 40 | 4DSD | NISSA | T | 24090 | 0 | 0 |
| 7025381809 | FSW5604 | NY | PAS | 2015-05-21T00:00:00.000 | 71 | SUBN | NISSA | T | 74380 | 64520 | 53620 |
| 7982768570 | 75127JX | NY | COM | 2015-04-15T00:00:00.000 | 69 | VAN | CHEVR | T | 34930 | 10810 | 10910 |
| 7069430346 | GMZ8407 | NY | PAS | 2014-11-11T00:00:00.000 | 37 | VAN | MERCU | T | 13610 | 35090 | 35110 |
| 8045350957 | GRP7934 | NY | PAS | 2015-05-07T00:00:00.000 | 21 | SUBN | HONDA | T | 51090 | 16590 | 45590 |
| 7445114452 | GLB5111 | NY | PAS | 2015-01-21T00:00:00.000 | 21 | 4DSD | HONDA | T | 22240 | 50190 | 16810 |
Showing 12 of 37 columns. All of them are listed below.
| 0% |
2015-01-15T00:00:00.0002015-01-13T00:00:00.0002015-01-16T00:00:00.000 |
violation_code | integer | — | 0% | 213814 |
vehicle_body_type | text | — | 0% | SUBN4DSDVAN |
vehicle_make | text | — | 1% | FORDTOYOTHONDA |
issuing_agency | categorical | — | 0% | TVPof 19 |
street_code1 | integer | — | 0% | 01361010210 |
street_code2 | integer | — | 0% | 04040410410 |
street_code3 | integer | — | 0% | 04040410510 |
vehicle_expiration_date | datetime | — | 81% | 0001-01-03T12:00:00.000of 1 |
violation_location | text | — | 15% | 001900180014 |
violation_precinct | integer | — | 0% | 01918 |
issuer_precinct | integer | — | 0% | 01918 |
issuer_code | integer | — | 0% | 0355542352979 |
issuer_command | text | — | 15% | T103T401T302 |
issuer_squad | text | — | 15% | 0000AM |
violation_time | text | — | 0% | 0836A1136A1140A |
time_first_observed | text | — | 90% | 1200P1000A1100A |
violation_county | categorical | — | 16% | NYKQof 14 |
violation_in_front_of_or_opposite | categorical | — | 16% | FOIof 5 |
house_number | text | — | 17% | NSE |
street_name | text | — | 0% | Broadway3rd Ave5th Ave |
intersecting_street | text | — | 73% | AVESTPRESSWAY @ PECK AVE |
date_first_observed | datetime | — | 3% | 0001-01-03T12:00:00.000of 1 |
law_section | categorical | — | 0% | 40811111180of 4 |
sub_division | text | — | 0% | h1d1c |
violation_legal_code | categorical | — | 85% | T0of 2 |
days_parking_in_effect | text | — | 24% | YYYYYYYYYYYYY |
from_hours_in_effect | text | — | 44% | 0800A0900AALL |
to_hours_in_effect | text | — | 44% | 0700PALL0600P |
vehicle_color | text | — | 1% | GYWHWHITE |
unregistered_vehicle | text | — | 88% | 0of 1 |
vehicle_year | integer | — | 0% | 020132014 |
meter_number | text | — | 81% | -126-4950120-8014 |
feet_from_curb | categorical | — | 0% | 056of 17 |
violation_post_code | text | — | 27% | 99 6CC1C 77 |
violation_description | text | — | 12% | 38-Failure to Display Mu…21-No Parking (street cl…14-No Standing |
no_standing_or_stopping_violation | text | — | 100% | average_medicare_payment…of 1 |
hydrant_violation | text | — | 100% | nppes_provider_gender":"…of 1 |
double_parking_violation | text | — | 100% | nppes_provider_last_org_…of 1 |