what works · what's broken · what's on the way

Total Electric Power Industry -- Generation, Sales, Revenue, and Customers: 1970 to 2006 (Statistical Abstract 2008 Table 0916)

Photo of a Papa Gorilla

Size: 15 KB (approx) Downloaded: 0 times
Available in: csv, yaml, and xls Category: demographics/us

Tags

About

The Statistical Abstract of the United States is the standard summary of statistics on the social, political, and economic organization of the United States. It is also designed to serve as a guide to other statistical publications and sources. The latter function is served by the introductory text to each section, the source note appearing below each table, and Appendix I, which comprises the Guide to Sources of Statistics, the Guide to State Statistical Abstracts, and the Guide to Foreign Statistical Abstracts. This volume includes a selection of data from many statistical sources, both government and private. Publications cited as sources usually contain additional statistical detail and more comprehensive discussions of definitions and concepts. Data not available in publications issued by the contributing agency but obtained from the Internet or unpublished records are identified in the source notes. More information on the subjects covered in the tables so noted may generally be obtained from the source.

Although emphasis in the Statistical Abstract is primarily given to national data, many tables present data for regions and individual states and a smaller number for metropolitan areas and cities. Appendix II, Metropolitan and Micropolitan Statistical Areas: Concepts, Components, and Population, presents explanatory text, a complete current listing and population data for metropolitan and micropolitan areas defined as of December 2005. Statistics for the Commonwealth of Puerto Rico and for island areas of the United States are included in many state tables and are supplemented by information in Section 29. Additional information for states, cities, counties, metropolitan areas, and other small units, as well as more historical data are available in various supplements to the Abstract.

Fields

nametypeunitstags

Credits

US Census Bureau source http://www.census.gov/statab/www

U.S. Census Bureau, Statistical Abstract of the United States: 2008 (127th Edition) Washington, DC, 2007; http://www.census.gov/statab/www/
Philip (flip) Kromer converted http://infochimp.org/flip
Edison Electric Institute, Washington, DC,

Edison Electric Institute, Washington, DC,

Statistical Yearbook of the Electric Power Industry, annual.

referenced on dataset section Data (#1)
Edison Electric Institute, Washington, DC, http://www.eei.org/

Edison Electric Institute, Washington, DC,

Statistical Yearbook of the Electric Power Industry, annual.

For more information:

http://www.eei.org/

referenced on dataset section Notes (#2)

Usage Notes

[none]

Rights Info

All US Census Bureau materials, regardless of the media, are entirely in the public domain. There are no user fees, site licenses, or any special agreements etc for the public or private use, and or reuse of any census title. As tax funded product, it’s all in the public record. Some of our products, however, are special cases. [...] The Statistical Abstract has some data covered by copyright law. Check the table’s footnotes to determine if the data are covered by copyright law.

File structure

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.

Footnotes

Notes (pg 2)

  1. Preliminary.
  2. “Generation” includes batteries, chemicals, hydrogen, pitch, sulfur, purchased steam, and miscellaneous technologies, which are not separately displayed.
  3. Includes other types not shown separately. Data for 1990-1994 are as of December 31st, data for following years are average yearly customers.
  4. Small light and power.
  5. Large light and power.

Headnotes

[1,532 represents 1,532,000,000,000 kilowatt-hours. Sales and revenue are to and from ultimate customers. Commercial and Industrial are not wholly comparable on a year-to-year basis due to changes from one classification to another. For the 2003 period forward, the Energy Information Administration replaced the “Other” sector with the Transportation sector. The Transportation sector consists entirely of electrified rail and urban transit systems. Data previously reported in “Other” have been relocated to the Commercial sector, except for Agriculture (i.e., irrigation load), which have been relocated to the Industrial sector]

Shape

table: [71, 39]

Snippet

Generation 2 Billion kilowatt-hours 1531.609 1612.589 1749.637 1856.216 1866.436 1917.619 2037.674 2124.166 2206.313 2247.359 2286.414 2294.812 2241.211 2310.285 2416.304 2469.841 2487.31 2572.127 2704.25 2784.304 2808.151 3073.799 3083.882 3197.191 3247.522 3353.486697 3444.188 3492.172 3620.295 3694.81 3802.105 3736.644 3858.452 3883.185 3970.555 4055.423 4052.968
Sales 3 Billion kilowatt-hours 1392 1470 1595 1713 1706 1747 1855 1948 2017.818 2071 2094 2147 2086 2151 2286 2324 2369 2457 2578 2647 2712.555 2762.003 2763.365 2861.462 2934.563 3013.287 3101.127 3145.61 3264.231 3312.087 3421.414 3382.092 3466.08 3489.223 3548.218 3660.969 3665.009
Residential or domestic Billion kilowatt-hours 466 500 539 579 578 588 606 645 674 683 717 722 730 751 780 794 819 850 893 906 924.019 955.417 935.939 994.781 1008.482 1042.501 1082.512 1075.88 1130.109 1144.923 1192.446 1201.148 1265.403 1273.597 1293.587 1359.227 1354.232
Percent of total 33.4770114943 34.0136054422 33.7931034483 33.8003502627 33.8804220399 33.6576989124 32.6684636119 33.1108829569 33.4024178593 32.9792370835 34.2406876791 33.6283185841 34.9952061361 34.9139934914 34.1207349081 34.165232358 34.5715491769 34.595034595 34.6392552366 34.2274272762 34.0645258806 34.5914541005 33.8695394926 34.7647810804 34.3656619401 34.596804088 34.9070515332 34.2025870976 34.6209873015 34.5680231226 34.8524323569 35.5149416397 36.5081879241 36.5008771294 36.4573709958 37.1275200637 36.9503048969
Commercial 4 Billion kilowatt-hours 307 329 359 388 385 403 425 447 461 473 488 514 526 544 583 606 631 660 699 726 751.027 765.664 761.271 794.573 820.269 862.685 887.445 928.633 979.401 1001.996 1055.232 1087.987 1104.748 1197.199 1229.045 1275.079 1300.851
Industrial 5 Billion kilowatt-hours 571 589 641 686 685 688 754 786 809 842 815 826 745 776 838 837 831 858 896 926 945.522 946.583 972.714 977.164 1007.981 1012.693 1033.631 1038.197 1051.203 1058.217 1064.239 984.511 990.139 1011.617 1018.522 1019.156 1001.929
Revenue 3 Billion dollars 23.664 26.46 30.305 34.26 42.65 50.663 57.505 66.232 74.659266 82.84 98.418 118.085 127.246 135.513 142.875 149.6656 152.5636 156.5109 163.703 170.7315 178.243 186.359 188.48 198.22 202.706 207.717 212.609407 215.333605 219.848291 219.896024 233.1634 247.324855 250.189101 258.860912 270.456169 298.003 324.308
Residential or domestic Billion dollars 10.252 11.5 12.936 14.475 17.918 20.58 22.422 26.445 28.982 31.418 38.718 44.764 50.37 54.072 55.77 58.6766 60.7698 63.325 66.7964 69.309 72.378 76.828 76.848 82.814 84.552 87.61 90.503465 90.704081 93.360164 93.483142 98.209387 103.665471 107.106147 110.794077 116.037126 128.393 140.838
Percent of total Percent 43.3231913455 43.4618291761 42.6860254083 42.2504378284 42.0117233294 40.6213607564 38.9913920529 39.927829448 38.8190261608 37.9261226461 39.3403645675 37.9082864039 39.5847413671 39.9017068473 39.0341207349 39.2051346468 39.8324370951 40.4604407744 40.8034061685 40.5953207229 40.6063632232 41.2258061054 40.7724957555 41.7788316013 41.7116414906 42.1775781472 42.5679494981 42.122585093 42.4657219646 42.5124294198 42.1204129808 41.9147000005 42.8100770865 42.8006206669 42.9042260079 43.0844655926 43.4272358375
39=. ... snip ...
Source: Edison Electric Institute, Washington, DC,
Statistical Yearbook of the Electric Power Industry, annual.

Symbols

Notes (pg 2)

  • (NA) Not available.

Tablenum

0916

Year

2008

History

Uploaded by (admin) Modified by (admin)