Pittsburgh American Community Survey 2014 - Miscellaneous Data
Allegheny County / City of Pittsburgh / Western PA Regional Data Center
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472
About this Dataset
Pittsburgh American Community Survey 2014 - Miscellaneous Data
Miscellaneous Reports from the 2014 American Community Survey Report
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:11:53.558690
Tags: acs, age, american-community-survey, census, community, demographics, education, employment, health-insurance, healthcare, housing, income, mortgage, population, public-assistance, race, rent, retirement, salary, survey, wage
Tables
Age Of Householder By Household Income In The Past 12 Months
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.age_of_householder_by_household_income_in_the_past_12_months
- 201.24 KB
- 91 rows
- 140 columns
Loading...
CREATE TABLE age_of_householder_by_household_income_in_the_past_12_months (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_householder_under_25_years" DOUBLE,
"margin_of_error_householder_under_25_years" DOUBLE,
"estimate_householder_under_25_years_less_than_10_000" DOUBLE,
"margin_of_error_householder_under_25_years_less_than_10_000" DOUBLE,
"estimate_householder_under_25_years_10_000_to_14_999" DOUBLE,
"margin_of_error_householder_under_25_years_10_000_to_14_999" DOUBLE,
"estimate_householder_under_25_years_15_000_to_19_999" DOUBLE,
"margin_of_error_householder_under_25_years_15_000_to_19_999" DOUBLE,
"estimate_householder_under_25_years_20_000_to_24_999" DOUBLE,
"margin_of_error_householder_under_25_years_20_000_to_24_999" DOUBLE,
"estimate_householder_under_25_years_25_000_to_29_999" DOUBLE,
"margin_of_error_householder_under_25_years_25_000_to_29_999" DOUBLE,
"estimate_householder_under_25_years_30_000_to_34_999" DOUBLE,
"margin_of_error_householder_under_25_years_30_000_to_34_999" DOUBLE,
"estimate_householder_under_25_years_35_000_to_39_999" DOUBLE,
"margin_of_error_householder_under_25_years_35_000_to_39_999" DOUBLE,
"estimate_householder_under_25_years_40_000_to_44_999" DOUBLE,
"margin_of_error_householder_under_25_years_40_000_to_44_999" DOUBLE,
"estimate_householder_under_25_years_45_000_to_49_999" DOUBLE,
"margin_of_error_householder_under_25_years_45_000_to_49_999" DOUBLE,
"estimate_householder_under_25_years_50_000_to_59_999" DOUBLE,
"margin_of_error_householder_under_25_years_50_000_to_59_999" DOUBLE,
"estimate_householder_under_25_years_60_000_to_74_999" DOUBLE,
"margin_of_error_householder_under_25_years_60_000_to_74_999" DOUBLE,
"estimate_householder_under_25_years_75_000_to_99_999" DOUBLE,
"margin_of_error_householder_under_25_years_75_000_to_99_999" DOUBLE,
"estimate_householder_under_25_years_100_000_to_124_999" DOUBLE,
"margin_of_error_householder_under_25_years_100_000_to_124_999" DOUBLE,
"estimate_householder_under_25_years_125_000_to_149_999" DOUBLE,
"margin_of_error_householder_under_25_years_125_000_to_149_999" DOUBLE,
"estimate_householder_under_25_years_150_000_to_199_999" DOUBLE,
"margin_of_error_householder_under_25_years_150_000_to_199_999" DOUBLE,
"estimate_householder_under_25_years_200_000_or_more" DOUBLE,
"margin_of_error_householder_under_25_years_200_000_or_more" DOUBLE,
"estimate_householder_25_to_44_years" DOUBLE,
"margin_of_error_householder_25_to_44_years" DOUBLE,
"estimate_householder_25_to_44_years_less_than_10_000" DOUBLE,
"margin_of_error_householder_25_to_44_years_less_than_10_000" DOUBLE,
"estimate_householder_25_to_44_years_10_000_to_14_999" DOUBLE,
"margin_of_error_householder_25_to_44_years_10_000_to_14_999" DOUBLE,
"estimate_householder_25_to_44_years_15_000_to_19_999" DOUBLE,
"margin_of_error_householder_25_to_44_years_15_000_to_19_999" DOUBLE,
"estimate_householder_25_to_44_years_20_000_to_24_999" DOUBLE,
"margin_of_error_householder_25_to_44_years_20_000_to_24_999" DOUBLE,
"estimate_householder_25_to_44_years_25_000_to_29_999" DOUBLE,
"margin_of_error_householder_25_to_44_years_25_000_to_29_999" DOUBLE,
"estimate_householder_25_to_44_years_30_000_to_34_999" DOUBLE,
"margin_of_error_householder_25_to_44_years_30_000_to_34_999" DOUBLE,
"estimate_householder_25_to_44_years_35_000_to_39_999" DOUBLE,
"margin_of_error_householder_25_to_44_years_35_000_to_39_999" DOUBLE,
"estimate_householder_25_to_44_years_40_000_to_44_999" DOUBLE,
"margin_of_error_householder_25_to_44_years_40_000_to_44_999" DOUBLE,
"estimate_householder_25_to_44_years_45_000_to_49_999" DOUBLE,
"margin_of_error_householder_25_to_44_years_45_000_to_49_999" DOUBLE,
"estimate_householder_25_to_44_years_50_000_to_59_999" DOUBLE,
"margin_of_error_householder_25_to_44_years_50_000_to_59_999" DOUBLE,
"estimate_householder_25_to_44_years_60_000_to_74_999" DOUBLE,
"margin_of_error_householder_25_to_44_years_60_000_to_74_999" DOUBLE,
"estimate_householder_25_to_44_years_75_000_to_99_999" DOUBLE,
"margin_of_error_householder_25_to_44_years_75_000_to_99_999" DOUBLE,
"estimate_householder_25_to_44_years_100_000_to_124_999" DOUBLE,
"margin_of_error_householder_25_to_44_years_100_000_to_124_999" DOUBLE,
"estimate_householder_25_to_44_years_125_000_to_149_999" DOUBLE,
"margin_of_error_householder_25_to_44_years_125_000_to_149_999" DOUBLE,
"estimate_householder_25_to_44_years_150_000_to_199_999" DOUBLE,
"margin_of_error_householder_25_to_44_years_150_000_to_199_999" DOUBLE,
"estimate_householder_25_to_44_years_200_000_or_more" DOUBLE,
"margin_of_error_householder_25_to_44_years_200_000_or_more" DOUBLE,
"estimate_householder_45_to_64_years" DOUBLE,
"margin_of_error_householder_45_to_64_years" DOUBLE,
"estimate_householder_45_to_64_years_less_than_10_000" DOUBLE,
"margin_of_error_householder_45_to_64_years_less_than_10_000" DOUBLE,
"estimate_householder_45_to_64_years_10_000_to_14_999" DOUBLE,
"margin_of_error_householder_45_to_64_years_10_000_to_14_999" DOUBLE,
"estimate_householder_45_to_64_years_15_000_to_19_999" DOUBLE,
"margin_of_error_householder_45_to_64_years_15_000_to_19_999" DOUBLE,
"estimate_householder_45_to_64_years_20_000_to_24_999" DOUBLE,
"margin_of_error_householder_45_to_64_years_20_000_to_24_999" DOUBLE,
"estimate_householder_45_to_64_years_25_000_to_29_999" DOUBLE,
"margin_of_error_householder_45_to_64_years_25_000_to_29_999" DOUBLE,
"estimate_householder_45_to_64_years_30_000_to_34_999" DOUBLE,
"margin_of_error_householder_45_to_64_years_30_000_to_34_999" DOUBLE,
"estimate_householder_45_to_64_years_35_000_to_39_999" DOUBLE,
"margin_of_error_householder_45_to_64_years_35_000_to_39_999" DOUBLE,
"estimate_householder_45_to_64_years_40_000_to_44_999" DOUBLE,
"margin_of_error_householder_45_to_64_years_40_000_to_44_999" DOUBLE,
"estimate_householder_45_to_64_years_45_000_to_49_999" DOUBLE,
"margin_of_error_householder_45_to_64_years_45_000_to_49_999" DOUBLE,
"estimate_householder_45_to_64_years_50_000_to_59_999" DOUBLE,
"margin_of_error_householder_45_to_64_years_50_000_to_59_999" DOUBLE,
"estimate_householder_45_to_64_years_60_000_to_74_999" DOUBLE,
"margin_of_error_householder_45_to_64_years_60_000_to_74_999" DOUBLE,
"estimate_householder_45_to_64_years_75_000_to_99_999" DOUBLE,
"margin_of_error_householder_45_to_64_years_75_000_to_99_999" DOUBLE,
"estimate_householder_45_to_64_years_100_000_to_124_999" DOUBLE,
"margin_of_error_householder_45_to_64_years_100_000_to_124_999" DOUBLE
);
Aggregate Household Income In The Past 12 Months
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.aggregate_household_income_in_the_past_12_months
- 7.83 KB
- 91 rows
- 4 columns
Loading...
CREATE TABLE aggregate_household_income_in_the_past_12_months (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_aggregate_household_income_in_the_past_12_mon_c1853f1d" VARCHAR,
"margin_of_error_aggregate_household_income_in_the_past_ad3e0f33" VARCHAR
);
Contract Rent
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.contract_rent
- 66.64 KB
- 91 rows
- 50 columns
Loading...
CREATE TABLE contract_rent (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_with_cash_rent" DOUBLE,
"margin_of_error_with_cash_rent" DOUBLE,
"estimate_with_cash_rent_less_than_100" DOUBLE,
"margin_of_error_with_cash_rent_less_than_100" DOUBLE,
"estimate_with_cash_rent_100_to_149" DOUBLE,
"margin_of_error_with_cash_rent_100_to_149" DOUBLE,
"estimate_with_cash_rent_150_to_199" DOUBLE,
"margin_of_error_with_cash_rent_150_to_199" DOUBLE,
"estimate_with_cash_rent_200_to_249" DOUBLE,
"margin_of_error_with_cash_rent_200_to_249" DOUBLE,
"estimate_with_cash_rent_250_to_299" DOUBLE,
"margin_of_error_with_cash_rent_250_to_299" DOUBLE,
"estimate_with_cash_rent_300_to_349" DOUBLE,
"margin_of_error_with_cash_rent_300_to_349" DOUBLE,
"estimate_with_cash_rent_350_to_399" DOUBLE,
"margin_of_error_with_cash_rent_350_to_399" DOUBLE,
"estimate_with_cash_rent_400_to_449" DOUBLE,
"margin_of_error_with_cash_rent_400_to_449" DOUBLE,
"estimate_with_cash_rent_450_to_499" DOUBLE,
"margin_of_error_with_cash_rent_450_to_499" DOUBLE,
"estimate_with_cash_rent_500_to_549" DOUBLE,
"margin_of_error_with_cash_rent_500_to_549" DOUBLE,
"estimate_with_cash_rent_550_to_599" DOUBLE,
"margin_of_error_with_cash_rent_550_to_599" DOUBLE,
"estimate_with_cash_rent_600_to_649" DOUBLE,
"margin_of_error_with_cash_rent_600_to_649" DOUBLE,
"estimate_with_cash_rent_650_to_699" DOUBLE,
"margin_of_error_with_cash_rent_650_to_699" DOUBLE,
"estimate_with_cash_rent_700_to_749" DOUBLE,
"margin_of_error_with_cash_rent_700_to_749" DOUBLE,
"estimate_with_cash_rent_750_to_799" DOUBLE,
"margin_of_error_with_cash_rent_750_to_799" DOUBLE,
"estimate_with_cash_rent_800_to_899" DOUBLE,
"margin_of_error_with_cash_rent_800_to_899" DOUBLE,
"estimate_with_cash_rent_900_to_999" DOUBLE,
"margin_of_error_with_cash_rent_900_to_999" DOUBLE,
"estimate_with_cash_rent_1_000_to_1_249" DOUBLE,
"margin_of_error_with_cash_rent_1_000_to_1_249" DOUBLE,
"estimate_with_cash_rent_1_250_to_1_499" DOUBLE,
"margin_of_error_with_cash_rent_1_250_to_1_499" DOUBLE,
"estimate_with_cash_rent_1_500_to_1_999" DOUBLE,
"margin_of_error_with_cash_rent_1_500_to_1_999" DOUBLE,
"estimate_with_cash_rent_2_000_or_more" DOUBLE,
"margin_of_error_with_cash_rent_2_000_or_more" DOUBLE,
"estimate_no_cash_rent" DOUBLE,
"margin_of_error_no_cash_rent" DOUBLE
);
Educational Attainment For The Population 25 Years And Over
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.educational_attainment_for_the_population_25_years_and_over
- 66.24 KB
- 91 rows
- 52 columns
Loading...
CREATE TABLE educational_attainment_for_the_population_25_years_and_over (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_total_no_schooling_completed" DOUBLE,
"margin_of_error_total_no_schooling_completed" DOUBLE,
"estimate_total_nursery_school" DOUBLE,
"margin_of_error_total_nursery_school" DOUBLE,
"estimate_total_kindergarten" DOUBLE,
"margin_of_error_total_kindergarten" DOUBLE,
"estimate_total_1st_grade" DOUBLE,
"margin_of_error_total_1st_grade" DOUBLE,
"estimate_total_2nd_grade" DOUBLE,
"margin_of_error_total_2nd_grade" DOUBLE,
"estimate_total_3rd_grade" DOUBLE,
"margin_of_error_total_3rd_grade" DOUBLE,
"estimate_total_4th_grade" DOUBLE,
"margin_of_error_total_4th_grade" DOUBLE,
"estimate_total_5th_grade" DOUBLE,
"margin_of_error_total_5th_grade" DOUBLE,
"estimate_total_6th_grade" DOUBLE,
"margin_of_error_total_6th_grade" DOUBLE,
"estimate_total_7th_grade" DOUBLE,
"margin_of_error_total_7th_grade" DOUBLE,
"estimate_total_8th_grade" DOUBLE,
"margin_of_error_total_8th_grade" DOUBLE,
"estimate_total_9th_grade" DOUBLE,
"margin_of_error_total_9th_grade" DOUBLE,
"estimate_total_10th_grade" DOUBLE,
"margin_of_error_total_10th_grade" DOUBLE,
"estimate_total_11th_grade" DOUBLE,
"margin_of_error_total_11th_grade" DOUBLE,
"estimate_total_12th_grade_no_diploma" DOUBLE,
"margin_of_error_total_12th_grade_no_diploma" DOUBLE,
"estimate_total_regular_high_school_diploma" DOUBLE,
"margin_of_error_total_regular_high_school_diploma" DOUBLE,
"estimate_total_ged_or_alternative_credential" DOUBLE,
"margin_of_error_total_ged_or_alternative_credential" DOUBLE,
"estimate_total_some_college_less_than_1_year" DOUBLE,
"margin_of_error_total_some_college_less_than_1_year" DOUBLE,
"estimate_total_some_college_1_or_more_years_no_degree" DOUBLE,
"margin_of_error_total_some_college_1_or_more_years_no_degree" DOUBLE,
"estimate_total_associate_s_degree" DOUBLE,
"margin_of_error_total_associate_s_degree" DOUBLE,
"estimate_total_bachelor_s_degree" DOUBLE,
"margin_of_error_total_bachelor_s_degree" DOUBLE,
"estimate_total_master_s_degree" DOUBLE,
"margin_of_error_total_master_s_degree" DOUBLE,
"estimate_total_professional_school_degree" DOUBLE,
"margin_of_error_total_professional_school_degree" DOUBLE,
"estimate_total_doctorate_degree" DOUBLE,
"margin_of_error_total_doctorate_degree" DOUBLE
);
Employment Status For The Population 16 Years And Over
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.employment_status_for_the_population_16_years_and_over
- 24.19 KB
- 91 rows
- 16 columns
Loading...
CREATE TABLE employment_status_for_the_population_16_years_and_over (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_in_labor_force" DOUBLE,
"margin_of_error_in_labor_force" DOUBLE,
"estimate_in_labor_force_civilian_labor_force" DOUBLE,
"margin_of_error_in_labor_force_civilian_labor_force" DOUBLE,
"estimate_in_labor_force_civilian_labor_force_employed" DOUBLE,
"margin_of_error_in_labor_force_civilian_labor_force_employed" DOUBLE,
"estimate_in_labor_force_civilian_labor_force_unemployed" DOUBLE,
"margin_of_error_in_labor_force_civilian_labor_force_unemployed" DOUBLE,
"estimate_in_labor_force_armed_forces" DOUBLE,
"margin_of_error_in_labor_force_armed_forces" DOUBLE,
"estimate_not_in_labor_force" DOUBLE,
"margin_of_error_not_in_labor_force" DOUBLE
);
Full-Time, Year Round Work Status In The Past 12 Months By Age
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.full_time_year_round_work_status_in_the_past_12_months_by_age
- 116.55 KB
- 91 rows
- 74 columns
Loading...
CREATE TABLE full_time_year_round_work_status_in_the_past_12_months_by_age (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_16_to_19_years" DOUBLE,
"margin_of_error_16_to_19_years" DOUBLE,
"estimate_16_to_19_years_worked_in_the_past_12_months" DOUBLE,
"margin_of_error_16_to_19_years_worked_in_the_past_12_months" DOUBLE,
"estimate_16_to_19_years_worked_in_the_past_12_months_w_dda5b9f6" DOUBLE,
"margin_of_error_16_to_19_years_worked_in_the_past_12_m_70d90bbc" DOUBLE,
"estimate_16_to_19_years_worked_in_the_past_12_months_w_3083e096" DOUBLE,
"margin_of_error_16_to_19_years_worked_in_the_past_12_m_806ece58" DOUBLE,
"estimate_16_to_19_years_did_not_work_in_the_past_12_months" DOUBLE,
"margin_of_error_16_to_19_years_did_not_work_in_the_pas_c17232aa" DOUBLE,
"estimate_20_to_24_years" DOUBLE,
"margin_of_error_20_to_24_years" DOUBLE,
"estimate_20_to_24_years_worked_in_the_past_12_months" DOUBLE,
"margin_of_error_20_to_24_years_worked_in_the_past_12_months" DOUBLE,
"estimate_20_to_24_years_worked_in_the_past_12_months_w_e002e409" DOUBLE,
"margin_of_error_20_to_24_years_worked_in_the_past_12_m_149096fb" DOUBLE,
"estimate_20_to_24_years_worked_in_the_past_12_months_w_c5de49b5" DOUBLE,
"margin_of_error_20_to_24_years_worked_in_the_past_12_m_e915de76" DOUBLE,
"estimate_20_to_24_years_did_not_work_in_the_past_12_months" DOUBLE,
"margin_of_error_20_to_24_years_did_not_work_in_the_pas_c33996d3" DOUBLE,
"estimate_25_to_44_years" DOUBLE,
"margin_of_error_25_to_44_years" DOUBLE,
"estimate_25_to_44_years_worked_in_the_past_12_months" DOUBLE,
"margin_of_error_25_to_44_years_worked_in_the_past_12_months" DOUBLE,
"estimate_25_to_44_years_worked_in_the_past_12_months_w_dea49e6a" DOUBLE,
"margin_of_error_25_to_44_years_worked_in_the_past_12_m_1b490e80" DOUBLE,
"estimate_25_to_44_years_worked_in_the_past_12_months_w_0d85cdc7" DOUBLE,
"margin_of_error_25_to_44_years_worked_in_the_past_12_m_3751342b" DOUBLE,
"estimate_25_to_44_years_did_not_work_in_the_past_12_months" DOUBLE,
"margin_of_error_25_to_44_years_did_not_work_in_the_pas_e339b7b6" DOUBLE,
"estimate_45_to_54_years" DOUBLE,
"margin_of_error_45_to_54_years" DOUBLE,
"estimate_45_to_54_years_worked_in_the_past_12_months" DOUBLE,
"margin_of_error_45_to_54_years_worked_in_the_past_12_months" DOUBLE,
"estimate_45_to_54_years_worked_in_the_past_12_months_w_f4ba73f7" DOUBLE,
"margin_of_error_45_to_54_years_worked_in_the_past_12_m_324c933e" DOUBLE,
"estimate_45_to_54_years_worked_in_the_past_12_months_w_522eb5ce" DOUBLE,
"margin_of_error_45_to_54_years_worked_in_the_past_12_m_548aec9a" DOUBLE,
"estimate_45_to_54_years_did_not_work_in_the_past_12_months" DOUBLE,
"margin_of_error_45_to_54_years_did_not_work_in_the_pas_228fd23e" DOUBLE,
"estimate_55_to_64_years" DOUBLE,
"margin_of_error_55_to_64_years" DOUBLE,
"estimate_55_to_64_years_worked_in_the_past_12_months" DOUBLE,
"margin_of_error_55_to_64_years_worked_in_the_past_12_months" DOUBLE,
"estimate_55_to_64_years_worked_in_the_past_12_months_w_a9949475" DOUBLE,
"margin_of_error_55_to_64_years_worked_in_the_past_12_m_77ff2037" DOUBLE,
"estimate_55_to_64_years_worked_in_the_past_12_months_w_e92e0df9" DOUBLE,
"margin_of_error_55_to_64_years_worked_in_the_past_12_m_8908b501" DOUBLE,
"estimate_55_to_64_years_did_not_work_in_the_past_12_months" DOUBLE,
"margin_of_error_55_to_64_years_did_not_work_in_the_pas_7456dab9" DOUBLE,
"estimate_65_to_69_years" DOUBLE,
"margin_of_error_65_to_69_years" DOUBLE,
"estimate_65_to_69_years_worked_in_the_past_12_months" DOUBLE,
"margin_of_error_65_to_69_years_worked_in_the_past_12_months" DOUBLE,
"estimate_65_to_69_years_worked_in_the_past_12_months_w_69c6276b" DOUBLE,
"margin_of_error_65_to_69_years_worked_in_the_past_12_m_d47e9e05" DOUBLE,
"estimate_65_to_69_years_worked_in_the_past_12_months_w_ecf9f5df" DOUBLE,
"margin_of_error_65_to_69_years_worked_in_the_past_12_m_3bf940fa" DOUBLE,
"estimate_65_to_69_years_did_not_work_in_the_past_12_months" DOUBLE,
"margin_of_error_65_to_69_years_did_not_work_in_the_pas_790eace5" DOUBLE,
"estimate_70_years_and_over" DOUBLE,
"margin_of_error_70_years_and_over" DOUBLE,
"estimate_70_years_and_over_worked_in_the_past_12_months" DOUBLE,
"margin_of_error_70_years_and_over_worked_in_the_past_12_months" DOUBLE,
"estimate_70_years_and_over_worked_in_the_past_12_month_728d032b" DOUBLE,
"margin_of_error_70_years_and_over_worked_in_the_past_1_9bdf25a2" DOUBLE,
"estimate_70_years_and_over_worked_in_the_past_12_month_9179007b" DOUBLE,
"margin_of_error_70_years_and_over_worked_in_the_past_1_7df48047" DOUBLE,
"estimate_70_years_and_over_did_not_work_in_the_past_12_months" DOUBLE,
"margin_of_error_70_years_and_over_did_not_work_in_the__329a8d97" DOUBLE
);
Household Language By Household Limited English Speaking Status
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.household_language_by_household_limited_english_speaking_status
- 43.01 KB
- 91 rows
- 30 columns
Loading...
CREATE TABLE household_language_by_household_limited_english_speaking_status (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_total_english_only" DOUBLE,
"margin_of_error_total_english_only" DOUBLE,
"estimate_total_spanish" DOUBLE,
"margin_of_error_total_spanish" DOUBLE,
"estimate_total_spanish_limited_english_speaking_household" DOUBLE,
"margin_of_error_total_spanish_limited_english_speaking_a2ef0110" DOUBLE,
"estimate_total_spanish_not_a_limited_english_speaking_household" DOUBLE,
"margin_of_error_total_spanish_not_a_limited_english_sp_3c9fe60e" DOUBLE,
"estimate_total_other_indo_european_languages" DOUBLE,
"margin_of_error_total_other_indo_european_languages" DOUBLE,
"estimate_total_other_indo_european_languages_limited_e_aced86f2" DOUBLE,
"margin_of_error_total_other_indo_european_languages_li_04361ec2" DOUBLE,
"estimate_total_other_indo_european_languages_not_a_lim_191ab38f" DOUBLE,
"margin_of_error_total_other_indo_european_languages_no_697b2f66" DOUBLE,
"estimate_total_asian_and_pacific_island_languages" DOUBLE,
"margin_of_error_total_asian_and_pacific_island_languages" DOUBLE,
"estimate_total_asian_and_pacific_island_languages_limi_48e4ddd0" DOUBLE,
"margin_of_error_total_asian_and_pacific_island_languag_e016be1c" DOUBLE,
"estimate_total_asian_and_pacific_island_languages_not__ec98ac8d" DOUBLE,
"margin_of_error_total_asian_and_pacific_island_languag_4aaf69c4" DOUBLE,
"estimate_total_other_languages" DOUBLE,
"margin_of_error_total_other_languages" DOUBLE,
"estimate_total_other_languages_limited_english_speakin_b7030d81" DOUBLE,
"margin_of_error_total_other_languages_limited_english__3a84d5e0" DOUBLE,
"estimate_total_other_languages_not_a_limited_english_s_e8c6fb72" DOUBLE,
"margin_of_error_total_other_languages_not_a_limited_en_bd2261c4" DOUBLE
);
Poverty Status Of Individuals In The Past 12 Months By Living Arrangements
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.poverty_status_of_individuals_in_the_past_12_months_by_4ae836b5
- 116.72 KB
- 91 rows
- 72 columns
Loading...
CREATE TABLE poverty_status_of_individuals_in_the_past_12_months_by_4ae836b5 (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_level" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_458472e3" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_6726880a" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_d10f3b56" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_64113316" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_47005a00" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_8df7c691" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_2058143a" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_6877fef6" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_8ee87ba9" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_84b6d6f6" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_13b5a966" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_8a65a56f" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_80f090ab" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_6427d1cb" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_d037dbdd" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_d117015f" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_07114133" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_d6d2c515" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_643477a8" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_cf791b37" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_713bf1ff" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_255f7fdf" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_287e03d3" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_b6fc8c7a" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_973a6b32" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_60f8ed87" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_2a5b020d" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_cf0f5e90" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_72434c1f" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_4128c3e5" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_3c946fbe" DOUBLE,
"estimate_income_in_the_past_12_months_below_poverty_le_5aee5345" DOUBLE,
"margin_of_error_income_in_the_past_12_months_below_pov_e4441f7e" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_aa8a9083" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_8dc7a68f" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_5b52a2b5" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_978877fb" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_66b3f2f0" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_2be594b7" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_2e58ca88" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_48fe761a" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_9b25cbfe" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_51cebd3a" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_9e34ae93" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_a7c59ca6" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_dac1fe60" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_870bbd39" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_719bb156" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_70a7cac5" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_2d07d3a4" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_887b59ca" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_63a9dd82" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_7f3ca011" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_0183583d" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_c95a8680" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_85ed53e1" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_893c98ea" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_a9e250c5" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_8a3a4f50" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_b5af671f" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_81bf99e5" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_27a41190" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_8796d4fe" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_ac2a0e9f" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_8a0a0a0e" DOUBLE,
"estimate_income_in_the_past_12_months_at_or_above_pove_f5b74bd8" DOUBLE,
"margin_of_error_income_in_the_past_12_months_at_or_abo_9788fac9" DOUBLE
);
Public Assistance Income In The Past 12 Months For Households
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.public_assistance_income_in_the_past_12_months_for_households
- 12.63 KB
- 91 rows
- 8 columns
Loading...
CREATE TABLE public_assistance_income_in_the_past_12_months_for_households (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_total_with_public_assistance_income" DOUBLE,
"margin_of_error_total_with_public_assistance_income" DOUBLE,
"estimate_total_no_public_assistance_income" DOUBLE,
"margin_of_error_total_no_public_assistance_income" DOUBLE
);
Race
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.race
- 31.71 KB
- 91 rows
- 22 columns
Loading...
CREATE TABLE race (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_total_white_alone" DOUBLE,
"margin_of_error_total_white_alone" DOUBLE,
"estimate_total_black_or_african_american_alone" DOUBLE,
"margin_of_error_total_black_or_african_american_alone" DOUBLE,
"estimate_total_american_indian_and_alaska_native_alone" DOUBLE,
"margin_of_error_total_american_indian_and_alaska_native_alone" DOUBLE,
"estimate_total_asian_alone" DOUBLE,
"margin_of_error_total_asian_alone" DOUBLE,
"estimate_total_native_hawaiian_and_other_pacific_islander_alone" DOUBLE,
"margin_of_error_total_native_hawaiian_and_other_pacifi_0e4ff679" DOUBLE,
"estimate_total_some_other_race_alone" DOUBLE,
"margin_of_error_total_some_other_race_alone" DOUBLE,
"estimate_total_two_or_more_races" DOUBLE,
"margin_of_error_total_two_or_more_races" DOUBLE,
"estimate_total_two_or_more_races_two_races_including_s_f38a59af" DOUBLE,
"margin_of_error_total_two_or_more_races_two_races_incl_6e216665" DOUBLE,
"estimate_total_two_or_more_races_two_races_excluding_s_7c65a5a6" DOUBLE,
"margin_of_error_total_two_or_more_races_two_races_excl_24d61c7e" DOUBLE
);
Receipt Of Food Stamps/SNAP In The Past 12 Months By Disability Status
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.receipt_of_food_stamps_snap_in_the_past_12_months_by_d_3ff75cc3
- 26.92 KB
- 91 rows
- 16 columns
Loading...
CREATE TABLE receipt_of_food_stamps_snap_in_the_past_12_months_by_d_3ff75cc3 (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_household_received_food_stamps_snap_in_the_pa_6e821a51" DOUBLE,
"margin_of_error_household_received_food_stamps_snap_in_00a59fac" DOUBLE,
"estimate_household_received_food_stamps_snap_in_the_pa_1873cc70" DOUBLE,
"margin_of_error_household_received_food_stamps_snap_in_5b18ee74" DOUBLE,
"estimate_household_received_food_stamps_snap_in_the_pa_c09632b8" DOUBLE,
"margin_of_error_household_received_food_stamps_snap_in_973893a6" DOUBLE,
"estimate_household_did_not_receive_food_stamps_snap_in_617f4a25" DOUBLE,
"margin_of_error_household_did_not_receive_food_stamps__26e84d0e" DOUBLE,
"estimate_household_did_not_receive_food_stamps_snap_in_58f6e73a" DOUBLE,
"margin_of_error_household_did_not_receive_food_stamps__2f6fcac8" DOUBLE,
"estimate_household_did_not_receive_food_stamps_snap_in_7718f72e" DOUBLE,
"margin_of_error_household_did_not_receive_food_stamps__00adb5c5" DOUBLE
);
Retirement Income In The Past 12 Months
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.retirement_income_in_the_past_12_months
- 12.5 KB
- 91 rows
- 8 columns
Loading...
CREATE TABLE retirement_income_in_the_past_12_months (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_total_with_retirement_income" DOUBLE,
"margin_of_error_total_with_retirement_income" DOUBLE,
"estimate_total_no_retirement_income" DOUBLE,
"margin_of_error_total_no_retirement_income" DOUBLE
);
Self-Employment Income In The Past 12 Months
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.self_employment_income_in_the_past_12_months
- 12.56 KB
- 91 rows
- 8 columns
Loading...
CREATE TABLE self_employment_income_in_the_past_12_months (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_total_with_self_employment_income" DOUBLE,
"margin_of_error_total_with_self_employment_income" DOUBLE,
"estimate_total_no_self_employment_income" DOUBLE,
"margin_of_error_total_no_self_employment_income" DOUBLE
);
Sex By Class Of Worker For The Civilian Employed Population 16 Years Or Older
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.sex_by_class_of_worker_for_the_civilian_employed_popul_726effda
- 64.79 KB
- 91 rows
- 44 columns
Loading...
CREATE TABLE sex_by_class_of_worker_for_the_civilian_employed_popul_726effda (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_male" DOUBLE,
"margin_of_error_male" DOUBLE,
"estimate_male_private_for_profit_wage_and_salary_workers" DOUBLE,
"margin_of_error_male_private_for_profit_wage_and_salar_426f78ff" DOUBLE,
"estimate_male_private_for_profit_wage_and_salary_worke_20578019" DOUBLE,
"margin_of_error_male_private_for_profit_wage_and_salar_213dca85" DOUBLE,
"estimate_male_private_for_profit_wage_and_salary_worke_b3e312d1" DOUBLE,
"margin_of_error_male_private_for_profit_wage_and_salar_f5a24c9a" DOUBLE,
"estimate_male_private_not_for_profit_wage_and_salary_workers" DOUBLE,
"margin_of_error_male_private_not_for_profit_wage_and_s_a0eef1f9" DOUBLE,
"estimate_male_local_government_workers" DOUBLE,
"margin_of_error_male_local_government_workers" DOUBLE,
"estimate_male_state_government_workers" DOUBLE,
"margin_of_error_male_state_government_workers" DOUBLE,
"estimate_male_federal_government_workers" DOUBLE,
"margin_of_error_male_federal_government_workers" DOUBLE,
"estimate_male_self_employed_in_own_not_incorporated_bu_5f29fe21" DOUBLE,
"margin_of_error_male_self_employed_in_own_not_incorpor_5aea8276" DOUBLE,
"estimate_male_unpaid_family_workers" DOUBLE,
"margin_of_error_male_unpaid_family_workers" DOUBLE,
"estimate_female" DOUBLE,
"margin_of_error_female" DOUBLE,
"estimate_female_private_for_profit_wage_and_salary_workers" DOUBLE,
"margin_of_error_female_private_for_profit_wage_and_sal_d2b4c714" DOUBLE,
"estimate_female_private_for_profit_wage_and_salary_wor_1a2323f5" DOUBLE,
"margin_of_error_female_private_for_profit_wage_and_sal_e5eaf157" DOUBLE,
"estimate_female_private_for_profit_wage_and_salary_wor_beff83a8" DOUBLE,
"margin_of_error_female_private_for_profit_wage_and_sal_5dfba027" DOUBLE,
"estimate_female_private_not_for_profit_wage_and_salary_workers" DOUBLE,
"margin_of_error_female_private_not_for_profit_wage_and_9fc064d4" DOUBLE,
"estimate_female_local_government_workers" DOUBLE,
"margin_of_error_female_local_government_workers" DOUBLE,
"estimate_female_state_government_workers" DOUBLE,
"margin_of_error_female_state_government_workers" DOUBLE,
"estimate_female_federal_government_workers" DOUBLE,
"margin_of_error_female_federal_government_workers" DOUBLE,
"estimate_female_self_employed_in_own_not_incorporated__c83b0f53" DOUBLE,
"margin_of_error_female_self_employed_in_own_not_incorp_52ee73cd" DOUBLE,
"estimate_female_unpaid_family_workers" DOUBLE,
"margin_of_error_female_unpaid_family_workers" DOUBLE
);
Sex By Educational Attainment For The Population 25 Years And Older
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.sex_by_educational_attainment_for_the_population_25_ye_0bae370c
- 96.71 KB
- 91 rows
- 72 columns
Loading...
CREATE TABLE sex_by_educational_attainment_for_the_population_25_ye_0bae370c (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_male" DOUBLE,
"margin_of_error_male" DOUBLE,
"estimate_male_no_schooling_completed" DOUBLE,
"margin_of_error_male_no_schooling_completed" DOUBLE,
"estimate_male_nursery_to_4th_grade" DOUBLE,
"margin_of_error_male_nursery_to_4th_grade" DOUBLE,
"estimate_male_5th_and_6th_grade" DOUBLE,
"margin_of_error_male_5th_and_6th_grade" DOUBLE,
"estimate_male_7th_and_8th_grade" DOUBLE,
"margin_of_error_male_7th_and_8th_grade" DOUBLE,
"estimate_male_9th_grade" DOUBLE,
"margin_of_error_male_9th_grade" DOUBLE,
"estimate_male_10th_grade" DOUBLE,
"margin_of_error_male_10th_grade" DOUBLE,
"estimate_male_11th_grade" DOUBLE,
"margin_of_error_male_11th_grade" DOUBLE,
"estimate_male_12th_grade_no_diploma" DOUBLE,
"margin_of_error_male_12th_grade_no_diploma" DOUBLE,
"estimate_male_high_school_graduate_includes_equivalency" DOUBLE,
"margin_of_error_male_high_school_graduate_includes_equivalency" DOUBLE,
"estimate_male_some_college_less_than_1_year" DOUBLE,
"margin_of_error_male_some_college_less_than_1_year" DOUBLE,
"estimate_male_some_college_1_or_more_years_no_degree" DOUBLE,
"margin_of_error_male_some_college_1_or_more_years_no_degree" DOUBLE,
"estimate_male_associate_s_degree" DOUBLE,
"margin_of_error_male_associate_s_degree" DOUBLE,
"estimate_male_bachelor_s_degree" DOUBLE,
"margin_of_error_male_bachelor_s_degree" DOUBLE,
"estimate_male_master_s_degree" DOUBLE,
"margin_of_error_male_master_s_degree" DOUBLE,
"estimate_male_professional_school_degree" DOUBLE,
"margin_of_error_male_professional_school_degree" DOUBLE,
"estimate_male_doctorate_degree" DOUBLE,
"margin_of_error_male_doctorate_degree" DOUBLE,
"estimate_female" DOUBLE,
"margin_of_error_female" DOUBLE,
"estimate_female_no_schooling_completed" DOUBLE,
"margin_of_error_female_no_schooling_completed" DOUBLE,
"estimate_female_nursery_to_4th_grade" DOUBLE,
"margin_of_error_female_nursery_to_4th_grade" DOUBLE,
"estimate_female_5th_and_6th_grade" DOUBLE,
"margin_of_error_female_5th_and_6th_grade" DOUBLE,
"estimate_female_7th_and_8th_grade" DOUBLE,
"margin_of_error_female_7th_and_8th_grade" DOUBLE,
"estimate_female_9th_grade" DOUBLE,
"margin_of_error_female_9th_grade" DOUBLE,
"estimate_female_10th_grade" DOUBLE,
"margin_of_error_female_10th_grade" DOUBLE,
"estimate_female_11th_grade" DOUBLE,
"margin_of_error_female_11th_grade" DOUBLE,
"estimate_female_12th_grade_no_diploma" DOUBLE,
"margin_of_error_female_12th_grade_no_diploma" DOUBLE,
"estimate_female_high_school_graduate_includes_equivalency" DOUBLE,
"margin_of_error_female_high_school_graduate_includes_e_2aa609b3" DOUBLE,
"estimate_female_some_college_less_than_1_year" DOUBLE,
"margin_of_error_female_some_college_less_than_1_year" DOUBLE,
"estimate_female_some_college_1_or_more_years_no_degree" DOUBLE,
"margin_of_error_female_some_college_1_or_more_years_no_degree" DOUBLE,
"estimate_female_associate_s_degree" DOUBLE,
"margin_of_error_female_associate_s_degree" DOUBLE,
"estimate_female_bachelor_s_degree" DOUBLE,
"margin_of_error_female_bachelor_s_degree" DOUBLE,
"estimate_female_master_s_degree" DOUBLE,
"margin_of_error_female_master_s_degree" DOUBLE,
"estimate_female_professional_school_degree" DOUBLE,
"margin_of_error_female_professional_school_degree" DOUBLE,
"estimate_female_doctorate_degree" DOUBLE,
"margin_of_error_female_doctorate_degree" DOUBLE
);
Social Security Income In The Past 12 Months
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.social_security_income_in_the_past_12_months
- 12.69 KB
- 91 rows
- 8 columns
Loading...
CREATE TABLE social_security_income_in_the_past_12_months (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_total_with_social_security_income" DOUBLE,
"margin_of_error_total_with_social_security_income" DOUBLE,
"estimate_total_no_social_security_income" DOUBLE,
"margin_of_error_total_no_social_security_income" DOUBLE
);
Supplemental Security Income (SSI) In The Past 12 Months For Households
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.supplemental_security_income_ssi_in_the_past_12_months_6ec1b57a
- 12.93 KB
- 91 rows
- 8 columns
Loading...
CREATE TABLE supplemental_security_income_ssi_in_the_past_12_months_6ec1b57a (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_total_with_supplemental_security_income_ssi" DOUBLE,
"margin_of_error_total_with_supplemental_security_income_ssi" DOUBLE,
"estimate_total_no_supplemental_security_income_ssi" DOUBLE,
"margin_of_error_total_no_supplemental_security_income_ssi" DOUBLE
);
Vacancy Status
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.vacancy_status
- 23.16 KB
- 91 rows
- 18 columns
Loading...
CREATE TABLE vacancy_status (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_total_for_rent" DOUBLE,
"margin_of_error_total_for_rent" DOUBLE,
"estimate_total_rented_not_occupied" DOUBLE,
"margin_of_error_total_rented_not_occupied" DOUBLE,
"estimate_total_for_sale_only" DOUBLE,
"margin_of_error_total_for_sale_only" DOUBLE,
"estimate_total_sold_not_occupied" DOUBLE,
"margin_of_error_total_sold_not_occupied" DOUBLE,
"estimate_total_for_seasonal_recreational_or_occasional_use" DOUBLE,
"margin_of_error_total_for_seasonal_recreational_or_occ_64f9e608" DOUBLE,
"estimate_total_for_migrant_workers" DOUBLE,
"margin_of_error_total_for_migrant_workers" DOUBLE,
"estimate_total_other_vacant" DOUBLE,
"margin_of_error_total_other_vacant" DOUBLE
);
Housing Value
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.housing_value
- 66.4 KB
- 91 rows
- 52 columns
Loading...
CREATE TABLE housing_value (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_total_less_than_10_000" DOUBLE,
"margin_of_error_total_less_than_10_000" DOUBLE,
"estimate_total_10_000_to_14_999" DOUBLE,
"margin_of_error_total_10_000_to_14_999" DOUBLE,
"estimate_total_15_000_to_19_999" DOUBLE,
"margin_of_error_total_15_000_to_19_999" DOUBLE,
"estimate_total_20_000_to_24_999" DOUBLE,
"margin_of_error_total_20_000_to_24_999" DOUBLE,
"estimate_total_25_000_to_29_999" DOUBLE,
"margin_of_error_total_25_000_to_29_999" DOUBLE,
"estimate_total_30_000_to_34_999" DOUBLE,
"margin_of_error_total_30_000_to_34_999" DOUBLE,
"estimate_total_35_000_to_39_999" DOUBLE,
"margin_of_error_total_35_000_to_39_999" DOUBLE,
"estimate_total_40_000_to_49_999" DOUBLE,
"margin_of_error_total_40_000_to_49_999" DOUBLE,
"estimate_total_50_000_to_59_999" DOUBLE,
"margin_of_error_total_50_000_to_59_999" DOUBLE,
"estimate_total_60_000_to_69_999" DOUBLE,
"margin_of_error_total_60_000_to_69_999" DOUBLE,
"estimate_total_70_000_to_79_999" DOUBLE,
"margin_of_error_total_70_000_to_79_999" DOUBLE,
"estimate_total_80_000_to_89_999" DOUBLE,
"margin_of_error_total_80_000_to_89_999" DOUBLE,
"estimate_total_90_000_to_99_999" DOUBLE,
"margin_of_error_total_90_000_to_99_999" DOUBLE,
"estimate_total_100_000_to_124_999" DOUBLE,
"margin_of_error_total_100_000_to_124_999" DOUBLE,
"estimate_total_125_000_to_149_999" DOUBLE,
"margin_of_error_total_125_000_to_149_999" DOUBLE,
"estimate_total_150_000_to_174_999" DOUBLE,
"margin_of_error_total_150_000_to_174_999" DOUBLE,
"estimate_total_175_000_to_199_999" DOUBLE,
"margin_of_error_total_175_000_to_199_999" DOUBLE,
"estimate_total_200_000_to_249_999" DOUBLE,
"margin_of_error_total_200_000_to_249_999" DOUBLE,
"estimate_total_250_000_to_299_999" DOUBLE,
"margin_of_error_total_250_000_to_299_999" DOUBLE,
"estimate_total_300_000_to_399_999" DOUBLE,
"margin_of_error_total_300_000_to_399_999" DOUBLE,
"estimate_total_400_000_to_499_999" DOUBLE,
"margin_of_error_total_400_000_to_499_999" DOUBLE,
"estimate_total_500_000_to_749_999" DOUBLE,
"margin_of_error_total_500_000_to_749_999" DOUBLE,
"estimate_total_750_000_to_999_999" DOUBLE,
"margin_of_error_total_750_000_to_999_999" DOUBLE,
"estimate_total_1_000_000_or_more" DOUBLE,
"margin_of_error_total_1_000_000_or_more" DOUBLE
);
Wage Or Salary Income In The Past 12 Months For Households
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.wage_or_salary_income_in_the_past_12_months_for_households
- 12.66 KB
- 91 rows
- 8 columns
Loading...
CREATE TABLE wage_or_salary_income_in_the_past_12_months_for_households (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE,
"margin_of_error_total" DOUBLE,
"estimate_total_with_wage_or_salary_income" DOUBLE,
"margin_of_error_total_with_wage_or_salary_income" DOUBLE,
"estimate_total_no_wage_or_salary_income" DOUBLE,
"margin_of_error_total_no_wage_or_salary_income" DOUBLE
);