Share of Aggregate Income Received by Each Fifth and Top 5 Percent of Households: 1967 to 2005 (Statistical Abstract 2008 Table 0675)

The Statistical Abstract files are distributed by the census department as excel files. These files have data mixed with notes and references, multiple tables per sheet, and worst of all the table headers aren’t easily matched to their rows and columns.
The excel files in this collection are unmolested copies of the census originals, with the following exceptions:

1. A few files had extraneous characters in the title. These were
   corrected to be consistent. A few files have a sheet of crufty
   gibberish in the first slot. The sheet order was shuffled but no
   data were changed.

1. The first four files have been restructured to allow full
   comprehension of the table. If you’d like to help clean up the data
   follow along with what’s there.

The CSV files, and the payload portions of the yaml files, have not been processed beyond extracting an array (excel sheets) of 2-D arrays (each sheet’s cells).

Some metadata (title, footnotes, symbols, and sources) has been copied (without molesting the imported stream) into the appropriate slot in this schema. This metadata identification was purposefully done to be strict and simple, and the original files are somewhat irregular, so it’s possible that some metadata fields were missed

These files have been tagged by hand and received cursory inspection, but you’re advised to check against the originals before you go lauching any Mars rovers.

Notes (pg 2)

1. Data reflect implementation of a new March CPS processing system.
2. Data reflect introduction of 1970 census-based sample design and population controls.
3. Data reflect full implementation of 1970 census-based sample design.
4. Data reflect implementation of a new March CPS processing system. Questionnaire expanded to ask 11
   income questions.
5. Some of these estimates were derived using Pareto interpolation and may differ from published data
   which were derived using linear interpolation.
6. First year medians were derived using both Pareto and linear interpolation. Before this year, all medians
   were derived using linear interpolation.
7. Data reflect implementation of 1980 census population controls. Questionnaire expanded to show 27
   possible values from 51 possible sources of income.
8. Data reflect implementation of Hispanic population weighting controls and introduction of 1980 census-
   based sample design.
9. Recording of amounts for earnings from longest job were increased to $299,999. Data reflect full
   implementation of 1980 census-based sample design.
10. Data reflect implementation of 1990 census population controls.
11. Data collection method changed from paper and pencil to computer-assisted interviewing. In addition,
    the March 1994 income supplement was revised to allow for the coding of different income amounts on
    selected questionnaire items. Child support and alimony limits decreased to $49,999. Limits increased in
    the following categories: earnings to $999,999; social security to $49,999; supplemental security income
    and public assistance income to $24,000; and veterans’ benefits to $99,999.
12. Data reflect introduction of 1990 census-based sample design.
13. Data reflect full implementation of the 1990 census-based sample design and metropolitan definitions,
    7,000 hosehold sample reduction, and revised race edits.
14. Implementation of Census 2000-based population controls.
15. Implementation of 28,000 household sample expansion.
16. Data have been revised to reflect a correction to the weights in the 2005 ASEC.

[Constant dollars based on Consumer Price Index Research Series Using Current Methods (CPI-U-RS) deflator.
Households as of March of the following year.
Based on Current Population Survey; see text, sections 1 and 13, and Appendix III.
For methodology information, see
http://www.census.gov/hhes/www/income/p60_231sa.pdf
For definition of median, see Guide to Tabular Presentation]

table: [47, 13]

0675

2008