From a 500-row sample across 15 columns.
binhouse_numberdisposition_datecommunity_boardbindobrundate+2binzip_codecommunity_boarddobrundateHas zip codes (`zip_code`) — joinable, but needs boundary shapes to draw.
| complaint_number | status | date_entered | house_number | house_street | zip_code | bin | community_board | complaint_category | unit | disposition_date | disposition_code |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1450858 | CLOSED | 05/17/2017 | 603 | WEST 29 STREET | 10001 | 1012271 | 104 | 52 | PLUMB | 05/22/2017 | I2 |
| 3025852 | CLOSED |
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 |
|---|---|---|---|---|
complaint_number | text | Complaint number starting with borough code: (1= Manhattan, 2= Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island) | — | — |
status | text | Status of Complaint | — | — |
date_entered | text | Date Complaint was Entered | — | — |
house_number | text | House Number of Complaint | — | — |
house_street | text | House Street of Complaint | — | — |
zip_code | text | Zip code of complaint | — |
GET /api/datasets/eabe-havv GET /api/datasets/eabe-havv/quality GET /api/datasets/eabe-havv/related GET /api/columns?dataset=eabe-havv
binzip_codecommunity_boardbinzip_codecommunity_boardinspection_datebin| 11/02/1992 |
| 578 |
| PACIFIC ST |
| 11217 |
| 3395962 |
| 306 |
| 09 |
| BKLYN |
| 11/27/1992 |
| B1 |
| 3192969 | CLOSED | 06/06/2006 | 2810 | BATCHELDER STREET | 11235 | 3247802 | 315 | 05 | BKLYN | 09/28/2007 | L2 |
| 3279670 | CLOSED | 09/13/2008 | 722 | EAST 4 STREET | 11218 | 3127107 | 312 | 74 | BKLYN | 10/03/2008 | I2 |
| 3940421 | CLOSED | 12/22/2023 | 60 | BRIGHTON 10 STREET | 11235 | 3245188 | 313 | 35 | BKLYN | 11/15/2024 | I2 |
| 2112569 | CLOSED | 04/10/2008 | 1479 | CROMWELL AVENUE | 10452 | 2008717 | 204 | 63 | ELEVR | 05/07/2008 | I2 |
| 5001801 | CLOSED | 07/18/1989 | 198 | HILLSIDE TERRACE | 10308 | 5065828 | 503 | 32 | ST.IS | 08/10/1989 | I2 |
| 1482472 | CLOSED | 06/22/2018 | 1201 | 2 AVENUE | 10065 | 1043864 | 108 | 1L | PLUMB | 06/25/2018 | A8 |
| 5099203 | CLOSED | 08/04/2012 | 69 | DEHART AVENUE | 10303 | 5027449 | 501 | 04 | ERT | 12/10/2012 | I2 |
| 2155658 | CLOSED | 02/11/2011 | 2185 | HONE AVENUE | 10461 | 2049592 | 211 | 84 | BRONX | 02/14/2011 | I2 |
Showing 12 of 14 columns. All of them are listed below.
| — |
bin | text | Number assigned by City Planning to a specific building | — | — |
community_board | text | 3-digit identifier: Borough code = first position, last 2 = community board | — | — |
special_district | text | Is Complaint in Special District | — | — |
complaint_category | text | DOB Complaint Category Codes (01-Accident Construction/Plumbing, etc.) | — | — |
unit | text | Unit dispositioning Complaint | — | — |
disposition_date | text | Date Complaint was Dispositioned | — | — |
disposition_code | text | Disposition Code of Complaint (A1-Building Violations Served, L1-Partial Stop Work Order,etc.) | — | — |
inspection_date | text | Inspection Date of Complaint | — | — |
dobrundate | text | Date when query is run and pushed to Open Data. Could be used to differentiate report dates. | — | — |