From a 500-row sample across 65 columns.
violation_descriptionviolation_timeissuing_agencyviolation_timeissuing_agency| ticket_number | violation_date | issuing_agency | respondent_last_name | violation_location_borough | violation_location_city | violation_location_zip_code | respondent_address_house | hearing_result | hearing_date | hearing_time | decision_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1585011A0 | 5201-05-12T09:00:00.000 | DOHMH - VPHS | WILLETT ZIEGLER | STATEN IS | STATEN ISLAND | 10301 | 149 | Default/ No Appearance | 2011-07-11T00:00:00.000 | 10:00:00 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
ticket_number | text | — | 0% | 000000011700000001260000000189 |
violation_date | datetime | — | 0% | 1900-01-01T00:00:00.0002012-03-27T00:00:00.0002009-09-15T00:00:00.000 |
violation_time | text | — | 21% | 10:30:0008:30:0010:00:00 |
issuing_agency | text | — | 30% | DOS - ENFORCEMENT AGENTSSANITATION OTHERSDEPT. OF BUILDINGS |
GET /api/datasets/jz4z-kudi GET /api/datasets/jz4z-kudi/quality GET /api/datasets/jz4z-kudi/related GET /api/columns?dataset=jz4z-kudi
| 2011-07-18T16:09:01.000 |
| UR1003539 | 3017-03-22T17:00:00.000 | TAXI_TLC | ERWIN | NOT NYC | BROOKLYN | 11211 | — | — | 2017-08-23T00:00:00.000 | — | 2017-08-23T14:40:03.000 |
| 009033P | 2109-10-25T23:22:00.000 | TAXI_TLC | HORACE | NOT NYC | WOODSIDE | 11377 | — | — | 2019-11-18T00:00:00.000 | — | 2019-11-19T14:29:24.000 |
| 018543P | 2109-10-19T07:50:00.000 | TAXI_TLC | FARHAN | NOT NYC | FLORAL PARK | 11004 | — | — | 2019-11-18T00:00:00.000 | — | 2019-11-22T15:33:37.000 |
| 014626P | 2109-08-02T14:27:00.000 | TAXI_TLC | ANGEL | NOT NYC | RIDGEWOOD | 11385 | — | — | 2019-08-19T00:00:00.000 | — | 2019-08-15T09:47:08.000 |
| 017169P | 2109-04-08T15:44:00.000 | TAXI_TLC | ABDEL | NOT NYC | NEW JERSEY | 07306 | — | — | 2019-04-25T00:00:00.000 | — | 2019-04-23T10:40:34.000 |
| SE0018591 | 2104-11-13T11:46:00.000 | TAXI_TLC | Rehman | NOT NYC | BROOKLYN | 11210 | — | — | 2015-01-12T00:00:00.000 | — | 2015-01-12T12:19:26.000 |
| 1461530A | 2104-04-11T17:25:00.000 | TAXI_TLC | IBRAHIM | NOT NYC | BRONX | 10474 | — | — | 2014-05-08T00:00:00.000 | — | 2014-05-08T14:43:56.000 |
| PA241397 | 2103-08-05T06:50:00.000 | TAXI_Port Authority | TERRY | NOT NYC | Jamaica | 11433 | 110-04 | — | 2014-03-11T00:00:00.000 | — | 2014-03-11T09:16:22.000 |
| 0088632648 | 2096-07-01T00:00:00.000 | — | — | MANHATTAN | — | 10021 | — | DISMISSED | 2006-07-25T00:00:00.000 | 08:30:00 | 2006-06-30T00:00:00.000 |
Showing 12 of 42 columns. All of them are listed below.
respondent_last_name | text | — | 26% | CONSOLIDATED EDISONCAB CORPTHE BROOKLYN UNION GAS C… |
balance_due | integer | — | 69% | 030025 |
violation_location_borough | categorical | — | 0% | BROOKLYNMANHATTANQUEENSof 6 |
violation_location_block_no | text | — | 32% | 000000215402165 |
violation_location_lot_no | text | — | 32% | 000000017501 |
violation_location_house | text | — | 44% | 1100200 |
violation_location_street_name | text | — | 36% | BROADWAY3 AVENUE5 AVENUE |
violation_location_floor | text | — | 100% | 00of 1 |
violation_location_city | text | — | 17% | BROOKLYNNEW YORKBRONX |
violation_location_zip_code | text | — | 8% | 000001110111368 |
violation_location_state_name | text | — | 37% | NEW YORKOTHERNEW JERSEY |
respondent_address_borough | categorical | — | 1% | NOT NYCBROOKLYNQUEENSof 6 |
respondent_address_house | text | — | 22% | 41140 |
respondent_address_zip_code | text | — | 24% | 100031136811201 |
hearing_status | text | — | 21% | PAID IN FULLWRITTEN OFFHEARING COMPLETED |
hearing_result | text | — | 42% | IN VIOLATIONWRITTEN OFFDEFAULTED |
scheduled_hearing_location | categorical | — | 26% | MANHATTANBROOKLYNBRONXof 12 |
hearing_date | datetime | — | 11% | 2012-03-30T00:00:00.0002010-12-10T00:00:00.0002011-09-16T00:00:00.000 |
hearing_time | text | — | 16% | 08:30:0010:30:0013:00:00 |
decision_location_borough | categorical | — | 78% | MANHATTANBROOKLYNQUEENSof 14 |
decision_date | datetime | — | 34% | 2010-12-10T00:00:00.0002012-09-27T00:00:00.0002012-06-21T00:00:00.000 |
total_violation_amount | integer | — | 6% | 100010000 |
violation_details | text | — | 12% | EVT_OLDCase Updated ManuallyCase Document Scanned |
date_judgment_docketed | datetime | — | 83% | 2018-03-31T00:00:00.0002015-07-31T00:00:00.0002021-04-30T00:00:00.000 |
respondent_address_or_facility_number_for_fdny_and_dob_tickets | text | — | 90% | 013 |
penalty_imposed | integer | — | 9% | 0300100 |
paid_amount | integer | — | 23% | 010025 |
additional_penalties_or_late_fees | integer | — | 63% | 0100200 |
compliance_status | categorical | — | 51% | All Terms MetPenalty DueCompliance Dueof 4 |
violation_description | categorical | — | 98% | FIREBARNOISEof 4 |
charge_1_code | text | — | 27% | AS06AS26AS6M |
charge_1_code_section | text | — | 29% | A.C. 16-118 2 A16-118 2A.C. 16-120 A |
charge_1_code_description | text | — | 34% | DIRTY SIDEWALK DIRTY ARE…FAILURE TO CLEAN 18 INCH…DIRTY SIDEWALK |
charge_1_infraction_amount | integer | — | 32% | 100050 |
charge_2_code | text | — | 91% | 80-1A259a- |
charge_2_code_section | text | — | 94% | NYCHC 81.23(a)NYCHC 81.09(a)80-13(a)(2) |
charge_2_code_description | text | — | 96% | FIRE PROTECTION SYSTEMSSee Attached NOVPOSTING OF PERMITS AND R… |
charge_2_infraction_amount | integer | — | 96% | 0600950 |
charge_3_code | text | — | 94% | 80-159a-A2 |
charge_3_code_section | text | — | 95% | NYCHC 81.23(a)80-13(a)(2)NYCHC 81.09(a) |
charge_3_code_description | text | — | 98% | See attached NOVSee Attached NOVSIGN, POSTINGS, NOTICES … |
charge_3_infraction_amount | integer | — | 97% | 0600500 |
charge_4_code | text | — | 95% | 80-159a-A2 |
charge_4_code_section | text | — | 96% | NYCHC 81.23(a)80-13(a)(2)80-13(a)(3)(viii) |
charge_4_code_description | text | — | 98% | See attached NOVSee Attached NOVPOSTING OF PERMITS AND R… |
charge_4_infraction_amount | integer | — | 98% | 0600700 |
charge_5_code | text | — | 96% | 80-159a-08A |
charge_5_code_section | text | — | 97% | NYCHC 81.23(a)80-13(a)(2)80-13(a)(3)(viii) |
charge_5_code_description | text | — | 98% | See attached NOVSee Attached NOVPOSTING OF PERMITS AND R… |
charge_5_infraction_amount | integer | — | 98% | 0600700 |
charge_6_code | text | — | 96% | 80-159a-08A |
charge_6_code_section | text | — | 97% | NYCHC 81.23(a)NYCHC 81.09(a)80-13(a)(2) |
charge_6_code_description | text | — | 98% | See attached NOVSee Attached NOVSee Attached Nov |
charge_6_infraction_amount | integer | — | 99% | 0600500 |
charge_7_code | text | — | 97% | 80-159a-08A |
charge_7_code_section | text | — | 98% | NYCHC 81.23(a)NYCHC 81.09(a)80-13(a)(2) |
charge_7_code_description | text | — | 99% | See attached NOVSee Attached NOVTP - SELLING OR OFFERING… |
charge_7_infraction_amount | integer | — | 99% | 06004800 |
charge_8_code | text | — | 97% | 80-108A59a- |
charge_8_code_section | text | — | 98% | NYCHC 81.23(a)NYCHC 81.09(a)NYCHC 81.07(a) |
charge_8_code_description | text | — | 99% | See attached NOVSee Attached NOVOL - SOLD, OFFERED FOR S… |
charge_8_infraction_amount | categorical | — | 99% | 048002400of 17 |
charge_9_code | text | — | 97% | 80-159a-08A |
charge_9_code_section | text | — | 98% | NYCHC 81.23(a)NYCHC 81.09(a)80-13(a)(2) |
charge_9_code_description | text | — | 99% | See attached NOVSee Attached NOVPL - BUSINESS ENGAGES IN… |
charge_9_infraction_amount | categorical | — | 99% | 024004800of 11 |
charge_10_code | text | — | 98% | 80-108A10F |
charge_10_code_section | text | — | 98% | NYCHC 81.23(a)NYCHC 81.09(a)NYCHC 81.07(a) |
charge_10_code_description | text | — | 99% | See attached NOVSee Attached NOVSee Attached Nov |
charge_10_infraction_amount | categorical | — | 99% | 048002400of 7 |