Money Income of Households--Median Income in Current and Constant (2005) (Statistical Abstract 2008 Table 0669)

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.

   The tables that were changed:

   0166 0257 0362 0429 0445 0446 0459 0461 0462 0464 0465 0466 0467 0469 0479 0480 0481 0482 0483 0484 0485 0486 0487 0559 0628 0629 1144 1227 1231

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. Includes other races not shown separately.
2. Beginning with 2002, data represents White alone, which refers to people who reported White and did not report any other race category.

1. Beginning with 2002, data represents Black alone, which refers to people who reported Black and did not report any other race category.

1. The 2003 Current Population Survey (CPS) allowed respondents to choose more than one race. For 2002, data represent persons who selected this race group only and persons reporting this race group and at least one other race. The CPS in prior years allowed respondents to report only one race group. See also comments on race in the text for Section 1.
2. Beginning with 2002, data represents Asian alone, which refers to people who reported Asian and did not report any other race category.

1. People of Hispanic origin may be of any race.
2. Data represents White alone, not Hispanic, which refers to people who reported White, not Hispanic and did not report any other race category.
3. Data reflect implementation of a new March CPS processing system.
4. Data reflect introduction of 1970 census-based sample design and population controls.
5. Data reflect full implementation of 1970 census-based sample design.
6. Data reflect implementation of a new March CPS processing system. Questionnaire expanded to ask 11 income questions.
7. Some of these estimates were derived using Pareto interpolation and may differ from published data which were derived using linear interpolation.
8. First year medians were derived using both Pareto and linear interpolation. Before this year, all medians were derived using linear interpolation.
9. Data reflect implementation of 1980 census population controls. Questionnaire expanded to show 27 possible values from 51 possible sources of income.
10. Data reflect implementation of Hispanic population weighting controls and introduction of 1980 census- based sample design.
11. Recording of amounts for earnings from longest job were increased to $299,999. Data reflect full implementation of 1980 census-based sample design.
12. Data reflect implementation of 1990 census population controls.
13. 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.
14. Data reflect introduction of 1990 census-based sample design.
15. Data reflect full implementation of the 1990 census-based sample design and metropolitan definitions, 7,000 hosehold sample reduction, and revised race edits.
16. Implementation of Census 2000-based population controls.
17. Implementation of 28,000 household sample expansion.
18. 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: [86, 61]

Notes (pg 2)

• (FN) Footnote.
• (NA) Not available.

0669

2008