Pittsburgh American Community Survey 2015 - Miscellaneous Data
Allegheny County / City of Pittsburgh / Western PA Regional Data Center
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_a2ddc202
Allegheny County / City of Pittsburgh / Western PA Regional Data Center
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_a2ddc202
Miscellaneous Reports from the 2015 American Community Survey Report
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:11:53.523148
Tags: acs, age, american-community-survey, census, demographics, education, employment, health-insurance, healthcare, housing, income, mortgage, population, public-assistance, race, rent, retirement, salary, wage
CREATE TABLE contract_rent (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_with_cash_rent" DOUBLE -- Estimate; With Cash Rent:,
"margin_of_error_with_cash_rent" DOUBLE -- Margin Of Error; With Cash Rent:,
"estimate_with_cash_rent_less_than_100" DOUBLE -- Estimate; With Cash Rent: - Less Than $100,
"margin_of_error_with_cash_rent_less_than_100" DOUBLE -- Margin Of Error; With Cash Rent: - Less Than $100,
"estimate_with_cash_rent_100_to_149" DOUBLE -- Estimate; With Cash Rent: - $100 To $149,
"margin_of_error_with_cash_rent_100_to_149" DOUBLE -- Margin Of Error; With Cash Rent: - $100 To $149,
"estimate_with_cash_rent_150_to_199" DOUBLE -- Estimate; With Cash Rent: - $150 To $199,
"margin_of_error_with_cash_rent_150_to_199" DOUBLE -- Margin Of Error; With Cash Rent: - $150 To $199,
"estimate_with_cash_rent_200_to_249" DOUBLE -- Estimate; With Cash Rent: - $200 To $249,
"margin_of_error_with_cash_rent_200_to_249" DOUBLE -- Margin Of Error; With Cash Rent: - $200 To $249,
"estimate_with_cash_rent_250_to_299" DOUBLE -- Estimate; With Cash Rent: - $250 To $299,
"margin_of_error_with_cash_rent_250_to_299" DOUBLE -- Margin Of Error; With Cash Rent: - $250 To $299,
"estimate_with_cash_rent_300_to_349" DOUBLE -- Estimate; With Cash Rent: - $300 To $349,
"margin_of_error_with_cash_rent_300_to_349" DOUBLE -- Margin Of Error; With Cash Rent: - $300 To $349,
"estimate_with_cash_rent_350_to_399" DOUBLE -- Estimate; With Cash Rent: - $350 To $399,
"margin_of_error_with_cash_rent_350_to_399" DOUBLE -- Margin Of Error; With Cash Rent: - $350 To $399,
"estimate_with_cash_rent_400_to_449" DOUBLE -- Estimate; With Cash Rent: - $400 To $449,
"margin_of_error_with_cash_rent_400_to_449" DOUBLE -- Margin Of Error; With Cash Rent: - $400 To $449,
"estimate_with_cash_rent_450_to_499" DOUBLE -- Estimate; With Cash Rent: - $450 To $499,
"margin_of_error_with_cash_rent_450_to_499" DOUBLE -- Margin Of Error; With Cash Rent: - $450 To $499,
"estimate_with_cash_rent_500_to_549" DOUBLE -- Estimate; With Cash Rent: - $500 To $549,
"margin_of_error_with_cash_rent_500_to_549" DOUBLE -- Margin Of Error; With Cash Rent: - $500 To $549,
"estimate_with_cash_rent_550_to_599" DOUBLE -- Estimate; With Cash Rent: - $550 To $599,
"margin_of_error_with_cash_rent_550_to_599" DOUBLE -- Margin Of Error; With Cash Rent: - $550 To $599,
"estimate_with_cash_rent_600_to_649" DOUBLE -- Estimate; With Cash Rent: - $600 To $649,
"margin_of_error_with_cash_rent_600_to_649" DOUBLE -- Margin Of Error; With Cash Rent: - $600 To $649,
"estimate_with_cash_rent_650_to_699" DOUBLE -- Estimate; With Cash Rent: - $650 To $699,
"margin_of_error_with_cash_rent_650_to_699" DOUBLE -- Margin Of Error; With Cash Rent: - $650 To $699,
"estimate_with_cash_rent_700_to_749" DOUBLE -- Estimate; With Cash Rent: - $700 To $749,
"margin_of_error_with_cash_rent_700_to_749" DOUBLE -- Margin Of Error; With Cash Rent: - $700 To $749,
"estimate_with_cash_rent_750_to_799" DOUBLE -- Estimate; With Cash Rent: - $750 To $799,
"margin_of_error_with_cash_rent_750_to_799" DOUBLE -- Margin Of Error; With Cash Rent: - $750 To $799,
"estimate_with_cash_rent_800_to_899" DOUBLE -- Estimate; With Cash Rent: - $800 To $899,
"margin_of_error_with_cash_rent_800_to_899" DOUBLE -- Margin Of Error; With Cash Rent: - $800 To $899,
"estimate_with_cash_rent_900_to_999" DOUBLE -- Estimate; With Cash Rent: - $900 To $999,
"margin_of_error_with_cash_rent_900_to_999" DOUBLE -- Margin Of Error; With Cash Rent: - $900 To $999,
"estimate_with_cash_rent_1_000_to_1_249" DOUBLE -- Estimate; With Cash Rent: - $1,000 To $1,249,
"margin_of_error_with_cash_rent_1_000_to_1_249" DOUBLE -- Margin Of Error; With Cash Rent: - $1,000 To $1,249,
"estimate_with_cash_rent_1_250_to_1_499" DOUBLE -- Estimate; With Cash Rent: - $1,250 To $1,499,
"margin_of_error_with_cash_rent_1_250_to_1_499" DOUBLE -- Margin Of Error; With Cash Rent: - $1,250 To $1,499,
"estimate_with_cash_rent_1_500_to_1_999" DOUBLE -- Estimate; With Cash Rent: - $1,500 To $1,999,
"margin_of_error_with_cash_rent_1_500_to_1_999" DOUBLE -- Margin Of Error; With Cash Rent: - $1,500 To $1,999,
"estimate_with_cash_rent_2_000_to_2_499" DOUBLE -- Estimate; With Cash Rent: - $2,000 To $2,499,
"margin_of_error_with_cash_rent_2_000_to_2_499" DOUBLE -- Margin Of Error; With Cash Rent: - $2,000 To $2,499,
"estimate_with_cash_rent_2_500_to_2_999" DOUBLE -- Estimate; With Cash Rent: - $2,500 To $2,999,
"margin_of_error_with_cash_rent_2_500_to_2_999" DOUBLE -- Margin Of Error; With Cash Rent: - $2,500 To $2,999,
"estimate_with_cash_rent_3_000_to_3_499" DOUBLE -- Estimate; With Cash Rent: - $3,000 To $3,499,
"margin_of_error_with_cash_rent_3_000_to_3_499" DOUBLE -- Margin Of Error; With Cash Rent: - $3,000 To $3,499,
"estimate_with_cash_rent_3_500_or_more" DOUBLE -- Estimate; With Cash Rent: - $3,500 Or More,
"margin_of_error_with_cash_rent_3_500_or_more" DOUBLE -- Margin Of Error; With Cash Rent: - $3,500 Or More,
"estimate_no_cash_rent" DOUBLE -- Estimate; No Cash Rent,
"margin_of_error_no_cash_rent" DOUBLE -- Margin Of Error; No Cash Rent
);CREATE TABLE educational_attainment_for_the_population_25_years_and_over (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_total_no_schooling_completed" DOUBLE -- Estimate; Total: - No Schooling Completed,
"margin_of_error_total_no_schooling_completed" DOUBLE -- Margin Of Error; Total: - No Schooling Completed,
"estimate_total_nursery_school" DOUBLE -- Estimate; Total: - Nursery School,
"margin_of_error_total_nursery_school" DOUBLE -- Margin Of Error; Total: - Nursery School,
"estimate_total_kindergarten" DOUBLE -- Estimate; Total: - Kindergarten,
"margin_of_error_total_kindergarten" DOUBLE -- Margin Of Error; Total: - Kindergarten,
"estimate_total_1st_grade" DOUBLE -- Estimate; Total: - 1st Grade,
"margin_of_error_total_1st_grade" DOUBLE -- Margin Of Error; Total: - 1st Grade,
"estimate_total_2nd_grade" DOUBLE -- Estimate; Total: - 2nd Grade,
"margin_of_error_total_2nd_grade" DOUBLE -- Margin Of Error; Total: - 2nd Grade,
"estimate_total_3rd_grade" DOUBLE -- Estimate; Total: - 3rd Grade,
"margin_of_error_total_3rd_grade" DOUBLE -- Margin Of Error; Total: - 3rd Grade,
"estimate_total_4th_grade" DOUBLE -- Estimate; Total: - 4th Grade,
"margin_of_error_total_4th_grade" DOUBLE -- Margin Of Error; Total: - 4th Grade,
"estimate_total_5th_grade" DOUBLE -- Estimate; Total: - 5th Grade,
"margin_of_error_total_5th_grade" DOUBLE -- Margin Of Error; Total: - 5th Grade,
"estimate_total_6th_grade" DOUBLE -- Estimate; Total: - 6th Grade,
"margin_of_error_total_6th_grade" DOUBLE -- Margin Of Error; Total: - 6th Grade,
"estimate_total_7th_grade" DOUBLE -- Estimate; Total: - 7th Grade,
"margin_of_error_total_7th_grade" DOUBLE -- Margin Of Error; Total: - 7th Grade,
"estimate_total_8th_grade" DOUBLE -- Estimate; Total: - 8th Grade,
"margin_of_error_total_8th_grade" DOUBLE -- Margin Of Error; Total: - 8th Grade,
"estimate_total_9th_grade" DOUBLE -- Estimate; Total: - 9th Grade,
"margin_of_error_total_9th_grade" DOUBLE -- Margin Of Error; Total: - 9th Grade,
"estimate_total_10th_grade" DOUBLE -- Estimate; Total: - 10th Grade,
"margin_of_error_total_10th_grade" DOUBLE -- Margin Of Error; Total: - 10th Grade,
"estimate_total_11th_grade" DOUBLE -- Estimate; Total: - 11th Grade,
"margin_of_error_total_11th_grade" DOUBLE -- Margin Of Error; Total: - 11th Grade,
"estimate_total_12th_grade_no_diploma" DOUBLE -- Estimate; Total: - 12th Grade, No Diploma,
"margin_of_error_total_12th_grade_no_diploma" DOUBLE -- Margin Of Error; Total: - 12th Grade, No Diploma,
"estimate_total_regular_high_school_diploma" DOUBLE -- Estimate; Total: - Regular High School Diploma,
"margin_of_error_total_regular_high_school_diploma" DOUBLE -- Margin Of Error; Total: - Regular High School Diploma,
"estimate_total_ged_or_alternative_credential" DOUBLE -- Estimate; Total: - GED Or Alternative Credential,
"margin_of_error_total_ged_or_alternative_credential" DOUBLE -- Margin Of Error; Total: - GED Or Alternative Credential,
"estimate_total_some_college_less_than_1_year" DOUBLE -- Estimate; Total: - Some College, Less Than 1 Year,
"margin_of_error_total_some_college_less_than_1_year" DOUBLE -- Margin Of Error; Total: - Some College, Less Than 1 Year,
"estimate_total_some_college_1_or_more_years_no_degree" DOUBLE -- Estimate; Total: - Some College, 1 Or More Years, No Degree,
"margin_of_error_total_some_college_1_or_more_years_no_degree" DOUBLE -- Margin Of Error; Total: - Some College, 1 Or More Years, No Degree,
"estimate_total_associate_s_degree" DOUBLE -- Estimate; Total: - Associate's Degree,
"margin_of_error_total_associate_s_degree" DOUBLE -- Margin Of Error; Total: - Associate's Degree,
"estimate_total_bachelor_s_degree" DOUBLE -- Estimate; Total: - Bachelor's Degree,
"margin_of_error_total_bachelor_s_degree" DOUBLE -- Margin Of Error; Total: - Bachelor's Degree,
"estimate_total_master_s_degree" DOUBLE -- Estimate; Total: - Master's Degree,
"margin_of_error_total_master_s_degree" DOUBLE -- Margin Of Error; Total: - Master's Degree,
"estimate_total_professional_school_degree" DOUBLE -- Estimate; Total: - Professional School Degree,
"margin_of_error_total_professional_school_degree" DOUBLE -- Margin Of Error; Total: - Professional School Degree,
"estimate_total_doctorate_degree" DOUBLE -- Estimate; Total: - Doctorate Degree,
"margin_of_error_total_doctorate_degree" DOUBLE -- Margin Of Error; Total: - Doctorate Degree
);CREATE TABLE household_income_in_the_past_12_months_in_2015_inflati_ddb67809 (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_total_less_than_10_000" DOUBLE -- Estimate; Total: - Less Than $10,000,
"margin_of_error_total_less_than_10_000" DOUBLE -- Margin Of Error; Total: - Less Than $10,000,
"estimate_total_10_000_to_14_999" DOUBLE -- Estimate; Total: - $10,000 To $14,999,
"margin_of_error_total_10_000_to_14_999" DOUBLE -- Margin Of Error; Total: - $10,000 To $14,999,
"estimate_total_15_000_to_19_999" DOUBLE -- Estimate; Total: - $15,000 To $19,999,
"margin_of_error_total_15_000_to_19_999" DOUBLE -- Margin Of Error; Total: - $15,000 To $19,999,
"estimate_total_20_000_to_24_999" DOUBLE -- Estimate; Total: - $20,000 To $24,999,
"margin_of_error_total_20_000_to_24_999" DOUBLE -- Margin Of Error; Total: - $20,000 To $24,999,
"estimate_total_25_000_to_29_999" DOUBLE -- Estimate; Total: - $25,000 To $29,999,
"margin_of_error_total_25_000_to_29_999" DOUBLE -- Margin Of Error; Total: - $25,000 To $29,999,
"estimate_total_30_000_to_34_999" DOUBLE -- Estimate; Total: - $30,000 To $34,999,
"margin_of_error_total_30_000_to_34_999" DOUBLE -- Margin Of Error; Total: - $30,000 To $34,999,
"estimate_total_35_000_to_39_999" DOUBLE -- Estimate; Total: - $35,000 To $39,999,
"margin_of_error_total_35_000_to_39_999" DOUBLE -- Margin Of Error; Total: - $35,000 To $39,999,
"estimate_total_40_000_to_44_999" DOUBLE -- Estimate; Total: - $40,000 To $44,999,
"margin_of_error_total_40_000_to_44_999" DOUBLE -- Margin Of Error; Total: - $40,000 To $44,999,
"estimate_total_45_000_to_49_999" DOUBLE -- Estimate; Total: - $45,000 To $49,999,
"margin_of_error_total_45_000_to_49_999" DOUBLE -- Margin Of Error; Total: - $45,000 To $49,999,
"estimate_total_50_000_to_59_999" DOUBLE -- Estimate; Total: - $50,000 To $59,999,
"margin_of_error_total_50_000_to_59_999" DOUBLE -- Margin Of Error; Total: - $50,000 To $59,999,
"estimate_total_60_000_to_74_999" DOUBLE -- Estimate; Total: - $60,000 To $74,999,
"margin_of_error_total_60_000_to_74_999" DOUBLE -- Margin Of Error; Total: - $60,000 To $74,999,
"estimate_total_75_000_to_99_999" DOUBLE -- Estimate; Total: - $75,000 To $99,999,
"margin_of_error_total_75_000_to_99_999" DOUBLE -- Margin Of Error; Total: - $75,000 To $99,999,
"estimate_total_100_000_to_124_999" DOUBLE -- Estimate; Total: - $100,000 To $124,999,
"margin_of_error_total_100_000_to_124_999" DOUBLE -- Margin Of Error; Total: - $100,000 To $124,999,
"estimate_total_125_000_to_149_999" DOUBLE -- Estimate; Total: - $125,000 To $149,999,
"margin_of_error_total_125_000_to_149_999" DOUBLE -- Margin Of Error; Total: - $125,000 To $149,999,
"estimate_total_150_000_to_199_999" DOUBLE -- Estimate; Total: - $150,000 To $199,999,
"margin_of_error_total_150_000_to_199_999" DOUBLE -- Margin Of Error; Total: - $150,000 To $199,999,
"estimate_total_200_000_or_more" DOUBLE -- Estimate; Total: - $200,000 Or More,
"margin_of_error_total_200_000_or_more" DOUBLE -- Margin Of Error; Total: - $200,000 Or More
);CREATE TABLE housing_units (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total
);CREATE TABLE housing_unit_value (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_total_less_than_10_000" DOUBLE -- Estimate; Total: - Less Than $10,000,
"margin_of_error_total_less_than_10_000" DOUBLE -- Margin Of Error; Total: - Less Than $10,000,
"estimate_total_10_000_to_14_999" DOUBLE -- Estimate; Total: - $10,000 To $14,999,
"margin_of_error_total_10_000_to_14_999" DOUBLE -- Margin Of Error; Total: - $10,000 To $14,999,
"estimate_total_15_000_to_19_999" DOUBLE -- Estimate; Total: - $15,000 To $19,999,
"margin_of_error_total_15_000_to_19_999" DOUBLE -- Margin Of Error; Total: - $15,000 To $19,999,
"estimate_total_20_000_to_24_999" DOUBLE -- Estimate; Total: - $20,000 To $24,999,
"margin_of_error_total_20_000_to_24_999" DOUBLE -- Margin Of Error; Total: - $20,000 To $24,999,
"estimate_total_25_000_to_29_999" DOUBLE -- Estimate; Total: - $25,000 To $29,999,
"margin_of_error_total_25_000_to_29_999" DOUBLE -- Margin Of Error; Total: - $25,000 To $29,999,
"estimate_total_30_000_to_34_999" DOUBLE -- Estimate; Total: - $30,000 To $34,999,
"margin_of_error_total_30_000_to_34_999" DOUBLE -- Margin Of Error; Total: - $30,000 To $34,999,
"estimate_total_35_000_to_39_999" DOUBLE -- Estimate; Total: - $35,000 To $39,999,
"margin_of_error_total_35_000_to_39_999" DOUBLE -- Margin Of Error; Total: - $35,000 To $39,999,
"estimate_total_40_000_to_49_999" DOUBLE -- Estimate; Total: - $40,000 To $49,999,
"margin_of_error_total_40_000_to_49_999" DOUBLE -- Margin Of Error; Total: - $40,000 To $49,999,
"estimate_total_50_000_to_59_999" DOUBLE -- Estimate; Total: - $50,000 To $59,999,
"margin_of_error_total_50_000_to_59_999" DOUBLE -- Margin Of Error; Total: - $50,000 To $59,999,
"estimate_total_60_000_to_69_999" DOUBLE -- Estimate; Total: - $60,000 To $69,999,
"margin_of_error_total_60_000_to_69_999" DOUBLE -- Margin Of Error; Total: - $60,000 To $69,999,
"estimate_total_70_000_to_79_999" DOUBLE -- Estimate; Total: - $70,000 To $79,999,
"margin_of_error_total_70_000_to_79_999" DOUBLE -- Margin Of Error; Total: - $70,000 To $79,999,
"estimate_total_80_000_to_89_999" DOUBLE -- Estimate; Total: - $80,000 To $89,999,
"margin_of_error_total_80_000_to_89_999" DOUBLE -- Margin Of Error; Total: - $80,000 To $89,999,
"estimate_total_90_000_to_99_999" DOUBLE -- Estimate; Total: - $90,000 To $99,999,
"margin_of_error_total_90_000_to_99_999" DOUBLE -- Margin Of Error; Total: - $90,000 To $99,999,
"estimate_total_100_000_to_124_999" DOUBLE -- Estimate; Total: - $100,000 To $124,999,
"margin_of_error_total_100_000_to_124_999" DOUBLE -- Margin Of Error; Total: - $100,000 To $124,999,
"estimate_total_125_000_to_149_999" DOUBLE -- Estimate; Total: - $125,000 To $149,999,
"margin_of_error_total_125_000_to_149_999" DOUBLE -- Margin Of Error; Total: - $125,000 To $149,999,
"estimate_total_150_000_to_174_999" DOUBLE -- Estimate; Total: - $150,000 To $174,999,
"margin_of_error_total_150_000_to_174_999" DOUBLE -- Margin Of Error; Total: - $150,000 To $174,999,
"estimate_total_175_000_to_199_999" DOUBLE -- Estimate; Total: - $175,000 To $199,999,
"margin_of_error_total_175_000_to_199_999" DOUBLE -- Margin Of Error; Total: - $175,000 To $199,999,
"estimate_total_200_000_to_249_999" DOUBLE -- Estimate; Total: - $200,000 To $249,999,
"margin_of_error_total_200_000_to_249_999" DOUBLE -- Margin Of Error; Total: - $200,000 To $249,999,
"estimate_total_250_000_to_299_999" DOUBLE -- Estimate; Total: - $250,000 To $299,999,
"margin_of_error_total_250_000_to_299_999" DOUBLE -- Margin Of Error; Total: - $250,000 To $299,999,
"estimate_total_300_000_to_399_999" DOUBLE -- Estimate; Total: - $300,000 To $399,999,
"margin_of_error_total_300_000_to_399_999" DOUBLE -- Margin Of Error; Total: - $300,000 To $399,999,
"estimate_total_400_000_to_499_999" DOUBLE -- Estimate; Total: - $400,000 To $499,999,
"margin_of_error_total_400_000_to_499_999" DOUBLE -- Margin Of Error; Total: - $400,000 To $499,999,
"estimate_total_500_000_to_749_999" DOUBLE -- Estimate; Total: - $500,000 To $749,999,
"margin_of_error_total_500_000_to_749_999" DOUBLE -- Margin Of Error; Total: - $500,000 To $749,999,
"estimate_total_750_000_to_999_999" DOUBLE -- Estimate; Total: - $750,000 To $999,999,
"margin_of_error_total_750_000_to_999_999" DOUBLE -- Margin Of Error; Total: - $750,000 To $999,999,
"estimate_total_1_000_000_to_1_499_999" DOUBLE -- Estimate; Total: - $1,000,000 To $1,499,999,
"margin_of_error_total_1_000_000_to_1_499_999" DOUBLE -- Margin Of Error; Total: - $1,000,000 To $1,499,999,
"estimate_total_1_500_000_to_1_999_999" DOUBLE -- Estimate; Total: - $1,500,000 To $1,999,999,
"margin_of_error_total_1_500_000_to_1_999_999" DOUBLE -- Margin Of Error; Total: - $1,500,000 To $1,999,999,
"estimate_total_2_000_000_or_more" DOUBLE -- Estimate; Total: - $2,000,000 Or More,
"margin_of_error_total_2_000_000_or_more" DOUBLE -- Margin Of Error; Total: - $2,000,000 Or More
);CREATE TABLE mortgage_status (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_housing_units_with_a_mortgage_contract_to_pur_d3feed0e" DOUBLE -- Estimate; Housing Units With A Mortgage, Contract To Purchase, Or Similar Debt:,
"margin_of_error_housing_units_with_a_mortgage_contract_9bb7ee9d" DOUBLE -- Margin Of Error; Housing Units With A Mortgage, Contract To Purchase, Or Similar Debt:,
"estimate_housing_units_with_a_mortgage_contract_to_pur_49d5a658" DOUBLE -- Estimate; Housing Units With A Mortgage, Contract To Purchase, Or Similar Debt: - With Either A Second Mortgage Or Home Equity Loan, But Not Both:,
"margin_of_error_housing_units_with_a_mortgage_contract_48c18a85" DOUBLE -- Margin Of Error; Housing Units With A Mortgage, Contract To Purchase, Or Similar Debt: - With Either A Second Mortgage Or Home Equity Loan, But Not Both:,
"estimate_housing_units_with_a_mortgage_contract_to_pur_b495f382" DOUBLE -- Estimate; Housing Units With A Mortgage, Contract To Purchase, Or Similar Debt: - With Either A Second Mortgage Or Home Equity Loan, But Not Both: - Second Mortgage Only,
"margin_of_error_housing_units_with_a_mortgage_contract_7fbf6358" DOUBLE -- Margin Of Error; Housing Units With A Mortgage, Contract To Purchase, Or Similar Debt: - With Either A Second Mortgage Or Home Equity Loan, But Not Both: - Second Mortgage Only,
"estimate_housing_units_with_a_mortgage_contract_to_pur_6e7820de" DOUBLE -- Estimate; Housing Units With A Mortgage, Contract To Purchase, Or Similar Debt: - With Either A Second Mortgage Or Home Equity Loan, But Not Both: - Home Equity Loan Only,
"margin_of_error_housing_units_with_a_mortgage_contract_1fdffde3" DOUBLE -- Margin Of Error; Housing Units With A Mortgage, Contract To Purchase, Or Similar Debt: - With Either A Second Mortgage Or Home Equity Loan, But Not Both: - Home Equity Loan Only,
"estimate_housing_units_with_a_mortgage_contract_to_pur_96514c32" DOUBLE -- Estimate; Housing Units With A Mortgage, Contract To Purchase, Or Similar Debt: - Both Second Mortgage And Home Equity Loan,
"margin_of_error_housing_units_with_a_mortgage_contract_39255739" DOUBLE -- Margin Of Error; Housing Units With A Mortgage, Contract To Purchase, Or Similar Debt: - Both Second Mortgage And Home Equity Loan,
"estimate_housing_units_with_a_mortgage_contract_to_pur_42f07528" DOUBLE -- Estimate; Housing Units With A Mortgage, Contract To Purchase, Or Similar Debt: - No Second Mortgage And No Home Equity Loan,
"margin_of_error_housing_units_with_a_mortgage_contract_e42b3ba8" DOUBLE -- Margin Of Error; Housing Units With A Mortgage, Contract To Purchase, Or Similar Debt: - No Second Mortgage And No Home Equity Loan,
"estimate_housing_units_without_a_mortgage" DOUBLE -- Estimate; Housing Units Without A Mortgage,
"margin_of_error_housing_units_without_a_mortgage" DOUBLE -- Margin Of Error; Housing Units Without A Mortgage
);CREATE TABLE public_assistance_income_in_the_past_12_months_for_households (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_total_with_public_assistance_income" DOUBLE -- Estimate; Total: - With Public Assistance Income,
"margin_of_error_total_with_public_assistance_income" DOUBLE -- Margin Of Error; Total: - With Public Assistance Income,
"estimate_total_no_public_assistance_income" DOUBLE -- Estimate; Total: - No Public Assistance Income,
"margin_of_error_total_no_public_assistance_income" DOUBLE -- Margin Of Error; Total: - No Public Assistance Income
);CREATE TABLE race (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_total_white_alone" DOUBLE -- Estimate; Total: - White Alone,
"margin_of_error_total_white_alone" DOUBLE -- Margin Of Error; Total: - White Alone,
"estimate_total_black_or_african_american_alone" DOUBLE -- Estimate; Total: - Black Or African American Alone,
"margin_of_error_total_black_or_african_american_alone" DOUBLE -- Margin Of Error; Total: - Black Or African American Alone,
"estimate_total_american_indian_and_alaska_native_alone" DOUBLE -- Estimate; Total: - American Indian And Alaska Native Alone,
"margin_of_error_total_american_indian_and_alaska_native_alone" DOUBLE -- Margin Of Error; Total: - American Indian And Alaska Native Alone,
"estimate_total_asian_alone" DOUBLE -- Estimate; Total: - Asian Alone,
"margin_of_error_total_asian_alone" DOUBLE -- Margin Of Error; Total: - Asian Alone,
"estimate_total_native_hawaiian_and_other_pacific_islander_alone" DOUBLE -- Estimate; Total: - Native Hawaiian And Other Pacific Islander Alone,
"margin_of_error_total_native_hawaiian_and_other_pacifi_0e4ff679" DOUBLE -- Margin Of Error; Total: - Native Hawaiian And Other Pacific Islander Alone,
"estimate_total_some_other_race_alone" DOUBLE -- Estimate; Total: - Some Other Race Alone,
"margin_of_error_total_some_other_race_alone" DOUBLE -- Margin Of Error; Total: - Some Other Race Alone,
"estimate_total_two_or_more_races" DOUBLE -- Estimate; Total: - Two Or More Races:,
"margin_of_error_total_two_or_more_races" DOUBLE -- Margin Of Error; Total: - Two Or More Races:,
"estimate_total_two_or_more_races_two_races_including_s_f38a59af" DOUBLE -- Estimate; Total: - Two Or More Races: - Two Races Including Some Other Race,
"margin_of_error_total_two_or_more_races_two_races_incl_6e216665" DOUBLE -- Margin Of Error; Total: - Two Or More Races: - Two Races Including Some Other Race,
"estimate_total_two_or_more_races_two_races_excluding_s_7c65a5a6" DOUBLE -- Estimate; Total: - Two Or More Races: - Two Races Excluding Some Other Race, And Three Or More Races,
"margin_of_error_total_two_or_more_races_two_races_excl_24d61c7e" DOUBLE -- Margin Of Error; Total: - Two Or More Races: - Two Races Excluding Some Other Race, And Three Or More Races
);CREATE TABLE retirement_income_in_the_past_12_months_for_households (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_total_with_retirement_income" DOUBLE -- Estimate; Total: - With Retirement Income,
"margin_of_error_total_with_retirement_income" DOUBLE -- Margin Of Error; Total: - With Retirement Income,
"estimate_total_no_retirement_income" DOUBLE -- Estimate; Total: - No Retirement Income,
"margin_of_error_total_no_retirement_income" DOUBLE -- Margin Of Error; Total: - No Retirement Income
);CREATE TABLE self_employment_income_in_the_past_12_months_for_households (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_total_with_self_employment_income" DOUBLE -- Estimate; Total: - With Self-employment Income,
"margin_of_error_total_with_self_employment_income" DOUBLE -- Margin Of Error; Total: - With Self-employment Income,
"estimate_total_no_self_employment_income" DOUBLE -- Estimate; Total: - No Self-employment Income,
"margin_of_error_total_no_self_employment_income" DOUBLE -- Margin Of Error; Total: - No Self-employment Income
);CREATE TABLE sex_by_age (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_male" DOUBLE -- Estimate; Male:,
"margin_of_error_male" DOUBLE -- Margin Of Error; Male:,
"estimate_male_under_5_years" DOUBLE -- Estimate; Male: - Under 5 Years,
"margin_of_error_male_under_5_years" DOUBLE -- Margin Of Error; Male: - Under 5 Years,
"estimate_male_5_to_9_years" DOUBLE -- Estimate; Male: - 5 To 9 Years,
"margin_of_error_male_5_to_9_years" DOUBLE -- Margin Of Error; Male: - 5 To 9 Years,
"estimate_male_10_to_14_years" DOUBLE -- Estimate; Male: - 10 To 14 Years,
"margin_of_error_male_10_to_14_years" DOUBLE -- Margin Of Error; Male: - 10 To 14 Years,
"estimate_male_15_to_17_years" DOUBLE -- Estimate; Male: - 15 To 17 Years,
"margin_of_error_male_15_to_17_years" DOUBLE -- Margin Of Error; Male: - 15 To 17 Years,
"estimate_male_18_and_19_years" DOUBLE -- Estimate; Male: - 18 And 19 Years,
"margin_of_error_male_18_and_19_years" DOUBLE -- Margin Of Error; Male: - 18 And 19 Years,
"estimate_male_20_years" DOUBLE -- Estimate; Male: - 20 Years,
"margin_of_error_male_20_years" DOUBLE -- Margin Of Error; Male: - 20 Years,
"estimate_male_21_years" DOUBLE -- Estimate; Male: - 21 Years,
"margin_of_error_male_21_years" DOUBLE -- Margin Of Error; Male: - 21 Years,
"estimate_male_22_to_24_years" DOUBLE -- Estimate; Male: - 22 To 24 Years,
"margin_of_error_male_22_to_24_years" DOUBLE -- Margin Of Error; Male: - 22 To 24 Years,
"estimate_male_25_to_29_years" DOUBLE -- Estimate; Male: - 25 To 29 Years,
"margin_of_error_male_25_to_29_years" DOUBLE -- Margin Of Error; Male: - 25 To 29 Years,
"estimate_male_30_to_34_years" DOUBLE -- Estimate; Male: - 30 To 34 Years,
"margin_of_error_male_30_to_34_years" DOUBLE -- Margin Of Error; Male: - 30 To 34 Years,
"estimate_male_35_to_39_years" DOUBLE -- Estimate; Male: - 35 To 39 Years,
"margin_of_error_male_35_to_39_years" DOUBLE -- Margin Of Error; Male: - 35 To 39 Years,
"estimate_male_40_to_44_years" DOUBLE -- Estimate; Male: - 40 To 44 Years,
"margin_of_error_male_40_to_44_years" DOUBLE -- Margin Of Error; Male: - 40 To 44 Years,
"estimate_male_45_to_49_years" DOUBLE -- Estimate; Male: - 45 To 49 Years,
"margin_of_error_male_45_to_49_years" DOUBLE -- Margin Of Error; Male: - 45 To 49 Years,
"estimate_male_50_to_54_years" DOUBLE -- Estimate; Male: - 50 To 54 Years,
"margin_of_error_male_50_to_54_years" DOUBLE -- Margin Of Error; Male: - 50 To 54 Years,
"estimate_male_55_to_59_years" DOUBLE -- Estimate; Male: - 55 To 59 Years,
"margin_of_error_male_55_to_59_years" DOUBLE -- Margin Of Error; Male: - 55 To 59 Years,
"estimate_male_60_and_61_years" DOUBLE -- Estimate; Male: - 60 And 61 Years,
"margin_of_error_male_60_and_61_years" DOUBLE -- Margin Of Error; Male: - 60 And 61 Years,
"estimate_male_62_to_64_years" DOUBLE -- Estimate; Male: - 62 To 64 Years,
"margin_of_error_male_62_to_64_years" DOUBLE -- Margin Of Error; Male: - 62 To 64 Years,
"estimate_male_65_and_66_years" DOUBLE -- Estimate; Male: - 65 And 66 Years,
"margin_of_error_male_65_and_66_years" DOUBLE -- Margin Of Error; Male: - 65 And 66 Years,
"estimate_male_67_to_69_years" DOUBLE -- Estimate; Male: - 67 To 69 Years,
"margin_of_error_male_67_to_69_years" DOUBLE -- Margin Of Error; Male: - 67 To 69 Years,
"estimate_male_70_to_74_years" DOUBLE -- Estimate; Male: - 70 To 74 Years,
"margin_of_error_male_70_to_74_years" DOUBLE -- Margin Of Error; Male: - 70 To 74 Years,
"estimate_male_75_to_79_years" DOUBLE -- Estimate; Male: - 75 To 79 Years,
"margin_of_error_male_75_to_79_years" DOUBLE -- Margin Of Error; Male: - 75 To 79 Years,
"estimate_male_80_to_84_years" DOUBLE -- Estimate; Male: - 80 To 84 Years,
"margin_of_error_male_80_to_84_years" DOUBLE -- Margin Of Error; Male: - 80 To 84 Years,
"estimate_male_85_years_and_over" DOUBLE -- Estimate; Male: - 85 Years And Over,
"margin_of_error_male_85_years_and_over" DOUBLE -- Margin Of Error; Male: - 85 Years And Over,
"estimate_female" DOUBLE -- Estimate; Female:,
"margin_of_error_female" DOUBLE -- Margin Of Error; Female:,
"estimate_female_under_5_years" DOUBLE -- Estimate; Female: - Under 5 Years,
"margin_of_error_female_under_5_years" DOUBLE -- Margin Of Error; Female: - Under 5 Years,
"estimate_female_5_to_9_years" DOUBLE -- Estimate; Female: - 5 To 9 Years,
"margin_of_error_female_5_to_9_years" DOUBLE -- Margin Of Error; Female: - 5 To 9 Years,
"estimate_female_10_to_14_years" DOUBLE -- Estimate; Female: - 10 To 14 Years,
"margin_of_error_female_10_to_14_years" DOUBLE -- Margin Of Error; Female: - 10 To 14 Years,
"estimate_female_15_to_17_years" DOUBLE -- Estimate; Female: - 15 To 17 Years,
"margin_of_error_female_15_to_17_years" DOUBLE -- Margin Of Error; Female: - 15 To 17 Years,
"estimate_female_18_and_19_years" DOUBLE -- Estimate; Female: - 18 And 19 Years,
"margin_of_error_female_18_and_19_years" DOUBLE -- Margin Of Error; Female: - 18 And 19 Years,
"estimate_female_20_years" DOUBLE -- Estimate; Female: - 20 Years,
"margin_of_error_female_20_years" DOUBLE -- Margin Of Error; Female: - 20 Years,
"estimate_female_21_years" DOUBLE -- Estimate; Female: - 21 Years,
"margin_of_error_female_21_years" DOUBLE -- Margin Of Error; Female: - 21 Years,
"estimate_female_22_to_24_years" DOUBLE -- Estimate; Female: - 22 To 24 Years,
"margin_of_error_female_22_to_24_years" DOUBLE -- Margin Of Error; Female: - 22 To 24 Years,
"estimate_female_25_to_29_years" DOUBLE -- Estimate; Female: - 25 To 29 Years,
"margin_of_error_female_25_to_29_years" DOUBLE -- Margin Of Error; Female: - 25 To 29 Years,
"estimate_female_30_to_34_years" DOUBLE -- Estimate; Female: - 30 To 34 Years,
"margin_of_error_female_30_to_34_years" DOUBLE -- Margin Of Error; Female: - 30 To 34 Years,
"estimate_female_35_to_39_years" DOUBLE -- Estimate; Female: - 35 To 39 Years,
"margin_of_error_female_35_to_39_years" DOUBLE -- Margin Of Error; Female: - 35 To 39 Years,
"estimate_female_40_to_44_years" DOUBLE -- Estimate; Female: - 40 To 44 Years,
"margin_of_error_female_40_to_44_years" DOUBLE -- Margin Of Error; Female: - 40 To 44 Years,
"estimate_female_45_to_49_years" DOUBLE -- Estimate; Female: - 45 To 49 Years,
"margin_of_error_female_45_to_49_years" DOUBLE -- Margin Of Error; Female: - 45 To 49 Years,
"estimate_female_50_to_54_years" DOUBLE -- Estimate; Female: - 50 To 54 Years,
"margin_of_error_female_50_to_54_years" DOUBLE -- Margin Of Error; Female: - 50 To 54 Years,
"estimate_female_55_to_59_years" DOUBLE -- Estimate; Female: - 55 To 59 Years,
"margin_of_error_female_55_to_59_years" DOUBLE -- Margin Of Error; Female: - 55 To 59 Years,
"estimate_female_60_and_61_years" DOUBLE -- Estimate; Female: - 60 And 61 Years,
"margin_of_error_female_60_and_61_years" DOUBLE -- Margin Of Error; Female: - 60 And 61 Years,
"estimate_female_62_to_64_years" DOUBLE -- Estimate; Female: - 62 To 64 Years,
"margin_of_error_female_62_to_64_years" DOUBLE -- Margin Of Error; Female: - 62 To 64 Years,
"estimate_female_65_and_66_years" DOUBLE -- Estimate; Female: - 65 And 66 Years,
"margin_of_error_female_65_and_66_years" DOUBLE -- Margin Of Error; Female: - 65 And 66 Years,
"estimate_female_67_to_69_years" DOUBLE -- Estimate; Female: - 67 To 69 Years,
"margin_of_error_female_67_to_69_years" DOUBLE -- Margin Of Error; Female: - 67 To 69 Years,
"estimate_female_70_to_74_years" DOUBLE -- Estimate; Female: - 70 To 74 Years,
"margin_of_error_female_70_to_74_years" DOUBLE -- Margin Of Error; Female: - 70 To 74 Years,
"estimate_female_75_to_79_years" DOUBLE -- Estimate; Female: - 75 To 79 Years,
"margin_of_error_female_75_to_79_years" DOUBLE -- Margin Of Error; Female: - 75 To 79 Years,
"estimate_female_80_to_84_years" DOUBLE -- Estimate; Female: - 80 To 84 Years,
"margin_of_error_female_80_to_84_years" DOUBLE -- Margin Of Error; Female: - 80 To 84 Years,
"estimate_female_85_years_and_over" DOUBLE -- Estimate; Female: - 85 Years And Over,
"margin_of_error_female_85_years_and_over" DOUBLE -- Margin Of Error; Female: - 85 Years And Over
);CREATE TABLE sex_by_industry_for_the_civilian_employed_population_1_43b65bd2 (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_male" DOUBLE -- Estimate; Male:,
"margin_of_error_male" DOUBLE -- Margin Of Error; Male:,
"estimate_male_agriculture_forestry_fishing_and_hunting_45943dc7" DOUBLE -- Estimate; Male: - Agriculture, Forestry, Fishing And Hunting, And Mining:,
"margin_of_error_male_agriculture_forestry_fishing_and__d6ef9a22" DOUBLE -- Margin Of Error; Male: - Agriculture, Forestry, Fishing And Hunting, And Mining:,
"estimate_male_agriculture_forestry_fishing_and_hunting_efedd900" DOUBLE -- Estimate; Male: - Agriculture, Forestry, Fishing And Hunting, And Mining: - Agriculture, Forestry, Fishing And Hunting,
"margin_of_error_male_agriculture_forestry_fishing_and__f4071769" DOUBLE -- Margin Of Error; Male: - Agriculture, Forestry, Fishing And Hunting, And Mining: - Agriculture, Forestry, Fishing And Hunting,
"estimate_male_agriculture_forestry_fishing_and_hunting_140c935e" DOUBLE -- Estimate; Male: - Agriculture, Forestry, Fishing And Hunting, And Mining: - Mining, Quarrying, And Oil And Gas Extraction,
"margin_of_error_male_agriculture_forestry_fishing_and__e1a7187d" DOUBLE -- Margin Of Error; Male: - Agriculture, Forestry, Fishing And Hunting, And Mining: - Mining, Quarrying, And Oil And Gas Extraction,
"estimate_male_construction" DOUBLE -- Estimate; Male: - Construction,
"margin_of_error_male_construction" DOUBLE -- Margin Of Error; Male: - Construction,
"estimate_male_manufacturing" DOUBLE -- Estimate; Male: - Manufacturing,
"margin_of_error_male_manufacturing" DOUBLE -- Margin Of Error; Male: - Manufacturing,
"estimate_male_wholesale_trade" DOUBLE -- Estimate; Male: - Wholesale Trade,
"margin_of_error_male_wholesale_trade" DOUBLE -- Margin Of Error; Male: - Wholesale Trade,
"estimate_male_retail_trade" DOUBLE -- Estimate; Male: - Retail Trade,
"margin_of_error_male_retail_trade" DOUBLE -- Margin Of Error; Male: - Retail Trade,
"estimate_male_transportation_and_warehousing_and_utilities" DOUBLE -- Estimate; Male: - Transportation And Warehousing, And Utilities:,
"margin_of_error_male_transportation_and_warehousing_an_bb9989c5" DOUBLE -- Margin Of Error; Male: - Transportation And Warehousing, And Utilities:,
"estimate_male_transportation_and_warehousing_and_utili_1e60bcdb" DOUBLE -- Estimate; Male: - Transportation And Warehousing, And Utilities: - Transportation And Warehousing,
"margin_of_error_male_transportation_and_warehousing_an_f7435812" DOUBLE -- Margin Of Error; Male: - Transportation And Warehousing, And Utilities: - Transportation And Warehousing,
"estimate_male_transportation_and_warehousing_and_utili_6c3f2b44" DOUBLE -- Estimate; Male: - Transportation And Warehousing, And Utilities: - Utilities,
"margin_of_error_male_transportation_and_warehousing_an_08e44832" DOUBLE -- Margin Of Error; Male: - Transportation And Warehousing, And Utilities: - Utilities,
"estimate_male_information" DOUBLE -- Estimate; Male: - Information,
"margin_of_error_male_information" DOUBLE -- Margin Of Error; Male: - Information,
"estimate_male_finance_and_insurance_and_real_estate_an_d30fd809" DOUBLE -- Estimate; Male: - Finance And Insurance, And Real Estate And Rental And Leasing:,
"margin_of_error_male_finance_and_insurance_and_real_es_02cfc2f7" DOUBLE -- Margin Of Error; Male: - Finance And Insurance, And Real Estate And Rental And Leasing:,
"estimate_male_finance_and_insurance_and_real_estate_an_c370d5f3" DOUBLE -- Estimate; Male: - Finance And Insurance, And Real Estate And Rental And Leasing: - Finance And Insurance,
"margin_of_error_male_finance_and_insurance_and_real_es_465cf7c8" DOUBLE -- Margin Of Error; Male: - Finance And Insurance, And Real Estate And Rental And Leasing: - Finance And Insurance,
"estimate_male_finance_and_insurance_and_real_estate_an_47fb9ed3" DOUBLE -- Estimate; Male: - Finance And Insurance, And Real Estate And Rental And Leasing: - Real Estate And Rental And Leasing,
"margin_of_error_male_finance_and_insurance_and_real_es_56ea11cf" DOUBLE -- Margin Of Error; Male: - Finance And Insurance, And Real Estate And Rental And Leasing: - Real Estate And Rental And Leasing,
"estimate_male_professional_scientific_and_management_a_15856422" DOUBLE -- Estimate; Male: - Professional, Scientific, And Management, And Administrative And Waste Management Services:,
"margin_of_error_male_professional_scientific_and_manag_3a7b15ed" DOUBLE -- Margin Of Error; Male: - Professional, Scientific, And Management, And Administrative And Waste Management Services:,
"estimate_male_professional_scientific_and_management_a_23be41c6" DOUBLE -- Estimate; Male: - Professional, Scientific, And Management, And Administrative And Waste Management Services: - Professional, Scientific, And Technical Services,
"margin_of_error_male_professional_scientific_and_manag_c80348ca" DOUBLE -- Margin Of Error; Male: - Professional, Scientific, And Management, And Administrative And Waste Management Services: - Professional, Scientific, And Technical Services,
"estimate_male_professional_scientific_and_management_a_6f1866f0" DOUBLE -- Estimate; Male: - Professional, Scientific, And Management, And Administrative And Waste Management Services: - Management Of Companies And Enterprises,
"margin_of_error_male_professional_scientific_and_manag_0b74fb70" DOUBLE -- Margin Of Error; Male: - Professional, Scientific, And Management, And Administrative And Waste Management Services: - Management Of Companies And Enterprises,
"estimate_male_professional_scientific_and_management_a_6113ce6d" DOUBLE -- Estimate; Male: - Professional, Scientific, And Management, And Administrative And Waste Management Services: - Administrative And Support And Waste Management Services,
"margin_of_error_male_professional_scientific_and_manag_8a248d49" DOUBLE -- Margin Of Error; Male: - Professional, Scientific, And Management, And Administrative And Waste Management Services: - Administrative And Support And Waste Management Services,
"estimate_male_educational_services_and_health_care_and_584f95e5" DOUBLE -- Estimate; Male: - Educational Services, And Health Care And Social Assistance:,
"margin_of_error_male_educational_services_and_health_c_3d7ed2e1" DOUBLE -- Margin Of Error; Male: - Educational Services, And Health Care And Social Assistance:,
"estimate_male_educational_services_and_health_care_and_c166f0e7" DOUBLE -- Estimate; Male: - Educational Services, And Health Care And Social Assistance: - Educational Services,
"margin_of_error_male_educational_services_and_health_c_99c4020d" DOUBLE -- Margin Of Error; Male: - Educational Services, And Health Care And Social Assistance: - Educational Services,
"estimate_male_educational_services_and_health_care_and_3c7a0b5e" DOUBLE -- Estimate; Male: - Educational Services, And Health Care And Social Assistance: - Health Care And Social Assistance,
"margin_of_error_male_educational_services_and_health_c_6691ac48" DOUBLE -- Margin Of Error; Male: - Educational Services, And Health Care And Social Assistance: - Health Care And Social Assistance,
"estimate_male_arts_entertainment_and_recreation_and_ac_0dcda132" DOUBLE -- Estimate; Male: - Arts, Entertainment, And Recreation, And Accommodation And Food Services:,
"margin_of_error_male_arts_entertainment_and_recreation_7536801e" DOUBLE -- Margin Of Error; Male: - Arts, Entertainment, And Recreation, And Accommodation And Food Services:,
"estimate_male_arts_entertainment_and_recreation_and_ac_4f3a85a7" DOUBLE -- Estimate; Male: - Arts, Entertainment, And Recreation, And Accommodation And Food Services: - Arts, Entertainment, And Recreation,
"margin_of_error_male_arts_entertainment_and_recreation_d99e6ad5" DOUBLE -- Margin Of Error; Male: - Arts, Entertainment, And Recreation, And Accommodation And Food Services: - Arts, Entertainment, And Recreation,
"estimate_male_arts_entertainment_and_recreation_and_ac_4838b9d6" DOUBLE -- Estimate; Male: - Arts, Entertainment, And Recreation, And Accommodation And Food Services: - Accommodation And Food Services,
"margin_of_error_male_arts_entertainment_and_recreation_ac26fe81" DOUBLE -- Margin Of Error; Male: - Arts, Entertainment, And Recreation, And Accommodation And Food Services: - Accommodation And Food Services,
"estimate_male_other_services_except_public_administration" DOUBLE -- Estimate; Male: - Other Services, Except Public Administration,
"margin_of_error_male_other_services_except_public_admi_537a12f3" DOUBLE -- Margin Of Error; Male: - Other Services, Except Public Administration,
"estimate_male_public_administration" DOUBLE -- Estimate; Male: - Public Administration,
"margin_of_error_male_public_administration" DOUBLE -- Margin Of Error; Male: - Public Administration,
"estimate_female" DOUBLE -- Estimate; Female:,
"margin_of_error_female" DOUBLE -- Margin Of Error; Female:,
"estimate_female_agriculture_forestry_fishing_and_hunti_29450b37" DOUBLE -- Estimate; Female: - Agriculture, Forestry, Fishing And Hunting, And Mining:,
"margin_of_error_female_agriculture_forestry_fishing_an_706d3a7d" DOUBLE -- Margin Of Error; Female: - Agriculture, Forestry, Fishing And Hunting, And Mining:,
"estimate_female_agriculture_forestry_fishing_and_hunti_3c3ca8f3" DOUBLE -- Estimate; Female: - Agriculture, Forestry, Fishing And Hunting, And Mining: - Agriculture, Forestry, Fishing And Hunting,
"margin_of_error_female_agriculture_forestry_fishing_an_3e96a338" DOUBLE -- Margin Of Error; Female: - Agriculture, Forestry, Fishing And Hunting, And Mining: - Agriculture, Forestry, Fishing And Hunting,
"estimate_female_agriculture_forestry_fishing_and_hunti_5b127b3f" DOUBLE -- Estimate; Female: - Agriculture, Forestry, Fishing And Hunting, And Mining: - Mining, Quarrying, And Oil And Gas Extraction,
"margin_of_error_female_agriculture_forestry_fishing_an_96199c7a" DOUBLE -- Margin Of Error; Female: - Agriculture, Forestry, Fishing And Hunting, And Mining: - Mining, Quarrying, And Oil And Gas Extraction,
"estimate_female_construction" DOUBLE -- Estimate; Female: - Construction,
"margin_of_error_female_construction" DOUBLE -- Margin Of Error; Female: - Construction,
"estimate_female_manufacturing" DOUBLE -- Estimate; Female: - Manufacturing,
"margin_of_error_female_manufacturing" DOUBLE -- Margin Of Error; Female: - Manufacturing,
"estimate_female_wholesale_trade" DOUBLE -- Estimate; Female: - Wholesale Trade,
"margin_of_error_female_wholesale_trade" DOUBLE -- Margin Of Error; Female: - Wholesale Trade,
"estimate_female_retail_trade" DOUBLE -- Estimate; Female: - Retail Trade,
"margin_of_error_female_retail_trade" DOUBLE -- Margin Of Error; Female: - Retail Trade,
"estimate_female_transportation_and_warehousing_and_utilities" DOUBLE -- Estimate; Female: - Transportation And Warehousing, And Utilities:,
"margin_of_error_female_transportation_and_warehousing__5bf555c9" DOUBLE -- Margin Of Error; Female: - Transportation And Warehousing, And Utilities:,
"estimate_female_transportation_and_warehousing_and_uti_3a3436ec" DOUBLE -- Estimate; Female: - Transportation And Warehousing, And Utilities: - Transportation And Warehousing,
"margin_of_error_female_transportation_and_warehousing__5f2b267c" DOUBLE -- Margin Of Error; Female: - Transportation And Warehousing, And Utilities: - Transportation And Warehousing,
"estimate_female_transportation_and_warehousing_and_uti_1986a12d" DOUBLE -- Estimate; Female: - Transportation And Warehousing, And Utilities: - Utilities,
"margin_of_error_female_transportation_and_warehousing__88b264d1" DOUBLE -- Margin Of Error; Female: - Transportation And Warehousing, And Utilities: - Utilities,
"estimate_female_information" DOUBLE -- Estimate; Female: - Information,
"margin_of_error_female_information" DOUBLE -- Margin Of Error; Female: - Information,
"estimate_female_finance_and_insurance_and_real_estate__1287908b" DOUBLE -- Estimate; Female: - Finance And Insurance, And Real Estate And Rental And Leasing:,
"margin_of_error_female_finance_and_insurance_and_real__be908395" DOUBLE -- Margin Of Error; Female: - Finance And Insurance, And Real Estate And Rental And Leasing:,
"estimate_female_finance_and_insurance_and_real_estate__807404e0" DOUBLE -- Estimate; Female: - Finance And Insurance, And Real Estate And Rental And Leasing: - Finance And Insurance,
"margin_of_error_female_finance_and_insurance_and_real__e1c101d6" DOUBLE -- Margin Of Error; Female: - Finance And Insurance, And Real Estate And Rental And Leasing: - Finance And Insurance,
"estimate_female_finance_and_insurance_and_real_estate__edd33d1c" DOUBLE -- Estimate; Female: - Finance And Insurance, And Real Estate And Rental And Leasing: - Real Estate And Rental And Leasing,
"margin_of_error_female_finance_and_insurance_and_real__b14d2a1e" DOUBLE -- Margin Of Error; Female: - Finance And Insurance, And Real Estate And Rental And Leasing: - Real Estate And Rental And Leasing,
"estimate_female_professional_scientific_and_management_b8fa2251" DOUBLE -- Estimate; Female: - Professional, Scientific, And Management, And Administrative And Waste Management Services:,
"margin_of_error_female_professional_scientific_and_man_f8f77819" DOUBLE -- Margin Of Error; Female: - Professional, Scientific, And Management, And Administrative And Waste Management Services:,
"estimate_female_professional_scientific_and_management_6c4a84a7" DOUBLE -- Estimate; Female: - Professional, Scientific, And Management, And Administrative And Waste Management Services: - Professional, Scientific, And Technical Services,
"margin_of_error_female_professional_scientific_and_man_5216d2f9" DOUBLE -- Margin Of Error; Female: - Professional, Scientific, And Management, And Administrative And Waste Management Services: - Professional, Scientific, And Technical Services,
"estimate_female_professional_scientific_and_management_c51e32e0" DOUBLE -- Estimate; Female: - Professional, Scientific, And Management, And Administrative And Waste Management Services: - Management Of Companies And Enterprises,
"margin_of_error_female_professional_scientific_and_man_5ceb68da" DOUBLE -- Margin Of Error; Female: - Professional, Scientific, And Management, And Administrative And Waste Management Services: - Management Of Companies And Enterprises,
"estimate_female_professional_scientific_and_management_dbdf5ded" DOUBLE -- Estimate; Female: - Professional, Scientific, And Management, And Administrative And Waste Management Services: - Administrative And Support And Waste Management Services,
"margin_of_error_female_professional_scientific_and_man_9d6946da" DOUBLE -- Margin Of Error; Female: - Professional, Scientific, And Management, And Administrative And Waste Management Services: - Administrative And Support And Waste Management Services,
"estimate_female_educational_services_and_health_care_a_294de1e9" DOUBLE -- Estimate; Female: - Educational Services, And Health Care And Social Assistance:,
"margin_of_error_female_educational_services_and_health_81485a1b" DOUBLE -- Margin Of Error; Female: - Educational Services, And Health Care And Social Assistance:,
"estimate_female_educational_services_and_health_care_a_b4a64a19" DOUBLE -- Estimate; Female: - Educational Services, And Health Care And Social Assistance: - Educational Services,
"margin_of_error_female_educational_services_and_health_7896d957" DOUBLE -- Margin Of Error; Female: - Educational Services, And Health Care And Social Assistance: - Educational Services
);CREATE TABLE sex_by_school_enrollment_by_educational_attainment_by__b42bcc98 (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_male" DOUBLE -- Estimate; Male:,
"margin_of_error_male" DOUBLE -- Margin Of Error; Male:,
"estimate_male_enrolled_in_school" DOUBLE -- Estimate; Male: - Enrolled In School:,
"margin_of_error_male_enrolled_in_school" DOUBLE -- Margin Of Error; Male: - Enrolled In School:,
"estimate_male_enrolled_in_school_employed" DOUBLE -- Estimate; Male: - Enrolled In School: - Employed,
"margin_of_error_male_enrolled_in_school_employed" DOUBLE -- Margin Of Error; Male: - Enrolled In School: - Employed,
"estimate_male_enrolled_in_school_unemployed" DOUBLE -- Estimate; Male: - Enrolled In School: - Unemployed,
"margin_of_error_male_enrolled_in_school_unemployed" DOUBLE -- Margin Of Error; Male: - Enrolled In School: - Unemployed,
"estimate_male_enrolled_in_school_not_in_labor_force" DOUBLE -- Estimate; Male: - Enrolled In School: - Not In Labor Force,
"margin_of_error_male_enrolled_in_school_not_in_labor_force" DOUBLE -- Margin Of Error; Male: - Enrolled In School: - Not In Labor Force,
"estimate_male_not_enrolled_in_school" DOUBLE -- Estimate; Male: - Not Enrolled In School:,
"margin_of_error_male_not_enrolled_in_school" DOUBLE -- Margin Of Error; Male: - Not Enrolled In School:,
"estimate_male_not_enrolled_in_school_high_school_gradu_8be44ca2" DOUBLE -- Estimate; Male: - Not Enrolled In School: - High School Graduate (includes Equivalency):,
"margin_of_error_male_not_enrolled_in_school_high_schoo_be80b2cf" DOUBLE -- Margin Of Error; Male: - Not Enrolled In School: - High School Graduate (includes Equivalency):,
"estimate_male_not_enrolled_in_school_high_school_gradu_c918f163" DOUBLE -- Estimate; Male: - Not Enrolled In School: - High School Graduate (includes Equivalency): - Employed,
"margin_of_error_male_not_enrolled_in_school_high_schoo_e12265e1" DOUBLE -- Margin Of Error; Male: - Not Enrolled In School: - High School Graduate (includes Equivalency): - Employed,
"estimate_male_not_enrolled_in_school_high_school_gradu_87e0b224" DOUBLE -- Estimate; Male: - Not Enrolled In School: - High School Graduate (includes Equivalency): - Unemployed,
"margin_of_error_male_not_enrolled_in_school_high_schoo_fa439202" DOUBLE -- Margin Of Error; Male: - Not Enrolled In School: - High School Graduate (includes Equivalency): - Unemployed,
"estimate_male_not_enrolled_in_school_high_school_gradu_6259fd9f" DOUBLE -- Estimate; Male: - Not Enrolled In School: - High School Graduate (includes Equivalency): - Not In Labor Force,
"margin_of_error_male_not_enrolled_in_school_high_schoo_93686206" DOUBLE -- Margin Of Error; Male: - Not Enrolled In School: - High School Graduate (includes Equivalency): - Not In Labor Force,
"estimate_male_not_enrolled_in_school_not_high_school_graduate" DOUBLE -- Estimate; Male: - Not Enrolled In School: - Not High School Graduate:,
"margin_of_error_male_not_enrolled_in_school_not_high_s_9916e6be" DOUBLE -- Margin Of Error; Male: - Not Enrolled In School: - Not High School Graduate:,
"estimate_male_not_enrolled_in_school_not_high_school_g_63af6678" DOUBLE -- Estimate; Male: - Not Enrolled In School: - Not High School Graduate: - Employed,
"margin_of_error_male_not_enrolled_in_school_not_high_s_2f85cf73" DOUBLE -- Margin Of Error; Male: - Not Enrolled In School: - Not High School Graduate: - Employed,
"estimate_male_not_enrolled_in_school_not_high_school_g_889faf1d" DOUBLE -- Estimate; Male: - Not Enrolled In School: - Not High School Graduate: - Unemployed,
"margin_of_error_male_not_enrolled_in_school_not_high_s_9a1db013" DOUBLE -- Margin Of Error; Male: - Not Enrolled In School: - Not High School Graduate: - Unemployed,
"estimate_male_not_enrolled_in_school_not_high_school_g_70e0f9ce" DOUBLE -- Estimate; Male: - Not Enrolled In School: - Not High School Graduate: - Not In Labor Force,
"margin_of_error_male_not_enrolled_in_school_not_high_s_01add1a2" DOUBLE -- Margin Of Error; Male: - Not Enrolled In School: - Not High School Graduate: - Not In Labor Force,
"estimate_female" DOUBLE -- Estimate; Female:,
"margin_of_error_female" DOUBLE -- Margin Of Error; Female:,
"estimate_female_enrolled_in_school" DOUBLE -- Estimate; Female: - Enrolled In School:,
"margin_of_error_female_enrolled_in_school" DOUBLE -- Margin Of Error; Female: - Enrolled In School:,
"estimate_female_enrolled_in_school_employed" DOUBLE -- Estimate; Female: - Enrolled In School: - Employed,
"margin_of_error_female_enrolled_in_school_employed" DOUBLE -- Margin Of Error; Female: - Enrolled In School: - Employed,
"estimate_female_enrolled_in_school_unemployed" DOUBLE -- Estimate; Female: - Enrolled In School: - Unemployed,
"margin_of_error_female_enrolled_in_school_unemployed" DOUBLE -- Margin Of Error; Female: - Enrolled In School: - Unemployed,
"estimate_female_enrolled_in_school_not_in_labor_force" DOUBLE -- Estimate; Female: - Enrolled In School: - Not In Labor Force,
"margin_of_error_female_enrolled_in_school_not_in_labor_force" DOUBLE -- Margin Of Error; Female: - Enrolled In School: - Not In Labor Force,
"estimate_female_not_enrolled_in_school" DOUBLE -- Estimate; Female: - Not Enrolled In School:,
"margin_of_error_female_not_enrolled_in_school" DOUBLE -- Margin Of Error; Female: - Not Enrolled In School:,
"estimate_female_not_enrolled_in_school_high_school_gra_ad151550" DOUBLE -- Estimate; Female: - Not Enrolled In School: - High School Graduate (includes Equivalency):,
"margin_of_error_female_not_enrolled_in_school_high_sch_3858630e" DOUBLE -- Margin Of Error; Female: - Not Enrolled In School: - High School Graduate (includes Equivalency):,
"estimate_female_not_enrolled_in_school_high_school_gra_9f0649e6" DOUBLE -- Estimate; Female: - Not Enrolled In School: - High School Graduate (includes Equivalency): - Employed,
"margin_of_error_female_not_enrolled_in_school_high_sch_4e2d262b" DOUBLE -- Margin Of Error; Female: - Not Enrolled In School: - High School Graduate (includes Equivalency): - Employed,
"estimate_female_not_enrolled_in_school_high_school_gra_6f6d7b22" DOUBLE -- Estimate; Female: - Not Enrolled In School: - High School Graduate (includes Equivalency): - Unemployed,
"margin_of_error_female_not_enrolled_in_school_high_sch_377abc26" DOUBLE -- Margin Of Error; Female: - Not Enrolled In School: - High School Graduate (includes Equivalency): - Unemployed,
"estimate_female_not_enrolled_in_school_high_school_gra_ec185f9e" DOUBLE -- Estimate; Female: - Not Enrolled In School: - High School Graduate (includes Equivalency): - Not In Labor Force,
"margin_of_error_female_not_enrolled_in_school_high_sch_4f8b3843" DOUBLE -- Margin Of Error; Female: - Not Enrolled In School: - High School Graduate (includes Equivalency): - Not In Labor Force,
"estimate_female_not_enrolled_in_school_not_high_school_43f89f50" DOUBLE -- Estimate; Female: - Not Enrolled In School: - Not High School Graduate:,
"margin_of_error_female_not_enrolled_in_school_not_high_63a9fe87" DOUBLE -- Margin Of Error; Female: - Not Enrolled In School: - Not High School Graduate:,
"estimate_female_not_enrolled_in_school_not_high_school_b23f74c8" DOUBLE -- Estimate; Female: - Not Enrolled In School: - Not High School Graduate: - Employed,
"margin_of_error_female_not_enrolled_in_school_not_high_8af5398d" DOUBLE -- Margin Of Error; Female: - Not Enrolled In School: - Not High School Graduate: - Employed,
"estimate_female_not_enrolled_in_school_not_high_school_29e251fc" DOUBLE -- Estimate; Female: - Not Enrolled In School: - Not High School Graduate: - Unemployed,
"margin_of_error_female_not_enrolled_in_school_not_high_a3b03c11" DOUBLE -- Margin Of Error; Female: - Not Enrolled In School: - Not High School Graduate: - Unemployed,
"estimate_female_not_enrolled_in_school_not_high_school_6e157411" DOUBLE -- Estimate; Female: - Not Enrolled In School: - Not High School Graduate: - Not In Labor Force,
"margin_of_error_female_not_enrolled_in_school_not_high_6f482ceb" DOUBLE -- Margin Of Error; Female: - Not Enrolled In School: - Not High School Graduate: - Not In Labor Force
);CREATE TABLE social_security_income_in_the_past_12_months_for_households (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_total_with_social_security_income" DOUBLE -- Estimate; Total: - With Social Security Income,
"margin_of_error_total_with_social_security_income" DOUBLE -- Margin Of Error; Total: - With Social Security Income,
"estimate_total_no_social_security_income" DOUBLE -- Estimate; Total: - No Social Security Income,
"margin_of_error_total_no_social_security_income" DOUBLE -- Margin Of Error; Total: - No Social Security Income
);CREATE TABLE supplemental_security_income_ssi_in_the_past_12_months_6ec1b57a (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_total_with_supplemental_security_income_ssi" DOUBLE -- Estimate; Total: - With Supplemental Security Income (SSI),
"margin_of_error_total_with_supplemental_security_income_ssi" DOUBLE -- Margin Of Error; Total: - With Supplemental Security Income (SSI),
"estimate_total_no_supplemental_security_income_ssi" DOUBLE -- Estimate; Total: - No Supplemental Security Income (SSI),
"margin_of_error_total_no_supplemental_security_income_ssi" DOUBLE -- Margin Of Error; Total: - No Supplemental Security Income (SSI)
);CREATE TABLE total_population (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total
);CREATE TABLE types_of_health_insurance_coverage_by_age (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_under_18_years" DOUBLE -- Estimate; Under 18 Years:,
"margin_of_error_under_18_years" DOUBLE -- Margin Of Error; Under 18 Years:,
"estimate_under_18_years_with_one_type_of_health_insura_62682e67" DOUBLE -- Estimate; Under 18 Years: - With One Type Of Health Insurance Coverage:,
"margin_of_error_under_18_years_with_one_type_of_health_31df0c1d" DOUBLE -- Margin Of Error; Under 18 Years: - With One Type Of Health Insurance Coverage:,
"estimate_under_18_years_with_one_type_of_health_insura_d65f142d" DOUBLE -- Estimate; Under 18 Years: - With One Type Of Health Insurance Coverage: - With Employer-based Health Insurance Only,
"margin_of_error_under_18_years_with_one_type_of_health_e5b59e7c" DOUBLE -- Margin Of Error; Under 18 Years: - With One Type Of Health Insurance Coverage: - With Employer-based Health Insurance Only,
"estimate_under_18_years_with_one_type_of_health_insura_47a19434" DOUBLE -- Estimate; Under 18 Years: - With One Type Of Health Insurance Coverage: - With Direct-purchase Health Insurance Only,
"margin_of_error_under_18_years_with_one_type_of_health_5c9416ab" DOUBLE -- Margin Of Error; Under 18 Years: - With One Type Of Health Insurance Coverage: - With Direct-purchase Health Insurance Only,
"estimate_under_18_years_with_one_type_of_health_insura_1b162472" DOUBLE -- Estimate; Under 18 Years: - With One Type Of Health Insurance Coverage: - With Medicare Coverage Only,
"margin_of_error_under_18_years_with_one_type_of_health_dd4a8d20" DOUBLE -- Margin Of Error; Under 18 Years: - With One Type Of Health Insurance Coverage: - With Medicare Coverage Only,
"estimate_under_18_years_with_one_type_of_health_insura_a4bea9ce" DOUBLE -- Estimate; Under 18 Years: - With One Type Of Health Insurance Coverage: - With Medicaid/means-tested Public Coverage Only,
"margin_of_error_under_18_years_with_one_type_of_health_7fcc2624" DOUBLE -- Margin Of Error; Under 18 Years: - With One Type Of Health Insurance Coverage: - With Medicaid/means-tested Public Coverage Only,
"estimate_under_18_years_with_one_type_of_health_insura_0c38c496" DOUBLE -- Estimate; Under 18 Years: - With One Type Of Health Insurance Coverage: - With TRICARE/military Health Coverage Only,
"margin_of_error_under_18_years_with_one_type_of_health_71062d9d" DOUBLE -- Margin Of Error; Under 18 Years: - With One Type Of Health Insurance Coverage: - With TRICARE/military Health Coverage Only,
"estimate_under_18_years_with_one_type_of_health_insura_8c649003" DOUBLE -- Estimate; Under 18 Years: - With One Type Of Health Insurance Coverage: - With VA Health Care Only,
"margin_of_error_under_18_years_with_one_type_of_health_6fad35c7" DOUBLE -- Margin Of Error; Under 18 Years: - With One Type Of Health Insurance Coverage: - With VA Health Care Only,
"estimate_under_18_years_with_two_or_more_types_of_heal_5f18def1" DOUBLE -- Estimate; Under 18 Years: - With Two Or More Types Of Health Insurance Coverage:,
"margin_of_error_under_18_years_with_two_or_more_types__57d48694" DOUBLE -- Margin Of Error; Under 18 Years: - With Two Or More Types Of Health Insurance Coverage:,
"estimate_under_18_years_with_two_or_more_types_of_heal_5a5494f9" DOUBLE -- Estimate; Under 18 Years: - With Two Or More Types Of Health Insurance Coverage: - With Employer-based And Direct-purchase Coverage,
"margin_of_error_under_18_years_with_two_or_more_types__9e59b920" DOUBLE -- Margin Of Error; Under 18 Years: - With Two Or More Types Of Health Insurance Coverage: - With Employer-based And Direct-purchase Coverage,
"estimate_under_18_years_with_two_or_more_types_of_heal_b5794fb3" DOUBLE -- Estimate; Under 18 Years: - With Two Or More Types Of Health Insurance Coverage: - With Employer-based And Medicare Coverage,
"margin_of_error_under_18_years_with_two_or_more_types__2b10a9d9" DOUBLE -- Margin Of Error; Under 18 Years: - With Two Or More Types Of Health Insurance Coverage: - With Employer-based And Medicare Coverage,
"estimate_under_18_years_with_two_or_more_types_of_heal_305ef6f4" DOUBLE -- Estimate; Under 18 Years: - With Two Or More Types Of Health Insurance Coverage: - With Medicare And Medicaid/means-tested Public Coverage,
"margin_of_error_under_18_years_with_two_or_more_types__9c4defef" DOUBLE -- Margin Of Error; Under 18 Years: - With Two Or More Types Of Health Insurance Coverage: - With Medicare And Medicaid/means-tested Public Coverage,
"estimate_under_18_years_with_two_or_more_types_of_heal_7e253016" DOUBLE -- Estimate; Under 18 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Private Only Combinations,
"margin_of_error_under_18_years_with_two_or_more_types__e9060579" DOUBLE -- Margin Of Error; Under 18 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Private Only Combinations,
"estimate_under_18_years_with_two_or_more_types_of_heal_fbdde91d" DOUBLE -- Estimate; Under 18 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Public Only Combinations,
"margin_of_error_under_18_years_with_two_or_more_types__d2dcdcd0" DOUBLE -- Margin Of Error; Under 18 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Public Only Combinations,
"estimate_under_18_years_with_two_or_more_types_of_heal_b7f1882f" DOUBLE -- Estimate; Under 18 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Coverage Combinations,
"margin_of_error_under_18_years_with_two_or_more_types__8b8450b3" DOUBLE -- Margin Of Error; Under 18 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Coverage Combinations,
"estimate_under_18_years_no_health_insurance_coverage" DOUBLE -- Estimate; Under 18 Years: - No Health Insurance Coverage,
"margin_of_error_under_18_years_no_health_insurance_coverage" DOUBLE -- Margin Of Error; Under 18 Years: - No Health Insurance Coverage,
"estimate_18_to_34_years" DOUBLE -- Estimate; 18 To 34 Years:,
"margin_of_error_18_to_34_years" DOUBLE -- Margin Of Error; 18 To 34 Years:,
"estimate_18_to_34_years_with_one_type_of_health_insura_54f179c4" DOUBLE -- Estimate; 18 To 34 Years: - With One Type Of Health Insurance Coverage:,
"margin_of_error_18_to_34_years_with_one_type_of_health_ab46aa2c" DOUBLE -- Margin Of Error; 18 To 34 Years: - With One Type Of Health Insurance Coverage:,
"estimate_18_to_34_years_with_one_type_of_health_insura_f35e286f" DOUBLE -- Estimate; 18 To 34 Years: - With One Type Of Health Insurance Coverage: - With Employer-based Health Insurance Only,
"margin_of_error_18_to_34_years_with_one_type_of_health_e2f8a923" DOUBLE -- Margin Of Error; 18 To 34 Years: - With One Type Of Health Insurance Coverage: - With Employer-based Health Insurance Only,
"estimate_18_to_34_years_with_one_type_of_health_insura_08ceed7b" DOUBLE -- Estimate; 18 To 34 Years: - With One Type Of Health Insurance Coverage: - With Direct-purchase Health Insurance Only,
"margin_of_error_18_to_34_years_with_one_type_of_health_d539a7d6" DOUBLE -- Margin Of Error; 18 To 34 Years: - With One Type Of Health Insurance Coverage: - With Direct-purchase Health Insurance Only,
"estimate_18_to_34_years_with_one_type_of_health_insura_bf5b6f15" DOUBLE -- Estimate; 18 To 34 Years: - With One Type Of Health Insurance Coverage: - With Medicare Coverage Only,
"margin_of_error_18_to_34_years_with_one_type_of_health_92013a27" DOUBLE -- Margin Of Error; 18 To 34 Years: - With One Type Of Health Insurance Coverage: - With Medicare Coverage Only,
"estimate_18_to_34_years_with_one_type_of_health_insura_559d6c1f" DOUBLE -- Estimate; 18 To 34 Years: - With One Type Of Health Insurance Coverage: - With Medicaid/means-tested Public Coverage Only,
"margin_of_error_18_to_34_years_with_one_type_of_health_22c4f658" DOUBLE -- Margin Of Error; 18 To 34 Years: - With One Type Of Health Insurance Coverage: - With Medicaid/means-tested Public Coverage Only,
"estimate_18_to_34_years_with_one_type_of_health_insura_f596e56a" DOUBLE -- Estimate; 18 To 34 Years: - With One Type Of Health Insurance Coverage: - With TRICARE/military Health Coverage Only,
"margin_of_error_18_to_34_years_with_one_type_of_health_3fceeec8" DOUBLE -- Margin Of Error; 18 To 34 Years: - With One Type Of Health Insurance Coverage: - With TRICARE/military Health Coverage Only,
"estimate_18_to_34_years_with_one_type_of_health_insura_acad1313" DOUBLE -- Estimate; 18 To 34 Years: - With One Type Of Health Insurance Coverage: - With VA Health Care Only,
"margin_of_error_18_to_34_years_with_one_type_of_health_9cd57e82" DOUBLE -- Margin Of Error; 18 To 34 Years: - With One Type Of Health Insurance Coverage: - With VA Health Care Only,
"estimate_18_to_34_years_with_two_or_more_types_of_heal_4330fbb3" DOUBLE -- Estimate; 18 To 34 Years: - With Two Or More Types Of Health Insurance Coverage:,
"margin_of_error_18_to_34_years_with_two_or_more_types__86a817cf" DOUBLE -- Margin Of Error; 18 To 34 Years: - With Two Or More Types Of Health Insurance Coverage:,
"estimate_18_to_34_years_with_two_or_more_types_of_heal_5c5c6036" DOUBLE -- Estimate; 18 To 34 Years: - With Two Or More Types Of Health Insurance Coverage: - With Employer-based And Direct-purchase Coverage,
"margin_of_error_18_to_34_years_with_two_or_more_types__7ed60ed2" DOUBLE -- Margin Of Error; 18 To 34 Years: - With Two Or More Types Of Health Insurance Coverage: - With Employer-based And Direct-purchase Coverage,
"estimate_18_to_34_years_with_two_or_more_types_of_heal_d5a29452" DOUBLE -- Estimate; 18 To 34 Years: - With Two Or More Types Of Health Insurance Coverage: - With Employer-based And Medicare Coverage,
"margin_of_error_18_to_34_years_with_two_or_more_types__cd2a3459" DOUBLE -- Margin Of Error; 18 To 34 Years: - With Two Or More Types Of Health Insurance Coverage: - With Employer-based And Medicare Coverage,
"estimate_18_to_34_years_with_two_or_more_types_of_heal_e8dd4af9" DOUBLE -- Estimate; 18 To 34 Years: - With Two Or More Types Of Health Insurance Coverage: - With Medicare And Medicaid/means-tested Public Coverage,
"margin_of_error_18_to_34_years_with_two_or_more_types__0c838aae" DOUBLE -- Margin Of Error; 18 To 34 Years: - With Two Or More Types Of Health Insurance Coverage: - With Medicare And Medicaid/means-tested Public Coverage,
"estimate_18_to_34_years_with_two_or_more_types_of_heal_5948f993" DOUBLE -- Estimate; 18 To 34 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Private Only Combinations,
"margin_of_error_18_to_34_years_with_two_or_more_types__74dc8b16" DOUBLE -- Margin Of Error; 18 To 34 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Private Only Combinations,
"estimate_18_to_34_years_with_two_or_more_types_of_heal_a5aa99ef" DOUBLE -- Estimate; 18 To 34 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Public Only Combinations,
"margin_of_error_18_to_34_years_with_two_or_more_types__8fe567b1" DOUBLE -- Margin Of Error; 18 To 34 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Public Only Combinations,
"estimate_18_to_34_years_with_two_or_more_types_of_heal_01e02aeb" DOUBLE -- Estimate; 18 To 34 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Coverage Combinations,
"margin_of_error_18_to_34_years_with_two_or_more_types__b1275031" DOUBLE -- Margin Of Error; 18 To 34 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Coverage Combinations,
"estimate_18_to_34_years_no_health_insurance_coverage" DOUBLE -- Estimate; 18 To 34 Years: - No Health Insurance Coverage,
"margin_of_error_18_to_34_years_no_health_insurance_coverage" DOUBLE -- Margin Of Error; 18 To 34 Years: - No Health Insurance Coverage,
"estimate_35_to_64_years" DOUBLE -- Estimate; 35 To 64 Years:,
"margin_of_error_35_to_64_years" DOUBLE -- Margin Of Error; 35 To 64 Years:,
"estimate_35_to_64_years_with_one_type_of_health_insura_0a611804" DOUBLE -- Estimate; 35 To 64 Years: - With One Type Of Health Insurance Coverage:,
"margin_of_error_35_to_64_years_with_one_type_of_health_c179e7ee" DOUBLE -- Margin Of Error; 35 To 64 Years: - With One Type Of Health Insurance Coverage:,
"estimate_35_to_64_years_with_one_type_of_health_insura_aa0253a3" DOUBLE -- Estimate; 35 To 64 Years: - With One Type Of Health Insurance Coverage: - With Employer-based Health Insurance Only,
"margin_of_error_35_to_64_years_with_one_type_of_health_31716d82" DOUBLE -- Margin Of Error; 35 To 64 Years: - With One Type Of Health Insurance Coverage: - With Employer-based Health Insurance Only,
"estimate_35_to_64_years_with_one_type_of_health_insura_7b161379" DOUBLE -- Estimate; 35 To 64 Years: - With One Type Of Health Insurance Coverage: - With Direct-purchase Health Insurance Only,
"margin_of_error_35_to_64_years_with_one_type_of_health_5daffe58" DOUBLE -- Margin Of Error; 35 To 64 Years: - With One Type Of Health Insurance Coverage: - With Direct-purchase Health Insurance Only,
"estimate_35_to_64_years_with_one_type_of_health_insura_79dd987e" DOUBLE -- Estimate; 35 To 64 Years: - With One Type Of Health Insurance Coverage: - With Medicare Coverage Only,
"margin_of_error_35_to_64_years_with_one_type_of_health_97f20a6c" DOUBLE -- Margin Of Error; 35 To 64 Years: - With One Type Of Health Insurance Coverage: - With Medicare Coverage Only,
"estimate_35_to_64_years_with_one_type_of_health_insura_7ad4b109" DOUBLE -- Estimate; 35 To 64 Years: - With One Type Of Health Insurance Coverage: - With Medicaid/means-tested Public Coverage Only,
"margin_of_error_35_to_64_years_with_one_type_of_health_911ef165" DOUBLE -- Margin Of Error; 35 To 64 Years: - With One Type Of Health Insurance Coverage: - With Medicaid/means-tested Public Coverage Only,
"estimate_35_to_64_years_with_one_type_of_health_insura_7dae935a" DOUBLE -- Estimate; 35 To 64 Years: - With One Type Of Health Insurance Coverage: - With TRICARE/military Health Coverage Only,
"margin_of_error_35_to_64_years_with_one_type_of_health_46656649" DOUBLE -- Margin Of Error; 35 To 64 Years: - With One Type Of Health Insurance Coverage: - With TRICARE/military Health Coverage Only,
"estimate_35_to_64_years_with_one_type_of_health_insura_eaad7a8e" DOUBLE -- Estimate; 35 To 64 Years: - With One Type Of Health Insurance Coverage: - With VA Health Care Only,
"margin_of_error_35_to_64_years_with_one_type_of_health_fd0629a8" DOUBLE -- Margin Of Error; 35 To 64 Years: - With One Type Of Health Insurance Coverage: - With VA Health Care Only,
"estimate_35_to_64_years_with_two_or_more_types_of_heal_b1f19c5b" DOUBLE -- Estimate; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage:,
"margin_of_error_35_to_64_years_with_two_or_more_types__50b64095" DOUBLE -- Margin Of Error; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage:,
"estimate_35_to_64_years_with_two_or_more_types_of_heal_ff01e268" DOUBLE -- Estimate; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage: - With Employer-based And Direct-purchase Coverage,
"margin_of_error_35_to_64_years_with_two_or_more_types__3024603c" DOUBLE -- Margin Of Error; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage: - With Employer-based And Direct-purchase Coverage,
"estimate_35_to_64_years_with_two_or_more_types_of_heal_30703549" DOUBLE -- Estimate; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage: - With Employer-based And Medicare Coverage,
"margin_of_error_35_to_64_years_with_two_or_more_types__9a646079" DOUBLE -- Margin Of Error; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage: - With Employer-based And Medicare Coverage,
"estimate_35_to_64_years_with_two_or_more_types_of_heal_03e8bc41" DOUBLE -- Estimate; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage: - With Direct-purchase And Medicare Coverage,
"margin_of_error_35_to_64_years_with_two_or_more_types__85622630" DOUBLE -- Margin Of Error; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage: - With Direct-purchase And Medicare Coverage,
"estimate_35_to_64_years_with_two_or_more_types_of_heal_c1af1c86" DOUBLE -- Estimate; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage: - With Medicare And Medicaid/means-tested Public Coverage,
"margin_of_error_35_to_64_years_with_two_or_more_types__227f60c2" DOUBLE -- Margin Of Error; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage: - With Medicare And Medicaid/means-tested Public Coverage,
"estimate_35_to_64_years_with_two_or_more_types_of_heal_67cbc1fe" DOUBLE -- Estimate; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Private Only Combinations,
"margin_of_error_35_to_64_years_with_two_or_more_types__5e17e736" DOUBLE -- Margin Of Error; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Private Only Combinations,
"estimate_35_to_64_years_with_two_or_more_types_of_heal_2bbde812" DOUBLE -- Estimate; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Public Only Combinations,
"margin_of_error_35_to_64_years_with_two_or_more_types__53bb456b" DOUBLE -- Margin Of Error; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Public Only Combinations,
"estimate_35_to_64_years_with_two_or_more_types_of_heal_d08d17b0" DOUBLE -- Estimate; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Coverage Combinations,
"margin_of_error_35_to_64_years_with_two_or_more_types__f54e1a66" DOUBLE -- Margin Of Error; 35 To 64 Years: - With Two Or More Types Of Health Insurance Coverage: - Other Coverage Combinations
);CREATE TABLE wage_or_salary_income_in_the_past_12_months_for_households (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_total_with_wage_or_salary_income" DOUBLE -- Estimate; Total: - With Wage Or Salary Income,
"margin_of_error_total_with_wage_or_salary_income" DOUBLE -- Margin Of Error; Total: - With Wage Or Salary Income,
"estimate_total_no_wage_or_salary_income" DOUBLE -- Estimate; Total: - No Wage Or Salary Income,
"margin_of_error_total_no_wage_or_salary_income" DOUBLE -- Margin Of Error; Total: - No Wage Or Salary Income
);Anyone who has the link will be able to view this.