Baselight

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

Loading...
Loading...

About this Dataset

Pittsburgh American Community Survey 2014 - Miscellaneous Data

Miscellaneous Reports from the 2014 American Community Survey Report
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:11:53.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

Tables

Aggregate Household Income In The Past 12 Months

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.aggregate_household_income_in_the_past_12_months
  • 8.02 kB
  • 91 rows
  • 4 columns
Loading...
CREATE TABLE aggregate_household_income_in_the_past_12_months (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_aggregate_household_income_in_the_past_12_mon_c1853f1d" VARCHAR  -- 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)
);

Contract Rent

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.contract_rent
  • 68.23 kB
  • 91 rows
  • 50 columns
Loading...
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
);

Educational Attainment For The Population 25 Years And Over

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.educational_attainment_for_the_population_25_years_and_over
  • 67.83 kB
  • 91 rows
  • 52 columns
Loading...
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
);

Employment Status For The Population 16 Years And Over

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.employment_status_for_the_population_16_years_and_over
  • 24.77 kB
  • 91 rows
  • 16 columns
Loading...
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
);

Full-Time, Year Round Work Status In The Past 12 Months By Age

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.full_time_year_round_work_status_in_the_past_12_months_by_age
  • 119.35 kB
  • 91 rows
  • 74 columns
Loading...
CREATE TABLE full_time_year_round_work_status_in_the_past_12_months_by_age (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- 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
);

Household Language By Household Limited English Speaking Status

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.household_language_by_household_limited_english_speaking_status
  • 44.05 kB
  • 91 rows
  • 30 columns
Loading...
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
);

Housing Value

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.housing_value
  • 67.99 kB
  • 91 rows
  • 52 columns
Loading...
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
);

Poverty Status Of Individuals In The Past 12 Months By Living Arrangements

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.poverty_status_of_individuals_in_the_past_12_months_by_4ae836b5
  • 119.53 kB
  • 91 rows
  • 72 columns
Loading...
CREATE TABLE poverty_status_of_individuals_in_the_past_12_months_by_4ae836b5 (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- 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
);

Public Assistance Income In The Past 12 Months For Households

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.public_assistance_income_in_the_past_12_months_for_households
  • 12.93 kB
  • 91 rows
  • 8 columns
Loading...
CREATE TABLE public_assistance_income_in_the_past_12_months_for_households (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- 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
);

Race

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.race
  • 32.48 kB
  • 91 rows
  • 22 columns
Loading...
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
);

Receipt Of Food Stamps/SNAP In The Past 12 Months By Disability Status

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.receipt_of_food_stamps_snap_in_the_past_12_months_by_d_3ff75cc3
  • 27.57 kB
  • 91 rows
  • 16 columns
Loading...
CREATE TABLE receipt_of_food_stamps_snap_in_the_past_12_months_by_d_3ff75cc3 (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- 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
);

Retirement Income In The Past 12 Months

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.retirement_income_in_the_past_12_months
  • 12.8 kB
  • 91 rows
  • 8 columns
Loading...
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
);

Self-Employment Income In The Past 12 Months

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.self_employment_income_in_the_past_12_months
  • 12.86 kB
  • 91 rows
  • 8 columns
Loading...
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
);

Sex By Class Of Worker For The Civilian Employed Population 16 Years Or Older

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.sex_by_class_of_worker_for_the_civilian_employed_popul_726effda
  • 66.34 kB
  • 91 rows
  • 44 columns
Loading...
CREATE TABLE sex_by_class_of_worker_for_the_civilian_employed_popul_726effda (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- 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
);

Sex By Educational Attainment For The Population 25 Years And Older

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.sex_by_educational_attainment_for_the_population_25_ye_0bae370c
  • 99.03 kB
  • 91 rows
  • 72 columns
Loading...
CREATE TABLE sex_by_educational_attainment_for_the_population_25_ye_0bae370c (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- 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
);

Social Security Income In The Past 12 Months

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.social_security_income_in_the_past_12_months
  • 12.99 kB
  • 91 rows
  • 8 columns
Loading...
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
);

Supplemental Security Income (SSI) In The Past 12 Months For Households

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.supplemental_security_income_ssi_in_the_past_12_months_6ec1b57a
  • 13.24 kB
  • 91 rows
  • 8 columns
Loading...
CREATE TABLE supplemental_security_income_ssi_in_the_past_12_months_6ec1b57a (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- 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)
);

Vacancy Status

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.vacancy_status
  • 23.71 kB
  • 91 rows
  • 18 columns
Loading...
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
);

Wage Or Salary Income In The Past 12 Months For Households

@usgov.allegheny_county_city_of_pitts_pittsburgh_american_com_55eae472.wage_or_salary_income_in_the_past_12_months_for_households
  • 12.96 kB
  • 91 rows
  • 8 columns
Loading...
CREATE TABLE wage_or_salary_income_in_the_past_12_months_for_households (
  "neighborhood" VARCHAR,
  "id" BIGINT,
  "estimate_total" DOUBLE  -- 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
);

Share link

Anyone who has the link will be able to view this.