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

Dataset Summary

Description

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

2012
 
ZIP

2011
 
ZIP

2010
 
ZIP

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

Source Energy Information Administration (EIA)
Date Released December 31st, 2009 (5 years ago)
Date Updated March 12th, 2014 (6 months ago)
Keywords
Data

Quality Metrics

Level of Review No Review
Comment

Temporal and Spatial Coverage

Frequency Annually
Time Period 1990-2012

License

License Open Data Commons Attribution License
Comment
Rate this dataset
Usefulness of the metadata
Average voteYour vote

Usefulness of the dataset
Average voteYour vote

Ease of access
Average voteYour vote

Overall rating
Average voteYour vote

Comments

If you rate this dataset, your published comment will include your rating.
  • 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.

ThanksSee this awesome website

movers in dallas by Awaisccj, February 23, 2012 

yes no doubt about this that energy plays a very important role in our daily life and without it we can't do anything so we also try to save energy as much as possible.

[note that as of 2/18/11 I gave this dataset many good stars, but because of a bug in the system, it shows me having rated it poorly. I have given this dataset 5 stars!]The EIA-861 is one of the most useful electricity statistics datasets for the US. But as many of you may already realize, it's an extremely intimidating dataset. One suggestion I have is to add additional datasets alongside this one with easier to access, simpler data (but based ultimately on this dataset).