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

Energy Expenditures -- End-Use Sector and Selected Source, by State: 2003 (Statistical Abstract 2008 Table 0895)

Photo of a Baby Chacma Baboon

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

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
U.S. Energy Information Administration, State Energy Data, annual.

U.S. Energy Information Administration, State Energy Data, annual.

referenced on dataset section Data (#1)

U.S. Energy Information Administration, State Energy Data, annual. http://www.eia.doe.gov/emeu/states/_seds.html

U.S. Energy Information Administration, State Energy Data, annual.

For more information:

http://www.eia.doe.gov/emeu/states/_seds.html

Energy Expenditures: The money spent directly by consumers to purchase

energy. Expenditures equal the amount of energy used by the consumer

times the price p…

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. Includes sources not shown separately, such as electricity imports and exports and coal coke net
    imports ($169.1 million in 2003, which are not allocated to the States). Total expenditures are the sum of
    purchases for each source (including electricity sales) less electric utility purchases of fuel.

Headnotes

[In millions of dollars (471,786 represents $471,786,000,000). Data are preliminary.
End-use sector and electric utilities exclude expenditures on energy such as hydroelectric, solar thermal,
wind, photovoltaic, and geothermal. Also excludes expenditures for reported amounts of
energy consumed by the energy industry for production, transportation, and processing
operations]

Shape

table: [57, 65]

Snippet

1997 1998 1999 2000 2001 2003 1997 1998 1999 2000 2001 2003 1997 1998 1999 2000 2001 2003 1997 1998 1999 2000 2001 2003 1997 1998 1999 2000 2001 2003 1997 1998 1999 2000 2001 2003 1997 1998 1999 2000 2001 2003 1997 1998 1999 2000 2001 2003
(Million dollars) (Million dollars) (Million dollars) (Million dollars) (Million dollars) (Million dollars) (Million dollars) (Million dollars) (Million dollars)
United States US 00000 00 471786 469505 474515 491904 505518 515321 561473 568242 526224 558742 703188.1 693599 753412.1 138954 135044 137348 155624.6 168617.7 178797.4 100296 98249 98059 113030.2 125771.9 129233.9 120042 108282 114318 152581.8 137819.6 150110 208950 184649 209017 281951.5 261389.9 295270.8 267621 232367 262912 362026.2 336361.6 379145 91736 81628 83512 115909.7 139526.3 144434.1 27523 27195 25920 28728 28195.4 29224 213645 216928 216737 231652.7 244814.2 257081
Alabama AL 01000 01 8393.7 8345.8 8469.1 8775.3 8932.5 9192.7 9824.6 9721.5 9481.7 10075.7 12093.8 11579.8 12679.7 2233.6 2395.4 2462.9 2738.9 2797.9 2894.4 1343.2 1399.7 1464.7 1573.8 1627.7 1723.4 2462.2 2378.3 2527.4 2862.5 2826.9 3265.9 3682.5 3308.3 3620.7 4918.7 4327.3 4795.9 4239.7 3743.9 4220.9 5786.8 5142.2 5817.1 1297.3 1174.7 1199.6 1550.4 2077.1 2220 1345.3 1355.2 1283.5 1290.6 1219.1 1254.4 3883.9 4315.5 4367.1 4592.3 4345.3 4824.9
Alaska AK 02000 02 2130.4 1888.7 1867.6 1824.6 1763 1966.8 2050.8 2179 1946.1 2040.4 2721.5 2780 2842.5 330.1 329.4 342.4 354.3 428.1 413 343.8 360.8 354.2 368.4 452.8 382.7 239.1 209.2 196.8 239.4 310.3 244.9 1266 1046.8 1147 1759.4 1588.7 1802 1519 1273.8 1357.4 1991.5 2070.5 2108 252 236.7 234.8 247.4 249.6 261 25.5 22.4 23.2 47.2 30.7 25.1 485.2 505.3 514.6 532 567.1 579.6
Arizona AZ 04000 04 6530.3 6453.4 6916.7 7352.6 7550.1 7688.4 8457.5 8594.7 8433.9 9012.5 10561.9 10671.8 11842.2 2126.4 2245.3 2303.3 2520.1 2663.6 2803.9 1712 1800 1845.1 1961.2 2046.3 2092.5 1087.5 1031.7 998.3 1094.1 1135.5 1095.7 3668.7 3356.9 3865.8 4986.5 4826.4 5850.1 4025.1 3712.2 4212.1 5438.9 5351.3 6328.7 574.1 683.8 723 1100.1 1380.5 1639.4 534 523.7 545.2 546.1 539.5 525.4 4019.2 4091.9 4170.2 4431.2 4525.6 4705.5
Arkansas AR 05000 05 4703 4690.8 4761.5 5083.9 5153.2 5223.4 5683.1 5938.1 5480.8 5990.3 7326 7339.5 7591.3 1364.2 1382.9 1422.8 1570.9 1701.8 1623.3 728.8 684.6 707.1 784.4 915 878.4 1522.9 1380.7 1591.3 1938.8 1967.7 1973.6 2322.2 2032.6 2269 3031.8 2755 3115.9 2757.5 2369.1 2773.5 3809 3510.4 3845.6 980.6 929.8 947.6 1253.7 1418.9 1560.7 405.9 376.3 390.9 383 249.5 311.5 2216.1 2226.1 2215.2 2348.6 2463.5 2346.8
California CA 06000 06 48659.9 47525.7 49540.3 48504.1 50151.1 51042.4 52741.4 55168.7 51656.3 56007.3 71058.4 72923.7 79564.6 11932.5 12082.5 12110.1 13305.4 15503.6 14715.6 10745.5 10530.3 10170.3 11885.5 15831.6 15487.5 8463.5 8084.8 8875 13083.8 10675.7 11354.5 24027.3 20958.7 24851.9 32783.8 30912.8 38007 25678.5 22720 26691 35100.7 33750.5 40764.6 8878.9 9196.4 9102.4 13512.3 20824.3 14986.4 87.4 116.7 111.3 115.4 98.8 118.7 21567.9 20256.6 20359.7 22914.6 27482.6 27480.7
Colorado CO 08000 08 5254.5 5394 5496.9 5866.7 6103.2 6307 6819.2 6811 6524.6 7002.5 8689.9 9279.4 9860.7 1498.4 1539.6 1652.3 1894.4 2268.3 2315.8 1239.4 1283.4 1358.9 1472.3 1653.2 1724.3 1019.7 957 834.8 1188.6 1154.9 1508.8 3053.4 2744.6 3156.4 4134.6 4203 4311.9 3448.7 3105.1 3509.9 4820.4 4864.1 5061.9 1097.4 1094 1123 1457.6 2092 1993.8 362.4 351.9 352.1 361.4 373.7 382.5 2244.2 2336.7 2395 2508 2638.4 3118.2
Connecticut CT 09000 09 6129.8 6214.1 6510.7 6576 6627.6 6702.4 7262.4 7329.8 6667.7 7110.8 8275.1 8062.1 9212.2 2396.6 2193.4 2310.4 2631.4 2671.6 3157.7 1701.4 1646.5 1650.4 1698.9 1742.5 2046.4 866.2 767.2 770.3 1011.5 885.9 927.7 2365.7 2060.6 2379.6 2933.3 2762.1 3080.3 3683.2 3058 3414.1 4314.3 4272.9 4875.2 932.3 837.2 884.7 996.7 1124.5 1429.2 53.6 28.6 (Z) 83.2 67 79.2 2990.6 2983.2 2968.1 2852.3 2936.9 3234.5
Delaware DE 10000 10 1409.5 1421.2 1386.7 1491 1502 1534.1 1667.4 1688.5 1587.9 1727.5 2071.6 1985 2266.5 468.4 456.5 482.9 494.4 521.6 605.9 293.6 290.5 316.1 311.3 352.1 391.1 341.1 322.2 347.5 454.4 425.3 495.1 585.4 518.7 580.9 811.4 686.1 774.3 820.1 725.1 807.7 1121.3 1020.3 1179.2 232.1 204.6 259.9 293.5 337.5 359.3 75.1 70.5 55.9 73.8 79.8 75.4 704.3 711.4 744.7 681.8 743.5 870.8
65=. … snip
Source: U.S. Energy Information Administration, State Energy Data, annual.

Symbols

Notes (pg 2)

  • (Z) Represents less than 0.5 million dollars.

Tablenum

0895

Year

2008

History

Uploaded by (admin) Modified by (admin)