mydata-iowa-gov/annual-personal-income-for-state-of-iowa-dxzz-fkf8
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 4 months ago
Indexed 1 month ago

Annual Personal Income for State of Iowa

This dataset provides annual personal income estimates for State of Iowa produced by the U.S. Bureau of Economic Analysis beginning in 1997. Data includes the following estimates: personal income, per capita personal income, wages and salaries, supplements to wages and salaries, private nonfarm earnings, compensation of employees, average compensation per job, and private nonfarm compensation.

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 for Iowa is the income received by, or on behalf of all persons residing in Iowa, 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.

Wages and salaries is defined as the remuneration receivable by employees (including corporate officers) from employers for the provision of labor services. It includes commissions, tips, and bonuses; employee gains from exercising stock options; and pay-in-kind. Judicial fees paid to jurors and witnesses are classified as wages and salaries. Wages and salaries are measured before deductions, such as social security contributions, union dues, and voluntary employee contributions to defined contribution pension plans.

Supplements to wages and salaries consists of employer contributions for government social insurance and employer contributions for employee pension and insurance funds.

Private nonfarm earnings is the sum of wages and salaries, supplements to wages and salaries, and nonfarm proprietors' income, excluding farm and government.

Compensation to employees is the total remuneration, both monetary and in kind, payable by employers to employees in return for their work during the period. It consists of wages and salaries and of supplements to wages and salaries. Compensation is presented on an accrual basis - that is, it reflects compensation liabilities incurred by the employer in a given period regardless of when the compensation is actually received by the employee.

Average compensation per job is compensation of employees divided by total full-time and part-time wage and salary employment.

Private nonfarm compensation is the sum of wages and salaries and supplements to wages and salaries, excluding farm and government.

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

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-dxzz-fkf8\".\"annual_personal_income_for_state_of_iowa\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • annual_personal_income_for_state_of_iowa
     
     
     
     
     
Upstream Metadata