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

Housing Maintenance Code Complaints and Problems

ygpa-z7crHousing & Development33 columns
The Department of Housing Preservation and Development (HPD) records complaints that are made by the public for conditions which violate the New York City Housing Maintenance Code (HMC) or the New York State Multiple Dwelling Law (MDL).
View on NYC Open Data↗

Quality

A93.2 / 100

From a 500-row sample across 33 columns.

completeness100/ 25% weight
consistency73/ 20% weight
accuracy93/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Handyman Work Order (HWO) Charges0.43
    joins onlotcommunity_boardlongitude+7
  • Open Market Order (OMO) Charges0.43
    joins onlotcommunity_boardlongitude+8
  • Housing Litigations0.42
    joins onlotlongitudelatitude+6
  • Buildings Selected for the Alternative Enforcement Program (AEP)0.42
    joins oncommunity_boardlongitudebuilding_id+6

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

received_dateproblem_idcomplaint_idbuilding_idboroughhouse_numberstreet_namepost_codeblocklotapartmentcommunity_board
2018-01-03T16:04:59.000181688928852631374378BROOKLYN1248ST MARKS AVENUE112131361431H8
2017-01-08T17:45:47.00017172242

Columns

33 queryable · 33 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
received_datedatetimeDate when the complaint was received0%2016-02-03T14:58:36.0002014-01-26T15:18:49.0002024-02-01T11:22:28.000
problem_idintegerUnique identifier of this problem0%282185228218532821855
complaint_idintegerUnique identifier of the complaint this problem is associated with0%785127567500246031266
building_idintegerUnique identifier given to a building record0%1144126131

Query this from your own app

GET /api/datasets/ygpa-z7cr
GET /api/datasets/ygpa-z7cr/quality
GET /api/datasets/ygpa-z7cr/related
GET /api/columns?dataset=ygpa-z7cr
  • Housing Maintenance Code Violations NYCHA properties0.41
    joins onlotcommunity_boardlongitude+6
  • DOB NOW: Certificate of Occupancy0.39
    joins onstreet_namelotborough+6
  • Fee Charges0.39
    joins onlotcommunity_boardlongitude+7
  • Buildings Subject to HPD Jurisdiction0.39
    joins onlotblockbin
    • 8340683
    1012317
    BRONX
    2170
    PROSPECT AVENUE
    10457
    3110
    54
    BLDG
    6
    2018-01-26T12:38:28.000182753728921612313392BROOKLYN2750HOMECREST AVENUE11235876410BLDG15
    2017-11-01T00:20:17.00017899006866867560670BRONX889DAWSON STREET1045926971BLDG2
    2017-11-01T21:03:41.00017902810867092819518MANHATTAN163EAST 115 STREET10029164325GF311
    2017-11-01T21:03:41.00017902812867092819518MANHATTAN163EAST 115 STREET10029164325GF311
    2017-11-01T21:03:41.00017902813867092819518MANHATTAN163EAST 115 STREET10029164325GF311
    2017-11-01T21:03:41.00017902814867092819518MANHATTAN163EAST 115 STREET10029164325GF311
    2017-11-01T21:03:41.00017902815867092819518MANHATTAN163EAST 115 STREET10029164325GF311
    2017-11-01T21:03:41.00017902816867092819518MANHATTAN163EAST 115 STREET10029164325GF311

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

    811407
    boroughcategoricalComplaint borough0%BROOKLYNBRONXMANHATTANof 5
    house_numbertextComplaint house number0%201530
    street_nametextComplaint street name0%GRAND CONCOURSEBROADWAYOCEAN AVENUE
    post_codetextComplaint zip code0%112261045810467
    blockinteger"Number assigned by DoF identifying the Tax block the lot is on"0%217431432136
    lotinteger"Unique number assigned by DoF within a Block identifying a lot"0%1610
    apartmenttextNumber of the unit or apartment in a building0%BLDG21
    community_boardinteger"Unique number identifying a Community District/Board, which is a political geographical area within a borough of the City of NY"0%1249
    unit_typecategoricalType of space where the problem was reported0%APARTMENTBUILDINGBUILDING-WIDEof 6
    space_typetextType of space where the problem was reported0%ENTIRE APARTMENTBATHROOMENTIRE BUILDING
    typecategoricalCode indicating the problem type0%EMERGENCYNON EMERGENCYIMMEDIATE EMERGENCYof 5
    major_categorycategoricalThe major category of the problem0%HEATINGHEAT/HOT WATERPLUMBINGof 17
    minor_categorytextThe minor category of the problem0%HEAT RELATEDENTIRE BUILDINGWALL
    problem_codetextThe problem code0%NO HEATNO HEAT& HOT WATERNO HOT WATER
    complaint_statuscategoricalThe status of the complaint0%CLOSEOPENof 2
    complaint_status_datedatetimeDate when the complaint status was updated0%2009-05-20T05:20:45.0002011-06-14T05:21:07.0002011-03-22T05:21:12.000
    problem_statuscategoricalThe status of the problem0%CLOSEOPENof 2
    problem_status_datedatetimeStatus description0%2008-06-30T15:34:38.0002011-09-29T14:08:27.0002008-06-17T14:33:23.000
    status_descriptiontext—0%The Department of Housin…The Department of Housin…The Department of Housin…
    problem_duplicate_flagcategoricalDuplicate complaint Indicator0%NYof 2
    complaint_anonymous_flagcategoricalAnonymous complaint Indicator10%NYof 2
    unique_keytextUnique identifier of a Service Request (SR) in the open data set * Ties to 31113%100000011000000210000003
    latitudefloat—0%40.85443899999999940.86193800000000240.747421000000003
    longitudefloat—0%-73.898422999999994-73.927145999999993-73.876852999999997
    council_districtinteger—0%151410
    census_tractinteger—0%225279245
    bininteger—0%201331710641974431449
    bblinteger—0%282185228218532821855
    ntatext—0%Washington Heights (Sout…Crown Heights (North)Flatbush