In [1]:
%load_ext sql
In [2]:
%sql sqlite:///coal.db
Out[2]:
u'Connected: None@coal.db'
In [3]:
%sql select * from data limit 0
Done.
Out[3]:
state
name
orispl_code
unitid
op_date
op_hour
op_time
gload
SO2_MASS
NOX_MASS
CO2_MASS
heat_input
county
latitude
longitude
fuel_type
year
In [10]:
%%sql
select d.name, d.unitid, d.year, maybe_NG, maybe_coal, CAST(maybe_NG as float) / count(*) as percent_NG, CAST(maybe_coal as float) / count(*) as percent_coal
from data as d,
(select name, unitid, year, count(*) as maybe_NG from data where CO2_MASS / heat_input > 0.05 and CO2_MASS / heat_input < 0.07
group by name, unitid, year) as n,
(select name, unitid, year, count(*) as maybe_coal from data where CO2_MASS / heat_input > 0.09 and CO2_MASS / heat_input < 0.11
group by name, unitid, year) as c
WHERE d.name = n.name and d.unitid = n.unitid and d.year = n.year and
d.name = c.name and d.unitid = c.unitid and d.year = c.year
and d.CO2_MASS > 0
group by d.name, d.unitid, d.year
Done.
Out[10]:
name
unitid
year
maybe_NG
maybe_coal
percent_NG
percent_coal
Apache Station
2
2001
198
7610
0.022602739726
0.868721461187
Apache Station
2
2002
123
8409
0.0140410958904
0.959931506849
Apache Station
2
2003
23
8041
0.00262557077626
0.917922374429
Apache Station
2
2004
26
8626
0.00295992714026
0.982012750455
Apache Station
2
2005
66
7647
0.00753424657534
0.872945205479
Apache Station
2
2006
8
8730
0.000913242009132
0.996575342466
Apache Station
2
2007
29
8646
0.00331050228311
0.98698630137
Apache Station
2
2008
55
7558
0.0062663780335
0.861114275949
Apache Station
2
2009
70
7815
0.00799543118218
0.892632781268
Apache Station
2
2010
47
7677
0.00536529680365
0.876369863014
Apache Station
2
2011
50
8530
0.00570776255708
0.973744292237
Apache Station
2
2012
177
7135
0.020150273224
0.812272313297
Apache Station
2
2013
141
8460
0.016095890411
0.965753424658
Apache Station
2
2014
85
8532
0.00970319634703
0.97397260274
Apache Station
2
2015
73
7716
0.00833333333333
0.880821917808
Apache Station
2
2016
40
8491
0.00455373406193
0.966643897996
Apache Station
3
2001
24
8621
0.0027397260274
0.984132420091
Apache Station
3
2002
70
7746
0.00799086757991
0.884246575342
Apache Station
3
2003
18
8602
0.00205479452055
0.98196347032
Apache Station
3
2004
42
7541
0.00478142076503
0.858492714026
Apache Station
3
2005
30
8665
0.00342465753425
0.989155251142
Apache Station
3
2006
126
7497
0.0143835616438
0.855821917808
Apache Station
3
2007
12
8690
0.0013698630137
0.99200913242
Apache Station
3
2008
16
8684
0.00182149362477
0.988615664845
Apache Station
3
2009
123
7025
0.0140410958904
0.801940639269
Apache Station
3
2010
24
8505
0.0027397260274
0.970890410959
Apache Station
3
2011
95
7254
0.0108447488584
0.828082191781
Apache Station
3
2012
3572
5144
0.40664845173
0.585610200364
Apache Station
3
2013
37
8428
0.00422374429224
0.962100456621
Apache Station
3
2014
50
7799
0.00570776255708
0.890296803653
Apache Station
3
2015
30
8190
0.00342465753425
0.934931506849
Apache Station
3
2016
73
8172
0.00831056466302
0.930327868852
Arapahoe
1
2001
56
8499
0.00640146319159
0.971536351166
Arapahoe
1
2002
17
7805
0.00194330132602
0.892203932327
Arapahoe
2
2001
105
6188
0.0119863013699
0.706392694064
Arapahoe
2
2002
12
6032
0.0013698630137
0.688584474886
Arapahoe
3
2002
2
8270
0.000228310502283
0.944063926941
Arapahoe
3
2007
75
8030
0.00856164383562
0.916666666667
Arapahoe
4
2001
24
7311
0.0027397260274
0.834589041096
Arapahoe
4
2002
8
8247
0.000913242009132
0.941438356164
Arapahoe
4
2007
315
7469
0.0359589041096
0.852625570776
Cameo
2
2001
5
8652
0.000570776255708
0.987671232877
Cameo
2
2002
28
8612
0.00319634703196
0.983105022831
Carbon
1
2009
1
7324
0.000114364135407
0.837602927722
Cherokee
1
2001
246
7129
0.0280821917808
0.813812785388
Cherokee
1
2002
122
8010
0.0139269406393
0.914383561644
Cherokee
1
2003
129
8474
0.0147260273973
0.967351598174
Cherokee
1
2004
112
7243
0.0127504553734
0.824567395264
Cherokee
1
2005
119
7592
0.0135844748858
0.866666666667
Cherokee
1
2006
88
7490
0.0100456621005
0.85502283105
Cherokee
1
2007
111
6609
0.0126712328767
0.754452054795
Cherokee
1
2008
59
7413
0.00671675774135
0.843920765027
Cherokee
1
2009
76
4894
0.00867579908676
0.558675799087
Cherokee
1
2010
166
5886
0.0189735969825
0.67276260144
Cherokee
1
2011
188
7996
0.0214734437464
0.913306681896
Cherokee
1
2012
104
2511
0.0239190432383
0.577506899724
Cherokee
2
2001
199
7675
0.0227168949772
0.876141552511
Cherokee
2
2002
262
5558
0.0299086757991
0.634474885845
Cherokee
2
2003
212
8224
0.024200913242
0.938812785388
Cherokee
2
2004
166
6855
0.018897996357
0.780396174863
Cherokee
2
2005
98
8331
0.0111872146119
0.95102739726
Cherokee
2
2006
56
8048
0.00639269406393
0.918721461187
Cherokee
2
2007
507
6748
0.0578767123288
0.770319634703
Cherokee
2
2008
132
6810
0.0150273224044
0.775273224044
Cherokee
2
2009
69
4998
0.00788571428571
0.5712
Cherokee
2
2010
96
7432
0.0109726825923
0.849468510687
Cherokee
2
2011
222
5897
0.025406271458
0.674868390936
Cherokee
3
2001
245
7803
0.0279680365297
0.890753424658
Cherokee
3
2002
273
6954
0.0311643835616
0.793835616438
Cherokee
3
2003
355
7927
0.0405251141553
0.904908675799
Cherokee
3
2004
147
7741
0.0167349726776
0.881261384335
Cherokee
3
2005
120
7193
0.013698630137
0.821118721461
Cherokee
3
2006
109
8057
0.0124429223744
0.919748858447
Cherokee
3
2007
588
7579
0.0671232876712
0.865182648402
Cherokee
3
2008
49
7578
0.00557832422587
0.862704918033
Cherokee
3
2009
103
7419
0.0117620189563
0.847207947927
Cherokee
3
2010
101
6336
0.0115309966891
0.723370247745
Cherokee
3
2011
144
6773
0.0164477441462
0.773615077099
Cherokee
3
2012
577
6658
0.0666127915031
0.768644654814
Cherokee
3
2013
75
8095
0.00858713075338
0.926837645981
Cherokee
3
2014
41
8322
0.0046803652968
0.95
Cherokee
3
2015
156
4169
0.0178082191781
0.475913242009
Cherokee
4
2001
223
7959
0.0254566210046
0.908561643836
Cherokee
4
2002
183
7310
0.0208904109589
0.834474885845
Cherokee
4
2003
218
6596
0.0248858447489
0.75296803653
Cherokee
4
2004
159
8156
0.0181010928962
0.928506375228
Cherokee
4
2005
148
7874
0.0168949771689
0.898858447489
Cherokee
4
2006
120
7547
0.013698630137
0.861529680365
Cherokee
4
2007
114
7814
0.0130136986301
0.89200913242
Cherokee
4
2008
88
8021
0.0100182149362
0.913137522769
Cherokee
4
2009
143
5874
0.016337255798
0.671084199703
Cherokee
4
2010
264
6092
0.0301576422207
0.695910440941
Cherokee
4
2011
123
7097
0.0140410958904
0.810159817352
Cherokee
4
2012
115
7914
0.0130964582622
0.901264092928
Cherokee
4
2013
163
7036
0.0186094303003
0.803288046581
Cherokee
4
2014
89
7264
0.0101621374743
0.829413108016
Cherokee
4
2015
161
7367
0.0183789954338
0.84098173516
Cherokee
4
2016
231
8289
0.0262978142077
0.943647540984
Colstrip
1
2002
21
8339
0.00239726027397
0.951940639269
Colstrip
1
2012
31
5646
0.00352954571331
0.642832745076
Colstrip
1
2013
30
8372
0.00342465753425
0.955707762557
Colstrip
1
2014
23
8261
0.00262557077626
0.94303652968
Colstrip
1
2015
76
7945
0.00868372943327
0.90779250457
Colstrip
1
2016
65
6696
0.00740150307447
0.762468685949
Colstrip
2
2004
1
8344
0.000113843351548
0.949908925319
Colstrip
2
2012
37
5547
0.00421220400729
0.631489071038
Colstrip
2
2013
17
8440
0.00194130409958
0.963800388261
Colstrip
2
2014
19
8420
0.00216919739696
0.961296951707
Colstrip
2
2015
69
6867
0.0078776115995
0.783993606576
Colstrip
2
2016
35
7990
0.00398678664996
0.910126438091
Comanche (470)
1
2001
137
7396
0.0156392694064
0.844292237443
Comanche (470)
1
2002
72
7586
0.00821917808219
0.86598173516
Comanche (470)
1
2003
94
7626
0.0107305936073
0.870547945205
Comanche (470)
1
2004
139
5959
0.0158242258652
0.678392531876
Comanche (470)
1
2005
84
7930
0.00958904109589
0.905251141553
Comanche (470)
1
2006
60
8185
0.00685400959561
0.935001142335
Comanche (470)
1
2007
73
8041
0.008339045008
0.918551519305
Comanche (470)
1
2008
118
6438
0.0134335154827
0.732923497268
Comanche (470)
1
2009
80
8092
0.00913346272406
0.923849754538
Comanche (470)
1
2010
155
7564
0.0176981045901
0.863667503996
Comanche (470)
1
2011
120
6510
0.0137033230558
0.743405275779
Comanche (470)
1
2012
70
7846
0.00797357329992
0.893723658731
Comanche (470)
1
2013
137
8081
0.0156517765338
0.923226322404
Comanche (470)
1
2014
99
6799
0.0113104078602
0.776762252942
Comanche (470)
1
2015
50
8084
0.00570841420253
0.922936408266
Comanche (470)
1
2016
89
8030
0.0101332118866
0.914266196061
Comanche (470)
2
2001
64
7689
0.00730593607306
0.877739726027
Comanche (470)
2
2002
35
8509
0.00399543378995
0.971347031963
Comanche (470)
2
2003
33
8545
0.00376712328767
0.975456621005
Comanche (470)
2
2004
73
8307
0.00831056466302
0.945696721311
Comanche (470)
2
2005
136
6957
0.0155251141553
0.794178082192
Comanche (470)
2
2006
44
8517
0.00502283105023
0.972260273973
Comanche (470)
2
2007
133
6825
0.0151826484018
0.779109589041
Comanche (470)
2
2008
68
8250
0.00774134790528
0.939207650273
Comanche (470)
2
2009
143
7700
0.0163242009132
0.87899543379
Comanche (470)
2
2010
184
6097
0.0210093628682
0.69616350765
Comanche (470)
2
2011
166
6638
0.0189562635606
0.758022153706
Comanche (470)
2
2012
29
8288
0.0033014571949
0.943533697632
Comanche (470)
2
2013
230
6932
0.0262587053317
0.791414545039
Comanche (470)
2
2014
45
8454
0.00513698630137
0.965068493151
Comanche (470)
2
2015
78
8050
0.00890512615595
0.919054686608
Comanche (470)
2
2016
101
6839
0.0115021068215
0.778840678738
Comanche (470)
3
2010
501
5050
0.0571917808219
0.576484018265
Comanche (470)
3
2011
203
5390
0.0231735159817
0.615296803653
Comanche (470)
3
2012
157
7073
0.0178734061931
0.805214025501
Comanche (470)
3
2013
114
7255
0.0130196436729
0.82857469164
Comanche (470)
3
2014
226
6210
0.025799086758
0.708904109589
Comanche (470)
3
2015
82
6668
0.00936073059361
0.761187214612
Comanche (470)
3
2016
169
7846
0.0192395264117
0.893214936248
Craig
C1
2001
44
8510
0.00502340449823
0.971572097271
Craig
C2
2001
63
7361
0.00719178082192
0.840296803653
Craig
C3
2001
24
8473
0.0027397260274
0.967237442922
Four Corners Steam Elec Station
1
2005
4
7640
0.000456621004566
0.872146118721
Four Corners Steam Elec Station
2
2005
4
8489
0.000456621004566
0.969063926941
Four Corners Steam Elec Station
3
2004
1
8386
0.000113843351548
0.954690346084
Four Corners Steam Elec Station
3
2005
9
8217
0.00102739726027
0.93801369863
Four Corners Steam Elec Station
4
2004
3
6247
0.000341530054645
0.711179417122
Four Corners Steam Elec Station
4
2005
51
7916
0.00582191780822
0.903652968037
Four Corners Steam Elec Station
5
2002
1
5637
0.000114155251142
0.643493150685
Four Corners Steam Elec Station
5
2005
38
7390
0.00433789954338
0.843607305936
Hardin
U1
2006
43
4421
0.00651515151515
0.669848484848
Hardin
U1
2007
75
7419
0.00856164383562
0.846917808219
Hardin
U1
2008
84
6476
0.00956284153005
0.737249544627
Hardin Generating Station
U1
2009
87
7822
0.00993264071241
0.893024317845
Hardin Generating Station
U1
2010
76
7828
0.00867778031514
0.893811372459
Hardin Generating Station
U1
2011
75
6702
0.0085645769099
0.765330592669
Hardin Generating Station
U1
2012
45
4815
0.00512295081967
0.548155737705
Hardin Generating Station
U1
2013
131
6196
0.0149577529116
0.707467458324
Hardin Generating Station
U1
2014
105
7085
0.0119890385933
0.808974651747
Hardin Generating Station
U1
2015
112
5328
0.0127868478137
0.608288617422
Hardin Generating Station
U1
2016
57
3482
0.00648907103825
0.396402550091
Hayden
H1
2003
5
7142
0.000570776255708
0.815296803653
Hayden
H1
2012
8
6110
0.00091095422455
0.695741289
Hayden
H2
2002
22
8475
0.00251141552511
0.967465753425
Irvington Generating Station
4
2001
86
8180
0.00981735159817
0.933789954338
Irvington Generating Station
4
2002
40
8560
0.00456621004566
0.977168949772
Irvington Generating Station
4
2003
176
7345
0.0200936179929
0.838566046352
Irvington Generating Station
4
2004
98
8269
0.0111566484517
0.941370673953
Irvington Generating Station
4
2005
54
8310
0.00616649537513
0.948955121617
Irvington Generating Station
4
2006
234
7231
0.0267123287671
0.825456621005
Irvington Generating Station
4
2007
68
8399
0.00776255707763
0.958789954338
Irvington Generating Station
4
2008
64
8471
0.00728597449909
0.964367030965
Irvington Generating Station
4
2009
5067
2276
0.578424657534
0.259817351598
Irvington Generating Station
4
2010
3070
5665
0.350456621005
0.646689497717
Irvington Generating Station
4
2011
186
7986
0.0212328767123
0.911643835616
Irvington Generating Station
4
2012
7072
1426
0.805100182149
0.162340619308
Irvington Generating Station
4
2013
1058
4783
0.120776255708
0.54600456621
Irvington Generating Station
4
2014
3807
3336
0.434589041096
0.380821917808
Irvington Generating Station
4
2015
3660
4384
0.417808219178
0.500456621005
Jim Bridger
BW73
2003
3
7124
0.000342465753425
0.813242009132
Lewis & Clark
B1
2001
70
8166
0.00799086757991
0.932191780822
Lewis & Clark
B1
2002
74
7548
0.00844748858447
0.861643835616
Lewis & Clark
B1
2003
71
8222
0.00810502283105
0.938584474886
Lewis & Clark
B1
2004
71
8202
0.00808287795993
0.933743169399
Lewis & Clark
B1
2005
151
6700
0.0172374429224
0.764840182648
Lewis & Clark
B1
2006
52
8113
0.00594829558453
0.928048501487
Lewis & Clark
B1
2007
86
7654
0.00981735159817
0.873744292237
Lewis & Clark
B1
2008
59
8145
0.00671675774135
0.927254098361
Lewis & Clark
B1
2009
48
8249
0.00547945205479
0.941666666667
Lewis & Clark
B1
2010
67
8121
0.00764840182648
0.927054794521
Lewis & Clark
B1
2011
69
7872
0.00787671232877
0.898630136986
Lewis & Clark
B1
2012
95
7070
0.0108175814165
0.805055795946
Lewis & Clark
B1
2013
59
8053
0.00673592875899
0.91939719146
Lewis & Clark
B1
2014
65
7600
0.00742178579584
0.867778031514
Lewis & Clark
B1
2015
116
6012
0.0132662397072
0.687557182068
Lewis & Clark
B1
2016
88
7488
0.0100193555733
0.852556074234
Martin Drake
5
2001
79
8357
0.00901826484018
0.95399543379
Martin Drake
5
2002
109
8485
0.0124429223744
0.968607305936
Martin Drake
5
2003
85
7458
0.00970319634703
0.851369863014
Martin Drake
5
2004
105
8128
0.0119535519126
0.925318761384
Martin Drake
5
2005
133
7427
0.0151826484018
0.847831050228
Martin Drake
5
2006
64
8393
0.00730593607306
0.958105022831
Martin Drake
5
2007
196
6910
0.0223744292237
0.788812785388
Martin Drake
5
2008
40
8508
0.00455373406193
0.968579234973
Martin Drake
5
2009
93
7192
0.0106164383562
0.82100456621
Martin Drake
5
2010
43
8413
0.00490867579909
0.960388127854
Martin Drake
5
2011
64
7890
0.00730593607306
0.900684931507
Martin Drake
5
2012
56
8608
0.0063752276867
0.979963570128
Martin Drake
5
2013
123
8270
0.0140410958904
0.944063926941
Martin Drake
5
2014
21
2635
0.00239726027397
0.300799086758
Martin Drake
5
2015
152
5416
0.0173515981735
0.618264840183
Martin Drake
5
2016
51
109
0.00580601092896
0.0124089253188
Martin Drake
6
2001
790
6606
0.0901826484018
0.754109589041
Martin Drake
6
2002
149
8255
0.0170091324201
0.942351598174
Martin Drake
6
2003
96
8192
0.0109589041096
0.935159817352
Martin Drake
6
2004
69
7562
0.00785519125683
0.860883424408
Martin Drake
6
2005
95
8286
0.0108447488584
0.945890410959
Martin Drake
6
2006
52
7650
0.00593607305936
0.873287671233
Martin Drake
6
2007
73
8247
0.00833333333333
0.941438356164
Martin Drake
6
2008
324
7252
0.0368852459016
0.825591985428
Martin Drake
6
2009
41
8439
0.0046803652968
0.963356164384
Martin Drake
6
2010
191
7475
0.0218061422537
0.853407923279
Martin Drake
6
2011
90
7146
0.0102739726027
0.815753424658
Martin Drake
6
2012
94
8199
0.0107012750455
0.933401639344
Martin Drake
6
2013
134
8169
0.015296803653
0.932534246575
Martin Drake
6
2014
204
6257
0.0232876712329
0.714269406393
Martin Drake
6
2015
40
8100
0.00456621004566
0.924657534247
Martin Drake
6
2016
113
7146
0.012864298725
0.813524590164
Martin Drake
7
2001
101
8187
0.0115296803653
0.934589041096
Martin Drake
7
2002
158
7066
0.0180365296804
0.806621004566
Martin Drake
7
2003
84
8529
0.00958904109589
0.973630136986
Martin Drake
7
2004
126
7062
0.0143442622951
0.803961748634
Martin Drake
7
2005
21
8732
0.00239726027397
0.996803652968
Martin Drake
7
2006
126
7250
0.0143835616438
0.827625570776
Martin Drake
7
2007
92
8115
0.0105034821327
0.926475625071
Martin Drake
7
2008
274
6868
0.0311930783242
0.781876138434
Martin Drake
7
2009
89
8179
0.0101598173516
0.933675799087
Martin Drake
7
2010
189
7418
0.0215753424658
0.846803652968
Martin Drake
7
2011
186
8032
0.0212353008334
0.916999657495
Martin Drake
7
2012
125
7072
0.0142336597586
0.805283534502
Martin Drake
7
2013
223
6363
0.0254566210046
0.726369863014
Martin Drake
7
2014
169
5800
0.0192922374429
0.662100456621
Martin Drake
7
2015
194
7037
0.0221461187215
0.803310502283
Martin Drake
7
2016
90
8027
0.0102459016393
0.913820582878
Mohave
1
2001
83
7704
0.00947488584475
0.879452054795
Mohave
1
2002
51
7472
0.00582191780822
0.85296803653
Mohave
1
2003
81
8200
0.00924657534247
0.936073059361
Mohave
1
2004
41
7598
0.00466757741348
0.864981785064
Mohave
1
2005
50
8286
0.00570776255708
0.945890410959
Mohave
2
2001
42
7537
0.00479725870931
0.86087949743
Mohave
2
2002
27
8082
0.00308219178082
0.922602739726
Mohave
2
2003
76
7012
0.00867579908676
0.800456621005
Mohave
2
2004
34
7515
0.00387067395264
0.855532786885
Mohave
2
2005
50
7697
0.00570776255708
0.878652968037
Naughton
1
2001
40
8450
0.00456621004566
0.964611872146
Naughton
1
2002
22
7724
0.00251141552511
0.881735159817
Naughton
1
2003
88
8455
0.0100456621005
0.965182648402
Naughton
1
2004
55
8143
0.00626138433515
0.927026411658
Naughton
1
2005
3
8362
0.000342465753425
0.954566210046
Naughton
1
2006
1
8438
0.000114155251142
0.963242009132
Naughton
1
2010
21
8677
0.00239780771866
0.990751313085
Naughton
1
2011
59
8471
0.00673515981735
0.96700913242
Naughton
1
2012
129
6318
0.0146924829157
0.719589977221
Naughton
1
2013
64
8392
0.00730927364093
0.958428506167
Naughton
1
2014
71
8303
0.00810502283105
0.947831050228
Naughton
1
2015
73
8461
0.00833333333333
0.965867579909
Naughton
1
2016
38
8558
0.00432604735883
0.97427140255
Naughton
2
2001
50
8346
0.00570776255708
0.952739726027
Naughton
2
2002
69
7409
0.00787671232877
0.845776255708
Naughton
2
2003
62
7686
0.00707762557078
0.877397260274
Naughton
2
2004
7
8362
0.000796903460838
0.951958105647
Naughton
2
2005
10
8492
0.00114155251142
0.969406392694
Naughton
2
2006
13
7177
0.00148401826484
0.819292237443
Naughton
2
2007
1
8635
0.000114155251142
0.985730593607
Naughton
2
2010
27
8541
0.00308254366937
0.975111314077
Naughton
2
2011
58
7094
0.00662176047494
0.809909807056
Naughton
2
2012
102
8039
0.0116133439599
0.915290902881
Naughton
2
2013
107
8208
0.0122146118721
0.93698630137
Naughton
2
2014
54
8356
0.00616508733874
0.953990181528
Naughton
2
2015
44
8530
0.00502283105023
0.973744292237
Naughton
2
2016
75
7405
0.00853825136612
0.843010018215
Naughton
3
2001
122
8175
0.0139285306542
0.933325722114
Naughton
3
2002
537
7663
0.061301369863
0.874771689498
Naughton
3
2003
266
6791
0.0303652968037
0.775228310502
Naughton
3
2004
86
8258
0.00979052823315
0.940118397086
Naughton
3
2005
146
7829
0.0166666666667
0.893721461187
Naughton
3
2006
53
8403
0.0060502283105
0.959246575342
Naughton
3
2007
116
7971
0.0132420091324
0.909931506849
Naughton
3
2008
114
7871
0.0129781420765
0.896061020036
Naughton
3
2009
5
6879
0.000570971793993
0.785542994176
Naughton
3
2010
81
8248
0.00924657534247
0.941552511416
Naughton
3
2011
74
8159
0.00844748858447
0.931392694064
Naughton
3
2012
115
8212
0.0130919854281
0.934881602914
Naughton
3
2013
76
8371
0.00867579908676
0.955593607306
Naughton
3
2014
96
7918
0.0109589041096
0.903881278539
Naughton
3
2015
133
7386
0.0151826484018
0.843150684932
Naughton
3
2016
52
8368
0.00591985428051
0.952641165756
Nucla
1
2001
101
7648
0.0115296803653
0.873059360731
Nucla
1
2002
106
8156
0.012100456621
0.931050228311
Nucla
1
2003
199
7198
0.0227272727273
0.822064869804
Nucla
1
2004
48
8232
0.00546510303996
0.937265171354
Nucla
1
2005
93
8046
0.0106164383562
0.918493150685
Nucla
1
2006
80
8107
0.00913242009132
0.925456621005
Nucla
1
2007
134
7607
0.015302044079
0.868676487382
Nucla
1
2008
95
7792
0.0108163497666
0.887168393487
Nucla
1
2009
64
7812
0.00731595793324
0.893004115226
Nucla
1
2010
183
5906
0.0209095063985
0.674817184644
Nucla
1
2011
151
7557
0.0172472872644
0.863163906339
Nucla
1
2012
112
7331
0.0127620783956
0.835346399271
Nucla
1
2013
86
4898
0.00982071485669
0.559323969396
Nucla
1
2014
91
5518
0.0103928734582
0.630196436729
Nucla
1
2015
107
5463
0.0122146118721
0.623630136986
Nucla
1
2016
56
2992
0.00637740576244
0.340735679308
Pawnee
1
2001
27
8587
0.00308219178082
0.980251141553
Pawnee
1
2002
102
7444
0.0116438356164
0.849771689498
Pawnee
1
2003
35
8508
0.00399543378995
0.971232876712
Pawnee
1
2004
122
7683
0.0138888888889
0.874658469945
Pawnee
1
2005
128
7049
0.0146118721461
0.804680365297
Pawnee
1
2006
68
8380
0.00776255707763
0.956621004566
Pawnee
1
2007
30
8565
0.00342465753425
0.977739726027
Pawnee
1
2008
87
8140
0.0099043715847
0.926684881603
Pawnee
1
2009
196
4971
0.0223795387075
0.567595341402
Pawnee
1
2010
127
7820
0.0144993720744
0.892795981276
Pawnee
1
2011
115
6777
0.0131278538813
0.773630136986
Pawnee
1
2012
97
7734
0.0110428051002
0.880464480874
Pawnee
1
2013
115
7173
0.0131308517926
0.819022607901
Pawnee
1
2014
169
6301
0.0193032552827
0.719703026842
Pawnee
1
2015
94
8051
0.0107342697271
0.919378782688
Pawnee
1
2016
86
6536
0.00979275791391
0.744249601458
Ray D Nixon
1
2001
1
7643
0.000114155251142
0.872488584475
Ray D Nixon
1
2005
7
7509
0.000799086757991
0.857191780822
Reid Gardner
1
2001
32
7077
0.00365547178433
0.808430431803
Reid Gardner
1
2002
6
7596
0.000685009704304
0.867222285649
Reid Gardner
1
2003
9
8235
0.00102739726027
0.940068493151
Reid Gardner
1
2004
18
7522
0.00204941363999
0.856427188888
Reid Gardner
1
2005
6
7821
0.000685009704304
0.89291014956
Reid Gardner
1
2006
9
7729
0.00102739726027
0.882305936073
Reid Gardner
1
2007
18
6398
0.00205831903945
0.731618067467
Reid Gardner
1
2008
19
6417
0.0021637626694
0.730782371028
Reid Gardner
1
2009
17
6126
0.00194063926941
0.699315068493
Reid Gardner
1
2010
24
6345
0.00274003881722
0.724397762302
Reid Gardner
1
2011
32
6281
0.00365296803653
0.71700913242
Reid Gardner
2
2001
40
7223
0.00457090618215
0.825391383842
Reid Gardner
2
2002
5
7954
0.000571037003198
0.908405664687
Reid Gardner
2
2003
5
7561
0.000570776255708
0.863127853881
Reid Gardner
2
2004
7
7985
0.000796994193328
0.909142661961
Reid Gardner
2
2005
18
6821
0.00205526375885
0.778830783284
Reid Gardner
2
2006
17
7418
0.00194063926941
0.846803652968
Reid Gardner
2
2007
10
8045
0.00114168284051
0.918483845188
Reid Gardner
2
2008
19
7596
0.00216302367942
0.864754098361
Reid Gardner
2
2009
48
5255
0.00547945205479
0.599885844749
Reid Gardner
2
2010
115
6567
0.0131278538813
0.749657534247
Reid Gardner
2
2011
67
5941
0.00764840182648
0.678196347032
Reid Gardner
3
2001
5
7996
0.000571363272769
0.913724145812
Reid Gardner
3
2002
14
7906
0.00159872102318
0.902820600662
Reid Gardner
3
2003
2
6893
0.000228937728938
0.789033882784
Reid Gardner
3
2004
7
7958
0.000796903460838
0.905965391621
Reid Gardner
3
2006
12
6662
0.0013698630137
0.760502283105
Reid Gardner
3
2007
12
6637
0.0013698630137
0.757648401826
Reid Gardner
3
2008
26
6835
0.00296161293997
0.778562478642
Reid Gardner
3
2009
19
6657
0.00216894977169
0.759931506849
Reid Gardner
3
2010
80
7080
0.00913242009132
0.808219178082
Reid Gardner
3
2011
8
5850
0.000913242009132
0.667808219178
Reid Gardner
4
2001
62
7612
0.00708328573061
0.869644693248
Reid Gardner
4
2002
3
8005
0.000342465753425
0.913812785388
Reid Gardner
4
2003
5
7014
0.000570776255708
0.800684931507
Reid Gardner
4
2004
10
7421
0.00113856313333
0.844927701241
Reid Gardner
4
2005
33
7780
0.00376712328767
0.888127853881
Reid Gardner
4
2006
14
7560
0.00159817351598
0.86301369863
San Juan
1
2005
29
8197
0.00331050228311
0.935730593607
San Juan
1
2011
2
6735
0.000228493088084
0.769450474123
San Juan
1
2012
1
7301
0.000113895216401
0.831548974943
San Juan
1
2013
1
7488
0.000114194358799
0.855087358684
San Juan
1
2014
2
6344
0.000228336568101
0.724283594018
San Juan
1
2015
2
5931
0.000228362639872
0.677209408541
San Juan
1
2016
1
7631
0.000113856313333
0.868837527041
San Juan
2
2011
3
7576
0.000342661336379
0.865334094803
San Juan
2
2012
1
6756
0.000113895216401
0.769476082005
San Juan
2
2013
1
7549
0.000114181319936
0.861954784197
San Juan
2
2015
3
7210
0.000342622201919
0.823435358611
San Juan
2
2016
2
6975
0.000227790432802
0.794419134396
San Juan
3
2011
2
8022
0.000228362639872
0.915962548527
San Juan
3
2012
1
7157
0.000114025085519
0.816077537058
San Juan
3
2013
1
7302
0.00011423349326
0.834132967786
San Juan
3
2014
1
7757
0.000114155251142
0.885502283105
San Juan
3
2015
2
7532
0.000228440890919
0.860308395203
San Juan
3
2016
11
7228
0.00125227686703
0.822859744991
San Juan
4
2001
30
7769
0.00342504852152
0.88697339879
San Juan
4
2011
1
8215
0.000114181319936
0.937999543275
San Juan
4
2012
1
8244
0.000113843351548
0.938524590164
San Juan
4
2014
1
7823
0.000114194358799
0.893342468882
San Juan
4
2015
2
6927
0.000228310502283
0.790753424658
San Juan
4
2016
2
7785
0.000227686703097
0.886270491803
Valmont
5
2002
76
7313
0.00867579908676
0.834817351598
Valmont
5
2004
1
7800
0.000113843351548
0.887978142077
Valmont
5
2011
19
6813
0.00217018846374
0.778183894917
Wyodak
BW91
2003
1
8563
0.000114155251142
0.977511415525
In [8]:
%%sql
select name, unitid, year, count(*) as maybe_coal from data where CO2_MASS / heat_input > 0.09 and CO2_MASS / heat_input < 0.11
group by name, unitid, year
Done.
Out[8]:
name
unitid
year
maybe_coal
Apache Station
2
2001
7610
Apache Station
2
2002
8409
Apache Station
2
2003
8041
Apache Station
2
2004
8626
Apache Station
2
2005
7647
Apache Station
2
2006
8730
Apache Station
2
2007
8646
Apache Station
2
2008
7558
Apache Station
2
2009
7815
Apache Station
2
2010
7677
Apache Station
2
2011
8530
Apache Station
2
2012
7135
Apache Station
2
2013
8460
Apache Station
2
2014
8532
Apache Station
2
2015
7716
Apache Station
2
2016
8491
Apache Station
3
2001
8621
Apache Station
3
2002
7746
Apache Station
3
2003
8602
Apache Station
3
2004
7541
Apache Station
3
2005
8665
Apache Station
3
2006
7497
Apache Station
3
2007
8690
Apache Station
3
2008
8684
Apache Station
3
2009
7025
Apache Station
3
2010
8505
Apache Station
3
2011
7254
Apache Station
3
2012
5144
Apache Station
3
2013
8428
Apache Station
3
2014
7799
Apache Station
3
2015
8190
Apache Station
3
2016
8172
Arapahoe
1
2001
8499
Arapahoe
1
2002
7805
Arapahoe
2
2001
6188
Arapahoe
2
2002
6032
Arapahoe
3
2001
7807
Arapahoe
3
2002
8270
Arapahoe
3
2003
7997
Arapahoe
3
2004
5947
Arapahoe
3
2005
7825
Arapahoe
3
2006
8204
Arapahoe
3
2007
8030
Arapahoe
3
2008
7546
Arapahoe
3
2009
6149
Arapahoe
3
2010
6325
Arapahoe
3
2011
6817
Arapahoe
3
2012
7554
Arapahoe
3
2013
7515
Arapahoe
4
2001
7311
Arapahoe
4
2002
8247
Arapahoe
4
2003
7473
Arapahoe
4
2004
8296
Arapahoe
4
2005
7132
Arapahoe
4
2006
7304
Arapahoe
4
2007
7469
Arapahoe
4
2008
6874
Arapahoe
4
2009
6946
Arapahoe
4
2010
5270
Arapahoe
4
2011
4780
Arapahoe
4
2012
7487
Arapahoe
4
2013
7302
Boardman
1SG
2001
8184
Boardman
1SG
2002
7111
Boardman
1SG
2003
7925
Boardman
1SG
2004
6570
Boardman
1SG
2005
6362
Boardman
1SG
2006
4542
Boardman
1SG
2007
7775
Boardman
1SG
2008
7279
Boardman
1SG
2009
5814
Boardman
1SG
2010
7610
Boardman
1SG
2011
7020
Boardman
1SG
2012
5670
Boardman
1SG
2013
7294
Boardman
1SG
2014
6651
Boardman
1SG
2015
5073
Boardman
1SG
2016
3987
Bonanza
1-1
2001
8703
Bonanza
1-1
2002
8649
Bonanza
1-1
2003
8089
Bonanza
1-1
2004
8402
Bonanza
1-1
2005
8321
Bonanza
1-1
2006
8674
Bonanza
1-1
2007
7749
Bonanza
1-1
2008
8600
Bonanza
1-1
2009
8205
Bonanza
1-1
2010
8702
Bonanza
1-1
2011
8559
Bonanza
1-1
2012
7961
Bonanza
1-1
2013
8572
Bonanza
1-1
2014
8514
Bonanza
1-1
2015
8432
Bonanza
1-1
2016
7622
Cameo
2
2001
8652
Cameo
2
2002
8612
Cameo
2
2003
8009
Cameo
2
2004
8122
Cameo
2
2005
8518
Cameo
2
2006
7053
Cameo
2
2007
7558
Cameo
2
2008
8133
Cameo
2
2009
8519
Cameo
2
2010
8320
Carbon
1
2001
8481
Carbon
1
2002
8460
Carbon
1
2003
8406
Carbon
1
2004
6869
Carbon
1
2005
8133
Carbon
1
2006
8336
Carbon
1
2007
8485
Carbon
1
2008
8276
Carbon
1
2009
7324
Carbon
1
2010
8439
Carbon
1
2011
8547
Carbon
1
2012
8647
Carbon
1
2013
8191
Carbon
1
2014
8606
Carbon
1
2015
2515
Carbon
2
2001
8415
Carbon
2
2002
8371
Carbon
2
2003
8553
Carbon
2
2004
7663
Carbon
2
2005
8397
Carbon
2
2006
8358
Carbon
2
2007
8270
Carbon
2
2008
7319
Carbon
2
2009
8681
Carbon
2
2010
8342
Carbon
2
2011
8646
Carbon
2
2012
8427
Carbon
2
2013
8046
Carbon
2
2014
8463
Carbon
2
2015
2487
Centralia
BW21
2001
8176
Centralia
BW21
2002
6810
Centralia
BW21
2003
8551
Centralia
BW21
2004
8343
Centralia
BW21
2005
7650
Centralia
BW21
2006
6256
Centralia
BW21
2007
7904
Centralia
BW21
2008
7416
Centralia
BW21
2009
5931
Centralia
BW21
2010
7459
Centralia
BW21
2011
4381
Centralia
BW21
2012
3907
Centralia
BW21
2013
6109
Centralia
BW21
2014
6773
Centralia
BW21
2015
5532
Centralia
BW21
2016
4620
Centralia
BW22
2001
6320
Centralia
BW22
2002
8383
Centralia
BW22
2003
8164
Centralia
BW22
2004
7579
Centralia
BW22
2005
8295
Centralia
BW22
2006
5509
Centralia
BW22
2007
7759
Centralia
BW22
2008
6295
Centralia
BW22
2009
6513
Centralia
BW22
2010
6711
Centralia
BW22
2011
4550
Centralia
BW22
2012
3635
Centralia
BW22
2013
6078
Centralia
BW22
2014
6042
Centralia
BW22
2015
5433
Centralia
BW22
2016
4964
Cherokee
1
2001
7129
Cherokee
1
2002
8010
Cherokee
1
2003
8474
Cherokee
1
2004
7243
Cherokee
1
2005
7592
Cherokee
1
2006
7490
Cherokee
1
2007
6609
Cherokee
1
2008
7413
Cherokee
1
2009
4894
Cherokee
1
2010
5886
Cherokee
1
2011
7996
Cherokee
1
2012
2511
Cherokee
2
2001
7675
Cherokee
2
2002
5558
Cherokee
2
2003
8224
Cherokee
2
2004
6855
Cherokee
2
2005
8331
Cherokee
2
2006
8048
Cherokee
2
2007
6748
Cherokee
2
2008
6810
Cherokee
2
2009
4998
Cherokee
2
2010
7432
Cherokee
2
2011
5897
Cherokee
3
2001
7803
Cherokee
3
2002
6954
Cherokee
3
2003
7927
Cherokee
3
2004
7741
Cherokee
3
2005
7193
Cherokee
3
2006
8057
Cherokee
3
2007
7579
Cherokee
3
2008
7578
Cherokee
3
2009
7419
Cherokee
3
2010
6336
Cherokee
3
2011
6773
Cherokee
3
2012
6658
Cherokee
3
2013
8095
Cherokee
3
2014
8322
Cherokee
3
2015
4169
Cherokee
4
2001
7959
Cherokee
4
2002
7310
Cherokee
4
2003
6596
Cherokee
4
2004
8156
Cherokee
4
2005
7874
Cherokee
4
2006
7547
Cherokee
4
2007
7814
Cherokee
4
2008
8021
Cherokee
4
2009
5874
Cherokee
4
2010
6092
Cherokee
4
2011
7097
Cherokee
4
2012
7914
Cherokee
4
2013
7036
Cherokee
4
2014
7264
Cherokee
4
2015
7367
Cherokee
4
2016
8289
Cholla
1
2001
6660
Cholla
1
2002
8358
Cholla
1
2003
8504
Cholla
1
2004
8043
Cholla
1
2005
8588
Cholla
1
2006
8619
Cholla
1
2007
7613
Cholla
1
2008
8533
Cholla
1
2009
7298
Cholla
1
2010
8605
Cholla
1
2011
7970
Cholla
1
2012
8481
Cholla
1
2013
8450
Cholla
1
2014
8184
Cholla
1
2015
7199
Cholla
1
2016
1947
Cholla
2
2001
7876
Cholla
2
2002
7361
Cholla
2
2003
8403
Cholla
2
2004
8462
Cholla
2
2005
7355
Cholla
2
2006
8312
Cholla
2
2007
8704
Cholla
2
2008
7785
Cholla
2
2009
8163
Cholla
2
2010
6782
Cholla
2
2011
8475
Cholla
2
2012
8515
Cholla
2
2013
7814
Cholla
2
2014
7733
Cholla
2
2015
5851
Cholla
3
2001
8222
Cholla
3
2002
8479
Cholla
3
2003
4069
Cholla
3
2004
8673
Cholla
3
2005
8696
Cholla
3
2006
7601
Cholla
3
2007
8504
Cholla
3
2008
8465
Cholla
3
2009
7039
Cholla
3
2010
8315
Cholla
3
2011
7892
Cholla
3
2012
7596
Cholla
3
2013
8250
Cholla
3
2014
7261
Cholla
3
2015
6752
Cholla
3
2016
3888
Cholla
4
2001
8143
Cholla
4
2002
7868
Cholla
4
2003
8448
Cholla
4
2004
6900
Cholla
4
2005
8557
Cholla
4
2006
8397
Cholla
4
2007
8496
Cholla
4
2008
7360
Cholla
4
2009
8535
Cholla
4
2010
7980
Cholla
4
2011
8228
Cholla
4
2012
8499
Cholla
4
2013
7476
Cholla
4
2014
8113
Cholla
4
2015
7409
Cholla
4
2016
6708
Colstrip
1
2001
7634
Colstrip
1
2002
8339
Colstrip
1
2003
7474
Colstrip
1
2004
8477
Colstrip
1
2005
8440
Colstrip
1
2006
7284
Colstrip
1
2007
8377
Colstrip
1
2008
8230
Colstrip
1
2009
7527
Colstrip
1
2010
8170
Colstrip
1
2011
7983
Colstrip
1
2012
5646
Colstrip
1
2013
8372
Colstrip
1
2014
8261
Colstrip
1
2015
7945
Colstrip
1
2016
6696
Colstrip
2
2001
8575
Colstrip
2
2002
7138
Colstrip
2
2003
8231
Colstrip
2
2004
8344
Colstrip
2
2005
7431
Colstrip
2
2006
8347
Colstrip
2
2007
8173
Colstrip
2
2008
7142
Colstrip
2
2009
8600
Colstrip
2
2010
7968
Colstrip
2
2011
6737
Colstrip
2
2012
5547
Colstrip
2
2013
8440
Colstrip
2
2014
8420
Colstrip
2
2015
6867
Colstrip
2
2016
7990
Colstrip
3
2001
7092
Colstrip
3
2002
5628
Colstrip
3
2003
8177
Colstrip
3
2004
7370
Colstrip
3
2005
8348
Colstrip
3
2006
8319
Colstrip
3
2007
7500
Colstrip
3
2008
8671
Colstrip
3
2009
8552
Colstrip
3
2010
8430
Colstrip
3
2011
6407
Colstrip
3
2012
7926
Colstrip
3
2013
8593
Colstrip
3
2014
7019
Colstrip
3
2015
8459
Colstrip
3
2016
8157
Colstrip
4
2001
7954
Colstrip
4
2002
8438
Colstrip
4
2003
7175
Colstrip
4
2004
8207
Colstrip
4
2005
8584
Colstrip
4
2006
7527
Colstrip
4
2007
8319
Colstrip
4
2008
8529
Colstrip
4
2009
3655
Colstrip
4
2010
8425
Colstrip
4
2011
8556
Colstrip
4
2012
8589
Colstrip
4
2013
3209
Colstrip
4
2014
7924
Colstrip
4
2015
8493
Colstrip
4
2016
7398
Comanche (470)
1
2001
7396
Comanche (470)
1
2002
7586
Comanche (470)
1
2003
7626
Comanche (470)
1
2004
5959
Comanche (470)
1
2005
7930
Comanche (470)
1
2006
8185
Comanche (470)
1
2007
8041
Comanche (470)
1
2008
6438
Comanche (470)
1
2009
8092
Comanche (470)
1
2010
7564
Comanche (470)
1
2011
6510
Comanche (470)
1
2012
7846
Comanche (470)
1
2013
8081
Comanche (470)
1
2014
6799
Comanche (470)
1
2015
8084
Comanche (470)
1
2016
8030
Comanche (470)
2
2001
7689
Comanche (470)
2
2002
8509
Comanche (470)
2
2003
8545
Comanche (470)
2
2004
8307
Comanche (470)
2
2005
6957
Comanche (470)
2
2006
8517
Comanche (470)
2
2007
6825
Comanche (470)
2
2008
8250
Comanche (470)
2
2009
7700
Comanche (470)
2
2010
6097
Comanche (470)
2
2011
6638
Comanche (470)
2
2012
8288
Comanche (470)
2
2013
6932
Comanche (470)
2
2014
8454
Comanche (470)
2
2015
8050
Comanche (470)
2
2016
6839
Comanche (470)
3
2010
5050
Comanche (470)
3
2011
5390
Comanche (470)
3
2012
7073
Comanche (470)
3
2013
7255
Comanche (470)
3
2014
6210
Comanche (470)
3
2015
6668
Comanche (470)
3
2016
7846
Coronado Generating Station
U1B
2001
7878
Coronado Generating Station
U1B
2002
7750
Coronado Generating Station
U1B
2003
8500
Coronado Generating Station
U1B
2004
7742
Coronado Generating Station
U1B
2005
8494
Coronado Generating Station
U1B
2006
8589
Coronado Generating Station
U1B
2007
8459
Coronado Generating Station
U1B
2008
8529
Coronado Generating Station
U1B
2009
7067
Coronado Generating Station
U1B
2010
8577
Coronado Generating Station
U1B
2011
8435
Coronado Generating Station
U1B
2012
7795
Coronado Generating Station
U1B
2013
8063
Coronado Generating Station
U1B
2014
8253
Coronado Generating Station
U1B
2015
7332
Coronado Generating Station
U1B
2016
8198
Coronado Generating Station
U2B
2001
8629
Coronado Generating Station
U2B
2002
8336
Coronado Generating Station
U2B
2003
8049
Coronado Generating Station
U2B
2004
8652
Coronado Generating Station
U2B
2005
8581
Coronado Generating Station
U2B
2006
7876
Coronado Generating Station
U2B
2007
7321
Coronado Generating Station
U2B
2008
8511
Coronado Generating Station
U2B
2009
8508
Coronado Generating Station
U2B
2010
8497
Coronado Generating Station
U2B
2011
7364
Coronado Generating Station
U2B
2012
8526
Coronado Generating Station
U2B
2013
8332
Coronado Generating Station
U2B
2014
7121
Coronado Generating Station
U2B
2015
8220
Coronado Generating Station
U2B
2016
8090
Craig
C1
2001
8510
Craig
C1
2002
8484
Craig
C1
2003
7545
Craig
C1
2004
8571
Craig
C1
2005
8667
Craig
C1
2006
7521
Craig
C1
2007
8611
Craig
C1
2008
8335
Craig
C1
2009
8746
Craig
C1
2010
8611
Craig
C1
2011
7395
Craig
C1
2012
8622
Craig
C1
2013
6200
Craig
C1
2014
7024
Craig
C1
2015
8541
Craig
C1
2016
7603
Craig
C2
2001
7361
Craig
C2
2002
8687
Craig
C2
2003
8383
Craig
C2
2004
7608
Craig
C2
2005
8382
Craig
C2
2006
8678
Craig
C2
2007
7951
Craig
C2
2008
8684
Craig
C2
2009
8336
Craig
C2
2010
7960
Craig
C2
2011
8384
Craig
C2
2012
8351
Craig
C2
2013
7429
Craig
C2
2014
8554
Craig
C2
2015
7641
Craig
C2
2016
8714
Craig
C3
2001
8473
Craig
C3
2002
8248
Craig
C3
2003
8446
Craig
C3
2004
8564
Craig
C3
2005
7630
Craig
C3
2006
8407
Craig
C3
2007
8650
Craig
C3
2008
8270
Craig
C3
2009
7395
Craig
C3
2010
8557
Craig
C3
2011
8458
Craig
C3
2012
8223
Craig
C3
2013
8641
Craig
C3
2014
8601
Craig
C3
2015
6848
Craig
C3
2016
8345
Dave Johnston
BW41
2001
8568
Dave Johnston
BW41
2002
8504
Dave Johnston
BW41
2003
7935
Dave Johnston
BW41
2004
8420
Dave Johnston
BW41
2005
8463
Dave Johnston
BW41
2006
8553
Dave Johnston
BW41
2007
8479
Dave Johnston
BW41
2008
7806
Dave Johnston
BW41
2009
8680
Dave Johnston
BW41
2010
8587
Dave Johnston
BW41
2011
8608
Dave Johnston
BW41
2012
8340
Dave Johnston
BW41
2013
8639
Dave Johnston
BW41
2014
8589
Dave Johnston
BW41
2015
8648
Dave Johnston
BW41
2016
7728
Dave Johnston
BW42
2001
8481
Dave Johnston
BW42
2002
8662
Dave Johnston
BW42
2003
8667
Dave Johnston
BW42
2004
8410
Dave Johnston
BW42
2005
8670
Dave Johnston
BW42
2006
8760
Dave Johnston
BW42
2007
7553
Dave Johnston
BW42
2008
7880
Dave Johnston
BW42
2009
8667
Dave Johnston
BW42
2010
8506
Dave Johnston
BW42
2011
8467
Dave Johnston
BW42
2012
8714
Dave Johnston
BW42
2013
8607
Dave Johnston
BW42
2014
7916
Dave Johnston
BW42
2015
8695
Dave Johnston
BW42
2016
8600
Dave Johnston
BW43
2001
8045
Dave Johnston
BW43
2002
8210
Dave Johnston
BW43
2003
8080
Dave Johnston
BW43
2004
8118
Dave Johnston
BW43
2005
7689
Dave Johnston
BW43
2006
8551
Dave Johnston
BW43
2007
8511
Dave Johnston
BW43
2008
8648
Dave Johnston
BW43
2009
8343
Dave Johnston
BW43
2010
6164
Dave Johnston
BW43
2011
8507
Dave Johnston
BW43
2012
8337
Dave Johnston
BW43
2013
8617
Dave Johnston
BW43
2014
8269
Dave Johnston
BW43
2015
7639
Dave Johnston
BW43
2016
7998
Dave Johnston
BW44
2001
7567
Dave Johnston
BW44
2002
8052
Dave Johnston
BW44
2003
6963
Dave Johnston
BW44
2004
8073
Dave Johnston
BW44
2005
7980
Dave Johnston
BW44
2006
8236
Dave Johnston
BW44
2007
8247
Dave Johnston
BW44
2008
8246
Dave Johnston
BW44
2009
6110
Dave Johnston
BW44
2010
8278
Dave Johnston
BW44
2011
8030
Dave Johnston
BW44
2012
7617
Dave Johnston
BW44
2013
8554
Dave Johnston
BW44
2014
8387
Dave Johnston
BW44
2015
8218
Dave Johnston
BW44
2016
8100
Dry Fork Station
01
2011
3250
Dry Fork Station
01
2012
8143
Dry Fork Station
01
2013
8038
Dry Fork Station
01
2014
8499
Dry Fork Station
01
2015
8262
Dry Fork Station
01
2016
7536
Escalante
1
2001
7460
Escalante
1
2002
8097
Escalante
1
2003
8709
Escalante
1
2004
8275
Escalante
1
2008
8155
Escalante
1
2009
8721
Escalante
1
2010
8201
Escalante
1
2011
8652
Escalante
1
2012
6988
Escalante
1
2013
8592
Escalante
1
2014
7605
Escalante
1
2015
8064
Escalante
1
2016
8784
Four Corners Steam Elec Station
1
2001
7362
Four Corners Steam Elec Station
1
2002
7246
Four Corners Steam Elec Station
1
2003
8184
Four Corners Steam Elec Station
1
2004
8217
Four Corners Steam Elec Station
1
2005
7640
Four Corners Steam Elec Station
1
2006
8648
Four Corners Steam Elec Station
1
2007
8339
Four Corners Steam Elec Station
1
2008
7735
Four Corners Steam Elec Station
1
2009
8348
Four Corners Steam Elec Station
1
2010
8290
Four Corners Steam Elec Station
1
2011
6894
Four Corners Steam Elec Station
1
2012
7133
Four Corners Steam Elec Station
1
2013
4620
Four Corners Steam Elec Station
2
2001
7383
Four Corners Steam Elec Station
2
2002
8021
Four Corners Steam Elec Station
2
2003
7897
Four Corners Steam Elec Station
2
2004
7323
Four Corners Steam Elec Station
2
2005
8489
Four Corners Steam Elec Station
2
2006
8436
Four Corners Steam Elec Station
2
2007
7736
Four Corners Steam Elec Station
2
2008
8155
Four Corners Steam Elec Station
2
2009
8279
Four Corners Steam Elec Station
2
2010
7393
Four Corners Steam Elec Station
2
2011
8152
Four Corners Steam Elec Station
2
2012
6929
Four Corners Steam Elec Station
2
2013
8102
Four Corners Steam Elec Station
3
2001
8297
Four Corners Steam Elec Station
3
2002
8288
Four Corners Steam Elec Station
3
2003
7276
Four Corners Steam Elec Station
3
2004
8386
Four Corners Steam Elec Station
3
2005
8217
Four Corners Steam Elec Station
3
2006
6782
Four Corners Steam Elec Station
3
2007
8258
Four Corners Steam Elec Station
3
2008
8437
Four Corners Steam Elec Station
3
2009
7762
Four Corners Steam Elec Station
3
2010
8112
Four Corners Steam Elec Station
3
2011
7666
Four Corners Steam Elec Station
3
2012
7317
Four Corners Steam Elec Station
3
2013
7877
Four Corners Steam Elec Station
4
2001
7896
Four Corners Steam Elec Station
4
2002
8035
Four Corners Steam Elec Station
4
2003
8225
Four Corners Steam Elec Station
4
2004
6247
Four Corners Steam Elec Station
4
2005
7916
Four Corners Steam Elec Station
4
2006
8328
Four Corners Steam Elec Station
4
2007
7331
Four Corners Steam Elec Station
4
2008
8258
Four Corners Steam Elec Station
4
2009
8025
Four Corners Steam Elec Station
4
2010
6007
Four Corners Steam Elec Station
4
2011
7607
Four Corners Steam Elec Station
4
2012
7718
Four Corners Steam Elec Station
4
2013
7006
Four Corners Steam Elec Station
4
2014
7175
Four Corners Steam Elec Station
4
2015
7698
Four Corners Steam Elec Station
4
2016
5933
Four Corners Steam Elec Station
5
2001
7927
Four Corners Steam Elec Station
5
2002
5637
Four Corners Steam Elec Station
5
2003
7892
Four Corners Steam Elec Station
5
2004
8458
Four Corners Steam Elec Station
5
2005
7390
Four Corners Steam Elec Station
5
2006
8055
Four Corners Steam Elec Station
5
2007
6929
Four Corners Steam Elec Station
5
2008
6136
Four Corners Steam Elec Station
5
2009
7910
Four Corners Steam Elec Station
5
2010
8104
Four Corners Steam Elec Station
5
2011
7435
Four Corners Steam Elec Station
5
2012
7399
Four Corners Steam Elec Station
5
2013
6954
Four Corners Steam Elec Station
5
2014
5997
Four Corners Steam Elec Station
5
2015
7565
Four Corners Steam Elec Station
5
2016
5399
Hardin
U1
2006
4421
Hardin
U1
2007
7419
Hardin
U1
2008
6476
Hardin Generating Station
U1
2009
7822
Hardin Generating Station
U1
2010
7828
Hardin Generating Station
U1
2011
6702
Hardin Generating Station
U1
2012
4815
Hardin Generating Station
U1
2013
6196
Hardin Generating Station
U1
2014
7085
Hardin Generating Station
U1
2015
5328
Hardin Generating Station
U1
2016
3482
Hayden
H1
2001
8569
Hayden
H1
2002
8344
Hayden
H1
2003
7142
Hayden
H1
2004
8500
Hayden
H1
2005
8530
Hayden
H1
2006
7551
Hayden
H1
2007
8679
Hayden
H1
2008
8606
Hayden
H1
2009
6898
Hayden
H1
2010
8521
Hayden
H1
2011
8522
Hayden
H1
2012
6110
Hayden
H1
2013
8605
Hayden
H1
2014
8469
Hayden
H1
2015
6906
Hayden
H1
2016
8347
Hayden
H2
2001
8226
Hayden
H2
2002
8475
Hayden
H2
2003
8552
Hayden
H2
2004
7884
Hayden
H2
2005
8341
Hayden
H2
2006
8648
Hayden
H2
2007
8327
Hayden
H2
2008
7823
Hayden
H2
2009
8550
Hayden
H2
2010
8672
Hayden
H2
2011
6393
Hayden
H2
2012
8522
Hayden
H2
2013
8438
Hayden
H2
2014
7684
Hayden
H2
2015
8455
Hayden
H2
2016
7131
Hunter
1
2001
5661
Hunter
1
2002
8162
Hunter
1
2003
8356
Hunter
1
2004
7986
Hunter
1
2005
7686
Hunter
1
2006
8522
Hunter
1
2007
8367
Hunter
1
2008
8428
Hunter
1
2009
8300
Hunter
1
2010
7291
Hunter
1
2011
8198
Hunter
1
2012
8386
Hunter
1
2013
8468
Hunter
1
2014
7000
Hunter
1
2015
8592
Hunter
1
2016
8463
Hunter
2
2001
8059
Hunter
2
2002
6930
Hunter
2
2003
7730
Hunter
2
2004
8408
Hunter
2
2005
8225
Hunter
2
2006
7595
Hunter
2
2007
8493
Hunter
2
2008
8656
Hunter
2
2009
8152
Hunter
2
2010
8062
Hunter
2
2011
7144
Hunter
2
2012
8463
Hunter
2
2013
8658
Hunter
2
2014
8630
Hunter
2
2015
7951
Hunter
2
2016
8354
Hunter
3
2001
7716
Hunter
3
2002
8208
Hunter
3
2003
8154
Hunter
3
2004
8577
Hunter
3
2005
8106
Hunter
3
2006
8422
Hunter
3
2007
7289
Hunter
3
2008
8375
Hunter
3
2009
8217
Hunter
3
2010
8413
Hunter
3
2011
8084
Hunter
3
2012
7726
Hunter
3
2013
8502
Hunter
3
2014
8209
Hunter
3
2015
8492
Hunter
3
2016
7170
Huntington
1
2001
7320
Huntington
1
2002
8161
Huntington
1
2003
8193
Huntington
1
2004
7386
Huntington
1
2005
7474
Huntington
1
2006
8368
Huntington
1
2007
8352
Huntington
1
2008
8193
Huntington
1
2009
8026
Huntington
1
2010
6898
Huntington
1
2011
8239
Huntington
1
2012
8433
Huntington
1
2013
8566
Huntington
1
2014
7605
Huntington
1
2015
8638
Huntington
1
2016
7376
Huntington
2
2001
8016
Huntington
2
2002
6682
Huntington
2
2003
8563
Huntington
2
2004
8037
Huntington
2
2005
8035
Huntington
2
2006
6683
Huntington
2
2007
8526
Huntington
2
2008
8609
Huntington
2
2009
8266
Huntington
2
2010
8115
Huntington
2
2011
6820
Huntington
2
2012
8462
Huntington
2
2013
8448
Huntington
2
2014
8423
Huntington
2
2015
7253
Huntington
2
2016
8511
Intermountain
1SGA
2001
7854
Intermountain
1SGA
2002
8494
Intermountain
1SGA
2003
7814
Intermountain
1SGA
2004
8735
Intermountain
1SGA
2005
7565
Intermountain
1SGA
2006
8742
Intermountain
1SGA
2007
7724
Intermountain
1SGA
2008
8649
Intermountain
1SGA
2009
8110
Intermountain
1SGA
2010
8565
Intermountain
1SGA
2011
7628
Intermountain
1SGA
2012
5076
Intermountain
1SGA
2013
8615
Intermountain
1SGA
2014
7395
Intermountain
1SGA
2015
8561
Intermountain
1SGA
2016
7865
Intermountain
2SGA
2001
8760
Intermountain
2SGA
2002
8073
Intermountain
2SGA
2003
8477
Intermountain
2SGA
2004
7896
Intermountain
2SGA
2005
8317
Intermountain
2SGA
2006
8023
Intermountain
2SGA
2007
8755
Intermountain
2SGA
2008
7912
Intermountain
2SGA
2009
8285
Intermountain
2SGA
2010
7318
Intermountain
2SGA
2011
8623
Intermountain
2SGA
2012
8477
Intermountain
2SGA
2013
7602
Intermountain
2SGA
2014
8598
Intermountain
2SGA
2015
8077
Intermountain
2SGA
2016
8636
Irvington Generating Station
4
2001
8180
Irvington Generating Station
4
2002
8560
Irvington Generating Station
4
2003
7345
Irvington Generating Station
4
2004
8269
Irvington Generating Station
4
2005
8310
Irvington Generating Station
4
2006
7231
Irvington Generating Station
4
2007
8399
Irvington Generating Station
4
2008
8471
Irvington Generating Station
4
2009
2276
Irvington Generating Station
4
2010
5665
Irvington Generating Station
4
2011
7986
Irvington Generating Station
4
2012
1426
Irvington Generating Station
4
2013
4783
Irvington Generating Station
4
2014
3336
Irvington Generating Station
4
2015
4384
J E Corette
2
2001
6991
J E Corette
2
2002
7912
J E Corette
2
2003
8324
J E Corette
2
2004
7953
J E Corette
2
2005
6802
J E Corette
2
2006
8182
J E Corette
2
2007
8056
J E Corette
2
2008
7312
J E Corette
2
2009
7832
J E Corette
2
2010
7411
J E Corette
2
2011
7144
J E Corette
2
2012
5667
J E Corette
2
2013
7127
J E Corette
2
2014
5299
J E Corette
2
2015
1471
Jim Bridger
BW71
2001
8415
Jim Bridger
BW71
2002
7463
Jim Bridger
BW71
2003
8263
Jim Bridger
BW71
2004
8369
Jim Bridger
BW71
2005
8242
Jim Bridger
BW71
2006
7221
Jim Bridger
BW71
2007
8350
Jim Bridger
BW71
2008
8149
Jim Bridger
BW71
2009
8155
Jim Bridger
BW71
2010
6325
Jim Bridger
BW71
2011
8134
Jim Bridger
BW71
2012
8385
Jim Bridger
BW71
2013
8387
Jim Bridger
BW71
2014
7278
Jim Bridger
BW71
2015
8115
Jim Bridger
BW71
2016
8258
Jim Bridger
BW72
2001
7725
Jim Bridger
BW72
2002
7989
Jim Bridger
BW72
2003
8078
Jim Bridger
BW72
2004
8145
Jim Bridger
BW72
2005
7007
Jim Bridger
BW72
2006
8371
Jim Bridger
BW72
2007
7882
Jim Bridger
BW72
2008
8370
Jim Bridger
BW72
2009
6953
Jim Bridger
BW72
2010
8520
Jim Bridger
BW72
2011
7971
Jim Bridger
BW72
2012
7953
Jim Bridger
BW72
2013
7543
Jim Bridger
BW72
2014
8490
Jim Bridger
BW72
2015
8525
Jim Bridger
BW72
2016
8559
Jim Bridger
BW73
2001
8501
Jim Bridger
BW73
2002
8450
Jim Bridger
BW73
2003
7124
Jim Bridger
BW73
2004
7962
Jim Bridger
BW73
2005
8283
Jim Bridger
BW73
2006
8363
Jim Bridger
BW73
2007
6914
Jim Bridger
BW73
2008
8437
Jim Bridger
BW73
2009
8406
Jim Bridger
BW73
2010
8220
Jim Bridger
BW73
2011
6765
Jim Bridger
BW73
2012
8599
Jim Bridger
BW73
2013
8439
Jim Bridger
BW73
2014
8585
Jim Bridger
BW73
2015
6353
Jim Bridger
BW73
2016
6548
Jim Bridger
BW74
2001
8328
Jim Bridger
BW74
2002
7840
Jim Bridger
BW74
2003
8147
Jim Bridger
BW74
2004
7475
Jim Bridger
BW74
2005
8276
Jim Bridger
BW74
2006
8216
Jim Bridger
BW74
2007
8160
Jim Bridger
BW74
2008
6843
Jim Bridger
BW74
2009
8436
Jim Bridger
BW74
2010
7959
Jim Bridger
BW74
2011
8271
Jim Bridger
BW74
2012
7301
Jim Bridger
BW74
2013
8463
Jim Bridger
BW74
2014
8556
Jim Bridger
BW74
2015
8559
Jim Bridger
BW74
2016
7090
Lamar
8
2009
1581
Lamar
8
2010
5713
Lamar
8
2011
1604
Laramie River
1
2001
8091
Laramie River
1
2002
8241
Laramie River
1
2003
7623
Laramie River
1
2004
8418
Laramie River
1
2005
8548
Laramie River
1
2006
7403
Laramie River
1
2007
8653
Laramie River
1
2008
8420
Laramie River
1
2009
7253
Laramie River
1
2010
8422
Laramie River
1
2011
8322
Laramie River
1
2012
5558
Laramie River
1
2013
8046
Laramie River
1
2014
8231
Laramie River
1
2015
5918
Laramie River
1
2016
7691
Laramie River
2
2001
7274
Laramie River
2
2002
8434
Laramie River
2
2003
8513
Laramie River
2
2004
7605
Laramie River
2
2005
8725
Laramie River
2
2006
8642
Laramie River
2
2007
7461
Laramie River
2
2008
8244
Laramie River
2
2009
7921
Laramie River
2
2010
6877
Laramie River
2
2011
8400
Laramie River
2
2012
8422
Laramie River
2
2013
6941
Laramie River
2
2014
6314
Laramie River
2
2015
7826
Laramie River
2
2016
7454
Laramie River
3
2001
8433
Laramie River
3
2002
6973
Laramie River
3
2003
8570
Laramie River
3
2004
8305
Laramie River
3
2005
7467
Laramie River
3
2006
8298
Laramie River
3
2007
8314
Laramie River
3
2008
7456
Laramie River
3
2009
6934
Laramie River
3
2010
8465
Laramie River
3
2011
7154
Laramie River
3
2012
8131
Laramie River
3
2013
8306
Laramie River
3
2014
5725
Laramie River
3
2015
7776
Laramie River
3
2016
8562
Lewis & Clark
B1
2001
8166
Lewis & Clark
B1
2002
7548
Lewis & Clark
B1
2003
8222
Lewis & Clark
B1
2004
8202
Lewis & Clark
B1
2005
6700
Lewis & Clark
B1
2006
8113
Lewis & Clark
B1
2007
7654
Lewis & Clark
B1
2008
8145
Lewis & Clark
B1
2009
8249
Lewis & Clark
B1
2010
8121
Lewis & Clark
B1
2011
7872
Lewis & Clark
B1
2012
7070
Lewis & Clark
B1
2013
8053
Lewis & Clark
B1
2014
7600
Lewis & Clark
B1
2015
6012
Lewis & Clark
B1
2016
7488
Martin Drake
5
2001
8357
Martin Drake
5
2002
8485
Martin Drake
5
2003
7458
Martin Drake
5
2004
8128
Martin Drake
5
2005
7427
Martin Drake
5
2006
8393
Martin Drake
5
2007
6910
Martin Drake
5
2008
8508
Martin Drake
5
2009
7192
Martin Drake
5
2010
8413
Martin Drake
5
2011
7890
Martin Drake
5
2012
8608
Martin Drake
5
2013
8270
Martin Drake
5
2014
2635
Martin Drake
5
2015
5416
Martin Drake
5
2016
109
Martin Drake
6
2001
6606
Martin Drake
6
2002
8255
Martin Drake
6
2003
8192
Martin Drake
6
2004
7562
Martin Drake
6
2005
8286
Martin Drake
6
2006
7650
Martin Drake
6
2007
8247
Martin Drake
6
2008
7252
Martin Drake
6
2009
8439
Martin Drake
6
2010
7475
Martin Drake
6
2011
7146
Martin Drake
6
2012
8199
Martin Drake
6
2013
8169
Martin Drake
6
2014
6257
Martin Drake
6
2015
8100
Martin Drake
6
2016
7146
Martin Drake
7
2001
8187
Martin Drake
7
2002
7066
Martin Drake
7
2003
8529
Martin Drake
7
2004
7062
Martin Drake
7
2005
8732
Martin Drake
7
2006
7250
Martin Drake
7
2007
8115
Martin Drake
7
2008
6868
Martin Drake
7
2009
8179
Martin Drake
7
2010
7418
Martin Drake
7
2011
8032
Martin Drake
7
2012
7072
Martin Drake
7
2013
6363
Martin Drake
7
2014
5800
Martin Drake
7
2015
7037
Martin Drake
7
2016
8027
Mohave
1
2001
7704
Mohave
1
2002
7472
Mohave
1
2003
8200
Mohave
1
2004
7598
Mohave
1
2005
8286
Mohave
2
2001
7537
Mohave
2
2002
8082
Mohave
2
2003
7012
Mohave
2
2004
7515
Mohave
2
2005
7697
Naughton
1
2001
8450
Naughton
1
2002
7724
Naughton
1
2003
8455
Naughton
1
2004
8143
Naughton
1
2005
8362
Naughton
1
2006
8438
Naughton
1
2007
7727
Naughton
1
2008
8674
Naughton
1
2009
8648
Naughton
1
2010
8677
Naughton
1
2011
8471
Naughton
1
2012
6318
Naughton
1
2013
8392
Naughton
1
2014
8303
Naughton
1
2015
8461
Naughton
1
2016
8558
Naughton
2
2001
8346
Naughton
2
2002
7409
Naughton
2
2003
7686
Naughton
2
2004
8362
Naughton
2
2005
8492
Naughton
2
2006
7177
Naughton
2
2007
8635
Naughton
2
2008
8660
Naughton
2
2009
8395
Naughton
2
2010
8541
Naughton
2
2011
7094
Naughton
2
2012
8039
Naughton
2
2013
8208
Naughton
2
2014
8356
Naughton
2
2015
8530
Naughton
2
2016
7405
Naughton
3
2001
8175
Naughton
3
2002
7663
Naughton
3
2003
6791
Naughton
3
2004
8258
Naughton
3
2005
7829
Naughton
3
2006
8403
Naughton
3
2007
7971
Naughton
3
2008
7871
Naughton
3
2009
6879
Naughton
3
2010
8248
Naughton
3
2011
8159
Naughton
3
2012
8212
Naughton
3
2013
8371
Naughton
3
2014
7918
Naughton
3
2015
7386
Naughton
3
2016
8368
Navajo Generating Station
1
2001
7918
Navajo Generating Station
1
2002
8523
Navajo Generating Station
1
2003
7611
Navajo Generating Station
1
2004
8570
Navajo Generating Station
1
2005
7243
Navajo Generating Station
1
2006
8585
Navajo Generating Station
1
2007
8364
Navajo Generating Station
1
2008
7991
Navajo Generating Station
1
2009
8587
Navajo Generating Station
1
2010
8482
Navajo Generating Station
1
2011
7051
Navajo Generating Station
1
2012
8672
Navajo Generating Station
1
2013
8499
Navajo Generating Station
1
2014
7949
Navajo Generating Station
1
2015
8575
Navajo Generating Station
1
2016
8244
Navajo Generating Station
2
2001
8644
Navajo Generating Station
2
2002
8200
Navajo Generating Station
2
2003
8443
Navajo Generating Station
2
2004
7401
Navajo Generating Station
2
2005
8330
Navajo Generating Station
2
2006
7831
Navajo Generating Station
2
2007
7811
Navajo Generating Station
2
2008
8482
Navajo Generating Station
2
2009
8340
Navajo Generating Station
2
2010
6844
Navajo Generating Station
2
2011
8528
Navajo Generating Station
2
2012
8584
Navajo Generating Station
2
2013
7725
Navajo Generating Station
2
2014
8724
Navajo Generating Station
2
2015
8076
Navajo Generating Station
2
2016
7035
Navajo Generating Station
3
2001
7849
Navajo Generating Station
3
2002
8551
Navajo Generating Station
3
2003
7163
Navajo Generating Station
3
2004
8782
Navajo Generating Station
3
2005
8304
Navajo Generating Station
3
2006
7986
Navajo Generating Station
3
2007
8229
Navajo Generating Station
3
2008
8431
Navajo Generating Station
3
2009
6233
Navajo Generating Station
3
2010
8220
Navajo Generating Station
3
2011
8622
Navajo Generating Station
3
2012
7855
Navajo Generating Station
3
2013
8640
Navajo Generating Station
3
2014
8231
Navajo Generating Station
3
2015
6879
Navajo Generating Station
3
2016
8035
Neil Simpson II
001
2001
8611
Neil Simpson II
001
2002
8682
Neil Simpson II
001
2003
8559
Neil Simpson II
001
2004
8225
Neil Simpson II
001
2005
7962
Neil Simpson II
001
2006
8751
Neil Simpson II
001
2007
8443
Neil Simpson II
001
2008
8699
Neil Simpson II
001
2009
8048
Neil Simpson II
001
2010
8586
Neil Simpson II
001
2011
8492
Neil Simpson II
001
2012
7452
Neil Simpson II
001
2013
8628
Neil Simpson II
001
2014
7824
Neil Simpson II
001
2015
8256
Neil Simpson II
001
2016
8388
North Valmy
1
2001
6856
North Valmy
1
2002
8236
North Valmy
1
2003
8200
North Valmy
1
2004
8175
North Valmy
1
2005
7748
North Valmy
1
2006
6797
North Valmy
1
2007
7935
North Valmy
1
2008
7658
North Valmy
1
2009
7416
North Valmy
1
2010
8275
North Valmy
1
2011
5248
North Valmy
1
2012
5780
North Valmy
1
2013
7565
North Valmy
1
2014
7768
North Valmy
1
2015
7672
North Valmy
1
2016
3447
North Valmy
2
2001
7795
North Valmy
2
2002
8484
North Valmy
2
2003
5442
North Valmy
2
2004
8078
North Valmy
2
2005
8114
North Valmy
2
2006
7907
North Valmy
2
2007
6942
North Valmy
2
2008
7837
North Valmy
2
2009
8166
North Valmy
2
2010
6598
North Valmy
2
2011
7784
North Valmy
2
2012
6270
North Valmy
2
2013
7636
North Valmy
2
2014
6400
North Valmy
2
2015
2128
North Valmy
2
2016
3145
Nucla
1
2001
7648
Nucla
1
2002
8156
Nucla
1
2003
7198
Nucla
1
2004
8232
Nucla
1
2005
8046
Nucla
1
2006
8107
Nucla
1
2007
7607
Nucla
1
2008
7792
Nucla
1
2009
7812
Nucla
1
2010
5906
Nucla
1
2011
7557
Nucla
1
2012
7331
Nucla
1
2013
4898
Nucla
1
2014
5518
Nucla
1
2015
5463
Nucla
1
2016
2992
Pawnee
1
2001
8587
Pawnee
1
2002
7444
Pawnee
1
2003
8508
Pawnee
1
2004
7683
Pawnee
1
2005
7049
Pawnee
1
2006
8380
Pawnee
1
2007
8565
Pawnee
1
2008
8140
Pawnee
1
2009
4971
Pawnee
1
2010
7820
Pawnee
1
2011
6777
Pawnee
1
2012
7734
Pawnee
1
2013
7173
Pawnee
1
2014
6301
Pawnee
1
2015
8051
Pawnee
1
2016
6536
Prewitt Escalante Generating Station
1
2005
8659
Prewitt Escalante Generating Station
1
2006
7124
Prewitt Escalante Generating Station
1
2007
8639
Rawhide Energy Station
101
2001
8451
Rawhide Energy Station
101
2002
7915
Rawhide Energy Station
101
2003
8439
Rawhide Energy Station
101
2004
8610
Rawhide Energy Station
101
2005
7550
Rawhide Energy Station
101
2006
8401
Rawhide Energy Station
101
2007
8570
Rawhide Energy Station
101
2008
7762
Rawhide Energy Station
101
2009
8745
Rawhide Energy Station
101
2010
8311
Rawhide Energy Station
101
2011
8706
Rawhide Energy Station
101
2012
8012
Rawhide Energy Station
101
2013
8693
Rawhide Energy Station
101
2014
8549
Rawhide Energy Station
101
2015
7526
Rawhide Energy Station
101
2016
8593
Ray D Nixon
1
2001
7643
Ray D Nixon
1
2002
8268
Ray D Nixon
1
2003
8286
Ray D Nixon
1
2004
8384
Ray D Nixon
1
2005
7509
Ray D Nixon
1
2006
7792
Ray D Nixon
1
2007
7325
Ray D Nixon
1
2008
8497
Ray D Nixon
1
2009
7803
Ray D Nixon
1
2010
8247
Ray D Nixon
1
2011
7302
Ray D Nixon
1
2012
7842
Ray D Nixon
1
2013
8340
Ray D Nixon
1
2014
6951
Ray D Nixon
1
2015
8117
Ray D Nixon
1
2016
7100
Reid Gardner
1
2001
7077
Reid Gardner
1
2002
7596
Reid Gardner
1
2003
8235
Reid Gardner
1
2004
7522
Reid Gardner
1
2005
7821
Reid Gardner
1
2006
7729
Reid Gardner
1
2007
6398
Reid Gardner
1
2008
6417
Reid Gardner
1
2009
6126
Reid Gardner
1
2010
6345
Reid Gardner
1
2011
6281
Reid Gardner
1
2012
2249
Reid Gardner
1
2013
3367
Reid Gardner
1
2014
6966
Reid Gardner
2
2001
7223
Reid Gardner
2
2002
7954
Reid Gardner
2
2003
7561
Reid Gardner
2
2004
7985
Reid Gardner
2
2005
6821
Reid Gardner
2
2006
7418
Reid Gardner
2
2007
8045
Reid Gardner
2
2008
7596
Reid Gardner
2
2009
5255
Reid Gardner
2
2010
6567
Reid Gardner
2
2011
5941
Reid Gardner
2
2012
1257
Reid Gardner
2
2013
3342
Reid Gardner
2
2014
6496
Reid Gardner
3
2001
7996
Reid Gardner
3
2002
7906
Reid Gardner
3
2003
6893
Reid Gardner
3
2004
7958
Reid Gardner
3
2005
6516
Reid Gardner
3
2006
6662
Reid Gardner
3
2007
6637
Reid Gardner
3
2008
6835
Reid Gardner
3
2009
6657
Reid Gardner
3
2010
7080
Reid Gardner
3
2011
5850
Reid Gardner
3
2012
2016
Reid Gardner
3
2013
2902
Reid Gardner
3
2014
4645
Reid Gardner
4
2001
7612
Reid Gardner
4
2002
8005
Reid Gardner
4
2003
7014
Reid Gardner
4
2004
7421
Reid Gardner
4
2005
7780
Reid Gardner
4
2006
7560
Reid Gardner
4
2007
7808
Reid Gardner
4
2008
6830
Reid Gardner
4
2009
7937
Reid Gardner
4
2010
7000
Reid Gardner
4
2011
6058
Reid Gardner
4
2012
5853
Reid Gardner
4
2013
6510
Reid Gardner
4
2014
5210
Reid Gardner
4
2015
2753
Reid Gardner
4
2016
2281
San Juan
1
2001
8275
San Juan
1
2002
7397
San Juan
1
2003
8226
San Juan
1
2004
7800
San Juan
1
2005
8197
San Juan
1
2006
7747
San Juan
1
2007
8209
San Juan
1
2008
6669
San Juan
1
2009
8043
San Juan
1
2010
7687
San Juan
1
2011
6735
San Juan
1
2012
7301
San Juan
1
2013
7488
San Juan
1
2014
6344
San Juan
1
2015
5931
San Juan
1
2016
7631
San Juan
2
2001
7173
San Juan
2
2002
8355
San Juan
2
2003
7057
San Juan
2
2004
8396
San Juan
2
2005
7859
San Juan
2
2006
8486
San Juan
2
2007
7361
San Juan
2
2008
7936
San Juan
2
2009
6432
San Juan
2
2010
6687
San Juan
2
2011
7576
San Juan
2
2012
6756
San Juan
2
2013
7549
San Juan
2
2014
7639
San Juan
2
2015
7210
San Juan
2
2016
6975
San Juan
3
2001
7291
San Juan
3
2002
8246
San Juan
3
2003
7871
San Juan
3
2004
7771
San Juan
3
2005
8131
San Juan
3
2006
7794
San Juan
3
2007
8191
San Juan
3
2008
6592
San Juan
3
2009
8386
San Juan
3
2010
6191
San Juan
3
2011
8022
San Juan
3
2012
7157
San Juan
3
2013
7302
San Juan
3
2014
7757
San Juan
3
2015
7532
San Juan
3
2016
7228
San Juan
4
2001
7769
San Juan
4
2002
8382
San Juan
4
2003
7375
San Juan
4
2004
8593
San Juan
4
2005
8006
San Juan
4
2006
8270
San Juan
4
2007
6273
San Juan
4
2008
7827
San Juan
4
2009
8227
San Juan
4
2010
7241
San Juan
4
2011
8215
San Juan
4
2012
8244
San Juan
4
2013
6911
San Juan
4
2014
7823
San Juan
4
2015
6927
San Juan
4
2016
7785
Springerville Generating Station
1
2001
8534
Springerville Generating Station
1
2002
7876
Springerville Generating Station
1
2003
8324
Springerville Generating Station
1
2004
7386
Springerville Generating Station
1
2005
8351
Springerville Generating Station
1
2006
8033
Springerville Generating Station
1
2007
8516
Springerville Generating Station
1
2008
8160
Springerville Generating Station
1
2009
7716
Springerville Generating Station
1
2010
8163
Springerville Generating Station
1
2011
7426
Springerville Generating Station
1
2012
8414
Springerville Generating Station
1
2013
8446
Springerville Generating Station
1
2014
8173
Springerville Generating Station
1
2015
8480
Springerville Generating Station
1
2016
7523
Springerville Generating Station
2
2001
8226
Springerville Generating Station
2
2002
8692
Springerville Generating Station
2
2003
8248
Springerville Generating Station
2
2004
8589
Springerville Generating Station
2
2005
7176
Springerville Generating Station
2
2006
8200
Springerville Generating Station
2
2007
7857
Springerville Generating Station
2
2008
8187
Springerville Generating Station
2
2009
7841
Springerville Generating Station
2
2010
7124
Springerville Generating Station
2
2011
8409
Springerville Generating Station
2
2012
8431
Springerville Generating Station
2
2013
7967
Springerville Generating Station
2
2014
6593
Springerville Generating Station
2
2015
8103
Springerville Generating Station
2
2016
8063
Springerville Generating Station
4
2009
353
Springerville Generating Station
4
2010
8001
Springerville Generating Station
4
2011
8134
Springerville Generating Station
4
2012
6661
Springerville Generating Station
4
2013
8162
Springerville Generating Station
4
2014
6905
Springerville Generating Station
4
2015
8474
Springerville Generating Station
4
2016
7253
Springerville Generating Station
TS3
2006
2296
Springerville Generating Station
TS3
2007
7806
Springerville Generating Station
TS3
2008
8129
Springerville Generating Station
TS3
2009
8297
Springerville Generating Station
TS3
2010
7923
Springerville Generating Station
TS3
2011
8253
Springerville Generating Station
TS3
2012
6057
Springerville Generating Station
TS3
2013
7757
Springerville Generating Station
TS3
2014
8532
Springerville Generating Station
TS3
2015
8385
Springerville Generating Station
TS3
2016
6998
TS Power Plant
001
2008
5555
TS Power Plant
001
2009
7511
TS Power Plant
001
2010
8168
TS Power Plant
001
2011
8176
TS Power Plant
001
2012
7696
TS Power Plant
001
2013
8094
TS Power Plant
001
2014
7448
TS Power Plant
001
2015
7978
TS Power Plant
001
2016
8132
Valmont
5
2001
8267
Valmont
5
2002
7313
Valmont
5
2003
8379
Valmont
5
2004
7800
Valmont
5
2005
8666
Valmont
5
2006
7608
Valmont
5
2007
7678
Valmont
5
2008
7320
Valmont
5
2009
6945
Valmont
5
2010
7132
Valmont
5
2011
6813
Valmont
5
2012
7615
Valmont
5
2013
6936
Valmont
5
2014
7610
Valmont
5
2015
7665
Valmont
5
2016
7720
Wygen I
001
2003
5535
Wygen I
001
2004
8682
Wygen I
001
2005
8400
Wygen I
001
2006
8493
Wygen I
001
2007
8572
Wygen I
001
2008
8586
Wygen I
001
2009
8525
Wygen I
001
2010
7750
Wygen I
001
2011
8667
Wygen I
001
2012
8149
Wygen I
001
2013
8357
Wygen I
001
2014
8471
Wygen I
001
2015
8747
Wygen I
001
2016
8511
Wygen II
001
2008
7932
Wygen II
001
2009
8562
Wygen II
001
2010
8446
Wygen II
001
2011
8618
Wygen II
001
2012
7576
Wygen II
001
2013
8536
Wygen II
001
2014
8706
Wygen II
001
2015
8018
Wygen II
001
2016
8745
Wygen III
001
2010
5514
Wygen III
001
2011
8391
Wygen III
001
2012
8553
Wygen III
001
2013
8488
Wygen III
001
2014
8401
Wygen III
001
2015
7973
Wygen III
001
2016
8178
Wyodak
BW91
2001
8461
Wyodak
BW91
2002
8625
Wyodak
BW91
2003
8563
Wyodak
BW91
2004
8273
Wyodak
BW91
2005
8309
Wyodak
BW91
2006
7493
Wyodak
BW91
2007
8654
Wyodak
BW91
2008
8544
Wyodak
BW91
2009
8453
Wyodak
BW91
2010
8171
Wyodak
BW91
2011
6412
Wyodak
BW91
2012
8416
Wyodak
BW91
2013
8364
Wyodak
BW91
2014
8554
Wyodak
BW91
2015
8241
Wyodak
BW91
2016
6813
In [11]:
select name, unitid, year, count(*) as maybe_NG from data where CO2_MASS / heat_input > 0.05 and CO2_MASS / heat_input < 0.07
group by name, unitid, year)
File "<ipython-input-11-865751f5b5e5>", line 1
select name, unitid, year, count(*) as maybe_NG from data where CO2_MASS / heat_input > 0.05 and CO2_MASS / heat_input < 0.07
^
SyntaxError: invalid syntax
In [ ]:
%%sql
create table n_or_c as
select d.name, d.unitid, d.op_date, maybe_NG, maybe_coal, CAST(maybe_NG as float) / count(*) as percent_NG, CAST(maybe_coal as float) / count(*) as percent_coal
from data as d,
(select name, unitid, op_date, count(*) as maybe_NG from data where CO2_MASS / heat_input > 0.05 and CO2_MASS / heat_input < 0.07
group by name, unitid, op_date) as n,
(select name, unitid, op_date, count(*) as maybe_coal from data where CO2_MASS / heat_input > 0.09 and CO2_MASS / heat_input < 0.11
group by name, unitid, op_date) as c
WHERE d.name = n.name and d.unitid = n.unitid and d.op_date = n.op_date and
d.name = c.name and d.unitid = c.unitid and d.op_date = c.op_date
and d.CO2_MASS > 0
group by d.name, d.unitid, d.op_date
In [ ]:
%sql select * from n_or_c where name = 'Apache Station' and substr(op_date, 1, 2) is '02' and substr(op_date, -4) is '2016'
In [ ]:
Content source: maxoboe/CEMS_Project
Similar notebooks: