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

Buildings Subject to HPD Jurisdiction

kj4p-ruqcHousing & Development23 columns
Pursuant to New York City’s Housing Maintenance Code, the Department of Housing Preservation and Development (HPD) collects information on multiple dwellings in New York City, and other buildings that fall under its jurisdiction. HPD’s Buildings Open Data covers all buildings which meet any of the following criteria: a. HPD has required the owner to register the building under the Housing Maintenance Code (HMC) b. HPD has initiated a litigation action under the HMC c. HPD has received a complaint for the building d. HPD has initiated a work order for the purposes of emergency repair, demolition, or the Alternative Enforcement Program (AEP) for the building e. HPD has added the property to the AEP program Buildings are identified by a BuildingID.
View on NYC Open Data↗

Quality

A90.5 / 100

From a 500-row sample across 23 columns.

completeness99/ 25% weight
consistency70/ 20% weight
accuracy94/ 20% weight
timeliness100/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Multiple Dwelling Registrations0.55
    joins onregistrationidlowhousenumbercommunityboard+10
  • Housing Litigations0.50
    joins onlotstreetnameblock+5
  • Open Market Order (OMO) Charges0.45
    joins onlotstreetnameblock+6
  • Registration Contacts0.45
    joins onregistrationid
  • Housing Maintenance Code Violations

Geography

Has borough codes (`boro`) — joinable, but needs boundary shapes to draw.

Sample rows

buildingidboroidborohousenumberlowhousenumberhighhousenumberstreetnameblocklotcommunityboardmanagementprogramregistrationid
8591293BROOKLYN0000000PVT0
9359132BRONX

Columns

23 queryable · 23 profiled

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

FieldTypeDescriptionNullValues
buildingidintegerUnique identifier of building0%475040881753461061
boroidcategoricalUnique number identifying a borough0%342of 5
borocategoricalBoro code (1 = Manhattan, 2 = Bronx, 3 = Brooklyn, 4 = Queens, 5 = Staten Island)0%BROOKLYNQUEENSBRONXof 5
housenumbertextAddress information for the building0%152011

Query this from your own app

GET /api/datasets/kj4p-ruqc
GET /api/datasets/kj4p-ruqc/quality
GET /api/datasets/kj4p-ruqc/related
GET /api/columns?dataset=kj4p-ruqc
0.43
joins onregistrationidlowhousenumbercommunityboard+11
  • Affordable Housing Production by Project0.42
  • DOB NOW: Certificate of Occupancy0.42
    joins onlotblockbin
  • Buildings Selected for the Alternative Enforcement Program (AEP)0.41
    joins onbinboro
  • 00
    00
    00
    00
    0
    0
    0
    PVT
    0
    5107114QUEENS198-06198-06198-06100 AVENUE10865312PVT0
    5108654QUEENS219-40219-40219-40100 AVENUE1077312113PVT0
    5108514QUEENS218-33218-33218-33100 AVENUE107684613PVT0
    5108884QUEENS222-18222-18222-18100 AVENUE10803813PVT0
    8335054QUEENS218-50218-50218-50100 AVENUE107672813PVT0
    5108234QUEENS217-40217-40217-40100 AVENUE107612513PVT418747
    5106654QUEENS193-01193-01193-01100 AVENUE10840112PVT0
    5106714QUEENS193-14193-14193-14100 AVENUE108604412PVT0

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

    lowhousenumber
    text
    Address information for the building
    0%
    152011
    highhousenumbertextAddress information for the building0%152019
    streetnametextAddress information for the building0%BROADWAY5 AVENUE3 AVENUE
    ziptextAddress information for the building0%112071122111208
    blockintegerTax block for building0%034325141
    lotintegerTax lot for building0%175016
    binintegerDCP Building Identification Number for building3%300000004000000
    communityboardintegerUnique number identifying a Community District/Board, which is a political geographical area within a borough of the City of NY0%1213
    censustracttextGeographic area defined by the U.S. Census Bureau for the various decennial censuses0%7512277
    managementprogramcategoricalContains the current active management program which determines who is responsible for the management of this building0%PVTNYCHACENTRAL MGTof 15
    dobbuildingclassidintegerUnique number identifying DoB Building Class Code4%24252
    dobbuildingclasstextStores DoB building classification codes as augmented by HPD for other than Multiple Dwellings (see DoBBuildingClass below)4%NOT AVAILABLE2 FAMILY HOUSENEW LAW TENEMENT
    legalstoriesintegerNumber of legal stories in building4%234
    legalclassaintegerThe number of apartments in a multiple dwelling4%231
    legalclassbintegerThe number of rooms in a multiple dwelling without individual baths and kitchens6%078
    registrationidintegerMultiple dwelling registration number, used by HPD in the master building file to identify a building0%0399995199995
    lifecyclecategoricalThe stage in the building life cycle0%BuildingDemolishedLandof 6
    recordstatusidcategoricalUnique number for record status0%123of 3
    recordstatuscategorical"The numeric value of the status of this building code (1 = Active, 2 = Inactive, 3 = Pending)"0%ActiveInactivePendingof 3