About this Dataset

Incomes Occupations And Earnings - Seattle Neighborhoods

Table from the American Community Survey (ACS) 5-year series on income and earning related topics for City of Seattle Council Districts, Comprehensive Plan Growth Areas and Community Reporting Areas. Table includes B19025 Aggregate Household Income, B19013 Median Household Income, B19001 Household Income, B19113 Median Family Household Income, B19101 Family Household Income, B19202 Median Nonfamily Household Income, B19201 Nonfamily Household Income, B19301 Per Capita Income/B19313 Aggregate Income/B01001 Sex by Age, C24010 Sex by Occupation of the Civilian Employed Population 16 years and Over, B20017 Median Earnings by Sex by Work Experience for the Population 16 years and over with Earnings, B20001 Sex by Earnings for the Population 16 years and over with Earnings. Data is pulled from block group tables for the most recent ACS vintage and summarized to the neighborhoods based on block group assignment.

Table created for and used in the Neighborhood Profiles application.

Vintages : 2023

ACS Table(s) : B19013, B19001, B19113, B19101, B19202, B19201, B19301, B19313, B01001, C24010, B20017, B20001, B19025

Data downloaded from : <a href='https://data.census.gov/' style='color:rgb
Organization: City of Seattle
Last updated: 2024-12-16T22:20:26.792839
Tags: acs, acs-bg, american-community-survey, census, census-block-groups, demographics, earinings, gis, income, occupation, planning, seattle-gis-open-data

Tables

Table 1

@usgov.city_of_seattle_incomes_occupations_and_earnings_seatt_45372fc9.table_1

92.6 kB
92 rows
69 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "neigh_no" DOUBLE,
  "neighborhood_name" VARCHAR,
  "neighborhood_type" VARCHAR,
  "neighborhood_subtype" VARCHAR,
  "acs_vinatage" VARCHAR,
  "aggregate_income_in_the_past_12_months_in_2022_inflati_b33aa6fa" BIGINT  -- Aggregate Income In The Past 12 Months (in 2022 Inflation-adjusted Dollars),
  "total_population" BIGINT,
  "total_households" BIGINT,
  "household_income_less_than_10_000" VARCHAR  -- Household Income Less Than $10,000,
  "household_income_10_000_to_14_999" BIGINT  -- Household Income $10,000 To $14,999,
  "household_income_15_000_to_24_999" BIGINT  -- Household Income $15,000 To $24,999,
  "household_income_25_000_to_34_999" BIGINT  -- Household Income $25,000 To $34,999,
  "household_income_35_000_to_49_999" BIGINT  -- Household Income $35,000 To $49,999,
  "household_income_50_000_to_74_999" BIGINT  -- Household Income $50,000 To $74,999,
  "household_income_75_000_to_99_999" BIGINT  -- Household Income $75,000 To $99,999,
  "household_income_100_000_to_149_999" BIGINT  -- Household Income $100,000 To $149,999,
  "household_income_150_000_to_199_999" BIGINT  -- Household Income $150,000 To $199,999,
  "household_income_200_000_or_more" BIGINT  -- Household Income $200,000 Or More,
  "total_family_households" BIGINT,
  "family_household_income_less_than_10_000" VARCHAR  -- Family Household Income Less Than $10,000,
  "family_household_income_10_000_to_14_999" BIGINT  -- Family Household Income $10,000 To $14,999,
  "family_household_income_15_000_to_24_999" BIGINT  -- Family Household Income $15,000 To $24,999,
  "family_household_income_25_000_to_34_999" BIGINT  -- Family Household Income $25,000 To $34,999,
  "family_household_income_35_000_to_49_999" BIGINT  -- Family Household Income $35,000 To $49,999,
  "family_household_income_50_000_to_74_999" BIGINT  -- Family Household Income $50,000 To $74,999,
  "family_household_income_75_000_to_99_999" BIGINT  -- Family Household Income $75,000 To $99,999,
  "family_household_income_100_000_to_149_999" BIGINT  -- Family Household Income $100,000 To $149,999,
  "family_household_income_150_000_to_199_999" BIGINT  -- Family Household Income $150,000 To $199,999,
  "family_household_income_200_000_or_more" BIGINT  -- Family Household Income $200,000 Or More,
  "total_nonfamily_housholds" BIGINT,
  "nonfamily_household_income_less_than_10_000" VARCHAR  -- Nonfamily Household Income Less Than $10,000,
  "nonfamily_household_income_10_000_to_14_999" BIGINT  -- Nonfamily Household Income $10,000 To $14,999,
  "nonfamily_household_income_15_000_to_24_999" BIGINT  -- Nonfamily Household Income $15,000 To $24,999,
  "nonfamily_household_income_25_000_to_34_999" BIGINT  -- Nonfamily Household Income $25,000 To $34,999,
  "nonfamily_household_income_35_000_to_49_999" BIGINT  -- Nonfamily Household Income $35,000 To $49,999,
  "nonfamily_household_income_50_000_to_74_999" BIGINT  -- Nonfamily Household Income $50,000 To $74,999,
  "nonfamily_household_income_75_000_to_99_999" BIGINT  -- Nonfamily Household Income $75,000 To $99,999,
  "nonfamily_household_income_100_000_to_149_999" BIGINT  -- Nonfamily Household Income $100,000 To $149,999,
  "nonfamily_household_income_150_000_to_199_999" BIGINT  -- Nonfamily Household Income $150,000 To $199,999,
  "nonfamily_household_income_200_000_or_more" BIGINT  -- Nonfamily Household Income $200,000 Or More,
  "management_business_science_and_arts_occupations" BIGINT  -- Management, Business, Science, And Arts Occupations,
  "service_occupations" BIGINT,
  "sales_and_office_occupations" BIGINT,
  "natural_resources_construction_and_maintenance_occupations" BIGINT  -- Natural Resources, Construction, And Maintenance Occupations,
  "production_transportation_and_material_moving_occupations" BIGINT  -- Production, Transportation, And Material Moving Occupations,
  "earnings_male_less_than_10_000" BIGINT  -- Earnings Male Less Than $10,000,
  "earnings_male_10_000_to_19_999" BIGINT  -- Earnings Male $10,000 To $19,999,
  "earnings_male_20_000_to_39_999" BIGINT  -- Earnings Male $20,000 To $39,999,
  "earnings_male_40_000_to_74_999" BIGINT  -- Earnings Male $40,000 To $74,999,
  "earnings_male_75_000_to_99_999" BIGINT  -- Earnings Male $75,000 To $99,999,
  "earnings_male_100_000_or_more" BIGINT  -- Earnings Male $100,000 Or More,
  "earnings_female_less_than_10_000" BIGINT  -- Earnings Female Less Than $10,000,
  "earnings_female_10_000_to_19_999" BIGINT  -- Earnings Female $10,000 To $19,999,
  "earnings_female_20_000_to_39_999" BIGINT  -- Earnings Female $20,000 To $39,999,
  "earnings_female_40_000_to_74_999" BIGINT  -- Earnings Female $40,000 To $74,999,
  "earnings_female_75_000_to_99_999" BIGINT  -- Earnings Female $75,000 To $99,999,
  "earnings_female_100_000_or_more" BIGINT  -- Earnings Female $100,000 Or More,
  "household_income_100_000_or_more" BIGINT  -- Household Income $100,000 Or More,
  "family_household_income_100_000_or_more" BIGINT  -- Family Household Income $100,000 Or More,
  "nonfamily_household_income_100_000_or_more" BIGINT  -- Nonfamily Household Income $100,000 Or More,
  "earnings_50_000_or_more_male_workers" BIGINT  -- Earnings $50,000 Or More Male Workers,
  "earnings_50_000_or_more_female_workers" BIGINT  -- Earnings $50,000 Or More Female Workers,
  "population_16_years_and_over_with_earnings" BIGINT,
  "males_16_years_and_over_with_earnings" BIGINT,
  "females_16_years_and_over_with_earnings" BIGINT,
  "earnings_50_000_or_more_all_workers" BIGINT  -- Earnings $50,000 Or More All Workers,
  "aggregate_household_income" BIGINT,
  "neighborhood_type_outside_comp_plan_areas_id" VARCHAR  -- Neighborhood Type (outside Comp Plan Areas Id)
);