electricity icon

Electricity CSV File

From the CORGIS Dataset Project

By Dennis Kafura, Joung Min Choi, and Bo Guan
Version 2.0.0, created 9/7/2021
Tags: elctricity,electric power, utilities, utility revenues

Overview

The U.S. Energy Information Adminstration collects and curates self-reported information from energy utilities about energy production and usage in the United States. This data set contains information from over 2,000 U.S. utilities in 2017. The information includes sources of energy, its uses in different economic sectors, and the revenues obtained from the sale of electrical energy.

https://www.eia.gov/electricity/data/eia861/

Download

Download the following file:

Key Descriptions

Key List of... Comment Example Value
Utility.Number Integer Unique identifier for the utility. 34
Utility.Name String Utility Name "City of Abbeville - (SC)"
Utility.State String A two letter abbreviation for the name of the state (e.g., CA for California) "SC"
Utility.Type String Business type (e.g, Municipal, Private) "Municipal"
Demand.Summer Peak Float Peak demand in the summer measured in megawatts 13.7
Demand.Winter Peak Float Peak demand in the winter measured in megawatts 10.8
Sources.Generation Float Net generation of power measured in megawatt hours 7000.0
Sources.Purchased Float Power purchased from other electric utilities measured in megawatt hours 59000.0
Sources.Other Float Power obtained from other sources (e.g., exchanged with other utilities) measured in megawatt hours 0.0
Sources.Total Float Total power from all sources measured in megawatt hours 66000.0
Uses.Retail Float Power sold on the retail market measured in megawatt hours 58000.0
Uses.Resale Float Power sold to other utilities for resale measured in megawatt hours 0.0
Uses.No Charge Float Power furnished without charge measured in megawatt hours 7000.0
Uses.Consumed Float Power consumed by the utility itself measured in megawatt hours 0.0
Uses.Losses Float Power losses of all kinds measured in megawatt hours 1000.0
Uses.Total Float Total power used for all purposes measured in megawatt hours 66000.0
Revenues.Retail Float Revenue from retail power sales measured in thousands of US dolllars 7536.0
Revenue.Delivery Float Revenue from customers who delivered power measured in thousands of US dollars 0.0
Revenue.Resale Float Revenue from sale of power to other utilities for resale measured in thousands of US dollars 0.0
Revenue.Adjustments Float Revnue from credits or other adjustments measured in thousands of US dollars 0.0
Revenue.Transmission Float Revenue from transmission of power measured in thousands of US dollars 0.0
Revenue.Other Float Revenue of all other kinds measured in thousands of US dollars 0.0
Revenue.Total Float Total revenue from all sources measured in thousands of US dollars 7536.0
Retail.Residential.Revenue Float Revenue from retail sales to residential customers measured in thousands of US dollars 4563.0
Retail.Residential.Sales Float Power delivered to residential customers measured in meagawatt hours 33000.0
Retail.Residential.Customers Float Number of residential customers 3384.0
Retail.Commercial.Revenue Float Revenue from retail sales to commerical customers measured in thousands of US dollars 2973.0
Retail.Commercial.Sales Float Power delivered to commercial customers measured in meagawatt hours 25000.0
Retail.Commercial.Customers Float Number of commercial customers 460.0
Retail.Industrial.Revenue Float Revenue from retail sales to industrial customers measured in thousands of US dollars 0.0
Retail.Industrial.Sales Float Power delivered to industrial customers measured in meagawatt hours 0.0
Retail.Industrial.Customers Float Number of industrial customers 0.0
Retail.Transportation.Revenue Float Revenue from retail sales to transportation customers measured in thousands of US dollars 0.0
Retail.Transportation.Sales Float Power delivered to transportation customers measured in meagawatt hours 0.0
Retail.Transportation.Customers Float Number of transportation customers 0.0
Retail.Total.Revenue Float Total revenue from all retail customers measured in thousands of US dollars 7536.0
Retail.Total.Sales Float Total power delivered to all retail customers measured in megawatt hours 58000.0
Retail.Total.Customers Float Total number of retail customers 3844.0