Form EIA-861 Final Data File for 2010

This file contains information pertaining to the column headings for the files deployed from f861yr10.exe, when unzipped. This file layout also contains other useful information on the fields and data presented. The file names are File1_2010.xls, File1_cao.xls, File1a.xls, File2.xls, File3.xls, File4.xls, File5.xls File6.xls, File7.xls, and File8.xls.

The file F861yr10.exe is a file of data collected on the Form EIA-861, Annual Electric Power Industry Report, for the reporting period, calendar year 2010. The zipped .exe file contains 10 .xls files and one Word file. The data file structure detailed here also applies to data files for prior years. Years prior to 2007 do not include File1a, File7 and File8. In 2010, all DSM data was consolidated on to File3. Executable (and zip) files for years prior to 2004 do not contain file6 (distributed generation data). Executable (and zip) files for 2001 do not contain file 5 (green pricing, net metering data). Data for years prior to 2001 are described in the applicable file layout documentation.

• 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, the ISO or RTO region in which entity conducts operations (2010 forward), 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).
• 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, and (for 2010 forward) installed capacity by generation type: photovoltaic; wind; CHP/cogen; and other.
• File6 contains information on utility or customer-owned distributed and dispersed generation such as the number, capacity and types of generators. For 2010, we have added capacity by photovoltaic and storage generation types.
• 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