EIA - State Energy Data System

	State Energy Data System (SEDS)

SEDS CSV File Documentation: Price and Expenditure

State Energy Data System CSV File Documentation

Prices and Expenditures

Last updated: 08/27/2009 (CMC)

The State Energy Data System (SEDS) comma-separated value (CSV) files contain the price and expenditure data 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 characters), followed by the 38 values for the years 1970 through 2007, with all items separated by commas. The data are expressed with five decimal places and explicit decimal points are included in numeric fields. 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 nominal dollars per million British thermal units (Btu) and expenditures in million nominal 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 data for all States and years available at the main SEDS page. Prices, 1970-2007 contains the price data for all States and Expenditures, 1970-2007 contains the expenditure data for all States. The third file, Adjusted Consumption for Expenditure Calculations contains adjusted consumption data used in calculating expenditures for all States and years. Zip files are also available for the large data files.

The data contained in these CSV files are in greater precision expressed with five decimal places, while the data contained in the published tables are rounded. The decimal place precision reflected in these files is the same as that used in the SEDS and is provided so that users can completely duplicate SEDS calculations; however 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. Data are stored as positive numbers in the data files, although they may be shown as negative numbers in some of the report tables. The most notable example is electric power sector fuel expenditures.

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 2007. A discussion of the consumption estimation methodologies is contained in the SEDS Consumption Technical Notes. Consumption data 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.

Appendices:

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

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.

Additional Information and Contacts:

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

Copies of the report may be obtained from:

National Energy Information Center, EI-30
Energy Information Administration
Forrestal Building, Room 1E-238
Washington, D.C. 20585
202-586-8800
infoctr@eia.doe.gov
TTY: 202-586-1181

The State Energy Data System price and expenditure tables are prepared in the Integrated Energy Statistics Division of the Office of Energy Markets and End Use, Energy Information Administration. Questions concerning the contents of the tables or the use of these files may be referred to Yvonne Taylor, 202-586-1455, or yvonne.taylor@eia.doe.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 is a SEDS variable name defined as follows:

Data Identification Codes
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	waste
WW	wood and 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

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 nominal dollars per million Btu
V	expenditures in million nominal dollars
S	percentage

Other SEDS variables that do not follow this convention include:

Code	Name
TPOPP	resident population
GDPRV	nominal gross domestic product
TEGDS	energy expenditures as share of nominal 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 Table Codes

Column Heading Table S1a Table S1b Column Heading Table S2a Table S2b

Coal CLTCD CLTCV Coal CLRCD CLRCV

Natural Gas NGTCD NGTCV Natural Gas NGRCD NGRCV

Distillate Fuel Oil DFTCD DFTCV Distillate Fuel Oil DFRCD DFRCV

Jet Fuel JFTCD JFTCV Kerosene KSRCD KSRCV

LPG LGTCD LGTCV LPG LGRCD LGRCV

Motor Gasoline MGTCD MGTCV Total Petroleum PARCD PARCV

Residual Fuel Oil RFTCD RFTCV Wood WDRCD WDRCV

Other Petroleum P1TCD P1TCV Total Primary Energy PERCD PERCV

Total Petroleum PATCD PATCV Retail Electricity ESRCD ESRCV

Nuclear Fuel NUTCD NUTCV Total Energy TERCD TERCV

Biomass (Wood & Waste) WWTCD WWTCV

Total Primary Energy PETCD PETCV

Electric Power Sector PEEID PEEIV

Retail Electricity ESTCD ESTCV

Total Energy TETCD TETCV

Column Heading Table S3a Table S3b Column Heading Table S4a Table S4b

Coal CLCCD CLCCV Coking Coal CLKCD CLKCV

Natural Gas NGCCD NGSSV Steam Coal CLOCD CLOCV

Distillate Fuel Oil DFCCD DFCCV Total Coal CLICD CLICV

Kerosene KSCCD KSCCV Natural Gas NGICD NGICV

LPG LGCCD LGCCV Distillate Fuel Oil DFICD DFICV

Motor Gasoline MGCCD MGCCV LPG LGICD LGICV

Residual Fuel Oil RFCCD RFCCV Motor Gasoline MGICD MGICV

Total Petroleum PACCD PACCV Residual Fuel Oil RFICD RFICV

Biomass (Wood & Waste) WWCCD WWCCV Other Petroleum P1ICD P1ICV

Total Primary Energy PECCD PECCV Total Petroleum PAICD PAICV

Retail Electricity ESCCD ESCCV Biomass (Wood & Waste) WWICD WWICV

Total Energy TECCD TECCV Total Primary Energy PEICD PEICV
Retail Electricity ESICD ESICV
Total Energy TEICD TEICV

Column Heading Table S5a Table S5b Column Heading Table S6a Table S6b

Coal CLACD CLACV Coal CLEID CLEIV

Natural Gas NGACD NGACV Natural Gas NGEID NGEIV

Aviation Gasoline AVACD AVACV Residual Fuel Oil RFEID RFEIV

Distillate Fuel Oil DFACD DFACV Distillate Fuel Oil DKEID DKEIV

Jet Fuel JFACD JFACV Petroleum Coke PCEID PCEIV

LPG LGACD LGACV Total Petroleum PAEID PAEIV

Lubricants LUACD LUACV Nuclear Fuel NUEGD NUEGV

Motor Gasoline MGACD MGACV Biomass (Wood & Waste) WWEID WWEIV

Residual Fuel Oil RFACD RFACV Electricity Imports ELIMD ELIMV

Total Petroleum PAACD PAACV Total Energy PEEID PEEIV

Total Primary Energy PEACD PEACV
Retail Electricity ESACD ESACV

Total Energy TEACD TEACV

Ranking Table Codes

Column Heading Table R1 Table R2 Column Heading Table R3 Column Heading Table R4

Prices TETCD MGTCD Petroleum Prices PATCD Coal Prices CLTCD

Expenditures TETCV MGTCV Petroleum Expenditures PATCV Coal Expenditures CLTCV

Expenditures per Person TETPV MGTPV Natural Gas Prices NGTCD Retail Electricity Prices ESTCD

Expenditures as Share of Nominal GDP TEGDS Natural Gas Expenditures NGTCV Retail Electricity Expenditures ESTCV

Prices and Expenditures (D/V) of Fuels and Electricity (By Energy Source)

Table 1: Total Energy

Name Code

Coking Coal

CLKCD/V

Steam Coal

CLXCD/V

Coal

CLTCD/V

Exports of Coal Coke

CCEXD/V*

(CCEXD/V published as negative value, data stored as positive value)

Imports of Coal Coke

CCIMD/V*

Natural Gas

NGTCD/V

Distillate Fuel Oil

DFTCD/V

Jet Fuel

JFTCD/V

LPG

LGTCD/V

Motor Gasoline

MGTCD/V

Residual Fuel Oil

RFTCD/V

Other Petroleum

P1TCD/V

Total Petroleum

PATCD/V

Nuclear Fuel

NUETD/V

Biomass (Wood & Waste)

WWTCD/V

Primary Energy - Five Sectors

PETCD/V

Electric Power Sector

PEEID/V

(Published as negative value, data stored as positive value)

Retail Electricity

ESTCD/V

Total Energy

TETCD/V

* Appear only on U.S. tables.

return to Appendix List

return to top

Prices and Expenditures (D/V) of Fuels and Electricity (By Sector)
Table 2: Residential Sector
Name	Code
Coal	CLRCD/V
Natural Gas	NGRCD/V
Distillate Fuel Oil	DFRCD/V
Kerosene	KSRCD/V
LPG	LGRCD/V
Total Petroleum	PARCD/V
Wood	WDRCD/V
Total Primary Energy	PERCD/V
Retail Electricity	ESRCD/V
Total Residential Sector	TERCD/V
Table 3: Commercial Sector
Name	Code
Coal	CLCCD/V
Natural Gas	NGCCD/V
Distillate Fuel Oil	DFCCD/V
Kerosene	KSCCD/V
LPG	LGCCD/V
Motor Gasoline	MGCCD/V
Residual Fuel Oil	RFCCD/V
Total Petroleum	PACCD/V
Biomass (Wood & Waste)	WWCCD/V
Total Primary Energy	PECCD/V
Retail Electricity	ESCCD/V
Total Commercial Sector	TECCD/V
Table 4: Industrial Sector
Name	Code
Coking Coal	CLKCD/V
Steam Coal	CLOCD/V
Coal	CLICD/V
Exports of Coal Coke	CCEXD/V*
Imports of Coal Coke	CCIMD/V*
Natural Gas	NGICD/V
Distillate Fuel Oil	DFICD/V
LPG	LGICD/V
Motor Gasoline	MGICD/V
Residual Fuel Oil	RFICD/V
Other Petroleum	P1ICD/V
Total Petroleum	PAICD/V
Biomass (Wood & Waste)	WWICD/V
Total Primary Energy	PEICD/V
Retail Electricity	ESICD/V
Total Industrial Sector	TEICD/V
Table 5: Transportation Sector
Name	Code
Coal	CLACD/V
Natural Gas	NGACD/V
Aviation Gasoline	AVACD/V
Distillate Fuel Oil	DFACD/V
Jet Fuel	JFACD/V
LPG	LGACD/V
Lubricants	LUACD/V
Motor Gasoline	MGACD/V
Residual Fuel Oil	RFACD/V
Total Petroleum	PAACD/V
Total Primary Energy	PEACD/V
Retail Electricity	ESACD/V
Total Transportation Sector	TEACD/V
Table 6: Electric Power Sector
Name	Code
Coal	CLEID/V
Natural Gas	NGEID/V
Residual Fuel Oil	RFEID/V
Distillate Fuel Oil	DKEID/V
Petroleum Coke	PCEID/V
Total Petroleum	PAEID/V
Nuclear Fuel	NUEGD/V
Biomass (Wood & Waste)	WWEID/V
Electricity Imports	ELIMD/V
Total Electric Power Sector	PEEID/V

* Appear only on U.S. tables

return to Appendix List

return to top

Appendix D

return to appendix list

Other Petroleum

In the Total Energy and Industrial Sector tables, “Other Petroleum” includes asphalt and road oil, aviation gasoline (total energy only), 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
Asphalt and Road Oil	ARTCD/V
Aviation Gasoline	AVTCD/V
Kerosene	KSTCD/V
Lubricants	LUTCD/V
Other Petroleum Products:	POTCD/V:
Petrochemical Feedstocks, Naptha	FNTCD/V
Petrochemical Feedstocks, Other Oils	FOTCD/V
Petrochemical Feedstocks, Still Gas	FSTCD/V
Petroleum Coke	PCTCD/V
Special Napthas	SNTCD/V
Waxes	WXTCD/V
Miscellaneous Products	MSTCD/V

Components of P1ICD/V
Asphalt and Road Oil	ARICD/V
Kerosene	KSICD/V
Lubricants	LUICD/V
Other Petroleum Products:	POICD/V:
Petrochemical Feedstocks, Naptha	FNICD/V
Petrochemical Feedstocks, Other Oils	FOICD/V
Petrochemical Feedstocks, Still Gas	FSICD/V
Petroleum Coke	PCICD/V
Special Napthas	SNICD/V
Waxes	WXICD/V
Miscellaneous Products	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 data are shown in Table TN55, 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
ENLCB	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 waste consumption, costed
WWCXB	Commercial wood and waste consumption at no cost
WWISB	Industrial wood and waste consumption, costed
WWIXB	Industrial wood and waste at no cost

return to top

Summary Table Codes
Column Heading	Table S1a	Table S1b	Column Heading	Table S2a	Table S2b
Coal	CLTCD	CLTCV	Coal	CLRCD	CLRCV
Natural Gas	NGTCD	NGTCV	Natural Gas	NGRCD	NGRCV
Distillate Fuel Oil	DFTCD	DFTCV	Distillate Fuel Oil	DFRCD	DFRCV
Jet Fuel	JFTCD	JFTCV	Kerosene	KSRCD	KSRCV
LPG	LGTCD	LGTCV	LPG	LGRCD	LGRCV
Motor Gasoline	MGTCD	MGTCV	Total Petroleum	PARCD	PARCV
Residual Fuel Oil	RFTCD	RFTCV	Wood	WDRCD	WDRCV
Other Petroleum	P1TCD	P1TCV	Total Primary Energy	PERCD	PERCV
Total Petroleum	PATCD	PATCV	Retail Electricity	ESRCD	ESRCV
Nuclear Fuel	NUTCD	NUTCV	Total Energy	TERCD	TERCV
Biomass (Wood & Waste)	WWTCD	WWTCV
Total Primary Energy	PETCD	PETCV
Electric Power Sector	PEEID	PEEIV
Retail Electricity	ESTCD	ESTCV
Total Energy	TETCD	TETCV

Column Heading	Table S3a	Table S3b	Column Heading	Table S4a	Table S4b
Coal	CLCCD	CLCCV	Coking Coal	CLKCD	CLKCV
Natural Gas	NGCCD	NGSSV	Steam Coal	CLOCD	CLOCV
Distillate Fuel Oil	DFCCD	DFCCV	Total Coal	CLICD	CLICV
Kerosene	KSCCD	KSCCV	Natural Gas	NGICD	NGICV
LPG	LGCCD	LGCCV	Distillate Fuel Oil	DFICD	DFICV
Motor Gasoline	MGCCD	MGCCV	LPG	LGICD	LGICV
Residual Fuel Oil	RFCCD	RFCCV	Motor Gasoline	MGICD	MGICV
Total Petroleum	PACCD	PACCV	Residual Fuel Oil	RFICD	RFICV
Biomass (Wood & Waste)	WWCCD	WWCCV	Other Petroleum	P1ICD	P1ICV
Total Primary Energy	PECCD	PECCV	Total Petroleum	PAICD	PAICV
Retail Electricity	ESCCD	ESCCV	Biomass (Wood & Waste)	WWICD	WWICV
Total Energy	TECCD	TECCV	Total Primary Energy	PEICD	PEICV
			Retail Electricity	ESICD	ESICV
			Total Energy	TEICD	TEICV

Column Heading	Table S5a	Table S5b	Column Heading	Table S6a	Table S6b
Coal	CLACD	CLACV	Coal	CLEID	CLEIV
Natural Gas	NGACD	NGACV	Natural Gas	NGEID	NGEIV
Aviation Gasoline	AVACD	AVACV	Residual Fuel Oil	RFEID	RFEIV
Distillate Fuel Oil	DFACD	DFACV	Distillate Fuel Oil	DKEID	DKEIV
Jet Fuel	JFACD	JFACV	Petroleum Coke	PCEID	PCEIV
LPG	LGACD	LGACV	Total Petroleum	PAEID	PAEIV
Lubricants	LUACD	LUACV	Nuclear Fuel	NUEGD	NUEGV
Motor Gasoline	MGACD	MGACV	Biomass (Wood & Waste)	WWEID	WWEIV
Residual Fuel Oil	RFACD	RFACV	Electricity Imports	ELIMD	ELIMV
Total Petroleum	PAACD	PAACV	Total Energy	PEEID	PEEIV
Total Primary Energy	PEACD	PEACV
Retail Electricity	ESACD	ESACV
Total Energy	TEACD	TEACV

Ranking Table Codes
Column Heading	Table R1	Table R2	Column Heading	Table R3	Column Heading	Table R4
Prices	TETCD	MGTCD	Petroleum Prices	PATCD	Coal Prices	CLTCD
Expenditures	TETCV	MGTCV	Petroleum Expenditures	PATCV	Coal Expenditures	CLTCV
Expenditures per Person	TETPV	MGTPV	Natural Gas Prices	NGTCD	Retail Electricity Prices	ESTCD
Expenditures as Share of Nominal GDP	TEGDS		Natural Gas Expenditures	NGTCV	Retail Electricity Expenditures	ESTCV

Prices and Expenditures (D/V) of Fuels and Electricity (By Energy Source)
Table 1: Total Energy
Name	Code
Coking Coal	CLKCD/V
Steam Coal	CLXCD/V
Coal	CLTCD/V
Exports of Coal Coke	CCEXD/V*
(CCEXD/V published as negative value, data stored as positive value)
Imports of Coal Coke	CCIMD/V*
Natural Gas	NGTCD/V
Distillate Fuel Oil	DFTCD/V
Jet Fuel	JFTCD/V
LPG	LGTCD/V
Motor Gasoline	MGTCD/V
Residual Fuel Oil	RFTCD/V
Other Petroleum	P1TCD/V
Total Petroleum	PATCD/V
Nuclear Fuel	NUETD/V
Biomass (Wood & Waste)	WWTCD/V
Primary Energy - Five Sectors	PETCD/V
Electric Power Sector	PEEID/V
(Published as negative value, data stored as positive value)
Retail Electricity	ESTCD/V
Total Energy	TETCD/V