Price Indexes for Personal Consumption Expenditures by Type of Expenditure: 1929 to 2005 (Statistical Abstract 2008 Table 0718)

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, andamusement establishments, hotels, dining and buffet cars, schools, school fraternities,institutions, clubs, and industrial lunchrooms. Includes meals and beverages consumedboth on- and off-premise.
2. Includes luggage.
3. Consists of watch, clock, and jewelry repairs, costume and dress suit rental, andmiscellaneous personal services.
5. Consists of space rent (see footnote 4) and rent for appliances, furnishings, and furniture.
6. Consists of transient hotels, motels, other traveler accommodations, 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, picture frames, mirrors, art products,portable lamps, clocks, blinds, shades, drapery hardware, and telephone equipment. Also includes writing equipment and hand, power, and garden tools.
9. Consists largely of textile house furnishings, including piece goods allocated to housefurnishing use. Also includes lamp shades, brooms, and brushes.
10. Consists of repair and maintenance services for appliances and house furnishings, moving andwarehouse expenses, postage and parcel delivery charges, premiums plus premium supplementsless normal losses and dividends paid to policyholders for insurance on personal property (exceptmotor vehicles), and miscellaneous household operation services.
11. Excludes drug preparations and related products dispensed by physicians, hospitals, andother medical services.
12. Consists of offices of physicians, Health Maintenance Organization (HMO) medical centers, and freestanding ambulatory surgical and emergency centers.
13. Consists of chiropractors, optometrists, mental health practitioners (except physicians),physical, occupational and speech therapists, and audiologists, podiatrists, all other miscellaneoushealth practitioners, ambulance services, kidney dialysis centers, family planning services, outpatientmental health and substance abuse centers, all other outpatient care centers, blood and organ banks, allother miscellaneous ambulatory health care services, home health furniture and equipment rental, medicaland diagnostic laboratories, and home health care.
14. Consists of (1) current expenditures (including consumption of fixed capital) of nonprofithospitals and nursing homes, and (2) payments by patients to proprietary and governmenthospitals and nursing homes.
15. Consists of premiums less benefits for health, hospitalization, and accidental death anddismemberment insurance.
16. Consists of premiums less benefits for income loss insurance.
17. Consists of premiums plus premium supplements less normal losses and dividends paid topolicyholders for privately administered workers’ compensation.
18. Consists of (1) operating expenses of commercial life insurance carriers and fraternal benefit lifeinsurance and (2) administrative expenses of private noninsured pension plans and publicly administeredgovernment employee retirement plans. For commercial life insurance carriers, excludes expenses foraccident and health insurance and includes profits of stock companies and services furnished withoutpayment by banks, credit agencies, and investment companies. For pension and retirement plans, excludesservices furnished without payment by banks, credit agencies, and investment companies.
19. Consists of current expenditures (including consumption of fixed capital) of trade unions andprofessional associations, employment agency fees, money order fees, spending for classified advertisements,tax return preparation services, and other personal business services.
20. Consists of premiums plus premium supplements less normal losses and dividends paid to policyholders formotor vehicle insurance.
21. Consists of baggage charges, coastal and inland waterway fares, travel agents’ fees, airport bus fares,and limousine services.
22. Consists of admissions to professional and amateur athletic events and to racetracks.
23. Consists of current expenditures (including consumption of fixed capital) of nonprofit clubs and fraternalorganizations and dues and fees paid to proprietary clubs.
24. Consists of billiard parlors; bowling alleys; dancing, riding, shooting, skating, and swimming places;amusement devices and parks; golf courses; skiing facilities; marinas; sightseeing; private flying operations;casino gambling; recreational equipment rental, and other commercial participant amusements.
25. Consists of lotteries, pets and pet care services, cable TV, film processing, photographic studios, sportingand recreation camps, video rentals, internet access fees, and recreational services, not elsewhere classified.
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, and lessexpenditures for research and development financed under contracts or grants. For government institutions, equalsstudent payments of tuition.
27. 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 governmentinstitutions, equals student payments of tuition. Excludes child day care services, which are included in religious andwelfare activities.
28. Consists of (1) fees paid to business schools and computer and management training, technical and trade schools,other schools and instruction, and educational support services, and (2) current expenditures (including consumptionof fixed capital) by nonprofit research organizations and by grantmaking foundations for education and research.
29. For nonprofit institutions, equals current expenditures (including consumption of fixed capital) of religiousorganizations, child day care services (excluding educational programs), social advocacy organizations, human rightsorganizations, civic and social organizations, residential mental health and substance abuse facilities, homes for theelderly, other residential care facilities, social assistance services, political organizations, museums, libraries,and grantmaking and giving services. The expenditures are net of receipts-such as those from meals, rooms, andentertainments-accounted for separately in consumer expenditures, and exclude relief payments within the United Statesand expenditures by grantmaking foundations for education and research. For proprietary and government institutions,equals receipts from users.
30. Beginning with 1981, includes U.S. students’ expenditures abroad.
31. Beginning with 1981, includes nonresidents’ student and medical care expenditures in the United States. Beginningwith 1986, includes migratory worker and foreign professional expenditures in the U.S..

[2000 = 100]

table: [123, 78]

0718

2008