Baselight

NYC Housing Data

NYC Affordable Housing Production Dataset

@kaggle.shreyapande0_nyc_affordable_housing_production

Loading...
Loading...

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

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

Share link

Anyone who has the link will be able to view this.