Name: NYC Housing Data
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

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

686.43 kB
7,637 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  -- NTA - Neighborhood Tabulation Area,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "latitude_internal" DOUBLE  -- Latitude (Internal),
  "longitude_internal" DOUBLE  -- Longitude (Internal),
  "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  -- 1-BR Units,
  "n_2_br_units" BIGINT  -- 2-BR Units,
  "n_3_br_units" BIGINT  -- 3-BR Units,
  "n_4_br_units" BIGINT  -- 4-BR Units,
  "n_5_br_units" BIGINT  -- 5-BR Units,
  "n_6_br_units" BIGINT  -- 6-BR+ Units,
  "unknown_br_units" BIGINT,
  "counted_rental_units" BIGINT,
  "counted_homeownership_units" BIGINT,
  "all_counted_units" BIGINT,
  "total_units" BIGINT
);