Personal Consumption Expenditures in Current and Real (2000) Dollars by Type: 1990 to 2005 (Statistical Abstract 2008 Table 0655)

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. Consists of purchases (including tips) of meals and beverages from retail, service, and amusement establishments, hotels, dining and buffet cars, schools, school fraternities, institutions, clubs, and industrial lunchrooms. Includes meals and beverages consumed both on- and off-premise.
2. Includes luggage.
3. Consists of watch, clock, and jewelry repairs, costume and dress suit rental, and miscellaneous personal services.
4. Consists of rent for space and for heating and plumbing facilities, water heaters, lighting fixtures, kitchen cabinets, linoleum, storm windows and doors, window screens, and screen doors, but excludes rent for appliances and furniture and purchases of fuel and electricity.
5. Consists of space rent (see footnote 4) and rent for appliances, furnishings, and furniture.
6. Consists of transient hotels, motels, clubs, schools, and other group housing.
7. Consists of refrigerators and freezers, cooking ranges, dishwashers, laundry equipment, stoves, room air conditioners, sewing machines, vacuum cleaners, and other appliances.
8. Includes such house furnishings as floor coverings, comforters, quilts, blankets, pillows, picture frames, mirrors, art products, portable lamps, and clocks. Also includes writing equipment and hand, power, and garden tools.
9. Consists largely of textile house furnishings, including piece goods allocated to house furnishing use. Also includes lamp shades, brooms, and brushes.
10. Consists of maintenance services for appliances and house furnishings, moving and warehouse expenses, postage and express charges, premiums for fire and theft insurance on personal property less benefits and dividends, and miscellaneous household operation services.
11. Excludes drug preparations and related products dispensed by physicians, hospitals, and other medical services.
12. Consists of osteopathic physicians, chiropractors, private duty nurses, chiropodists, podiatrists, and others providing health and allied services, not elsewhere classified.
13. Consists of (1) current expenditures (including consumption of fixed capital) of nonprofit hospitals and nursing homes and (2) payments by patients to proprietary and government hospitals and nursing homes.
14. Consists of (1) premiums, less benefits and dividends, for health, hospitalization, and accidental death and dismemberment insurance provided by commercial insurance carriers, and (2) administrative expenses (including consumption of fixed capital) of Blue Cross and Blue Shield plans and of other independent prepaid and self-insured health plans.
15. Consists of premiums, less benefits and dividends, for income loss insurance.
16. Consists of premiums, less benefits and dividends, for privately administered workers’ compensation.
17. Consists of (1) operating expenses of life insurance carriers and private noninsured pension plans, and (2) premiums, less benefits and dividends, of fraternal benefit societies. Excludes expenses allocated by commercial carriers to accident and health insurance.
18. Consists of current expenditures (including consumption of fixed capital) of trade unions and professional associations, employment agency fees, money order fees, spending for classified advertisements, tax return preparation services, and other personal business services.
19. Consists of premiums, less benefits and dividends, for motor vehicle insurance.
20. Consists of baggage charges, coastal and inland waterway fares, travel agents’ fees, and airport bus fares.
21. Consists of admissions to professional and amateur athletic events and to racetracks.
22. Consists of dues and fees excluding insurance premiums.
23. Consists of billiard parlors; bowling alleys; dancing, riding, shooting, skating, and swimming places; amusement devices and parks; golf courses; sightseeing buses and guides; private flying operations; casino gambling; and other commercial participant amusements.
24. Consists of net receipts of lotteries and expenditures for purchases of pets and pet care services, cable TV, film processing, photographic studios, sporting and recreation camps, video cassette rentals, and recreational services, not elsewhere classified.
25. For private institutions, equals current expenditures (including consumption of fixed capital) less receipts-such as those from meals, rooms, and entertainments- accounted for separately in consumer expenditures, and less expenditures for research and development financed under contracts or grants. For government institutions, equals student payments of tuition.
26. For private institutions, equals current expenditures (including consumption of fixed capital) less receipts-such as those from meals, rooms, and entertainments- accounted for separately in consumer expenditures. For government institutions, equals student payments of tuition. Excludes child day care services, which are included in religious and welfare activities.
27. Consists of (1) fees paid to commercial, business, trade, and correspondence schools and for educational services, not elsewhere classified, and (2) current expenditures (including consumption of fixed capital) by research organizations and foundations for education and research.
28. For nonprofit institutions, equal current expenditures (including consumption of fixed capital) of religious, social welfare, foreign relief, and political organizations, museums, libraries, and foundations. The expenditures are net of receipts-such as those from meals, rooms, and entertainments-accounted for separately in consumer expenditures, and excludes relief payments within the United States and expenditures by foundations for education and research. For proprietary and government institutions, equals receipts from users.

[In billions of dollars ($3,839.9 represents $3,839,900,000,000). For definition of “chained” dollars, see the Notes sheet. For information on methodology, see http://www.bea.doc.gov/bea/ARTICLES/NATIONAL/NIPA/Methpap/methpap6.pdf

table: [124, 34]

Notes (pg 2)

• (X) Not applicable.

0655

2008