In [1]:
%load_ext sql
In [22]:
%sql sqlite:///smaller.db
Out[22]:
u'Connected: None@smaller.db'
In [24]:
%sql select fuel_type, count(distinct(orispl_code)) from data group by fuel_type
Done.
Out[24]:
fuel_type
count(distinct(orispl_code))
1
Coal
48
Diesel Oil, Pipeline Natural Gas
1
Natural Gas
19
Natural Gas, Pipeline Natural Gas
7
Other Gas
2
Other Gas, Pipeline Natural Gas
2
Pipeline Natural Gas
218
Residual Oil
1
Wood
1
In [17]:
%sql select count(distinct orispl_code) as num_plants, fuel_type, SUM(heat_input), SUM(CO2_MASS) from data group by fuel_type
Done.
Out[17]:
num_plants
fuel_type
SUM(heat_input)
SUM(CO2_MASS)
44
Coal
1828294021.68
190078286.186
14
Natural Gas
113287674.599
6733549.711
1
Natural Gas, Pipeline Natural Gas
182723.201
10859.063
1
Other Gas
27517565.063
1624003.463
195
Pipeline Natural Gas
1373820199.42
81557792.797
1
Wood
5528270.88
576296.4
In [29]:
%%sql
sqlite:///2001.db
select state, fuel_actual, count(distinct(orispl_code)) as num_plants, SUM(heat_input), SUM(CO2_MASS)
FROM data group by state, fuel_actual
Done.
Out[29]:
state
fuel_actual
num_plants
SUM(heat_input)
SUM(CO2_MASS)
AZ
Coal
6
447464342.556
45858558.383
AZ
Diesel Oil, Pipeline Natural Gas
1
3922781.89
232947.762
AZ
NG
12
77275933.065
4631412.907
CA
NG
42
771451551.61
46070834.191
CA
Other Gas
1
30245435.627
1797462.142
CO
Coal
12
409369046.922
41873476.105
CO
NG
8
49669889.087
2952962.662
ID
NG
3
13522917.891
805005.979
MT
Coal
3
197210476.525
20263992.416
NM
Coal
3
320935742.843
32895022.899
NM
NG
6
49013536.3
2911834.0
NV
Coal
3
184688247.325
18866468.125
NV
NG
6
61847530.038
4107718.62
NV
Other Gas, Pipeline Natural Gas
1
6518932.825
386449.925
NV
Residual Oil
1
2142100.0
155069.973
OR
Coal
1
48100995.674
4935161.171
OR
NG
3
52602588.025
3126122.525
TX
NG
1
22770856.0
1353244.375
UT
Coal
5
348415381.843
35747410.075
UT
NG
2
11713745.706
696160.167
WA
Coal
1
99112592.555
10168951.935
WA
NG
3
13337514.407
794225.276
WY
Coal
6
488540398.097
50099021.399
WY
NG
2
2833919.075
1090721.575
In [19]:
%sql select state, SUM(heat_input), SUM(CO2_MASS) from data group by state
Done.
Out[19]:
state
SUM(heat_input)
SUM(CO2_MASS)
AZ
597460133.453
50593183.391
CA
603241740.893
36036418.042
CO
425303069.115
39859836.596
ID
22913633.317
1361724.075
MT
162469182.803
16854220.287
NM
284275742.417
25788747.703
NV
216752274.71
13978845.264
OR
122923450.501
8175661.118
TX
21233025.586
1228637.087
UT
316881851.178
29915177.364
WA
129412925.837
10105159.388
WY
445763425.031
46683177.305
In [31]:
%%sql
sqlite:///smaller.db
select substr(op_date, -4) as year, state, fuel_actual, count(distinct(orispl_code)) as num_plants, SUM(heat_input), SUM(CO2_MASS)
FROM (select *,
CASE WHEN (fuel_type is 'Natural Gas' or fuel_type is 'Pipeline Natural Gas' or fuel_type is 'Natural Gas, Pipeline Natural Gas')
THEN ('NG') ELSE (fuel_type) END as fuel_actual
FROM data)
group by substr(op_date, -4), state, fuel_actual
Done.
Out[31]:
year
state
fuel_actual
num_plants
SUM(heat_input)
SUM(CO2_MASS)
2001
AZ
Coal
6
447464342.556
45858558.383
2001
AZ
Diesel Oil, Pipeline Natural Gas
1
3922781.89
232947.762
2001
AZ
NG
12
77275933.065
4631412.907
2001
CA
NG
42
771451551.61
46070834.191
2001
CA
Other Gas
1
30245435.627
1797462.142
2001
CO
Coal
12
409369046.922
41873476.105
2001
CO
NG
8
49669889.087
2952962.662
2001
ID
NG
3
13522917.891
805005.979
2001
MT
Coal
3
197210476.525
20263992.416
2001
NM
Coal
3
320935742.843
32895022.899
2001
NM
NG
6
49013536.3
2911834.0
2001
NV
Coal
3
184688247.325
18866468.125
2001
NV
NG
6
61847530.038
4107718.62
2001
NV
Other Gas, Pipeline Natural Gas
1
6518932.825
386449.925
2001
NV
Residual Oil
1
2142100.0
155069.973
2001
OR
Coal
1
48100995.674
4935161.171
2001
OR
NG
3
52602588.025
3126122.525
2001
TX
NG
1
22770856.0
1353244.375
2001
UT
Coal
5
348415381.843
35747410.075
2001
UT
NG
2
11713745.706
696160.167
2001
WA
Coal
1
99112592.555
10168951.935
2001
WA
NG
3
13337514.407
794225.276
2001
WY
Coal
6
488540398.097
50099021.399
2001
WY
NG
2
2833919.075
1090721.575
2002
AZ
Coal
6
435598524.785
44666766.22
2002
AZ
Diesel Oil, Pipeline Natural Gas
1
688823.165
40839.617
2002
AZ
NG
15
114135505.511
6780982.66
2002
CA
1
80080.12
4757.053
2002
CA
NG
55
500076141.914
29841627.633
2002
CA
Other Gas
1
24656060.495
1465274.527
2002
CO
Coal
12
400204149.144
40992534.072
2002
CO
NG
11
59064621.23
3510981.816
2002
ID
NG
3
8778970.827
526141.559
2002
MT
Coal
3
175789356.964
18061126.366
2002
NM
Coal
3
304091112.286
31177037.747
2002
NM
NG
8
36860386.025
2191110.05
2002
NV
Coal
3
195267099.5
20013859.025
2002
NV
NG
7
56634695.141
3374455.005
2002
NV
Other Gas, Pipeline Natural Gas
1
5792844.2
343373.65
2002
NV
Residual Oil
1
882097.825
51877.57
2002
OR
Coal
1
40170316.321
4121474.353
2002
OR
NG
5
58566429.463
3480560.387
2002
TX
NG
1
17920776.4
1065017.0
2002
UT
Coal
5
360831599.558
37020960.453
2002
UT
NG
3
12204382.579
724731.633
2002
WA
Coal
1
101470658.801
10410886.155
2002
WA
NG
5
14005655.201
836060.861
2002
WY
Coal
6
469570666.024
48055126.766
2002
WY
NG
2
2825008.726
209272.246
2003
AZ
Coal
6
429041904.798
43994838.275
2003
AZ
Diesel Oil, Pipeline Natural Gas
1
0.0
0.0
2003
AZ
NG
18
167884986.124
9980819.04
2003
CA
1
92166.111
5476.733
2003
CA
NG
66
511401670.098
30527735.685
2003
CA
Other Gas
1
13344746.449
793063.188
2003
CO
Coal
12
409315624.889
41936072.894
2003
CO
NG
13
59882974.147
3561685.131
2003
ID
NG
3
8798879.037
525425.753
2003
MT
Coal
3
190747566.927
19597803.229
2003
MT
NG
1
12232.122
7450.194
2003
NM
Coal
3
296293825.142
30388977.053
2003
NM
NG
9
38309741.7
2275139.927
2003
NV
Coal
3
181783059.225
18694759.4
2003
NV
NG
10
66841202.367
4216722.659
2003
NV
Other Gas, Pipeline Natural Gas
1
5157602.744
307265.717
2003
NV
Residual Oil
1
1094781.747
65060.338
2003
OR
Coal
1
48197610.427
4945073.2
2003
OR
NG
5
71699925.955
4261061.219
2003
TX
NG
1
17978772.9
1068447.575
2003
UT
Coal
5
372680960.638
38235790.255
2003
UT
NG
3
16499969.744
980318.467
2003
WA
Coal
1
127702186.322
13102236.08
2003
WA
NG
6
26772336.902
1593706.226
2003
WY
Coal
7
470608759.571
48265369.172
2003
WY
NG
2
1588649.644
94415.018
2004
AZ
Coal
6
440381425.904
45165097.492
2004
AZ
Diesel Oil, Pipeline Natural Gas
1
186341.2
10984.8
2004
AZ
NG
18
202800258.115
12053256.586
2004
CA
1
75569.257
4491.18
2004
CA
NG
66
596485646.404
35573751.327
2004
CA
Other Gas
1
5664291.517
336617.983
2004
CO
Coal
12
403836696.205
41395779.122
2004
CO
NG
14
69008128.282
4102743.938
2004
ID
NG
3
10134267.806
603657.688
2004
MT
Coal
3
191832822.581
19710296.899
2004
MT
NG
1
72053.7
45026.203
2004
NM
Coal
3
293941462.542
30153496.985
2004
NM
NG
9
37964480.857
2256532.626
2004
NV
Coal
3
198727739.15
20318794.15
2004
NV
NG
11
99591300.69
6058993.359
2004
NV
Residual Oil
1
2028250.238
120845.45
2004
OR
Coal
1
39192643.117
4021165.14
2004
OR
NG
6
79568974.188
4728444.802
2004
TX
NG
1
19394952.95
1152619.225
2004
UT
Coal
5
375586517.852
38509061.856
2004
UT
NG
4
10692598.773
635434.952
2004
WA
Coal
1
118421425.991
12150042.709
2004
WA
NG
7
40878991.214
2430873.679
2004
WY
Coal
7
488951678.086
50159384.629
2004
WY
NG
2
155442.462
9236.482
2005
AZ
Coal
6
445058718.689
45655108.722
2005
AZ
NG
19
212040999.951
12601461.684
2005
CA
1
106059.584
6303.16
2005
CA
NG
75
520530482.051
31062900.869
2005
CA
Other Gas
1
7364225.954
437643.441
2005
CO
Coal
12
401725243.469
41185081.843
2005
CO
NG
14
83147079.906
4942295.817
2005
ID
NG
4
9661652.444
574923.675
2005
MT
Coal
3
203743817.99
20928354.14
2005
MT
NG
1
63123.214
37671.889
2005
NM
Coal
3
304009219.879
31170317.753
2005
NM
NG
10
42683463.691
2536919.749
2005
NV
Coal
3
199089785.125
20412088.525
2005
NV
NG
11
115773105.781
6873721.48
2005
NV
Residual Oil
1
1516327.71
91253.771
2005
OR
Coal
1
38902989.013
3991449.077
2005
OR
NG
6
88170138.56
5239862.462
2005
TX
NG
1
20936166.45
1244201.9
2005
UT
Coal
5
369804346.258
37941915.483
2005
UT
NG
5
10258506.932
609646.605
2005
WA
Coal
1
122003016.061
12517501.661
2005
WA
NG
7
42188359.304
2508120.6
2005
WY
Coal
7
487695242.069
50029742.676
2005
WY
NG
2
425500.974
25285.879
2006
AZ
Coal
6
454342259.38
46600183.806
2006
AZ
NG
19
249255108.769
14812994.787
2006
CA
1
113254.213
6730.747
2006
CA
NG
81
626363058.297
37351411.769
2006
CA
Other Gas
1
7122182.021
423262.193
2006
CO
Coal
12
405699823.654
41604089.933
2006
CO
NG
14
84529065.372
5030403.787
2006
ID
NG
4
8247669.645
492044.633
2006
MT
Coal
4
203120838.223
20867720.829
2006
MT
NG
1
49562.936
30824.638
2006
NM
Coal
3
302225632.385
31008949.238
2006
NM
NG
11
56607244.883
3365337.086
2006
NV
Coal
3
88001713.325
9006291.075
2006
NV
NG
11
140487224.219
8346779.839
2006
NV
Residual Oil
1
771745.304
45884.543
2006
OR
Coal
1
26680338.009
2737399.387
2006
OR
NG
6
72932762.595
4334310.582
2006
TX
NG
1
18314762.775
1088421.35
2006
UT
Coal
5
379794516.793
38966949.117
2006
UT
NG
6
25972469.394
1543225.083
2006
WA
Coal
1
74504411.211
7644160.147
2006
WA
NG
8
39599105.959
2355289.914
2006
WY
Coal
7
482709480.986
49517852.659
2006
WY
NG
2
558477.188
33189.083
2007
AZ
Coal
6
483999791.056
49650753.929
2007
AZ
NG
19
280719377.609
16682709.595
2007
CA
1
95844.698
5695.918
2007
CA
NG
89
713481266.375
42515554.046
2007
CA
Other Gas
1
6067472.226
360580.811
2007
CO
Coal
12
398205048.033
40755756.375
2007
CO
NG
15
108874714.812
6491845.211
2007
ID
NG
4
11486276.397
685224.783
2007
MT
Coal
4
217640327.629
22355905.554
2007
MT
NG
1
102209.26
62645.561
2007
NM
Coal
3
278200192.578
28539977.873
2007
NM
NG
11
62856313.67
3737734.97
2007
NV
Coal
3
82157728.356
8412456.932
2007
NV
NG
11
144333286.274
8569512.887
2007
NV
Residual Oil
1
1101522.219
65459.652
2007
OR
Coal
1
46838077.298
4805585.011
2007
OR
NG
7
99540328.866
5915571.209
2007
TX
NG
1
21945924.86
1304204.977
2007
UT
Coal
5
379794411.344
38968053.627
2007
UT
NG
7
53993179.921
3208518.873
2007
WA
Coal
1
100095369.019
10269789.946
2007
WA
NG
8
42005469.307
2496664.808
2007
WY
Coal
7
486679296.656
49920594.07
2007
WY
NG
2
770356.658
45781.413
2008
AZ
Coal
6
480018213.272
49493669.344
2008
AZ
NG
20
282420699.81
16783497.916
2008
CA
1
55748.167
3312.543
2008
CA
NG
90
758458292.572
44006554.457
2008
CA
Other Gas
1
5643117.935
335362.612
2008
CO
Coal
12
385559733.527
39953043.197
2008
CO
NG
15
93035328.611
5531820.091
2008
ID
NG
4
11966903.623
720898.918
2008
MT
Coal
4
209623961.425
21764739.132
2008
MT
NG
1
39028.025
2510.916
2008
NM
Coal
3
280377639.943
28823337.778
2008
NM
NG
13
69192015.865
4114071.439
2008
NV
Coal
4
83902322.251
8701130.714
2008
NV
NG
12
159966842.691
9497345.065
2008
NV
Residual Oil
1
67580.759
4015.72
2008
OR
Coal
1
40583362.888
4229237.489
2008
OR
NG
7
118416954.984
7037352.792
2008
TX
NG
2
20839132.27
1220861.643
2008
UT
Coal
5
377906115.568
38775070.262
2008
UT
NG
6
52566878.837
3123796.901
2008
WA
Coal
1
102161050.729
10481793.578
2008
WA
NG
9
57610866.73
3424722.226
2008
WY
Coal
8
488680644.96
50694167.313
2008
WY
NG
2
427545.219
25408.254
2009
AZ
Coal
6
439426011.953
45262814.994
2009
AZ
NG
20
254359586.579
15115281.279
2009
CA
1
26709.942
1587.517
2009
CA
NG
96
690188363.322
41117641.883
2009
CA
Other Gas
1
6102162.172
362643.349
2009
CO
Coal
13
348541530.422
36296928.515
2009
CO
NG
16
106693141.142
6341172.696
2009
ID
NG
4
11343624.257
674132.116
2009
MT
Coal
4
174480312.708
18290692.426
2009
MT
NG
1
17810.938
1182.772
2009
NM
Coal
3
305017109.506
31629659.216
2009
NM
NG
13
74048023.888
4402294.38
2009
NV
Coal
4
80409222.741
8383574.104
2009
NV
NG
12
173094881.99
10287059.403
2009
NV
Residual Oil
1
0.0
0.0
2009
OR
Coal
1
31463895.964
3299932.521
2009
OR
NG
6
108954178.789
6474995.568
2009
TX
NG
2
20855625.404
1226287.426
2009
UT
Coal
5
350763820.938
35988370.353
2009
UT
NG
6
44367010.417
2636391.029
2009
WA
Coal
1
91401342.889
9377766.704
2009
WA
NG
10
74680111.7
4439656.682
2009
WY
Coal
8
454440851.291
47660735.067
2009
WY
NG
2
306757.443
18230.593
2010
AZ
Coal
6
461829594.138
47671946.067
2010
AZ
NG
21
219501372.984
13041295.998
2010
CA
1
34292.602
2037.708
2010
CA
NG
99
620154171.206
36954813.661
2010
CA
Other Gas
1
2186538.793
129940.769
2010
CO
Coal
13
382240998.949
39720663.657
2010
CO
NG
16
90479889.157
5378715.903
2010
ID
NG
4
11662220.106
693068.541
2010
MT
Coal
4
203106514.694
21316793.153
2010
MT
NG
3
661632.152
39572.424
2010
NM
Coal
3
271757494.609
28177853.879
2010
NM
NG
13
75371633.725
4480960.749
2010
NV
Coal
4
76239388.897
7909497.743
2010
NV
NG
12
156033667.77
9272880.303
2010
NV
Residual Oil
1
0.0
0.0
2010
OR
Coal
1
41164519.208
4317329.275
2010
OR
NG
6
110322530.065
6556321.694
2010
TX
NG
2
23213996.783
1365103.203
2010
UT
Coal
5
335223607.839
34393920.966
2010
UT
NG
6
43616537.791
2591859.128
2010
WA
Coal
1
103725526.031
10643341.415
2010
WA
NG
10
65914770.274
3917647.325
2010
WY
Coal
9
470855663.168
49373051.281
2010
WY
NG
2
158401.629
9413.379
2011
AZ
Coal
6
465369316.525
48115278.046
2011
AZ
NG
21
177793618.629
10562735.08
2011
CA
1
24634.566
1463.802
2011
CA
NG
98
491815905.594
29343042.18
2011
CA
Other Gas, Pipeline Natural Gas
1
2649561.784
157460.852
2011
CO
Coal
12
367945788.134
38268785.956
2011
CO
NG
16
81921259.79
4870470.018
2011
ID
NG
4
7470314.872
443952.966
2011
MT
Coal
4
168392008.708
17675308.191
2011
MT
NG
3
4804248.408
285903.745
2011
NM
Coal
3
284338427.779
29493476.661
2011
NM
NG
13
74009548.155
4400802.914
2011
NV
Coal
3
60392280.559
6321961.752
2011
NV
NG
12
144721128.669
8600622.943
2011
NV
Residual Oil
1
0.0
0.0
2011
OR
Coal
1
32539553.59
3412749.706
2011
OR
NG
6
60314954.79
3584438.23
2011
TX
NG
2
28246923.13
1627848.597
2011
UT
Coal
5
325432464.065
33389345.998
2011
UT
NG
6
36026292.307
2140775.862
2011
WA
Coal
1
59932995.096
6149128.697
2011
WA
NG
10
28757879.359
1709733.973
2011
WY
Coal
10
459074166.338
48142240.696
2011
WY
NG
2
168578.392
10017.792
2012
AZ
Coal
6
438327716.423
44956398.744
2012
AZ
NG
21
225377182.084
13388938.159
2012
CA
NG
103
718639606.707
42812462.665
2012
CA
Other Gas
1
25719863.888
1504384.073
2012
CO
Coal
12
367986226.925
38335644.87
2012
CO
NG
17
82305294.628
4891726.692
2012
ID
NG
5
13280243.49
789231.5
2012
MT
Coal
4
158245028.051
16606739.855
2012
MT
NG
3
5213130.488
309773.983
2012
NM
Coal
3
267987857.446
27780792.452
2012
NM
NG
13
76701654.383
4556973.461
2012
NV
Coal
3
44858335.248
4701206.698
2012
NV
NG
11
168666448.966
10023840.004
2012
NV
Residual Oil
1
0.0
0.0
2012
OR
Coal
1
26175067.445
2745242.592
2012
OR
NG
6
82672666.58
4913126.693
2012
TX
NG
2
29809317.623
1733278.615
2012
UT
Coal
5
302913898.831
31078969.853
2012
UT
NG
6
48434285.326
2878089.147
2012
WA
Coal
1
43735155.998
4542415.372
2012
WA
NG
11
34172485.24
2031084.454
2012
WY
Coal
10
476765181.347
49998736.128
2012
WY
NG
2
306080.473
18190.647
2013
AZ
Coal
6
467946702.343
48368622.86
2013
AZ
NG
21
218957991.149
13008632.414
2013
CA
NG
110
711479496.382
42307204.424
2013
CA
Other Gas
1
27289406.605
1603974.352
2013
CO
Coal
12
365338266.348
38056337.939
2013
CO
NG
17
87861088.998
5221854.4
2013
ID
NG
5
23925844.154
1421935.076
2013
MT
Coal
4
164723354.589
17288463.3
2013
MT
NG
4
6613569.97
393647.273
2013
NM
Coal
3
261725336.381
27158585.364
2013
NM
NG
13
76546722.265
4548406.628
2013
NV
Coal
3
58415584.173
6124149.282
2013
NV
NG
11
162619493.387
9664368.489
2013
NV
Residual Oil
1
0.0
0.0
2013
OR
Coal
1
37849578.295
3969664.164
2013
OR
NG
6
101492907.916
6031570.026
2013
TX
NG
2
33263580.116
1943119.025
2013
UT
Coal
5
338624823.373
34742892.074
2013
UT
NG
6
50281697.039
2987915.012
2013
WA
Coal
1
78699977.007
8254269.352
2013
WA
NG
11
78175835.216
4646001.793
2013
WY
Coal
10
505659771.26
53030139.054
2013
WY
NG
2
371518.905
22080.105
2014
AZ
Coal
6
467915312.601
48256810.819
2014
AZ
NG
21
202944406.404
12057382.754
2014
CA
NG
108
715004968.149
42517017.947
2014
CA
Other Gas
1
28249090.481
1663001.548
2014
CA
Wood
1
3348513.394
348194.929
2014
CO
Coal
11
352404216.227
36701159.531
2014
CO
NG
17
96890269.967
5758575.981
2014
ID
NG
5
17246492.68
1024935.351
2014
MT
Coal
4
175012067.145
18369362.967
2014
MT
NG
4
5617472.128
335948.447
2014
NM
Coal
3
216425766.273
22505102.821
2014
NM
NG
13
77464164.722
4602939.691
2014
NV
Coal
3
70638313.272
7407457.513
2014
NV
NG
11
149995773.244
8914061.859
2014
NV
Residual Oil
1
0.0
0.0
2014
OR
Coal
1
32041007.058
3360460.44
2014
OR
NG
6
90135520.158
5356632.879
2014
TX
NG
2
27669880.478
1606120.518
2014
UT
Coal
5
329203149.13
33776244.938
2014
UT
NG
6
60325598.061
3584877.66
2014
WA
Coal
1
77647432.737
8143658.027
2014
WA
NG
11
75748250.332
4502180.107
2014
WY
Coal
10
467169351.198
48993264.958
2014
WY
NG
2
151225.719
8987.37
2015
AZ
Coal
6
407078206.197
41979430.973
2015
AZ
NG
21
249365084.059
14814777.506
2015
CA
NG
106
703532688.613
41836023.956
2015
CA
Other Gas
1
27976103.195
1645392.655
2015
CA
Wood
1
4832148.081
503461.758
2015
CO
Coal
11
349753803.154
36434927.008
2015
CO
NG
18
94589396.081
5621471.724
2015
ID
NG
5
27027009.959
1606177.498
2015
MT
Coal
4
177850615.207
18661716.76
2015
MT
NG
4
6099081.529
362540.936
2015
NM
Coal
3
215762074.914
22392710.434
2015
NM
NG
13
80439681.923
4779300.392
2015
NV
Coal
3
30063313.203
3151028.259
2015
NV
NG
12
192735219.032
11454146.769
2015
OR
Coal
1
24134580.786
2531234.055
2015
OR
NG
6
109313155.622
6496319.689
2015
TX
NG
2
27026513.582
1577898.956
2015
UT
Coal
6
315641071.022
32384759.52
2015
UT
NG
6
57118508.558
3394267.052
2015
WA
Coal
1
60415411.925
6336360.826
2015
WA
NG
10
91037374.115
5410363.645
2015
WY
Coal
10
473817726.07
49690057.863
2015
WY
NG
3
1027269.81
61046.488
2016
AZ
Coal
6
347623835.147
35745813.953
2016
AZ
NG
22
249836298.306
14847369.438
2016
CA
NG
108
570195904.95
33836118.179
2016
CA
Other Gas
1
27517565.063
1624003.463
2016
CA
Wood
1
5528270.88
576296.4
2016
CO
Coal
11
325802503.609
33946540.614
2016
CO
NG
18
99500565.506
5913295.982
2016
ID
NG
5
22913633.317
1361724.075
2016
MT
Coal
3
158169474.901
16598575.224
2016
MT
NG
3
4299707.902
255645.063
2016
NM
Coal
3
199116436.051
20727173.046
2016
NM
NG
14
85159306.366
5061574.657
2016
NV
Coal
3
24189257.853
2534770.784
2016
NV
NG
12
192563016.857
11444074.48
2016
OR
Coal
1
19224271.607
2016241.522
2016
OR
NG
7
103699178.894
6159419.596
2016
TX
NG
2
21233025.586
1228637.087
2016
UT
Coal
6
256737376.604
26341249.394
2016
UT
NG
6
60144474.574
3573927.97
2016
WA
Coal
1
53116406.488
5570847.302
2016
WA
NG
10
76296519.349
4534312.086
2016
WY
Coal
10
444314459.422
46597074.347
2016
WY
NG
3
1448965.609
86102.958
In [ ]:
Content source: maxoboe/CEMS_Project
Similar notebooks: