About this Dataset

OCCUPATION BY MEDIAN EARNINGS IN THE PAST 12 MONTHS (B24021)

Table from the American Community Survey (ACS) B24021 occupation by median earnings. These are multiple, nonoverlapping vintages of the 5-year ACS estimates of population and housing attributes starting in 2010 shown by the corresponding census tract vintage. Also includes the most recent release annually.

King County, Washington census tracts with nonoverlapping vintages of the 5-year American Community Survey (ACS) estimates starting in 2010. Vintage identified in the "ACS Vintage" field.

The census tract boundaries match the vintage of the ACS data (currently 2010 and 2020) so please note the geographic changes between the decades.

Tracts have been coded as being within the City of Seattle as well as assigned to neighborhood groups called "Community Reporting Areas". These areas were created after the 2000 census to provide geographically consistent neighborhoods through time for reporting U.S. Census Bureau data. This is not an attempt to identify neighborhood boundaries as defined by neighborhoods themselves.

Vintages : 2010, 2015, 2020, 2021, 2022, 2023

ACS Table(s) : B24021

Tables

Table 1

@usgov.city_of_seattle_occupation_by_median_earnings_in_the_p_fc2a74a5.table_1

904.95 kB
2,770 rows
82 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "geoid" BIGINT,
  "tract_name" VARCHAR,
  "median_earnings_of_total_full_time_year_round_civilian_3df73b3c" BIGINT  -- Median Earnings Of Total Full-Time Year-Round Civilian Employed Population 16 Years And Over With Earnings,
  "median_earnings_of_total_full_time_year_round_civilian_dd49c0eb" BIGINT  -- Median Earnings Of Total Full-Time Year-Round Civilian Employed Population 16 Years And Over With Earnings - Margin Of Error,
  "median_earnings_of_all_management_business_science_and_f4dab244" DOUBLE  -- Median Earnings Of All Management, Business, Science, And Arts Occupations,
  "median_earnings_of_all_management_business_science_and_08c721bf" DOUBLE  -- Median Earnings Of All Management, Business, Science, And Arts Occupations - Margin Of Error,
  "median_earnings_of_all_management_business_and_financi_3c77a15e" DOUBLE  -- Median Earnings Of All Management, Business, And Financial Occupations,
  "median_earnings_of_all_management_business_and_financi_1fed49cb" DOUBLE  -- Median Earnings Of All Management, Business, And Financial Occupations - Margin Of Error,
  "median_earnings_of_management_occupations" DOUBLE,
  "median_earnings_of_management_occupations_margin_of_error" DOUBLE  -- Median Earnings Of Management Occupations - Margin Of Error,
  "median_earnings_of_business_and_financial_operations_o_84256e87" DOUBLE  -- Median Earnings Of Business And Financial Operations Occupations,
  "median_earnings_of_business_and_financial_operations_o_444728fa" DOUBLE  -- Median Earnings Of Business And Financial Operations Occupations - Margin Of Error,
  "median_earnings_of_all_computer_engineering_and_scienc_815c5a88" DOUBLE  -- Median Earnings Of All Computer, Engineering, And Science Occupations,
  "median_earnings_of_all_computer_engineering_and_scienc_3b6cce95" DOUBLE  -- Median Earnings Of All Computer, Engineering, And Science Occupations - Margin Of Error,
  "median_earnings_of_computer_and_mathematical_occupations" DOUBLE,
  "median_earnings_of_computer_and_mathematical_occupatio_65d62b86" DOUBLE  -- Median Earnings Of Computer And Mathematical Occupations - Margin Of Error,
  "median_earnings_of_architecture_and_engineering_occupations" DOUBLE,
  "median_earnings_of_architecture_and_engineering_occupa_a938e25e" DOUBLE  -- Median Earnings Of Architecture And Engineering Occupations - Margin Of Error,
  "median_earnings_of_life_physical_and_social_science_occupations" DOUBLE  -- Median Earnings Of Life, Physical, And Social Science Occupations,
  "median_earnings_of_life_physical_and_social_science_oc_fd394906" DOUBLE  -- Median Earnings Of Life, Physical, And Social Science Occupations - Margin Of Error,
  "median_earnings_of_all_education_legal_community_servi_b843866e" DOUBLE  -- Median Earnings Of All Education, Legal, Community Service, Arts, And Media Occupations,
  "median_earnings_of_all_education_legal_community_servi_0ca2f394" DOUBLE  -- Median Earnings Of All Education, Legal, Community Service, Arts, And Media Occupations - Margin Of Error,
  "median_earnings_of_community_and_social_service_occupations" DOUBLE,
  "median_earnings_of_community_and_social_service_occupa_327f012b" DOUBLE  -- Median Earnings Of Community And Social Service Occupations - Margin Of Error,
  "median_earnings_of_legal_occupations" DOUBLE,
  "median_earnings_of_legal_occupations_margin_of_error" DOUBLE  -- Median Earnings Of Legal Occupations - Margin Of Error,
  "median_earnings_of_educational_instruction_and_library_0bcc8f4d" DOUBLE  -- Median Earnings Of Educational Instruction, And Library Occupations,
  "median_earnings_of_educational_instruction_and_library_70ee77cd" DOUBLE  -- Median Earnings Of Educational Instruction, And Library Occupations - Margin Of Error,
  "median_earnings_of_arts_design_entertainment_sports_an_5d1145e3" DOUBLE  -- Median Earnings Of Arts, Design, Entertainment, Sports, And Media Occupations,
  "median_earnings_of_arts_design_entertainment_sports_an_58f29857" DOUBLE  -- Median Earnings Of Arts, Design, Entertainment, Sports, And Media Occupations - Margin Of Error,
  "median_earnings_of_all_healthcare_practitioners_and_te_147ce9f8" DOUBLE  -- Median Earnings Of All Healthcare Practitioners And Technical Occupations,
  "median_earnings_of_all_healthcare_practitioners_and_te_fc8e37f3" DOUBLE  -- Median Earnings Of All Healthcare Practitioners And Technical Occupations - Margin Of Error,
  "median_earnings_of_health_diagnosing_and_treating_prac_9e215bdb" DOUBLE  -- Median Earnings Of Health Diagnosing And Treating Practitioners And Other Technical Occupations,
  "median_earnings_of_health_diagnosing_and_treating_prac_2b408262" DOUBLE  -- Median Earnings Of Health Diagnosing And Treating Practitioners And Other Technical Occupations - Margin Of Error,
  "median_earnings_of_health_technologists_and_technician_8e997259" DOUBLE  -- Median Earnings Of Health Technologists And Technicians Occupations,
  "median_earnings_of_health_technologists_and_technician_c25c9ddd" DOUBLE  -- Median Earnings Of Health Technologists And Technicians Occupations - Margin Of Error,
  "median_earnings_of_all_service_occupations" DOUBLE,
  "median_earnings_of_all_service_occupations_margin_of_error" DOUBLE  -- Median Earnings Of All Service Occupations - Margin Of Error,
  "median_earnings_of_healthcare_support_occupations" DOUBLE,
  "median_earnings_of_healthcare_support_occupations_marg_e60c84c8" DOUBLE  -- Median Earnings Of Healthcare Support Occupations - Margin Of Error,
  "median_earnings_of_all_protective_service_occupations" DOUBLE,
  "median_earnings_of_all_protective_service_occupations__cbc55125" DOUBLE  -- Median Earnings Of All Protective Service Occupations - Margin Of Error,
  "median_earnings_of_fire_fighting_and_prevention_and_ot_1ced14cd" DOUBLE  -- Median Earnings Of Fire Fighting And Prevention, And Other Protective Service Workers Including Supervisors,
  "median_earnings_of_fire_fighting_and_prevention_and_ot_c77348fa" DOUBLE  -- Median Earnings Of Fire Fighting And Prevention, And Other Protective Service Workers Including Supervisors - Margin Of Error,
  "median_earnings_of_law_enforcement_workers_including_s_8088a0a3" DOUBLE  -- Median Earnings Of Law Enforcement Workers Including Supervisors,
  "median_earnings_of_law_enforcement_workers_including_s_8922b425" DOUBLE  -- Median Earnings Of Law Enforcement Workers Including Supervisors - Margin Of Error,
  "median_earnings_of_food_preparation_and_serving_relate_a3d6ae0f" DOUBLE  -- Median Earnings Of Food Preparation And Serving Related Occupations,
  "median_earnings_of_food_preparation_and_serving_relate_641c8e7c" DOUBLE  -- Median Earnings Of Food Preparation And Serving Related Occupations - Margin Of Error,
  "median_earnings_of_building_and_grounds_cleaning_and_m_1de43671" DOUBLE  -- Median Earnings Of Building And Grounds Cleaning And Maintenance Occupations,
  "median_earnings_of_building_and_grounds_cleaning_and_m_efcf4734" DOUBLE  -- Median Earnings Of Building And Grounds Cleaning And Maintenance Occupations - Margin Of Error,
  "median_earnings_of_personal_care_and_service_occupations" DOUBLE,
  "median_earnings_of_personal_care_and_service_occupatio_bc0afee3" DOUBLE  -- Median Earnings Of Personal Care And Service Occupations - Margin Of Error,
  "median_earnings_of_all_sales_and_office_occupations" DOUBLE,
  "median_earnings_of_all_sales_and_office_occupations_ma_3691f395" DOUBLE  -- Median Earnings Of All Sales And Office Occupations - Margin Of Error,
  "median_earnings_of_sales_and_related_occupations" DOUBLE,
  "median_earnings_of_sales_and_related_occupations_margi_60512049" DOUBLE  -- Median Earnings Of Sales And Related Occupations - Margin Of Error,
  "median_earnings_of_office_and_administrative_support_o_f1bfc561" DOUBLE  -- Median Earnings Of Office And Administrative Support Occupations,
  "median_earnings_of_office_and_administrative_support_o_e0d8b474" DOUBLE  -- Median Earnings Of Office And Administrative Support Occupations - Margin Of Error,
  "median_earnings_of_all_natural_resources_construction__b052515d" DOUBLE  -- Median Earnings Of All Natural Resources, Construction, And Maintenance Occupations,
  "median_earnings_of_all_natural_resources_construction__c2b0add1" DOUBLE  -- Median Earnings Of All Natural Resources, Construction, And Maintenance Occupations - Margin Of Error,
  "median_earnings_of_farming_fishing_and_forestry_occupations" DOUBLE  -- Median Earnings Of Farming, Fishing, And Forestry Occupations,
  "median_earnings_of_farming_fishing_and_forestry_occupa_3609cb75" DOUBLE  -- Median Earnings Of Farming, Fishing, And Forestry Occupations - Margin Of Error,
  "median_earnings_of_construction_and_extraction_occupations" DOUBLE,
  "median_earnings_of_construction_and_extraction_occupat_0831dbcd" DOUBLE  -- Median Earnings Of Construction And Extraction Occupations - Margin Of Error,
  "median_earnings_of_installation_maintenance_and_repair_00e87868" DOUBLE  -- Median Earnings Of Installation, Maintenance, And Repair Occupations,
  "median_earnings_of_installation_maintenance_and_repair_9e75f8fb" DOUBLE  -- Median Earnings Of Installation, Maintenance, And Repair Occupations - Margin Of Error,
  "median_earnings_of_all_production_transportation_and_m_3d915446" DOUBLE  -- Median Earnings Of All Production, Transportation, And Material Moving Occupations,
  "median_earnings_of_all_production_transportation_and_m_fa7c943d" DOUBLE  -- Median Earnings Of All Production, Transportation, And Material Moving Occupations - Margin Of Error,
  "median_earnings_of_production_occupations" DOUBLE,
  "median_earnings_of_production_occupations_margin_of_error" DOUBLE  -- Median Earnings Of Production Occupations - Margin Of Error,
  "median_earnings_of_transportation_occupations" DOUBLE,
  "median_earnings_of_transportation_occupations_margin_of_error" DOUBLE  -- Median Earnings Of Transportation Occupations - Margin Of Error,
  "median_earnings_of_material_moving_occupations" DOUBLE,
  "median_earnings_of_material_moving_occupations_margin_of_error" DOUBLE  -- Median Earnings Of Material Moving Occupations - Margin Of Error,
  "acs_vintage" VARCHAR,
  "jurisdiction" VARCHAR,
  "community_reporting_area_id" DOUBLE,
  "community_reporting_area_group" DOUBLE,
  "community_reporting_area_name" VARCHAR,
  "community_reporting_area_neighborhoods" VARCHAR,
  "tract_label" DOUBLE
);