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 718):

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 123 rows and 78 columns.

2000 = 100

Footnotes

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..

Application Gallery