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 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 48 values for the years 1960 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 consumption in physical units (i.e., short tons, barrels, cubic feet, etc.) or in billion 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 four files that contain data for all States and years available on the main SEDS page. Consumption, Physical Units, 1960-2007 contains the physical unit data for all States; Consumption, British Thermal Units, 1960-2007 contains the Btu data for all States. There are two data files for Thermal Conversion Factors. The CSV file U.S. Factors: Coal and Natural Gas by State contains all of the conversion factors used to convert data between physical units and Btu for all States. Coal and Natural Gas by State shows the State-level conversion factors for coal and natural gas in six Excel spreadsheets. 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 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. Appendix D shows individual petroleum products covered under "Other Petroleum" in the consumption tables.

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

The consumption data contained in SEDS and the methodologies used to derive them are described in the Consumption 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

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 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:

Other SEDS variables that do not follow this convention include:

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
G1TCB	ELISB	OTTCB	TERCB	TECCB	TEICB	TEACB

Table S2
CLTCP	NGTCP	DFTCP	JFTCP	LGTCP	MGTCP
RFTCP	P1TCP	PATCP	NUETP	HYTCP

Table S3
CLTCB	NGTCB	DFTCB	JFTCB	LGTCB	MGTCB	RFTCB	P1TCB
PATCB	NUETB	HYTCB	WWTCB	G1TCB	ELISB	OTTCB	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	DFICB	LGICB	MGICB	RFICB	P1ICB	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 R3
TETCB	GDPRX	TETGR

Table 7
CLTC	CCNI	NGTC	DFTC	JFTC	LGTC	MGTC	RFTC
P1TC	PATC	NUET	HYTC	WWTC	G1TC	OTTC	TETC

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

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

Table 10
CLIC	CCNI	NGIC	DFIC	LGIC	MGIC	RFIC	P1IC
PAIC	HYIC	WWIC	GEIC	ESIC	TNIC	LOIC	TEIC

Table 11
CLAC	NGAC	AVAC	DFAC	JFAC	LGAC	LUAC	MGAC
RFAC	PAAC	ENAC	ESAC	TNAC	LOAC	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	DFTC	JFTC	LGTC	MGTC	RFTC	P1TC
PATC	NUET	HYTC	WWTC	G1TC	ELIS	OTTC	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	DFIC	LGIC	MGIC	RFIC	P1IC	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

Tables D1-D4: GDPRX

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 Consumption Technical Notes. Data for the detailed products are available in the CSV file.