Pittsburgh American Community Survey 2015 - Miscellaneous Data

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_to_2_499" DOUBLE,
  "margin_of_error_with_cash_rent_2_000_to_2_499" DOUBLE,
  "estimate_with_cash_rent_2_500_to_2_999" DOUBLE,
  "margin_of_error_with_cash_rent_2_500_to_2_999" DOUBLE,
  "estimate_with_cash_rent_3_000_to_3_499" DOUBLE,
  "margin_of_error_with_cash_rent_3_000_to_3_499" DOUBLE,
  "estimate_with_cash_rent_3_500_or_more" DOUBLE,
  "margin_of_error_with_cash_rent_3_500_or_more" DOUBLE,
  "estimate_no_cash_rent" DOUBLE,
  "margin_of_error_no_cash_rent" DOUBLE
);

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
);

CREATE TABLE household_income_in_the_past_12_months_in_2015_inflati_ddb67809 (
  "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_44_999" DOUBLE,
  "margin_of_error_total_40_000_to_44_999" DOUBLE,
  "estimate_total_45_000_to_49_999" DOUBLE,
  "margin_of_error_total_45_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_74_999" DOUBLE,
  "margin_of_error_total_60_000_to_74_999" DOUBLE,
  "estimate_total_75_000_to_99_999" DOUBLE,
  "margin_of_error_total_75_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_199_999" DOUBLE,
  "margin_of_error_total_150_000_to_199_999" DOUBLE,
  "estimate_total_200_000_or_more" DOUBLE,
  "margin_of_error_total_200_000_or_more" DOUBLE
);

CREATE TABLE housing_units (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE,
  "margin_of_error_total" DOUBLE
);

CREATE TABLE housing_unit_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_to_1_499_999" DOUBLE,
  "margin_of_error_total_1_000_000_to_1_499_999" DOUBLE,
  "estimate_total_1_500_000_to_1_999_999" DOUBLE,
  "margin_of_error_total_1_500_000_to_1_999_999" DOUBLE,
  "estimate_total_2_000_000_or_more" DOUBLE,
  "margin_of_error_total_2_000_000_or_more" DOUBLE
);

CREATE TABLE mortgage_status (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE,
  "margin_of_error_total" DOUBLE,
  "estimate_housing_units_with_a_mortgage_contract_to_pur_d3feed0e" DOUBLE,
  "margin_of_error_housing_units_with_a_mortgage_contract_9bb7ee9d" DOUBLE,
  "estimate_housing_units_with_a_mortgage_contract_to_pur_49d5a658" DOUBLE,
  "margin_of_error_housing_units_with_a_mortgage_contract_48c18a85" DOUBLE,
  "estimate_housing_units_with_a_mortgage_contract_to_pur_b495f382" DOUBLE,
  "margin_of_error_housing_units_with_a_mortgage_contract_7fbf6358" DOUBLE,
  "estimate_housing_units_with_a_mortgage_contract_to_pur_6e7820de" DOUBLE,
  "margin_of_error_housing_units_with_a_mortgage_contract_1fdffde3" DOUBLE,
  "estimate_housing_units_with_a_mortgage_contract_to_pur_96514c32" DOUBLE,
  "margin_of_error_housing_units_with_a_mortgage_contract_39255739" DOUBLE,
  "estimate_housing_units_with_a_mortgage_contract_to_pur_42f07528" DOUBLE,
  "margin_of_error_housing_units_with_a_mortgage_contract_e42b3ba8" DOUBLE,
  "estimate_housing_units_without_a_mortgage" DOUBLE,
  "margin_of_error_housing_units_without_a_mortgage" DOUBLE
);

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
);

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
);

CREATE TABLE retirement_income_in_the_past_12_months_for_households (
  "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
);

CREATE TABLE self_employment_income_in_the_past_12_months_for_households (
  "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
);

CREATE TABLE sex_by_age (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE,
  "margin_of_error_total" DOUBLE,
  "estimate_male" DOUBLE,
  "margin_of_error_male" DOUBLE,
  "estimate_male_under_5_years" DOUBLE,
  "margin_of_error_male_under_5_years" DOUBLE,
  "estimate_male_5_to_9_years" DOUBLE,
  "margin_of_error_male_5_to_9_years" DOUBLE,
  "estimate_male_10_to_14_years" DOUBLE,
  "margin_of_error_male_10_to_14_years" DOUBLE,
  "estimate_male_15_to_17_years" DOUBLE,
  "margin_of_error_male_15_to_17_years" DOUBLE,
  "estimate_male_18_and_19_years" DOUBLE,
  "margin_of_error_male_18_and_19_years" DOUBLE,
  "estimate_male_20_years" DOUBLE,
  "margin_of_error_male_20_years" DOUBLE,
  "estimate_male_21_years" DOUBLE,
  "margin_of_error_male_21_years" DOUBLE,
  "estimate_male_22_to_24_years" DOUBLE,
  "margin_of_error_male_22_to_24_years" DOUBLE,
  "estimate_male_25_to_29_years" DOUBLE,
  "margin_of_error_male_25_to_29_years" DOUBLE,
  "estimate_male_30_to_34_years" DOUBLE,
  "margin_of_error_male_30_to_34_years" DOUBLE,
  "estimate_male_35_to_39_years" DOUBLE,
  "margin_of_error_male_35_to_39_years" DOUBLE,
  "estimate_male_40_to_44_years" DOUBLE,
  "margin_of_error_male_40_to_44_years" DOUBLE,
  "estimate_male_45_to_49_years" DOUBLE,
  "margin_of_error_male_45_to_49_years" DOUBLE,
  "estimate_male_50_to_54_years" DOUBLE,
  "margin_of_error_male_50_to_54_years" DOUBLE,
  "estimate_male_55_to_59_years" DOUBLE,
  "margin_of_error_male_55_to_59_years" DOUBLE,
  "estimate_male_60_and_61_years" DOUBLE,
  "margin_of_error_male_60_and_61_years" DOUBLE,
  "estimate_male_62_to_64_years" DOUBLE,
  "margin_of_error_male_62_to_64_years" DOUBLE,
  "estimate_male_65_and_66_years" DOUBLE,
  "margin_of_error_male_65_and_66_years" DOUBLE,
  "estimate_male_67_to_69_years" DOUBLE,
  "margin_of_error_male_67_to_69_years" DOUBLE,
  "estimate_male_70_to_74_years" DOUBLE,
  "margin_of_error_male_70_to_74_years" DOUBLE,
  "estimate_male_75_to_79_years" DOUBLE,
  "margin_of_error_male_75_to_79_years" DOUBLE,
  "estimate_male_80_to_84_years" DOUBLE,
  "margin_of_error_male_80_to_84_years" DOUBLE,
  "estimate_male_85_years_and_over" DOUBLE,
  "margin_of_error_male_85_years_and_over" DOUBLE,
  "estimate_female" DOUBLE,
  "margin_of_error_female" DOUBLE,
  "estimate_female_under_5_years" DOUBLE,
  "margin_of_error_female_under_5_years" DOUBLE,
  "estimate_female_5_to_9_years" DOUBLE,
  "margin_of_error_female_5_to_9_years" DOUBLE,
  "estimate_female_10_to_14_years" DOUBLE,
  "margin_of_error_female_10_to_14_years" DOUBLE,
  "estimate_female_15_to_17_years" DOUBLE,
  "margin_of_error_female_15_to_17_years" DOUBLE,
  "estimate_female_18_and_19_years" DOUBLE,
  "margin_of_error_female_18_and_19_years" DOUBLE,
  "estimate_female_20_years" DOUBLE,
  "margin_of_error_female_20_years" DOUBLE,
  "estimate_female_21_years" DOUBLE,
  "margin_of_error_female_21_years" DOUBLE,
  "estimate_female_22_to_24_years" DOUBLE,
  "margin_of_error_female_22_to_24_years" DOUBLE,
  "estimate_female_25_to_29_years" DOUBLE,
  "margin_of_error_female_25_to_29_years" DOUBLE,
  "estimate_female_30_to_34_years" DOUBLE,
  "margin_of_error_female_30_to_34_years" DOUBLE,
  "estimate_female_35_to_39_years" DOUBLE,
  "margin_of_error_female_35_to_39_years" DOUBLE,
  "estimate_female_40_to_44_years" DOUBLE,
  "margin_of_error_female_40_to_44_years" DOUBLE,
  "estimate_female_45_to_49_years" DOUBLE,
  "margin_of_error_female_45_to_49_years" DOUBLE,
  "estimate_female_50_to_54_years" DOUBLE,
  "margin_of_error_female_50_to_54_years" DOUBLE,
  "estimate_female_55_to_59_years" DOUBLE,
  "margin_of_error_female_55_to_59_years" DOUBLE,
  "estimate_female_60_and_61_years" DOUBLE,
  "margin_of_error_female_60_and_61_years" DOUBLE,
  "estimate_female_62_to_64_years" DOUBLE,
  "margin_of_error_female_62_to_64_years" DOUBLE,
  "estimate_female_65_and_66_years" DOUBLE,
  "margin_of_error_female_65_and_66_years" DOUBLE,
  "estimate_female_67_to_69_years" DOUBLE,
  "margin_of_error_female_67_to_69_years" DOUBLE,
  "estimate_female_70_to_74_years" DOUBLE,
  "margin_of_error_female_70_to_74_years" DOUBLE,
  "estimate_female_75_to_79_years" DOUBLE,
  "margin_of_error_female_75_to_79_years" DOUBLE,
  "estimate_female_80_to_84_years" DOUBLE,
  "margin_of_error_female_80_to_84_years" DOUBLE,
  "estimate_female_85_years_and_over" DOUBLE,
  "margin_of_error_female_85_years_and_over" DOUBLE
);

CREATE TABLE sex_by_industry_for_the_civilian_employed_population_1_43b65bd2 (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE,
  "margin_of_error_total" DOUBLE,
  "estimate_male" DOUBLE,
  "margin_of_error_male" DOUBLE,
  "estimate_male_agriculture_forestry_fishing_and_hunting_45943dc7" DOUBLE,
  "margin_of_error_male_agriculture_forestry_fishing_and__d6ef9a22" DOUBLE,
  "estimate_male_agriculture_forestry_fishing_and_hunting_efedd900" DOUBLE,
  "margin_of_error_male_agriculture_forestry_fishing_and__f4071769" DOUBLE,
  "estimate_male_agriculture_forestry_fishing_and_hunting_140c935e" DOUBLE,
  "margin_of_error_male_agriculture_forestry_fishing_and__e1a7187d" DOUBLE,
  "estimate_male_construction" DOUBLE,
  "margin_of_error_male_construction" DOUBLE,
  "estimate_male_manufacturing" DOUBLE,
  "margin_of_error_male_manufacturing" DOUBLE,
  "estimate_male_wholesale_trade" DOUBLE,
  "margin_of_error_male_wholesale_trade" DOUBLE,
  "estimate_male_retail_trade" DOUBLE,
  "margin_of_error_male_retail_trade" DOUBLE,
  "estimate_male_transportation_and_warehousing_and_utilities" DOUBLE,
  "margin_of_error_male_transportation_and_warehousing_an_bb9989c5" DOUBLE,
  "estimate_male_transportation_and_warehousing_and_utili_1e60bcdb" DOUBLE,
  "margin_of_error_male_transportation_and_warehousing_an_f7435812" DOUBLE,
  "estimate_male_transportation_and_warehousing_and_utili_6c3f2b44" DOUBLE,
  "margin_of_error_male_transportation_and_warehousing_an_08e44832" DOUBLE,
  "estimate_male_information" DOUBLE,
  "margin_of_error_male_information" DOUBLE,
  "estimate_male_finance_and_insurance_and_real_estate_an_d30fd809" DOUBLE,
  "margin_of_error_male_finance_and_insurance_and_real_es_02cfc2f7" DOUBLE,
  "estimate_male_finance_and_insurance_and_real_estate_an_c370d5f3" DOUBLE,
  "margin_of_error_male_finance_and_insurance_and_real_es_465cf7c8" DOUBLE,
  "estimate_male_finance_and_insurance_and_real_estate_an_47fb9ed3" DOUBLE,
  "margin_of_error_male_finance_and_insurance_and_real_es_56ea11cf" DOUBLE,
  "estimate_male_professional_scientific_and_management_a_15856422" DOUBLE,
  "margin_of_error_male_professional_scientific_and_manag_3a7b15ed" DOUBLE,
  "estimate_male_professional_scientific_and_management_a_23be41c6" DOUBLE,
  "margin_of_error_male_professional_scientific_and_manag_c80348ca" DOUBLE,
  "estimate_male_professional_scientific_and_management_a_6f1866f0" DOUBLE,
  "margin_of_error_male_professional_scientific_and_manag_0b74fb70" DOUBLE,
  "estimate_male_professional_scientific_and_management_a_6113ce6d" DOUBLE,
  "margin_of_error_male_professional_scientific_and_manag_8a248d49" DOUBLE,
  "estimate_male_educational_services_and_health_care_and_584f95e5" DOUBLE,
  "margin_of_error_male_educational_services_and_health_c_3d7ed2e1" DOUBLE,
  "estimate_male_educational_services_and_health_care_and_c166f0e7" DOUBLE,
  "margin_of_error_male_educational_services_and_health_c_99c4020d" DOUBLE,
  "estimate_male_educational_services_and_health_care_and_3c7a0b5e" DOUBLE,
  "margin_of_error_male_educational_services_and_health_c_6691ac48" DOUBLE,
  "estimate_male_arts_entertainment_and_recreation_and_ac_0dcda132" DOUBLE,
  "margin_of_error_male_arts_entertainment_and_recreation_7536801e" DOUBLE,
  "estimate_male_arts_entertainment_and_recreation_and_ac_4f3a85a7" DOUBLE,
  "margin_of_error_male_arts_entertainment_and_recreation_d99e6ad5" DOUBLE,
  "estimate_male_arts_entertainment_and_recreation_and_ac_4838b9d6" DOUBLE,
  "margin_of_error_male_arts_entertainment_and_recreation_ac26fe81" DOUBLE,
  "estimate_male_other_services_except_public_administration" DOUBLE,
  "margin_of_error_male_other_services_except_public_admi_537a12f3" DOUBLE,
  "estimate_male_public_administration" DOUBLE,
  "margin_of_error_male_public_administration" DOUBLE,
  "estimate_female" DOUBLE,
  "margin_of_error_female" DOUBLE,
  "estimate_female_agriculture_forestry_fishing_and_hunti_29450b37" DOUBLE,
  "margin_of_error_female_agriculture_forestry_fishing_an_706d3a7d" DOUBLE,
  "estimate_female_agriculture_forestry_fishing_and_hunti_3c3ca8f3" DOUBLE,
  "margin_of_error_female_agriculture_forestry_fishing_an_3e96a338" DOUBLE,
  "estimate_female_agriculture_forestry_fishing_and_hunti_5b127b3f" DOUBLE,
  "margin_of_error_female_agriculture_forestry_fishing_an_96199c7a" DOUBLE,
  "estimate_female_construction" DOUBLE,
  "margin_of_error_female_construction" DOUBLE,
  "estimate_female_manufacturing" DOUBLE,
  "margin_of_error_female_manufacturing" DOUBLE,
  "estimate_female_wholesale_trade" DOUBLE,
  "margin_of_error_female_wholesale_trade" DOUBLE,
  "estimate_female_retail_trade" DOUBLE,
  "margin_of_error_female_retail_trade" DOUBLE,
  "estimate_female_transportation_and_warehousing_and_utilities" DOUBLE,
  "margin_of_error_female_transportation_and_warehousing__5bf555c9" DOUBLE,
  "estimate_female_transportation_and_warehousing_and_uti_3a3436ec" DOUBLE,
  "margin_of_error_female_transportation_and_warehousing__5f2b267c" DOUBLE,
  "estimate_female_transportation_and_warehousing_and_uti_1986a12d" DOUBLE,
  "margin_of_error_female_transportation_and_warehousing__88b264d1" DOUBLE,
  "estimate_female_information" DOUBLE,
  "margin_of_error_female_information" DOUBLE,
  "estimate_female_finance_and_insurance_and_real_estate__1287908b" DOUBLE,
  "margin_of_error_female_finance_and_insurance_and_real__be908395" DOUBLE,
  "estimate_female_finance_and_insurance_and_real_estate__807404e0" DOUBLE,
  "margin_of_error_female_finance_and_insurance_and_real__e1c101d6" DOUBLE,
  "estimate_female_finance_and_insurance_and_real_estate__edd33d1c" DOUBLE,
  "margin_of_error_female_finance_and_insurance_and_real__b14d2a1e" DOUBLE,
  "estimate_female_professional_scientific_and_management_b8fa2251" DOUBLE,
  "margin_of_error_female_professional_scientific_and_man_f8f77819" DOUBLE,
  "estimate_female_professional_scientific_and_management_6c4a84a7" DOUBLE,
  "margin_of_error_female_professional_scientific_and_man_5216d2f9" DOUBLE,
  "estimate_female_professional_scientific_and_management_c51e32e0" DOUBLE,
  "margin_of_error_female_professional_scientific_and_man_5ceb68da" DOUBLE,
  "estimate_female_professional_scientific_and_management_dbdf5ded" DOUBLE,
  "margin_of_error_female_professional_scientific_and_man_9d6946da" DOUBLE,
  "estimate_female_educational_services_and_health_care_a_294de1e9" DOUBLE,
  "margin_of_error_female_educational_services_and_health_81485a1b" DOUBLE,
  "estimate_female_educational_services_and_health_care_a_b4a64a19" DOUBLE,
  "margin_of_error_female_educational_services_and_health_7896d957" DOUBLE
);

CREATE TABLE sex_by_school_enrollment_by_educational_attainment_by__b42bcc98 (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE,
  "margin_of_error_total" DOUBLE,
  "estimate_male" DOUBLE,
  "margin_of_error_male" DOUBLE,
  "estimate_male_enrolled_in_school" DOUBLE,
  "margin_of_error_male_enrolled_in_school" DOUBLE,
  "estimate_male_enrolled_in_school_employed" DOUBLE,
  "margin_of_error_male_enrolled_in_school_employed" DOUBLE,
  "estimate_male_enrolled_in_school_unemployed" DOUBLE,
  "margin_of_error_male_enrolled_in_school_unemployed" DOUBLE,
  "estimate_male_enrolled_in_school_not_in_labor_force" DOUBLE,
  "margin_of_error_male_enrolled_in_school_not_in_labor_force" DOUBLE,
  "estimate_male_not_enrolled_in_school" DOUBLE,
  "margin_of_error_male_not_enrolled_in_school" DOUBLE,
  "estimate_male_not_enrolled_in_school_high_school_gradu_8be44ca2" DOUBLE,
  "margin_of_error_male_not_enrolled_in_school_high_schoo_be80b2cf" DOUBLE,
  "estimate_male_not_enrolled_in_school_high_school_gradu_c918f163" DOUBLE,
  "margin_of_error_male_not_enrolled_in_school_high_schoo_e12265e1" DOUBLE,
  "estimate_male_not_enrolled_in_school_high_school_gradu_87e0b224" DOUBLE,
  "margin_of_error_male_not_enrolled_in_school_high_schoo_fa439202" DOUBLE,
  "estimate_male_not_enrolled_in_school_high_school_gradu_6259fd9f" DOUBLE,
  "margin_of_error_male_not_enrolled_in_school_high_schoo_93686206" DOUBLE,
  "estimate_male_not_enrolled_in_school_not_high_school_graduate" DOUBLE,
  "margin_of_error_male_not_enrolled_in_school_not_high_s_9916e6be" DOUBLE,
  "estimate_male_not_enrolled_in_school_not_high_school_g_63af6678" DOUBLE,
  "margin_of_error_male_not_enrolled_in_school_not_high_s_2f85cf73" DOUBLE,
  "estimate_male_not_enrolled_in_school_not_high_school_g_889faf1d" DOUBLE,
  "margin_of_error_male_not_enrolled_in_school_not_high_s_9a1db013" DOUBLE,
  "estimate_male_not_enrolled_in_school_not_high_school_g_70e0f9ce" DOUBLE,
  "margin_of_error_male_not_enrolled_in_school_not_high_s_01add1a2" DOUBLE,
  "estimate_female" DOUBLE,
  "margin_of_error_female" DOUBLE,
  "estimate_female_enrolled_in_school" DOUBLE,
  "margin_of_error_female_enrolled_in_school" DOUBLE,
  "estimate_female_enrolled_in_school_employed" DOUBLE,
  "margin_of_error_female_enrolled_in_school_employed" DOUBLE,
  "estimate_female_enrolled_in_school_unemployed" DOUBLE,
  "margin_of_error_female_enrolled_in_school_unemployed" DOUBLE,
  "estimate_female_enrolled_in_school_not_in_labor_force" DOUBLE,
  "margin_of_error_female_enrolled_in_school_not_in_labor_force" DOUBLE,
  "estimate_female_not_enrolled_in_school" DOUBLE,
  "margin_of_error_female_not_enrolled_in_school" DOUBLE,
  "estimate_female_not_enrolled_in_school_high_school_gra_ad151550" DOUBLE,
  "margin_of_error_female_not_enrolled_in_school_high_sch_3858630e" DOUBLE,
  "estimate_female_not_enrolled_in_school_high_school_gra_9f0649e6" DOUBLE,
  "margin_of_error_female_not_enrolled_in_school_high_sch_4e2d262b" DOUBLE,
  "estimate_female_not_enrolled_in_school_high_school_gra_6f6d7b22" DOUBLE,
  "margin_of_error_female_not_enrolled_in_school_high_sch_377abc26" DOUBLE,
  "estimate_female_not_enrolled_in_school_high_school_gra_ec185f9e" DOUBLE,
  "margin_of_error_female_not_enrolled_in_school_high_sch_4f8b3843" DOUBLE,
  "estimate_female_not_enrolled_in_school_not_high_school_43f89f50" DOUBLE,
  "margin_of_error_female_not_enrolled_in_school_not_high_63a9fe87" DOUBLE,
  "estimate_female_not_enrolled_in_school_not_high_school_b23f74c8" DOUBLE,
  "margin_of_error_female_not_enrolled_in_school_not_high_8af5398d" DOUBLE,
  "estimate_female_not_enrolled_in_school_not_high_school_29e251fc" DOUBLE,
  "margin_of_error_female_not_enrolled_in_school_not_high_a3b03c11" DOUBLE,
  "estimate_female_not_enrolled_in_school_not_high_school_6e157411" DOUBLE,
  "margin_of_error_female_not_enrolled_in_school_not_high_6f482ceb" DOUBLE
);

CREATE TABLE social_security_income_in_the_past_12_months_for_households (
  "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
);

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
);

CREATE TABLE total_population (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE,
  "margin_of_error_total" DOUBLE
);

CREATE TABLE types_of_health_insurance_coverage_by_age (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE,
  "margin_of_error_total" DOUBLE,
  "estimate_under_18_years" DOUBLE,
  "margin_of_error_under_18_years" DOUBLE,
  "estimate_under_18_years_with_one_type_of_health_insura_62682e67" DOUBLE,
  "margin_of_error_under_18_years_with_one_type_of_health_31df0c1d" DOUBLE,
  "estimate_under_18_years_with_one_type_of_health_insura_d65f142d" DOUBLE,
  "margin_of_error_under_18_years_with_one_type_of_health_e5b59e7c" DOUBLE,
  "estimate_under_18_years_with_one_type_of_health_insura_47a19434" DOUBLE,
  "margin_of_error_under_18_years_with_one_type_of_health_5c9416ab" DOUBLE,
  "estimate_under_18_years_with_one_type_of_health_insura_1b162472" DOUBLE,
  "margin_of_error_under_18_years_with_one_type_of_health_dd4a8d20" DOUBLE,
  "estimate_under_18_years_with_one_type_of_health_insura_a4bea9ce" DOUBLE,
  "margin_of_error_under_18_years_with_one_type_of_health_7fcc2624" DOUBLE,
  "estimate_under_18_years_with_one_type_of_health_insura_0c38c496" DOUBLE,
  "margin_of_error_under_18_years_with_one_type_of_health_71062d9d" DOUBLE,
  "estimate_under_18_years_with_one_type_of_health_insura_8c649003" DOUBLE,
  "margin_of_error_under_18_years_with_one_type_of_health_6fad35c7" DOUBLE,
  "estimate_under_18_years_with_two_or_more_types_of_heal_5f18def1" DOUBLE,
  "margin_of_error_under_18_years_with_two_or_more_types__57d48694" DOUBLE,
  "estimate_under_18_years_with_two_or_more_types_of_heal_5a5494f9" DOUBLE,
  "margin_of_error_under_18_years_with_two_or_more_types__9e59b920" DOUBLE,
  "estimate_under_18_years_with_two_or_more_types_of_heal_b5794fb3" DOUBLE,
  "margin_of_error_under_18_years_with_two_or_more_types__2b10a9d9" DOUBLE,
  "estimate_under_18_years_with_two_or_more_types_of_heal_305ef6f4" DOUBLE,
  "margin_of_error_under_18_years_with_two_or_more_types__9c4defef" DOUBLE,
  "estimate_under_18_years_with_two_or_more_types_of_heal_7e253016" DOUBLE,
  "margin_of_error_under_18_years_with_two_or_more_types__e9060579" DOUBLE,
  "estimate_under_18_years_with_two_or_more_types_of_heal_fbdde91d" DOUBLE,
  "margin_of_error_under_18_years_with_two_or_more_types__d2dcdcd0" DOUBLE,
  "estimate_under_18_years_with_two_or_more_types_of_heal_b7f1882f" DOUBLE,
  "margin_of_error_under_18_years_with_two_or_more_types__8b8450b3" DOUBLE,
  "estimate_under_18_years_no_health_insurance_coverage" DOUBLE,
  "margin_of_error_under_18_years_no_health_insurance_coverage" DOUBLE,
  "estimate_18_to_34_years" DOUBLE,
  "margin_of_error_18_to_34_years" DOUBLE,
  "estimate_18_to_34_years_with_one_type_of_health_insura_54f179c4" DOUBLE,
  "margin_of_error_18_to_34_years_with_one_type_of_health_ab46aa2c" DOUBLE,
  "estimate_18_to_34_years_with_one_type_of_health_insura_f35e286f" DOUBLE,
  "margin_of_error_18_to_34_years_with_one_type_of_health_e2f8a923" DOUBLE,
  "estimate_18_to_34_years_with_one_type_of_health_insura_08ceed7b" DOUBLE,
  "margin_of_error_18_to_34_years_with_one_type_of_health_d539a7d6" DOUBLE,
  "estimate_18_to_34_years_with_one_type_of_health_insura_bf5b6f15" DOUBLE,
  "margin_of_error_18_to_34_years_with_one_type_of_health_92013a27" DOUBLE,
  "estimate_18_to_34_years_with_one_type_of_health_insura_559d6c1f" DOUBLE,
  "margin_of_error_18_to_34_years_with_one_type_of_health_22c4f658" DOUBLE,
  "estimate_18_to_34_years_with_one_type_of_health_insura_f596e56a" DOUBLE,
  "margin_of_error_18_to_34_years_with_one_type_of_health_3fceeec8" DOUBLE,
  "estimate_18_to_34_years_with_one_type_of_health_insura_acad1313" DOUBLE,
  "margin_of_error_18_to_34_years_with_one_type_of_health_9cd57e82" DOUBLE,
  "estimate_18_to_34_years_with_two_or_more_types_of_heal_4330fbb3" DOUBLE,
  "margin_of_error_18_to_34_years_with_two_or_more_types__86a817cf" DOUBLE,
  "estimate_18_to_34_years_with_two_or_more_types_of_heal_5c5c6036" DOUBLE,
  "margin_of_error_18_to_34_years_with_two_or_more_types__7ed60ed2" DOUBLE,
  "estimate_18_to_34_years_with_two_or_more_types_of_heal_d5a29452" DOUBLE,
  "margin_of_error_18_to_34_years_with_two_or_more_types__cd2a3459" DOUBLE,
  "estimate_18_to_34_years_with_two_or_more_types_of_heal_e8dd4af9" DOUBLE,
  "margin_of_error_18_to_34_years_with_two_or_more_types__0c838aae" DOUBLE,
  "estimate_18_to_34_years_with_two_or_more_types_of_heal_5948f993" DOUBLE,
  "margin_of_error_18_to_34_years_with_two_or_more_types__74dc8b16" DOUBLE,
  "estimate_18_to_34_years_with_two_or_more_types_of_heal_a5aa99ef" DOUBLE,
  "margin_of_error_18_to_34_years_with_two_or_more_types__8fe567b1" DOUBLE,
  "estimate_18_to_34_years_with_two_or_more_types_of_heal_01e02aeb" DOUBLE,
  "margin_of_error_18_to_34_years_with_two_or_more_types__b1275031" DOUBLE,
  "estimate_18_to_34_years_no_health_insurance_coverage" DOUBLE,
  "margin_of_error_18_to_34_years_no_health_insurance_coverage" DOUBLE,
  "estimate_35_to_64_years" DOUBLE,
  "margin_of_error_35_to_64_years" DOUBLE,
  "estimate_35_to_64_years_with_one_type_of_health_insura_0a611804" DOUBLE,
  "margin_of_error_35_to_64_years_with_one_type_of_health_c179e7ee" DOUBLE,
  "estimate_35_to_64_years_with_one_type_of_health_insura_aa0253a3" DOUBLE,
  "margin_of_error_35_to_64_years_with_one_type_of_health_31716d82" DOUBLE,
  "estimate_35_to_64_years_with_one_type_of_health_insura_7b161379" DOUBLE,
  "margin_of_error_35_to_64_years_with_one_type_of_health_5daffe58" DOUBLE,
  "estimate_35_to_64_years_with_one_type_of_health_insura_79dd987e" DOUBLE,
  "margin_of_error_35_to_64_years_with_one_type_of_health_97f20a6c" DOUBLE,
  "estimate_35_to_64_years_with_one_type_of_health_insura_7ad4b109" DOUBLE,
  "margin_of_error_35_to_64_years_with_one_type_of_health_911ef165" DOUBLE,
  "estimate_35_to_64_years_with_one_type_of_health_insura_7dae935a" DOUBLE,
  "margin_of_error_35_to_64_years_with_one_type_of_health_46656649" DOUBLE,
  "estimate_35_to_64_years_with_one_type_of_health_insura_eaad7a8e" DOUBLE,
  "margin_of_error_35_to_64_years_with_one_type_of_health_fd0629a8" DOUBLE,
  "estimate_35_to_64_years_with_two_or_more_types_of_heal_b1f19c5b" DOUBLE,
  "margin_of_error_35_to_64_years_with_two_or_more_types__50b64095" DOUBLE,
  "estimate_35_to_64_years_with_two_or_more_types_of_heal_ff01e268" DOUBLE,
  "margin_of_error_35_to_64_years_with_two_or_more_types__3024603c" DOUBLE,
  "estimate_35_to_64_years_with_two_or_more_types_of_heal_30703549" DOUBLE,
  "margin_of_error_35_to_64_years_with_two_or_more_types__9a646079" DOUBLE,
  "estimate_35_to_64_years_with_two_or_more_types_of_heal_03e8bc41" DOUBLE,
  "margin_of_error_35_to_64_years_with_two_or_more_types__85622630" DOUBLE,
  "estimate_35_to_64_years_with_two_or_more_types_of_heal_c1af1c86" DOUBLE,
  "margin_of_error_35_to_64_years_with_two_or_more_types__227f60c2" DOUBLE,
  "estimate_35_to_64_years_with_two_or_more_types_of_heal_67cbc1fe" DOUBLE,
  "margin_of_error_35_to_64_years_with_two_or_more_types__5e17e736" DOUBLE,
  "estimate_35_to_64_years_with_two_or_more_types_of_heal_2bbde812" DOUBLE,
  "margin_of_error_35_to_64_years_with_two_or_more_types__53bb456b" DOUBLE,
  "estimate_35_to_64_years_with_two_or_more_types_of_heal_d08d17b0" DOUBLE,
  "margin_of_error_35_to_64_years_with_two_or_more_types__f54e1a66" DOUBLE
);

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
);