This dataset provides quarterly personal income estimates for State of Iowa produced by the U.S. Bureau of Economic Analysis . Data includes the following estimates: personal income, per capita personal income, proprietors' income, farm proprietors' income, compensation of employees and private nonfarm earnings, compensation, and wages and salaries for wholesale trade. Personal income, proprietors' income, and farm proprietors' income available beginning 1997; per capita personal income available beginning 2010; and all other data beginning 1998. 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 midquarter population estimates. Proprietors' income is the current-production income (including income in kind) of sole proprietorships, partnerships, and tax-exempt cooperatives. Corporate directors' fees are included in proprietors' income. Proprietors' income includes the interest income received by financial partnerships and the net rental real estate income of those partnerships primarily engaged in the real estate business. Farm proprietors’ income as measured for personal income reflects returns from current production; it does not measure current cash flows. Sales out of inventories are included in current gross farm income, but they are excluded from net farm income because they represent income from a previous year’s production. 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. Private nonfarm earnings is the sum of wages and salaries, supplements to wages and salaries, and nonfarm proprietors' income, excluding farm and government. Private nonfarm wages and salaries is wages and salaries excluding farm and government. Wages and salaries is 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. More terms and definitions are available on https://apps.bea.gov/regional/definitions/.
This dataset has the following 8 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Row ID | row_id | text | Unique row identifier for the variable and time period | 19000_1997Q1_SQINC1-3_quarter 19000_1997Q1_SQINC4-10_quarter 19000_1997Q1_SQINC4-11_quarter 19000_1997Q1_SQINC4-12_quarter 19000_1997Q1_SQINC4-30_quarter view top 100 |
Table Code | table_code | text | Code for the quarterly series table: SQINC1, SQINC4, SQINC5N, SQINC6N, and SQINC7N | SQINC5N SQINC6N SQINC7N SQINC4 SQINC1 view top 100 |
Table Name | table_name | text | Name of the quarterly series table: Personal Income (SQINC1), Personal Income by Major Component (SQINC4), Personal Income by Major Component and Earnings by NAICS Industry (SQINC5N), Compensation of Employees by NAICS Industry (SQINC6N), and Wages and Salaries by NAICS Industry (SQINC7N) | Personal Income by Major Component and Earnings by NAICS Industry Compensation of Employees by NAICS Industry Wages and Salaries by NAICS Industry Personal Income by Major Component Personal Income view top 100 |
Variable Code | variable_code | text | Unique identifier for the variable reported, and year variable data first became available: SQINC1-1 (1997), SQINC1-3 (2010), SQINC4-30 (2010), SQINC4-70 (1997), SQINC4-71 (1997), SQINC5N-30 (2010), SQINC5N-600 (1998), SQINC5N-70 (1998), SQINC5N-71 (1998), SQINC6N-1 (1998), SQINC6N-600 (1998), and SQINC7N-600 (1998) | SQINC1-1 SQINC1-3 SQINC4-10 SQINC4-11 SQINC4-12 view top 100 |
Variable | variable | text | Description of the variable | Employer contributions for government social insurance Per capita personal income Personal income Employer contributions for employee pension and insurance funds Supplements to wages and salaries view top 100 |
Value | value | number | Value reported for the time period | 0.0 64157580.0 402528.0 57311.0 7508215.0 view top 100 |
Variable Unit | variable_unit | text | Units associated with the value reported | Thousands of dollars Millions of dollars Dollars view top 100 |
Date | date | calendar_date | Date the quarterly period ended that the reported value is for | 2023-12-31T00:00:00.000 2022-12-31T00:00:00.000 2023-03-31T00:00:00.000 2023-06-30T00:00:00.000 2023-09-30T00:00:00.000 view top 100 |