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

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

Sex categories include Male and Female.

The dataset includes the following industries: Agriculture forestry fishing and hunting, Mining quarrying and oil and gas extraction, Construction, Manufacturing, Wholesale trade, Retail trade, Transportation and warehousing, Utilities, Information, Finance and insurance, Real estate and rental and leasing, Professional scientific and technical services, Management of companies and enterprises, Administrative and support and waste management services, Educational services, Health care and social assistance, Arts entertainment and recreation, Accommodation and food services, Other services except public administration, and Public administration. Some industries roll up into a broader industry group.

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-srfw-ivcu\".\"iowa_median_earnings_in_past_12_months_for_the\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.