From a 500-row sample across 18 columns.
violation_typeviolation_numberhouse_number+5violation_typebinblock+3house_numberdisposition_datebinbinHas borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| isn_dob_bis_viol | boro | block | lot | issue_date | violation_type_code | violation_number | house_number | street | disposition_comments | device_number | description |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 24174 | 5 | 99999 | 99999 | 19881031 | E | 1391F/03 | TEST | RECORD | DELETED BY CES ON 06/21/91 BECAUSE TEST RECORD | 5P182 | (51) CLEAN INSTALLED (52) MARK EACH FLOOR# |
| 21792 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
isn_dob_bis_viol | text | — | 0% | 176723623108201101616 |
boro | categorical | — | 0% | 134of 11 |
bin | text | — | 0% | 415549332570581015219 |
block | text | — | 1% | 000000001605141 |
lot | text | — | 0% |
GET /api/datasets/3h2n-5cm9 GET /api/datasets/3h2n-5cm9/quality GET /api/datasets/3h2n-5cm9/related GET /api/columns?dataset=3h2n-5cm9
binblocklotblocklotbinblocklot+1binblocklot| 5 |
| 99999 |
| 99999 |
| 19881031 |
| E |
| 1391F\3 |
| TEST |
| RECORD |
| DELETED BY ASU ON 06/17/91 BECAUSE DUPLICATE ENTRY |
| 5P182 |
| (51)CLEAN INSTALLATION (52)MARK EACH FLOOR # |
| 22419 | 1 | 00847 | 00038 | 19881122 | E | 1179A-04 | 222 | 4TH AVE | — | 1P4050 | (51) REMOVE ALL DEADBOLT LOCKS |
| 32085 | 1 | 00847 | 00038 | 19881122 | E | 1179A-05 | 222 | 4TH AVE | — | 1P23210 | — |
| 22405 | 1 | 00847 | 00038 | 19881122 | E | 1179A/03 | 222 | 4TH AVE | — | 1P4049 | (51) REMOVE ALL DEADBOLT LOCKS ON HOISTWAY DOORS (50) TO M/R PIT OVERHEAD |
| 22408 | 1 | 00847 | 00038 | 19881122 | E | 1179A-06 | 222 | 4TH AVE | 266-81 | 1F3204 | (51) RESTORE TO SERVICE |
| 23135 | 1 | 00848 | 00043 | 19881123 | E | 1179A-01 | 242 | FOURTH AVE | 257-81 | 1P4068 | (21) RESHACKLE CAR AND CWT (33) REPAIR GLASS ON HOISTWAY DOOR TOP FLOOR (51) TAG GOVERNOR FOR ALL TEST (46) CAR TOP LIGHT |
| 23133 | 1 | 00848 | 00043 | 19881123 | E | 1179A-02 | 242 | FOURTH AVE | 257-81 | 1P4069 | (51) PRSCHACKLE CAR AND CWT (52) TAG GOVERNOR FOR ALL TEST (53) REPAIR GRATING IN MOTOR ROOM |
| 23142 | 1 | 00848 | 00043 | 19881123 | E | 1179A-03 | 242 | FOURTH AVE | 257-81 | 1P4066 | (51) TAG GOVENOR FOR ALL TEST |
| 23137 | 1 | 00848 | 00043 | 19881123 | E | 1179A-04 | 242 | FOURTH AVE | 257-81 | 1P4067 | (51) TAG GOVENOR FOR ALL TEST |
Showing 12 of 17 columns. All of them are listed below.
000010750100005 |
issue_date | text | — | 0% | 199508292023063020230620 |
violation_type_code | text | — | 0% | ELL6291LBLVIO |
violation_number | text | — | 0% | VIOLMTF1RIMTF1LE |
house_number | text | — | 0% | 11002 |
street | text | — | 1% | BROADWAY5 AVENUE3 AVENUE |
disposition_date | text | — | 23% | 201307312022121620140402 |
disposition_comments | text | — | 25% | CIANOW CRM Violation Dis…PVT: SATISFIED BY SUBMIS…PVT: RESOLVED BY SATISFA… |
device_number | text | — | 27% | 001025620082645900107000 |
description | text | — | 62% | FAILURE TO CERTIFY CORRE…FAILURE TO FILE BENCHMAR…VIOLATION ISSUED FOR FAI… |
ecb_number | text | — | 92% | \N34164450J |
number | text | — | 0% | V*011990LANDMRKVIOLV*073091LANDMRKVIOLV*031590LANDMRKVIOL |
violation_category | categorical | — | 0% | V*-DOB VIOLATION - DISMI…V*-DOB VIOLATION - Resol…V-DOB VIOLATION - ACTIVEof 15 |
violation_type | text | — | 0% | E-ELEVATOR …LL6291-LOCAL LAW 62/91 -…LBLVIO-LOW PRESSURE BOIL… |