From a 500-row sample across 36 columns.
binviolation_typelot+3binviolation_typelot+1binlotblockbinHas borough codes (`boro`) — joinable, but needs boundary shapes to draw.
| isn_dob_bis_extract | ecb_violation_number | ecb_violation_status | dob_violation_number | bin | boro | block | lot | hearing_date | hearing_time | served_date | issue_date |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1075005 | 34044233R | RESOLVE | 112790CA4PR04 | 1006588 | 1 | 00460 | 0029 | 19910509 | 830 | 19910129 | 19901127 |
| 1082681 |
The machine field names SoQL needs, with the publisher's own description of each. Profiling runs nightly; null rates and sample values appear once it has.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
isn_dob_bis_extract | text | — | — | — |
ecb_violation_number | text | — | — | — |
ecb_violation_status | text | — | — | — |
dob_violation_number | text | — | — | — |
bin | text | — | — | — |
boro | text | — | — | — |
block |
GET /api/datasets/6bgk-3dad GET /api/datasets/6bgk-3dad/quality GET /api/datasets/6bgk-3dad/related GET /api/columns?dataset=6bgk-3dad
binbinlotblock+1lotblockbinlotblock| 34833639Z |
| RESOLVE |
| 012810CJG03 |
| 1060779 |
| 1 |
| 02044 |
| 0020 |
| 20100325 |
| 1030 |
| 20100128 |
| 20100128 |
| 1226423 | 34870720Z | RESOLVE | 081910CSTFCS15 | 3071867 | 3 | 03150 | 0002 | 20101018 | 830 | 20100827 | 20100819 |
| 1215996 | 34056687J | RESOLVE | 051491C04EP02 | 3075774 | 3 | 03311 | 0001 | 19911230 | 1200 | 19910514 | 19910514 |
| 1652465 | 34793711K | RESOLVE | 092109C12JK02 | 4214942 | 4 | 10052 | 0023 | 20100406 | 830 | 20090921 | 20090921 |
| 1275619 | 36011144R | RESOLVE | 010710NRF | 3325882 | 3 | 03076 | 7501 | 20100325 | 1030 | 20100123 | 20100107 |
| 1368622 | 34561166L | RESOLVE | 01/29/07C13NS01 | 4224841 | 4 | 10551 | 0014 | 20070327 | 1030 | 20070129 | 20070129 |
| 1359685 | 34103884H | RESOLVE | 020294C13H1 | 4439453 | 4 | 08513 | 0002 | 19940405 | 1030 | 19940221 | 19940202 |
| 1225839 | 34767464N | RESOLVE | 051909C14GH01 | 3119687 | 3 | 05189 | 0036 | 20090713 | 830 | 20090522 | 20090519 |
| 1371606 | 34880814Z | RESOLVE | 100110A01SA03 | 4009419 | 4 | 00633 | 0025 | 20101123 | 830 | 20101001 | 20101001 |
Showing 12 of 30 columns. All of them are listed below.
| text |
| — |
| — |
| — |
lot | text | — | — | — |
hearing_date | text | — | — | — |
hearing_time | text | — | — | — |
served_date | text | — | — | — |
issue_date | text | — | — | — |
severity | text | — | — | — |
violation_type | text | — | — | — |
respondent_name | text | — | — | — |
respondent_house_number | text | — | — | — |
respondent_street | text | — | — | — |
respondent_city | text | — | — | — |
respondent_zip | text | — | — | — |
violation_description | text | — | — | — |
penality_imposed | numeric | — | — | — |
amount_paid | numeric | — | — | — |
balance_due | numeric | — | — | — |
infraction_code1 | text | — | — | — |
section_law_description1 | text | — | — | — |
infraction_code2 | text | — | — | — |
section_law_description2 | text | — | — | — |
infraction_code3 | text | — | — | — |
section_law_description3 | text | — | — | — |
infraction_code4 | text | — | — | — |
section_law_description4 | text | — | — | — |
infraction_code5 | text | — | — | — |
section_law_description5 | text | — | — | — |
infraction_code6 | text | — | — | — |
section_law_description6 | text | — | — | — |
infraction_code7 | text | — | — | — |
section_law_description7 | text | — | — | — |
infraction_code8 | text | — | — | — |
section_law_description8 | text | — | — | — |
infraction_code9 | text | — | — | — |
section_law_description9 | text | — | — | — |
infraction_code10 | text | — | — | — |
section_law_description10 | text | — | — | — |
aggravated_level | text | — | — | — |
hearing_status | text | — | — | — |
certification_status | text | — | — | — |