Money Income of Families--Median Income by Race and Hispanic Origin (Statistical Abstract 2008 Table 0674)

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. Includes other races not shown separately.
2. 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.
3. Data represent White alone, which refers to people who reported White and did not report any other race category.
4. Prior to 1967, data are for Black and other races.
5. Data represent Black alone, which refers to people who reported Black and did not report any other race category.
6. Data represent Asian alone, which refers to people who reported Asian and did not report any other race category.
7. People of Hispanic origin may be of any race.
8. Data represents White alone, not Hispanic, which refers to people who reported White, not Hispanic
   and did not report any other race category.
9. Data based on 1940 census population controls.
10. Data reflect implementation of expanded income questions to show wage and salary, farm self-
    employment, nonfarm self-employment, and all other nonearned income separately.
11. Data reflect implementation of 1950 census population controls.
12. Data reflect implementation of first hotdeck procedure to impute missing income entries (all income
    data imputed if any missing). Data also reflect introduction of 1960 census-based sample design.
13. Data reflect full implementation of 1960 census-based sample design and population controls.
14. Data reflect implementation of new procedures to impute missing data only.
15. Questionnaire expanded to ask eight income questions.
16. Data reflect implementation of a new March CPS processing system.
17. Data reflect introduction of 1970 census-based sample design and population controls.
18. Data reflect full implementation of 1970 census-based sample design.
19. Data reflect implementation of a new March CPS processing system. Questionnaire expanded to ask
    eleven income questions.
20. Some of these estimates were derived using Pareto interpolation and may differ from published data
    which were derived using linear interpolation.
21. First year medians were derived using both Pareto and linear interpolation. Before this year, all medians
    were derived using linear interpolation.
22. Data reflect implementation of 1980 census population controls. Questionnaire expanded to show 27
    possible values from 51 possible sources of income.
23. Data reflect implementation of Hispanic population weighting controls and introduction of 1980 census-
    based sample design.
24. Recording of amounts for earnings from longest job were increased to $299,999. Data reflect full
    implementation of 1980 census-based sample design.
25. Data reflect implementation of 1990 census population controls.
26. 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.
27. Data reflect introduction of 1990 census-based sample design.
28. Data reflect full implementation of the 1990 census-based sample design and metropolitan definitions,
    7,000 hosehold sample reduction, and revised race edits.
29. Implementation of Census 2000-based population controls.
30. Implementation of 28,000 household sample expansion.
31. 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.
Families 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: [129, 66]

0674

2008