Pittsburgh American Community Survey 2014 - Miscellaneous Data
Allegheny County / City of Pittsburgh / Western PA Regional Data Center
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472
Allegheny County / City of Pittsburgh / Western PA Regional Data Center
@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472
Miscellaneous Reports from the 2014 American Community Survey Report
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:11:53.558695
Tags: acs, age, american-community-survey, census, community, demographics, education, employment, health-insurance, healthcare, housing, income, mortgage, population, public-assistance, race, rent, retirement, salary, survey, wage
CREATE TABLE aggregate_household_income_in_the_past_12_months (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_aggregate_household_income_in_the_past_12_mon_c1853f1d" VARCHAR -- Estimate; Aggregate Household Income In The Past 12 Months (in 2014 Inflation-adjusted Dollars),
"margin_of_error_aggregate_household_income_in_the_past_ad3e0f33" VARCHAR -- Margin Of Error; Aggregate Household Income In The Past 12 Months (in 2014 Inflation-adjusted Dollars)
);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_or_more" DOUBLE -- Estimate; With Cash Rent: - $2,000 Or More,
"margin_of_error_with_cash_rent_2_000_or_more" DOUBLE -- Margin Of Error; With Cash Rent: - $2,000 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 employment_status_for_the_population_16_years_and_over (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_in_labor_force" DOUBLE -- Estimate; In Labor Force:,
"margin_of_error_in_labor_force" DOUBLE -- Margin Of Error; In Labor Force:,
"estimate_in_labor_force_civilian_labor_force" DOUBLE -- Estimate; In Labor Force: - Civilian Labor Force:,
"margin_of_error_in_labor_force_civilian_labor_force" DOUBLE -- Margin Of Error; In Labor Force: - Civilian Labor Force:,
"estimate_in_labor_force_civilian_labor_force_employed" DOUBLE -- Estimate; In Labor Force: - Civilian Labor Force: - Employed,
"margin_of_error_in_labor_force_civilian_labor_force_employed" DOUBLE -- Margin Of Error; In Labor Force: - Civilian Labor Force: - Employed,
"estimate_in_labor_force_civilian_labor_force_unemployed" DOUBLE -- Estimate; In Labor Force: - Civilian Labor Force: - Unemployed,
"margin_of_error_in_labor_force_civilian_labor_force_unemployed" DOUBLE -- Margin Of Error; In Labor Force: - Civilian Labor Force: - Unemployed,
"estimate_in_labor_force_armed_forces" DOUBLE -- Estimate; In Labor Force: - Armed Forces,
"margin_of_error_in_labor_force_armed_forces" DOUBLE -- Margin Of Error; In Labor Force: - Armed Forces,
"estimate_not_in_labor_force" DOUBLE -- Estimate; Not In Labor Force,
"margin_of_error_not_in_labor_force" DOUBLE -- Margin Of Error; Not In Labor Force
);CREATE TABLE full_time_year_round_work_status_in_the_past_12_months_by_age (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_16_to_19_years" DOUBLE -- Estimate; 16 To 19 Years:,
"margin_of_error_16_to_19_years" DOUBLE -- Margin Of Error; 16 To 19 Years:,
"estimate_16_to_19_years_worked_in_the_past_12_months" DOUBLE -- Estimate; 16 To 19 Years: - Worked In The Past 12 Months:,
"margin_of_error_16_to_19_years_worked_in_the_past_12_months" DOUBLE -- Margin Of Error; 16 To 19 Years: - Worked In The Past 12 Months:,
"estimate_16_to_19_years_worked_in_the_past_12_months_w_dda5b9f6" DOUBLE -- Estimate; 16 To 19 Years: - Worked In The Past 12 Months: - Worked Full-time, Year-round,
"margin_of_error_16_to_19_years_worked_in_the_past_12_m_70d90bbc" DOUBLE -- Margin Of Error; 16 To 19 Years: - Worked In The Past 12 Months: - Worked Full-time, Year-round,
"estimate_16_to_19_years_worked_in_the_past_12_months_w_3083e096" DOUBLE -- Estimate; 16 To 19 Years: - Worked In The Past 12 Months: - Worked Less Than Full-time, Year-round,
"margin_of_error_16_to_19_years_worked_in_the_past_12_m_806ece58" DOUBLE -- Margin Of Error; 16 To 19 Years: - Worked In The Past 12 Months: - Worked Less Than Full-time, Year-round,
"estimate_16_to_19_years_did_not_work_in_the_past_12_months" DOUBLE -- Estimate; 16 To 19 Years: - Did Not Work In The Past 12 Months,
"margin_of_error_16_to_19_years_did_not_work_in_the_pas_c17232aa" DOUBLE -- Margin Of Error; 16 To 19 Years: - Did Not Work In The Past 12 Months,
"estimate_20_to_24_years" DOUBLE -- Estimate; 20 To 24 Years:,
"margin_of_error_20_to_24_years" DOUBLE -- Margin Of Error; 20 To 24 Years:,
"estimate_20_to_24_years_worked_in_the_past_12_months" DOUBLE -- Estimate; 20 To 24 Years: - Worked In The Past 12 Months:,
"margin_of_error_20_to_24_years_worked_in_the_past_12_months" DOUBLE -- Margin Of Error; 20 To 24 Years: - Worked In The Past 12 Months:,
"estimate_20_to_24_years_worked_in_the_past_12_months_w_e002e409" DOUBLE -- Estimate; 20 To 24 Years: - Worked In The Past 12 Months: - Worked Full-time, Year-round,
"margin_of_error_20_to_24_years_worked_in_the_past_12_m_149096fb" DOUBLE -- Margin Of Error; 20 To 24 Years: - Worked In The Past 12 Months: - Worked Full-time, Year-round,
"estimate_20_to_24_years_worked_in_the_past_12_months_w_c5de49b5" DOUBLE -- Estimate; 20 To 24 Years: - Worked In The Past 12 Months: - Worked Less Than Full-time, Year-round,
"margin_of_error_20_to_24_years_worked_in_the_past_12_m_e915de76" DOUBLE -- Margin Of Error; 20 To 24 Years: - Worked In The Past 12 Months: - Worked Less Than Full-time, Year-round,
"estimate_20_to_24_years_did_not_work_in_the_past_12_months" DOUBLE -- Estimate; 20 To 24 Years: - Did Not Work In The Past 12 Months,
"margin_of_error_20_to_24_years_did_not_work_in_the_pas_c33996d3" DOUBLE -- Margin Of Error; 20 To 24 Years: - Did Not Work In The Past 12 Months,
"estimate_25_to_44_years" DOUBLE -- Estimate; 25 To 44 Years:,
"margin_of_error_25_to_44_years" DOUBLE -- Margin Of Error; 25 To 44 Years:,
"estimate_25_to_44_years_worked_in_the_past_12_months" DOUBLE -- Estimate; 25 To 44 Years: - Worked In The Past 12 Months:,
"margin_of_error_25_to_44_years_worked_in_the_past_12_months" DOUBLE -- Margin Of Error; 25 To 44 Years: - Worked In The Past 12 Months:,
"estimate_25_to_44_years_worked_in_the_past_12_months_w_dea49e6a" DOUBLE -- Estimate; 25 To 44 Years: - Worked In The Past 12 Months: - Worked Full-time, Year-round,
"margin_of_error_25_to_44_years_worked_in_the_past_12_m_1b490e80" DOUBLE -- Margin Of Error; 25 To 44 Years: - Worked In The Past 12 Months: - Worked Full-time, Year-round,
"estimate_25_to_44_years_worked_in_the_past_12_months_w_0d85cdc7" DOUBLE -- Estimate; 25 To 44 Years: - Worked In The Past 12 Months: - Worked Less Than Full-time, Year-round,
"margin_of_error_25_to_44_years_worked_in_the_past_12_m_3751342b" DOUBLE -- Margin Of Error; 25 To 44 Years: - Worked In The Past 12 Months: - Worked Less Than Full-time, Year-round,
"estimate_25_to_44_years_did_not_work_in_the_past_12_months" DOUBLE -- Estimate; 25 To 44 Years: - Did Not Work In The Past 12 Months,
"margin_of_error_25_to_44_years_did_not_work_in_the_pas_e339b7b6" DOUBLE -- Margin Of Error; 25 To 44 Years: - Did Not Work In The Past 12 Months,
"estimate_45_to_54_years" DOUBLE -- Estimate; 45 To 54 Years:,
"margin_of_error_45_to_54_years" DOUBLE -- Margin Of Error; 45 To 54 Years:,
"estimate_45_to_54_years_worked_in_the_past_12_months" DOUBLE -- Estimate; 45 To 54 Years: - Worked In The Past 12 Months:,
"margin_of_error_45_to_54_years_worked_in_the_past_12_months" DOUBLE -- Margin Of Error; 45 To 54 Years: - Worked In The Past 12 Months:,
"estimate_45_to_54_years_worked_in_the_past_12_months_w_f4ba73f7" DOUBLE -- Estimate; 45 To 54 Years: - Worked In The Past 12 Months: - Worked Full-time, Year-round,
"margin_of_error_45_to_54_years_worked_in_the_past_12_m_324c933e" DOUBLE -- Margin Of Error; 45 To 54 Years: - Worked In The Past 12 Months: - Worked Full-time, Year-round,
"estimate_45_to_54_years_worked_in_the_past_12_months_w_522eb5ce" DOUBLE -- Estimate; 45 To 54 Years: - Worked In The Past 12 Months: - Worked Less Than Full-time, Year-round,
"margin_of_error_45_to_54_years_worked_in_the_past_12_m_548aec9a" DOUBLE -- Margin Of Error; 45 To 54 Years: - Worked In The Past 12 Months: - Worked Less Than Full-time, Year-round,
"estimate_45_to_54_years_did_not_work_in_the_past_12_months" DOUBLE -- Estimate; 45 To 54 Years: - Did Not Work In The Past 12 Months,
"margin_of_error_45_to_54_years_did_not_work_in_the_pas_228fd23e" DOUBLE -- Margin Of Error; 45 To 54 Years: - Did Not Work In The Past 12 Months,
"estimate_55_to_64_years" DOUBLE -- Estimate; 55 To 64 Years:,
"margin_of_error_55_to_64_years" DOUBLE -- Margin Of Error; 55 To 64 Years:,
"estimate_55_to_64_years_worked_in_the_past_12_months" DOUBLE -- Estimate; 55 To 64 Years: - Worked In The Past 12 Months:,
"margin_of_error_55_to_64_years_worked_in_the_past_12_months" DOUBLE -- Margin Of Error; 55 To 64 Years: - Worked In The Past 12 Months:,
"estimate_55_to_64_years_worked_in_the_past_12_months_w_a9949475" DOUBLE -- Estimate; 55 To 64 Years: - Worked In The Past 12 Months: - Worked Full-time, Year-round,
"margin_of_error_55_to_64_years_worked_in_the_past_12_m_77ff2037" DOUBLE -- Margin Of Error; 55 To 64 Years: - Worked In The Past 12 Months: - Worked Full-time, Year-round,
"estimate_55_to_64_years_worked_in_the_past_12_months_w_e92e0df9" DOUBLE -- Estimate; 55 To 64 Years: - Worked In The Past 12 Months: - Worked Less Than Full-time, Year-round,
"margin_of_error_55_to_64_years_worked_in_the_past_12_m_8908b501" DOUBLE -- Margin Of Error; 55 To 64 Years: - Worked In The Past 12 Months: - Worked Less Than Full-time, Year-round,
"estimate_55_to_64_years_did_not_work_in_the_past_12_months" DOUBLE -- Estimate; 55 To 64 Years: - Did Not Work In The Past 12 Months,
"margin_of_error_55_to_64_years_did_not_work_in_the_pas_7456dab9" DOUBLE -- Margin Of Error; 55 To 64 Years: - Did Not Work In The Past 12 Months,
"estimate_65_to_69_years" DOUBLE -- Estimate; 65 To 69 Years:,
"margin_of_error_65_to_69_years" DOUBLE -- Margin Of Error; 65 To 69 Years:,
"estimate_65_to_69_years_worked_in_the_past_12_months" DOUBLE -- Estimate; 65 To 69 Years: - Worked In The Past 12 Months:,
"margin_of_error_65_to_69_years_worked_in_the_past_12_months" DOUBLE -- Margin Of Error; 65 To 69 Years: - Worked In The Past 12 Months:,
"estimate_65_to_69_years_worked_in_the_past_12_months_w_69c6276b" DOUBLE -- Estimate; 65 To 69 Years: - Worked In The Past 12 Months: - Worked Full-time, Year-round,
"margin_of_error_65_to_69_years_worked_in_the_past_12_m_d47e9e05" DOUBLE -- Margin Of Error; 65 To 69 Years: - Worked In The Past 12 Months: - Worked Full-time, Year-round,
"estimate_65_to_69_years_worked_in_the_past_12_months_w_ecf9f5df" DOUBLE -- Estimate; 65 To 69 Years: - Worked In The Past 12 Months: - Worked Less Than Full-time, Year-round,
"margin_of_error_65_to_69_years_worked_in_the_past_12_m_3bf940fa" DOUBLE -- Margin Of Error; 65 To 69 Years: - Worked In The Past 12 Months: - Worked Less Than Full-time, Year-round,
"estimate_65_to_69_years_did_not_work_in_the_past_12_months" DOUBLE -- Estimate; 65 To 69 Years: - Did Not Work In The Past 12 Months,
"margin_of_error_65_to_69_years_did_not_work_in_the_pas_790eace5" DOUBLE -- Margin Of Error; 65 To 69 Years: - Did Not Work In The Past 12 Months,
"estimate_70_years_and_over" DOUBLE -- Estimate; 70 Years And Over:,
"margin_of_error_70_years_and_over" DOUBLE -- Margin Of Error; 70 Years And Over:,
"estimate_70_years_and_over_worked_in_the_past_12_months" DOUBLE -- Estimate; 70 Years And Over: - Worked In The Past 12 Months:,
"margin_of_error_70_years_and_over_worked_in_the_past_12_months" DOUBLE -- Margin Of Error; 70 Years And Over: - Worked In The Past 12 Months:,
"estimate_70_years_and_over_worked_in_the_past_12_month_728d032b" DOUBLE -- Estimate; 70 Years And Over: - Worked In The Past 12 Months: - Worked Full-time, Year-round,
"margin_of_error_70_years_and_over_worked_in_the_past_1_9bdf25a2" DOUBLE -- Margin Of Error; 70 Years And Over: - Worked In The Past 12 Months: - Worked Full-time, Year-round,
"estimate_70_years_and_over_worked_in_the_past_12_month_9179007b" DOUBLE -- Estimate; 70 Years And Over: - Worked In The Past 12 Months: - Worked Less Than Full-time, Year-round,
"margin_of_error_70_years_and_over_worked_in_the_past_1_7df48047" DOUBLE -- Margin Of Error; 70 Years And Over: - Worked In The Past 12 Months: - Worked Less Than Full-time, Year-round,
"estimate_70_years_and_over_did_not_work_in_the_past_12_months" DOUBLE -- Estimate; 70 Years And Over: - Did Not Work In The Past 12 Months,
"margin_of_error_70_years_and_over_did_not_work_in_the__329a8d97" DOUBLE -- Margin Of Error; 70 Years And Over: - Did Not Work In The Past 12 Months
);CREATE TABLE household_language_by_household_limited_english_speaking_status (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_total_english_only" DOUBLE -- Estimate; Total: - English Only,
"margin_of_error_total_english_only" DOUBLE -- Margin Of Error; Total: - English Only,
"estimate_total_spanish" DOUBLE -- Estimate; Total: - Spanish:,
"margin_of_error_total_spanish" DOUBLE -- Margin Of Error; Total: - Spanish:,
"estimate_total_spanish_limited_english_speaking_household" DOUBLE -- Estimate; Total: - Spanish: - Limited English Speaking Household,
"margin_of_error_total_spanish_limited_english_speaking_a2ef0110" DOUBLE -- Margin Of Error; Total: - Spanish: - Limited English Speaking Household,
"estimate_total_spanish_not_a_limited_english_speaking_household" DOUBLE -- Estimate; Total: - Spanish: - Not A Limited English Speaking Household,
"margin_of_error_total_spanish_not_a_limited_english_sp_3c9fe60e" DOUBLE -- Margin Of Error; Total: - Spanish: - Not A Limited English Speaking Household,
"estimate_total_other_indo_european_languages" DOUBLE -- Estimate; Total: - Other Indo-European Languages:,
"margin_of_error_total_other_indo_european_languages" DOUBLE -- Margin Of Error; Total: - Other Indo-European Languages:,
"estimate_total_other_indo_european_languages_limited_e_aced86f2" DOUBLE -- Estimate; Total: - Other Indo-European Languages: - Limited English Speaking Household,
"margin_of_error_total_other_indo_european_languages_li_04361ec2" DOUBLE -- Margin Of Error; Total: - Other Indo-European Languages: - Limited English Speaking Household,
"estimate_total_other_indo_european_languages_not_a_lim_191ab38f" DOUBLE -- Estimate; Total: - Other Indo-European Languages: - Not A Limited English Speaking Household,
"margin_of_error_total_other_indo_european_languages_no_697b2f66" DOUBLE -- Margin Of Error; Total: - Other Indo-European Languages: - Not A Limited English Speaking Household,
"estimate_total_asian_and_pacific_island_languages" DOUBLE -- Estimate; Total: - Asian And Pacific Island Languages:,
"margin_of_error_total_asian_and_pacific_island_languages" DOUBLE -- Margin Of Error; Total: - Asian And Pacific Island Languages:,
"estimate_total_asian_and_pacific_island_languages_limi_48e4ddd0" DOUBLE -- Estimate; Total: - Asian And Pacific Island Languages: - Limited English Speaking Household,
"margin_of_error_total_asian_and_pacific_island_languag_e016be1c" DOUBLE -- Margin Of Error; Total: - Asian And Pacific Island Languages: - Limited English Speaking Household,
"estimate_total_asian_and_pacific_island_languages_not__ec98ac8d" DOUBLE -- Estimate; Total: - Asian And Pacific Island Languages: - Not A Limited English Speaking Household,
"margin_of_error_total_asian_and_pacific_island_languag_4aaf69c4" DOUBLE -- Margin Of Error; Total: - Asian And Pacific Island Languages: - Not A Limited English Speaking Household,
"estimate_total_other_languages" DOUBLE -- Estimate; Total: - Other Languages:,
"margin_of_error_total_other_languages" DOUBLE -- Margin Of Error; Total: - Other Languages:,
"estimate_total_other_languages_limited_english_speakin_b7030d81" DOUBLE -- Estimate; Total: - Other Languages: - Limited English Speaking Household,
"margin_of_error_total_other_languages_limited_english__3a84d5e0" DOUBLE -- Margin Of Error; Total: - Other Languages: - Limited English Speaking Household,
"estimate_total_other_languages_not_a_limited_english_s_e8c6fb72" DOUBLE -- Estimate; Total: - Other Languages: - Not A Limited English Speaking Household,
"margin_of_error_total_other_languages_not_a_limited_en_bd2261c4" DOUBLE -- Margin Of Error; Total: - Other Languages: - Not A Limited English Speaking Household
);CREATE TABLE housing_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_or_more" DOUBLE -- Estimate; Total: - $1,000,000 Or More,
"margin_of_error_total_1_000_000_or_more" DOUBLE -- Margin Of Error; Total: - $1,000,000 Or More
);CREATE TABLE poverty_status_of_individuals_in_the_past_12_months_by_4ae836b5 (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_income_in_the_past_12_months_below_poverty_level" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level:,
"margin_of_error_income_in_the_past_12_months_below_pov_458472e3" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level:,
"estimate_income_in_the_past_12_months_below_poverty_le_6726880a" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Family Households:,
"margin_of_error_income_in_the_past_12_months_below_pov_d10f3b56" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Family Households:,
"estimate_income_in_the_past_12_months_below_poverty_le_64113316" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Married Couple Families:,
"margin_of_error_income_in_the_past_12_months_below_pov_47005a00" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Married Couple Families:,
"estimate_income_in_the_past_12_months_below_poverty_le_8df7c691" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Married Couple Families: - All Relatives,
"margin_of_error_income_in_the_past_12_months_below_pov_2058143a" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Married Couple Families: - All Relatives,
"estimate_income_in_the_past_12_months_below_poverty_le_6877fef6" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Married Couple Families: - Non-relatives,
"margin_of_error_income_in_the_past_12_months_below_pov_8ee87ba9" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Married Couple Families: - Non-relatives,
"estimate_income_in_the_past_12_months_below_poverty_le_84b6d6f6" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Other Families:,
"margin_of_error_income_in_the_past_12_months_below_pov_13b5a966" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Other Families:,
"estimate_income_in_the_past_12_months_below_poverty_le_8a65a56f" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Other Families: - Male Householder, No Wife Present:,
"margin_of_error_income_in_the_past_12_months_below_pov_80f090ab" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Other Families: - Male Householder, No Wife Present:,
"estimate_income_in_the_past_12_months_below_poverty_le_6427d1cb" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Other Families: - Male Householder, No Wife Present: - All Relatives,
"margin_of_error_income_in_the_past_12_months_below_pov_d037dbdd" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Other Families: - Male Householder, No Wife Present: - All Relatives,
"estimate_income_in_the_past_12_months_below_poverty_le_d117015f" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Other Families: - Male Householder, No Wife Present: - Non-relatives,
"margin_of_error_income_in_the_past_12_months_below_pov_07114133" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Other Families: - Male Householder, No Wife Present: - Non-relatives,
"estimate_income_in_the_past_12_months_below_poverty_le_d6d2c515" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Other Families: - Female Householder, No Husband Present:,
"margin_of_error_income_in_the_past_12_months_below_pov_643477a8" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Other Families: - Female Householder, No Husband Present:,
"estimate_income_in_the_past_12_months_below_poverty_le_cf791b37" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Other Families: - Female Householder, No Husband Present: - All Relatives,
"margin_of_error_income_in_the_past_12_months_below_pov_713bf1ff" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Other Families: - Female Householder, No Husband Present: - All Relatives,
"estimate_income_in_the_past_12_months_below_poverty_le_255f7fdf" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Other Families: - Female Householder, No Husband Present: - Non-relatives,
"margin_of_error_income_in_the_past_12_months_below_pov_287e03d3" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Family Households: - In Other Families: - Female Householder, No Husband Present: - Non-relatives,
"estimate_income_in_the_past_12_months_below_poverty_le_b6fc8c7a" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Non-family Households And Other Living Arrangement:,
"margin_of_error_income_in_the_past_12_months_below_pov_973a6b32" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Non-family Households And Other Living Arrangement:,
"estimate_income_in_the_past_12_months_below_poverty_le_60f8ed87" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Non-family Households And Other Living Arrangement: - Householder:,
"margin_of_error_income_in_the_past_12_months_below_pov_2a5b020d" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Non-family Households And Other Living Arrangement: - Householder:,
"estimate_income_in_the_past_12_months_below_poverty_le_cf0f5e90" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Non-family Households And Other Living Arrangement: - Householder: - Living Alone,
"margin_of_error_income_in_the_past_12_months_below_pov_72434c1f" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Non-family Households And Other Living Arrangement: - Householder: - Living Alone,
"estimate_income_in_the_past_12_months_below_poverty_le_4128c3e5" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Non-family Households And Other Living Arrangement: - Householder: - Not Living Alone,
"margin_of_error_income_in_the_past_12_months_below_pov_3c946fbe" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Non-family Households And Other Living Arrangement: - Householder: - Not Living Alone,
"estimate_income_in_the_past_12_months_below_poverty_le_5aee5345" DOUBLE -- Estimate; Income In The Past 12 Months Below Poverty Level: - In Non-family Households And Other Living Arrangement: - Other Living Arrangement,
"margin_of_error_income_in_the_past_12_months_below_pov_e4441f7e" DOUBLE -- Margin Of Error; Income In The Past 12 Months Below Poverty Level: - In Non-family Households And Other Living Arrangement: - Other Living Arrangement,
"estimate_income_in_the_past_12_months_at_or_above_pove_aa8a9083" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level:,
"margin_of_error_income_in_the_past_12_months_at_or_abo_8dc7a68f" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level:,
"estimate_income_in_the_past_12_months_at_or_above_pove_5b52a2b5" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households:,
"margin_of_error_income_in_the_past_12_months_at_or_abo_978877fb" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households:,
"estimate_income_in_the_past_12_months_at_or_above_pove_66b3f2f0" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Married Couple Families:,
"margin_of_error_income_in_the_past_12_months_at_or_abo_2be594b7" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Married Couple Families:,
"estimate_income_in_the_past_12_months_at_or_above_pove_2e58ca88" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Married Couple Families: - All Relatives,
"margin_of_error_income_in_the_past_12_months_at_or_abo_48fe761a" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Married Couple Families: - All Relatives,
"estimate_income_in_the_past_12_months_at_or_above_pove_9b25cbfe" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Married Couple Families: - Non-relatives,
"margin_of_error_income_in_the_past_12_months_at_or_abo_51cebd3a" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Married Couple Families: - Non-relatives,
"estimate_income_in_the_past_12_months_at_or_above_pove_9e34ae93" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Other Families:,
"margin_of_error_income_in_the_past_12_months_at_or_abo_a7c59ca6" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Other Families:,
"estimate_income_in_the_past_12_months_at_or_above_pove_dac1fe60" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Other Families: - Male Householder, No Wife Present:,
"margin_of_error_income_in_the_past_12_months_at_or_abo_870bbd39" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Other Families: - Male Householder, No Wife Present:,
"estimate_income_in_the_past_12_months_at_or_above_pove_719bb156" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Other Families: - Male Householder, No Wife Present: - All Relatives,
"margin_of_error_income_in_the_past_12_months_at_or_abo_70a7cac5" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Other Families: - Male Householder, No Wife Present: - All Relatives,
"estimate_income_in_the_past_12_months_at_or_above_pove_2d07d3a4" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Other Families: - Male Householder, No Wife Present: - Non-relatives,
"margin_of_error_income_in_the_past_12_months_at_or_abo_887b59ca" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Other Families: - Male Householder, No Wife Present: - Non-relatives,
"estimate_income_in_the_past_12_months_at_or_above_pove_63a9dd82" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Other Families: - Female Householder, No Husband Present:,
"margin_of_error_income_in_the_past_12_months_at_or_abo_7f3ca011" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Other Families: - Female Householder, No Husband Present:,
"estimate_income_in_the_past_12_months_at_or_above_pove_0183583d" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Other Families: - Female Householder, No Husband Present: - All Relatives,
"margin_of_error_income_in_the_past_12_months_at_or_abo_c95a8680" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Other Families: - Female Householder, No Husband Present: - All Relatives,
"estimate_income_in_the_past_12_months_at_or_above_pove_85ed53e1" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Other Families: - Female Householder, No Husband Present: - Non-relatives,
"margin_of_error_income_in_the_past_12_months_at_or_abo_893c98ea" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Family Households: - In Other Families: - Female Householder, No Husband Present: - Non-relatives,
"estimate_income_in_the_past_12_months_at_or_above_pove_a9e250c5" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Non-family Households And Other Living Arrangement:,
"margin_of_error_income_in_the_past_12_months_at_or_abo_8a3a4f50" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Non-family Households And Other Living Arrangement:,
"estimate_income_in_the_past_12_months_at_or_above_pove_b5af671f" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Non-family Households And Other Living Arrangement: - Householder:,
"margin_of_error_income_in_the_past_12_months_at_or_abo_81bf99e5" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Non-family Households And Other Living Arrangement: - Householder:,
"estimate_income_in_the_past_12_months_at_or_above_pove_27a41190" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Non-family Households And Other Living Arrangement: - Householder: - Living Alone,
"margin_of_error_income_in_the_past_12_months_at_or_abo_8796d4fe" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Non-family Households And Other Living Arrangement: - Householder: - Living Alone,
"estimate_income_in_the_past_12_months_at_or_above_pove_ac2a0e9f" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Non-family Households And Other Living Arrangement: - Householder: - Not Living Alone,
"margin_of_error_income_in_the_past_12_months_at_or_abo_8a0a0a0e" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Non-family Households And Other Living Arrangement: - Householder: - Not Living Alone,
"estimate_income_in_the_past_12_months_at_or_above_pove_f5b74bd8" DOUBLE -- Estimate; Income In The Past 12 Months At Or Above Poverty Level: - In Non-family Households And Other Living Arrangement: - Other Living Arrangement,
"margin_of_error_income_in_the_past_12_months_at_or_abo_9788fac9" DOUBLE -- Margin Of Error; Income In The Past 12 Months At Or Above Poverty Level: - In Non-family Households And Other Living Arrangement: - Other Living Arrangement
);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 receipt_of_food_stamps_snap_in_the_past_12_months_by_d_3ff75cc3 (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_household_received_food_stamps_snap_in_the_pa_6e821a51" DOUBLE -- Estimate; Household Received Food Stamps/SNAP In The Past 12 Months:,
"margin_of_error_household_received_food_stamps_snap_in_00a59fac" DOUBLE -- Margin Of Error; Household Received Food Stamps/SNAP In The Past 12 Months:,
"estimate_household_received_food_stamps_snap_in_the_pa_1873cc70" DOUBLE -- Estimate; Household Received Food Stamps/SNAP In The Past 12 Months: - Households With 1 Or More Persons With A Disability,
"margin_of_error_household_received_food_stamps_snap_in_5b18ee74" DOUBLE -- Margin Of Error; Household Received Food Stamps/SNAP In The Past 12 Months: - Households With 1 Or More Persons With A Disability,
"estimate_household_received_food_stamps_snap_in_the_pa_c09632b8" DOUBLE -- Estimate; Household Received Food Stamps/SNAP In The Past 12 Months: - Households With No Persons With A Disability,
"margin_of_error_household_received_food_stamps_snap_in_973893a6" DOUBLE -- Margin Of Error; Household Received Food Stamps/SNAP In The Past 12 Months: - Households With No Persons With A Disability,
"estimate_household_did_not_receive_food_stamps_snap_in_617f4a25" DOUBLE -- Estimate; Household Did Not Receive Food Stamps/SNAP In The Past 12 Months:,
"margin_of_error_household_did_not_receive_food_stamps__26e84d0e" DOUBLE -- Margin Of Error; Household Did Not Receive Food Stamps/SNAP In The Past 12 Months:,
"estimate_household_did_not_receive_food_stamps_snap_in_58f6e73a" DOUBLE -- Estimate; Household Did Not Receive Food Stamps/SNAP In The Past 12 Months: - Households With 1 Or More Persons With A Disability,
"margin_of_error_household_did_not_receive_food_stamps__2f6fcac8" DOUBLE -- Margin Of Error; Household Did Not Receive Food Stamps/SNAP In The Past 12 Months: - Households With 1 Or More Persons With A Disability,
"estimate_household_did_not_receive_food_stamps_snap_in_7718f72e" DOUBLE -- Estimate; Household Did Not Receive Food Stamps/SNAP In The Past 12 Months: - Households With No Persons With A Disability,
"margin_of_error_household_did_not_receive_food_stamps__00adb5c5" DOUBLE -- Margin Of Error; Household Did Not Receive Food Stamps/SNAP In The Past 12 Months: - Households With No Persons With A Disability
);CREATE TABLE retirement_income_in_the_past_12_months (
"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 (
"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_class_of_worker_for_the_civilian_employed_popul_726effda (
"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_private_for_profit_wage_and_salary_workers" DOUBLE -- Estimate; Male: - Private For-profit Wage And Salary Workers:,
"margin_of_error_male_private_for_profit_wage_and_salar_426f78ff" DOUBLE -- Margin Of Error; Male: - Private For-profit Wage And Salary Workers:,
"estimate_male_private_for_profit_wage_and_salary_worke_20578019" DOUBLE -- Estimate; Male: - Private For-profit Wage And Salary Workers: - Employee Of Private Company Workers,
"margin_of_error_male_private_for_profit_wage_and_salar_213dca85" DOUBLE -- Margin Of Error; Male: - Private For-profit Wage And Salary Workers: - Employee Of Private Company Workers,
"estimate_male_private_for_profit_wage_and_salary_worke_b3e312d1" DOUBLE -- Estimate; Male: - Private For-profit Wage And Salary Workers: - Self-employed In Own Incorporated Business Workers,
"margin_of_error_male_private_for_profit_wage_and_salar_f5a24c9a" DOUBLE -- Margin Of Error; Male: - Private For-profit Wage And Salary Workers: - Self-employed In Own Incorporated Business Workers,
"estimate_male_private_not_for_profit_wage_and_salary_workers" DOUBLE -- Estimate; Male: - Private Not-for-profit Wage And Salary Workers,
"margin_of_error_male_private_not_for_profit_wage_and_s_a0eef1f9" DOUBLE -- Margin Of Error; Male: - Private Not-for-profit Wage And Salary Workers,
"estimate_male_local_government_workers" DOUBLE -- Estimate; Male: - Local Government Workers,
"margin_of_error_male_local_government_workers" DOUBLE -- Margin Of Error; Male: - Local Government Workers,
"estimate_male_state_government_workers" DOUBLE -- Estimate; Male: - State Government Workers,
"margin_of_error_male_state_government_workers" DOUBLE -- Margin Of Error; Male: - State Government Workers,
"estimate_male_federal_government_workers" DOUBLE -- Estimate; Male: - Federal Government Workers,
"margin_of_error_male_federal_government_workers" DOUBLE -- Margin Of Error; Male: - Federal Government Workers,
"estimate_male_self_employed_in_own_not_incorporated_bu_5f29fe21" DOUBLE -- Estimate; Male: - Self-employed In Own Not Incorporated Business Workers,
"margin_of_error_male_self_employed_in_own_not_incorpor_5aea8276" DOUBLE -- Margin Of Error; Male: - Self-employed In Own Not Incorporated Business Workers,
"estimate_male_unpaid_family_workers" DOUBLE -- Estimate; Male: - Unpaid Family Workers,
"margin_of_error_male_unpaid_family_workers" DOUBLE -- Margin Of Error; Male: - Unpaid Family Workers,
"estimate_female" DOUBLE -- Estimate; Female:,
"margin_of_error_female" DOUBLE -- Margin Of Error; Female:,
"estimate_female_private_for_profit_wage_and_salary_workers" DOUBLE -- Estimate; Female: - Private For-profit Wage And Salary Workers:,
"margin_of_error_female_private_for_profit_wage_and_sal_d2b4c714" DOUBLE -- Margin Of Error; Female: - Private For-profit Wage And Salary Workers:,
"estimate_female_private_for_profit_wage_and_salary_wor_1a2323f5" DOUBLE -- Estimate; Female: - Private For-profit Wage And Salary Workers: - Employee Of Private Company Workers,
"margin_of_error_female_private_for_profit_wage_and_sal_e5eaf157" DOUBLE -- Margin Of Error; Female: - Private For-profit Wage And Salary Workers: - Employee Of Private Company Workers,
"estimate_female_private_for_profit_wage_and_salary_wor_beff83a8" DOUBLE -- Estimate; Female: - Private For-profit Wage And Salary Workers: - Self-employed In Own Incorporated Business Workers,
"margin_of_error_female_private_for_profit_wage_and_sal_5dfba027" DOUBLE -- Margin Of Error; Female: - Private For-profit Wage And Salary Workers: - Self-employed In Own Incorporated Business Workers,
"estimate_female_private_not_for_profit_wage_and_salary_workers" DOUBLE -- Estimate; Female: - Private Not-for-profit Wage And Salary Workers,
"margin_of_error_female_private_not_for_profit_wage_and_9fc064d4" DOUBLE -- Margin Of Error; Female: - Private Not-for-profit Wage And Salary Workers,
"estimate_female_local_government_workers" DOUBLE -- Estimate; Female: - Local Government Workers,
"margin_of_error_female_local_government_workers" DOUBLE -- Margin Of Error; Female: - Local Government Workers,
"estimate_female_state_government_workers" DOUBLE -- Estimate; Female: - State Government Workers,
"margin_of_error_female_state_government_workers" DOUBLE -- Margin Of Error; Female: - State Government Workers,
"estimate_female_federal_government_workers" DOUBLE -- Estimate; Female: - Federal Government Workers,
"margin_of_error_female_federal_government_workers" DOUBLE -- Margin Of Error; Female: - Federal Government Workers,
"estimate_female_self_employed_in_own_not_incorporated__c83b0f53" DOUBLE -- Estimate; Female: - Self-employed In Own Not Incorporated Business Workers,
"margin_of_error_female_self_employed_in_own_not_incorp_52ee73cd" DOUBLE -- Margin Of Error; Female: - Self-employed In Own Not Incorporated Business Workers,
"estimate_female_unpaid_family_workers" DOUBLE -- Estimate; Female: - Unpaid Family Workers,
"margin_of_error_female_unpaid_family_workers" DOUBLE -- Margin Of Error; Female: - Unpaid Family Workers
);CREATE TABLE sex_by_educational_attainment_for_the_population_25_ye_0bae370c (
"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_no_schooling_completed" DOUBLE -- Estimate; Male: - No Schooling Completed,
"margin_of_error_male_no_schooling_completed" DOUBLE -- Margin Of Error; Male: - No Schooling Completed,
"estimate_male_nursery_to_4th_grade" DOUBLE -- Estimate; Male: - Nursery To 4th Grade,
"margin_of_error_male_nursery_to_4th_grade" DOUBLE -- Margin Of Error; Male: - Nursery To 4th Grade,
"estimate_male_5th_and_6th_grade" DOUBLE -- Estimate; Male: - 5th And 6th Grade,
"margin_of_error_male_5th_and_6th_grade" DOUBLE -- Margin Of Error; Male: - 5th And 6th Grade,
"estimate_male_7th_and_8th_grade" DOUBLE -- Estimate; Male: - 7th And 8th Grade,
"margin_of_error_male_7th_and_8th_grade" DOUBLE -- Margin Of Error; Male: - 7th And 8th Grade,
"estimate_male_9th_grade" DOUBLE -- Estimate; Male: - 9th Grade,
"margin_of_error_male_9th_grade" DOUBLE -- Margin Of Error; Male: - 9th Grade,
"estimate_male_10th_grade" DOUBLE -- Estimate; Male: - 10th Grade,
"margin_of_error_male_10th_grade" DOUBLE -- Margin Of Error; Male: - 10th Grade,
"estimate_male_11th_grade" DOUBLE -- Estimate; Male: - 11th Grade,
"margin_of_error_male_11th_grade" DOUBLE -- Margin Of Error; Male: - 11th Grade,
"estimate_male_12th_grade_no_diploma" DOUBLE -- Estimate; Male: - 12th Grade, No Diploma,
"margin_of_error_male_12th_grade_no_diploma" DOUBLE -- Margin Of Error; Male: - 12th Grade, No Diploma,
"estimate_male_high_school_graduate_includes_equivalency" DOUBLE -- Estimate; Male: - High School Graduate (includes Equivalency),
"margin_of_error_male_high_school_graduate_includes_equivalency" DOUBLE -- Margin Of Error; Male: - High School Graduate (includes Equivalency),
"estimate_male_some_college_less_than_1_year" DOUBLE -- Estimate; Male: - Some College, Less Than 1 Year,
"margin_of_error_male_some_college_less_than_1_year" DOUBLE -- Margin Of Error; Male: - Some College, Less Than 1 Year,
"estimate_male_some_college_1_or_more_years_no_degree" DOUBLE -- Estimate; Male: - Some College, 1 Or More Years, No Degree,
"margin_of_error_male_some_college_1_or_more_years_no_degree" DOUBLE -- Margin Of Error; Male: - Some College, 1 Or More Years, No Degree,
"estimate_male_associate_s_degree" DOUBLE -- Estimate; Male: - Associate's Degree,
"margin_of_error_male_associate_s_degree" DOUBLE -- Margin Of Error; Male: - Associate's Degree,
"estimate_male_bachelor_s_degree" DOUBLE -- Estimate; Male: - Bachelor's Degree,
"margin_of_error_male_bachelor_s_degree" DOUBLE -- Margin Of Error; Male: - Bachelor's Degree,
"estimate_male_master_s_degree" DOUBLE -- Estimate; Male: - Master's Degree,
"margin_of_error_male_master_s_degree" DOUBLE -- Margin Of Error; Male: - Master's Degree,
"estimate_male_professional_school_degree" DOUBLE -- Estimate; Male: - Professional School Degree,
"margin_of_error_male_professional_school_degree" DOUBLE -- Margin Of Error; Male: - Professional School Degree,
"estimate_male_doctorate_degree" DOUBLE -- Estimate; Male: - Doctorate Degree,
"margin_of_error_male_doctorate_degree" DOUBLE -- Margin Of Error; Male: - Doctorate Degree,
"estimate_female" DOUBLE -- Estimate; Female:,
"margin_of_error_female" DOUBLE -- Margin Of Error; Female:,
"estimate_female_no_schooling_completed" DOUBLE -- Estimate; Female: - No Schooling Completed,
"margin_of_error_female_no_schooling_completed" DOUBLE -- Margin Of Error; Female: - No Schooling Completed,
"estimate_female_nursery_to_4th_grade" DOUBLE -- Estimate; Female: - Nursery To 4th Grade,
"margin_of_error_female_nursery_to_4th_grade" DOUBLE -- Margin Of Error; Female: - Nursery To 4th Grade,
"estimate_female_5th_and_6th_grade" DOUBLE -- Estimate; Female: - 5th And 6th Grade,
"margin_of_error_female_5th_and_6th_grade" DOUBLE -- Margin Of Error; Female: - 5th And 6th Grade,
"estimate_female_7th_and_8th_grade" DOUBLE -- Estimate; Female: - 7th And 8th Grade,
"margin_of_error_female_7th_and_8th_grade" DOUBLE -- Margin Of Error; Female: - 7th And 8th Grade,
"estimate_female_9th_grade" DOUBLE -- Estimate; Female: - 9th Grade,
"margin_of_error_female_9th_grade" DOUBLE -- Margin Of Error; Female: - 9th Grade,
"estimate_female_10th_grade" DOUBLE -- Estimate; Female: - 10th Grade,
"margin_of_error_female_10th_grade" DOUBLE -- Margin Of Error; Female: - 10th Grade,
"estimate_female_11th_grade" DOUBLE -- Estimate; Female: - 11th Grade,
"margin_of_error_female_11th_grade" DOUBLE -- Margin Of Error; Female: - 11th Grade,
"estimate_female_12th_grade_no_diploma" DOUBLE -- Estimate; Female: - 12th Grade, No Diploma,
"margin_of_error_female_12th_grade_no_diploma" DOUBLE -- Margin Of Error; Female: - 12th Grade, No Diploma,
"estimate_female_high_school_graduate_includes_equivalency" DOUBLE -- Estimate; Female: - High School Graduate (includes Equivalency),
"margin_of_error_female_high_school_graduate_includes_e_2aa609b3" DOUBLE -- Margin Of Error; Female: - High School Graduate (includes Equivalency),
"estimate_female_some_college_less_than_1_year" DOUBLE -- Estimate; Female: - Some College, Less Than 1 Year,
"margin_of_error_female_some_college_less_than_1_year" DOUBLE -- Margin Of Error; Female: - Some College, Less Than 1 Year,
"estimate_female_some_college_1_or_more_years_no_degree" DOUBLE -- Estimate; Female: - Some College, 1 Or More Years, No Degree,
"margin_of_error_female_some_college_1_or_more_years_no_degree" DOUBLE -- Margin Of Error; Female: - Some College, 1 Or More Years, No Degree,
"estimate_female_associate_s_degree" DOUBLE -- Estimate; Female: - Associate's Degree,
"margin_of_error_female_associate_s_degree" DOUBLE -- Margin Of Error; Female: - Associate's Degree,
"estimate_female_bachelor_s_degree" DOUBLE -- Estimate; Female: - Bachelor's Degree,
"margin_of_error_female_bachelor_s_degree" DOUBLE -- Margin Of Error; Female: - Bachelor's Degree,
"estimate_female_master_s_degree" DOUBLE -- Estimate; Female: - Master's Degree,
"margin_of_error_female_master_s_degree" DOUBLE -- Margin Of Error; Female: - Master's Degree,
"estimate_female_professional_school_degree" DOUBLE -- Estimate; Female: - Professional School Degree,
"margin_of_error_female_professional_school_degree" DOUBLE -- Margin Of Error; Female: - Professional School Degree,
"estimate_female_doctorate_degree" DOUBLE -- Estimate; Female: - Doctorate Degree,
"margin_of_error_female_doctorate_degree" DOUBLE -- Margin Of Error; Female: - Doctorate Degree
);CREATE TABLE social_security_income_in_the_past_12_months (
"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 vacancy_status (
"neighborhood" VARCHAR,
"id" BIGINT,
"estimate_total" DOUBLE -- Estimate; Total:,
"margin_of_error_total" DOUBLE -- Margin Of Error; Total:,
"estimate_total_for_rent" DOUBLE -- Estimate; Total: - For Rent,
"margin_of_error_total_for_rent" DOUBLE -- Margin Of Error; Total: - For Rent,
"estimate_total_rented_not_occupied" DOUBLE -- Estimate; Total: - Rented, Not Occupied,
"margin_of_error_total_rented_not_occupied" DOUBLE -- Margin Of Error; Total: - Rented, Not Occupied,
"estimate_total_for_sale_only" DOUBLE -- Estimate; Total: - For Sale Only,
"margin_of_error_total_for_sale_only" DOUBLE -- Margin Of Error; Total: - For Sale Only,
"estimate_total_sold_not_occupied" DOUBLE -- Estimate; Total: - Sold, Not Occupied,
"margin_of_error_total_sold_not_occupied" DOUBLE -- Margin Of Error; Total: - Sold, Not Occupied,
"estimate_total_for_seasonal_recreational_or_occasional_use" DOUBLE -- Estimate; Total: - For Seasonal, Recreational, Or Occasional Use,
"margin_of_error_total_for_seasonal_recreational_or_occ_64f9e608" DOUBLE -- Margin Of Error; Total: - For Seasonal, Recreational, Or Occasional Use,
"estimate_total_for_migrant_workers" DOUBLE -- Estimate; Total: - For Migrant Workers,
"margin_of_error_total_for_migrant_workers" DOUBLE -- Margin Of Error; Total: - For Migrant Workers,
"estimate_total_other_vacant" DOUBLE -- Estimate; Total: - Other Vacant,
"margin_of_error_total_other_vacant" DOUBLE -- Margin Of Error; Total: - Other Vacant
);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.