Form EIA-861, "Annual Electric Power Industry Report."

This
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
years.

• 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
  consumers.
• 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
  generators.
• 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.
 

Download

Year
Formats

2009
DBF
ZIP

2008
DBF
ZIP

2007
DBF
ZIP

2006
DBF
ZIP

2005
DBF
ZIP

2004
DBF
ZIP

2003
DBF
ZIP

2002
DBF
ZIP

2001
DBF
ZIP

2000
DBF
ZIP

1999
DBF
ZIP

1998
DBF
ZIP

1997
DBF
ZIP

1996
DBF
ZIP

1995
DBF
ZIP

1994
DBF
ZIP

1993
DBF
ZIP

1992
DBF
ZIP

1991
DBF
ZIP

1990
DBF
ZIP

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