suppressWarnings({
library(knitr)
library(tidyverse)
library(readxl)
library(here)
library(dplyr)
library(ggplot2)
library(scales)
library(kableExtra)
library(plotly)})
## ── Attaching packages ─────────────────────────────────────── tidyverse 1.3.2 ──
## ✔ ggplot2 3.4.0      ✔ purrr   0.3.5 
## ✔ tibble  3.1.8      ✔ dplyr   1.0.10
## ✔ tidyr   1.2.1      ✔ stringr 1.5.0 
## ✔ readr   2.1.3      ✔ forcats 0.5.2 
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## here() starts at C:/Users/CP8853/ProjectFinal/CP8853ProjFin
## 
## 
## Attaching package: 'scales'
## 
## 
## The following object is masked from 'package:purrr':
## 
##     discard
## 
## 
## The following object is masked from 'package:readr':
## 
##     col_factor
## 
## 
## 
## Attaching package: 'kableExtra'
## 
## 
## The following object is masked from 'package:dplyr':
## 
##     group_rows
## 
## 
## 
## Attaching package: 'plotly'
## 
## 
## The following object is masked from 'package:ggplot2':
## 
##     last_plot
## 
## 
## The following object is masked from 'package:stats':
## 
##     filter
## 
## 
## The following object is masked from 'package:graphics':
## 
##     layout
source(here("functions.R"))
seds1 <- read.csv("Complete_SEDS.csv") %>% 
  tolow3()

msn1 <- read_excel("Codes_and_Descriptions.xlsx", sheet = "MSN Descriptions", skip = 9) %>% 
  tolow3()

stateinfo1 = read_excel("stateinfo6.xls")

#Section 1: Comparing the U.S. total energy consumption by the electric sector with all available data.

seds2 = seds1 %>% 
  left_join(stateinfo1, 
            by=c("statecode" = "stateabbr")) %>% 
  filter(msn %in% c("CLEIB","TEEIB", "NGEIB", "NUEGB", "SOEGB", "DFEIB" ,"WYEGB", "PCEIB", "GEEGB","PAEIB","HYEGB")) %>% 
  filter(statename == "United States")
seds3 <- seds2 %>% 
  group_by(msn, year) %>% 
  summarize(energycons = sum(data))
## `summarise()` has grouped output by 'msn'. You can override using the `.groups`
## argument.
seds4<- seds3 %>% left_join(msn1, by=c("msn")) %>% 
        separate(col=description, c('description','destination'), sep=" consumed ")
         
kable(seds4, digits = 2, format = "html", row.names = TRUE, caption = "Table 1: U.S. Total Energy Consumption by The Electric Sector 1960-2020 (Billion Btu)") %>%
  kable_styling(bootstrap_options = c("striped"),
                full_width = T,
                font_size = 14) %>%
   scroll_box(height = "600px")
Table 1: U.S. Total Energy Consumption by The Electric Sector 1960-2020 (Billion Btu)
msn year energycons description destination unit
1 CLEIB 1960 4226595 Coal by the electric power sector Billion Btu
2 CLEIB 1961 4355064 Coal by the electric power sector Billion Btu
3 CLEIB 1962 4622438 Coal by the electric power sector Billion Btu
4 CLEIB 1963 5050061 Coal by the electric power sector Billion Btu
5 CLEIB 1964 5379761 Coal by the electric power sector Billion Btu
6 CLEIB 1965 5821355 Coal by the electric power sector Billion Btu
7 CLEIB 1966 6301552 Coal by the electric power sector Billion Btu
8 CLEIB 1967 6444876 Coal by the electric power sector Billion Btu
9 CLEIB 1968 6993577 Coal by the electric power sector Billion Btu
10 CLEIB 1969 7219168 Coal by the electric power sector Billion Btu
11 CLEIB 1970 7228006 Coal by the electric power sector Billion Btu
12 CLEIB 1971 7299249 Coal by the electric power sector Billion Btu
13 CLEIB 1972 7842523 Coal by the electric power sector Billion Btu
14 CLEIB 1973 8659920 Coal by the electric power sector Billion Btu
15 CLEIB 1974 8538706 Coal by the electric power sector Billion Btu
16 CLEIB 1975 8789280 Coal by the electric power sector Billion Btu
17 CLEIB 1976 9730659 Coal by the electric power sector Billion Btu
18 CLEIB 1977 10258749 Coal by the electric power sector Billion Btu
19 CLEIB 1978 10253442 Coal by the electric power sector Billion Btu
20 CLEIB 1979 11270255 Coal by the electric power sector Billion Btu
21 CLEIB 1980 12157926 Coal by the electric power sector Billion Btu
22 CLEIB 1981 12622872 Coal by the electric power sector Billion Btu
23 CLEIB 1982 12537754 Coal by the electric power sector Billion Btu
24 CLEIB 1983 13184982 Coal by the electric power sector Billion Btu
25 CLEIB 1984 13961625 Coal by the electric power sector Billion Btu
26 CLEIB 1985 14586431 Coal by the electric power sector Billion Btu
27 CLEIB 1986 14418435 Coal by the electric power sector Billion Btu
28 CLEIB 1987 15114830 Coal by the electric power sector Billion Btu
29 CLEIB 1988 15886154 Coal by the electric power sector Billion Btu
30 CLEIB 1989 16135278 Coal by the electric power sector Billion Btu
31 CLEIB 1990 16258995 Coal by the electric power sector Billion Btu
32 CLEIB 1991 16247935 Coal by the electric power sector Billion Btu
33 CLEIB 1992 16463621 Coal by the electric power sector Billion Btu
34 CLEIB 1993 17194422 Coal by the electric power sector Billion Btu
35 CLEIB 1994 17259079 Coal by the electric power sector Billion Btu
36 CLEIB 1995 17465065 Coal by the electric power sector Billion Btu
37 CLEIB 1996 18427577 Coal by the electric power sector Billion Btu
38 CLEIB 1997 18902863 Coal by the electric power sector Billion Btu
39 CLEIB 1998 19215808 Coal by the electric power sector Billion Btu
40 CLEIB 1999 19279063 Coal by the electric power sector Billion Btu
41 CLEIB 2000 20219797 Coal by the electric power sector Billion Btu
42 CLEIB 2001 19613575 Coal by the electric power sector Billion Btu
43 CLEIB 2002 19782944 Coal by the electric power sector Billion Btu
44 CLEIB 2003 20183337 Coal by the electric power sector Billion Btu
45 CLEIB 2004 20303713 Coal by the electric power sector Billion Btu
46 CLEIB 2005 20735427 Coal by the electric power sector Billion Btu
47 CLEIB 2006 20459989 Coal by the electric power sector Billion Btu
48 CLEIB 2007 20805249 Coal by the electric power sector Billion Btu
49 CLEIB 2008 20510599 Coal by the electric power sector Billion Btu
50 CLEIB 2009 18223766 Coal by the electric power sector Billion Btu
51 CLEIB 2010 19133366 Coal by the electric power sector Billion Btu
52 CLEIB 2011 18035415 Coal by the electric power sector Billion Btu
53 CLEIB 2012 15821257 Coal by the electric power sector Billion Btu
54 CLEIB 2013 16450431 Coal by the electric power sector Billion Btu
55 CLEIB 2014 16427232 Coal by the electric power sector Billion Btu
56 CLEIB 2015 14138235 Coal by the electric power sector Billion Btu
57 CLEIB 2016 12996648 Coal by the electric power sector Billion Btu
58 CLEIB 2017 12622220 Coal by the electric power sector Billion Btu
59 CLEIB 2018 12053020 Coal by the electric power sector Billion Btu
60 CLEIB 2019 10181470 Coal by the electric power sector Billion Btu
61 CLEIB 2020 8229142 Coal by the electric power sector Billion Btu
62 DFEIB 1960 22273 Distillate fuel oil by the electric power sector Billion Btu
63 DFEIB 1961 21599 Distillate fuel oil by the electric power sector Billion Btu
64 DFEIB 1962 22775 Distillate fuel oil by the electric power sector Billion Btu
65 DFEIB 1963 24658 Distillate fuel oil by the electric power sector Billion Btu
66 DFEIB 1964 25107 Distillate fuel oil by the electric power sector Billion Btu
67 DFEIB 1965 28707 Distillate fuel oil by the electric power sector Billion Btu
68 DFEIB 1966 36759 Distillate fuel oil by the electric power sector Billion Btu
69 DFEIB 1967 43062 Distillate fuel oil by the electric power sector Billion Btu
70 DFEIB 1968 57261 Distillate fuel oil by the electric power sector Billion Btu
71 DFEIB 1969 87149 Distillate fuel oil by the electric power sector Billion Btu
72 DFEIB 1970 140518 Distillate fuel oil by the electric power sector Billion Btu
73 DFEIB 1971 199701 Distillate fuel oil by the electric power sector Billion Btu
74 DFEIB 1972 260049 Distillate fuel oil by the electric power sector Billion Btu
75 DFEIB 1973 237131 Distillate fuel oil by the electric power sector Billion Btu
76 DFEIB 1974 279354 Distillate fuel oil by the electric power sector Billion Btu
77 DFEIB 1975 208133 Distillate fuel oil by the electric power sector Billion Btu
78 DFEIB 1976 219075 Distillate fuel oil by the electric power sector Billion Btu
79 DFEIB 1977 247432 Distillate fuel oil by the electric power sector Billion Btu
80 DFEIB 1978 250558 Distillate fuel oil by the electric power sector Billion Btu
81 DFEIB 1979 160299 Distillate fuel oil by the electric power sector Billion Btu
82 DFEIB 1980 157890 Distillate fuel oil by the electric power sector Billion Btu
83 DFEIB 1981 120012 Distillate fuel oil by the electric power sector Billion Btu
84 DFEIB 1982 86791 Distillate fuel oil by the electric power sector Billion Btu
85 DFEIB 1983 96184 Distillate fuel oil by the electric power sector Billion Btu
86 DFEIB 1984 88483 Distillate fuel oil by the electric power sector Billion Btu
87 DFEIB 1985 85247 Distillate fuel oil by the electric power sector Billion Btu
88 DFEIB 1986 83448 Distillate fuel oil by the electric power sector Billion Btu
89 DFEIB 1987 89512 Distillate fuel oil by the electric power sector Billion Btu
90 DFEIB 1988 109329 Distillate fuel oil by the electric power sector Billion Btu
91 DFEIB 1989 152356 Distillate fuel oil by the electric power sector Billion Btu
92 DFEIB 1990 96504 Distillate fuel oil by the electric power sector Billion Btu
93 DFEIB 1991 83640 Distillate fuel oil by the electric power sector Billion Btu
94 DFEIB 1992 73531 Distillate fuel oil by the electric power sector Billion Btu
95 DFEIB 1993 86496 Distillate fuel oil by the electric power sector Billion Btu
96 DFEIB 1994 119963 Distillate fuel oil by the electric power sector Billion Btu
97 DFEIB 1995 107976 Distillate fuel oil by the electric power sector Billion Btu
98 DFEIB 1996 109300 Distillate fuel oil by the electric power sector Billion Btu
99 DFEIB 1997 110514 Distillate fuel oil by the electric power sector Billion Btu
100 DFEIB 1998 135581 Distillate fuel oil by the electric power sector Billion Btu
101 DFEIB 1999 139992 Distillate fuel oil by the electric power sector Billion Btu
102 DFEIB 2000 174665 Distillate fuel oil by the electric power sector Billion Btu
103 DFEIB 2001 170347 Distillate fuel oil by the electric power sector Billion Btu
104 DFEIB 2002 127298 Distillate fuel oil by the electric power sector Billion Btu
105 DFEIB 2003 160789 Distillate fuel oil by the electric power sector Billion Btu
106 DFEIB 2004 111164 Distillate fuel oil by the electric power sector Billion Btu
107 DFEIB 2005 114470 Distillate fuel oil by the electric power sector Billion Btu
108 DFEIB 2006 73388 Distillate fuel oil by the electric power sector Billion Btu
109 DFEIB 2007 88650 Distillate fuel oil by the electric power sector Billion Btu
110 DFEIB 2008 72524 Distillate fuel oil by the electric power sector Billion Btu
111 DFEIB 2009 69526 Distillate fuel oil by the electric power sector Billion Btu
112 DFEIB 2010 79637 Distillate fuel oil by the electric power sector Billion Btu
113 DFEIB 2011 63589 Distillate fuel oil by the electric power sector Billion Btu
114 DFEIB 2012 52367 Distillate fuel oil by the electric power sector Billion Btu
115 DFEIB 2013 55314 Distillate fuel oil by the electric power sector Billion Btu
116 DFEIB 2014 82034 Distillate fuel oil by the electric power sector Billion Btu
117 DFEIB 2015 70254 Distillate fuel oil by the electric power sector Billion Btu
118 DFEIB 2016 54750 Distillate fuel oil by the electric power sector Billion Btu
119 DFEIB 2017 54583 Distillate fuel oil by the electric power sector Billion Btu
120 DFEIB 2018 80435 Distillate fuel oil by the electric power sector Billion Btu
121 DFEIB 2019 53767 Distillate fuel oil by the electric power sector Billion Btu
122 DFEIB 2020 44167 Distillate fuel oil by the electric power sector Billion Btu
123 GEEGB 1960 359 Geothermal energy for electricity generation by the electric power sector Billion Btu
124 GEEGB 1961 1001 Geothermal energy for electricity generation by the electric power sector Billion Btu
125 GEEGB 1962 1061 Geothermal energy for electricity generation by the electric power sector Billion Btu
126 GEEGB 1963 1760 Geothermal energy for electricity generation by the electric power sector Billion Btu
127 GEEGB 1964 2132 Geothermal energy for electricity generation by the electric power sector Billion Btu
128 GEEGB 1965 1978 Geothermal energy for electricity generation by the electric power sector Billion Btu
129 GEEGB 1966 1958 Geothermal energy for electricity generation by the electric power sector Billion Btu
130 GEEGB 1967 3300 Geothermal energy for electricity generation by the electric power sector Billion Btu
131 GEEGB 1968 4532 Geothermal energy for electricity generation by the electric power sector Billion Btu
132 GEEGB 1969 6422 Geothermal energy for electricity generation by the electric power sector Billion Btu
133 GEEGB 1970 5511 Geothermal energy for electricity generation by the electric power sector Billion Btu
134 GEEGB 1971 5739 Geothermal energy for electricity generation by the electric power sector Billion Btu
135 GEEGB 1972 15079 Geothermal energy for electricity generation by the electric power sector Billion Btu
136 GEEGB 1973 20422 Geothermal energy for electricity generation by the electric power sector Billion Btu
137 GEEGB 1974 25610 Geothermal energy for electricity generation by the electric power sector Billion Btu
138 GEEGB 1975 33780 Geothermal energy for electricity generation by the electric power sector Billion Btu
139 GEEGB 1976 37513 Geothermal energy for electricity generation by the electric power sector Billion Btu
140 GEEGB 1977 37382 Geothermal energy for electricity generation by the electric power sector Billion Btu
141 GEEGB 1978 30851 Geothermal energy for electricity generation by the electric power sector Billion Btu
142 GEEGB 1979 40262 Geothermal energy for electricity generation by the electric power sector Billion Btu
143 GEEGB 1980 52699 Geothermal energy for electricity generation by the electric power sector Billion Btu
144 GEEGB 1981 59437 Geothermal energy for electricity generation by the electric power sector Billion Btu
145 GEEGB 1982 50627 Geothermal energy for electricity generation by the electric power sector Billion Btu
146 GEEGB 1983 63910 Geothermal energy for electricity generation by the electric power sector Billion Btu
147 GEEGB 1984 80811 Geothermal energy for electricity generation by the electric power sector Billion Btu
148 GEEGB 1985 97421 Geothermal energy for electricity generation by the electric power sector Billion Btu
149 GEEGB 1986 107677 Geothermal energy for electricity generation by the electric power sector Billion Btu
150 GEEGB 1987 112270 Geothermal energy for electricity generation by the electric power sector Billion Btu
151 GEEGB 1988 106338 Geothermal energy for electricity generation by the electric power sector Billion Btu
152 GEEGB 1989 152239 Geothermal energy for electricity generation by the electric power sector Billion Btu
153 GEEGB 1990 160547 Geothermal energy for electricity generation by the electric power sector Billion Btu
154 GEEGB 1991 166626 Geothermal energy for electricity generation by the electric power sector Billion Btu
155 GEEGB 1992 166899 Geothermal energy for electricity generation by the electric power sector Billion Btu
156 GEEGB 1993 173073 Geothermal energy for electricity generation by the electric power sector Billion Btu
157 GEEGB 1994 160264 Geothermal energy for electricity generation by the electric power sector Billion Btu
158 GEEGB 1995 137957 Geothermal energy for electricity generation by the electric power sector Billion Btu
159 GEEGB 1996 148159 Geothermal energy for electricity generation by the electric power sector Billion Btu
160 GEEGB 1997 150398 Geothermal energy for electricity generation by the electric power sector Billion Btu
161 GEEGB 1998 150650 Geothermal energy for electricity generation by the electric power sector Billion Btu
162 GEEGB 1999 151621 Geothermal energy for electricity generation by the electric power sector Billion Btu
163 GEEGB 2000 143764 Geothermal energy for electricity generation by the electric power sector Billion Btu
164 GEEGB 2001 141981 Geothermal energy for electricity generation by the electric power sector Billion Btu
165 GEEGB 2002 147420 Geothermal energy for electricity generation by the electric power sector Billion Btu
166 GEEGB 2003 146045 Geothermal energy for electricity generation by the electric power sector Billion Btu
167 GEEGB 2004 148347 Geothermal energy for electricity generation by the electric power sector Billion Btu
168 GEEGB 2005 146903 Geothermal energy for electricity generation by the electric power sector Billion Btu
169 GEEGB 2006 144500 Geothermal energy for electricity generation by the electric power sector Billion Btu
170 GEEGB 2007 144674 Geothermal energy for electricity generation by the electric power sector Billion Btu
171 GEEGB 2008 146233 Geothermal energy for electricity generation by the electric power sector Billion Btu
172 GEEGB 2009 146485 Geothermal energy for electricity generation by the electric power sector Billion Btu
173 GEEGB 2010 148479 Geothermal energy for electricity generation by the electric power sector Billion Btu
174 GEEGB 2011 148811 Geothermal energy for electricity generation by the electric power sector Billion Btu
175 GEEGB 2012 148092 Geothermal energy for electricity generation by the electric power sector Billion Btu
176 GEEGB 2013 150506 Geothermal energy for electricity generation by the electric power sector Billion Btu
177 GEEGB 2014 150990 Geothermal energy for electricity generation by the electric power sector Billion Btu
178 GEEGB 2015 148336 Geothermal energy for electricity generation by the electric power sector Billion Btu
179 GEEGB 2016 146104 Geothermal energy for electricity generation by the electric power sector Billion Btu
180 GEEGB 2017 146733 Geothermal energy for electricity generation by the electric power sector Billion Btu
181 GEEGB 2018 145060 Geothermal energy for electricity generation by the electric power sector Billion Btu
182 GEEGB 2019 133851 Geothermal energy for electricity generation by the electric power sector Billion Btu
183 GEEGB 2020 135462 Geothermal energy for electricity generation by the electric power sector Billion Btu
184 HYEGB 1960 1569167 Hydropower for electricity generation by the electric power sector Billion Btu
185 HYEGB 1961 1620627 Hydropower for electricity generation by the electric power sector Billion Btu
186 HYEGB 1962 1780151 Hydropower for electricity generation by the electric power sector Billion Btu
187 HYEGB 1963 1737441 Hydropower for electricity generation by the electric power sector Billion Btu
188 HYEGB 1964 1852542 Hydropower for electricity generation by the electric power sector Billion Btu
189 HYEGB 1965 2026320 Hydropower for electricity generation by the electric power sector Billion Btu
190 HYEGB 1966 2028381 Hydropower for electricity generation by the electric power sector Billion Btu
191 HYEGB 1967 2310877 Hydropower for electricity generation by the electric power sector Billion Btu
192 HYEGB 1968 2313457 Hydropower for electricity generation by the electric power sector Billion Btu
193 HYEGB 1969 2613763 Hydropower for electricity generation by the electric power sector Billion Btu
194 HYEGB 1970 2599507 Hydropower for electricity generation by the electric power sector Billion Btu
195 HYEGB 1971 2790405 Hydropower for electricity generation by the electric power sector Billion Btu
196 HYEGB 1972 2829445 Hydropower for electricity generation by the electric power sector Billion Btu
197 HYEGB 1973 2826675 Hydropower for electricity generation by the electric power sector Billion Btu
198 HYEGB 1974 3143378 Hydropower for electricity generation by the electric power sector Billion Btu
199 HYEGB 1975 3122285 Hydropower for electricity generation by the electric power sector Billion Btu
200 HYEGB 1976 2942893 Hydropower for electricity generation by the electric power sector Billion Btu
201 HYEGB 1977 2300652 Hydropower for electricity generation by the electric power sector Billion Btu
202 HYEGB 1978 2905420 Hydropower for electricity generation by the electric power sector Billion Btu
203 HYEGB 1979 2896591 Hydropower for electricity generation by the electric power sector Billion Btu
204 HYEGB 1980 2867306 Hydropower for electricity generation by the electric power sector Billion Btu
205 HYEGB 1981 2724925 Hydropower for electricity generation by the electric power sector Billion Btu
206 HYEGB 1982 3232512 Hydropower for electricity generation by the electric power sector Billion Btu
207 HYEGB 1983 3494005 Hydropower for electricity generation by the electric power sector Billion Btu
208 HYEGB 1984 3352809 Hydropower for electricity generation by the electric power sector Billion Btu
209 HYEGB 1985 2937168 Hydropower for electricity generation by the electric power sector Billion Btu
210 HYEGB 1986 3038157 Hydropower for electricity generation by the electric power sector Billion Btu
211 HYEGB 1987 2601572 Hydropower for electricity generation by the electric power sector Billion Btu
212 HYEGB 1988 2301629 Hydropower for electricity generation by the electric power sector Billion Btu
213 HYEGB 1989 2808182 Hydropower for electricity generation by the electric power sector Billion Btu
214 HYEGB 1990 3014012 Hydropower for electricity generation by the electric power sector Billion Btu
215 HYEGB 1991 2984899 Hydropower for electricity generation by the electric power sector Billion Btu
216 HYEGB 1992 2585662 Hydropower for electricity generation by the electric power sector Billion Btu
217 HYEGB 1993 2860991 Hydropower for electricity generation by the electric power sector Billion Btu
218 HYEGB 1994 2620314 Hydropower for electricity generation by the electric power sector Billion Btu
219 HYEGB 1995 3149392 Hydropower for electricity generation by the electric power sector Billion Btu
220 HYEGB 1996 3527582 Hydropower for electricity generation by the electric power sector Billion Btu
221 HYEGB 1997 3581168 Hydropower for electricity generation by the electric power sector Billion Btu
222 HYEGB 1998 3241286 Hydropower for electricity generation by the electric power sector Billion Btu
223 HYEGB 1999 3217744 Hydropower for electricity generation by the electric power sector Billion Btu
224 HYEGB 2000 2767916 Hydropower for electricity generation by the electric power sector Billion Btu
225 HYEGB 2001 2208671 Hydropower for electricity generation by the electric power sector Billion Btu
226 HYEGB 2002 2649979 Hydropower for electricity generation by the electric power sector Billion Btu
227 HYEGB 2003 2749056 Hydropower for electricity generation by the electric power sector Billion Btu
228 HYEGB 2004 2654880 Hydropower for electricity generation by the electric power sector Billion Btu
229 HYEGB 2005 2670131 Hydropower for electricity generation by the electric power sector Billion Btu
230 HYEGB 2006 2839353 Hydropower for electricity generation by the electric power sector Billion Btu
231 HYEGB 2007 2429909 Hydropower for electricity generation by the electric power sector Billion Btu
232 HYEGB 2008 2494003 Hydropower for electricity generation by the electric power sector Billion Btu
233 HYEGB 2009 2649898 Hydropower for electricity generation by the electric power sector Billion Btu
234 HYEGB 2010 2521486 Hydropower for electricity generation by the electric power sector Billion Btu
235 HYEGB 2011 3085127 Hydropower for electricity generation by the electric power sector Billion Btu
236 HYEGB 2012 2606047 Hydropower for electricity generation by the electric power sector Billion Btu
237 HYEGB 2013 2528923 Hydropower for electricity generation by the electric power sector Billion Btu
238 HYEGB 2014 2454019 Hydropower for electricity generation by the electric power sector Billion Btu
239 HYEGB 2015 2307717 Hydropower for electricity generation by the electric power sector Billion Btu
240 HYEGB 2016 2458721 Hydropower for electricity generation by the electric power sector Billion Btu
241 HYEGB 2017 2752024 Hydropower for electricity generation by the electric power sector Billion Btu
242 HYEGB 2018 2650608 Hydropower for electricity generation by the electric power sector Billion Btu
243 HYEGB 2019 2552636 Hydropower for electricity generation by the electric power sector Billion Btu
244 HYEGB 2020 2492052 Hydropower for electricity generation by the electric power sector Billion Btu
245 NGEIB 1960 1785129 Natural gas by the electric power sector Billion Btu
246 NGEIB 1961 1888996 Natural gas by the electric power sector Billion Btu
247 NGEIB 1962 2034783 Natural gas by the electric power sector Billion Btu
248 NGEIB 1963 2219740 Natural gas by the electric power sector Billion Btu
249 NGEIB 1964 2409105 Natural gas by the electric power sector Billion Btu
250 NGEIB 1965 2408483 Natural gas by the electric power sector Billion Btu
251 NGEIB 1966 2713021 Natural gas by the electric power sector Billion Btu
252 NGEIB 1967 2852698 Natural gas by the electric power sector Billion Btu
253 NGEIB 1968 3263255 Natural gas by the electric power sector Billion Btu
254 NGEIB 1969 3608770 Natural gas by the electric power sector Billion Btu
255 NGEIB 1970 4047608 Natural gas by the electric power sector Billion Btu
256 NGEIB 1971 4091837 Natural gas by the electric power sector Billion Btu
257 NGEIB 1972 4084865 Natural gas by the electric power sector Billion Btu
258 NGEIB 1973 3737666 Natural gas by the electric power sector Billion Btu
259 NGEIB 1974 3511446 Natural gas by the electric power sector Billion Btu
260 NGEIB 1975 3231601 Natural gas by the electric power sector Billion Btu
261 NGEIB 1976 3153102 Natural gas by the electric power sector Billion Btu
262 NGEIB 1977 3281850 Natural gas by the electric power sector Billion Btu
263 NGEIB 1978 3293224 Natural gas by the electric power sector Billion Btu
264 NGEIB 1979 3604419 Natural gas by the electric power sector Billion Btu
265 NGEIB 1980 3803559 Natural gas by the electric power sector Billion Btu
266 NGEIB 1981 3758745 Natural gas by the electric power sector Billion Btu
267 NGEIB 1982 3335052 Natural gas by the electric power sector Billion Btu
268 NGEIB 1983 2992082 Natural gas by the electric power sector Billion Btu
269 NGEIB 1984 3215002 Natural gas by the electric power sector Billion Btu
270 NGEIB 1985 3156898 Natural gas by the electric power sector Billion Btu
271 NGEIB 1986 2688540 Natural gas by the electric power sector Billion Btu
272 NGEIB 1987 2933713 Natural gas by the electric power sector Billion Btu
273 NGEIB 1988 2707892 Natural gas by the electric power sector Billion Btu
274 NGEIB 1989 3190947 Natural gas by the electric power sector Billion Btu
275 NGEIB 1990 3333026 Natural gas by the electric power sector Billion Btu
276 NGEIB 1991 3399114 Natural gas by the electric power sector Billion Btu
277 NGEIB 1992 3534751 Natural gas by the electric power sector Billion Btu
278 NGEIB 1993 3559399 Natural gas by the electric power sector Billion Btu
279 NGEIB 1994 3999649 Natural gas by the electric power sector Billion Btu
280 NGEIB 1995 4326582 Natural gas by the electric power sector Billion Btu
281 NGEIB 1996 3881836 Natural gas by the electric power sector Billion Btu
282 NGEIB 1997 4146566 Natural gas by the electric power sector Billion Btu
283 NGEIB 1998 4697507 Natural gas by the electric power sector Billion Btu
284 NGEIB 1999 4923553 Natural gas by the electric power sector Billion Btu
285 NGEIB 2000 5317691 Natural gas by the electric power sector Billion Btu
286 NGEIB 2001 5495837 Natural gas by the electric power sector Billion Btu
287 NGEIB 2002 5789323 Natural gas by the electric power sector Billion Btu
288 NGEIB 2003 5259181 Natural gas by the electric power sector Billion Btu
289 NGEIB 2004 5608613 Natural gas by the electric power sector Billion Btu
290 NGEIB 2005 6035810 Natural gas by the electric power sector Billion Btu
291 NGEIB 2006 6393820 Natural gas by the electric power sector Billion Btu
292 NGEIB 2007 7028340 Natural gas by the electric power sector Billion Btu
293 NGEIB 2008 6849356 Natural gas by the electric power sector Billion Btu
294 NGEIB 2009 7043916 Natural gas by the electric power sector Billion Btu
295 NGEIB 2010 7550276 Natural gas by the electric power sector Billion Btu
296 NGEIB 2011 7733627 Natural gas by the electric power sector Billion Btu
297 NGEIB 2012 9312820 Natural gas by the electric power sector Billion Btu
298 NGEIB 2013 8397689 Natural gas by the electric power sector Billion Btu
299 NGEIB 2014 8384516 Natural gas by the electric power sector Billion Btu
300 NGEIB 2015 9945330 Natural gas by the electric power sector Billion Btu
301 NGEIB 2016 10325030 Natural gas by the electric power sector Billion Btu
302 NGEIB 2017 9578309 Natural gas by the electric power sector Billion Btu
303 NGEIB 2018 10942466 Natural gas by the electric power sector Billion Btu
304 NGEIB 2019 11675619 Natural gas by the electric power sector Billion Btu
305 NGEIB 2020 12010976 Natural gas by the electric power sector Billion Btu
306 NUEGB 1960 6026 Nuclear energy for electricity generation by the electric power sector Billion Btu
307 NUEGB 1961 19678 Nuclear energy for electricity generation by the electric power sector Billion Btu
308 NUEGB 1962 26394 Nuclear energy for electricity generation by the electric power sector Billion Btu
309 NUEGB 1963 38147 Nuclear energy for electricity generation by the electric power sector Billion Btu
310 NUEGB 1964 39819 Nuclear energy for electricity generation by the electric power sector Billion Btu
311 NUEGB 1965 43164 Nuclear energy for electricity generation by the electric power sector Billion Btu
312 NUEGB 1966 64158 Nuclear energy for electricity generation by the electric power sector Billion Btu
313 NUEGB 1967 88456 Nuclear energy for electricity generation by the electric power sector Billion Btu
314 NUEGB 1968 141534 Nuclear energy for electricity generation by the electric power sector Billion Btu
315 NUEGB 1969 153722 Nuclear energy for electricity generation by the electric power sector Billion Btu
316 NUEGB 1970 239347 Nuclear energy for electricity generation by the electric power sector Billion Btu
317 NUEGB 1971 412939 Nuclear energy for electricity generation by the electric power sector Billion Btu
318 NUEGB 1972 583752 Nuclear energy for electricity generation by the electric power sector Billion Btu
319 NUEGB 1973 910177 Nuclear energy for electricity generation by the electric power sector Billion Btu
320 NUEGB 1974 1272083 Nuclear energy for electricity generation by the electric power sector Billion Btu
321 NUEGB 1975 1899798 Nuclear energy for electricity generation by the electric power sector Billion Btu
322 NUEGB 1976 2111121 Nuclear energy for electricity generation by the electric power sector Billion Btu
323 NUEGB 1977 2701762 Nuclear energy for electricity generation by the electric power sector Billion Btu
324 NUEGB 1978 3024126 Nuclear energy for electricity generation by the electric power sector Billion Btu
325 NUEGB 1979 2775827 Nuclear energy for electricity generation by the electric power sector Billion Btu
326 NUEGB 1980 2739169 Nuclear energy for electricity generation by the electric power sector Billion Btu
327 NUEGB 1981 3007589 Nuclear energy for electricity generation by the electric power sector Billion Btu
328 NUEGB 1982 3131148 Nuclear energy for electricity generation by the electric power sector Billion Btu
329 NUEGB 1983 3202549 Nuclear energy for electricity generation by the electric power sector Billion Btu
330 NUEGB 1984 3552531 Nuclear energy for electricity generation by the electric power sector Billion Btu
331 NUEGB 1985 4075563 Nuclear energy for electricity generation by the electric power sector Billion Btu
332 NUEGB 1986 4380109 Nuclear energy for electricity generation by the electric power sector Billion Btu
333 NUEGB 1987 4753933 Nuclear energy for electricity generation by the electric power sector Billion Btu
334 NUEGB 1988 5586968 Nuclear energy for electricity generation by the electric power sector Billion Btu
335 NUEGB 1989 5602161 Nuclear energy for electricity generation by the electric power sector Billion Btu
336 NUEGB 1990 6104350 Nuclear energy for electricity generation by the electric power sector Billion Btu
337 NUEGB 1991 6422132 Nuclear energy for electricity generation by the electric power sector Billion Btu
338 NUEGB 1992 6479206 Nuclear energy for electricity generation by the electric power sector Billion Btu
339 NUEGB 1993 6410499 Nuclear energy for electricity generation by the electric power sector Billion Btu
340 NUEGB 1994 6693877 Nuclear energy for electricity generation by the electric power sector Billion Btu
341 NUEGB 1995 7075436 Nuclear energy for electricity generation by the electric power sector Billion Btu
342 NUEGB 1996 7086674 Nuclear energy for electricity generation by the electric power sector Billion Btu
343 NUEGB 1997 6596992 Nuclear energy for electricity generation by the electric power sector Billion Btu
344 NUEGB 1998 7067809 Nuclear energy for electricity generation by the electric power sector Billion Btu
345 NUEGB 1999 7610256 Nuclear energy for electricity generation by the electric power sector Billion Btu
346 NUEGB 2000 7862349 Nuclear energy for electricity generation by the electric power sector Billion Btu
347 NUEGB 2001 8028853 Nuclear energy for electricity generation by the electric power sector Billion Btu
348 NUEGB 2002 8145429 Nuclear energy for electricity generation by the electric power sector Billion Btu
349 NUEGB 2003 7959622 Nuclear energy for electricity generation by the electric power sector Billion Btu
350 NUEGB 2004 8222774 Nuclear energy for electricity generation by the electric power sector Billion Btu
351 NUEGB 2005 8160810 Nuclear energy for electricity generation by the electric power sector Billion Btu
352 NUEGB 2006 8214626 Nuclear energy for electricity generation by the electric power sector Billion Btu
353 NUEGB 2007 8458589 Nuclear energy for electricity generation by the electric power sector Billion Btu
354 NUEGB 2008 8426491 Nuclear energy for electricity generation by the electric power sector Billion Btu
355 NUEGB 2009 8355220 Nuclear energy for electricity generation by the electric power sector Billion Btu
356 NUEGB 2010 8434433 Nuclear energy for electricity generation by the electric power sector Billion Btu
357 NUEGB 2011 8268698 Nuclear energy for electricity generation by the electric power sector Billion Btu
358 NUEGB 2012 8061822 Nuclear energy for electricity generation by the electric power sector Billion Btu
359 NUEGB 2013 8244433 Nuclear energy for electricity generation by the electric power sector Billion Btu
360 NUEGB 2014 8337559 Nuclear energy for electricity generation by the electric power sector Billion Btu
361 NUEGB 2015 8336886 Nuclear energy for electricity generation by the electric power sector Billion Btu
362 NUEGB 2016 8426753 Nuclear energy for electricity generation by the electric power sector Billion Btu
363 NUEGB 2017 8418968 Nuclear energy for electricity generation by the electric power sector Billion Btu
364 NUEGB 2018 8438068 Nuclear energy for electricity generation by the electric power sector Billion Btu
365 NUEGB 2019 8451852 Nuclear energy for electricity generation by the electric power sector Billion Btu
366 NUEGB 2020 8247915 Nuclear energy for electricity generation by the electric power sector Billion Btu
367 PAEIB 1960 552715 All petroleum products by the electric power sector Billion Btu
368 PAEIB 1961 557278 All petroleum products by the electric power sector Billion Btu
369 PAEIB 1962 559585 All petroleum products by the electric power sector Billion Btu
370 PAEIB 1963 584707 All petroleum products by the electric power sector Billion Btu
371 PAEIB 1964 633882 All petroleum products by the electric power sector Billion Btu
372 PAEIB 1965 722002 All petroleum products by the electric power sector Billion Btu
373 PAEIB 1966 883230 All petroleum products by the electric power sector Billion Btu
374 PAEIB 1967 1010541 All petroleum products by the electric power sector Billion Btu
375 PAEIB 1968 1181450 All petroleum products by the electric power sector Billion Btu
376 PAEIB 1969 1571294 All petroleum products by the electric power sector Billion Btu
377 PAEIB 1970 2117337 All petroleum products by the electric power sector Billion Btu
378 PAEIB 1971 2494999 All petroleum products by the electric power sector Billion Btu
379 PAEIB 1972 3097087 All petroleum products by the electric power sector Billion Btu
380 PAEIB 1973 3514815 All petroleum products by the electric power sector Billion Btu
381 PAEIB 1974 3365031 All petroleum products by the electric power sector Billion Btu
382 PAEIB 1975 3165675 All petroleum products by the electric power sector Billion Btu
383 PAEIB 1976 3477133 All petroleum products by the electric power sector Billion Btu
384 PAEIB 1977 3900624 All petroleum products by the electric power sector Billion Btu
385 PAEIB 1978 3986863 All petroleum products by the electric power sector Billion Btu
386 PAEIB 1979 3283366 All petroleum products by the electric power sector Billion Btu
387 PAEIB 1980 2633561 All petroleum products by the electric power sector Billion Btu
388 PAEIB 1981 2201663 All petroleum products by the electric power sector Billion Btu
389 PAEIB 1982 1567654 All petroleum products by the electric power sector Billion Btu
390 PAEIB 1983 1543683 All petroleum products by the electric power sector Billion Btu
391 PAEIB 1984 1286116 All petroleum products by the electric power sector Billion Btu
392 PAEIB 1985 1090459 All petroleum products by the electric power sector Billion Btu
393 PAEIB 1986 1451843 All petroleum products by the electric power sector Billion Btu
394 PAEIB 1987 1256859 All petroleum products by the electric power sector Billion Btu
395 PAEIB 1988 1563425 All petroleum products by the electric power sector Billion Btu
396 PAEIB 1989 1703091 All petroleum products by the electric power sector Billion Btu
397 PAEIB 1990 1289433 All petroleum products by the electric power sector Billion Btu
398 PAEIB 1991 1198261 All petroleum products by the electric power sector Billion Btu
399 PAEIB 1992 990707 All petroleum products by the electric power sector Billion Btu
400 PAEIB 1993 1123790 All petroleum products by the electric power sector Billion Btu
401 PAEIB 1994 1058680 All petroleum products by the electric power sector Billion Btu
402 PAEIB 1995 754504 All petroleum products by the electric power sector Billion Btu
403 PAEIB 1996 817262 All petroleum products by the electric power sector Billion Btu
404 PAEIB 1997 926706 All petroleum products by the electric power sector Billion Btu
405 PAEIB 1998 1306095 All petroleum products by the electric power sector Billion Btu
406 PAEIB 1999 1211206 All petroleum products by the electric power sector Billion Btu
407 PAEIB 2000 1144140 All petroleum products by the electric power sector Billion Btu
408 PAEIB 2001 1276376 All petroleum products by the electric power sector Billion Btu
409 PAEIB 2002 961185 All petroleum products by the electric power sector Billion Btu
410 PAEIB 2003 1204819 All petroleum products by the electric power sector Billion Btu
411 PAEIB 2004 1200997 All petroleum products by the electric power sector Billion Btu
412 PAEIB 2005 1222065 All petroleum products by the electric power sector Billion Btu
413 PAEIB 2006 636958 All petroleum products by the electric power sector Billion Btu
414 PAEIB 2007 647831 All petroleum products by the electric power sector Billion Btu
415 PAEIB 2008 459335 All petroleum products by the electric power sector Billion Btu
416 PAEIB 2009 382323 All petroleum products by the electric power sector Billion Btu
417 PAEIB 2010 370284 All petroleum products by the electric power sector Billion Btu
418 PAEIB 2011 294975 All petroleum products by the electric power sector Billion Btu
419 PAEIB 2012 214141 All petroleum products by the electric power sector Billion Btu
420 PAEIB 2013 255057 All petroleum products by the electric power sector Billion Btu
421 PAEIB 2014 295327 All petroleum products by the electric power sector Billion Btu
422 PAEIB 2015 275830 All petroleum products by the electric power sector Billion Btu
423 PAEIB 2016 243747 All petroleum products by the electric power sector Billion Btu
424 PAEIB 2017 217579 All petroleum products by the electric power sector Billion Btu
425 PAEIB 2018 260168 All petroleum products by the electric power sector Billion Btu
426 PAEIB 2019 188474 All petroleum products by the electric power sector Billion Btu
427 PAEIB 2020 184290 All petroleum products by the electric power sector Billion Btu
428 PCEIB 1960 0 Petroleum coke by the electric power sector Billion Btu
429 PCEIB 1961 0 Petroleum coke by the electric power sector Billion Btu
430 PCEIB 1962 0 Petroleum coke by the electric power sector Billion Btu
431 PCEIB 1963 0 Petroleum coke by the electric power sector Billion Btu
432 PCEIB 1964 0 Petroleum coke by the electric power sector Billion Btu
433 PCEIB 1965 0 Petroleum coke by the electric power sector Billion Btu
434 PCEIB 1966 0 Petroleum coke by the electric power sector Billion Btu
435 PCEIB 1967 0 Petroleum coke by the electric power sector Billion Btu
436 PCEIB 1968 0 Petroleum coke by the electric power sector Billion Btu
437 PCEIB 1969 0 Petroleum coke by the electric power sector Billion Btu
438 PCEIB 1970 19169 Petroleum coke by the electric power sector Billion Btu
439 PCEIB 1971 18228 Petroleum coke by the electric power sector Billion Btu
440 PCEIB 1972 18894 Petroleum coke by the electric power sector Billion Btu
441 PCEIB 1973 15262 Petroleum coke by the electric power sector Billion Btu
442 PCEIB 1974 18826 Petroleum coke by the electric power sector Billion Btu
443 PCEIB 1975 2113 Petroleum coke by the electric power sector Billion Btu
444 PCEIB 1976 2050 Petroleum coke by the electric power sector Billion Btu
445 PCEIB 1977 2938 Petroleum coke by the electric power sector Billion Btu
446 PCEIB 1978 11996 Petroleum coke by the electric power sector Billion Btu
447 PCEIB 1979 8069 Petroleum coke by the electric power sector Billion Btu
448 PCEIB 1980 5397 Petroleum coke by the electric power sector Billion Btu
449 PCEIB 1981 4183 Petroleum coke by the electric power sector Billion Btu
450 PCEIB 1982 4498 Petroleum coke by the electric power sector Billion Btu
451 PCEIB 1983 7875 Petroleum coke by the electric power sector Billion Btu
452 PCEIB 1984 7576 Petroleum coke by the electric power sector Billion Btu
453 PCEIB 1985 6968 Petroleum coke by the electric power sector Billion Btu
454 PCEIB 1986 9418 Petroleum coke by the electric power sector Billion Btu
455 PCEIB 1987 10469 Petroleum coke by the electric power sector Billion Btu
456 PCEIB 1988 12319 Petroleum coke by the electric power sector Billion Btu
457 PCEIB 1989 15584 Petroleum coke by the electric power sector Billion Btu
458 PCEIB 1990 30367 Petroleum coke by the electric power sector Billion Btu
459 PCEIB 1991 29329 Petroleum coke by the electric power sector Billion Btu
460 PCEIB 1992 45006 Petroleum coke by the electric power sector Billion Btu
461 PCEIB 1993 78648 Petroleum coke by the electric power sector Billion Btu
462 PCEIB 1994 69717 Petroleum coke by the electric power sector Billion Btu
463 PCEIB 1995 80556 Petroleum coke by the electric power sector Billion Btu
464 PCEIB 1996 79571 Petroleum coke by the electric power sector Billion Btu
465 PCEIB 1997 101558 Petroleum coke by the electric power sector Billion Btu
466 PCEIB 1998 123554 Petroleum coke by the electric power sector Billion Btu
467 PCEIB 1999 112491 Petroleum coke by the electric power sector Billion Btu
468 PCEIB 2000 98641 Petroleum coke by the electric power sector Billion Btu
469 PCEIB 2001 103226 Petroleum coke by the electric power sector Billion Btu
470 PCEIB 2002 175176 Petroleum coke by the electric power sector Billion Btu
471 PCEIB 2003 174667 Petroleum coke by the electric power sector Billion Btu
472 PCEIB 2004 210811 Petroleum coke by the electric power sector Billion Btu
473 PCEIB 2005 231132 Petroleum coke by the electric power sector Billion Btu
474 PCEIB 2006 203043 Petroleum coke by the electric power sector Billion Btu
475 PCEIB 2007 162557 Petroleum coke by the electric power sector Billion Btu
476 PCEIB 2008 146391 Petroleum coke by the electric power sector Billion Btu
477 PCEIB 2009 131842 Petroleum coke by the electric power sector Billion Btu
478 PCEIB 2010 136595 Petroleum coke by the electric power sector Billion Btu
479 PCEIB 2011 138320 Petroleum coke by the electric power sector Billion Btu
480 PCEIB 2012 85054 Petroleum coke by the electric power sector Billion Btu
481 PCEIB 2013 122518 Petroleum coke by the electric power sector Billion Btu
482 PCEIB 2014 118155 Petroleum coke by the electric power sector Billion Btu
483 PCEIB 2015 111716 Petroleum coke by the electric power sector Billion Btu
484 PCEIB 2016 118317 Petroleum coke by the electric power sector Billion Btu
485 PCEIB 2017 97208 Petroleum coke by the electric power sector Billion Btu
486 PCEIB 2018 101482 Petroleum coke by the electric power sector Billion Btu
487 PCEIB 2019 75913 Petroleum coke by the electric power sector Billion Btu
488 PCEIB 2020 87427 Petroleum coke by the electric power sector Billion Btu
489 SOEGB 1960 0 Solar energy for electricity generation by the electric power sector Billion Btu
490 SOEGB 1961 0 Solar energy for electricity generation by the electric power sector Billion Btu
491 SOEGB 1962 0 Solar energy for electricity generation by the electric power sector Billion Btu
492 SOEGB 1963 0 Solar energy for electricity generation by the electric power sector Billion Btu
493 SOEGB 1964 0 Solar energy for electricity generation by the electric power sector Billion Btu
494 SOEGB 1965 0 Solar energy for electricity generation by the electric power sector Billion Btu
495 SOEGB 1966 0 Solar energy for electricity generation by the electric power sector Billion Btu
496 SOEGB 1967 0 Solar energy for electricity generation by the electric power sector Billion Btu
497 SOEGB 1968 0 Solar energy for electricity generation by the electric power sector Billion Btu
498 SOEGB 1969 0 Solar energy for electricity generation by the electric power sector Billion Btu
499 SOEGB 1970 0 Solar energy for electricity generation by the electric power sector Billion Btu
500 SOEGB 1971 0 Solar energy for electricity generation by the electric power sector Billion Btu
501 SOEGB 1972 0 Solar energy for electricity generation by the electric power sector Billion Btu
502 SOEGB 1973 0 Solar energy for electricity generation by the electric power sector Billion Btu
503 SOEGB 1974 0 Solar energy for electricity generation by the electric power sector Billion Btu
504 SOEGB 1975 0 Solar energy for electricity generation by the electric power sector Billion Btu
505 SOEGB 1976 0 Solar energy for electricity generation by the electric power sector Billion Btu
506 SOEGB 1977 0 Solar energy for electricity generation by the electric power sector Billion Btu
507 SOEGB 1978 0 Solar energy for electricity generation by the electric power sector Billion Btu
508 SOEGB 1979 0 Solar energy for electricity generation by the electric power sector Billion Btu
509 SOEGB 1980 0 Solar energy for electricity generation by the electric power sector Billion Btu
510 SOEGB 1981 0 Solar energy for electricity generation by the electric power sector Billion Btu
511 SOEGB 1982 0 Solar energy for electricity generation by the electric power sector Billion Btu
512 SOEGB 1983 0 Solar energy for electricity generation by the electric power sector Billion Btu
513 SOEGB 1984 55 Solar energy for electricity generation by the electric power sector Billion Btu
514 SOEGB 1985 111 Solar energy for electricity generation by the electric power sector Billion Btu
515 SOEGB 1986 147 Solar energy for electricity generation by the electric power sector Billion Btu
516 SOEGB 1987 109 Solar energy for electricity generation by the electric power sector Billion Btu
517 SOEGB 1988 94 Solar energy for electricity generation by the electric power sector Billion Btu
518 SOEGB 1989 2614 Solar energy for electricity generation by the electric power sector Billion Btu
519 SOEGB 1990 3818 Solar energy for electricity generation by the electric power sector Billion Btu
520 SOEGB 1991 4923 Solar energy for electricity generation by the electric power sector Billion Btu
521 SOEGB 1992 4133 Solar energy for electricity generation by the electric power sector Billion Btu
522 SOEGB 1993 4767 Solar energy for electricity generation by the electric power sector Billion Btu
523 SOEGB 1994 5020 Solar energy for electricity generation by the electric power sector Billion Btu
524 SOEGB 1995 5123 Solar energy for electricity generation by the electric power sector Billion Btu
525 SOEGB 1996 5389 Solar energy for electricity generation by the electric power sector Billion Btu
526 SOEGB 1997 5221 Solar energy for electricity generation by the electric power sector Billion Btu
527 SOEGB 1998 5124 Solar energy for electricity generation by the electric power sector Billion Btu
528 SOEGB 1999 5063 Solar energy for electricity generation by the electric power sector Billion Btu
529 SOEGB 2000 5033 Solar energy for electricity generation by the electric power sector Billion Btu
530 SOEGB 2001 5608 Solar energy for electricity generation by the electric power sector Billion Btu
531 SOEGB 2002 5644 Solar energy for electricity generation by the electric power sector Billion Btu
532 SOEGB 2003 5407 Solar energy for electricity generation by the electric power sector Billion Btu
533 SOEGB 2004 5761 Solar energy for electricity generation by the electric power sector Billion Btu
534 SOEGB 2005 5502 Solar energy for electricity generation by the electric power sector Billion Btu
535 SOEGB 2006 5036 Solar energy for electricity generation by the electric power sector Billion Btu
536 SOEGB 2007 6047 Solar energy for electricity generation by the electric power sector Billion Btu
537 SOEGB 2008 8516 Solar energy for electricity generation by the electric power sector Billion Btu
538 SOEGB 2009 8697 Solar energy for electricity generation by the electric power sector Billion Btu
539 SOEGB 2010 11762 Solar energy for electricity generation by the electric power sector Billion Btu
540 SOEGB 2011 16782 Solar energy for electricity generation by the electric power sector Billion Btu
541 SOEGB 2012 39625 Solar energy for electricity generation by the electric power sector Billion Btu
542 SOEGB 2013 83240 Solar energy for electricity generation by the electric power sector Billion Btu
543 SOEGB 2014 164562 Solar energy for electricity generation by the electric power sector Billion Btu
544 SOEGB 2015 227901 Solar energy for electricity generation by the electric power sector Billion Btu
545 SOEGB 2016 327712 Solar energy for electricity generation by the electric power sector Billion Btu
546 SOEGB 2017 485742 Solar energy for electricity generation by the electric power sector Billion Btu
547 SOEGB 2018 575854 Solar energy for electricity generation by the electric power sector Billion Btu
548 SOEGB 2019 634613 Solar energy for electricity generation by the electric power sector Billion Btu
549 SOEGB 2020 776511 Solar energy for electricity generation by the electric power sector Billion Btu
550 TEEIB 1960 8156973 Total energy by the electric power sector Billion Btu
551 TEEIB 1961 8451672 Total energy by the electric power sector Billion Btu
552 TEEIB 1962 9027590 Total energy by the electric power sector Billion Btu
553 TEEIB 1963 9633531 Total energy by the electric power sector Billion Btu
554 TEEIB 1964 10325462 Total energy by the electric power sector Billion Btu
555 TEEIB 1965 11025629 Total energy by the electric power sector Billion Btu
556 TEEIB 1966 11999503 Total energy by the electric power sector Billion Btu
557 TEEIB 1967 12713020 Total energy by the electric power sector Billion Btu
558 TEEIB 1968 13899552 Total energy by the electric power sector Billion Btu
559 TEEIB 1969 15180137 Total energy by the electric power sector Billion Btu
560 TEEIB 1970 16247746 Total energy by the electric power sector Billion Btu
561 TEEIB 1971 17110473 Total energy by the electric power sector Billion Btu
562 TEEIB 1972 18482409 Total energy by the electric power sector Billion Btu
563 TEEIB 1973 19721801 Total energy by the electric power sector Billion Btu
564 TEEIB 1974 19902184 Total energy by the electric power sector Billion Btu
565 TEEIB 1975 20265511 Total energy by the electric power sector Billion Btu
566 TEEIB 1976 21484563 Total energy by the electric power sector Billion Btu
567 TEEIB 1977 22545459 Total energy by the electric power sector Billion Btu
568 TEEIB 1978 23564742 Total energy by the electric power sector Billion Btu
569 TEEIB 1979 23945259 Total energy by the electric power sector Billion Btu
570 TEEIB 1980 24324399 Total energy by the electric power sector Billion Btu
571 TEEIB 1981 24486837 Total energy by the electric power sector Billion Btu
572 TEEIB 1982 23953700 Total energy by the electric power sector Billion Btu
573 TEEIB 1983 24600825 Total energy by the electric power sector Billion Btu
574 TEEIB 1984 25589606 Total energy by the electric power sector Billion Btu
575 TEEIB 1985 26093891 Total energy by the electric power sector Billion Btu
576 TEEIB 1986 26217282 Total energy by the electric power sector Billion Btu
577 TEEIB 1987 26942577 Total energy by the electric power sector Billion Btu
578 TEEIB 1988 28274388 Total energy by the electric power sector Billion Btu
579 TEEIB 1989 29881381 Total energy by the electric power sector Billion Btu
580 TEEIB 1990 30510355 Total energy by the electric power sector Billion Btu
581 TEEIB 1991 30867954 Total energy by the electric power sector Billion Btu
582 TEEIB 1992 30737406 Total energy by the electric power sector Billion Btu
583 TEEIB 1993 31860085 Total energy by the electric power sector Billion Btu
584 TEEIB 1994 32412456 Total energy by the electric power sector Billion Btu
585 TEEIB 1995 33495365 Total energy by the electric power sector Billion Btu
586 TEEIB 1996 34497168 Total energy by the electric power sector Billion Btu
587 TEEIB 1997 34899402 Total energy by the electric power sector Billion Btu
588 TEEIB 1998 36240040 Total energy by the electric power sector Billion Btu
589 TEEIB 1999 36989517 Total energy by the electric power sector Billion Btu
590 TEEIB 2000 38079049 Total energy by the electric power sector Billion Btu
591 TEEIB 2001 37245293 Total energy by the electric power sector Billion Btu
592 TEEIB 2002 38034497 Total energy by the electric power sector Billion Btu
593 TEEIB 2003 38031754 Total energy by the electric power sector Billion Btu
594 TEEIB 2004 38705055 Total energy by the electric power sector Billion Btu
595 TEEIB 2005 39635034 Total energy by the electric power sector Billion Btu
596 TEEIB 2006 39423299 Total energy by the electric power sector Billion Btu
597 TEEIB 2007 40380816 Total energy by the electric power sector Billion Btu
598 TEEIB 2008 39979135 Total energy by the electric power sector Billion Btu
599 TEEIB 2009 38081040 Total energy by the electric power sector Billion Btu
600 TEEIB 2010 39637160 Total energy by the electric power sector Billion Btu
601 TEEIB 2011 39310609 Total energy by the electric power sector Billion Btu
602 TEEIB 2012 38151544 Total energy by the electric power sector Billion Btu
603 TEEIB 2013 38374061 Total energy by the electric power sector Billion Btu
604 TEEIB 2014 38647765 Total energy by the electric power sector Billion Btu
605 TEEIB 2015 37901687 Total energy by the electric power sector Billion Btu
606 TEEIB 2016 37743243 Total energy by the electric power sector Billion Btu
607 TEEIB 2017 37256169 Total energy by the electric power sector Billion Btu
608 TEEIB 2018 38182669 Total energy by the electric power sector Billion Btu
609 TEEIB 2019 37022412 Total energy by the electric power sector Billion Btu
610 TEEIB 2020 35611606 Total energy by the electric power sector Billion Btu
611 WYEGB 1960 0 Wind energy for electricity generation by the electric power sector Billion Btu
612 WYEGB 1961 0 Wind energy for electricity generation by the electric power sector Billion Btu
613 WYEGB 1962 0 Wind energy for electricity generation by the electric power sector Billion Btu
614 WYEGB 1963 0 Wind energy for electricity generation by the electric power sector Billion Btu
615 WYEGB 1964 0 Wind energy for electricity generation by the electric power sector Billion Btu
616 WYEGB 1965 0 Wind energy for electricity generation by the electric power sector Billion Btu
617 WYEGB 1966 0 Wind energy for electricity generation by the electric power sector Billion Btu
618 WYEGB 1967 0 Wind energy for electricity generation by the electric power sector Billion Btu
619 WYEGB 1968 0 Wind energy for electricity generation by the electric power sector Billion Btu
620 WYEGB 1969 0 Wind energy for electricity generation by the electric power sector Billion Btu
621 WYEGB 1970 0 Wind energy for electricity generation by the electric power sector Billion Btu
622 WYEGB 1971 0 Wind energy for electricity generation by the electric power sector Billion Btu
623 WYEGB 1972 0 Wind energy for electricity generation by the electric power sector Billion Btu
624 WYEGB 1973 0 Wind energy for electricity generation by the electric power sector Billion Btu
625 WYEGB 1974 0 Wind energy for electricity generation by the electric power sector Billion Btu
626 WYEGB 1975 0 Wind energy for electricity generation by the electric power sector Billion Btu
627 WYEGB 1976 0 Wind energy for electricity generation by the electric power sector Billion Btu
628 WYEGB 1977 0 Wind energy for electricity generation by the electric power sector Billion Btu
629 WYEGB 1978 0 Wind energy for electricity generation by the electric power sector Billion Btu
630 WYEGB 1979 0 Wind energy for electricity generation by the electric power sector Billion Btu
631 WYEGB 1980 0 Wind energy for electricity generation by the electric power sector Billion Btu
632 WYEGB 1981 0 Wind energy for electricity generation by the electric power sector Billion Btu
633 WYEGB 1982 0 Wind energy for electricity generation by the electric power sector Billion Btu
634 WYEGB 1983 28 Wind energy for electricity generation by the electric power sector Billion Btu
635 WYEGB 1984 68 Wind energy for electricity generation by the electric power sector Billion Btu
636 WYEGB 1985 60 Wind energy for electricity generation by the electric power sector Billion Btu
637 WYEGB 1986 44 Wind energy for electricity generation by the electric power sector Billion Btu
638 WYEGB 1987 37 Wind energy for electricity generation by the electric power sector Billion Btu
639 WYEGB 1988 9 Wind energy for electricity generation by the electric power sector Billion Btu
640 WYEGB 1989 22033 Wind energy for electricity generation by the electric power sector Billion Btu
641 WYEGB 1990 29007 Wind energy for electricity generation by the electric power sector Billion Btu
642 WYEGB 1991 30796 Wind energy for electricity generation by the electric power sector Billion Btu
643 WYEGB 1992 29863 Wind energy for electricity generation by the electric power sector Billion Btu
644 WYEGB 1993 30987 Wind energy for electricity generation by the electric power sector Billion Btu
645 WYEGB 1994 35560 Wind energy for electricity generation by the electric power sector Billion Btu
646 WYEGB 1995 32630 Wind energy for electricity generation by the electric power sector Billion Btu
647 WYEGB 1996 33440 Wind energy for electricity generation by the electric power sector Billion Btu
648 WYEGB 1997 33581 Wind energy for electricity generation by the electric power sector Billion Btu
649 WYEGB 1998 30853 Wind energy for electricity generation by the electric power sector Billion Btu
650 WYEGB 1999 45894 Wind energy for electricity generation by the electric power sector Billion Btu
651 WYEGB 2000 57057 Wind energy for electricity generation by the electric power sector Billion Btu
652 WYEGB 2001 69617 Wind energy for electricity generation by the electric power sector Billion Btu
653 WYEGB 2002 105334 Wind energy for electricity generation by the electric power sector Billion Btu
654 WYEGB 2003 113273 Wind energy for electricity generation by the electric power sector Billion Btu
655 WYEGB 2004 141664 Wind energy for electricity generation by the electric power sector Billion Btu
656 WYEGB 2005 178088 Wind energy for electricity generation by the electric power sector Billion Btu
657 WYEGB 2006 263738 Wind energy for electricity generation by the electric power sector Billion Btu
658 WYEGB 2007 340503 Wind energy for electricity generation by the electric power sector Billion Btu
659 WYEGB 2008 545548 Wind energy for electricity generation by the electric power sector Billion Btu
660 WYEGB 2009 721127 Wind energy for electricity generation by the electric power sector Billion Btu
661 WYEGB 2010 923271 Wind energy for electricity generation by the electric power sector Billion Btu
662 WYEGB 2011 1167094 Wind energy for electricity generation by the electric power sector Billion Btu
663 WYEGB 2012 1339365 Wind energy for electricity generation by the electric power sector Billion Btu
664 WYEGB 2013 1600424 Wind energy for electricity generation by the electric power sector Billion Btu
665 WYEGB 2014 1726026 Wind energy for electricity generation by the electric power sector Billion Btu
666 WYEGB 2015 1775705 Wind energy for electricity generation by the electric power sector Billion Btu
667 WYEGB 2016 2093728 Wind energy for electricity generation by the electric power sector Billion Btu
668 WYEGB 2017 2340784 Wind energy for electricity generation by the electric power sector Billion Btu
669 WYEGB 2018 2479897 Wind energy for electricity generation by the electric power sector Billion Btu
670 WYEGB 2019 2632354 Wind energy for electricity generation by the electric power sector Billion Btu
671 WYEGB 2020 2957843 Wind energy for electricity generation by the electric power sector Billion Btu 
totale <- ggplot(data=seds4) +
  geom_line(aes(x=year,y=energycons, col=description),lwd=0.5) +
  scale_color_brewer(palette = "Paired") +
  ggtitle("Total Energy Consumption by Sector in the US, billions of Btu")
## Warning: Using `size` aesthetic for lines was deprecated in ggplot2 3.4.0.
## ℹ Please use `linewidth` instead.
ggplotly(totale)

#Comparing the U.S. total energy consumption by the electric sector in GA, FL, CA, TX and the US as a whole for the year 2020.

# Comparing total energy consumption in four US states and the US as a whole. 

five_seds <- seds1 %>% 
  left_join(stateinfo1,
            by=c(statecode="stateabbr")) %>% 
          filter(msn %in% c("CLEIB","TEEIB", "NGEIB", "NUEGB", "SOEGB", "DFEIB" ,"WYEGB", "PCEIB", "GEEGB","PAEIB","HYEGB")) %>% 
  filter(statecode %in% c("GA", "FL", "CA", "TX", "US")) %>% 
  filter(year=="2020")

clean_five <- five_seds[, c("msn", "year", "data", "statecode")]

clean_five2 <- clean_five %>% 
        left_join(msn1, by=c("msn")) %>% 
        separate(col=description, c('description','destination'), sep=" consumed ")


tot_consumption <- clean_five2 %>% 
  group_by(statecode, msn, description, unit) %>% 
  filter(year=="2020" & statecode!= "US" & msn != "TEEIB")
tot_gen_plot <- ggplot(data=tot_consumption, aes(x=statecode, y=data, fill=description))+
  geom_bar(stat = "identity")+
  scale_y_continuous(labels=comma, n.breaks = 5)+
  xlab("State")+ ylab("Energy in Billion Btu")
  

ggplotly(tot_gen_plot)
tot_con_all <- clean_five2 %>% 
  group_by(statecode, msn, description, unit) %>% 
  filter(year=="2020" & msn != "TEEIB")

all_compared <- ggplot(data=tot_con_all, aes(x=statecode, y=data, fill=description))+
  geom_bar(stat = "identity")+
  scale_y_continuous(labels=comma, n.breaks = 5)+
  xlab("State")+ ylab("Energy in Billion Btu")
  
ggplotly(all_compared)

#Table showcasing the total energy consumption for the year 2020 in GA, FL, CA, TX, and the US as a whole. #Total Energy is in Billions of Btu.

final_table <- clean_five2[, c("description", "year", "data", "statecode")]

final_table2 <- final_table %>% 
            pivot_wider(names_from = "statecode", values_from = "data") 


kable(final_table2, digits = 2, format = "html", row.names = TRUE, caption ="Table 2: Total Energy Consumption: Electric Power Sector- Year 2020 ( Billion Btu)") %>%
  kable_styling(bootstrap_options = c("striped", "hover"),
                full_width = F,
                font_size = 14,
                position = "left")
Table 2: Total Energy Consumption: Electric Power Sector- Year 2020 ( Billion Btu)
description year CA FL GA TX US
1 Coal 2020 0 174940 146279 866717 8229142
2 Distillate fuel oil 2020 359 1605 594 523 44167
3 Geothermal energy 2020 99718 0 0 0 135462
4 Hydropower 2020 187491 2033 40720 9462 2492052
5 Natural gas 2020 635462 1394330 439637 1773446 12010976
6 Nuclear energy 2020 169773 307197 342766 432703 8247915
7 All petroleum products 2020 359 17773 594 523 184290
8 Petroleum coke 2020 0 15565 0 0 87427
9 Solar energy 2020 263718 57008 33134 74868 776511
10 Total energy 2020 1547830 1998429 1026372 3962219 35611606
11 Wind energy 2020 119069 0 0 810501 2957843

#Section 2: Calculating Total CO2 Emissions w/ CO2 coefficients

coef_co2 <- read_xlsx(here("egrid-coef.xlsx"))
         
         
kable(coef_co2, format = "html", row.names = TRUE, caption = "Table 3: CO2 coefficients, year 2020") %>%
  kable_styling(bootstrap_options = c("striped", "hover"),
                full_width = T,
                font_size = 14,
                position = "left")
Table 3: CO2 coefficients, year 2020
msn coef
1 SOEGB 0.00000
2 PCEIB 102.12000
3 NGEIB 52.91000
4 HYEGB 0.00000
5 CLEIB 95.77333
6 NUEGB 0.00000
7 WYEGB 0.00000
8 GEEGB 0.00000
9 DFEIB 74.14000

#Language Derived from EGRID2 Lab Created by Professor Drummond: #Section 2 reads CO2 coefficients for egrid fuels. coefficients represent grams of CO2 released per 1,000 btu of fuel burned.

#Note 1: since a coefficient is grams of CO2 / 1000 btu, we convert millions of btu (btum) to thousands of btu when we divide by 10^3.

#Note 2: the result of multiplying the coefficient times btu thousands is grams of CO2. There are 1 million (10^6) grams in a metric ton and one million metric tons in 1 mmt so we divide grams by 10^12 to calculate millions of metric tons of CO2 released.

seds6 <- seds4[c("msn", "energycons", "year")] %>% 
         left_join(coef_co2, by=c("msn"))  
         
#Result in million metric tons of CO2

seds6$CO2em <- seds6$energycons * seds6$coef/ 10^6 
calc_sum <- seds6 %>% filter(!is.na(coef)) %>% 
            group_by(year) %>% 
            summarise(CO2sum = sum(CO2em))


co2_tot <- ggplot(data = calc_sum, aes(x =year, y =CO2sum))+
   geom_line(colour = "darkseagreen2", lwd=1) +
   ggtitle("Total CO2 Emissions by the Electric Sector, All fuels in the US")

ggplotly(co2_tot)

#Calculating CO2 EMissions for five US States in comparison with the US as a whole #Results in million metric tons of CO2.

clean_five6 <- clean_five2[c("msn","statecode", "data", "year")] %>% 
              filter(msn != "TEEIB") 
             
         
seds7 <- clean_five6 %>% 
         left_join(coef_co2, by=c("msn")) 
         

seds7$CO2em <- seds7$data * seds7$coef/ 10^6 

kable(seds7, digits = 2, format = "html", row.names = TRUE, caption = "Table 4: CO2 Electricity Emissions- Comparison by MSN- Year 2020 - Million Metric Tons of CO2)") %>%
  kable_styling(bootstrap_options = c("striped"),
                full_width = T,
                font_size = 15) %>%
   scroll_box(height = "600px")
Table 4: CO2 Electricity Emissions- Comparison by MSN- Year 2020 - Million Metric Tons of CO2)
msn statecode data year coef CO2em
1 CLEIB CA 0 2020 95.77 0.00
2 CLEIB FL 174940 2020 95.77 16.75
3 CLEIB GA 146279 2020 95.77 14.01
4 CLEIB TX 866717 2020 95.77 83.01
5 CLEIB US 8229142 2020 95.77 788.13
6 DFEIB CA 359 2020 74.14 0.03
7 DFEIB FL 1605 2020 74.14 0.12
8 DFEIB GA 594 2020 74.14 0.04
9 DFEIB TX 523 2020 74.14 0.04
10 DFEIB US 44167 2020 74.14 3.27
11 GEEGB CA 99718 2020 0.00 0.00
12 GEEGB FL 0 2020 0.00 0.00
13 GEEGB GA 0 2020 0.00 0.00
14 GEEGB TX 0 2020 0.00 0.00
15 GEEGB US 135462 2020 0.00 0.00
16 HYEGB CA 187491 2020 0.00 0.00
17 HYEGB FL 2033 2020 0.00 0.00
18 HYEGB GA 40720 2020 0.00 0.00
19 HYEGB TX 9462 2020 0.00 0.00
20 HYEGB US 2492052 2020 0.00 0.00
21 NGEIB CA 635462 2020 52.91 33.62
22 NGEIB FL 1394330 2020 52.91 73.77
23 NGEIB GA 439637 2020 52.91 23.26
24 NGEIB TX 1773446 2020 52.91 93.83
25 NGEIB US 12010976 2020 52.91 635.50
26 NUEGB CA 169773 2020 0.00 0.00
27 NUEGB FL 307197 2020 0.00 0.00
28 NUEGB GA 342766 2020 0.00 0.00
29 NUEGB TX 432703 2020 0.00 0.00
30 NUEGB US 8247915 2020 0.00 0.00
31 PAEIB CA 359 2020 NA NA
32 PAEIB FL 17773 2020 NA NA
33 PAEIB GA 594 2020 NA NA
34 PAEIB TX 523 2020 NA NA
35 PAEIB US 184290 2020 NA NA
36 PCEIB CA 0 2020 102.12 0.00
37 PCEIB FL 15565 2020 102.12 1.59
38 PCEIB GA 0 2020 102.12 0.00
39 PCEIB TX 0 2020 102.12 0.00
40 PCEIB US 87427 2020 102.12 8.93
41 SOEGB CA 263718 2020 0.00 0.00
42 SOEGB FL 57008 2020 0.00 0.00
43 SOEGB GA 33134 2020 0.00 0.00
44 SOEGB TX 74868 2020 0.00 0.00
45 SOEGB US 776511 2020 0.00 0.00
46 WYEGB CA 119069 2020 0.00 0.00
47 WYEGB FL 0 2020 0.00 0.00
48 WYEGB GA 0 2020 0.00 0.00
49 WYEGB TX 810501 2020 0.00 0.00
50 WYEGB US 2957843 2020 0.00 0.00

#Comparing CO2 Emissions for 2020 in GA, FL, CA, and TX.

calc_states <- seds7 %>% filter(!is.na(coef)) %>% 
            filter(statecode!= "US") %>% 
            group_by(statecode) %>% 
            summarise(CO2sum = sum(CO2em))


states_CO2 <- ggplot(data=calc_states, aes(x=statecode, y=CO2sum, fill=statecode))+
  geom_bar(stat = "identity")+
  scale_y_continuous(labels=comma, n.breaks = 5)+
  xlab("State")+ ylab("CO2 Emissions (Metric Tons) in 2020")
  
ggplotly(states_CO2)

#CO2 Emissions for 2020 in GA, FL, CA, TX, and the US as a whole:

calc_sum2 <- seds7 %>% filter(!is.na(coef)) %>% 
            group_by(statecode, year) %>% 
            summarise(CO2sum = sum(CO2em))
## `summarise()` has grouped output by 'statecode'. You can override using the
## `.groups` argument.
CO2_compared <- ggplot(data=calc_sum2, aes(x=statecode, y=CO2sum, fill=statecode))+
  geom_bar(stat = "identity")+
  scale_y_continuous(labels=comma, n.breaks = 5)+
  xlab("State")+ ylab("CO2 Emissions (Metric Tons)in 2020")
  
ggplotly(CO2_compared)

#CO2 Emissions Final Table, Comparing GA, FL, CA, TX, and the US as a whole, for the year 2020:

kable(calc_sum2, format = "html", row.names = TRUE, caption = "Table 5: CO2 Electricity Emissions- Comparison Year 2020 - Million Metric Tons of CO2)") %>%
  kable_styling(bootstrap_options = c("striped", "hover"),
                full_width = T,
                font_size = 16,
                position = "center")
Table 5: CO2 Electricity Emissions- Comparison Year 2020 - Million Metric Tons of CO2)
statecode year CO2sum
1 CA 2020 33.64891
2 FL 2020 92.23708
3 GA 2020 37.31486
4 TX 2020 176.88018
5 US 2020 1435.83569