NYC Housing Data
NYC Affordable Housing Production Dataset
@kaggle.shreyapande0_nyc_affordable_housing_production
NYC Affordable Housing Production Dataset
@kaggle.shreyapande0_nyc_affordable_housing_production
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
);
Anyone who has the link will be able to view this.