Annual Electric Utility Data - EIA-861 Data File

Home > Electricity > Electricity Database Files >



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

ma

# base A

### nnual E

## lectric av^er 'Adustry D

### ata

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 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 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 ofthe 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 ofthe 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 peakload, 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 F86Iyr03.exe is a final file ofdata collected onthe Form EIA-861, Annual Electric Power Industry Report, for the reporting period, calendaryear 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 inthe country, including powermarketers, and Federal power marketing administrations.

611 0/2005 2:27 PMAnnual 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 Annual Electric Utility Data

- EIA-861 Data File

20f3 • File2 contains information onretail 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 all 50 States, the District ofColumbia, the Dominion ofPuerto Rico, andthe Territories ofAmerican Samoa, Guam, and the Virgin Islands. Forthe 2003 period forward, the Transportation consumer sectorreplaces the Other sectorwhich includedpublic street lighting, public buildings, electrified rail andtransit systems and some agricultural sector data such as irrigation load. The Transportation sector consists entirely of electrifiedrail andurbantransit systems. Datapreviouslyreported as the "Other" consumer sectorhave beenreclassified as Commercial sector activity for 2003. Agricultural data (i.e., irrigation load) previouslyreported inthe Other sector have beenreclassified as Industrial sector activity. • File 2U (new in 2003) contains revenue, sales and customer counts by State and class ofservice for

unregulated facilities reporting retail sales activity. • File3 contains information on retail revenue, sales, and customer counts, by State and class ofservice, for customers who selected alternate energy service providers in States that have deregulated their retail electricity markets, either fully orpartially. The revenue reported is the revenue received only for the energy portion 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 contain balancing data inthe amount of 14.8 billionkWh. • File3d contains information onthe delivery ofpower to customers who selected alternate power suppliers in State-level, "retail wheeling" programs. Therevenue, megawatthours, and consumer count information inthis file was reportedby distribution utilities delivering power soldby other energy suppliers. The revenue represents revenue reportedby the distributionutility for the delivery services provided to customers who were soldpowerby others, usually competitive retail energy service providers (ESPs). The megawatthours shown are the delivered megawatthours soldbythe ESPs (and reportedbyESPs as shown in File3.dbf) to customers who switched energy suppliers in the distribution utility's service area. Therevenue associated with delivery supplements the energy revenue shown in File3.dbf. The megawatthours and customer counts in file 3d, however are duplicative ofthe megawatthours and customers counts shown inFile3.dbf, and cannot be used to derive national, Census division, or State-level sales andrevenue totals. For information onthe new Transportation consumer sector, see the note for File2 above. ED File4 contains information on electric utility demand-side managementprograms, including energy efficiency and loadmanagement effects and expenditures. For information onthe newTransportation consumer sector, see the note for File2 above. ED File5 contains the names ofthe counties, by State, in which the respondent has equipment for the distribution ofelectricity to ultimate consumers. • File6 contains energy balance data reportedbynon-utility generators
.
., File7 (new in 2003) displays State level components from bundled andunbundledproviders,

unregulated facilities with retail sales, and balance adjustments. 

### Note: All sales data, including energy efficiency savings, arein megawatthours, peak and peak reduction data arein megawatts for 2001, 2002, and 2003 and kilowatts for previous years, all revenue and expenditure data arein 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 "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-levelretail sales in all States, bytraditional 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 onutility demand-side managementprograms collected on Schedule V; "file5" contains information onutility service territories (county-level) collected on Schedule VII ofthe Form EIA-861; file 6 (2002 and 2003 only) contains sources

6/1 012005 2:27 PMAnnual 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-0800 (Pacific Standard Time). URL: http://www.ela.doe.gov/cneaf/electricity/page/eia86l.htmi Download

3 of 3 6/10/2005 2:27 PM Annual Electric Utility Data

- EIA-861 Data File

30f3 and disposition electricity reported bynon-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); andNotepad versions ofthe file layout ("layout"), the FormEIA-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 precedingparagraph. The primary difference is that file F861TYP1.DBF contains a combination ofdata available inthe 1999,2000, 2001,2002 and 2003 files in file1.xls and file2.dbf. Utilityretail 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 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