Form EIA-826 Database Monthly Electric Utility Sales and Revenue Data

EIA previously collected sales and revenue data in a category called "Other." This category was defined as including activities such as public street highway lighting, other sales to public authorities, sales to railroads and railways, and interdepartmental sales. EIA has revised its survey to separate the transportation sales and reassign the other activities to the commercial and industrial sectors as appropriate.

This is an electric utility data file that includes utility level retail sales of electricity and associated revenue by end-use sector, State, and reporting month. The data source is the survey: Form EIA-826, "Monthly Electric Utility Sales and Revenue Report with State Distributions." The Form EIA-826 is used to collect retail sales of electricity and associated revenue, each month, from a statistically chosen sample of electric utilities in the United States. The respondents to the Form EIA-826 are chosen from the Form EIA-861, "Annual Electric Utility Report." The data also include, for each State, a record (UTILITYID "000000") containing data values which represent the arithmetic differences between the "estimated" State totals and the sum of the retail sales and associated revenue data reported by the respondents to the Form EIA-826.

The data are compressed into a self-extracting (f826yyyy.exe)^* zip file. This self-extracting zip file expands into one DBF file (f826utilyyyy.dbf)^* that contains the yearly data and an ASCII text file (f826layoutyyyy.txt)^* that contains the file description and record layout for the data base structure. The current year's file will be a year-to-date file and is maintained in this monthly format until the data for the final month is finalized.

To expand the self-extracting zip file, type f826yyyy.exe^* from a DOS window, or double click on the file name from File Manager in Windows 3x or Windows Explorer in either Windows 95, Windows 98, Windows 2000, XP, or ME. Or, click Start, then Run, then select name of .EXE file to open, then "OK." (Requires approx. 600K space). Usually, the current year's file will be a "year-to-date" file until the data for the final month is finalized.

^*Note: Substitute the applicable year for "yyyy" in the file name.

File Size: 200 k

Methodology is based on the "Model-Based Sampling, Inference and Imputation."

Contact:

EIA-826 Sales and Revenue Spreadsheets