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

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 119 rows and 13 columns.

In dollars. Wage and salary accruals include executives’ compensation, bonuses, tips, and payments-in-kind; total compensation includes in addition to wages and salaries, employer contributions for social insurance, employer contributions to private and welfare funds, director’s fees, jury and witness fees, etc. Based on the 1997 North American Industry Classification System (NAICS); see text, this section

Footnotes

1. NAICS crop and animal production.
2. Consists of furniture and home furnishings stores; electronics and appliance
   stores; buildingmaterial and garden equipment and supplies dealers; health and
   personal care stores; gasolinestations; clothing and clothing accessories
   stores; sporting goods, hobby, book, and musicstores; miscellaneous store
   retailers; and nonstore retailers.
3. Consists of scenic and sightseeing transportation; transportation support
   activities; andcouriers and messengers.
4. Intangible assets include patents, trademarks, and franchise agreements, but
   not copyrights.
5. Consists of accounting, tax preparation, bookkeeping, and payroll services;
   architectural,engineering, and related services; specialized design services;
   management, scientific, andtechnical consulting services; scientific research
   and development services; advertising andrelated services; and other
   professional, scientific, and technical services.
6. Consists of offices of bank and other holding companies and of corporate,
   subsidiary, and regional managing offices.
7. Includes Coast Guard.
8. Employees of Indian tribal governments are classified in state and local
   government.

Application Gallery