SEDS CSV File Documentation: Price and Expenditure

State Energy Data System CSV File Documentation

Prices and Expenditures

Last updated: 03/12/2008 (PED)

The State Energy Data System (SEDS) comma-separated value (CSV) files contain the price and expenditure data shown in the tables located on the SEDS web page at http://www.eia.doe.gov/emeu/states/_seds.html. 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 36 values for the years 1970 through 2005, 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 State data page http://www.eia.doe.gov/emeu/states/_seds.html. "Prices, 1970-2005" (pr_all.csv or the compressed pr_all.zip) contains the price data for all States, and "Expenditures, 1970-2005" (ex_all.csv or the compressed ex_all.zip) contains the expenditure data for all States. The third file, "Adjusted Consumption for Expenditure Calculations" (pr_adjust_consum.csv) contains adjusted consumption data used in calculating expenditures for all States and years.

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 at http://www.eia.doe.gov/emeu/states/_seds_tech_notes.html 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 2005. A discussion of the consumption estimation methodologies is contained in the SEDS Consumption Technical Notes available at the same Web page. 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 Technical Notes explains the adjustments. The SEDS consumption tables are available on the same main State data 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 available at:

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

Copies of the report can 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

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

Appendix B

Data Identification Codes

Characters Identity

1 and 2
represent an Energy Source

3 and 4
represent an Energy Consumption End-Use 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
DK	distillate fuel, 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
NU	nuclear electric power
P1	selected petroleum products subtotal
PA	all petroleum products
PC	petroleum coke
PE	primary energy
PO	other petroleum products
RF	residual fuel
SN	special naphtha
TE	total energy
TP	resident population
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 End-Use Sectors (Characters 3 and 4)
Code	Name
AC	transportation sector estimates
CC	commercial sector estimates
EI	electric power sector estimates
EU	electric utility 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
OP	resident population including Armed Forces
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)
P	population - thousand people
D	price in nominal dollars per million Btu
V	expenditures in million nominal dollars

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 DFTCD DFTCV Distillate Fuel 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 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 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 DFCCD DFCCV Total Coal CLICD CLICV

Kerosene KSCCD KSCCV Natural Gas NGICD NGICV

LPG LGCCD LGCCV Asphalt and Road Oil ARICD ARICV

Motor Gasoline MGCCD MGCCV Distillate Fuel DFICD DFICV

Residual Fuel RFCCD RFCCV Kerosene KSICD KSICV

Total Petroleum PACCD PACCV LPG LGICD LGICV

Biomass WWCCD WWCCV Lubricants LUICD LUICV

Total Primary Energy PECCD PECCV Motor Gasoline MGICD MGICV

Retail Electricity ESCCD ESCCV Residual Fuel RFICD RFICV

Total Energy TECCD TECCV Other Petroleum POICD POICV
Total Petroleum PAICD PAICV
Biomass WWICD WWICV
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 RFEID RFEIV

Distillate Fuel DFACD DFACV Distillate Fuel 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 WWEID WWEIV

Residual Fuel 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
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

DFTCD/V

Jet Fuel

JFTCD/V

LPG

LGTCD/V

Motor Gasoline

MGTCD/V

Residual Fuel

RFTCD/V

Other Petroleum

P1TCD/V

Total Petroleum

PATCD/V

Nuclear Fuel

NUETD/V

Biomass

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	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	DFCCD/V
Kerosene	KSCCD/V
LPG	LGCCD/V
Motor Gasoline	MGCCD/V
Residual Fuel	RFCCD/V
Total Petroleum	PACCD/V
Biomass	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
Asphalt and Road Oil	ARICD/V
Distillate Fuel	DFICD/V
Kerosene	KSICD/V
LPG	LGICD/V
Lubricants	LUICD/V
Motor Gasoline	MGICD/V
Residual Fuel	RFICD/V
Other Petroleum	POICD/V
Total Petroleum	PAICD/V
Biomass	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	DFACD/V
Jet Fuel	JFACD/V
LPG	LGACD/V
Lubricants	LUACD/V
Motor Gasoline	MGACD/V
Residual Fuel	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	RFEID/V
Distillate Fuel	DKEID/V
Petroleum Coke	PCEID/V
Total Petroleum	PAEID/V
Nuclear Fuel	NUEGD/V
Biomass	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

Individual petroleum products covered under "Other Petroleum" used in the industrial sector are shown in the following list. Numerical values are shown in the SEDS Price and Expenditure Technical Notes Table TN48.

Industrial Sector Prices and Expenditures
Miscellaneous Products	MSICD/V
Petrochemical Feedstocks: Naphtha Other Oils Still Gas	FNICD/V FOICD/V FSICD/V
Petroleum Coke	PCICD/V
Special Naphthas	SNICD
Waxes	WXICD/V
Average Price and Expenditure	POICD/V

In the Total Energy tables, "Other Petroleum" (P1TCD/V) also includes asphalt and road oil, aviation gasoline, kerosene, and lubricants.

return to top

Appendix E

return to Appendix List

Consumption Adjustments for Calculating Expenditures

Process fuel, intermediate product, adjusted consumption and uncosted renewable consumption variables included in these files are in a CSV file named "Adjusted Consumption for Expenditure Calculations" (pr_adjust_consum.csv). 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 SEDS Price and Expenditure Table TN55. In all cases, SEDS consumption minus process fuel, intermediate product, or uncosted renewables consumption equals adjusted consumption used in the price and expenditure tables.

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 consumption, costed
DFRFB	Distillate fuel used at refineries
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 consumption, costed
RFRFB	Residual fuel 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

Data Identification Codes
Characters	Identity
1 and 2	represent an Energy Source
3 and 4	represent an Energy Consumption End-Use Sector or an Energy Activity
5	represents a Type of Data

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	DFTCD	DFTCV	Distillate Fuel	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	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	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	DFCCD	DFCCV	Total Coal	CLICD	CLICV
Kerosene	KSCCD	KSCCV	Natural Gas	NGICD	NGICV
LPG	LGCCD	LGCCV	Asphalt and Road Oil	ARICD	ARICV
Motor Gasoline	MGCCD	MGCCV	Distillate Fuel	DFICD	DFICV
Residual Fuel	RFCCD	RFCCV	Kerosene	KSICD	KSICV
Total Petroleum	PACCD	PACCV	LPG	LGICD	LGICV
Biomass	WWCCD	WWCCV	Lubricants	LUICD	LUICV
Total Primary Energy	PECCD	PECCV	Motor Gasoline	MGICD	MGICV
Retail Electricity	ESCCD	ESCCV	Residual Fuel	RFICD	RFICV
Total Energy	TECCD	TECCV	Other Petroleum	POICD	POICV
			Total Petroleum	PAICD	PAICV
			Biomass	WWICD	WWICV
			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	RFEID	RFEIV
Distillate Fuel	DFACD	DFACV	Distillate Fuel	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	WWEID	WWEIV
Residual Fuel	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
			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	DFTCD/V
Jet Fuel	JFTCD/V
LPG	LGTCD/V
Motor Gasoline	MGTCD/V
Residual Fuel	RFTCD/V
Other Petroleum	P1TCD/V
Total Petroleum	PATCD/V
Nuclear Fuel	NUETD/V
Biomass	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