EIA - State Energy Data System

State Energy Data System CSV File Documentation

Prices and Expenditures

The State Energy Data System (SEDS) comma-separated value (CSV) files contain the price and expenditure estimates shown in the tables located on the main SEDS page. The first record in each file serves as a column heading and contains information about the data in each of the following records. Each data file record that follows begins with the State code (2 characters), followed by the data identifier (5-character mnemonic code, or MSN), followed by the 41 values for the years 1970 through 2010, with all items separated by commas. All items are enclosed in quotes, which means some systems will read numeric values as alphanumeric unless they are converted. Each file contains SEDS prices in dollars per million British thermal units (Btu) and expenditures in million dollars.

There is a CSV file for each State, named with the two-letter U.S. Postal Code listed in Appendix A, as well as a file for the United States, available on each individual State or U.S. page. In addition, there are three files that contain estimates for all States and years available at the main SEDS page. Prices contains the price estimates for all States and Expenditures contains the expenditure estimates for all States. The third file, Adjusted Consumption for Expenditure Calculations contains adjusted consumption estimates used in calculating expenditures (see Appendix E below). Zip files are also available for the large data files.

Price estimates contained in these CSV files are rounded to two decimal places, and expenditure estimates are rounded to one decimal place. Adjusted consumption estimates are rounded to whole numbers in billion Btu, and conversion factors, percentages, and ratios are rounded to three decimal places. The precision does not necessarily reflect the statistical accuracy of the numbers. Users should see the sources cited in the SEDS Price and Expenditure Technical Notes for a discussion of statistical considerations concerning specific data series. Electric power sector fuel expenditures, shown as negative numbers in tables on expenditures by source, are stored as positive numbers in the data files.

The data files contain additional data series not shown in the report tables that have frequently been requested by customers. These additional data include the individual petroleum products in "Other Petroleum Products" used in the industrial sector.

Expenditure estimates are calculated as the product of the price and consumption estimates. The consumption estimates are also from SEDS and cover 1960 through 2010. A discussion of the consumption estimation methodologies is contained in the SEDS Consumption Technical Notes. Consumption estimates used in the price and expenditure tables are not always identical to those contained in the consumption data tables. Section 7: Consumption Adjustments for Calculating Expenditures in the Price and Expenditure Technical Notes explains the adjustments. The SEDS consumption tables are available on the same main SEDS page with the price and expenditure tables.

The following appendices explain the data identification codes used in the files. Appendix A lists the State codes. Appendix B is a list of the components of the key variables and definitions of the various characters. A copy of the column headings used in the SEDS price and expenditure tables is contained in Appendix C with the associated names of the key variables. Appendix D shows individual petroleum products covered under "Other Petroleum" in the price and expenditure tables. Appendix E identifies the process fuel and intermediate product consumption variables and the adjusted consumption variables used in expenditure calculations.

List of Appendices
A	State Codes
B	Data Identification Codes (MSN)
C	Table column headings and variable names
D	Other Petroleum
E	Consumption Adjustments for Calculating Expenditures

The price and expenditure estimates contained in SEDS and the methodologies used to derive them are described in the SEDS Price and Expenditure Technical Notes.

Contacts:

Copies of the report may be obtained from:

National Energy Information Center
U.S. Energy Information Administration
1000 Independence Ave., SW
Washington, D.C. 20585
infoctr@eia.gov

The State Energy Data System tables were prepared by the Integrated Energy Statistics Team of the Office of Survey Development & Statistical Integration, U.S. Energy Information Administration. Questions concerning the contents of the State Energy Data System or these files may be referred to Yvonne Taylor, 202-586-1455, or yvonne.taylor@eia.gov.

return to top

Appendix A

U.S. Postal State Codes
Code	Name	Code	Name	Code	Name	Code	Name
AK	Alaska	ID	Idaho	MT	Montana	RI	Rhode Island
AL	Alabama	IL	Illinois	NE	Nebraska	SC	South Carolina
AR	Arkansas	IN	Indiana	NC	North Carolina	SD	South Dakota
AZ	Arizona	KS	Kansas	ND	North Dakota	TN	Tennessee
CA	California	KY	Kentucky	NH	New Hampshire	TX	Texas
CO	Colorado	LA	Louisiana	NJ	New Jersey	UT	Utah
CT	Connecticut	MA	Massachusetts	NM	New Mexico	VA	Virginia
DC	District of Columbia	MD	Maryland	NV	Nevada	VT	Vermont
DE	Delaware	ME	Maine	NY	New York	WA	Washington
FL	Florida	MI	Michigan	OH	Ohio	WI	Wisconsin
GA	Georgia	MN	Minnesota	OK	Oklahoma	WV	West Virginia
HI	Hawaii	MO	Missouri	OR	Oregon	WY	Wyoming
IA	Iowa	MS	Mississippi	PA	Pennsylvania	US	United States

return to Appendix List

Appendix B

The 5-letter identifier (MSN) is a SEDS variable name defined as follows:

Data Identification Codes (MSN)
Characters	Identity
1 and 2	represent an energy source
3 and 4	represent an energy consumption sector or an energy activity
5	represents a type of data

Energy Source (Characters 1 and 2)
Code	Name
AR	asphalt and road oil
AV	aviation gasoline
CC	coal coke
CL	coal
DF	distillate fuel oil
DK	distillate fuel oil, including kerosene-type jet fuel
ES	electricity sales
EL	electricity (imports/exports)
FN	petrochemical feedstocks naphtha less than 401 degrees F.
FO	petrochemical feedstocks other oils equal to or greater than 401 degrees F.
FS	feedstocks still gas
JF	jet fuel
KS	kerosene
LG	liquefied petroleum gases
LU	lubricants
MG	motor gasoline
MS	miscellaneous petroleum products
NG	natural gas (including supplemental gaseous fuels)
NU	nuclear electric power
P1	asphalt and road oil, aviation gasoline, kerosene, lubricants, and "other petroleum products"
PA	all petroleum products
PC	petroleum coke
PE	primary energy
PO	other petroleum products
RF	residual fuel oil
SN	special naphtha
TE	total energy
WD	wood
WS	biomass waste
WW	wood and biomass waste
WX	waxes

return to Data Identification Codes

return to Appendix List

The following codes represent the four end-use consuming sectors, electric utilities, and total energy price and expenditures:

Energy Consumption Sectors (Characters 3 and 4)
Code	Name
AC	transportation sector estimates
CC	commercial sector estimates
EI	electric power sector estimates
IC	industrial sector estimates
RC	residential sector estimates
TC	total energy sector estimates
TX	Total end-use estimates

The following codes represent energy activies used in intermediate calculations for deriving the major end-use price and expenditure estimates:

Energy Activities (Characters 3 and 4)
Code	Name
AS	transportation consumption, costed
CS	commercial consumption, costed
EG	electricity, net generation
EX	exports
IM	imports
IS	industrial consumption, costed
KC	coke plant consumption
NI	net imports
OC	industrial consumption, excluding coke plants
OS	industrial consumption, excluding coke plants and process fuel
PF	process fuel consumption
PZ	natural gas consumed as pipeline fuel
RF	refinery fuel consumption
RS	refinery fuel consumption, costed
TP	energy expenditures per capita
XC	total consumption, excluding coke plants and process fuel

return to Data Identification Codes

return to Appendix List

Types (Character 5)
Code	Name
B	data in billion British thermal units (Btu)
D	price in dollars per million Btu
V	expenditures in million dollars
S	percentage

Other SEDS variables that do not follow this convention include:

Code	Name
TPOPP	resident population
GDPRV	current-dollar gross domestic product
TEGDS	energy expenditures as percent of current-dollar gross domestic product

return to appendix list

return to top

Appendix C

return to appendix list

The following section lists the SEDS variables in the order they appear in the price and expenditure tables. Each table column contains one variable.

Summary Tables:

Table E1 Primary Energy and Electricity Price Estimates
CLTCD	NGTCD	DFTCD	JFTCD	LGTCD	MGTCD	RFTCD	P1TCD
PATCD	NUETD	WWTCD	PETCD	PEEID	ESTCD	TETCD

Table E2 Total End-Use Price Estimates
CLTXD	NGTXD	DFTXD	JFTXD	LGTXD	MGTXD	RFTXD
P1TXD	PATXD	WWTXD	PETXD	ESTXD	TETXD

Table E3 Residential Sector Price Estimates
CLRCD	NGRCD	DFRCD	KSRCD	LGRCD
PARCD	WDRCD	PERCD	ESRCD	TERCD

Table E4 Commercial Sector Price Estimates
CLCCD	NGCCD	DFCCD	KSCCD	LGCCD	MGCCD
RFCCD	PACCD	WWCCD	PECCD	ESCCD	TECCD

Table E5 Industrial Sector Price Estimates
CLKCD	CLOCD	CLICD	NGICD	DFICD	LGICD	MGICD
RFICD	P1ICD	PAICD	WWICD	PEICD	ESICD	TEICD

Table E6 Transportation Sector Price Estimates
CLACD	NGACD	AVACD	DFACD	JFACD	LGACD	LUACD
MGACD	RFACD	PAACD	PEACD	ESACD	TEACD

Table E7 Electric Power Sector Price Estimates
CLEID	NGEID	RFEID	DKEID	PCEID
PAEID	NUEGD	WWEID	ELIMD	PEEID

Table E8 Primary Energy and Electricity Expenditure Estimates
CLTCV	NGTCV	DFTCV	JFTCV	LGTCV	MGTCV	RFTCV	P1TCV
PATCV	NUETV	WWTCV	PETCV	PEEIV	ESTCV	TETCV

Table E9 Total End-Use Expenditure Estimates
CLTXV	NGTXV	DFTXV	JFTXV	LGTXV	MGTXV	RFTXV
P1TXV	PATXV	WWTXV	PETXV	ESTXV	TETXV

Table E10 Residential Sector Expenditure Estimates
CLRCV	NGRCV	DFRCV	KSRCV	LGRCV
PARCV	WDRCV	PERCV	ESRCV	TERCV

Table E11 Commercial Sector Expenditure Estimates
CLCCD	NGCCD	DFCCD	KSCCD	LGCCD	MGCCD
RFCCD	PACCD	WWCCD	PECCD	ESCCD	TECCD

Table E12 Industrial Sector Expenditure Estimates
CLKCV	CLOCV	CLICV	NGICV	DFICV	LGICV	MGICV
RFICV	P1ICV	PAICV	WWICV	PEICV	ESICV	TEICV

Table E13 Transportation Sector Expenditure Estimates
CLACV	NGACV	AVACV	DFACV	JFACV	LGACV	LUACV
MGACV	RFACV	PAACV	PEACV	ESACV	TEACV

Table E14 Electric Power Sector Expenditure Estimates
CLEID	NGEID	RFEID	DKEID	PCEID
PAEID	NUEGD	WWEID	ELIMD	PEEID

Ranking Tables:

Table E15 Energy Prices and Expenditures
TETCD	TETCV	TETPV	TEGDS

Table E16 Motor Gasoline Prices and Expenditures
MGTCD	MGTCV	MGTPV

Table E17 Petroleum and Natural Gas Prices and Expenditures
PATCD	PATCV	NGTCD	NGTCV

Table E18 Coal and Retail Electricity Prices and Expenditures
CLTCD	CLTCV	ESTCD	ESTCV

Time Series Tables:

Table ET1 Primary Energy and Electricity
CLKCD/V	CLXCD/V	CLTCD/V	CCEXD/V*	CCIMD/V*	NGTCD/V	DFTCD/V	JFTCD/V	LGTCD/V	MGTCD/V
RFTCD/V	P1TCD/V	PATCD/V	NUETD/V	WWTCD/V	PETCD/V	PEEID/V	ESTCD/V	TETCD/V

Table ET2 Total End-Use
CLTXD/V	NGTXD/V	DFTXD/V	JFTXD/V	LGTXD/V	MGTXD/V	RFTXD/V
P1TXD/V	PATXD/V	NUTXD/V	WWTXD/V	PETXD/V	ESTXD/V	TETXD/V

Table ET3 Residential Sector
CLRCD/V	NGRCD/V	DFRCD/V	KSRCD/V	LGRCD/V
PARCD/V	WDRCD/V	PERCD/V	ESRCD/V	TERCD/V

Table ET4 Commercial Sector
CLCCD/V	NGCCD/V	DFCCD/V	KSCCD/V	LGCCD/V	MGCCD/V
RFCCD/V	PACCD/V	WWCCD/V	PECCD/V	ESCCD/V	TECCD/V

Table E5 Industrial Sector
CLKCD/V	CLOCD/V	CLICD/V	CCEXD/V*	CCIMD/V*	NGICD/V	DFICD/V	LGICD/V
MGICD/V	RFICD/V	PAICD/V	PAICD/V	WWICD/V	PEICD/V	ESICD/V	TEICD/V

Table ET6 Transportation Sector
CLACD/V	NGACD/V	AVACD/V	DFACD/V	JFACD/V	LGACD/V	LUACD/V
MGACD/V	RFACD/V	PAACD/V	PEACD/V	ESACD/V	TEACD/V

Table ET7 Electric Power Sector
CLEID/V	NGEID/V	RFEID/V	DKEID/V	PCEID/V
PAEID/V	NUEGD/V	WWEID/V	ELIMD/V	PEEID/V

return to Appendix List

return to top

* Appear only on U.S. tables.

Appendix D

return to appendix list

Other Petroleum

In the Total Energy, Total End-use, and Industrial Sector tables, “Other Petroleum” includes asphalt and road oil, aviation gasoline, kerosene, lubricants, and “other petroleum products” as described in Section 4 of the Price and Expenditure Technical Notes. Data for the detailed products are available in the CSV file.

Components of P1TCD/V

ARTCD/C

AVTCD/C

KSTCD/C

LUTCD/C

POTCD/C, which includes:

FNTCD/V

FOTCD/V

FSTCD/V

PCTCD/V

SNTCD/V

WXTCD/V

MSTCD/V

Components of P1TXD/V

ARTXD/C

AVTXD/C

KSTXD/C

LUTXD/C

POTXD/C, which includes:

FNTXD/V

FOTXD/V

FSTXD/V

PCTXD/V

SNTXD/V

WXTXD/V

MSTXD/V

Components of P1ICD/V

ARICD/V

KSICD/V

LUICD/V

POICD/V, which includes:

FNICD/V

FOICD/V

FSICD/V

PCICD/V

SNICD/V

WXICD/V

MSICD/V

return to top

Appendix E

return to Appendix List

Consumption Adjustments for Calculating Expenditures

To calculate energy expenditures, SEDS consumption is adjusted to remove quantities of process fuel, intermediate products, renewable energy consumption that has no direct fuel cost, and other adjustments. All such series are included in these files are in a CSV file named Adjusted Consumption for Expenditure Calculations. Not all associated SEDS consumption variables are displayed here, but they are available on the SEDS files. The most recent year's estimates are shown in Tables TN56 and TN57, in Section 7 of the SEDS Price and Expenditure Technical Notes.

Consumption Variables
Code	Description
CLOSB	Industrial coal consumption, excluding coke plants and processing fuel
CLRFB	Coal used at refineries
COICB	Industrial crude oil consumption in petroleum industry operations
DFISB	Industrial distillate fuel oil consumption, costed
DFRFB	Distillate fuel oil used at refineries
EMLCB	Energy losses and co-products from the production of fuel ethanol
ESISB	Industrial electricity consumption, costed
ESRFB	Electricity used at refineries
GEICB	Industrial geothermal energy consumption
GOCCB	Commercial geothermal and solar photovoltaic, hydroelecticity consumption, costed
GORCB	Residential geothermal and solar photovoltaic energy consumption
HYICB	Industrial hydroelectricity at no cost
LGISB	Industrial liquefied petroleum gases consumption, costed
LGRFB	Liquefied petroleum gases used at refineries
LOTCB	Electrical system energy losses
NGISB	Industrial natural gas consumption, costed
NGLPB	Natural gas lease and plant fuel consumption
NGPZP	Natural gas pipeline consumption
NGRFB	Natural gas used at refineries
P5RFB	Other petroleum used at refineries
PCISB	Industrial petroleum coke consumption, costed
PCRFB	Petroleum coke used at refineries
RFISB	Industrial residual fuel oil consumption, costed
RFRFB	Residual fuel oil used at refineries
TEPFB	Total energy used as process fuel
TERFB	Total energy used at refineries
TETCB	Total energy consumption
TNSCB	Total adjusted consumption
WDCSB	Commercial wood consumption, costed
WDRSB	Residential wood consumption, costed
WDRXB	Residential wood at no cost
WWCSB	Commercial wood and biomass waste consumption, costed
WWCXB	Commercial wood and biomass waste consumption at no cost
WWISB	Industrial wood and biomass waste consumption, costed
WWIXB	Industrial wood and biomass waste at no cost

return to top