Dataset

The Statistical Abstract files are distributed by the US Census Department as Microsoft Excel files. These files have data mixed with notes and references, multiple tables per sheet, and, worst of all, the table headers are not easily matched to their rows and columns.

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 (this is table 1140):

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

This dataset consists of a table of 87 rows and 13 columns.

Median value in thousands of constant 2004 dollars (14.2 represents $14,200). All dollar figures are adjusted to 2004 dollars using the “current methods” version of the consumer price index for all urban consumers published by U.S. Bureau of Labor Statistics. Families include one-person units; for definition of family, see text, Section 1, Population. Based on Survey of Consumer Finances; see Appendix III.

Footnotes

1. Includes other types of financial assets, not shown separately.
2. Checking, savings, and money market deposit accounts, money market mutual funds, and call accounts at brokerages.
3. Covers only those stocks and bonds that are directly held by families
   outside mutual funds, retirement accounts and other managed assets.
4. Excludes money market mutual funds and indirectly held mutual funds and includes
   all other types of directly held pooled investment funds, such as traditional open-ended and
   closed-end mutual funds, real estate investment trusts, and hedge funds.
5. The tax-deferred retirement accounts consist of IRAs, Keogh
   accounts, and certain employer-sponsored accounts. Employer-sponsored
   accounts include 401(k), 403(b), and thrift saving accounts
   from current or past jobs; other current job plans from which loans
   or withdrawals can be made; and accounts from past jobs from which
   the family expects to receive the account balance in the future. This
   definition of employer-sponsored plans is intended to confine the
   analysis to accounts that are portable across jobs and for which families
   will ultimately have the option to withdraw the balance.
   IRAs and Keoghs may be invested in virtually any asset, including
   stocks, bonds, pooled investment funds, options, and real estate. In principle,
   employer-sponsored plans may be invested in a similarly broad way, but, in
   practice, individuals’ choices for investment are often limited to a
   narrower set of assets.
6. The value of such policies according to their current cash value, not their death benefit.
7. Includes personal annuities and trusts with an equity interest and managed investment accounts.
8. Percentiles of income distribution in 2004 dollars:
   20th: $18,900; 40th: $33,900; 60th: $53,600; 80th: $89,300; 90th: $129,400.
   Percentiles of distribution of net worth in 2004 dollars:
   25th: $13,300; 50th: $93,100; 75th: $328,500; 90th: $831,600.
   Percentile: A value on a scale of zero to 100 that indicates the percent of a
   distribution that is equal to or below it. For example, a family with income/net worth in
   the 80th percentile has income/net worth equal to or better than 80 percent
   of all other families.
9. Median value of financial asset for families holding such assets.