DHS Data Dashboard
City of New York
@usgov.city_of_new_york_dhs_data_dashboard
City of New York
@usgov.city_of_new_york_dhs_data_dashboard
This dataset displays demographics for the families and individuals residing in the Department of Homeless Services (DHS) shelter system.
Organization: City of New York
Last updated: 2020-11-10T17:00:47.234848
Tags: daily, dhs, homeless, report
CREATE TABLE table_1 (
"report_date" TIMESTAMP,
"fwc_avg_daily_census_individual_in_shelter_adults" BIGINT -- FWC Avg Daily Census Individual In Shelter - Adults,
"fwc_avg_daily_census_individual_in_shelter_children" BIGINT -- FWC Avg Daily Census Individual In Shelter - Children,
"fwc_avg_daily_census_individual_in_shelter_total" BIGINT -- FWC Avg Daily Census Individual In Shelter - Total,
"af_avg_daily_census_individual_in_shelter_adults" BIGINT -- AF Avg Daily Census Individual In Shelter - Adults,
"sa_avg_daily_census_individual_in_shelter_men" BIGINT -- SA Avg Daily Census Individual In Shelter - Men,
"sa_avg_daily_census_individual_in_shelter_women" BIGINT -- SA Avg Daily Census Individual In Shelter - Women,
"sa_avg_daily_census_individual_in_shelter_total" BIGINT -- SA Avg Daily Census Individual In Shelter - Total,
"fwc_unique_individuals_by_age_0_thru_5" BIGINT -- FWC Unique Individuals By Age - 0 Thru 5,
"fwc_unique_individuals_by_age_6_thru_13" BIGINT -- FWC Unique Individuals By Age - 6 Thru 13,
"fwc_unique_individuals_by_age_14_thru_17" BIGINT -- FWC Unique Individuals By Age - 14 Thru 17,
"fwc_unique_individuals_by_age_18_thru_20" BIGINT -- FWC Unique Individuals By Age- 18 Thru 20,
"fwc_unique_individuals_by_age_21_thru_29" BIGINT -- FWC Unique Individuals By Age - 21 Thru 29,
"fwc_unique_individuals_by_age_30_thru_44" BIGINT -- FWC Unique Individuals By Age - 30 Thru 44,
"fwc_unique_individuals_by_age_45_thru_64" BIGINT -- FWC Unique Individuals By Age - 45 Thru 64,
"fwc_unique_individuals_by_age_65_and_above" BIGINT -- FWC Unique Individuals By Age - 65 And Above,
"fwc_unique_individuals_by_age_total" BIGINT -- FWC Unique Individuals By Age - Total,
"af_unique_individuals_by_age_18_thru_20" BIGINT -- AF Unique Individuals By Age - 18 Thru 20,
"af_unique_individuals_by_age_21_thru_29" BIGINT -- AF Unique Individuals By Age - 21 Thru 29,
"af_unique_individuals_by_age_30_thru_44" BIGINT -- AF Unique Individuals By Age - 30 Thru 44,
"af_unique_individuals_by_age_45_thru_64" BIGINT -- AF Unique Individuals By Age - 45 Thru 64,
"af_unique_individuals_by_age_65_and_above" BIGINT -- AF Unique Individuals By Age - 65 And Above,
"af_unique_individuals_by_age_total" BIGINT -- AF Unique Individuals By Age - Total,
"sa_unique_individuals_by_age_18_thru_29" BIGINT -- SA Unique Individuals By Age - 18 Thru 29,
"sa_unique_individuals_by_age_30_thru_44" BIGINT -- SA Unique Individuals By Age - 30 Thru 44,
"sa_unique_individuals_by_age_45_thru_64" BIGINT -- SA Unique Individuals By Age - 45 Thru 64,
"sa_unique_individuals_by_age_65_and_above" BIGINT -- SA Unique Individuals By Age - 65 And Above,
"sa_unique_individuals_by_age_total" BIGINT -- SA Unique Individuals By Age - Total,
"fwc_race_ethnicity_hoh_asian_pacific_islander" BIGINT -- FWC Race/Ethnicity HoH - Asian/Pacific Islander,
"fwc_race_ethnicity_hoh_black_non_hispanic" BIGINT -- FWC Race/Ethnicity HoH - Black Non-Hispanic,
"fwc_race_ethnicity_hoh_hispanic" BIGINT -- FWC Race/Ethnicity HoH - Hispanic,
"fwc_race_ethnicity_hoh_native_american" BIGINT -- FWC Race/Ethnicity HoH - Native American,
"fwc_race_ethnicity_hoh_white_non_hispanic" BIGINT -- FWC Race/Ethnicity HoH - White Non-Hispanic,
"fwc_race_ethnicity_hoh_unknown" BIGINT -- FWC Race/Ethnicity HoH - Unknown,
"fwc_race_ethnicity_hoh_total_heads_of_households" BIGINT -- FWC Race/Ethnicity HoH - Total Heads Of Households,
"af_race_ethnicity_hoh_asian_pacific_islander" BIGINT -- AF Race/Ethnicity HoH - Asian/Pacific Islander,
"af_race_ethnicity_hoh_black_non_hispanic" BIGINT -- AF Race/Ethnicity HoH - Black Non-Hispanic,
"af_race_ethnicity_hoh_hispanic" BIGINT -- AF Race/Ethnicity HoH - Hispanic,
"af_race_ethnicity_hoh_native_american" BIGINT -- AF Race/Ethnicity HoH - Native American,
"af_race_ethnicity_hoh_white_non_hispanic" BIGINT -- AF Race/Ethnicity HoH - White Non-Hispanic,
"af_race_ethnicity_hoh_unknown" BIGINT -- AF Race/Ethnicity HoH - Unknown,
"af_race_ethnicity_hoh_total_heads_of_households" BIGINT -- AF Race/Ethnicity HoH - Total Heads Of Households,
"sa_race_ethnicity_hoh_asian_pacific_islander" BIGINT -- SA Race/Ethnicity HoH - Asian/Pacific Islander,
"sa_race_ethnicity_hoh_black_non_hispanic" BIGINT -- SA Race/Ethnicity HoH - Black Non-Hispanic,
"sa_race_ethnicity_hoh_hispanic" BIGINT -- SA Race/Ethnicity HoH - Hispanic,
"sa_race_ethnicity_hoh_native_american" DOUBLE -- SA Race/Ethnicity HoH - Native American,
"sa_race_ethnicity_hoh_white_non_hispanic" BIGINT -- SA Race/Ethnicity HoH - White Non-Hispanic,
"sa_race_ethnicity_hoh_unknown" BIGINT -- SA Race/Ethnicity HoH - Unknown,
"sa_race_ethnicity_hoh_total_individuals" BIGINT -- SA Race/Ethnicity HoH - Total Individuals,
"fwc_number_of_school_aged_children" BIGINT -- FWC - Number Of School-Aged Children,
"fwc_average_school_attendance_rate" VARCHAR -- FWC - Average School Attendance Rate,
"fwc_percent_of_families_successfully_placed_by_younges_afc77b91" DOUBLE -- FWC - Percent Of Families Successfully Placed By Youngest School-aged Child's School Address,
"home_stat_clients_placed_into_permanent_housing_transi_e4b0b8d4" VARCHAR -- HOME-STAT Clients Placed Into Permanent Housing, Transitional Housing, And Other Settings,
"total_homebase_enrollments" BIGINT,
"fwc_total_shelter_placements" BIGINT,
"af_total_shelter_placements" BIGINT,
"sa_total_shelter_placements" BIGINT,
"sa_shelter_exits_into_supportive_housing" BIGINT
);Anyone who has the link will be able to view this.