OCCUPATION BY MEDIAN EARNINGS IN THE PAST 12 MONTHS (B24021) by US Government | Finance and Economics

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

883.74 KB
2770 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_dd49c0eb" BIGINT,
  "median_earnings_of_all_management_business_science_and_f4dab244" DOUBLE,
  "median_earnings_of_all_management_business_science_and_08c721bf" DOUBLE,
  "median_earnings_of_all_management_business_and_financi_3c77a15e" DOUBLE,
  "median_earnings_of_all_management_business_and_financi_1fed49cb" DOUBLE,
  "median_earnings_of_management_occupations" DOUBLE,
  "median_earnings_of_management_occupations_margin_of_error" DOUBLE,
  "median_earnings_of_business_and_financial_operations_o_84256e87" DOUBLE,
  "median_earnings_of_business_and_financial_operations_o_444728fa" DOUBLE,
  "median_earnings_of_all_computer_engineering_and_scienc_815c5a88" DOUBLE,
  "median_earnings_of_all_computer_engineering_and_scienc_3b6cce95" DOUBLE,
  "median_earnings_of_computer_and_mathematical_occupations" DOUBLE,
  "median_earnings_of_computer_and_mathematical_occupatio_65d62b86" DOUBLE,
  "median_earnings_of_architecture_and_engineering_occupations" DOUBLE,
  "median_earnings_of_architecture_and_engineering_occupa_a938e25e" DOUBLE,
  "median_earnings_of_life_physical_and_social_science_occupations" DOUBLE,
  "median_earnings_of_life_physical_and_social_science_oc_fd394906" DOUBLE,
  "median_earnings_of_all_education_legal_community_servi_b843866e" DOUBLE,
  "median_earnings_of_all_education_legal_community_servi_0ca2f394" DOUBLE,
  "median_earnings_of_community_and_social_service_occupations" DOUBLE,
  "median_earnings_of_community_and_social_service_occupa_327f012b" DOUBLE,
  "median_earnings_of_legal_occupations" DOUBLE,
  "median_earnings_of_legal_occupations_margin_of_error" DOUBLE,
  "median_earnings_of_educational_instruction_and_library_0bcc8f4d" DOUBLE,
  "median_earnings_of_educational_instruction_and_library_70ee77cd" DOUBLE,
  "median_earnings_of_arts_design_entertainment_sports_an_5d1145e3" DOUBLE,
  "median_earnings_of_arts_design_entertainment_sports_an_58f29857" DOUBLE,
  "median_earnings_of_all_healthcare_practitioners_and_te_147ce9f8" DOUBLE,
  "median_earnings_of_all_healthcare_practitioners_and_te_fc8e37f3" DOUBLE,
  "median_earnings_of_health_diagnosing_and_treating_prac_9e215bdb" DOUBLE,
  "median_earnings_of_health_diagnosing_and_treating_prac_2b408262" DOUBLE,
  "median_earnings_of_health_technologists_and_technician_8e997259" DOUBLE,
  "median_earnings_of_health_technologists_and_technician_c25c9ddd" DOUBLE,
  "median_earnings_of_all_service_occupations" DOUBLE,
  "median_earnings_of_all_service_occupations_margin_of_error" DOUBLE,
  "median_earnings_of_healthcare_support_occupations" DOUBLE,
  "median_earnings_of_healthcare_support_occupations_marg_e60c84c8" DOUBLE,
  "median_earnings_of_all_protective_service_occupations" DOUBLE,
  "median_earnings_of_all_protective_service_occupations__cbc55125" DOUBLE,
  "median_earnings_of_fire_fighting_and_prevention_and_ot_1ced14cd" DOUBLE,
  "median_earnings_of_fire_fighting_and_prevention_and_ot_c77348fa" DOUBLE,
  "median_earnings_of_law_enforcement_workers_including_s_8088a0a3" DOUBLE,
  "median_earnings_of_law_enforcement_workers_including_s_8922b425" DOUBLE,
  "median_earnings_of_food_preparation_and_serving_relate_a3d6ae0f" DOUBLE,
  "median_earnings_of_food_preparation_and_serving_relate_641c8e7c" DOUBLE,
  "median_earnings_of_building_and_grounds_cleaning_and_m_1de43671" DOUBLE,
  "median_earnings_of_building_and_grounds_cleaning_and_m_efcf4734" DOUBLE,
  "median_earnings_of_personal_care_and_service_occupations" DOUBLE,
  "median_earnings_of_personal_care_and_service_occupatio_bc0afee3" DOUBLE,
  "median_earnings_of_all_sales_and_office_occupations" DOUBLE,
  "median_earnings_of_all_sales_and_office_occupations_ma_3691f395" DOUBLE,
  "median_earnings_of_sales_and_related_occupations" DOUBLE,
  "median_earnings_of_sales_and_related_occupations_margi_60512049" DOUBLE,
  "median_earnings_of_office_and_administrative_support_o_f1bfc561" DOUBLE,
  "median_earnings_of_office_and_administrative_support_o_e0d8b474" DOUBLE,
  "median_earnings_of_all_natural_resources_construction__b052515d" DOUBLE,
  "median_earnings_of_all_natural_resources_construction__c2b0add1" DOUBLE,
  "median_earnings_of_farming_fishing_and_forestry_occupations" DOUBLE,
  "median_earnings_of_farming_fishing_and_forestry_occupa_3609cb75" DOUBLE,
  "median_earnings_of_construction_and_extraction_occupations" DOUBLE,
  "median_earnings_of_construction_and_extraction_occupat_0831dbcd" DOUBLE,
  "median_earnings_of_installation_maintenance_and_repair_00e87868" DOUBLE,
  "median_earnings_of_installation_maintenance_and_repair_9e75f8fb" DOUBLE,
  "median_earnings_of_all_production_transportation_and_m_3d915446" DOUBLE,
  "median_earnings_of_all_production_transportation_and_m_fa7c943d" DOUBLE,
  "median_earnings_of_production_occupations" DOUBLE,
  "median_earnings_of_production_occupations_margin_of_error" DOUBLE,
  "median_earnings_of_transportation_occupations" DOUBLE,
  "median_earnings_of_transportation_occupations_margin_of_error" DOUBLE,
  "median_earnings_of_material_moving_occupations" DOUBLE,
  "median_earnings_of_material_moving_occupations_margin_of_error" DOUBLE,
  "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
);