akantamn

US Average Electricity Rates and Energy Sources (Notes)

May 3rd, 2018
393
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. US Average Electricity Rates and Energy Sources (Notes)
  2. ------------------------------------------------
  3. Viz by Abhi (@akantamn)
  4.  
  5. Average Price by State by Provider (EIA-861):
  6. https://www.eia.gov/electricity/data/state/avgprice_annual.xlsx
  7.  
  8. Net Generation by State by Type of Producer by Energy Source (EIA-906, EIA-920, and EIA-923): https://www.eia.gov/electricity/data/state/annual_generation_state.xls
  9.  
  10. Rates adjusted for inflation (2015) using CPI Calculator:
  11. https://www.bls.gov/data/inflation_calculator.htm
  12.  
  13. -------------------------
  14. Shoutout to @gschivley for pointing out that generation by state != consumption by state (which complicates matters)
  15. Shoutout to @CethEslick for pointing out that CPE may be a better metric to adjust for inflation by, since "it removes the changing price of energy (and food)"
  16. Shoutout to @sada_uc for pointing out that viz doesn't include AK and HI
  17. Shoutout to @midatalabs for early feedback on the viz
RAW Paste Data