Skip to content

Instantly share code, notes, and snippets.

@tshort

tshort/README.md

Forked from espinielli/README.md
Last active October 29, 2015 01:53
Show Gist options
  • Save tshort/a69ddbcedf925c59f188 to your computer and use it in GitHub Desktop.
Save tshort/a69ddbcedf925c59f188 to your computer and use it in GitHub Desktop.
Download ZIP
Problems with a groupby transform involving sum
Raw
README.md

Problems with a groupby transform involving sum

In this spec, the groupby transform works just fine using any of median, count, or average. When I use sum, the graph doesn't show.

Raw
f8612014.csv
Utility_Number State Utility_Name State_Code Year Service_Type Ownership Residential_Sales_Megawatthours Commercial_Sales_Megawatthours Total_Sales_Megawatthours Residential_Customers_Count Commercial_Customers_Count Total_Customers_Count Distribution_Circuits.x Circuits_with_Voltage_Optimization.x Distribution_Circuits.y Circuits_with_Voltage_Optimization.y SAIDI_With_MED SAIDI_Without_MED SAIFI_With_MED SAIFI_Without_MED IEEE_MED Highest_Dist_Voltage Outages_Recorded_Automatically AMR_Total AMI_Total Meters_Total DG_Number_of_Generators DG_Capacity_Back-up_Only DG_Total_Capacity_in_MWs DG_Capacity_Utility_Owned DG_Photovoltaic
15 195 AL Alabama Power Co 1 2014 Bundled Investor Owned 18726485 14329217 56854751 1247061 197828 1450921 2165 3 2165 3 194.3 117.9 1.334 1.036 FALSE 0 1423183
49 590 CA City of Anaheim - (CA) 6 2014 Bundled Municipal 609720 759259 2466538 98474 16836 115666 114 114 114 114 48.5 48.5 0.8 0.8 TRUE 12 Y 0 9240
53 689 MN Connexus Energy 27 2014 Bundled Cooperative 1164551 679501 1979438 117213 11387 128998 201 201 37.059 23.421 0.427 0.355 TRUE 12.5 Y
60 733 VA Appalachian Power Co 51 2014 Bundled Investor Owned 6461192 4013267 15954286 447766 74952 524618 555 0 555 0 363 334.2 1.705 1.668 TRUE 35 Y 525199 157 0 6 0 0.8 0 0
61 733 WV Appalachian Power Co 54 2014 Bundled Investor Owned 5721741 3637041 14185260 364704 66313 433391 484 0 484 0 818.8 640.8 2.891 2.727 TRUE 35 Y 435760 446 0
63 803 AZ Arizona Public Service Co 4 2014 Bundled Investor Owned 12837752 12477518 27584533 1033728 125623 1163079 1293 1293 111 79 0.91 0.79 TRUE 69 N 370 1166683 0
64 814 AR Entergy Arkansas Inc 5 2014 Bundled Investor Owned 8069917 6170936 21049257 586022 91417 701085 1174 0 1174 0 FALSE 34.5 Y 16590 809
66 817 AR Arkansas Valley Elec Coop Corp 5 2014 Bundled Cooperative 738355 162884 1179218 49494 3581 53097 127 0 127 0 53097
76 963 NJ Atlantic City Electric Co 34 2014 Bundled Investor Owned 3395705 960039 4455820 404344 43621 448497 355 0 355 0 123 123 1.2 1.2 TRUE 69 Y 1219 7001 0 123.2 0 122.1
77 963 NJ Atlantic City Electric Co 34 2014 Delivery Investor Owned 691783 3115915 4595557 74795 21590 96784 355 0 355 0 123 123 1.2 1.2 TRUE 69 Y 1219 7001 0 123.2 0 122.1
79 970 IL Homefield Energy 17 2014 Energy Retail Power Marketer 977470 2633571 3895533 135535 1781 137334
80 970 IL Homefield Energy 17 2014 Energy Retail Power Marketer 4748602 2422656 10644149 542140 1711 544016
85 1015 TX Austin Energy 48 2014 Bundled Municipal 4267484 5453445 12502512 394027 48016 442187 387 0 387 0 73.26 50.09 0.78 0.66 TRUE 35 Y 107047 335140 0 2 0 1.2 1.2 0.3
92 1149 AL Baldwin County El Member Corp 1 2014 Bundled Cooperative 911009 450541 1361550 63737 6669 70406 97 97 97 97 1.66 1.13 1.3 1.13 TRUE 12.5 Y 69461
93 1167 MD Baltimore Gas & Electric Co 24 2014 Bundled Investor Owned 8927905 3147168 12270475 801160 64114 868213 1392 50 1392 50 223 71 1.01 0.77 TRUE 34.5 Y 198679 1052582
94 1167 MD Baltimore Gas & Electric Co 24 2014 Delivery Investor Owned 4046074 12840271 18291606 322791 55155 380533 1392 50 1392 50 223 71 1.01 0.77 TRUE 34.5 Y 198679 1052582
98 1179 ME Emera Maine 23 2014 Delivery Investor Owned 615547 606162 1513646 102028 17781 119855 252 252 252 252 2155 354 3.919 2.673 TRUE 35 Y 119263
130 1579 WA PUD No 1 of Benton County 53 2014 Bundled Political Subdivision 696804 540006 1781322 41758 7504 50053 135 0 135 0 28.7 21.9 0.26 0.21 TRUE 15 Y 49469
143 1613 SC Berkeley Electric Coop Inc 45 2014 Bundled Cooperative 1269704 244465 2095651 78764 9179 88111 180 180 180 180 134 134 3.43 2.06 TRUE 25 Y 10249 72947
169 1886 KY Blue Grass Energy Coop Corp 21 2014 Bundled Cooperative 830406 164359 1332654 53379 2686 56075 130 13 130 13 257.8 122.9 1.54 1.22 TRUE 25 Y 56032
170 1889 NC Blue Ridge Elec Member Corp - (NC) 37 2014 Bundled Cooperative 736193 259491 1100324 66963 7782 74751 101 0 101 0 79.5 65.5 0.97 0.95 TRUE 15 Y 74756 1 0.2
171 1890 SC Blue Ridge Electric Coop Inc - (SC) 45 2014 Bundled Cooperative 764613 210632 1054720 58607 5187 63819 137 0 137 0 115.82 113.65 TRUE 7.2 N
174 1892 TX Bluebonnet Electric Coop, Inc 48 2014 Bundled Cooperative 1121532 220497 1957372 73724 10001 85847 220 172 220 172 2 2 1.29 1.29 FALSE 85846 1
209 2442 TX City of Bryan - (TX) 48 2014 Bundled Municipal 642395 548315 1323374 43695 7079 50786 90 0 90 0 19 0 0 0 FALSE 54214
213 2507 CA City of Burbank Water and Power 6 2014 Bundled Municipal 267682 855800 1123482 45284 7155 52439 116 0 116 0 10 10 0.235 0.235 FALSE 52439 13 1 1 0.2
246 3046 NC Duke Energy Progress - (NC) 37 2014 Bundled Investor Owned 16021212 13618798 37506433 1107292 192505 1303473 1058 1058 1058 1058 469 124 1.86 1.22 TRUE 35 Y 1305881 0 325 0 22.9 0 19.4
247 3046 SC Duke Energy Progress - (NC) 45 2014 Bundled Investor Owned 2292609 1804594 6559067 135036 31238 166955 169 169 169 169 2132 128 3.24 1.42 TRUE 35 Y 156729 7799 5 0 0.1 0 0.1
251 3093 AR Carroll Electric Coop Corp - (AR) 5 2014 Bundled Cooperative 1120562 312096 1734345 75123 5295 80454 165 0 165 0 2.41 1.83 1.65 1.48 TRUE 34.5 Y 78741
266 3248 GA Central Georgia El Member Corp 13 2014 Bundled Cooperative 792660 164408 1192670 48158 4668 52913 73 73 73 73 479 106 2.67 1.34 TRUE 25 Y 52978
267 3249 NY Central Hudson Gas & Elec Corp 36 2014 Bundled Investor Owned 1684952 801954 2569449 213187 33384 247334 209 0 209 0 106801
268 3249 NY Central Hudson Gas & Elec Corp 36 2014 Delivery Investor Owned 361590 1149441 2451305 41162 11856 53313 209 0 209 0 106801
271 3265 LA Cleco Power LLC 22 2014 Bundled Investor Owned 3783175 2818916 8814121 240205 40788 281583 773 0 773 0 2.36 2.36 1.67 1.67 FALSE 281718 0
273 3266 ME Central Maine Power Co 23 2014 Delivery Investor Owned 3683400 3186343 9335128 549484 62110 614238 492 0 492 0 12.7 3.29 12.7 2.34 TRUE 34.5 N 101 622556 622556 181 3.7
289 3408 TN City of Chattanooga - (TN) 47 2014 Bundled Municipal 2160990 2279370 5524163 140339 23257 163649 299 299 299 299 FALSE 0 161944 0 105 0 3.59 0 3.59
290 3408 TN City of Chattanooga - (TN) 47 2014 Bundled Municipal 2160990 2279370 5524163 140339 23257 163649 299 299 299 299 302.874 70.169 1.459 0.778 FALSE 0 161944 0 105 0 3.59 0 3.59
306 3503 MD Choptank Electric Coop, Inc 24 2014 Bundled Cooperative 693289 213624 993589 47573 5049 52647 110 0 110 0 1.17 1.17 0.77 0.77 TRUE 69 Y 19163 1 0.4 0.4
307 3522 AK Chugach Electric Assn Inc 2 2014 Bundled Cooperative 513748 563581 1134527 70127 9389 79523 92 92 78938 6 0.1 0.7 0
309 3542 OH Duke Energy Ohio Inc 39 2014 Delivery Investor Owned 3678672 6651462 15255807 311463 39050 351923 693 492 693 492 145.41 111.89 1.29 1.15 TRUE 34.5 N 292 692350 15 0.4 3.3
310 3542 OH Duke Energy Ohio Inc 39 2014 Bundled Investor Owned 3646633 1182713 5030930 308050 35441 344234 693 492 693 492 145.41 111.89 1.29 1.15 TRUE 34.5 N 292 692350 15 0.4 3.3
311 3579 TX Cirro Group, Inc. 48 2014 Bundled Retail Power Marketer 1610635 1924514 3535149 89928 24559 114487
319 3660 WA PUD No 1 of Clark County - (WA) 53 2014 Bundled Political Subdivision 2315417 1316304 4380723 175720 16834 192584 213 0 213 0 210.5 39.1 1.465 0.676 TRUE 12.5 Y 185718
323 3704 TN City of Clarksville - (TN) 47 2014 Bundled Municipal 875102 538441 1487394 57526 8016 65548 73 0 73 0 FALSE 0 57581 0 10 0 0.12 0 0.12
335 3755 OH Cleveland Electric Illum Co 39 2014 Delivery Investor Owned 4342100 5883962 15856166 509988 66829 577316 1079 987 1079 987 222.03 105 1.46 1.03 TRUE 36 Y 6463 32169 1219
336 3755 OH Cleveland Electric Illum Co 39 2014 Bundled Investor Owned 1206723 839549 2877136 149807 17133 167093 1079 987 1079 987 222.03 105 1.46 1.03 TRUE 36 Y 6463 32169 1219
337 3757 FL Clay Electric Cooperative, Inc 12 2014 Bundled Cooperative 2134428 625311 3115488 149556 18204 167804 182 0 182 0 210 180 3.8 3.2 TRUE 25 N 12
339 3762 OH City of Cleveland - (OH) 39 2014 Bundled Municipal 399023 614643 1618081 64336 8134 72494 276 276 41.88 0.08 TRUE 13.8 N 79200
342 3763 MA Dominion Retail Inc 25 2014 Energy Retail Power Marketer 444090 171241 615331 68497 6365 74862
348 3763 PA Dominion Retail Inc 42 2014 Energy Retail Power Marketer 1514844 162058 1676902 132086 7070 139156
358 3841 MS Coast Electric Power Assn 28 2014 Bundled Cooperative 1123341 391878 1722747 72611 6733 79352 124 0 124 0 85 35 1.47 0.68 TRUE 25 N 79344 11 0 0.853 0 0.153
367 3916 GA Cobb Electric Membership Corp 13 2014 Bundled Cooperative 2446620 1205517 3838364 176229 20904 197216 193 185 193 185 35.85 35.85 0.58 0.58 TRUE 20 N 193963 0
372 3989 CO City of Colorado Springs - (CO) 8 2014 Bundled Municipal 1425423 1097160 4477715 185963 29975 217497 210 0 210 0 43.53 43.53 0.727 0.727 TRUE 34.5 Y 208905 8436 7035 3 0 1.4 0 1.4
396 4110 IL Commonwealth Edison Co 17 2014 Bundled Investor Owned 9114941 7890441 18061768 1187567 149280 1336981 5484 13 5484 13 205 74 1.05 0.87 TRUE 34 Y 6213 743256 743256 488 0.2 6.4 0 4.6
397 4110 IL Commonwealth Edison Co 17 2014 Delivery Investor Owned 18114700 25051368 70518875 2302008 223191 2527078 5484 13 5484 13 205 74 1.05 0.87 TRUE 34 Y 6213 743256 743256 488 0.2 6.4 0 4.6
404 4166 ME CECG Maine, LLC 23 2014 Energy Retail Power Marketer 826557 71874 1074515 131035 11574 142610
405 4176 CT Connecticut Light & Power Co 9 2014 Delivery Investor Owned 3879621 7108729 13100310 408583 48476 458655 1047 0 1047 0 93.67 93.67 0.76 0.76 TRUE 34.5 Y 1251387 80 5.3 18.1 0 0.6
406 4176 CT Connecticut Light & Power Co 9 2014 Bundled Investor Owned 6146224 2365991 8945482 704394 65659 771847 1047 0 1047 0 93.67 93.67 0.76 0.76 TRUE 34.5 Y 1251387 80 5.3 18.1 0 0.6
411 4191 MA Consolidated Edison Sol Inc 25 2014 Energy Retail Power Marketer 1011360 1280721 2292081 139421 7195 146616
418 4191 PA Consolidated Edison Sol Inc 42 2014 Energy Retail Power Marketer 617176 823363 1440539 49070 4684 53754
421 4226 NY Consolidated Edison Co-NY Inc 36 2014 Delivery Investor Owned 3698256 29809716 36546104 733909 156644 891230 2194 0 2194 0 21 19 0.111 0.107 FALSE 1300000 9500 339 0 155.178 0 2.162
422 4226 NY Consolidated Edison Co-NY Inc 36 2014 Bundled Investor Owned 9869409 9783465 19756921 2135972 342181 2478248 2194 0 2194 0 21 19 0.111 0.107 FALSE 1300000 9500 339 0 155.178 0 2.162
426 4254 MI Consumers Energy Co 26 2014 Bundled Investor Owned 12593983 11045552 33253922 1574243 208616 1791366 1957 1957 1957 1957 376.6 168.4 1.102 0.914 TRUE 14.4 Y 386589 11 5.8 7.5 2
450 4432 GA Coweta-Fayette El Member Corp 13 2014 Bundled Cooperative 1092103 270951 1529602 70777 5874 76703 81 0 81 0 266.26 107.41 2.37 1.49 TRUE 25 N 0 75717 0
471 4624 TN Cumberland Elec Member Corp 47 2014 Bundled Cooperative 1514866 472434 2570957 79471 10325 89829 130 100 130 100 229 2.3 FALSE 91633 0 0 48 0 1.87 0 0.87
475 4675 MO Cuivre River Electric Coop Inc 29 2014 Bundled Cooperative 1005210 37381 1317032 59701 1119 61037 117 70 117 70 1.767 1.767 0.928 0 TRUE 24.9 Y 60559
489 4922 OH Dayton Power & Light Co 39 2014 Delivery Investor Owned 2518456 3902463 9990587 199312 33917 234475 490 490 127.55 108.9 0.964 0.923 TRUE 12 N 248125
490 4922 OH Dayton Power & Light Co 39 2014 Bundled Investor Owned 2811928 1117180 4015531 256675 23318 280477 490 490 127.55 108.9 0.964 0.923 TRUE 12 N 248125
497 5027 DE Delmarva Power 10 2014 Bundled Investor Owned 2673209 902845 3604764 243578 23741 267434 276 0 276 0 166 105 1.18 0.98 TRUE 69 Y 78 293663 1752 0 21.8 0 21.7
499 5027 MD Delmarva Power 24 2014 Bundled Investor Owned 1745573 451707 2207594 145753 15142 160993 180 0 180 0 163 127 1.93 1.81 TRUE 69 Y 100 707 0 13.3 0 13.2
501 5063 TX City of Denton - (TX) 48 2014 Bundled Municipal 565857 312394 1421056 44241 5753 50121 106 106 37 37 0.41 0.41 TRUE 69 Y 928 48668 8 0.1 0.1
502 5070 DE Delaware Electric Cooperative 10 2014 Bundled Cooperative 1060347 241351 1301698 78631 9395 88026 87 87 87 87 188 147.95 2.26 1.88 TRUE 12 Y 84933 1 0 0.4 0.4
503 5078 TX Denton County Elec Coop, Inc 48 2014 Bundled Cooperative 2945797 429337 4572801 167566 12169 181648 137 137 137 137 32.92 27.71 1.024 1.013 TRUE 7.2 Y 186086
506 5109 MI DTE Electric Company 26 2014 Bundled Investor Owned 14932840 16790364 41923906 1943880 198146 2142829 3599 10 3599 10 793 189 1.22 0.76 TRUE 13.2 Y 1627899 1217 20.7 7.4 16
511 5202 LA Dixie Electric Membership Corp 22 2014 Bundled Cooperative 1678147 142245 2127470 98457 6138 105137 146 146 146 146 3 3 2.87 2.87 FALSE 104946 0
521 5399 TN Duck River Elec Member Corp 47 2014 Bundled Cooperative 1075522 464814 1831464 61147 10816 71972 109 4 109 4 114.97 114.97 1.41 1.41 TRUE 25 N 0 414 0 29 0 0.53 0 0.53
522 5416 NC Duke Energy Carolinas, LLC 37 2014 Bundled Investor Owned 21232503 22869336 56750616 1624552 266710 1896136 2094 0 2094 0 606 138 1.3 0.94 TRUE 35 Y 1569804 275186 11 5.4 5.4 5.4
523 5416 SC Duke Energy Carolinas, LLC 45 2014 Bundled Investor Owned 6633843 5727023 21202789 464747 89598 555991 686 0 686 0 160 126 1 0.87 TRUE 35 Y 465823 83554 1 0.5 0.5 0.5
530 5487 PA Duquesne Light Co 42 2014 Delivery Investor Owned 1847331 5277900 10154450 219811 27649 248196 546 0 546 0 63 63 0.62 0.62 FALSE 590965
531 5487 PA Duquesne Light Co 42 2014 Bundled Investor Owned 2220685 1195638 3568054 307940 34679 343009 546 0 546 0 63 63 0.62 0.62 FALSE 590965
535 5574 MN East Central Energy 27 2014 Bundled Cooperative 520177 283812 905212 47780 5166 53098 110 0 110 0 91.7 71.7 1.096 1.015 TRUE 14.4 N 53200 1 0 0.15 0 0
550 5701 NM El Paso Electric Co 35 2014 Bundled Investor Owned 651515 910681 1640996 83132 11136 94276 59 30 59 30 52.972 52.972 0.903 0.903 TRUE 23.9 Y 100871
551 5701 TX El Paso Electric Co 48 2014 Bundled Investor Owned 1982610 3000832 5967962 269145 33552 302738 259 190 259 190 63.975 63.975 0.79 0.79 TRUE 23.9 Y 282249
566 5860 MO Empire District Electric Co 29 2014 Bundled Investor Owned 1741812 1561658 4148677 126168 23324 149769 251 0 251 0 150.76 127.92 1.413 1.366 TRUE 25 N
584 6022 OR City of Eugene - (OR) 41 2014 Bundled Municipal 919175 872330 2336296 80307 9449 89760 147 0 147 0 336.9 59.39 0.67 0.41 TRUE 12.5 Y 17 0 0 37 2.9 2.1
599 6182 TX Farmers Electric Coop, Inc - (TX) 48 2014 Bundled Cooperative 779025 148378 983989 45521 7146 52677 56 0 56 0 4.08 2.15 2.09 1.37 TRUE 24.9 Y 49583 2239
607 6235 NC Public Works Comm-City of Fayetteville 37 2014 Bundled Municipal 930569 797126 2087801 71675 17063 88760 165 0 165 0 74241 8726 0
613 6342 AR First Electric Coop Corp 5 2014 Bundled Cooperative 1260342 198780 1894997 83224 5536 90201 136 136 136 136 266.15 204.576 2.512 2.206 TRUE 25 Y 90188
619 6395 MT Flathead Electric Coop Inc 30 2014 Bundled Cooperative 721571 442584 1424137 52557 10229 62873 87 0 87 0 297.76 147.77 1.68 1.26 TRUE 24.9 Y 331 61912
620 6411 GA Flint Electric Membership Corp 13 2014 Bundled Cooperative 1172804 503998 1777953 71442 10203 82184 166 136 166 136 1.47 1.47 0.03 0.03 FALSE 80946
628 6452 FL Florida Power & Light Co 12 2014 Bundled Investor Owned 55224658 46172611 104431096 4169028 529349 4708793 3211 2869 3211 2869 69.4 69.4 0.82 0.82 TRUE 23 Y 1061 4792834 363 184 184 0
629 6455 FL Duke Energy Florida, Inc 12 2014 Bundled Investor Owned 19002681 14970106 37240099 1503757 193040 1699077 1249 1044 1249 1044 103.81 101.22 1.34 1.31 TRUE 25 Y 1606898 73141 2164 81.6 81.6 0 15.6
631 6458 IL First Energy Solutions Corp. 17 2014 Energy Retail Power Marketer 4492034 2221651 7003262 477853 25669 503593
635 6458 OH First Energy Solutions Corp. 39 2014 Energy Retail Power Marketer 13964059 18033550 41994756 1429876 161706 1592874
636 6458 PA First Energy Solutions Corp. 42 2014 Energy Retail Power Marketer 4702190 7310965 17647600 392359 37029 429993
641 6604 CO City of Fort Collins - (CO) 8 2014 Bundled Municipal 482398 498597 1433244 61016 8583 69615 77 0 77 0 26 26 0.37 0.37 FALSE 15 67910 2 5 1.8 1.8 0 0.3
675 6909 FL Gainesville Regional Utilities 12 2014 Bundled Municipal 772836 784616 1708818 83214 10629 93855 76 59 76 59 70 70 1.27 1.23 FALSE 135 13 4.1 4.1 3.5
684 6958 TX City of Garland - (TX) 48 2014 Bundled Municipal 934941 786709 1989584 62868 6387 69262 93 93 93 93 53 0.38 FALSE
688 7090 GA GreyStone Power Corporation 13 2014 Bundled Cooperative 1661068 624471 2722545 113228 8772 122062 135 0 135 0 4.376 1.54 1.56 1.17 TRUE 25 Y 126131
692 7140 GA Georgia Power Co 13 2014 Bundled Investor Owned 27132065 32894391 83740365 2092051 308831 2410042 2400 2000 2400 2000 244.75 102.76 1.56 1.2 TRUE 38 Y 2369325 632 80 146 47
715 7279 TX NextEra Energy Services, LLC 48 2014 Bundled Retail Power Marketer 1913391 7166024 9079415 115816 71659 187475
717 7294 CA City of Glendale - (CA) 6 2014 Bundled Municipal 378771 692718 1088667 72975 13019 86012 104 0 104 0 37 37 0.96 0.96 FALSE 0 86012 6 2.2 0.6 0.3
736 7554 NY Green Mountain Energy Company 36 2014 Energy Retail Power Marketer 222192 274526 496718 51708 2021 53729
738 7554 TX Green Mountain Energy Company 48 2014 Bundled Retail Power Marketer 3270075 3782815 7052890 283628 48809 332437
744 7601 VT Green Mountain Power Corp 50 2014 Bundled Investor Owned 1551471 1572378 4281682 219910 38953 258928 305 2 305 2 763 217 2.24 1.54 FALSE 2046 262559 258928 39 6.2 2.2
749 7639 NC Greenville Utilities Comm 37 2014 Bundled Municipal 721215 703220 1706381 57507 7353 65326 119 87 119 87 31 31 0.52 0.52 FALSE 65300 35
759 7752 TX Guadalupe Valley Elec Coop Inc 48 2014 Bundled Cooperative 1075618 396045 2332625 68197 6109 74418 149 149 149 149 1.33 0.36 1.39 0.33 TRUE 24.9 Y 64575 9690
762 7801 FL Gulf Power Co 12 2014 Bundled Investor Owned 5362423 3863384 11075062 386765 55346 442369 307 0 307 0 169 84 1.01 0.74 FALSE 0 433677 0
790 8287 HI Hawaii Electric Light Co Inc 15 2014 Bundled Investor Owned 386585 427538 1062521 70108 12914 83104 136 0 136 0 956 161 4.89 3.396 FALSE 13953 0 0 59 10.6 0.1 7.4
827 8773 CO Holy Cross Electric Assn, Inc 8 2014 Bundled Cooperative 604619 520825 1179789 45396 9803 55208 52 0 52 0 90 90 0 0 TRUE 24.9 N 9050 41 12 0 2.7 0 2
830 8786 SC Horry Electric Coop Inc 45 2014 Bundled Cooperative 896731 196556 1126196 61976 9710 71697 119 119 544.26 64.74 1.565 0.822 TRUE 25 Y 71697
849 9094 AL City of Huntsville - (AL) 1 2014 Bundled Municipal 2559875 2127737 5277748 153325 21166 174529 266 0 266 0 FALSE 0 0 0 31 0 0.62 0 0.62
850 9096 LA City of Lafayette - (LA) 22 2014 Bundled Municipal 840541 1186574 2027115 53882 11380 65262 84 0 84 0 61 61 0.97 0.97 FALSE 64839
856 9191 ID Idaho Power Co 16 2014 Bundled Investor Owned 4784073 3792971 13462077 411689 63729 493396 577 341 577 341 151.69 126.61 1.19 1.08 TRUE 34.5 Y 988 490070 0 34 13.2
859 9216 CA Imperial Irrigation District 6 2014 Bundled Political Subdivision 1741325 1564172 3392435 129973 20600 151410 321 0 321 0 65 43 1 1 TRUE 35 N 53286 18549 133 19 17
862 9231 MO City of Independence - (MO) 29 2014 Bundled Municipal 506410 459772 1016792 51499 5106 56616 67 67 68 49 0.701 0.586 FALSE 0 0 0
864 9273 IN Indianapolis Power & Light Co 18 2014 Bundled Investor Owned 5269008 1942701 13994070 424752 48309 477921 458 0 458 0 189.98 56.71 0.96 0.71 TRUE 13.2 Y 500311 17347 55 0 3.2 0 3.2
867 9324 IN Indiana Michigan Power Co 18 2014 Bundled Investor Owned 4556299 4150709 15516220 400453 53656 458140 596 9 596 9 305.9 127.5 0.963 0.771 TRUE 35 Y 451732 9893 5 0 1 0 0
868 9324 MI Indiana Michigan Power Co 26 2014 Bundled Investor Owned 1219481 804608 2854869 108929 17841 127734 141 0 141 0 1078.6 286.9 1.685 1.299 TRUE 35 Y 128543
870 9336 CO Intermountain Rural Elec Assn 8 2014 Bundled Cooperative 1403217 634719 2172005 133613 12092 145775 294 0 294 0 59 50 0.6 0.563 FALSE 145775
871 9417 IA Interstate Power and Light Co 19 2014 Bundled Investor Owned 3837912 3989842 14618822 409205 75949 486745 1504 0 1504 0 200 95 1.16 0.96 FALSE 5071 252 4.1 0.8
878 9575 KY Jackson Energy Coop Corp - (KY) 21 2014 Bundled Cooperative 708879 140224 916270 47723 3706 51435 113 0 113 0 506.15 178.74 2.144 1.66 TRUE 12.5 Y 51435 2 0 1.8 0
883 9601 GA Jackson Electric Member Corp - (GA) 13 2014 Bundled Cooperative 3003210 1476773 5201199 192993 20818 213997 218 218 218 218 68.95 62.6 0.981 0.884 TRUE 35 Y 210611 1 0 0.1 0 0.1
889 9617 FL JEA 12 2014 Bundled Municipal 5162233 3987033 11934412 383998 52849 437062 383 0 383 0 92 92 2 2 FALSE 381243 71258 0
905 9726 NJ Jersey Central Power & Lt Co 34 2014 Delivery Investor Owned 2071121 6737301 10855369 196263 46577 244119 1419 1419 1419 1419 170.34 125.91 1.23 1.15 TRUE 34.5 Y 1909 0 0
906 9726 NJ Jersey Central Power & Lt Co 34 2014 Bundled Investor Owned 7264641 2445207 9957517 776222 79185 856511 1419 1419 1419 1419 170.34 125.91 1.23 1.15 TRUE 34.5 Y 1909 0 0
910 9777 TN Johnson City - (TN) 47 2014 Bundled Municipal 1030607 765701 1949589 65903 10693 76617 128 128 128 128 34.1 28.7 0.513 0.486 TRUE 12.5 Y 9 75540 0 60 0 1.66 0 0.73
912 9837 NC Jones-Onslow Elec Member Corp 37 2014 Bundled Cooperative 930356 239463 1195272 67417 4159 71579 124 0 124 0 84 1.216 FALSE 67023
916 9949 MA Just Energy 25 2014 Energy Retail Power Marketer 478415 64423 542838 69553 2242 71795
918 9949 TX Just Energy 48 2014 Bundled Retail Power Marketer 2619839 555891 3175730 200205 22001 222206
919 9964 KY Kenergy Corp 21 2014 Bundled Cooperative 757715 325857 9670080 45311 10585 55932 191 0 191 0 126 98.54 1.7 1.61 TRUE 14.4 Y
921 9996 KS City of Kansas City - (KS) 20 2014 Bundled Municipal 564170 1049883 2174399 57104 7058 64252 142 142 382.964 266.177 3.02 2.575 TRUE 15 Y 7 63929
923 10000 KS Kansas City Power & Light Co 20 2014 Bundled Investor Owned 2822640 3229962 6365343 218084 28130 247193 328 0 328 0 113.06 75.33 0.857 0.721 TRUE 34 Y 23355 205679 0 15 0.6 0.9 0 0.1
924 10000 MO Kansas City Power & Light Co 29 2014 Bundled Investor Owned 2571510 4454312 8554331 240967 31537 273512 452 11 452 11 156.12 96.95 1.158 0.945 TRUE 34 Y 248764 22716 55 72 0 1 0 1
925 10005 KS Kansas Gas & Electric Co 20 2014 Bundled Investor Owned 3146186 3153623 9814230 281983 36020 321501 507 507 105.72 99.52 1.14 1.101 TRUE 34 N 21457 55039 55039
939 10171 KY Kentucky Utilities Co 21 2014 Bundled Investor Owned 6334638 5483135 18888411 421974 88797 513697 1117 0 1117 0 193.99 100.46 1.367 1.007 TRUE 34.5 Y 26483 0 0
952 10376 FL Kissimmee Utility Authority 12 2014 Bundled Municipal 741059 461483 1377596 56781 9396 66246 66 36 66 36 52 52 0.98 0.98 FALSE 52463
955 10421 TN Knoxville Utilities Board 47 2014 Bundled Municipal 2506771 2279472 5536187 173700 24021 197759 268 0 268 0 3.38 1.57 1.51 1.14 TRUE 13 Y 6949 4259 0 86 0 2.42 0 2.42
978 10623 FL City of Lakeland - (FL) 12 2014 Bundled Municipal 1399962 827437 2904061 103003 20681 123768 118 110 118 110 69 69 1.293 1.293 FALSE 3 122458 0
991 10704 MI City of Lansing - (MI) 26 2014 Bundled Municipal 556185 1176771 2112554 83512 12722 96489 221 0 221 0 166 81 0.89 0.83 FALSE 0 140 0
995 10768 SC Laurens Electric Coop, Inc 45 2014 Bundled Cooperative 693520 195895 1024373 49501 5299 54827 120 0 120 0 104.27 72.4 0.95 0.82 TRUE 14.4 Y 45130 10000
1007 10857 FL Lee County Electric Coop, Inc 12 2014 Bundled Cooperative 2435778 1134496 3570274 186759 17264 204023 123 0 123 0 75 75 1.2 1.2 FALSE 208372
1010 10906 TN City of Lenoir - (TN) 47 2014 Bundled Municipal 839474 711656 1605224 50012 11335 61355 67 67 67 67 FALSE 61133 0 0 49 0 1.25 0 1.25
1021 11018 NE Lincoln Electric System 31 2014 Bundled Municipal 1193586 1526628 3219685 116273 16214 132673 162 162 162 162 26.9 21.6 0.39 0.33 TRUE 35 N 28911 0 0 1 0 0.5 0
1035 11171 NY Long Island Power Authority 36 2014 Bundled State 9389030 8344323 18053465 996453 116293 1112747 918 693 918 693 65.3 65.3 0.77 0.77 TRUE 13 Y 19559 7729 87 17.4 9.6
1040 11208 CA Los Angeles Department of Water & Power 6 2014 Bundled Municipal 8165544 13342552 23456101 1310678 88984 1409093 2273 1662 2273 1662 77.69 77.69 0.65 0.65 TRUE 34.5 N 372470 8585 0
1042 11241 LA Entergy Louisiana LLC 22 2014 Bundled Investor Owned 9047299 6757407 32904509 588800 83568 679462 1015 0 1015 0 FALSE 34.5 Y 7644 897 0
1044 11249 KY Louisville Gas & Electric Co 21 2014 Bundled Investor Owned 4157326 4885866 11817164 350587 47014 398041 670 0 670 0 160.92 75.04 1.181 0.917 TRUE 34.5 Y 30856 0 0
1052 11291 NC Lumbee River Elec Member Corp 37 2014 Bundled Cooperative 987865 150691 1247620 56648 2125 58787 119 0 119 0 151.312 89.174 1.299 1.121 TRUE 25 Y 58787 9 0 0.5 0 0.5
1053 11292 TX City of Lubbock - (TX) 48 2014 Bundled Municipal 983339 1453419 2548442 87652 14158 101818 152 152
1070 11479 WI Madison Gas & Electric Co 55 2014 Bundled Investor Owned 807265 2247641 3301173 124903 19699 144646 242 0 242 0 51.2 26.75 0.39 0.327 TRUE 13.8 Y 138470 6437 0 259 39.8 59.5 39.9 1.1
1073 11501 TX Magic Valley Electric Coop Inc 48 2014 Bundled Cooperative 1438330 211886 2105414 93530 17559 111755 118 0 118 0 68 67 TRUE 12.4 Y 111755
1098 11804 MA Massachusetts Electric Co 25 2014 Delivery Investor Owned 1358378 6192152 10281748 173131 38345 212996 1151 10 1151 10 143.63 96.83 1.12 0.964 TRUE 69 Y 1228329 15018 0 79 19.6 8.1
1099 11804 MA Massachusetts Electric Co 25 2014 Bundled Investor Owned 7180002 3013034 10602381 959140 116427 1078192 1151 10 1151 10 143.63 96.83 1.12 0.964 TRUE 69 Y 1228329 15018 0 79 19.6 8.1
1101 11824 AK Matanuska Electric Assn Inc 2 2014 Bundled Cooperative 448552 273691 722243 56055 3831 59886 68 2 68 2 242.1 189.7 1.77 1.28 TRUE 14.4 Y 35682 19920
1102 11843 HI Maui Electric Co Ltd 15 2014 Bundled Investor Owned 381979 373947 1132056 59609 10059 69804 146 104 146 104 188.39 103.7 2.567 1.545 FALSE 7272 30
1112 12199 ND Montana-Dakota Utilities Co 38 2014 Bundled Investor Owned 811250 1081889 2068166 75508 13535 89143 371 371 55.4 0.317 FALSE 89143
1123 12293 TN City of Memphis - (TN) 47 2014 Bundled Municipal 5221000 4647368 13765439 364624 43476 408411 487 2 487 2 386.4 200.4 1.84 1.61 TRUE 23 Y 236 1004 0
1130 12341 IA MidAmerican Energy Co 19 2014 Bundled Investor Owned 5705293 5040992 20585461 563119 91103 655770 984 984 156 96 1.24 1 TRUE 13.8 Y 655222 26 7.8 12.7 0.1 0.1
1131 12341 IL MidAmerican Energy Co 17 2014 Bundled Investor Owned 673070 622937 1974897 75812 9213 85124 115 115 243 94 1.22 0.93 TRUE 13.8 Y 84517 22 12.6 3.6
1144 12390 PA Metropolitan Edison Co 42 2014 Delivery Investor Owned 2039490 2154643 9502052 171958 28770 201524 783 666 783 666 480.16 134.92 1.51 1.12 TRUE 34.5 Y 4278 2 0
1145 12390 PA Metropolitan Edison Co 42 2014 Bundled Investor Owned 3437743 818258 4330275 318101 36879 355053 783 666 783 666 480.16 134.92 1.51 1.12 TRUE 34.5 Y 4278 2 0
1152 12462 SC Mid-Carolina Electric Coop Inc 45 2014 Bundled Cooperative 729496 259261 1025057 46927 6745 53680 82 82 82 82 53680
1154 12470 TN Middle Tennessee E M C 47 2014 Bundled Cooperative 3134733 1993358 5743330 174542 25892 200477 186 0 186 0 98.75 98.75 1.76 1.76 FALSE 0 7 0 118 0 4.45 0 4.44
1160 12524 KS Midwest Energy Inc 20 2014 Bundled Cooperative 319201 367259 1497022 30054 13165 50386 375 375 4.78 2.82 1.76 1.51 TRUE 34.5 Y
1171 12647 MN ALLETE, Inc. 27 2014 Bundled Investor Owned 1112579 1332101 9391216 121601 23038 145033 348 0 348 0 129.74 88.35 1.15 0.96 TRUE 69 N 108275 35236
1176 12685 MS Entergy Mississippi Inc 28 2014 Bundled Investor Owned 5672166 5235681 13204945 370464 67627 442111 734 0 734 0 FALSE 34.5 Y 6575 105
1177 12686 MS Mississippi Power Co 28 2014 Bundled Investor Owned 2136509 2905744 9960184 152589 33475 186545 271 0 271 0 84 56 1 1 FALSE 6576 21 0
1180 12698 MO KCP&L Greater Missouri Operations Co. 29 2014 Bundled Investor Owned 3576410 3259502 8195101 278361 39111 317720 517 0 517 0 179.87 143.11 1.566 1.397 TRUE 34 Y 460 0 0 103 0 1.3 0 1.2
1184 12745 CA Modesto Irrigation District 6 2014 Bundled Political Subdivision 868541 864032 2501526 95835 20663 116662 171 5 171 5 30.42 0.41 TRUE 21 N 116662 1 0 0.2 0.2
1187 12796 WV Monongahela Power Co 54 2014 Bundled Investor Owned 3814821 2840690 11426122 331924 49107 388542 503 490 503 490 574.63 331.47 2.03 1.79 TRUE 34.5 Y 26320
1192 12825 MT NorthWestern Energy LLC - (MT) 30 2014 Bundled Investor Owned 2398528 3120726 5974533 283165 67151 351970 612 8 612 8 112.87 112.87 1.076 1.076 TRUE 25 N 315700 18 5.6
1227 13119 TN City of Murfreesboro 47 2014 Bundled Municipal 734606 745161 1694729 48615 6683 55311 56 0 56 0 37.894 37.894 0.576 0.576 FALSE 55674 0 0 12 0 0.33 0 0.33
1236 13208 IL City of Naperville - (IL) 17 2014 Bundled Municipal 534716 795969 1399607 52411 6273 58693 116 0 116 0 15 15 0.22 0.22 FALSE 0 58762 52023
1239 13214 RI The Narragansett Electric Co 44 2014 Bundled Investor Owned 2852069 1901360 5006934 410974 48072 460505 409 0 409 0 54.21 54.21 0.762 0.762 TRUE 69 Y 480329 247 25 6.6 4.6
1240 13216 TN Nashville Electric Service 47 2014 Bundled Municipal 4905686 6131693 12081020 330681 41503 372249 516 0 516 0 102.11 82.18 1.76 1.65 FALSE 71812 80003 80003 227 0 5.09 0 5.09
1252 13337 NE Nebraska Public Power District 31 2014 Bundled Political Subdivision 895508 1211817 3353118 69784 19128 88968 102 11 102 11 174.13 74.8 0.89 0.82 TRUE 69 Y 12361 45415
1259 13374 IL Constellation NewEnergy, Inc 17 2014 Energy Retail Power Marketer 758201 5585152 9334952 80553 2106 82971
1260 13374 IL Constellation NewEnergy, Inc 17 2014 Energy Retail Power Marketer 758200 5585152 9947253 80553 2105 82970
1275 13407 NV Nevada Power Co 32 2014 Bundled Investor Owned 8922759 4638229 21109027 770167 102139 873898 968 0 968 0 36 32 0.44 0.39 TRUE 60 Y 351 878526
1283 13441 NH New Hampshire Elec Coop Inc 33 2014 Bundled Cooperative 462738 171219 652808 69254 9534 78794 208 208 208 208 20.57 7.09 4.57 3.29 FALSE N 23 83166 0
1288 13478 LA Entergy New Orleans Inc 22 2014 Bundled Investor Owned 1965927 2802820 5232742 151377 16353 169855 224 0 224 0 FALSE 34.5 Y 5375 4609 4609
1294 13511 NY New York State Elec & Gas Corp 36 2014 Bundled Investor Owned 5015098 1413210 6661926 583185 69443 653354 1264 0 1264 0 3.94 2.02 1.33 1.03 FALSE 1087
1295 13511 NY New York State Elec & Gas Corp 36 2014 Delivery Investor Owned 1718759 4201214 8632699 180404 48422 230203 1264 0 1264 0 3.94 2.02 1.33 1.03 FALSE 1087
1304 13573 NY Niagara Mohawk Power Corp. 36 2014 Delivery Investor Owned 2746542 9503774 21185820 306231 74452 381731 2094 928 2094 928 198 116 1.15 0.96 TRUE 69 Y 1882646 2997
1305 13573 NY Niagara Mohawk Power Corp. 36 2014 Bundled Investor Owned 8914956 3220135 13152596 1164691 94509 1259788 2094 928 2094 928 198 116 1.15 0.96 TRUE 69 Y 1882646 2997
1310 13640 VA Northern Virginia Elec Coop 51 2014 Bundled Cooperative 2130721 903386 4029218 145788 11945 157851 227 54 227 54 51.33 51.33 0.71 0.71 TRUE 34.5 Y 150227 123 0 6 0 4.5 0
1329 13716 GA North Georgia Elec Member Corp 13 2014 Bundled Cooperative 1494133 607788 2511849 83769 14446 98251 142 142 142 142 230.7 150.3 FALSE 0 97183 0 48 0 4.65 0 3.02
1338 13756 IN Northern Indiana Pub Serv Co 18 2014 Bundled Investor Owned 3384222 3991852 17510802 403272 55385 461010 128 128 FALSE N 11530
1345 13780 WI Northern States Power Co 55 2014 Bundled Investor Owned 1925799 2889729 6607279 206309 38625 245042 367 367 193 121 1 1 TRUE 34.5 Y 236646
1346 13781 MN Northern States Power Co - Minnesota 27 2014 Bundled Investor Owned 8784578 13764808 30752653 1113587 136109 1250135 1026 451 1026 451 115 82 1 1 TRUE 34.5 Y 1205083
1347 13781 ND Northern States Power Co - Minnesota 38 2014 Bundled Investor Owned 818018 1147525 2300601 78596 12733 91349 58 27 58 27 82 82 1 1 TRUE 34.5 Y 89211
1348 13781 SD Northern States Power Co - Minnesota 46 2014 Bundled Investor Owned 714040 997932 2056587 76454 11424 87898 79 54 79 54 148 140 1 1 TRUE 34.5 Y 84233
1355 13809 SD NorthWestern Energy - (SD) 46 2014 Bundled Investor Owned 582064 711070 1579926 49590 12681 62330 254 0 254 0 90 82 1 1 TRUE 25 N
1369 13955 FL City of Ocala 12 2014 Bundled Municipal 490711 200653 1220551 40160 14427 55557 74 0 74 0 FALSE 12.4 Y 0 50998
1374 13998 OH Ohio Edison Co 39 2014 Delivery Investor Owned 6713241 5888693 19889281 668538 88580 758143 1049 1049 1049 1049 116.19 95.07 1.07 0.98 TRUE 34.5 Y 1137 11 0
1375 13998 OH Ohio Edison Co 39 2014 Bundled Investor Owned 2639838 939334 5038011 251214 25422 276953 1049 1049 1049 1049 116.19 95.07 1.07 0.98 TRUE 34.5 Y 1137 11 0
1376 14006 OH Ohio Power Co 39 2014 Delivery Investor Owned 4430148 12014273 28106374 379032 85538 469638 1656 17 1656 17 213.4 191.5 1.341 1.268 TRUE 35 Y 494493 134988 3826 10 0 0.4 0.2 0.2
1377 14006 OH Ohio Power Co 39 2014 Bundled Investor Owned 10206657 2508302 15593920 896991 92224 994245 1656 17 1656 17 213.4 191.5 1.341 1.268 TRUE 35 Y 494493 134988 3826 10 0 0.4 0.2 0.2
1381 14062 OK Oklahoma Electric Coop Inc 40 2014 Bundled Cooperative 756243 247925 1140514 47701 4271 52023 75 0 75 0 75.3 75.3 1.44 1.44 TRUE 14.4 Y 52023
1382 14063 AR Oklahoma Gas & Electric Co 5 2014 Bundled Investor Owned 738882 882348 2693596 54841 10499 65732 131 14 131 14 361 160 1.59 1.17 FALSE 68149
1383 14063 OK Oklahoma Gas & Electric Co 40 2014 Bundled Investor Owned 8652606 9472917 24307160 639163 97326 745456 1079 254 1079 254 108 103 0.888 0.876 FALSE 1 773869
1388 14127 NE Omaha Public Power District 31 2014 Bundled Political Subdivision 3561537 3640059 10659655 315705 44785 360667 480 24 480 24 142 80 1.052 0.822 FALSE 355750 488 0 1 0.7
1391 14154 NY Orange & Rockland Utils Inc 36 2014 Delivery Investor Owned 748498 1416724 2515633 78179 14381 92615 207 0 207 0 171.757 103.01 1.191 1.075 FALSE 91277
1392 14154 NY Orange & Rockland Utils Inc 36 2014 Bundled Investor Owned 877435 524143 1467457 117671 16848 134561 207 0 207 0 171.757 103.01 1.191 1.075 FALSE 91277
1409 14232 MN Otter Tail Power Co 27 2014 Bundled Investor Owned 599034 360966 2327987 48613 11418 60809 289 289 63.93 0 1.24 0 TRUE 12.5 Y 125 0 0
1410 14232 ND Otter Tail Power Co 38 2014 Bundled Investor Owned 669563 369236 1938747 45379 11790 58116 347 347 32
1415 14251 KY Owen Electric Coop Inc 21 2014 Bundled Cooperative 748500 241464 2263319 56186 2630 58840 121 121 121 121 152 105 1.46 1.05 TRUE 12.5 Y 58777
1420 14289 AR Ozarks Electric Coop Corp - (AR) 5 2014 Bundled Cooperative 732380 304461 1122609 54237 3787 58035 89 0 89 0 97.2 66 1.1 0.82 TRUE 24.9 Y 58035
1423 14328 CA Pacific Gas & Electric Co 6 2014 Bundled Investor Owned 29289082 28107971 75114523 4560446 539245 5188308 3247 0 3247 0 117.8 96.5 1.068 0.966 TRUE 35 Y 0 5070987 0 464 0.5 93.5 33.4
1424 14328 CA Pacific Gas & Electric Co 6 2014 Delivery Investor Owned 626807 5198721 11756985 118729 31868 150956 3247 0 3247 0 117.8 96.5 1.068 0.966 TRUE 35 Y 0 5070987 0 464 0.5 93.5 33.4
1427 14354 ID PacifiCorp 16 2014 Bundled Investor Owned 665344 457510 3495174 59974 8363 73872 171 0 171 0 281.426 223.012 1.865 1.703 TRUE 34.5 Y 26322
1428 14354 OR PacifiCorp 41 2014 Bundled Investor Owned 5309295 5109334 12958735 485307 67309 562049 523 0 523 0 259.451 132.439 1.62 1.191 TRUE 34.5 Y 89484
1430 14354 UT PacifiCorp 49 2014 Bundled Investor Owned 6605139 8564346 24105301 745363 81824 835233 1052 0 1052 0 209.947 169.664 1.451 1.28 TRUE 34.5 Y 814191
1431 14354 WA PacifiCorp 53 2014 Bundled Investor Owned 1594743 1548056 4117647 106503 15997 128139 120 0 120 0 148.572 124.589 0.874 0.806 TRUE 34.5 Y 124728
1432 14354 WY PacifiCorp 56 2014 Bundled Investor Owned 1041412 1503050 9568272 112972 23129 138867 240 0 240 0 218.986 192.95 1.6 1.555 TRUE 34.5 Y 134728
1436 14398 SC Palmetto Electric Coop Inc 45 2014 Bundled Cooperative 922541 474028 1492839 58358 10214 68597 128 128 128 128 112.768 45.738 0.946 0.773 TRUE 35 Y 68597 7 0 3.2 0
1447 14534 CA City of Pasadena - (CA) 6 2014 Bundled Municipal 329320 787239 1126121 54723 8446 63170 112 0 112 0 13.1 13.1 0.142 0.142 TRUE 17 Y 63346
1458 14610 FL Orlando Utilities Comm 12 2014 Bundled Municipal 2257492 3948894 6206386 191436 29192 220628 284 284 284 284 60 51 0.9 0.78 FALSE 229500 145 1 0.4 0.4
1460 14626 TX Pedernales Electric Coop, Inc 48 2014 Bundled Cooperative 3704491 602321 5338808 234264 21483 256744 258 0 258 0 68 39 0.66 0.56 FALSE 256744
1467 14711 PA Pennsylvania Electric Co 42 2014 Bundled Investor Owned 2689068 1069851 3964554 319991 46641 366733 1242 907 1242 907 193.71 158.1 1.63 1.52 TRUE 34.5 Y 3139 1 0
1468 14711 PA Pennsylvania Electric Co 42 2014 Delivery Investor Owned 1740206 2539682 9717976 180323 37049 218120 1242 907 1242 907 193.71 158.1 1.63 1.52 TRUE 34.5 Y 3139 1 0
1470 14715 PA PPL Electric Utilities Corp 42 2014 Delivery Investor Owned 7351717 12621463 28226904 557825 89828 650525 1212 1212 168 92 0.9 0.8 TRUE 12 N 0 1414297 0
1471 14715 PA PPL Electric Utilities Corp 42 2014 Bundled Investor Owned 7089771 1574767 8791728 676504 85868 763772 1212 1212 168 92 0.9 0.8 TRUE 12 N 0 1414297 0
1472 14716 PA Pennsylvania Power Co 42 2014 Delivery Investor Owned 658963 893745 3113945 50675 7655 58461 178 178 178 178 117.92 109.76 1.12 1.1 TRUE 23 Y 238 0 0
1473 14716 PA Pennsylvania Power Co 42 2014 Bundled Investor Owned 1069386 493839 1600543 91070 12611 103702 178 178 178 178 117.92 109.76 1.12 1.1 TRUE 23 Y 238 0 0
1483 14940 PA PECO Energy Co 42 2014 Delivery Investor Owned 4724247 6012980 26288589 459413 78915 541134 2276 2276 880 73 1.53 0.8 TRUE 34 Y 100338 1544070 2
1484 14940 PA PECO Energy Co 42 2014 Bundled Investor Owned 8577010 2270505 11394476 969937 80013 1050255 2276 2276 880 73 1.53 0.8 TRUE 34 Y 100338 1544070 2
1512 15248 OR Portland General Electric Co 41 2014 Bundled Investor Owned 7461863 6849512 17603187 735502 101924 840668 617 3 617 3 245 93 1.2 0.69 TRUE 35 Y 840668 587 30.4
1514 15263 MD The Potomac Edison Company 24 2014 Bundled Investor Owned 2810166 669012 3701189 192527 18996 213076 347 347 347 347 702.03 160.4 1.66 1.12 TRUE 34.5 Y 8045
1516 15263 WV The Potomac Edison Company 54 2014 Bundled Investor Owned 1899961 878523 3597953 118283 17227 137482 171 171 171 171 493.45 206.75 1.87 1.38 TRUE 34.5 Y 6666
1517 15270 DC Potomac Electric Power Co 11 2014 Bundled Investor Owned 1733437 1282327 3015764 205519 17600 223119 781 0 781 0 96 82 0.69 0.64 TRUE 34 Y 2103 277998 1509 0 10.4 0 10
1519 15270 MD Potomac Electric Power Co 24 2014 Bundled Investor Owned 4293846 1675381 6010132 369892 26801 396697 704 0 704 0 170 99 1.5 1.19 TRUE 34 Y 1028 555443 2665 0 23.7 0 23.7
1520 15270 MD Potomac Electric Power Co 24 2014 Delivery Investor Owned 1488509 6488847 8548064 121256 21109 142375 704 0 704 0 170 99 1.5 1.19 TRUE 34 Y 1028 555443 2665 0 23.7 0 23.7
1544 15466 CO Public Service Co of Colorado 8 2014 Bundled Investor Owned 9008526 12886370 28671219 1195260 210496 1406090 773 6 773 6 89 85 1 1 TRUE 34.5 N 1153857 19486
1545 15470 IN Duke Energy Indiana Inc 18 2014 Bundled Investor Owned 9245016 8349697 28224148 693006 101866 797580 1203 1203 185.66 140.16 1.31 1.16 TRUE 34.5 N 23525 25 2.4 11.2 0
1546 15472 NH Public Service Co of NH 33 2014 Bundled Investor Owned 2390026 1240068 3799020 335555 50387 387774 457 0 457 0 873.23 122.84 1.86 1.25 TRUE 34.5 N 178724 48 0.8 21.8 0 0
1547 15472 NH Public Service Co of NH 33 2014 Delivery Investor Owned 782431 2091818 4087034 91554 23602 116225 457 0 457 0 873.23 122.84 1.86 1.25 TRUE 34.5 N 178724 48 0.8 21.8 0 0
1548 15473 NM Public Service Co of NM 35 2014 Bundled Investor Owned 3169071 4125480 9037310 454396 56587 511235 533 269 533 269 65.39 65.39 0.74 0.74 TRUE 46 Y
1549 15474 OK Public Service Co of Oklahoma 40 2014 Bundled Investor Owned 6320906 6389387 17947669 465014 69698 541107 757 13 757 13 97 84.2 0.963 0.945 TRUE 35 Y 178458 59521 938
1550 15477 NJ Public Service Elec & Gas Co 34 2014 Bundled Investor Owned 11374261 7430854 19571938 1664998 229257 1900444 2829 2829 80.48 44.45 0.76 0.65 TRUE 69 Y 13092 0 174309 38.4 38.4
1551 15477 NJ Public Service Elec & Gas Co 34 2014 Delivery Investor Owned 1706505 16020601 21174764 224314 73636 300633 2829 2829 80.48 44.45 0.76 0.65 TRUE 69 Y 13092 0 174309 38.4 38.4
1552 15500 WA Puget Sound Energy Inc 53 2014 Bundled Investor Owned 10349927 8988442 20568948 960708 127346 1091492 1094 12 1094 12 540 153 1.84 0.96 TRUE 35 Y 1117564 3939 0 15 0 5.5 0 0.5
1574 15847 TX Reliant Energy Retail Services 48 2014 Bundled Retail Power Marketer 17366667 4243521 38670246 1255152 91620 1348834
1585 16088 CA City of Riverside - (CA) 6 2014 Bundled Municipal 718970 457823 2184633 96878 10682 108450 127 127 127 127 76.42 37.49 0.86 0.66 TRUE 12 N 84467 6 1.1 0.1 0.2
1591 16181 MN Rochester Public Utilities 27 2014 Bundled Municipal 341452 652612 1206361 45826 4744 50572 78 44 78 44 103.6 30.82 1.14 0.72 TRUE 13.8 Y 50570
1592 16183 NY Rochester Gas & Electric Corp 36 2014 Bundled Investor Owned 1946739 611565 2620139 253092 21250 274635 576 0 576 0 1.96 1.32 0.85 0.76 FALSE 689
1593 16183 NY Rochester Gas & Electric Corp 36 2014 Delivery Investor Owned 706317 2564388 4510046 78275 18759 97602 576 0 576 0 1.96 1.32 0.85 0.76 FALSE 689
1598 16213 NJ Rockland Electric Co 34 2014 Bundled Investor Owned 625331 297411 941542 57101 7597 64727 83 0 83 0 129.837 101.69 0.935 0.913 FALSE 20046
1607 16295 CA City of Roseville - (CA) 6 2014 Bundled Municipal 440146 451572 1194138 49372 6619 56023 99 0 99 0 8 8 0.095 0.095 FALSE 22153 0
1618 16496 NC Rutherford Elec Member Corp 37 2014 Bundled Cooperative 912441 144150 1245785 62887 5018 67948 197 0 197 0 48.55 43.5 0.616 0.56 TRUE 15 Y 0 67948
1621 16534 CA Sacramento Municipal Util Dist 6 2014 Bundled Political Subdivision 4642956 3875915 10497960 542930 66718 612205 678 118 678 118 54 54 1 1 FALSE 613735 9521 25 5.6 2 2.5
1627 16572 AZ Salt River Project 4 2014 Bundled Political Subdivision 12293633 11099759 27548529 903484 98273 1001809 1374 0 1374 0 61.99 40.43 0.74 0.62 TRUE 21.6 N 3 876308 71 5.48 22.1 1.16 16.57
1630 16604 TX City of San Antonio - (TX) 48 2014 Bundled Municipal 9525212 10851552 21297396 679455 82877 762395 580 0 580 0 124.95 47.545 1.18 0.734 TRUE 35 N 452071 64076 64076
1632 16609 CA San Diego Gas & Electric Co 6 2014 Bundled Investor Owned 7338332 6975252 16467768 1256446 150700 1407604 1027 599 1027 599 75.81 64.6 0.632 0.603 TRUE 12.5 Y 393 1408733 14 2.5
1636 16613 TX Sam Houston Electric Coop Inc 48 2014 Bundled Cooperative 928593 122605 1313371 65107 5428 70714 122 122 243 146 TRUE 34.5 N 70714
1644 16655 CA City of Santa Clara - (CA) 6 2014 Bundled Municipal 230930 93603 3052051 44758 6218 52712 147 0 147 0 56.6 0 0.48 0 FALSE 8955
1645 16674 GA Satilla Rural Elec Member Corporation 13 2014 Bundled Cooperative 750495 118620 1115921 49349 4766 54135 82 0 82 0 54115
1677 16865 GA Sawnee Electric Membership Corporation 13 2014 Bundled Cooperative 2175189 843345 3281022 143789 16995 160879 202 146 202 146 47.28 44.68 0.74 0.72 TRUE 24.9 Y 1 160798
1678 16868 WA City of Seattle - (WA) 53 2014 Bundled Municipal 2995912 5234632 9340586 374620 40223 415056 233 0 233 0 147.6 69.1 1.48 0.89 TRUE 26.4 N 771
1685 16949 TN Sevier County Electric System 47 2014 Bundled Municipal 527391 891041 1478195 35027 20428 55462 77 0 77 0 272 139 1.7 1.52 FALSE 0 55067 0 22 0 0.18 0 0.18
1700 17066 VA Shenandoah Valley Elec Coop 51 2014 Bundled Cooperative 1137453 590657 2413648 72868 17649 90578 132 1 132 1 5 3 1.81 1.49 TRUE 69 N 87183
1705 17166 NV Sierra Pacific Power Co 32 2014 Bundled Investor Owned 2268295 2959866 8097075 284301 46292 330706 432 0 432 0 181 143 1.37 1.24 TRUE 60 Y 245 332845 0 2 1
1709 17252 MS Singing River Elec Pwr Assn 28 2014 Bundled Cooperative 983123 342286 1419464 63218 8496 71725 165 165 150.16 150.16 TRUE 25 N 71725 1 0 0
1724 17470 WA PUD 1 of Snohomish County 53 2014 Bundled Political Subdivision 3502768 2409958 6477971 301639 30781 332496 358 277 358 277 119 119 1.17 1.17 FALSE 3968
1728 17539 SC South Carolina Electric&Gas Company 45 2014 Bundled Investor Owned 8155692 7985229 22374515 587870 96048 684671 762 0 762 0 911.51 97.33 2.45 1.44 TRUE 23.9 Y 675789 9936 0
1730 17543 SC South Carolina Public Service Authority 45 2014 Bundled State 1801075 2057457 11201955 142663 28904 171595 275 275 275 275 248.612 17.864 0.86 0.313 TRUE 34 Y 106328 33 3 1.6 1.6 1.6
1742 17561 TX South Plains Electric Coop Inc 48 2014 Bundled Cooperative 487447 432818 1580460 35973 8162 51879 162 144 162 144 51879 27 0.4
1744 17564 KY South Kentucky Rural E C C 21 2014 Bundled Cooperative 836289 84358 1308085 60376 5275 66220 128 0 128 0 208.32 192.57 3.246 2.605 TRUE 25 Y 0 66220
1755 17609 CA Southern California Edison Co 6 2014 Bundled Investor Owned 29972416 37903351 75828585 4352025 580197 4963983 4552 7 4552 7 112.003 92.196 0.962 0.86 TRUE 33 N 21773 5009351 1356 318 0 104.2 0 42.2
1759 17633 IN Southern Indiana Gas & Elec Co 18 2014 Bundled Investor Owned 1455292 1329569 5589459 128525 18529 147171 253 2 253 2 314 67 1.46 0.92 FALSE
1761 17637 MD Southern Maryland Elec Coop Inc 24 2014 Bundled Cooperative 2115327 1326812 3442139 140259 15228 155487 242 0 242 0 2 1 1.03 0.97 FALSE 83115
1765 17647 MS Southern Pine Elec Power Assn 28 2014 Bundled Cooperative 907445 329701 2056052 60927 5200 66174 130 0 130 0 289 193 FALSE N 65613
1772 17684 LA Southwest Louisiana E M C 22 2014 Bundled Cooperative 1726095 498101 2430786 95766 8126 103913 158 158 158 158 3 3 2 2 FALSE 103526 0
1777 17698 AR Southwestern Electric Power Co 5 2014 Bundled Investor Owned 1121436 1354356 4018839 97253 17554 115414 139 0 139 0 307.9 104.6 1.368 0.852 TRUE 35 Y 50290 0 0
1778 17698 LA Southwestern Electric Power Co 22 2014 Bundled Investor Owned 2991457 2446268 6471793 201885 25301 229239 318 0 318 0 707.1 274.2 3.013 2.247 TRUE 35 Y 83796 0 0
1779 17698 TX Southwestern Electric Power Co 48 2014 Bundled Investor Owned 2198241 2276207 7798065 147734 30449 182584 281 0 281 0 507.8 213.9 2.631 1.9 TRUE 35 Y 143119 0 0
1781 17710 IL Spark Energy, LP 17 2014 Energy Retail Power Marketer 333676 333676 667352 51849 1001 52850
1792 17718 NM Southwestern Public Service Co 35 2014 Bundled Investor Owned 1127323 1655334 5014741 93828 24160 118051 174 174 82 79 1 1 TRUE 34.5 Y 789 16
1793 17718 TX Southwestern Public Service Co 48 2014 Bundled Investor Owned 2421204 3641780 14092829 208392 58290 266833 474 474 114 80 1 1 TRUE 34.5 Y 304 34
1798 17828 IL City of Springfield - (IL) 17 2014 Bundled Municipal 664486 1071342 1735828 58947 11312 70259 114 114 114 114 75 0.791 FALSE 53236
1800 17832 GA Snapping Shoals El Member Corp 13 2014 Bundled Cooperative 1453645 262885 1918506 90036 4007 94084 98 93 98 93 100.12 66.321 1.354 1.059 TRUE 25 Y 0 94084
1801 17833 MO City Utilities of Springfield - (MO) 29 2014 Bundled Municipal 1035121 1568359 3032465 97258 14280 111819 157 0 157 0 32.124 0 0.257 0 TRUE 13.2 N 7823 1327 0
1820 18085 OH South Central Power Company 39 2014 Bundled Cooperative 1488666 403719 2356991 107410 8997 116512 205 0 205 0 378.908 330.816 2.732 TRUE 7.2 N 115933
1852 18280 AZ Sulphur Springs Valley E C Inc 4 2014 Bundled Cooperative 337035 408295 793046 41113 9793 50911 83 0 83 0 21705 29201 6 4 5.2 1.2 1.2
1853 18304 FL Sumter Electric Coop, Inc 12 2014 Bundled Cooperative 2049075 198805 2982645 172101 15764 189058 186 0 186 0 70 70 1.39 1.39 FALSE 0 4322
1868 18429 WA City of Tacoma - (WA) 53 2014 Bundled Municipal 1854170 346245 4723634 153541 16251 172531 178 13 178 13 50 50 1 1 FALSE 482 17263 0
1870 18445 FL City of Tallahassee - (FL) 12 2014 Bundled Municipal 1089483 1548212 2637695 97985 18723 116708 254 0 254 0 141 0 1.885 0 FALSE 0 115229 0
1874 18449 FL Talquin Electric Coop, Inc 12 2014 Bundled Cooperative 688932 167717 965142 48947 3942 52893 89 0 89 0 396 353 4.13 3.93 TRUE 25 Y 0 52362
1875 18454 FL Tampa Electric Co 12 2014 Bundled Investor Owned 8655850 7969103 18525739 623846 80742 706160 769 769 769 769 99.51 99.51 1.5 1.5 TRUE 15 Y 649862 0
1906 18976 TX Trinity Valley Elec Coop Inc 48 2014 Bundled Cooperative 1008998 156756 1235418 60122 4180 64308 109 0 109 0 262.55 191.28 2.36 2.09 TRUE 14.4 Y 56716
1909 18997 OH The Toledo Edison Co 39 2014 Bundled Investor Owned 699079 309766 2464641 71962 8325 80359 248 239 248 239 112.36 55.52 0.74 0.58 TRUE 12.5 Y 931 0 0
1910 18997 OH The Toledo Edison Co 39 2014 Delivery Investor Owned 1838547 1742990 8079244 198539 28519 227494 248 239 248 239 112.36 55.52 0.74 0.58 TRUE 12.5 Y 931 0 0
1940 19126 TX TriEagle Energy, L.P. 48 2014 Bundled Retail Power Marketer 617940 532129 1150069 49289 5724 55013
1957 19159 TX Tri-County Electric Coop, Inc 48 2014 Bundled Cooperative 1638891 509697 2645810 84196 11805 97478 129 0 129 0 46.28 46.28 0.4 0.4 TRUE 24.9 Y 97478 0 0
1976 19281 CA Turlock Irrigation District 6 2014 Bundled Political Subdivision 721094 259732 2016138 72711 23927 100989 107 0 107 0 84 81 0.84 0.78 FALSE 77003
1982 19327 TX TXU Energy Retail Co LP 48 2014 Bundled Retail Power Marketer 21961271 5876380 38377869 1474934 175608 1672257
1984 19390 PA UGI Utilities, Inc 42 2014 Bundled Investor Owned 542590 178199 742542 54337 6859 61291 45 0 45 0 466 63 0.72 0.44 TRUE 13.8 Y 59488 0 0
1989 19435 NC Union Electric Membership Corp - (NC) 37 2014 Bundled Cooperative 1071418 184727 1256145 69203 1707 70910 132 132 104.6 51.8 1.08 0.6 TRUE 12.5 Y 257 70653
1990 19436 MO Union Electric Co - (MO) 29 2014 Bundled Investor Owned 13649267 14751404 37022540 1041094 154624 1200003 2200 300 2200 300 133 89 0.97 0.81 TRUE 69 Y 1191816 109 11.1 20.9 0.1 1.7
1993 19446 KY Duke Energy Kentucky 21 2014 Bundled Investor Owned 1479517 1760440 4062378 122287 15209 137869 132 132 128.86 116.38 1.08 1.02 TRUE 12.5 N 6977 38255
1995 19490 TX United Electric Coop Service Inc - (TX) 48 2014 Bundled Cooperative 1135580 500635 2192626 66782 11862 78708 180 180 57.34 57.34 0.71 0.71 TRUE 25 Y 78708
1997 19497 CT United Illuminating Co 9 2014 Delivery Investor Owned 1019248 2101051 3555981 121697 16116 138617 347 0 347 0 62 62 0.65 0.65 FALSE 179711 159795
1998 19497 CT United Illuminating Co 9 2014 Bundled Investor Owned 1179978 547455 1771412 161723 14574 176639 347 0 347 0 62 62 0.65 0.65 FALSE 179711 159795
1999 19499 CO United Power, Inc 8 2014 Bundled Cooperative 666977 539344 1645719 63800 9683 74146 127 127 12168 32839
2003 19545 SD Black Hills Power Inc 46 2014 Bundled Investor Owned 520087 772211 1507129 54430 13734 68186 139 0 139 0 84.03 74.63 1 0.092 TRUE 35 66354
2005 19547 HI Hawaiian Electric Co Inc 15 2014 Bundled Investor Owned 1611149 2270495 6781665 266923 33430 300723 416 167 416 167 108 108 1.487 1.487 FALSE 11167 0 1096 74 73.9
2008 19578 MI Upper Peninsula Power Co 26 2014 Bundled Investor Owned 269719 205667 773536 46190 5726 51925 97 97 281 248 1.85 1.78 TRUE 50 Y 44
2016 19728 AZ UNS Electric, Inc 4 2014 Bundled Investor Owned 815941 612062 1677447 82107 11286 93411 109 0 109 0 156.854 99.601 1.312 0.441 TRUE 69 Y 63197 169 0
2032 19876 NC Virginia Electric & Power Co 37 2014 Bundled Investor Owned 1628625 962870 4446761 101326 17852 119230 99 0 99 0 185 123 1.455 1.239 FALSE 111840
2033 19876 VA Virginia Electric & Power Co 51 2014 Bundled Investor Owned 29406355 39038242 75562974 2128313 252419 2381312 1622 0 1622 0 152 112 1.319 1.154 FALSE 1991164 296540 0 4 0 1.4 1.4 1.4
2037 19898 TN Volunteer Electric Coop 47 2014 Bundled Cooperative 1454685 646022 2336258 94375 18622 113012 114 0 114 0 FALSE 112472 0 0 133 0 2.29 0 2.29
2046 20065 GA Walton Electric Member Corp 13 2014 Bundled Cooperative 1766715 544941 2515059 112560 9471 122080 85 0 85 0 2.335 1.484 1.726 1.34 TRUE 25 N 122080
2049 20130 KY Warren Rural Elec Coop Corp 21 2014 Bundled Cooperative 880943 293918 1926983 51452 10455 61959 134 0 134 0 135 101.85 1.81 1.54 TRUE 7.2 Y 52113 1947 0 59 0 4.05 0 3.03
2061 20169 ID Avista Corp 16 2014 Bundled Investor Owned 1188464 1029305 3083614 108563 17107 126125 119 4 119 4 129036
2063 20169 WA Avista Corp 53 2014 Bundled Investor Owned 2505175 2197187 5704529 215617 24494 241041 220 74 220 74 66826
2088 20387 PA West Penn Power Company 42 2014 Bundled Investor Owned 4910816 1581016 7360535 432145 55683 495073 836 836 836 836 146.49 137.14 1.07 1.03 TRUE 25 Y 20082 21857
2089 20387 PA West Penn Power Company 42 2014 Delivery Investor Owned 2370473 3422752 12896661 188875 30361 224871 836 836 836 836 146.49 137.14 1.07 1.03 TRUE 25 Y 20082 21857
2098 20455 MA Western Massachusetts Electric Company 25 2014 Bundled Investor Owned 1273017 452114 1825087 169704 17946 188299 226 0 226 0 267.52 112.93 1.31 1.09 TRUE 22.9 Y 215608 34 5.9 0.6
2115 20659 MD WGL Energy Services, Inc. 24 2014 Energy Retail Power Marketer 1077458 6124751 7202209 88207 31959 120166
2131 20847 WI Wisconsin Electric Power Co 55 2014 Bundled Investor Owned 7778541 8832104 23909329 988035 114371 1103081 1694 0 1694 0 123 52 0.67 0.5 TRUE 34.9 N 1079535 30109 0 129 0 2 0 1.5
2132 20856 WI Wisconsin Power & Light Co 55 2014 Bundled Investor Owned 3533105 2424249 10646058 403918 58942 463862 1005 332 1005 332 102 54 0.66 0.54 FALSE 65 426548 137 11.8 1.5
2134 20860 WI Wisconsin Public Service Corp 55 2014 Bundled Investor Owned 2794703 3945316 10557757 383153 54696 438062 175 175 265 141 1.26 1.02 TRUE 50 Y 441630
2136 20885 FL Withlacoochee River Elec Coop 12 2014 Bundled Cooperative 2575081 947257 3685143 184269 20059 204366 186 0 186 0 126.27 117.96 1.71 1.7 TRUE 25 Y 203951 17 11.3
2160 21244 VA Southside Electric Coop, Inc 51 2014 Bundled Cooperative 752646 104479 938569 52949 2169 55130 126 0 126 0 211 183 1.89 1.79 TRUE 25 Y 55130
2165 21567 LA Washington-St Tammany E C, Inc 22 2014 Bundled Cooperative 804716 209951 1037005 46424 4241 50669 102 102 312.171 312.171 3.749 3.749 TRUE 13.6 Y 50630
2166 21632 NC EnergyUnited Elec Member Corp 37 2014 Bundled Cooperative 1619366 563236 2427478 106838 17187 124052 236 236 6.765 1.321 1.18 0.762 TRUE 15 Y 122896 119186
2170 21795 IL Constellation Energy Services, Inc. 17 2014 Energy Retail Power Marketer 5208659 5477480 10686139 824655 63514 888169
2180 22053 KY Kentucky Power Co 21 2014 Bundled Investor Owned 2350431 1371282 6531904 138958 30757 171011 216 22 216 22 761.9 505.3 2.677 2.373 TRUE 35 Y 170269 6
2181 22500 KS Westar Energy Inc 20 2014 Bundled Investor Owned 3434301 4452905 9973395 325263 48757 375307 898 24 898 24 158.93 114.36 1.494 1.299 TRUE 34 N 19482 46783 46783
2208 24211 AZ Tucson Electric Power Co 4 2014 Bundled Investor Owned 3726983 2202954 9165355 374203 39937 414748 420 0 420 0 57.126 0 0.714 0 TRUE 14 Y 331952 58 0 8 1.8 1.8 0
2211 24590 NH Unitil Energy Systems 33 2014 Bundled Investor Owned 457220 222465 758891 59272 9807 69133 103 62 103 62 747.58 184.35 2.592 1.733 TRUE 34.5 Y 200 73960 4 0.7
2213 24889 NC Brunswick Electric Member Corp 37 2014 Bundled Cooperative 1036882 266997 1303879 83228 2693 85921 126 85 126 85 FALSE 14.4 Y 0 85921 0
2216 25177 MN Dakota Electric Association 27 2014 Bundled Cooperative 916369 903479 1828435 95505 7405 103286 162 0 162 0 30.55 28.25 0.5 0.48 TRUE 12.5 N 35943
2260 28802 PA Talen Energy Marketing, LLC 42 2014 Energy Retail Power Marketer 1509992 5324011 10381698 97958 3211 101394
2267 38084 MI Great Lakes Energy Coop 26 2014 Bundled Cooperative 835082 172768 1422624 112071 10435 122833 245 0 245 0 250.18 136.2 1.48 1.19 TRUE Y 122833
2275 40212 GA Colquitt Electric Membership Corp 13 2014 Bundled Cooperative 862949 62290 1218673 57965 3391 64124 104 104 104 104 0 63751 0
2282 40228 VA Rappahannock Electric Coop 51 2014 Bundled Cooperative 2270494 333745 4376249 143220 12833 156611 315 5 315 5 116 116 1.2 1.2 FALSE 153670 3 0.8 2.4 0
2313 49853 TX Amigo Energy 48 2014 Bundled Retail Power Marketer 1634699 308914 1943613 100399 5040 105439
2314 49891 ME NextEra Energy Power Marketing 23 2014 Energy Retail Power Marketer 859679 1082377 1984446 135055 11706 147233
2321 50041 TX Stream SPE, LTD 48 2014 Bundled Retail Power Marketer 5063428 410776 5474204 319444 19021 338465
2333 50062 OH DPL Energy Resources 39 2014 Energy Retail Power Marketer 1858681 3765474 7574648 135777 25192 161378 FALSE N
2336 50149 MD Constellation Energy Power Choice Inc. 24 2014 Energy Retail Power Marketer 1444646 431 1445077 106486 163 106649
2348 54820 CT Direct Energy Services 9 2014 Energy Retail Power Marketer 655750 386472 1042222 74307 16325 90632
2351 54820 IL Direct Energy Services 17 2014 Energy Retail Power Marketer 1372161 825333 2197494 143542 29672 173214
2353 54820 MD Direct Energy Services 24 2014 Energy Retail Power Marketer 479399 380425 859824 38838 11509 50347
2354 54820 NJ Direct Energy Services 34 2014 Energy Retail Power Marketer 475528 712599 1188127 48690 25527 74217
2355 54820 NY Direct Energy Services 36 2014 Energy Retail Power Marketer 1521626 893525 2415151 177777 32960 210737
2356 54820 OH Direct Energy Services 39 2014 Energy Retail Power Marketer 430200 315412 745612 39512 11474 50986
2357 54820 PA Direct Energy Services 42 2014 Energy Retail Power Marketer 1337885 669553 2007438 116948 24141 141089
2358 54820 TX Direct Energy Services 48 2014 Bundled Retail Power Marketer 6621127 1017957 7639084 641424 48787 690211
2367 54862 TX Champion Energy Services 48 2014 Bundled Retail Power Marketer 1630745 3259314 6457194 94200 5736 99999
2392 54913 MA NSTAR Electric Company 25 2014 Delivery Investor Owned 1561091 9476890 12479590 241054 59837 301670 1990 523 1990 523 89.41 66.95 0.77 0.66 TRUE 34.5 Y 1200506 0 126 22.508
2393 54913 MA NSTAR Electric Company 25 2014 Bundled Investor Owned 5064032 3531796 8805023 765480 112265 879498 1990 523 1990 523 89.41 66.95 0.77 0.66 TRUE 34.5 Y 1200506 0 126 22.508
2398 55722 OH AEP Energy 39 2014 Energy Retail Power Marketer 2004539 5474133 7478672 155914 26059 181973
2404 55781 IL Liberty Power Corp. 17 2014 Energy Retail Power Marketer 352573 727720 1080293 52019 8774 60793
2421 55815 NY IDT Energy, Inc. 36 2014 Energy Retail Power Marketer 521395 53999 575394 110185 5477 115662
2422 55815 PA IDT Energy, Inc. 42 2014 Energy Retail Power Marketer 670071 86995 757066 67252 5191 72443
2432 55874 PA Energy Services Providers, Inc 42 2014 Energy Retail Power Marketer 735357 229822 965179 64301 10348 74649
2433 55875 TX StarTex Power 48 2014 Bundled Retail Power Marketer 1834304 1100150 2934738 120967 15120 136096
2440 55878 TX Hudson Energy Services 48 2014 Bundled Retail Power Marketer 1865 12540515 12542380 62 54424 54486
2441 55936 LA Entergy Gulf States - LA LLC 22 2014 Bundled Investor Owned 5368421 5529206 20822523 337242 53596 394367 541 0 541 0 FALSE 34.5 Y 11163 11654 3775
2442 55937 TX Entergy Texas Inc. 48 2014 Bundled Investor Owned 5810453 4747814 17698737 371752 48516 425554 484 0 484 0 FALSE 34.5 Y 15486
2446 56146 CO Black Hills/Colorado Elec.Util 8 2014 Bundled Investor Owned 598270 804350 1829881 82670 11837 94570 117 0 117 0 116.53 96 1.35 1.21 TRUE 35 N 93321
2447 56196 NY Just Energy New York Corp. 36 2014 Energy Retail Power Marketer 843735 161106 1004841 120742 3659 124401
2455 56212 NY Ambit Energy Holdings, LLC 36 2014 Energy Retail Power Marketer 1880375 395720 2276095 193934 15009 208943
2456 56212 PA Ambit Energy Holdings, LLC 42 2014 Energy Retail Power Marketer 748985 254155 1003140 57966 7769 65735
2458 56212 TX Ambit Energy Holdings, LLC 48 2014 Bundled Retail Power Marketer 5501615 944507 6446122 380797 33177 413974
2471 56265 PA Energy Plus Holdings LLC 42 2014 Energy Retail Power Marketer 524628 31434 556062 48352 1956 50308
2477 56292 TX Bounce Energy, Inc. 48 2014 Bundled Retail Power Marketer 1274955 129800 1404755 90373 6373 96746
2482 56379 IL MC Squared Energy Services, LLC 17 2014 Energy Retail Power Marketer 1506622 618267 2185848 100348 7465 107861
2493 56502 OH Duke Energy Retail Sales, LLC 39 2014 Energy Retail Power Marketer 1258302 3126130 7634863 93241 1751 95036
2512 56692 CA Marin Clean Energy 6 2014 Energy Retail Power Marketer 598017 635873 1233890 108497 12774 121271
2513 56697 IL Ameren Illinois Company 17 2014 Delivery Investor Owned 7221765 9938452 27756478 644748 95689 741092 2503 2503 175 139 1.31 1.15 TRUE 69 Y 663048 65966 50 4 2.5
2514 56697 IL Ameren Illinois Company 17 2014 Bundled Investor Owned 4662037 2737857 9140912 417879 65451 483679 2503 2503 175 139 1.31 1.15 TRUE 69 Y 663048 65966 50 4 2.5
2517 56737 PA Stream Energy Pennsylvania, LLC 42 2014 Energy Retail Power Marketer 974511 103059 1077570 86467 2188 88655
2525 56775 TX Entrust Energy 48 2014 Bundled Retail Power Marketer 853235 142551 995786 60341 3118 63459
2536 57037 MA Reliant Energy Northeast LLC 25 2014 Energy Retail Power Marketer 646636 127654 1259555 70223 3099 73372
2541 57037 PA Reliant Energy Northeast LLC 42 2014 Energy Retail Power Marketer 1867653 227836 2873443 189873 4585 194915
2555 57132 TX US Retailers, LLC 48 2014 Bundled Retail Power Marketer 983274 359670 1342944 60696 4841 65537
2607 57368 ME NEPM II 23 2014 Energy Retail Power Marketer 162257 14334 177200 136951 2089 139129
2630 58085 ME Electricity Maine, LLC 23 2014 Energy Retail Power Marketer 1016516 138720 1155236 132213 8473 140686
2631 58086 NH Electricity NH, LLC d/b/a ENH Power, LLC 33 2014 Energy Retail Power Marketer 416257 106653 522910 52564 5927 58491
2636 58119 CT Public Power LLC (CT) 9 2014 Energy Retail Power Marketer 572271 197827 770098 66452 4428 70880
2659 58162 NJ Viridian Energy PA LLC 34 2014 Energy Retail Power Marketer 506124 149952 656076 52748 5196 57944
2673 58364 ME New Brunswick Power Generation Corp. 23 2014 Energy Retail Power Marketer 1551656 1551656 504040 504040
2687 58667 CT North American Power and Gas, LLC 9 2014 Energy Retail Power Marketer 523155 48751 571906 52679 2181 54860
2712 58853 NY Kiwi Energy NY LLC 36 2014 Energy Retail Power Marketer 250252 250252 53050 53050
2737 58957 OH Interstate Gas Supply, Inc. 39 2014 Energy Retail Power Marketer 1281282 136648 2201046 127462 2580 136944
2741 58964 NY Alpha Gas and Electric, LLC 36 2014 Energy Retail Power Marketer 84084 84084 161690 161690
2745 58965 IL Energy.Me Midwest LLC 17 2014 Energy Retail Power Marketer 111559 1317804 1429363 102319 91042 193361
2764 59053 CT Abest Power & Gas, LLC 9 2014 Energy Retail Power Marketer 31665 134619 166284 33887 18194 52081
2807 59128 NY MPower Energy LLC 36 2014 Energy Retail Power Marketer 144008 97501 241509 441983 31694 473677
2944 99999 IL Adjustment 2014 17 2014 Bundled 815272 516280 1545627 79256 9625 89331
2946 99999 IL Adjustment 2014 17 2014 Energy 13032259 11479496 47765061 1674019 87293 1762792
2948 99999 IN Adjustment 2014 18 2014 Bundled 603706 393111 1215213 49813 7700 58054
2949 99999 KS Adjustment 2014 20 2014 Bundled 440585 304547 798448 45469 9336 55086
2991 99999 NJ Adjustment 2014 34 2014 Energy 537145 -472314 1277806 29331 31325 60120
3003 99999 NY Adjustment 2014 36 2014 Bundled 919411 652235 2254215 65720 9302 75887
3005 99999 OH Adjustment 2014 39 2014 Energy -84354 -14777215 1506666 28907 33772 62737
3006 99999 OH Adjustment 2014 39 2014 Bundled 667492 564666 1714772 58794 7696 67000
3007 99999 OK Adjustment 2014 40 2014 Bundled 509239 312613 984801 46691 7960 54883
3013 99999 PA Adjustment 2014 42 2014 Energy 1486665 -22160260 5352653 106808 89846 204750
3014 99999 PA Adjustment 2014 42 2014 Bundled 516171 256470 919459 64302 7709 72376
3025 99999 TX Adjustment 2014 48 2014 Bundled 865636 752071 10708925 67933 15894 84318
NA
Raw
index.html
<html>
<head>
<title>Vega test</title>
<script src="http://vega.github.io/vega-editor/vendor/d3.min.js"></script>
<script src="http://vega.github.io/vega/vega.min.js"></script>
</head>
<body>
<div id="vis"></div>
</body>
<script type="text/javascript">
//vg.debug.enable = true;
// parse a spec and create a visualization view
vg.parse.spec("spec.json", function(chart) { chart({el:"#vis"}).update(); });
</script>
</html>
Raw
spec.json
{
"width": 800,
"height": 400,
"data": [
{
"name": "f861",
"url": "f8612014.csv",
"format": {
"type": "csv"
},
"transform": [
{
"type": "aggregate",
"groupby": [
"State_Code"
],
"summarize": {
"Total_Customers_Count": [
"sum",
"median",
"average",
"min",
"max",
"count"
]
}
}
]
}
],
"scales": [
{
"name": "x",
"type": "ordinal",
"range": "width",
"domain": {
"data": "f861",
"field": "State_Code"
}
},
{
"name": "y",
"type": "linear",
"range": "height",
"domain": {
"data": "f861",
"field": "sum_Total_Customers_Count"
},
"nice": true
}
],
"axes": [
{
"type": "x",
"scale": "x"
},
{
"type": "y",
"scale": "y"
}
],
"marks": [
{
"type": "rect",
"from": {
"data": "f861"
},
"properties": {
"enter": {
"x": {
"scale": "x",
"field": "State_Code"
},
"width": {
"scale": "x",
"band": true,
"offset": -1
},
"y": {
"scale": "y",
"field": "sum_Total_Customers_Count"
},
"y2": {
"scale": "y",
"value": 0
}
},
"update": {
"fill": {
"value": "steelblue"
}
},
"hover": {
"fill": {
"value": "red"
}
}
}
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment