Annual Electric Utility Data - EIA-861 Data File http://www.eia.doe.gov/eneaf/electricity/page/eia861.htmi

Home > Electricity > Electricity Database Files >



# Form EIA-861 Database Annual Electric Power Industry Data

Reporting Issues for California Power sales and Revenues in 2003 (preliminary) 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 File3 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-86 1, "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 9/26/2005 2:54 PM Annual Electric Utility Data

- EIA-861 Data File http://www.eia.doe.gOY1 cneaflelectricity/pagel eia861.html

10f3 Home> Electricity> Electricity Database files> 

# 1 Database Annual Electric Power Industry Data**---------~-~--~~------~-~-~------ -.-~~-~-**  ...**~~~-** rU",!rtin:n Issues for California ""'",>AU',,. Sales and Revenues in (preliminary) i

### Effective January 17, 2001, the California State legislature authorized the California Department ofWater Resources (CDWR) to purchase wholesale power for California retail consumers. This action was a result of the very high wholesale power prices and power

i

### shortages experienced in California in 2000 and 200I, and associated financial problems lencountered by the State's large investor-owned utilities (IOUs). The Electric Fund's suppOli 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 File! and lFile3 of this 2003 preliminary file, available below under the new entity "Electric Fund i(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 Elech'ic (CDWR), the State's investor-owned utilities, and the California ratepayers. The EIA \representation of sales in File3 by the Electric Fund (CD'WR) 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-861, "Annual Electric Power Industry Report." Data for all years are final. The file F86lyr03.exe is a final file ofdata collected onthe 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.

ED 

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

information from each electric utility inthe country, including powermarketers, and Federal power marketing administrations.

9/26/2005 2:54 PMAnnual Electric Utility Data - EIA-861 Data File http://www.eia.doe.gov/cneaf/electricity/page/eia861.html

o 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. 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. • 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. o 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. o Files contains the names of the counties, by State, in which the respondent has equipment for the distribution of electricity to ultimate consumers. o 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 "filet" 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; "fle3" 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 9/26/2005 2:54 PM Annual Electric Utility Data

- EIA-861 Data File http://www

.eia.doe.gOY/cneaf/ electricity /page/ eia861.html**~** of3 lID File2 contains information on retail revenue, sales, customer counts and average retail price, by State and class ofservice, for each electric distribution utility, for all consumers provided fully bundled electric service (both energy and delivery service) by a single electric utility in alISO States, the District ofColumbia, the Dominion ofPuerto Rico, and the Territories ofAmerican Samoa, Guam, and the Virgin Islands. Forthe 2003 period forward, the Transportation consumer sectorreplaces 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 urbantransit systems. Datapreviously reported as the "Other" consumer sectorhave beenreclassified 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.
lID File 2U (new in 2003) contains revenue, sales and customer counts by State and class ofservice for

unregulated facilities reporting retail sales activity.
lID File3 contains information onretail revenue, sales, and customer counts, by State and class ofservice, for customers who selected alternate energy service providers in States that have deregulated theirretail electricity markets, either fully orpartially. The revenue reported is the revenue received only for the energyportion ofthe customer's bill, (revenue for delivery services is not included). Forinformation on the new Transportation consumer sector, see the note for File2 above. File3 does not containbalancing data in the amount of 14.8 billionkWh. lID File3d contains information onthe delivery ofpowerto 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 soldby other energy suppliers. The revenue represents revenue reported by the distribution utility for the delivery services providedto customers who were soldpowerby others, usually competitive retail energy service providers (ESPs). The megawatthours shown are the delivered megawatthours soldbythe ESPs (and reported byESPs 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 energyrevenue shown in File3.dbf. The megawatthours and customer counts in file 3d, however are duplicative ofthe megawatthours and customers counts shown in File3.dbf, and cannotbeused to derive national, Census division, or State-level sales andrevenue totals. For information on the new Transportation consumer sector, see the note for File2 above.
lID File4 contains information on electric utility demand-side managementprograms, including energy efficiency and loadmanagement effects and expenditures. For information on the new Transportation consumer sector, see the note for File2 above. • FileS contains the names ofthe counties, by State, in which the respondent has equipment for the

distribution ofelectricity to ultimate consumers. • File6 contains energybalance data reported bynon-utility generators. • File7 (new in 2003) displays State level components from bundled and unbundled providers,

unregulated facilities withretail 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 (file1.xls, file6.xls, and file7.xls), and DBF files (file2.dbf, file3.dbf, file4.dbf, and fileS.dbf) where "file1 " contains data collected on Schedule II, and Schedule III ofthe FormEIA-861 for utilities and non-traditional powermarketers; "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 managementprograms collected on Schedule V; "fileS" contains information on utility service territories (county-level) collected on Schedule VII ofthe Form EIA-861; file 6 (2002 and 2003 only) contains sources

912612005 2:54 PMAnnual Electric Utility Data - EIA-861 Data File http://www.eia.doe.gov/cneaf/electricity/page/eia861.html

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

Download Year 2 i 2002F 2 0 0 1 2000E 1999 '1998 1997 1996 1995 1994 1993 1992 1991 1990] DBF DBF ^^ DBF DBF DBF DBF DBF DBF DBF DBF DBF DBF DBF DBF Formats ZIP ZIP ZIP - ZIP



# ____ ,-

ZIP ZIP 

# F_ ZIP Z T IP ZIP ZIP ZIP _ ZIP ZIP 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.dunn(&,eia.doe. gov

EIA Home Contact Us Page last modified on Mon Jun 27 2005 07:00 : 28 GMT-0700 (Pacific Daylight Time). URL: http ://www.eia

.doe.gov/cneaf/electricity/page/eia861

.htmI

3 of 3 9/26/2005 2:54 PM Annual Electric Utility Data

- EIA-861 DataFile http://www

.eia.doe.gOY 1 cneafl electricity Ipageleia861.html

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 (F861TYP1.DBF, F861TY2A.DBF, F861TY2B.DBF, F861TYP3.DBF, F861TYP7DBF); and Notepad versions ofthe file layout ("layout"), the Form EIA-861 (WordPerfect), and EIA-861 Instructions (instr.wpd). To expandthe 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 precedingparagraph. The primary difference is that file F861TYPl.DBF contains a combination ofdata available inthe 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.dbffor 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

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 Mon lun 27 2005 07:00:28 GMT-0700 (Pacific Daylight Time). URL: http://www.eia.doe.gov/cneaf/electricity/page/eia861.html

9/26120052:54 PM