mydata-iowa-gov/annual-personal-income-for-state-of-iowa-by-county-st2k-2ti2
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 4 months ago
Indexed 26 days ago

Annual Personal Income for State of Iowa by County

This dataset provides annual personal income estimates for State of Iowa counties produced by the U.S. Bureau of Economic Analysis beginning in 1997. Data includes the following estimates: personal income and per capita personal income.

Personal income is defined as the sum of wages and salaries, supplements to wages and salaries, proprietors’ income, dividends, interest, and rent, and personal current transfer receipts, less contributions for government social insurance. Personal income is the income received by, or on behalf of all persons residing in the Iowa county, regardless of the duration of residence, except for foreign nationals employed by their home governments in Iowa. Per capita personal income is personal income divided by the Census Bureau’s annual midyear (July 1) population estimates for the county.

More terms and definitions are available on https://apps.bea.gov/regional/definitions/.

Less

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/annual-personal-income-for-state-of-iowa-by-county-st2k-2ti2\".\"annual_personal_income_for_state_of_iowa_by_county\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • annual_personal_income_for_state_of_iowa_by_county
     
     
     
     
     
Upstream Metadata