is an electric utility data file that includes such information as peak
load, generation, electric purchases, sales, revenues, customer counts
and demand-side management programs, green pricing and net metering
programs, and distributed generation capacity. The data source is the
survey Form EIA-861, "Annual Electric Power Industry Report." Data for
all years are final.
The file F861yr09.exe is a file of data collected on
the Form EIA-861, Annual Electric Power Industry Report, for the
reporting period, calendar year 2009. The zipped .exe file contains 11
.xls files and one Word file, and a .pdf of the Form EIA-861. The data
file structure detailed here also applies to data files for prior
- File1 contains aggregate operational data such as control area
operators (years prior to 2005), energy balance, and revenue information
from each electric utility in the country, including power marketers,
and Federal power marketing administrations.
- File1_cao contains (2005 forward) data on control area operators.
- File1_a (2007 forward) contains data on the types of activities
each utility engages in, the NERC regions of operation, whether the
utility generates power, and if it operates alternative-fueled vehicles.
- File2 contains information on retail revenue, sales, and customer
counts, by State and class of service (including the Transportation
sector, new in 2003), for each electric distribution utility, or energy
service provider in all 50 States, the District of Columbia, the
Dominion of Puerto Rico, and the Territories of American Samoa, Guam,
and the Virgin Islands.
- File3 contains information on electric utility demand-side
management programs, including energy efficiency and load management
effects and expenditures, and (2007 forward) the number of customers in
time- and incentive-based rate programs (peak data is in megawatts for
2001 forward – in previous years the data are in kilowatts).
- File3a (2007 forward) contains the cost percentages by state of energy efficiency and load management programs.
- File4 contains the names of the counties, by State, in which the
respondent has equipment for the distribution of electricity to ultimate
- File5 contains aggregate data of the number of customers by State
and customer class for Green Pricing and Net Metering programs, as well
as (for 2007 forward) the revenue and sales from Green Pricing programs
and the energy displaced by Net Metering programs.
- File6 contains information on utility or customer-owned distributed
and dispersed generation such as the number, capacity and types of
- File7 (2007 forward) contains data on mergers and acquisitions
- File8 (2007 forward) contains data on advanced meters.
Note: All sales data, including energy efficiency
savings, are in megawatthours, peak and peak reduction data are in
megawatts for 2001 forward and kilowatts for previous years, all revenue
and expenditure data are in thousand-dollar units.
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 1999 and 2000 files
described in the preceding paragraph. The primary difference is that
file F861TYP1.DBF contains a combination of data available in the 1999,
2000, and 2001 in file1.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
If you experience difficulty in
downloading an EIA electricity database, please try substituting
"eiainfo2" in place of "www" in the URL address.
R=Revised Data. F=Final Data.
View Contact Information for Electric Utilities Selling to Ultimate Consumers,
by State and Utility
Contact: Stephen Scott Phone: 202-586-5140 Email: Stephen Scott
Karen McDaniel Phone: 202-586-4280 Email: Karen McDaniel