Utilities--Employees, Annual Payroll, and Establishments by Industry: 2004 (Statistical Abstract 2008 Table 0888)

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.

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. North American Industry Classification System, 2002; see text, Section 15.
2. Covers full- and part-time employees who are on the payroll in the pay period including March 12.

2003 (pg 3)

1. North American Industry Classification System, 1997.
2. Covers full- and part-time employees who are on the payroll in the pay period including March 12.

2000 (pg 6)

1. North American Industry Classification System, 1997.
2. Covers full- and part-time employees who are on the payroll in the pay period including March 12.

1999 (pg 7)

1. North American Industry Classification System, 1997.
2. Covers full- and part-time employees who are on the payroll in the pay period including March 12.

1998 (pg 8)

1. North American Industry Classification System, 1997.
2. Covers full- and part-time employees who are on the payroll in the pay period including March 12.

[Excludes government employees, railroad employees, self-employed persons, etc.
An establishment is a single physical location where business is conducted
or where services or industrial operations are performed]

table: [30, 11]

0888

2008