People and Families With Alternative Definitions of Income Below the Three-Parameter Poverty Thresholds, by Selected Characteristics: 2004 (Statistical Abstract 2008 Table 0695)

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. Money income concept includes all money income received by individuals who are 15 years or older.
   It consists of income before deductions for taxes and other expenses and does not include lump-sum
   payments or capital gains. It also does not include the value of noncash benefits such as food stamps. This
   income concept is the basis for the official U.S. poverty measure.
2. Market income concept includes money income except government cash transfers; includes imputed
   realized capital gains and losses; includes imputed rate of return on home equity; and subtracts imputed
   work expenses.
3. Post-Social insurance income concept includes money income except government means-tested cash
   transfers; includes imputed realized capital gains and losses; includes imputed rate of return on home
   equity; and subtracts imputed work expenses.
4. Disposable income concept includes money income; includes the value of noncash transfers (food
   stamps, public or subsidized housing, and free or reduced-price school lunches); includes imputed realized
   capital gains and losses; includes imputed rate of return on home equity; and subtracts imputed work
   expenses, federal payroll taxes, federal and state income taxes, and property taxes on owner-occupied
   homes.
5. Data for American Indians and Alaska Natives, and Asian, Native Hawaiian and Other Pacific
   Islanders are not shown separately.
6. White alone refers to people who reported White and did not report any other race category.

1. Black alone refers to people who reported Black and did not report any other race category.
2. Asian alone refers to people who reported Asian and did not report any other race category.
3. Persons of Hispanic origin may be of any race.

[Counts of people in thousands—290,605 represents 290,605,000. Poverty rates in percentages. People and families as of March of the following year]

table: [123, 6]

0695

2008