Dataset: NYC Housing Data

About this Dataset

NYC Housing Data

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).

Last Updated: September 23, 2024
Data Provided By: Department of Housing Preservation and Development (HPD)

Tables

Nyc Affordable Housing

@kaggle.shreyapande0_nyc_affordable_housing_production.nyc_affordable_housing

670.34 KB
7637 rows
41 columns


CREATE TABLE nyc_affordable_housing (
  "project_id" BIGINT,
  "project_name" VARCHAR,
  "project_start_date" TIMESTAMP,
  "project_completion_date" TIMESTAMP,
  "building_id" DOUBLE,
  "number" VARCHAR,
  "street" VARCHAR,
  "borough" VARCHAR,
  "postcode" DOUBLE,
  "bbl" DOUBLE,
  "bin" DOUBLE,
  "community_board" VARCHAR,
  "council_district" BIGINT,
  "census_tract" DOUBLE,
  "nta_neighborhood_tabulation_area" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "latitude_internal" DOUBLE,
  "longitude_internal" DOUBLE,
  "building_completion_date" TIMESTAMP,
  "reporting_construction_type" VARCHAR,
  "extended_affordability_only" VARCHAR,
  "prevailing_wage_status" VARCHAR,
  "extremely_low_income_units" BIGINT,
  "very_low_income_units" BIGINT,
  "low_income_units" BIGINT,
  "moderate_income_units" BIGINT,
  "middle_income_units" BIGINT,
  "other_income_units" BIGINT,
  "studio_units" BIGINT,
  "n_1_br_units" BIGINT,
  "n_2_br_units" BIGINT,
  "n_3_br_units" BIGINT,
  "n_4_br_units" BIGINT,
  "n_5_br_units" BIGINT,
  "n_6_br_units" BIGINT,
  "unknown_br_units" BIGINT,
  "counted_rental_units" BIGINT,
  "counted_homeownership_units" BIGINT,
  "all_counted_units" BIGINT,
  "total_units" BIGINT
);