Iowa Median Earnings in Past 12 Months for the Civilian Employed Population 16 Years and Over by Sex and Occupation (ACS 5-Year Estimates)

This dataset provides median earnings in past 12 months for civilian employed population 16 years and over by sex and 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 B24012.

Sex categories included: Male, Female, and Both

Occupation categories included: 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.

Occupations are organized into broader occupation groups and categories.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"mydata-iowa-gov/iowa-median-earnings-in-past-12-months-for-the-2jg9-y5ct\".\"iowa_median_earnings_in_past_12_months_for_the\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.