About this Dataset

NYCHA Resident Data Book Summary

Contains resident demographic data at a summary level.
The Resident Data Book is compiled to serve as an information source for queries involving resident demographic as well as a source of data for internal analysis. Statistics are compiled via HUD mandated annual income reviews involving NYCHA Staff and residents. Data is then aggregated and compiled by development. Each record pertains to a single public housing development.
Organization: City of New York
Last updated: 2020-11-10T17:00:50.814984
Tags: demographics-by-borough, nyc-housing, nycha, public-housing, resident-data-book, statistics

Tables

Table 1

@usgov.city_of_new_york_nycha_resident_data_book_summary.table_1

44.32 kB
26 rows
43 columns

CREATE TABLE table_1 (
  "program" VARCHAR,
  "statecity_section8_flag" VARCHAR,
  "total_families" BIGINT,
  "total_female_headed_families" BIGINT,
  "total_male_headed_families" BIGINT,
  "total_population" BIGINT,
  "average_family_size" DOUBLE,
  "total_minors_under_18" BIGINT,
  "average_minors_per_family" DOUBLE,
  "total_minors_as_percent_of_population" DOUBLE,
  "all_average_total_gross_income" VARCHAR,
  "all_average_gross_rent" VARCHAR,
  "total_hoh_62_years_and_over" BIGINT,
  "total_hoh_62_years_and_over_as_percent_of_families" DOUBLE,
  "total_female_headed_hoh_62_years_and_over" BIGINT,
  "total_male_headed_hoh_62_years_and_over" BIGINT,
  "total_elderly_single_person_families" BIGINT,
  "total_elderly_population" BIGINT,
  "total_62_years_and_over_as_percent_of_population" DOUBLE,
  "total_families_on_welfare" BIGINT,
  "total_families_on_welfare_and_hoh_elderly" BIGINT,
  "total_families_on_full_welfare" BIGINT,
  "total_families_on_welfare_as_percent_of_families" DOUBLE,
  "total_single_parent_grandparent_families_with_minors" BIGINT,
  "total_female_headed_single_parent_grandparent_with_minors" BIGINT,
  "total_male_headed_single_parent_grandparent_with_minors" BIGINT,
  "total_single_parent_grandparent_families_on_welfare" BIGINT,
  "total_single_parent_grandparent_with_minors_as_of_families" DOUBLE  -- Total Single Parent/Grandparent With Minors As % Of Families,
  "total_families_1_or_more_employed" BIGINT  -- Total Families - 1 Or More Employed,
  "total_families_1_or_more_employed_as_percent_of_families" DOUBLE  -- Total Families - 1 Or More Employed As Percent Of Families,
  "total_families_2nd_adult_employed" BIGINT  -- Total Families - 2nd Adult Employed,
  "all_families_average_years_in_public_housing" DOUBLE,
  "residents_under_4" BIGINT,
  "residents_4_to_5" BIGINT,
  "residents_6_to_9" BIGINT,
  "residents_10_to_13" BIGINT,
  "residents_14_to_17" BIGINT,
  "residents_18_to_20" BIGINT,
  "residents_21_to_49" BIGINT,
  "residents_50_to_61" BIGINT,
  "residents_62_plus" BIGINT,
  "total_fixed_income_families" BIGINT,
  "total_fixed_income_families_as_percent_of_families" DOUBLE
);