Revenue and pricing for electricity consumption by month in each state, since 1990 from the US Energy Information Administration (USEIA).
This dataset has the following 28 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
year | year | number | Year recorded | 1999 2011 2012 2003 2016 view top 100 |
month | month | number | Month recorded (1 is January, 12 is December) | 4 5 6 9 2 view top 100 |
state | state | text | The state the data was compiled in | CA NH OR TX ND view top 100 |
dataStatus | datastatus | text | Whether the record has been approved and validated (Final) or if the record is the first recording (Preliminary) | Final Preliminary view top 100 |
residentialRevenue | residentialrevenue | number | Revenue from residential electricity consumption, in thousands of dollars | 31427 23079 22064 21434 90877 view top 100 |
residentialSales | residentialsales | number | Number of megawatt hours sold | 187051 1781137 3501740 192181 252624 view top 100 |
residentialCustomers | residentialcustomers | number | Number of customers (if available) | 865722 696160 438156 427028 861484 view top 100 |
residentialPrice | residentialprice | number | Price in cents per kilowatt hour | 7.2 7.38 7.21 7.3 7.4 view top 100 |
commercialRevenue | commercialrevenue | number | Revenue from electrical commercial consumption in thousands of dollars | 23341 20185 42360 91815 136301 view top 100 |
commercialSales | commercialsales | number | Commercial sales in megawatt hours | 886742 672945 430130 618637 2019215 view top 100 |
commercialCustomers | commercialcustomers | number | Number of commercial customers (where available) | 58272 27281 227892 59538 26490 view top 100 |
commercialPrice | commercialprice | number | Commercial price in cents per kilowatt hour | 6.4 6.5 6.2 6 6.3 view top 100 |
industrialRevenue | industrialrevenue | number | Revenue for industrial electricity consumption, in thousand dollars | 45847 16782 66728 27977 18885 view top 100 |
industrialSales | industrialsales | number | Industrial sales in megawatt hours | 107896 22352 17937 996300 1159264 view top 100 |
industrialCustomers | industrialcustomers | number | Number of industrial customers (where available) | 1 2 224 248 222 view top 100 |
industrialPrice | industrialprice | number | Industrial price in cents per kilowatt hour | 3.8 4.1 3.9 4.39 4.5 view top 100 |
transportationRevenue | transportationrevenue | number | Revenue from electricity usage by transportation, in thousand dollars | 0 4 3 5 2 view top 100 |
transportationSales | transportationsales | number | Transportation sales in megawatt hours | 0 36 2 34 70 view top 100 |
transportationCustomers | transportationcustomers | number | Number of transportation customers (where available) | 0 1 2 3 5 view top 100 |
transportationPrice | transportationprice | number | Transportation price in cents per kilowatt hour | 0.00 7.14 8.02 7.83 8.04 view top 100 |
otherRevenue | otherrevenue | number | Revenue from other sources, in thousand dollars | 641 711 583 699 1660 view top 100 |
otherSales | othersales | number | Sales to other types, in megawatt hours | 4717 4787 5014 29588 5469 view top 100 |
otherCustomers | othercustomers | number | Number of other customers | view top 100 |
otherPrice | otherprice | number | Price for other sectors, in cents per kilowatt hour | 6.71 6.66 6.41 6.32 6.28 view top 100 |
totalRevenue | totalrevenue | number | Revenue from all sources, in thousand dollars | 67349 79548 84342 297043 104470 view top 100 |
totalSales | totalsales | number | Total sales in megawatt hours | 857373 5006803 991827 925409 1901273 view top 100 |
totalCustomers | totalcustomers | number | Total number of customers | 357955 2546431 1026025 1475959 322364 view top 100 |
totalPrice | totalprice | number | Overall price, in cents per kilowatt hour | 6.33 6.11 6.1 5.99 8.80 view top 100 |