Electricity Python Library
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/
Explore Structure
Each row represents Generation and distribution properties for a single utility .
Explore electricity data
Index Type Example Value
0
dict
{
1 dict (same structure)
2 dict (same structure)
... ... ...
Key Type Example Value Description
"Utility"
dict
{
"Demand"
dict
{
"Sources"
dict
{
"Uses"
dict
{
"Revenues"
dict
{
"Revenue"
dict
{
"Retail"
dict
{
Key Type Example Value Description
"Number"
int
34
Unique identifier for the utility.
"Name"
str
"City of Abbeville - (SC)"
Utility Name
"State"
str
"SC"
A two letter abbreviation for the name of the state (e.g., CA for California)
"Type"
str
"Municipal"
Business type (e.g, Municipal, Private)
Key Type Example Value Description
"Summer Peak"
float
13.7
Peak demand in the summer measured in megawatts
"Winter Peak"
float
10.8
Peak demand in the winter measured in megawatts
Key Type Example Value Description
"Generation"
float
7000.0
Net generation of power measured in megawatt hours
"Purchased"
float
59000.0
Power purchased from other electric utilities measured in megawatt hours
"Other"
float
0.0
Power obtained from other sources (e.g., exchanged with other utilities) measured in megawatt hours
"Total"
float
66000.0
Total power from all sources measured in megawatt hours
Key Type Example Value Description
"Retail"
float
58000.0
Power sold on the retail market measured in megawatt hours
"Resale"
float
0.0
Power sold to other utilities for resale measured in megawatt hours
"No Charge"
float
7000.0
Power furnished without charge measured in megawatt hours
"Consumed"
float
0.0
Power consumed by the utility itself measured in megawatt hours
"Losses"
float
1000.0
Power losses of all kinds measured in megawatt hours
"Total"
float
66000.0
Total power used for all purposes measured in megawatt hours
Key Type Example Value Description
"Retail"
float
7536.0
Revenue from retail power sales measured in thousands of US dolllars
Key Type Example Value Description
"Delivery"
float
0.0
Revenue from customers who delivered power measured in thousands of US dollars
"Resale"
float
0.0
Revenue from sale of power to other utilities for resale measured in thousands of US dollars
"Adjustments"
float
0.0
Revnue from credits or other adjustments measured in thousands of US dollars
"Transmission"
float
0.0
Revenue from transmission of power measured in thousands of US dollars
"Other"
float
0.0
Revenue of all other kinds measured in thousands of US dollars
"Total"
float
7536.0
Total revenue from all sources measured in thousands of US dollars
Key Type Example Value Description
"Residential"
dict
{
"Commercial"
dict
{
"Industrial"
dict
{
"Transportation"
dict
{
"Total"
dict
{
Key Type Example Value Description
"Revenue"
float
4563.0
Revenue from retail sales to residential customers measured in thousands of US dollars
"Sales"
float
33000.0
Power delivered to residential customers measured in meagawatt hours
"Customers"
float
3384.0
Number of residential customers
Key Type Example Value Description
"Revenue"
float
2973.0
Revenue from retail sales to commerical customers measured in thousands of US dollars
"Sales"
float
25000.0
Power delivered to commercial customers measured in meagawatt hours
"Customers"
float
460.0
Number of commercial customers
Key Type Example Value Description
"Revenue"
float
0.0
Revenue from retail sales to industrial customers measured in thousands of US dollars
"Sales"
float
0.0
Power delivered to industrial customers measured in meagawatt hours
"Customers"
float
0.0
Number of industrial customers
Key Type Example Value Description
"Revenue"
float
0.0
Revenue from retail sales to transportation customers measured in thousands of US dollars
"Sales"
float
0.0
Power delivered to transportation customers measured in meagawatt hours
"Customers"
float
0.0
Number of transportation customers
Key Type Example Value Description
"Revenue"
float
7536.0
Total revenue from all retail customers measured in thousands of US dollars
"Sales"
float
58000.0
Total power delivered to all retail customers measured in megawatt hours
"Customers"
float
3844.0
Total number of retail customers
Downloads
Download all of the following files.
electricity.py electricity.data
Usage
import electricity
utility = electricity . get_utility ()
Documentation
get_utility() Returns a list of dictionaries representing utility.
