NYCHA Development Data Book
City of New York
@usgov.city_of_new_york_nycha_development_data_book
City of New York
@usgov.city_of_new_york_nycha_development_data_book
CREATE TABLE table_1 (
"data_as_of" TIMESTAMP,
"development" VARCHAR,
"hud_amp" VARCHAR,
"tds" VARCHAR,
"consolidated_tds" VARCHAR,
"development_edp" VARCHAR,
"operating_edp" VARCHAR,
"hud" VARCHAR,
"program" VARCHAR,
"method" VARCHAR,
"type" VARCHAR,
"number_of_section_8_transition_apartments" DOUBLE,
"number_of_current_apartments" DOUBLE,
"total_number_of_apartments" DOUBLE,
"number_of_rental_rooms" DOUBLE,
"avg_no_r_r_per_apartment" DOUBLE,
"population_section_8_transition" DOUBLE,
"population_public_housing" DOUBLE,
"total_population" DOUBLE,
"total_of_fixed_income_household" DOUBLE,
"percent_fixed_income_households" DOUBLE,
"number_of_residential_bldgs" DOUBLE,
"number_of_non_residential_bldgs" DOUBLE,
"number_of_stairhalls" DOUBLE,
"number_of_stories" VARCHAR,
"total_area_sq_ft" DOUBLE,
"acres" DOUBLE,
"net_dev_area_sq_ft" DOUBLE,
"excluding_park_acres" DOUBLE,
"bldg_coverage_sq_ft" DOUBLE,
"cubage_cu_ft" DOUBLE,
"bldg_coverage" VARCHAR,
"density" DOUBLE,
"development_cost" VARCHAR,
"per_rental_room" VARCHAR,
"avg_monthly_gross_rent" VARCHAR,
"location_street_a" VARCHAR,
"location_street_b" VARCHAR,
"location_street_c" VARCHAR,
"location_street_d" VARCHAR,
"borough" VARCHAR,
"community_distirct" VARCHAR,
"us_congressional_district" VARCHAR,
"ny_state_senate_district" VARCHAR,
"ny_state_assembly_district" VARCHAR,
"ny_city_council_district" VARCHAR,
"completion_date" TIMESTAMP,
"federalized_development" VARCHAR,
"senior_development" VARCHAR,
"electricity_paid_by_residents" VARCHAR,
"private_management" VARCHAR,
"rad_transferred_date" TIMESTAMP
);
Anyone who has the link will be able to view this.