Energy Consumption, by End-Use Sector: 1950 to 2005 (Statistical Abstract 2008 Table 0891)

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. Commercial sector fuel use, including that at commercial combined-heat-and-power (CHP) and commercial electricity-only plants.
2. Industrial sector fuel use, including that at industrial combined-heat-and-power (CHP) and industrial electricity-only plants.
3. A balancing item. The sum of primary consumption in the five energy-use sectors equals the sum of total consumption in the four end-use sectors. However, total energy consumption does not equal the sum of the sectoral components due to: 1) for 1949 forward, the use of sector-specific conversion factors for natural gas and coal; 2) for 1989 forward, the undercounting of coal consumption at “Other Power Producers” in the energy-use sectors; and 3) for 1999 and 2000, the double-counting of fossil-fuel consumption at nonutilities in both the electric power sector and the end-use sectors.
4. Preliminary. NOTE Primary consumption includes coal, natural gas, petroleum, nuclear electric power, hydroelectric power, wood, waste, alcohol fuels, geothermal, solar, wind, net imports of coal coke, and net imports of electricity. Total consumption includes primary consumption, electricity end-use, and electrical system energy losses. Totals may not equal sum of components due to independent rounding.

[31.98 represents 31,980,000,000,000,000 Btu. Btu=British thermal unit. For residential and commercial, industrial, and transportation, represents consumption of fossil fuels only. For definition of Btu, see source and text, this section. See Appendix III]

table: [66, 12]

0891

2008