Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

DOB Complaints Received

eabe-havvHousing & Development15 columns
This is the universe of complaints received by Department of Buildings (DOB). It includes complaints that come from 311 or that are entered into the system by DOB staff. A Complaint Categories codes can be found at http://www1.nyc.gov/assets/buildings/pdf/bis_complaint_disposition_codes.pdf
View on NYC Open Data↗

Quality

A94.1 / 100

From a 500-row sample across 15 columns.

completeness93/ 25% weight
consistency80/ 20% weight
accuracy99/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • DOB Violations0.49
    joins onbinhouse_numberdisposition_date
  • DOB Stalled Construction Sites0.38
    joins oncommunity_boardbindobrundate+2
  • DOB ECB Violations0.37
    joins onbin
  • DOB Permit Issuance0.34
    joins onzip_codecommunity_boarddobrundate
  • DOB NOW: Build – Job Application Filings0.34

Geography

Has zip codes (`zip_code`) — joinable, but needs boundary shapes to draw.

Sample rows

complaint_numberstatusdate_enteredhouse_numberhouse_streetzip_codebincommunity_boardcomplaint_categoryunitdisposition_datedisposition_code
1450858CLOSED05/17/2017603WEST 29 STREET10001101227110452PLUMB05/22/2017I2
3025852CLOSED

Columns

15 queryable

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.

FieldTypeDescriptionNullValues
complaint_numbertextComplaint number starting with borough code: (1= Manhattan, 2= Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island)——
statustextStatus of Complaint——
date_enteredtextDate Complaint was Entered——
house_numbertextHouse Number of Complaint——
house_streettextHouse Street of Complaint——
zip_codetextZip code of complaint—

Query this from your own app

GET /api/datasets/eabe-havv
GET /api/datasets/eabe-havv/quality
GET /api/datasets/eabe-havv/related
GET /api/columns?dataset=eabe-havv
joins on
bin
  • DOB NOW: Build – Approved Permits0.32
    joins onzip_codecommunity_boardbin
  • DOB NOW: Build – Limited Alteration Applications0.32
    joins onzip_codecommunity_boardinspection_date
  • Housing Maintenance Code Violations0.31
    joins onbin
  • 11/02/1992
    578
    PACIFIC ST
    11217
    3395962
    306
    09
    BKLYN
    11/27/1992
    B1
    3192969CLOSED06/06/20062810BATCHELDER STREET11235324780231505BKLYN09/28/2007L2
    3279670CLOSED09/13/2008722EAST 4 STREET11218312710731274BKLYN10/03/2008I2
    3940421CLOSED12/22/202360BRIGHTON 10 STREET11235324518831335BKLYN11/15/2024I2
    2112569CLOSED04/10/20081479CROMWELL AVENUE10452200871720463ELEVR05/07/2008I2
    5001801CLOSED07/18/1989198HILLSIDE TERRACE10308506582850332ST.IS08/10/1989I2
    1482472CLOSED06/22/201812012 AVENUE1006510438641081LPLUMB06/25/2018A8
    5099203CLOSED08/04/201269DEHART AVENUE10303502744950104ERT12/10/2012I2
    2155658CLOSED02/11/20112185HONE AVENUE10461204959221184BRONX02/14/2011I2

    Showing 12 of 14 columns. All of them are listed below.

    —
    bintextNumber assigned by City Planning to a specific building——
    community_boardtext3-digit identifier: Borough code = first position, last 2 = community board——
    special_districttextIs Complaint in Special District——
    complaint_categorytextDOB Complaint Category Codes (01-Accident Construction/Plumbing, etc.)——
    unittextUnit dispositioning Complaint——
    disposition_datetextDate Complaint was Dispositioned——
    disposition_codetextDisposition Code of Complaint (A1-Building Violations Served, L1-Partial Stop Work Order,etc.)——
    inspection_datetextInspection Date of Complaint——
    dobrundatetextDate when query is run and pushed to Open Data. Could be used to differentiate report dates.——