Iowa Population 16 Years and Over by Sex and Earnings in Past 12 Months (ACS 5-Year Estimates)

This dataset provides Iowa population 16 years and over by sex and earnings in past 12 months 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 B20001.

Sex categories: Male, Female, and Both

Earnings in Past 12 Months. Categories include: 01 - $1 to $2499 or loss, 02 - $2500 to $4999, 03 - $5000 to $7499, 04 - $7500 to $9999, 05 - $10000 to $12499, 06 - $12500 to $14999, 07 - $15000 to $17499, 08 - $17500 to $19999, 09 - $20000 to $22499, 10 - $22500 to $24999, 11 - $25000 to $29999, 12 - $30000 to $34999, 13 - $35000 to $39999, 14 - $40000 to $44999, 15 - $45000 to $49999, 16 - $50000 to $54999, 17 - $55000 to $64999, 18 - $65000 to $74999, 19 - $75000 to $99999, and 20 - $100000 or more.

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-population-16-years-and-over-by-sex-and-8r6p-4vrb\".\"iowa_population_16_years_and_over_by_sex_and\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.