Annual Electric Utility Data - EIA-861 Data File

Home > Electricity > Electricity Database Files >

Form EIA-` i )'o^ t _ 11mabase

Annual Electric av^er 'Adustry Data

Reporting Issues for California Power

Sales and Revenues in 2003 (prelimina ry)

Effective January 17, 2001, the California State legislature authorized the California

Department of Water Resources (CDWR) to purchase wholesale power for California retail

consumers. This action was a result of the very high wholesale power prices and power

shortages experienced in California in 2000 and 2001, and associated financial problems

encountered by the State's large investor-owned utilities (IOUs). The Electric Fund's

support for California ratepayers has declined slightly each year since 2001 and currently

includes only long-term contracts put in place in that year. These long-term contracts will

operate for years to come.

Data related to the CDWR's intervention in the California crisis are included in Filel and

Filc3 of this 2003 preliminary file, available below under the new entity "Electric Fund

(CDWR.)" with EIA code 3288.

Users of the data should be aware that substantial definitional differences exist with

regard to the type of transactions (wholesale or retail) between the Electric Fund

(CDWR), the State's investor-owned utilities, and the California ratepayers. The EIA

representation of sales in File3 by the Electric Fund (CDWR) as retail sales direct to

;California ratepayers was agreed to by the CDWR and the three major

investor-owned California respondents.

Form EIA-861 Final Data File for 2003

This is an electric utility data file that includes such information as peak load, generation, electric purchases,

sales, revenues, and customer counts. The data source is the survey Form EIA-861, "Annual Electric Power

Industry Report." Data for all years are final.

The file F861yr03.exe is a final file of data collected on the Form EIA-861, Annual Electric Power Industry

Report, for the reporting period, calendar year 2003. The zipped exe file contains formatted xls and .dbf files

suitable for importing into spreadsheet or database programs.

o Filet contains aggregate operational data such as control area operators, energy balance, and revenue

information from each electric utility in the country, including power marketers, and Federal power

marketing administrations.

1 of 3 6/10/2005 2:27 PM

 EE-RM/STD-00-550 COMMENT 86

Annual Electric Utility Data - EIA-861 Data File 

10f3 

Home> Electricity> Electricity Database files> 

E 1 base 

Annual Electric Power Industry Data 

Issues 

Sales and Revenues in 

!EJIective January 17, 2001, the California State legislature authorized the California 

jDepartment ofWatcr Resources (CDWR) to purchase wholesale power for California retail 

I consumers. This action was a result of the very high wholesale power prices and power 

ishortages experienced in California in 2000 and 2001, and associated financial problems 

encountered by the State's large investor-owned utilities (lOUs). The Electric Fund's 

support for California ratepayers has declined slightly each year since 2001 and currently 

includes only long-term contracts put in place in that year. These long-term contracts will 

I 

;operate for years to come. 

i 

Data related to the CDWR's intervention in the California crisis are included in Filel and 

File3 of this 2003 preliminary file, available below under the new entity "Electric Fund 

(CDWR)" with ETA code 3288. 

IUsers of the data should be aware substantial definitional differences exist with 

regard to the type of transactions (wholesale or retail) between the Electric Fund 

(CDWR), the State's investor-owned utilities, and the California ratepayers. The EIA 

Irepresentation of sales in File3 by the Electric Fund (CDWR) as retail sales direct to 

ICalifornia ratepayers was agreed to by the CD\VR and the three major 

linvestor-owned California respondents. ---------~--~--~-- --~-~-~---.--~-~--~----.--~- --~.~--~--~--~--~------

Form EIA·861 Final Data File for 2003 

This is an electric utility data file that includes such information as peak load, generation, electric purchases, 

sales, revenues, and customer counts. The data source is the survey Form EIA-86 1 , "Annual Electric Power 

Industry Report." Data for all years are final. 

The file F86I yr03 .exe is a final file of data collected on the Form EIA -861, Annual Electric Power Industry 

Report, for the reporting period, calendar year 2003. The zipped .exe file contains formatted .xls and .dbffiles 

suitable for importing into spreadsheet or database programs. 

CII Filel contains aggregate operational data such as control area operators, energy balance, and revenue 

information from each electric utility in the country, including power marketers, and Federal power 

marketing administrations. 

611 0/2005 2:27 PM 
Annual Electric Utility Data - EIA-861 Data File

o Filet contains information on retail revenue, sales, customer counts and average retail price, by State

and class of service, for each electric distribution utility, for all consumers provided fully bundled

electric service (both energy and delivery service) by a single electric utility in all 50 States, the District

of Columbia, the Dominion of Puerto Rico, and the Territories of American Samoa, Guam, and the

Virgin Islands. For the 2003 period forward, the Transportation consumer sector replaces the Other

sector which included public street lighting, public buildings, electrified rail and transit systems and

some agricultural sector data such as irrigation load. The Transportation sector consists entirely of

electrified rail and urban transit systems. Data previously reported as the "Other" consumer sector have

been reclassified as Commercial sector activity for 2003. Agricultural data (i.e., irrigation load)

previously reported in the Other sector have been reclassified as Industrial sector activity.

o File 2U (new in 2003) contains revenue, sales and customer counts by State and class of service for

unregulated facilities reporting retail sales activity.

o File3 contains information on retail revenue, sales, and customer counts, by State and class of service,

for customers who selected alternate energy service providers in States that have deregulated their retail

electricity markets, either fully or partially. The revenue reported is the revenue received only for the

energy portion of the customer's bill, (revenue for delivery services is not included). For information on

the new Transportation consumer sector, see the note for File2 above. File3 does not contain balancing

data in the amount of 14.8 billion kWh.

o File3d contains information on the delivery of power to customers who selected alternate power

suppliers in State-level, "retail wheeling" programs. The revenue, megawatthours, and consumer count

information in this file was reported by distribution utilities delivering power sold by other energy

suppliers. The revenue represents revenue reported by the distribution utility for the delivery services

provided to customers who were sold power by others, usually competitive retail energy service

providers (ESPs). The megawatthours shown are the delivered megawatthours sold by the ESPs (and

reported by ESPs as shown in File3.dbf) to customers who switched energy suppliers in the distribution

utility's service area. The revenue associated with delivery supplements the energy revenue shown in

File3.dbf. The megawatthours and customer counts in file 3d, however are duplicative of the

megawatthours and customers counts shown in File3.dbf, and cannot be used to derive national, Census

division, or State-level sales and revenue totals. For information on the new Transportation consumer

sector, see the note for File2 above.

® File4 contains information on electric utility demand-side management programs, including energy

efficiency and load management effects and expenditures. For information on the new Transportation

consumer sector, see the note for Filet above.

• FileS contains the names of the counties, by State, in which the respondent has equipment for the

distribution of electricity to ultimate consumers.

• File6 contains energy balance data reported by non-utility generators.

® File? (new in 2003) displays State level components from bundled and unbundled providers,

unregulated facilities with retail sales, and balance adjustments.

Note: All sales data, including energy efficiency savings, are in megawatthours, peak and peak

reduction data are in megawatts for 2001 , 2002, and 2003 and kilowatts for previous years , all revenue

and expenditure data are in thousand -dollar units.

Final data for the years 1999 through 2003 are in self-extracting zip files which expand into Excel files

(filel.xls, file6.xls, and file7.xls), and DBF files (file2.dbf, file3.dbf, file4.dbf, and file5.dbf) where "filel"

contains data collected on Schedule II, and Schedule III of the Form EIA-861 for utilities and non-traditional

power marketers; "file 2" contains information on State-level retail sales in all States, by traditional utilities

only, collected on Schedule IV; "file3" contains information on State-level, retail sales in deregulated markets

in all States, for non-traditional energy service providers; "file4" contains information on utility demand-side

management programs collected on Schedule V; "files" contains information on utility service territories

(county-level) collected on Schedule VII of the Form EIA-861; file 6 (2002 and 2003 only) contains sources

2 of 3 6/10/2005 2:27 PM

 EE-RM/STD-00-550 COMMENT 86

Annual Electric Utility Data - EIA-861 Data File 

20f3 

• File2 contains information on retail revenue, sales, customer counts and average retail price, by State 

and class of service, for each electric distribution utility, for all consumers provided fully bundled 

electric service (both energy and delivery service) by a single electric utility in all 50 States, the District 

of Columbia, the Dominion of Puerto Rico, and the Territories of American Samoa, Guam, and the 

Virgin Islands. For the 2003 period forward, the Transportation consumer sector replaces the Other 

sector which included public street lighting, public buildings, electrified rail and transit systems and 

some agricultural sector data such as irrigation load. The Transportation sector consists entirely of 

electrified rail and urban transit systems. Data previously reported as the "Other" consumer sector have 

been reclassified as Commercial sector activity for 2003. Agricultural data (i.e., irrigation load) 

previously reported in the Other sector have been reclassified as Industrial sector activity. 

• File 2U (new in 2003) contains revenue, sales and customer counts by State and class of service for 

unregulated facilities reporting retail sales activity. 

• File3 contains information on retail revenue, sales, and customer counts, by State and class of service, 

for customers who selected alternate energy service providers in States that have deregulated their retail 

electricity markets, either fully or partially. The revenue reported is the revenue received only for the 

energy portion of the customer's bill, (revenue for delivery services is not included). For information on 

the new Transportation consumer sector, see the note for File2 above. File3 does not contain balancing 

data in the amount of 14.8 billion kWh. 

• File3d contains information on the delivery of power to customers who selected alternate power 

suppliers in State-level, "retail wheeling" programs. The revenue, megawatthours, and consumer count 

information in this file was reported by distribution utilities delivering power sold by other energy 

suppliers. The revenue represents revenue reported by the distribution utility for the delivery services 

provided to customers who were sold power by others, usually competitive retail energy service 

providers (ESPs). The megawatthours shown are the delivered megawatthours sold by the ESPs (and 

reported by ESPs as shown in File3.dbf) to customers who switched energy suppliers in the distribution 

utility's service area. The revenue associated with delivery supplements the energy revenue shown in 

File3.dbf. The megawatthours and customer counts in file 3d, however are duplicative of the 

megawatthours and customers counts shown in File3.dbf, and cannot be used to derive national, Census 

division, or State-level sales and revenue totals. For information on the new Transportation consumer 

sector, see the note for File2 above. 

ED File4 contains information on electric utility demand-side management programs, including energy 

efficiency and load management effects and expenditures. For information on the new Transportation 

consumer sector, see the note for File2 above. 

ED File5 contains the names of the counties, by State, in which the respondent has equipment for the 

distribution of electricity to ultimate consumers. 

• File6 contains energy balance data reported by non-utility generators . 

., File7 (new in 2003) displays State level components from bundled and unbundled providers, 

unregulated facilities with retail sales, and balance adjustments. 

Note: All sales data, including energy efficiency savings, are in megawatthours, peak and peak 

reduction data are in megawatts for 2001, 2002, and 2003 and kilowatts for previous years, all revenue 

and expenditure data are in thousand-dollar units. 

Final data for the years 1999 through 2003 are in self-extracting zip files which expand into Excel files 

(filel.xls, file6.xls, and file7.xls), and DBF files (file2.dbf, file3.dbf, file4.dbf, and file5.dbf) where "file 1 " 

contains data collected on Schedule II, and Schedule III of the Form EIA -861 for utilities and non-traditional 

power marketers; "file 2" contains information on State-level retail sales in all States, by traditional utilities 

only, collected on Schedule IV; "file3" contains information on State-level, retail sales in deregulated markets 

in all States, for non-traditional energy service providers; "file4" contains information on utility demand-side 

management programs collected on Schedule V; "file5" contains information on utility service territories 

(county-level) collected on Schedule VII of the Form EIA-861; file 6 (2002 and 2003 only) contains sources 

6/1 012005 2:27 PM 
Annual Electric Utility Data - EIA-861 Data File

and disposition electricity reported by non-utility generators; and file 7 contains State-level retail sales by

sector.

Final data for the years 1990 through 1998 are in self-extracting zip files which expand into 5 DBF files

(F861TYP1.DBF, F861TY2A.DBF, F861TY2B.DBF, F861TYP3.DBF, F861TYP7DBF); and Notepad

versions of the file layout ("layout"), the Form EIA-861 (WordPerfect), and EIA-861 Instructions (instr.wpd).

To expand the file, type F861yy.EXE* (requires 5-6 megs space). The file structure for the years 1990

through 1998 differs from that for the files from 1999 through 2003 described in the preceding paragraph. The

primary difference is that file F861TYP1.DBF contains a combination of data available in the 1999, 2000,

2001, 2002 and 2003 files in filel.xls and file2.dbf. Utility retail sales data, for utilities with sales in 3 or

more States are shown in F861TYP3.dbf for the third, fourth, fifth, etc., States. Utility Demand-side

Management information for the years 1990 through 1998 is available in F861TY2A.DBF and

F861TY2B.DBF.

*Note: Substitute the applicable year for "yy" in the file name.

File Size: 550 k

Year 2003E 2002F2001F 2000E 1999E 1998 [1 997 [199611995 11994 [ 1993 1992 1991 [1990.

DBF

Formats

ZIP

DBF DBF

ZIP ZIP

DBF

ZIP

DBF

ZIP

DBF

ZIP

DBF

ZIP

DBF DBF DBF

ZIP ZIP ZIP

DBFi

ZIP

DBF

ZIP

DBF

ZIP

DBF

ZIP

P=Preliminary Data. F=Final Data.

View Contact Information for Electric Utilities Selling to Ultimate Consumers, by State and Utility

Contact:

Rodney Dunn

(202) 287-1676

Internet E-Mail: rodney.dunnCc^,eia.doe. gov

EIA Home

Contact Us

Page last modified on Tue Mar 15 2005 07:26:17 GMT-0 800 (Pacific Standard Time).

URL: http://www.ela.doe.gov/cneaf/electricity/page/eia86l.htmi

Download

3 of 3 6/10/2005 2:27 PM

 EE-RM/STD-00-550 COMMENT 86

Annual Electric Utility Data - EIA-861 Data File 

30f3 

and disposition electricity reported by non-utility generators; and file 7 contains State-level retail sales by 

sector. 

Final data for the years 1990 through 1998 are in self-extracting zip files which expand into 5 DBF files 

(F861 TYP1.DBF, F861 TY2A.DBF, F861 TY2B.DBF, F861 TYP3.DBF, F861 TYP7DBF); and Notepad 

versions of the file layout ("layout"), the Form EIA-861 (WordPerfect), and EIA-861 Instructions (instr.wpd). 

To expand the file, type F861yy.EXE* (requires 5-6 megs space). The file structure for the years 1990 

through 1998 differs from that for the files from 1999 through 2003 described in the preceding paragraph. The 

primary difference is that file F861TYP1.DBF contains a combination of data available in the 1999,2000, 

2001,2002 and 2003 files in file1.xls and file2.dbf. Utility retail sales data, for utilities with sales in 3 or 

more States are shown in F861 TYP3.dbffor the third, fourth, fifth, etc., States. Utility Demand-side 

Management information for the years 1990 through 1998 is available in F861 TY2A.DBF and 

F861TY2B.DBF. 

*Note: Substitute the applicable year for "yy" in the file name. 

File Size: 550 k 

P=Preliminary Data. F=Final Data. 

View Contact Information for Electric Utilities Selling to Ultimate Consumers, by State and Utility 

Contact: 

Rodney Dunn 

(202) 287-1676 

Internet E-Mail: rodney.dunn@eia.doe.gov 

EIA Home 

Contact Us 

Page last modified on Tue Mar 15 200507:26:17 GMT-0800 (Pacific Standard Time). 

URL: http://www.eia.doe.gov/cneaf/electricity/page/eia861.htmi 

6110/20052:27 PM