Pittsburgh American Community Survey Data 2015 - Household Types
Allegheny County / City of Pittsburgh / Western PA Regional Data Center
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_501b25ad
Allegheny County / City of Pittsburgh / Western PA Regional Data Center
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_501b25ad
CREATE TABLE household_type_all_races (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_family_households" DOUBLE,
"margin_of_error_family_households" DOUBLE,
"estimate_family_households_married_couple_family" DOUBLE,
"margin_of_error_family_households_married_couple_family" DOUBLE,
"estimate_family_households_other_family" DOUBLE,
"margin_of_error_family_households_other_family" DOUBLE,
"estimate_family_households_other_family_male_household_ffc4ae3e" DOUBLE,
"margin_of_error_family_households_other_family_male_ho_00ff797b" DOUBLE,
"estimate_family_households_other_family_female_househo_4ac08ba5" DOUBLE,
"margin_of_error_family_households_other_family_female__aabc65d2" DOUBLE,
"estimate_nonfamily_households" DOUBLE,
"margin_of_error_nonfamily_households" DOUBLE,
"estimate_nonfamily_households_householder_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_living_alone" DOUBLE,
"estimate_nonfamily_households_householder_not_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_not_l_7a126f8a" DOUBLE
);
CREATE TABLE household_type_asian_alone (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_family_households" DOUBLE,
"margin_of_error_family_households" DOUBLE,
"estimate_family_households_married_couple_family" DOUBLE,
"margin_of_error_family_households_married_couple_family" DOUBLE,
"estimate_family_households_other_family" DOUBLE,
"margin_of_error_family_households_other_family" DOUBLE,
"estimate_family_households_other_family_male_household_ffc4ae3e" DOUBLE,
"margin_of_error_family_households_other_family_male_ho_00ff797b" DOUBLE,
"estimate_family_households_other_family_female_househo_4ac08ba5" DOUBLE,
"margin_of_error_family_households_other_family_female__aabc65d2" DOUBLE,
"estimate_nonfamily_households" DOUBLE,
"margin_of_error_nonfamily_households" DOUBLE,
"estimate_nonfamily_households_householder_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_living_alone" DOUBLE,
"estimate_nonfamily_households_householder_not_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_not_l_7a126f8a" DOUBLE
);
CREATE TABLE household_type_black_or_african_american_alone (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_family_households" DOUBLE,
"margin_of_error_family_households" DOUBLE,
"estimate_family_households_married_couple_family" DOUBLE,
"margin_of_error_family_households_married_couple_family" DOUBLE,
"estimate_family_households_other_family" DOUBLE,
"margin_of_error_family_households_other_family" DOUBLE,
"estimate_family_households_other_family_male_household_ffc4ae3e" DOUBLE,
"margin_of_error_family_households_other_family_male_ho_00ff797b" DOUBLE,
"estimate_family_households_other_family_female_househo_4ac08ba5" DOUBLE,
"margin_of_error_family_households_other_family_female__aabc65d2" DOUBLE,
"estimate_nonfamily_households" DOUBLE,
"margin_of_error_nonfamily_households" DOUBLE,
"estimate_nonfamily_households_householder_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_living_alone" DOUBLE,
"estimate_nonfamily_households_householder_not_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_not_l_7a126f8a" DOUBLE
);
CREATE TABLE household_type_hispanic_or_latino (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_family_households" DOUBLE,
"margin_of_error_family_households" DOUBLE,
"estimate_family_households_married_couple_family" DOUBLE,
"margin_of_error_family_households_married_couple_family" DOUBLE,
"estimate_family_households_other_family" DOUBLE,
"margin_of_error_family_households_other_family" DOUBLE,
"estimate_family_households_other_family_male_household_ffc4ae3e" DOUBLE,
"margin_of_error_family_households_other_family_male_ho_00ff797b" DOUBLE,
"estimate_family_households_other_family_female_househo_4ac08ba5" DOUBLE,
"margin_of_error_family_households_other_family_female__aabc65d2" DOUBLE,
"estimate_nonfamily_households" DOUBLE,
"margin_of_error_nonfamily_households" DOUBLE,
"estimate_nonfamily_households_householder_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_living_alone" DOUBLE,
"estimate_nonfamily_households_householder_not_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_not_l_7a126f8a" DOUBLE
);
CREATE TABLE household_type_native_hawaiian_and_other_pacific_islander_alone (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_family_households" DOUBLE,
"margin_of_error_family_households" DOUBLE,
"estimate_family_households_married_couple_family" DOUBLE,
"margin_of_error_family_households_married_couple_family" DOUBLE,
"estimate_family_households_other_family" DOUBLE,
"margin_of_error_family_households_other_family" DOUBLE,
"estimate_family_households_other_family_male_household_ffc4ae3e" DOUBLE,
"margin_of_error_family_households_other_family_male_ho_00ff797b" DOUBLE,
"estimate_family_households_other_family_female_househo_4ac08ba5" DOUBLE,
"margin_of_error_family_households_other_family_female__aabc65d2" DOUBLE,
"estimate_nonfamily_households" DOUBLE,
"margin_of_error_nonfamily_households" DOUBLE,
"estimate_nonfamily_households_householder_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_living_alone" DOUBLE,
"estimate_nonfamily_households_householder_not_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_not_l_7a126f8a" DOUBLE
);
CREATE TABLE household_type_some_other_race_alone (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_family_households" DOUBLE,
"margin_of_error_family_households" DOUBLE,
"estimate_family_households_married_couple_family" DOUBLE,
"margin_of_error_family_households_married_couple_family" DOUBLE,
"estimate_family_households_other_family" DOUBLE,
"margin_of_error_family_households_other_family" DOUBLE,
"estimate_family_households_other_family_male_household_ffc4ae3e" DOUBLE,
"margin_of_error_family_households_other_family_male_ho_00ff797b" DOUBLE,
"estimate_family_households_other_family_female_househo_4ac08ba5" DOUBLE,
"margin_of_error_family_households_other_family_female__aabc65d2" DOUBLE,
"estimate_nonfamily_households" DOUBLE,
"margin_of_error_nonfamily_households" DOUBLE,
"estimate_nonfamily_households_householder_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_living_alone" DOUBLE,
"estimate_nonfamily_households_householder_not_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_not_l_7a126f8a" DOUBLE
);
CREATE TABLE household_type_two_or_more_races (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_family_households" DOUBLE,
"margin_of_error_family_households" DOUBLE,
"estimate_family_households_married_couple_family" DOUBLE,
"margin_of_error_family_households_married_couple_family" DOUBLE,
"estimate_family_households_other_family" DOUBLE,
"margin_of_error_family_households_other_family" DOUBLE,
"estimate_family_households_other_family_male_household_ffc4ae3e" DOUBLE,
"margin_of_error_family_households_other_family_male_ho_00ff797b" DOUBLE,
"estimate_family_households_other_family_female_househo_4ac08ba5" DOUBLE,
"margin_of_error_family_households_other_family_female__aabc65d2" DOUBLE,
"estimate_nonfamily_households" DOUBLE,
"margin_of_error_nonfamily_households" DOUBLE,
"estimate_nonfamily_households_householder_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_living_alone" DOUBLE,
"estimate_nonfamily_households_householder_not_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_not_l_7a126f8a" DOUBLE
);
CREATE TABLE household_type_white_alone (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_family_households" DOUBLE,
"margin_of_error_family_households" DOUBLE,
"estimate_family_households_married_couple_family" DOUBLE,
"margin_of_error_family_households_married_couple_family" DOUBLE,
"estimate_family_households_other_family" DOUBLE,
"margin_of_error_family_households_other_family" DOUBLE,
"estimate_family_households_other_family_male_household_ffc4ae3e" DOUBLE,
"margin_of_error_family_households_other_family_male_ho_00ff797b" DOUBLE,
"estimate_family_households_other_family_female_househo_4ac08ba5" DOUBLE,
"margin_of_error_family_households_other_family_female__aabc65d2" DOUBLE,
"estimate_nonfamily_households" DOUBLE,
"margin_of_error_nonfamily_households" DOUBLE,
"estimate_nonfamily_households_householder_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_living_alone" DOUBLE,
"estimate_nonfamily_households_householder_not_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_not_l_7a126f8a" DOUBLE
);
CREATE TABLE household_type_white_alone_not_hispanic_or_latino (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_family_households" DOUBLE,
"margin_of_error_family_households" DOUBLE,
"estimate_family_households_married_couple_family" DOUBLE,
"margin_of_error_family_households_married_couple_family" DOUBLE,
"estimate_family_households_other_family" DOUBLE,
"margin_of_error_family_households_other_family" DOUBLE,
"estimate_family_households_other_family_male_household_ffc4ae3e" DOUBLE,
"margin_of_error_family_households_other_family_male_ho_00ff797b" DOUBLE,
"estimate_family_households_other_family_female_househo_4ac08ba5" DOUBLE,
"margin_of_error_family_households_other_family_female__aabc65d2" DOUBLE,
"estimate_nonfamily_households" DOUBLE,
"margin_of_error_nonfamily_households" DOUBLE,
"estimate_nonfamily_households_householder_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_living_alone" DOUBLE,
"estimate_nonfamily_households_householder_not_living_alone" DOUBLE,
"margin_of_error_nonfamily_households_householder_not_l_7a126f8a" DOUBLE
);
Anyone who has the link will be able to view this.