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

Affordable Housing Production by Building

hg8x-zxprHousing & Development41 columns
The Department of Housing Preservation and Development (HPD) reports on projects, buildings, and units that began after January 1, 2014, and are counted towards either the Housing New York plan (1/1/2014 – 12/31/2021) or the Housing Our Neighbors: A Blueprint for Housing & Homelessness plan (1/1/2022 – present).
View on NYC Open Data↗

Quality

B81.5 / 100

From a 500-row sample across 41 columns.

completeness63/ 25% weight
consistency61/ 20% weight
accuracy94/ 20% weight
timeliness99/ 15% weight
usability100/ 20% weight
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Affordable Housing Production by Project0.75
    joins onprevailing_wage_statusextended_affordability_statuscounted_rental_units+9
  • Housing Maintenance Code Violations0.43
    joins onlatitudebinbbl+1
  • DOB Certificate Of Occupancy0.41
    joins oncouncil_districtstreet_namelatitude+8
  • Housing Litigations0.39
    joins oncouncil_district

Geography

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

Open on the map →

Sample rows

project_idproject_nameproject_start_datebuilding_idhouse_numberstreet_nameboroughpostcodebblbincommunity_boardcouncil_district
68872177-06 WEXFORD TERRACE2026-06-30T00:00:00.000991637177-06WEXFORD TERRACEQueens1143240983500234000000QN-0824
72436

Columns

41 queryable · 41 profiled

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

FieldTypeDescriptionNullValues
project_idtextThe Project ID is a unique numeric identifier assigned to each project by HPD.0%751735301768530
project_nametextThe Project Name is the name assigned to the project by HPD.0%CONFIDENTIALEASTCHESTER HEIGHTS HDFC…Nehemiah Spring Creek Ho…
project_start_datedatetimeThe Project Start Date is the date of the project loan closing and regulatory agreement — or the notice of intent to market affordable units.0%2021-06-30T00:00:00.0002024-12-19T00:00:00.0002026-06-30T00:00:00.000
project_completion_datedatetimeThe Project Completion Date is the date that the last building in the project was completed. If the project has not yet completed, then the field is blank.

Query this from your own app

GET /api/datasets/hg8x-zxpr
GET /api/datasets/hg8x-zxpr/quality
GET /api/datasets/hg8x-zxpr/related
GET /api/columns?dataset=hg8x-zxpr
latitude
bin
+3
  • Multiple Dwelling Registrations0.38
    joins onbin
  • DOB ECB Violations0.37
    joins onbin
  • Housing Maintenance Code Complaints and Problems0.37
    joins oncouncil_districtstreet_namebuilding_id+8
  • Open Market Order (OMO) Charges0.36
    joins oncouncil_districtlatitudebin+4
    • ST. NICK'S. 819 GRAND STREET
    2026-06-30T00:00:00.000
    1021347
    819
    GRAND STREET
    Brooklyn
    11211
    3029220001
    3070436
    BK-01
    34
    72449BREMOND KING DAVIS.YR15.FY262026-06-30T00:00:00.00021199127EDGECOMBE AVENUEManhattan1003010204800371060911MN-109
    72449BREMOND KING DAVIS.YR15.FY262026-06-30T00:00:00.00028145602ST NICHOLAS AVENUEManhattan1003010204800471060920MN-109
    72449BREMOND KING DAVIS.YR15.FY262026-06-30T00:00:00.00040555129WEST 133 STREETManhattan1003010191800181058219MN-109
    72449BREMOND KING DAVIS.YR15.FY262026-06-30T00:00:00.00040578163WEST 133 STREETManhattan1003010191800081058213MN-109
    72449BREMOND KING DAVIS.YR15.FY262026-06-30T00:00:00.00040586171WEST 133 STREETManhattan1003010191800051058209MN-109
    72559NRP-FOXY-SELFHELP. SOL ON PARK2026-06-30T00:00:00.00010220253728PARK AVENUEBronx1045620242200302000000BX-0316
    73047FOXY. 1016 BEACH 19TH ST.2026-06-30T00:00:00.000101237220-OctBEACH 19 STREETQueens1169141556000084000000QN-1431
    744452629 SEDGWICK AVE.HRP.FY262026-06-30T00:00:00.0001084962629SEDGWICK AVENUEBronx1046820323701082015143BX-0714

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

    19%
    2019-06-20T00:00:00.0002024-06-25T00:00:00.0002019-05-28T00:00:00.000
    building_idintegerThe Building ID is a unique numeric identifier assigned to each building by HPD.20%967819295952213417
    house_numbertextThe House Number is the street number in the building’s address. E.g., the house number is ‘100’ in ‘100 Gold Street.’0%----120100
    street_nametextThe Street Name is the name of the street in the building’s address. E.g., the street name is ‘Gold Street’ in ‘100 Gold Street.’0%----NEW YORK AVENUESCHROEDERS AVENUE
    boroughcategoricalThe Borough is the borough where the building is located.0%BrooklynBronxManhattanof 5
    postcodeintegerZip code21%112211123311207
    bblintegerThe BBL (Borough, Block, and Lot) is a unique identifier for each tax lot in the City.21%205141012050127200114092470001
    binintegerThe BIN (Building Identification Number) is a unique identifier for each building in the City.21%300000020000004000000
    community_boardtextThe Community Board field indicates the New York City Community District where the building is located.0%BK-05BK-03BX-12
    council_districtintegerThe Council District indicates the New York City Council District where the building is located.0%42936
    census_tracttextThe Census Tract indicates the 2010 U.S. Census Tract where the building is located.21%107001386363
    neighborhood_tabulation_areatextThe Neighborhood Tabulation Area indicates the New York City Neighborhood Tabulation Area where the building is located.21%BK82MN03BK61
    latitudefloatThe Latitude and Longitude specify the location of the property on the earth’s surface. The coordinates provided are an estimate of the location based on the street segment and address range.21%40.75087140.75085240.686032
    longitudefloatThe Latitude and Longitude specify the location of the property on the earth’s surface. The coordinates provided are an estimate of the location based on the street segment and address range.21%-74.171256-74.171244-74.171236
    latitude_internalfloatThe Latitude (Internal) and Longitude (Internal) specify the location of the property on the earth’s surface. The coordinates provided are of the internal centroid derived from the tax lot.21%40.87501340.63910440.707269
    longitude_internalfloatThe Latitude (Internal) and Longitude (Internal) specify the location of the property on the earth’s surface. The coordinates provided are of the internal centroid derived from the tax lot.21%-73.828362-74.170235-73.826503
    building_completion_datedatetimeThe Building Completion Date is the date the building was completed. The field is blank if the building has not completed.17%2019-06-20T00:00:00.0002017-12-31T00:00:00.0002026-06-30T00:00:00.000
    reporting_construction_typecategoricalThe Reporting Construction Type field indicates whether the building is categorized as ‘new construction’ or ‘preservation’ in Housing New York statistics. Note that some preservation projects included here may not actually involve construction, because they extend the project’s regulatory restrictions but do not require rehabilitation.0%PreservationNew Constructionof 2
    extended_affordability_statuscategoricalThe Extended Affordability Only field indicates whether the project is considered to be Extended Affordability. An extended affordability project involves no construction, but secures an extended or new regulatory agreement. All extended affordability projects have a ‘reporting construction type’ of ‘preservation.’0%NoYesof 2
    prevailing_wage_statuscategoricalThe Prevailing Wage Status field indicates whether the project is subject to prevailing wage requirements, such as Davis Bacon.0%Non Prevailing WagePrevailing Wageof 2
    extremely_low_income_unitsintegerExtremely Low Income Units are units with rents that are affordable to households earning 0 to 30% of the area median income (AMI).78%123
    very_low_income_unitsintegerVery Low Income Units are units with rents that are affordable to households earning 31 to 50% of the area median income (AMI).64%123
    low_income_unitsintegerLow Income Units are units with rents that are affordable to households earning 51 to 80% of the area median income (AMI).42%123
    moderate_income_unitsintegerModerate Income Units are units with rents that are affordable to households earning 81 to 120% of the area median income (AMI).82%123
    middle_income_unitsintegerMiddle Income Units are units with rents that are affordable to households earning 121 to 165% of the area median income (AMI).72%321
    other_income_unitscategoricalOther Units are units reserved for building superintendents.86%123of 5
    studio_unitsintegerStudio Units are units with 0-bedrooms.67%123
    _1_br_unitsinteger1-BR Units are units with 1-bedroom.36%132
    _2_br_unitsinteger2-BR Units are units with 2-bedrooms.37%123
    _3_br_unitsinteger3-BR Units are units with 3-bedrooms.64%123
    _4_br_unitsinteger4-BR Units are units with 4-bedrooms.94%124
    _5_br_unitscategorical5-BR Units are units with 5-bedrooms.99%125of 11
    _6_br_unitscategorical6-BR+ Units are units with 6-bedrooms or more.100%132of 5
    unknown_br_unitsintegerUnknown-BR Units are units with an unknown number of bedrooms.93%123
    counted_rental_unitsintegerCounted Rental Units are the units in the building, counted toward the Housing New York plan, where assistance has been provided to landlords in exchange for a requirement for affordable units.27%386
    counted_homeownership_unitsintegerCounted Homeownership Units are the units in the building, counted toward the Housing New York Plan, where assistance has been provided directly to homeowners.71%123
    all_counted_unitsintegerThe Counted Units field indicates the total number of affordable units, counted towards the Housing New York plan, that are in the building.0%132
    total_unitsintegerThe Total Units field indicates the total number of units, affordable and market rate, in each building.0%182