From a 500-row sample across 36 columns.
feet_from_curbviolation_codehouse_number+38feet_from_curbviolation_codehouse_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1442479747 | HCP7926 | NY | PAS | 2018-07-16T00:00:00.000 | 21 | SDN | ME/BE | S | 0 | 0 | 0 |
| 1442479759 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
summons_number | integer | — | 0% | 105390208610539020981053909548 |
plate_id | text | — | 0% | BLANKPLATE2028685NS |
registration_state | text | — | 0% | NYNJPA |
plate_type | text | — | 0% | PASCOMOMT |
issue_date | datetime | — |
GET /api/datasets/faiq-9dfq GET /api/datasets/faiq-9dfq/quality GET /api/datasets/faiq-9dfq/related GET /api/columns?dataset=faiq-9dfq
feet_from_curbviolation_codehouse_number+40feet_from_curbviolation_codehouse_number+40feet_from_curbviolation_codehouse_number+38feet_from_curbviolation_codehouse_number+38feet_from_curbviolation_codehouse_number+38feet_from_curbviolation_codehouse_number+40| HSZ2472 |
| NY |
| PAS |
| 2018-07-13T00:00:00.000 |
| 21 |
| SUBN |
| ME/BE |
| S |
| 49230 |
| 56630 |
| 73380 |
| 1442479772 | HYJ1988 | NY | PAS | 2018-07-13T00:00:00.000 | 21 | SUBN | HONDA | S | 12430 | 56630 | 0 |
| 1442480397 | HNV6246 | NY | PAS | 2018-07-13T00:00:00.000 | 21 | SUBN | TOYOT | S | 83730 | 74730 | 72030 |
| 1442480403 | HWG4025 | NY | PAS | 2018-07-13T00:00:00.000 | 21 | SUBN | HYUND | S | 83730 | 74730 | 72030 |
| 1442480415 | KPB2420 | PA | PAS | 2018-07-13T00:00:00.000 | 21 | SDN | HONDA | S | 83730 | 26130 | 74730 |
| 1442480427 | KTN9364 | PA | PAS | 2018-07-13T00:00:00.000 | 21 | SDN | BMW | S | 19830 | 82230 | 72030 |
| 1442480439 | HRC4509 | NY | PAS | 2018-07-13T00:00:00.000 | 21 | SDN | KIA | S | 19830 | 72030 | 53935 |
| 1442480506 | HYH2162 | NY | PAS | 2018-07-13T00:00:00.000 | 21 | SUBN | MITSU | S | 26130 | 56630 | 73380 |
| 1442480531 | GSZ9713 | NY | PAS | 2018-07-17T00:00:00.000 | 21 | SUBN | PLYMO | S | 49230 | 19830 | 34330 |
Showing 12 of 36 columns. All of them are listed below.
| 0% |
2018-10-25T00:00:00.0002018-11-08T00:00:00.0002018-10-16T00:00:00.000 |
violation_code | integer | — | 0% | 213836 |
vehicle_body_type | text | — | 0% | SUBN4DSDVAN |
vehicle_make | text | — | 1% | FORDTOYOTHONDA |
issuing_agency | categorical | — | 0% | TVPof 18 |
street_code1 | integer | — | 0% | 01361010210 |
street_code2 | integer | — | 0% | 01041040404 |
street_code3 | integer | — | 0% | 04040410510 |
vehicle_expiration_date | integer | — | 0% | 08888008820180088 |
violation_location | integer | — | 16% | 191418 |
violation_precinct | integer | — | 0% | 01914 |
issuer_precinct | integer | — | 0% | 01914 |
issuer_code | integer | — | 0% | 0346199347607 |
issuer_command | text | — | 16% | T103T302T401 |
issuer_squad | text | — | 16% | 0000MA |
violation_time | text | — | 0% | 0836A1136A1140A |
time_first_observed | text | — | 94% | 1200P1100A1000A |
violation_county | categorical | — | 0% | NYKQof 10 |
violation_in_front_of_or | categorical | — | 17% | FOIof 6 |
house_number | text | — | 18% | NSE |
street_name | text | — | 0% | Broadway3rd Ave5th Ave |
intersecting_street | text | — | 71% | H STSTAVE |
date_first_observed | integer | — | 0% | 02018071820181010 |
law_section | categorical | — | 0% | 40811801111of 4 |
sub_division | text | — | 0% | D1DC |
violation_legal_code | categorical | — | 84% | T0of 2 |
days_parking_in_effect | text | — | 16% | YYYYYYYYYYYYYYYYYY |
from_hours_in_effect | text | — | 50% | 0800A0700A0900A |
to_hours_in_effect | text | — | 50% | 0700P0600PALL |
vehicle_color | text | — | 1% | WHGYBK |
unregistered_vehicle | integer | — | 92% | 0of 1 |
vehicle_year | integer | — | 0% | 020172016 |
meter_number | text | — | 89% | -201-3010111-1111 |
feet_from_curb | categorical | — | 0% | 056of 17 |
violation_post_code | text | — | 24% | 0199A |
violation_description | categorical | — | 84% | PHTO SCHOOL ZN SPEED VIO…FAILURE TO STOP AT RED L…BUS LANE VIOLATIONof 4 |
no_standing_or_stopping | text | — | 100% | — |
hydrant_violation | text | — | 100% | — |
double_parking_violation | text | — | 100% | — |