Revenue and pricing for electricity consumption by month in each state, since 1990. From the US Energy Information Administration
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 | CO 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 | 72091 99915 139036 89835 166455 view top 100 |
residentialSales | residentialsales | number | Number of megawatt hours sold | 1530922 1824026 1323265 985305 1910094 view top 100 |
residentialCustomers | residentialcustomers | number | Number of customers (if available) | 1663543 2175988 2330942 2141224 2395258 view top 100 |
residentialPrice | residentialprice | number | Price in cents per kilowatt hour | 7.41 7.4 7.33 7.3 7.53 view top 100 |
commercialRevenue | commercialrevenue | number | Revenue from electrical commercial consumption in thousands of dollars | 112609 136903 111686 155945 143790 view top 100 |
commercialSales | commercialsales | number | Commercial sales in megawatt hours | 1156648 1556494 1601381 1190065 985505 view top 100 |
commercialCustomers | commercialcustomers | number | Number of commercial customers (where available) | 381703 386365 349961 381511 381722 view top 100 |
commercialPrice | commercialprice | number | Commercial price in cents per kilowatt hour | 5.8 5.82 5.91 5.99 7.45 view top 100 |
industrialRevenue | industrialrevenue | number | Revenue for industrial electricity consumption, in thousand dollars | 86878 83331 24272 103531 74806 view top 100 |
industrialSales | industrialsales | number | Industrial sales in megawatt hours | 1203209 976065 1281552 1118226 1252292 view top 100 |
industrialCustomers | industrialcustomers | number | Number of industrial customers (where available) | 15346 16608 15243 15103 5702 view top 100 |
industrialPrice | industrialprice | number | Industrial price in cents per kilowatt hour | 4.3 4.33 4.32 4.4 7.4 view top 100 |
transportationRevenue | transportationrevenue | number | Revenue from electricity usage by transportation, in thousand dollars | 85 420 84 428 89 view top 100 |
transportationSales | transportationsales | number | Transportation sales in megawatt hours | 4199 5103 2062 5094 7135 view top 100 |
transportationCustomers | transportationcustomers | number | Number of transportation customers (where available) | 1 view top 100 |
transportationPrice | transportationprice | number | Transportation price in cents per kilowatt hour | 8.89 8.96 8.02 7.66 9.27 view top 100 |
otherRevenue | otherrevenue | number | Revenue from other sources, in thousand dollars | 5778 6113 3901 4332 6358 view top 100 |
otherSales | othersales | number | Sales to other types, in megawatt hours | 71212 65222 78601 117537 82528 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 | 8.01 8.25 7.61 8.33 7.81 view top 100 |
totalRevenue | totalrevenue | number | Revenue from all sources, in thousand dollars | 309614 651930 553598 192534 339943 view top 100 |
totalSales | totalsales | number | Total sales in megawatt hours | 2717631 2500200 5609946 2425988 3073268 view top 100 |
totalCustomers | totalcustomers | number | Total number of customers | 2546431 2846085 2874327 1941761 2470448 view top 100 |
totalPrice | totalprice | number | Overall price, in cents per kilowatt hour | 6.08 6.06 5.89 6.13 5.84 view top 100 |