STATE PERSONAL INCOME
CD-ROM USER GUIDE

OVERVIEW: The State Personal Income (SPI) CD-ROM contains state economic estimates from the U.S. Bureau of Economic Analysis' (BEA) Regional Economic Information System. SPI includes annual estimates of income by major source and per capita personal income as well as wage and salary disbursements, full and part-time employment, and wage and salary employment by Standard Industrial Classification code (SIC) for the entire United States, individual states, and specified regions. The data contained on the SPI CD-ROM for years 1929 and on are also available on the Internet from the Bureau of Economic Analysis at http://www.bea.doc.gov/bea/regional/spi/.

INSTRUCTIONS:

The State Personal Income CD-ROM contains two software programs to access the State Annual Tables; one program for each of two year groups, 1929-1957 and 1958-current. Under the File menu is a menu item that allows switching between the two year groups.

1. Select a Table
Click on the arrow at the right side of the Table menu. For an index of tables by type of estimate, click on Help on the top menu bar and then on Index of Tables. For detailed information about a specific table, select the table and then click on Documentation from the top menu bar to access a summary and the footnotes for that table. The following tables are available for selection:

SA05 Personal Income by Major Source and Earnings by Industry
The first section of SA05 presents summary statistics for a state: total personal income, population (annual Census Bureau estimate), and per capita personal income. The second section presents the derivation of personal income: earnings (e.g., wages and salaries, dividends, and interest) less deductions from earnings (e.g. contributions for social insurance). Since estimates are primarily based on the residents' place of work rather than place of residence, the data are adjusted for interstate commuters. The third section presents estimates of earnings by type of payment and by industry (Standard Industrial Classification two-digit level).

SA07 Wage and Salary Disbursements by Industry

This contains estimates of wage and salary disbursements for industries at the SIC two-digit-level.

SA25 Total Employment (full and part-time) by Industry
This table contains estimates of employment, which is measured as the average annual number of jobs (full-time plus part-time). The data are organized by type of payment (wage and salary or self-employment) and by industry (SIC two-digit level). The industry data reflect a combination of both types of payments. *Not available for years 1929-1957.

SA27 Wage and Salary Employment (full and part time) by Industry
Estimates of wage and salary employment by industry (SIC two-digit detail) are presented in this table. Employment is measured as the average annual number of jobs (full-time plus part-time). *Not available for years 1929-1957.

SA30 Regional Economic Profile
This table provides two summaries of general economic data for the specified region. The place of residence profile includes estimates of total personal income, population, and per capita personal income as well as a derivation of personal income. The place of work profile includes estimates of total earnings, total employment, and average earnings per job. *Not available for years 1929-1957.

SA35 Transfer Payments
The table contains estimates of transfer payments made by government or business to individuals and to nonprofit institutions serving individuals. Transfer payments are income payments to persons for which they do not render services in the current period. The table divides the payments to individuals into several groups, including retirement and disability insurance benefit payments, medical payments, income maintenance benefit payments, unemployment insurance benefit payments, and business payments (primarily personal injury liability payments). Payments to nonprofit institutions are divided into federal government payments, state and local government payments, and business payments (corporate gifts).

SA45 Farm Income and Expenses
This table includes detailed estimates of farm gross income and production expenses as well as a derivation of total farm labor and proprietors' income. The derivation includes several different measures of farm income, including realized net income (gross farm income less production expenses), total net income (realized net income modified to reflect current production through a change-in-inventory adjustment), farm proprietors' income (net income less the income of corporate farms), and total farm earnings (farm proprietors' income plus all farm wages and salaries). *Not available for years 1929-1957.

SA50 Personal Tax and Non-Tax Payments
This table provides estimates of disposable personal income as well as personal tax and non-tax payments (PTNT) to the government. PTNT, primarily taxes, fines, and fees, is subtracted from personal income to yield disposable income (income available to persons for spending and saving). PTNT is presented by level of government (federal, state, local), and by type of payment for each level.

BEARFACTS (BEA Regional FACT Sheets)
BEARFACTS are narrative summaries of data from SA05, Personal Income by Major Source and Earnings by Industry. The summaries are available in two versions, one that presents growth rates for the most recent year and one that presents the average annual growth rate for the most recent ten-year period. Each version has four sections:
  1. PER CAPITA PERSONAL INCOME (PCPI) presents PCPI for a state, its rank among the states, its size relative to the national average PCPI, and its growth rate.
  2. TOTAL PERSONAL INCOME (TPI) reflects TPI for a state, its rank among the states, its proportion of the national TPI total, and its growth rate.
  3. COMPONENTS OF TOTAL PERSONAL INCOME divides TPI into three broad components: Earnings (wages and salaries, other labor income, and proprietors' income, less personal contributions for social insurance); dividends, interest, and rent; and transfer payments. For each of these components, its percent of TPI and growth rate are presented.
  4. EARNINGS BY INDUSTRY presents the amount and growth rate of total earnings and identifies the largest, the slowest-growing, and the fastest-growing broad industry groups.

2. Select a Geographic Location
Click on the Select States button. Scroll through the list and select/highlight one or more places: the entire country, individual states, or regions. (For an explanation of regional divisions, click on Documentation on the top menu bar and then select BEA Regions). To choose more than one location, hold down the control (Ctrl) key while selecting/highlighting each area. After selecting the desired location(s), click the OK button.

3. Select a Time Period
Select the Years menu by clicking on the arrow on the right side of the menu. Highlight a preset range of years (all years, last 5 years, or last 10 years) or click on the Choose Selected Years button. In the year list, select an individual year or hold down the control key while selecting multiple years. Click on OK to continue.

4. Display Data
Select File from the top menu bar and then click on Display or click on the display arrow pointing to the right. Each display will include one selected geographic area. To move between areas, click on the right and left display arrows on the icon.

Use the Display One Line option to compare a single variable for all the geographic areas in the nation. While the table is displayed, select/highlight a line. Then either click on the icon of the U.S. map or select File from the top menu bar and then Display One Line. A new window will display the variable for all areas.

PRINTING:

Data tables can be printed by selecting File on the top menu bar and then choosing Print Active Window or Print Table for Selected Areas. Print Active Window will print the contents of the currently displayed or active window. Print Table for Selected Areas will print the selected table for all selected geographic areas. When printing a table, an option to include the table's footnotes is available. If an "invalid property value error" is displayed while printing, a font needs to be selected. Click on the Change Font button in the Print Settings window, and select a new font and font size.

DOWNLOADING:

Downloading is available for all of the data tables, with the exception of the BEARFACTS narratives. Place a disk in drive a:\. Select File from the top menu bar, then choose Export to File. A box will appear listing all the lines of data in the selected table. Select individual lines of data to be downloaded. For more than one line, hold down the control key while selecting. To download all lines, click on the ALL button. Once the selection has been made, click OK. A box will appear with download/export options:

  1. Record Format Options: To create a file for spreadsheet import, select one of the variable-length record options: variable-length space-delimited, variable-length comma-delimited, or variable-length tab-delimited. Most newer spreadsheet applications will recognize any of the listed delimiters. The fourth format option, fixed-length no delimiters, will require keying the data into another application manually.

  2. Inserting Extra Text Fields: The defaults for text fields are "Include a header record" and "Insert line titles." Choosing to insert a header is recommended. The header, appearing as the first row in the output file, contains labels for the column as well as years. Line titles, those from the table, will be displayed as separate columns in the spreadsheet. To change line title selections, click on the "Change selected line titles" button. "Insert area names" will label geographic areas on the output.

  3. Output Files Options: When "One output file for all areas" is selected, only a single output file will be created for all the data. When "One output file per state" is selected, an individual output file will be created for each state or region.

  4. Change output file button: When "One output file for all areas" is selected, it is necessary to specify a filename by clicking on the "Change output file" button. In the dialog box which appears, select the a:\ drive, then type in a filename. Click on OK to return to the downloading box. For a multiple file output, it is necessary to specify an output directory by clicking on the "Change output directory" button. In the dialog box, select the a:\ drive. With a multiple file output, filenames are constructed automatically. Click on OK to return to the downloading box. Click on the OK button to save the data.

  5. Miscellaneous: Unless the "Append to existing files" box is checked, the data will overwrite an existing file of the same name.

HELP:

Select Help from the top menu bar. Read Quick start for an overview, or select Contents or Search for detailed information on a specific topic.

EXIT:

Select File from the top menu bar, then select Exit to quit the database.


revised 10/17/02; last reviewed 02/06/2005


UWM Libraries Home * PantherCat

UWM Libraries Staff
page contact: Linda Brothen