About this Dataset

NYCHA Development Data Book

Contains the main body of the "Development Data Book". The Development Data Book lists all of the Authority's Developments alphabetically and includes information on the development identification numbers, program and construction type, number of apartments and rental rooms, population, number of buildings and stories, street boundaries, and political districts.
Organization: City of New York
Last updated: 2020-11-10T17:02:47.260514
Tags: development-data-book, developments, locations, nyc-housing, nycha, programs, public-housing, statistics

Tables

Table 1

@usgov.city_of_new_york_nycha_development_data_book.table_1

106.81 kB
346 rows
52 columns

CREATE TABLE table_1 (
  "data_as_of" TIMESTAMP,
  "development" VARCHAR,
  "hud_amp" VARCHAR  -- HUD AMP#,
  "tds" VARCHAR  -- TDS#,
  "consolidated_tds" VARCHAR  -- CONSOLIDATED TDS#,
  "development_edp" VARCHAR  -- DEVELOPMENT EDP#,
  "operating_edp" VARCHAR  -- OPERATING EDP#,
  "hud" VARCHAR  -- HUD #,
  "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  -- TOTAL # OF FIXED INCOME HOUSEHOLD,
  "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  -- BLDG COVERAGE %,
  "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
);