Others titles
- Electric Power Annual (EPI) And The Electric Sales Revenue And Average Price (ESR)
- Energy Information Administration Dataset Sales Revenue And Average Price 2011
Keywords
- Electricity Rates
- Utility Companies
- Utility Rates
- Zipcode
- Electricity
- Electric Energy Sales
- Electric Energy Revenue
Electric Power Annual Utilization Sales And Revenue
The Energy Information Administration data files includes demand, generation, electric purchases, sales, revenues, source of energy and losses of electric power for the year of 2011.
Get The Data
- ResearchNon-Commercial, Share-Alike, Attribution Free Forever
- CommercialCommercial Use, Remix & Adapt, White Label Log in to download
Description
The dataset compiled by National Renewable Energy Laboratory (NREL) using data from ABB group, the Velocity Suite and the U.S. Energy Information Administration dataset 861, provides average residential, commercial and industrial electricity rates by zip code for both investor owned utilities (IOU) and non-investor owned utilities. The Energy Information Administration data files include information such 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 file includes average rates for each utility, but not the detailed rate structure data found in the Open Energy Information (EI) U.S. Utility Rate Database. A more recent version of this data is also available through the NREL Utility Rate API with more search options. This data was released by NREL/Ventyx in February 2011.
About this Dataset
Data Info
Date Created | 2015-02-23 |
---|---|
Last Modified | 2016-10-20 |
Version | 2016-10-20 |
Update Frequency |
Never |
Temporal Coverage |
2011 |
Spatial Coverage |
United States |
Source | John Snow Labs; Data.gov; |
Source License URL | |
Source License Requirements |
N/A |
Source Citation |
N/A |
Keywords | Electricity Rates, Utility Companies, Utility Rates, Zipcode, Electricity, Electric Energy Sales, Electric Energy Revenue |
Other Titles | Electric Power Annual (EPI) And The Electric Sales Revenue And Average Price (ESR), Energy Information Administration Dataset Sales Revenue And Average Price 2011 |
Data Fields
Name | Description | Type | Constraints |
---|---|---|---|
Year | Year of data | date | level : Nominal |
Utility_Id | ID number of utility (reporting entity) | integer | level : Nominal |
Utility_Name | Name of Utility | string | - |
State_Abbreviation | State/Territory in which the utility (entity) is located | string | - |
Ownership_Type | Ownership Type: One of 10 different types of ownership categories: Federal; Political Subdivision; Municipal Marketing Authority; Cooperative; State; Municipal; Investor-Owned; Retail Power Marketer (Energy Service Provider); (Wholesale) Power Marketer; Transmission Company. “State” ownership refers to statewide organizations whose scope is larger than county level. | string | - |
NRC_Location | NERC Location: The North American Electric Reliability Corporation (NERC) region where the utility has its primary business operations (service territory), electrical generation, transmission, and distribution equipment, and its administrative headquarters. Some utilities have business operations and service areas in more than one NERC region. Power marketers, because they generally have only office equipment, can have business operations in any NERC region. FRCC = Florida Reliability Coordinating Council; MRO = Midwest Reliability Organization; NPCC = Northeast Power Coordinating Council; RFC = Reliability First Corporation (formerly MAAC, MAIN and ECAR); SERC = SERC Reliability Corporation; SPP = Southwest Power Pool, RE; TRE = Texas Regional Entity (formerly ERCOT); WECC = Western Electric Coordinating Council. AK = Alaska; AS = American Samoa; GU = Guam; HI = Hawaii; PR = Puerto Rico; VI = Virgin Islands. | string | - |
Peak_Demand_Summer | Summer Peak Demand: The one hour during the months of June, July, August or September when the utility sold the most power, including full and partial requirements wholesale consumers. Peak data is in megawatts (2000 and previous years in kilowatts). | number | level : Ratio |
Peak_Demand_Winter | Winter Peak Demand: The one hour during the months of December (prior), January, February, March (current year) when the utility sold the most power, including full and partial requirements wholesale consumers. Peak data is in megawatts (2000 and previous years in kilowatts). | number | level : Ratio |
Net_Generation | Net Generation: Gross generation minus plant use from all electric utility owned plants. Energy data is in megawatthours. | number | level : Ratio |
Wholesale_Purachases | Wholesale Power Purchases (in megawatthours): Energy purchased and supplied to other electric utilities, cooperatives, municipals, and Federal and state electric agencies for resale to ultimate consumers. | number | level : Ratio |
Exchanged_Energy_Received | Exchange Energy Received (in megawatthours): Specific energy transactions between electric utilities, where electricity received is returned in kind at a later time or accumulated as energy balances until the end of the stated period, after which settlement may be by monetary payment. This is the portion of energy reported as received. | number | level : Ratio |
Exchanged_Energy_Delivered | Exchange Energy Delivered (in megawatthours): Specific energy transactions between electric utilities, where electricity received is returned in kind at a later time or accumulated as energy balances until the end of the stated period, after which settlement may be by monetary payment. This is the portion of energy reported as delivered. | number | level : Ratio |
Net_Power_Exchanged | Net Power Exchanged (in megawatthours): Specific energy transactions between electric utilities, where electricity received is returned in kind at a later time or accumulated as energy balances until the end of the stated period, after which settlement may be by monetary payment. This is the Net difference between the energy reported as received and delivered. | number | level : Ratio |
Wheeled_Power_Received | Wheeled Power Received (in megawatthours): The reported volume of electricity received, transmitted over an electric utility’s system for compensation, which the electric utility received from one system and delivered to another system. | number | level : Ratio |
Wheeled_Power_Delivered | Wheeled Power Delivered (in megawatthours): The reported volume of electricity delivered, transmitted over an electric utility’s system for compensation, which the electric utility received from one system and delivered to another system. | number | level : Ratio |
Net_Wheeled_Power | Net Wheeled Power (in megawatthours): The reported net volume of electricity transmitted over an electric utility’s system for compensation, which the electric utility received from one system and delivered to another system. | number | level : Ratio |
Transmission_By_Other_Losses | Transmission By Others Losses (in megawatthours): The amount of energy losses associated with the wheeling of electricity provided to the respondent’s system by other utilities. This should always be expressed as a negative value. | number | level : Ratio |
Total_Sources_Of_Energy | Total Sources (in megawatthours): The sum of all sources of energy (Sum of columns I through P). | number | level : Ratio |
Retail_Sales | Retail Sales (in megawatthours): Sales to ultimate consumers. The amount of electricity sold to customers purchasing electricity for their own use and not for resale. | number | level : Ratio |
Sales_For_Resale | Sales For Resale (in megawatthours): Wholesale sales. The amount of electricity sold for resale purposes. This includes sales for resale to power marketers, full and partial requirements customers, firm power customers and nonfirm customers, and sales through tolling agreements. | number | level : Ratio |
Furnished_Without_Charge | Furnished Without Charge (in megawatthours): The amount of electricity furnished by the electric utility without charge, such as a municipality under a franchise agreement or for public street and highway lighting. This entry does not include data entered in Column V, Consumed_By_Respondent | number | level : Ratio |
Consumed_By_Respondent | Consumed By Respondent without charge (in megawatthours): The amount of electricity furnished by the electric utility without charge, such as to a municipality under a franchise agreement or for public street and highway lighting. This entry does not include data entered in Column U, Furnished_Without_Charge | number | level : Ratio |
Total_Losses | Total Energy Losses (in megawatthours): The total amount of electricity lost from transmission, distribution, and/or unaccounted for (sum of columns S through V). This must be a positive number. | number | level : Ratio |
Total_Disposition | Total Disposition (in megawatthours): The total amount of electricity disposed (The difference between Column R “TOTAL_SOURCES” and the sum of columns S through W). | number | level : Ratio |
Retail_Revenues | Electric Operating Revenue from Sales to Ultimate Customers, Schedule 4, Parts A and B (in thousand dollars): The amount of revenue from sales of electricity to those customers purchasing electricity for their own use and not for resale. | number | level : Ratio |
Unbundled_Revenues | Revenue from Unbundled (Delivery) Customers, Schedule 4, part C (in thousand dollars): The amount of revenue from unbundled customers who purchase their energy from a supplier other than the electric utility that distributes the power to their premises. This electric operating revenue does not include the charges for electric energy but does include the revenue required to cover power delivery. | number | level : Ratio |
Resale_Revenues | Electric Operating Revenue from Sales for Resale (in thousand dollars): The amount of revenue from sales of electricity sold for resale purposes. This includes revenue from sales for resale to wholesale or retail power marketers, full and partial requirements customers (firm) and to nonrequirements (nonfirm) customers. | number | level : Ratio |
Revenue_Credits_And_Adjustments | Electric Credits/Other Adjustments (in thousand dollars): Funds included in this entry consist of refunds to customers resulting from rate commission rulings delayed beyond the reporting year in which the funds were originally collected. This also includes revenue distributions to customers from rate stabilizations funds where the distribution occurred during the current reporting year but the funds were collected during the previous reporting years. | number | level : Ratio |
Transmission_Revenues | Amount of revenue derived from the transmission of electricity for others (wheeling) | number | level : Ratio |
Other_Revenues | Other Electric Operating Revenue (in thousand dollars): The amount of revenue received from electric activities other than selling electricity. This may include revenue from selling or servicing electric appliances, revenue from the sale of water and water power for irrigation, domestic, industrial or hydroelectric operations, revenue from electric plants leased to others, revenue from the transmission of electricity to others (wheeling), revenue from the sale of steam, but not including sales made by a steam heating department or transfers of steam under joint facility operations, revenue from interdepartmental rents or sale of electric property, revenue from late fees, penalties or reconnections, and revenue from interest. | number | level : Ratio |
Total_Revenues | Total Electric Operating Revenues (in thousand dollars): The sum of columns Y through AD. | number | level : Ratio |
Data_Type | O=observed; I=imputed | string | - |
Data Preview
Year | Utility Id | Utility Name | State Abbreviation | Ownership Type | NRC Location | Peak Demand Summer | Peak Demand Winter | Net Generation | Wholesale Purachases | Exchanged Energy Received | Exchanged Energy Delivered | Net Power Exchanged | Wheeled Power Received | Wheeled Power Delivered | Net Wheeled Power | Transmission By Other Losses | Total Sources Of Energy | Retail Sales | Sales For Resale | Furnished Without Charge | Consumed By Respondent | Total Losses | Total Disposition | Retail Revenues | Unbundled Revenues | Resale Revenues | Revenue Credits And Adjustments | Transmission Revenues | Other Revenues | Total Revenues | Data Type |
2011 | 34 | City of Abbeville - (SC) | SC | Municipal | SERC | 16.0 | 14.0 | 2106.0 | 64473 | 0.0 | 0.0 | 66579 | 61404 | 704.0 | 61.0 | 4410 | 66579 | 7201.0 | 7201.0 | O | |||||||||||
2011 | 55 | City of Aberdeen - (MS) | MS | Municipal | SERC | 34.0 | 32.2 | 0.0 | 190703 | 190703 | 184771 | 0.0 | 0.0 | 5932 | 190703 | 15045.0 | 0.0 | 122.0 | 15167.0 | O | |||||||||||
2011 | 59 | City of Abbeville - (LA) | LA | Municipal | SPP | 34.0 | 26.0 | 149154 | 0.0 | 0.0 | 149154 | 139383 | 9771 | 149154 | 14524.0 | 14524.0 | O | ||||||||||||||
2011 | 84 | A & N Electric Coop | VA | Cooperative | RFC | 159.0 | 133.2 | 234.0 | 694570 | 0.0 | 0.0 | 694804 | 667824 | 1041.0 | 25939 | 694804 | 72193.5 | 72193.5 | O | ||||||||||||
2011 | 87 | City of Ada | MN | Municipal | MRO | 4.1 | 4.5 | 22216 | 0.0 | 0.0 | 22216 | 20852 | 1364 | 22216 | 1343.0 | 1343.0 | O | ||||||||||||||
2011 | 97 | Adams Electric Coop | IL | Cooperative | SERC | 37.0 | 36.0 | 1942.0 | 173296 | 0.0 | 0.0 | 175238 | 163125 | 347.0 | 11766 | 175238 | 19770.0 | 222.0 | 19992.0 | O | |||||||||||
2011 | 108 | Adams-Columbia Electric Coop | WI | Cooperative | MRO | 129.6 | 83.2 | 500240 | 0.0 | 0.0 | 500240 | 471663 | 102.0 | 1140.0 | 27335 | 500240 | 58658.0 | 6.0 | 204.0 | 58868.0 | O | ||||||||||
2011 | 113 | Agway Energy Services, LLC | NY | Retail Power Marketer | NPCC | 99.7 | 99.1 | 616243 | 0.0 | 0.0 | 616243 | 595225 | 21018 | 616243 | 50451.0 | 50451.0 | O | ||||||||||||||
2011 | 118 | Adams Rural Electric Coop, Inc | OH | Cooperative | RFC | 25.6 | 30.6 | 119012 | 12.0 | 0.0 | 0.0 | 119012 | 111335 | 146.0 | 7531 | 119012 | 14227.0 | 406.0 | 14633.0 | O | |||||||||||
2011 | 122 | Village of Arcade | NY | Municipal | NPCC | 26.0 | 40.0 | 162155 | 0.0 | 0.0 | 162155 | 154335 | 674.0 | 7146 | 162155 | 7391.0 | 345.0 | 98.0 | 7834.0 | O |