Iowa Median Earnings in Past 12 Months for the Civilian Employed Population 16 Years and Over by Occupation (ACS 5-Year Estimates)
mydata.iowa.gov | Last Updated 30 Aug 2023This dataset provides median earnings in past 12 months for civilian employed population 16 year and over by occupation for State of Iowa, individual Iowa counties, Iowa places and census tracts within Iowa. Data is from the American Community Survey, Five Year Estimates, Table B24011. Data is available on the following occupations: Management occupations, Business and financial operations occupations, Computer and mathematical occupations, Architecture and engineering occupations, Life physical and social science occupations, Community and social service occupations, Legal occupations, Education training and library occupations, Arts design entertainment sports and media occupations, Health diagnosing and treating practitioners and other technical occupations, Health technologists and technicians, Healthcare support occupations, Fire fighting and prevention and other protective service workers including supervisors, Law enforcement workers including supervisors, Food preparation and serving related occupations, Building and grounds cleaning and maintenance occupations, Personal care and service occupations, Sales and related occupations, Office and administrative support occupations, Farming fishing and forestry occupations, Construction and extraction occupations, Installation maintenance and repair occupations, Production occupations, Transportation occupations, and Material moving occupations. This occupations role up into occupational groups and categories.
This dataset has the following 13 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Geography Id | geography_id | text | Specific geography id used by the U.S. Census for the state, county, place or census tract associated with the record. | 1600000US1907660 1600000US1910225 1600000US1906940 1600000US1907480 1600000US1908200 view top 100 |
Type | type | text | Specifies the type of geography associated with the record. Categories include: state, county, place and tract. | place tract county state view top 100 |
Name | name | text | Name of geography associated with the record. | Coin, Iowa Cresco, Iowa Clearfield, Iowa Coggon, Iowa Corley CDP, Iowa view top 100 |
Variable | variable | text | Variable name identified by the US Census Bureau. | B24011_001E B24011_002E B24011_003E B24011_004E B24011_005E view top 100 |
Variable Description | variable_description | text | Describes the characteristics associated with the variable. | Management business science and arts occupations Management business science and arts occupations - Computer engineering and science occupations Management business science and arts occupations - Computer engineering and science occupations - Architecture and engineering occupations Management business science and arts occupations - Computer engineering and science occupations - Computer and mathematical occupations Management business science and arts occupations - Computer engineering and science occupations - Life physical and social science occupations view top 100 |
Data Collection Period | data_collection_period | text | The data collection period reflects the years associated with the 60 month data collection period. | 2017-2021 2016-2020 2010-2014 2008-2012 2009-2013 view top 100 |
Data Collection End Date | date | calendar_date | The date when the 60 month data collection period concluded. | 2021-12-31T00:00:00.000 2020-12-31T00:00:00.000 2014-12-31T00:00:00.000 2012-12-31T00:00:00.000 2013-12-31T00:00:00.000 view top 100 |
Occupation Category | occupation_category | text | Occupation categories are broad occupational groupings and include the following: Total, Management business science and arts occupations, Service occupations, Sales and office occupations, Natural resources construction and maintenance occupations, and Production transportation and material moving occupations. | Management business science and arts occupations Service occupations Natural resources construction and maintenance occupations Production transportation and material moving occupations Sales and office occupations view top 100 |
Occupation Group | occupation_group | text | Occupation groups are subcategories within individual occupation categories and include the following: Management business and financial occupations, Computer engineering and science occupations, Education legal community service arts and media occupations, Healthcare practitioners and technical occupations, Healthcare support occupations, Protective service occupations, Food preparation and serving related occupations, Building and grounds cleaning and maintenance occupations, Personal care and service occupations, Sales and related occupations, Office and administrative support occupations, Farming fishing and forestry occupations, Construction and extraction occupations, Installation maintenance and repair occupations, Production occupations, Transportation occupations, and Material moving occupations. Those with NA are records reflecting median earnings for total population or occupation category. | NA Education legal community service arts and media occupations Computer engineering and science occupations Management business and financial occupations Protective service occupations view top 100 |
Occupation | occupation | text | Occupations are subcategories within occupation groups and include the following: Management occupations, Business and financial operations occupations, Computer and mathematical occupations, Architecture and engineering occupations, Life physical and social science occupations, Community and social service occupations, Legal occupations, Education training and library occupations, Arts design entertainment sports and media occupations, Health diagnosing and treating practitioners and other technical occupations, Health technologists and technicians, Healthcare support occupations, Fire fighting and prevention and other protective service workers including supervisors, Law enforcement workers including supervisors, Food preparation and serving related occupations, Building and grounds cleaning and maintenance occupations, Personal care and service occupations, Sales and related occupations, Office and administrative support occupations, Farming fishing and forestry occupations, Construction and extraction occupations, Installation maintenance and repair occupations, Production occupations, Transportation occupations, and Material moving occupations. Those with NA are records reflecting median earnings for total population, occupation category, or occupation group. | NA Arts design entertainment sports and media occupations Building and grounds cleaning and maintenance occupations Business and financial operations occupations Community and social service occupations view top 100 |
Median Earnings | value | number | Median earnings in the past 12 months (in inflation-adjusted dollars) associated with geography, variable and data collection period. | -666666666.0 2499.0 31250.0 41250.0 36250.0 view top 100 |
Location | location | point | Primary point for the specific geography. | {"coordinates":[-91.96744,41.006384],"type":"Point"} {"coordinates":[-94.560049,41.290006],"type":"Point"} {"coordinates":[-95.8992858,41.2072955],"type":"Point"} {"coordinates":[-95.934367,43.244319],"type":"Point"} {"coordinates":[-95.950704,42.204757],"type":"Point"} view top 100 |
Row ID | row_id | text | Unique Row Identifier | 1400000US19045001000-2018-B24011_007E 1400000US19079960200-2019-B24011_018E 1400000US19153000103-2015-B24011_030E 1600000US1929775-2021-B24011_013E 1600000US1947370-2021-B24011_005E view top 100 |