State Energy Data System CSV File Documentation

Consumption

The State Energy Data System (SEDS) comma-separated value (CSV) files contain consumption 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 46 values for the years 1960 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 consumption in physical units (i.e., short tons, barrels, cubic feet, etc.) or in British thermal units (Btu).

There is a 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 on the main State data page, http://www.eia.doe.gov/emeu/states/_seds.html. "Consumption, Physical Units, 1960-2005" (use_all_phy.csv or the compressed use_all_phy.zip) contains the physical unit data for all States; "Consumption, British Thermal Units, 1960-2005" (use_all_btu.csv or the compressed use_all_btu.zip) contains the Btu data for all States. The third file, "Thermal Convertion Factors" (use_confac.csv) contains all of the conversion factors used to convert data between physical units and Btus for all States.

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 Consumption Technical Notes for a discussion of estimation methodologies for specific data series.

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 "Other Petroleum Products" used in the industrial sector, the breakout of natural gas used as lease and plant fuel, the breakout of types of jet fuel in the transportation sector, and the breakout of wood and waste for each of the consuming sectors.

The following appendices explain the data identification codes used in the files. Appendix A lists the State codes. Appendix B gives brief definitions of the components of the variable names. Appendix C lists the specific data series shown in the SEDS tables.

List of Appendices
A	State Codes
B	Data Identification Codes
C	List of Data Codes shown in Tables

To fully understand and utilize the data files, recipients should read the documentation in the Technical Notes available on at:

Contacts:

The State Energy Data System tables were 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 State Energy Data System or these files may be referred to Yvonne Taylor, 202-586-1455, or yvonne.taylor@eia.doe.gov

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

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

The following codes represent the four end-use consuming sectors, electric power, and total energy consumption:

The following codes represent energy activities used in intermediate calculations for deriving the major end-use consumption estimates:

Energy Activities (Characters 3 and 4)
Code	Name
EG	electricity net generation
EX	exports
IM	imports
IS	interstate sales (of electricity)
KC	coke plants estimated consumption
LP	lease and plant fuel
NI	net imports
OC	industrial estimated consumption, excluding coke plants
OP	population
PZ	pipeline fuel
TP	total estimated consumption per capita
TX	all sectors except electric power
VH	vehicle fuel

Types (Character 5)
Code	Name
B	data in billion British thermal units (Btu)
P	data in physical units:   petroleum - thousand barrels   natural gas - million cubic feet   coal - thousand short tons   electricity - million kilowatthours   population - thousand people
K	conversion factor:   petroleum - (US only) barrels   natural gas - cubic feet   coal - short tons   electricity - (US only) kilowatthours

The following section lists the SEDS variables in the order they appear in the SEDS consumption tables. Each table column contains one variable. Variables with only four letters indicate that both physical unit and Btu values appear on the table.

Table S1
TETCB	CLTCB	NGTCB	PATCB	NUETB	HYTCB	WWTCB
GOTCB	ELISB	TERCB	TECCB	TEICB	TEACB

Table S2
CLTCP	NGTCP	ARTCP	AVTCP	DFTCP	JFTCP	KSTCP	LGTCP
LUTCP	MGTCP	RFTCP	POTCP	PATCP	NUETP	HYTCP

Table S3
CLTCB	NGTCB	ARTCB	AVTCB	DFTCB	JFTCB	KSTCB
LGTCB	LUTCB	MGTCB	RFTCB	POTCB	PATCB	NUETB
HYTCB	WWTCB	GOTCB	ELISB	TETCB

Table S4
CLRCB	NGRCB	DFRCB	KSRCB	LGRCB	PARCB	WDRCB
GERCB	SOHCB	ESRCB	TNRCB	LORCB	TERCB

Table S5
CLCCB	NGCCB	DFCCB	KSCCB	LGCCB	MGCCB	RFCCB	PACCB
HYCCB	WWCCB	GECCB	ESCCB	TNCCB	LOCCB	TECCB

Table S6
CLICB	NGICB	ARICB	DFICB	KSICB	LGICB	LUICB	MGICB	RFICB
POICB	PAICB	HYICB	WWICB	GEICB	ESICB	TNICB	LOICB	TEICB

Table S7
CLACB	NGACB	AVACB	DFACB	JFACB	LGACB	LUACB	MGACB
RFACB	PAACB	ENACB	ESACB	TNACB	LOACB	TEACB

Table S8
CLEIB	NGEIB	RFEIB	DKEIB	PCEIB	PAEIB	NUEGB
HYEGB	WWEIB	GEEGB	SOEGB	WYEGB	ELNIB	TEEIB

Table R1
TERCB	TECCB	TEICB	TEACB	TETCB

Table R2
CLTCB	NGTCB	PATCB	ESTCB	TETPB

Table 7
CLTC	CCNI	NGTC	ARTC	AVTC	DFTC	JFTC	KSTC	LGTC	LUTC
MGTC	RFTC	POTC	PATC	NUET	HYTC	WWTC	GOTC	TETC

Table 8
CLRC	NGRC	DFRC	KSRC	LGRC	PARC	WDRC
GERC	SOHC	ESRC	LORC	TNRC	TERC

Table 9
CLCC	NGCC	DFCC	KSCC	LGCC	MGCC	RFCC	PACC
HYCC	WWCC	GECC	ESCC	LOCC	TNCC	TECC

Table 10
CLIC	CCNI	NGIC	ARIC	DFIC	KSIC	LGIC	LUIC	MGIC	RFIC
POIC	PAIC	HYIC	WWIC	GEIC	ESIC	LOIC	TNIC	TEIC

Table 11
CLAC	NGAC	AVAC	DFAC	JFAC	LGAC	LUAC	MGAC
RFAC	PAAC	ENAC	ESAC	LOAC	TNAC	TEAC

Table 12
CLEI	NGEI	RFEI	DKEI	PCEI	PAEI	NUEG
HYEG	WWEI	GEEG	SOEG	WYEG	ELNI	TEEI

State Tables, Total Consumption (Table 7 for every State)
CLTC	NGTC	ARTC	AVTC	DFTC	JFTC	KSTC	LGTC	LUTC	MGTC
RFTC	POTC	PATC	NUET	HYTC	WWTC	GOTC	ELIS	TETC

State Tables, Residential Consumption (Table 8 for every State)
CLRC	NGRC	DFRC	KSRC	LGRC	PARC	WDRC
GERC	SOHC	ESRC	TNRC	LORC	TERC

State Tables, Commercial Consumption (Table 9 for every State)
CLCC	NGCC	DFCC	KSCC	LGCC	MGCC	RFCC	PACC
HYCC	WWCC	GECC	ESCC	TNCC	LOCC	TECC

State Tables, Industrial Consumption (Table 10 for every State)
CLIC	NGIC	ARIC	DFIC	KSIC	LGIC	LUIC	MGIC	RFIC
POIC	PAIC	HYIC	WWIC	GEIC	ESIC	TNIC	LOIC	TEIC

State Tables, Transportation Consumption (Table 11 for every State)
CLAC	NGAC	AVAC	DFAC	JFAC	LGAC	LUAC	MGAC
RFAC	PAAC	ENAC	ESAC	TNAC	LOAC	TEAC

State Tables, Electric Power Consumption (Table 12 for every State)
CLEI	NGEI	RFEI	DKEI	PCEI	PAEI	NUEG
HYEG	WWEG	GEEG	SOEG	WYEG	ELNI	TEEI

Tables B2, B3: NGEIK

Tables B4, B5: NGTXK

Tables B6, B7: NGTCK

Tables B8, B9: CLHCK

Tables B10, B11: CLOCK

Tables B12, B13: CLEIK

Tables C1-C5: TPOPP