From a 500-row sample across 19 columns.
summons_numberissuing_agencyissue_date+1statesummons_numberissuing_agencyissue_date+1summons_numberissuing_agency| plate | state | license_type | summons_number | issue_date | violation_time | violation | fine_amount | penalty_amount | interest_amount | reduction_amount | payment_amount |
|---|---|---|---|---|---|---|---|---|---|---|---|
| SHWAGON | CT | PAS | 5707457604 | 11/13/2025 | 08:36A | MTA CAMERA VIOLATION - DOUBLE PARKING | 50 | 0 | 0 | 0 | 50 |
| KDT6318 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
plate | text | — | 0% | BLANKPLATE12125MJN/A |
state | text | — | 0% | NYNJPA |
license_type | text | — | 0% | PASCOMOMT |
summons_number | integer | — | 0% | 435685 |
issue_date | text | — | 0% |
GET /api/datasets/nc67-uf89 GET /api/datasets/nc67-uf89/quality GET /api/datasets/nc67-uf89/related GET /api/columns?dataset=nc67-uf89
issue_datesummons_numberissuing_agencyissue_date+1summons_numberissuing_agencyissue_date+1summons_numberissuing_agencyissue_date+1| NY |
| PAS |
| 5131033070 |
| 10/24/2023 |
| 06:35P |
| FAILURE TO STOP AT RED LIGHT |
| 50 |
| 25 |
| 10.51 |
| 0 |
| 85.51 |
| 19186NE | NY | COM | 5707458001 | 11/13/2025 | 09:09A | MTA CAMERA VIOLATION - DOUBLE PARKING | 150 | 0 | 0 | 0 | 150 |
| LCJ3605 | NY | PAS | 9056475022 | 05/17/2023 | 03:53P | FRONT OR BACK PLATE MISSING | 65 | 60 | 12.57 | 0 | 137.57 |
| KGA3019 | NY | PAS | 8689013775 | 05/15/2021 | 09:32A | NO STANDING-BUS STOP | 115 | 60 | 35.82 | 0 | 210.82 |
| LXU3074 | NY | PAS | 4050756523 | 01/20/2026 | 12:40P | BUS LANE VIOLATION | 50 | 0 | 0 | 0 | 50 |
| HWF3237 | NY | PAS | 4050756493 | 01/20/2026 | 12:38P | BUS LANE VIOLATION | 50 | 25 | 0 | 0 | 75 |
| T116963C | NY | OMT | 4050756500 | 01/20/2026 | 12:38P | BUS LANE VIOLATION | 50 | 0 | 0 | 0 | 50 |
| KKF6794 | NY | PAS | 5707457987 | 11/13/2025 | 09:07A | MTA CAMERA VIOLATION - DOUBLE PARKING | 50 | 0 | 0 | 0 | 50 |
| 52443MM | NY | COM | 5707457975 | 11/13/2025 | 09:06A | MTA CAMERA VIOLATION - DOUBLE PARKING | 150 | 0 | 0 | 0 | 150 |
Showing 12 of 19 columns. All of them are listed below.
NYNJPA |
violation_time | text | — | 6% | 08:36A11:36A08:40A |
violation | text | — | 6% | PHTO SCHOOL ZN SPEED VIO…NO PARKING-STREET CLEANI…FAIL TO DSPLY MUNI METER… |
judgment_entry_date | date | — | 84% | 07/28/202204/08/202106/16/2022 |
fine_amount | integer | — | 6% | 5011565 |
penalty_amount | categorical | — | 6% | 06010of 10 |
interest_amount | float | — | 6% | 00.941.29 |
reduction_amount | float | — | 6% | 06515 |
payment_amount | float | — | 6% | 050115 |
amount_due | float | — | 6% | 012575 |
precinct | text | — | 6% | 000019014 |
county | text | — | 6% | NYKQ |
issuing_agency | text | — | 6% | TRAFFICDEPARTMENT OF TRANSPORTA…POLICE DEPARTMENT |
violation_status | categorical | — | 77% | HEARING HELD-GUILTYHEARING HELD-GUILTY REDU…HEARING HELD-NOT GUILTYof 15 |
summons_image | url | — | — | {'description': 'View Su…{'description': 'View Su…{'description': 'View Su… |