Skip to content

Instantly share code, notes, and snippets.

@donaldpminer
Created September 27, 2018 01:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save donaldpminer/3737c5711883a45313dd36720821d019 to your computer and use it in GitHub Desktop.
Save donaldpminer/3737c5711883a45313dd36720821d019 to your computer and use it in GitHub Desktop.
Percentage of times that play sol ring from edhrec data sept 26, 2018
SELECT commander, COUNT(*), COUNT(*)::float / (SELECT COUNT(*) FROM decks WHERE decks.commander=aa.commander) as perc FROM (SELECT commander, card FROM (SELECT * FROM cards WHERE card='Sol Ring') cards JOIN decks on cards.url=decks.url) aa GROUP BY commander ORDER BY perc;
commander | count | perc
---------------------------------+-------+-------------------
Budoka Gardener | 5 | 0.125
Kodama of the North Tree | 1 | 0.125
Marhault Elsdragon | 2 | 0.125
Zurgo Bellstriker | 48 | 0.185328185328185
Kasimir the Lone Wolf | 1 | 0.2
Jerrard of the Closed Fist | 4 | 0.210526315789474
Autumn Willow | 3 | 0.230769230769231
Barktooth Warbeard | 4 | 0.235294117647059
Jasmine Boreal | 10 | 0.263157894736842
Sir Shandlar of Eberyn | 6 | 0.272727272727273
Tobias Andrion | 8 | 0.275862068965517
Sivitri Scarzam | 6 | 0.285714285714286
Seton, Krosan Protector | 87 | 0.287128712871287
Genju of the Realm | 22 | 0.289473684210526
Ascendant Evincar | 16 | 0.30188679245283
Kaysa | 14 | 0.318181818181818
Ur-Drago | 1 | 0.333333333333333
Tuknir Deathlock | 2 | 0.333333333333333
Eron the Relentless | 8 | 0.333333333333333
Molimo, Maro-Sorcerer | 37 | 0.333333333333333
Sasaya, Orochi Ascendant | 68 | 0.345177664974619
Braids, Cabal Minion | 15 | 0.357142857142857
General Jarkeld | 9 | 0.36
Pavel Maliki | 4 | 0.363636363636364
Orim, Samite Healer | 7 | 0.368421052631579
Bartel Runeaxe | 7 | 0.368421052631579
Alexi, Zephyr Mage | 7 | 0.368421052631579
Rofellos, Llanowar Emissary | 10 | 0.37037037037037
Baru, Fist of Krosa | 22 | 0.372881355932203
Hikari, Twilight Guardian | 6 | 0.375
Griselbrand | 21 | 0.375
Kodama of the South Tree | 14 | 0.388888888888889
Irini Sengir | 4 | 0.4
Isareth the Awakener | 2 | 0.4
Lady Orca | 8 | 0.4
Torsten Von Ursus | 6 | 0.4
Myojin of Night's Reach | 2 | 0.4
The Lady of the Mountain | 6 | 0.4
Dwynen, Gilt-Leaf Daen | 33 | 0.402439024390244
Joven | 11 | 0.407407407407407
Patron of the Akki | 11 | 0.407407407407407
Sosuke, Son of Seshiro | 9 | 0.409090909090909
Kyoki, Sanity's Eclipse | 12 | 0.413793103448276
Ramirez DePietro | 26 | 0.419354838709677
Jolrael, Empress of Beasts | 42 | 0.424242424242424
Sima Yi, Wei Field Marshal | 3 | 0.428571428571429
Jedit Ojanen of Efrava | 18 | 0.428571428571429
Nemata, Grove Guardian | 28 | 0.430769230769231
Thriss, Nantuko Primus | 22 | 0.44
Glissa Sunseeker | 15 | 0.441176470588235
Shanna, Sisay's Legacy | 19 | 0.441860465116279
Daughter of Autumn | 4 | 0.444444444444444
Yukora, the Prisoner | 4 | 0.444444444444444
Borborygmos | 20 | 0.454545454545455
Princess Lucrezia | 5 | 0.454545454545455
Linvala, the Preserver | 12 | 0.461538461538462
Asmira, Holy Avenger | 32 | 0.463768115942029
Patron of the Orochi | 37 | 0.468354430379747
Seshiro the Anointed | 53 | 0.473214285714286
Bounteous Kirin | 9 | 0.473684210526316
Sachi, Daughter of Seshiro | 51 | 0.476635514018692
Ink-Treader Nephilim | 44 | 0.478260869565217
Thalia, Guardian of Thraben | 98 | 0.480392156862745
Masumaro, First to Live | 13 | 0.481481481481481
Kamahl, Fist of Krosa | 76 | 0.484076433121019
Vendilion Clique | 34 | 0.485714285714286
Surrak, the Hunt Caller | 35 | 0.486111111111111
Shizuko, Caller of Autumn | 19 | 0.487179487179487
Grunn, the Lonely King | 21 | 0.488372093023256
Emmara Tandris | 43 | 0.488636363636364
Krond the Dawn-Clad | 78 | 0.490566037735849
Rhys the Exiled | 50 | 0.495049504950495
Tor Wauki | 9 | 0.5
Eladamri, Lord of Leaves | 38 | 0.5
Cao Ren, Wei Commander | 1 | 0.5
Kitsune Mystic | 6 | 0.5
Iname, Life Aspect | 16 | 0.5
Tivadar of Thorn | 9 | 0.5
Hunding Gjornersen | 1 | 0.5
Nagao, Bound by Honor | 5 | 0.5
Ma Chao, Western Warrior | 1 | 0.5
Kwende, Pride of Femeref | 9 | 0.5
Ayumi, the Last Visitor | 12 | 0.5
Telim'Tor | 1 | 0.5
Guan Yu, Sainted Warrior | 1 | 0.5
Ol' Buzzbark | 1 | 0.5
Xun Yu, Wei Advisor | 1 | 0.5
Ishi-Ishi, Akki Crackshot | 5 | 0.5
Zhang Liao, Hero of Hefei | 1 | 0.5
Isao, Enlightened Bushi | 16 | 0.5
Tamanoa | 29 | 0.5
Zhuge Jin, Wu Strategist | 3 | 0.5
Nefarox, Overlord of Grixis | 28 | 0.509090909090909
Silvos, Rogue Elemental | 26 | 0.509803921568627
Anax and Cymede | 103 | 0.50990099009901
Dromoka, the Eternal | 65 | 0.511811023622047
Sliver Hivelord | 233 | 0.513215859030837
Horde of Notions | 433 | 0.514863258026159
Boris Devilboon | 17 | 0.515151515151515
Demonlord Belzenlok | 15 | 0.517241379310345
Child of Alara | 736 | 0.517945109078114
Masako the Humorless | 13 | 0.52
Mina and Denn, Wildborn | 285 | 0.521978021978022
He Who Hungers | 11 | 0.523809523809524
Dune-Brood Nephilim | 33 | 0.523809523809524
Jugan, the Rising Star | 10 | 0.526315789473684
Sol'kanar the Swamp King | 29 | 0.527272727272727
Multani, Yavimaya's Avatar | 29 | 0.527272727272727
Verdeloth the Ancient | 38 | 0.527777777777778
Akuta, Born of Ash | 9 | 0.529411764705882
Lim-Dûl the Necromancer | 18 | 0.529411764705882
Atogatog | 124 | 0.532188841201717
Patron of the Nezumi | 24 | 0.533333333333333
Anafenza, Kin-Tree Spirit | 72 | 0.533333333333333
Maelstrom Archangel | 40 | 0.533333333333333
Nylea, God of the Hunt | 83 | 0.535483870967742
Cromat | 331 | 0.535598705501618
Daghatar the Adamant | 144 | 0.537313432835821
Sliver Legion | 43 | 0.5375
Wydwen, the Biting Gale | 92 | 0.538011695906433
Niambi, Faithful Healer | 7 | 0.538461538461538
Ezuri, Renegade Leader | 560 | 0.539499036608863
Animar, Soul of Elements | 1115 | 0.539690222652469
Tuktuk the Explorer | 20 | 0.540540540540541
Munda, Ambush Leader | 39 | 0.541666666666667
Radha, Heir to Keld | 135 | 0.542168674698795
Opal-Eye, Konda's Yojimbo | 19 | 0.542857142857143
Purraj of Urborg | 6 | 0.545454545454545
Marwyn, the Nurturer | 47 | 0.546511627906977
Ruric Thar, the Unbowed | 403 | 0.547554347826087
Teshar, Ancestor's Apostle | 22 | 0.55
Sakiko, Mother of Summer | 16 | 0.551724137931034
Karona, False God | 453 | 0.551766138855055
Arashi, the Sky Asunder | 5 | 0.555555555555556
Jeska, Warrior Adept | 10 | 0.555555555555556
Nissa, Vastwood Seer | 228 | 0.55609756097561
Kataki, War's Wage | 28 | 0.56
Lady Evangela | 28 | 0.56
Hua Tuo, Honored Physician | 28 | 0.56
Chromanticore | 37 | 0.560606060606061
Johan | 27 | 0.5625
Patron of the Kitsune | 18 | 0.5625
Ib Halfheart, Goblin Tactician | 58 | 0.563106796116505
Adeliz, the Cinder Wind | 49 | 0.563218390804598
Rona, Disciple of Gix | 13 | 0.565217391304348
Maralen of the Mornsong | 181 | 0.565625
Yeva, Nature's Herald | 213 | 0.566489361702128
Ragnar | 25 | 0.568181818181818
Kiku, Night's Flower | 29 | 0.568627450980392
Rayne, Academy Chancellor | 28 | 0.571428571428571
Pianna, Nomad Captain | 12 | 0.571428571428571
X | 4 | 0.571428571428571
Morinfen | 8 | 0.571428571428571
Chorus of the Conclave | 56 | 0.571428571428571
Crovax the Cursed | 8 | 0.571428571428571
Rohgahh of Kher Keep | 4 | 0.571428571428571
Ihsan's Shade | 27 | 0.574468085106383
Szadek, Lord of Secrets | 49 | 0.576470588235294
The Unspeakable | 15 | 0.576923076923077
Gabriel Angelfire | 11 | 0.578947368421053
Stonebrow, Krosan Hero | 102 | 0.579545454545455
Xira Arien | 143 | 0.58130081300813
Borborygmos Enraged | 277 | 0.581932773109244
Oriss, Samite Guardian | 7 | 0.583333333333333
Omnath, Locus of Mana | 684 | 0.585115483319076
Baron Sengir | 17 | 0.586206896551724
Myojin of Life's Web | 10 | 0.588235294117647
Cloudhoof Kirin | 20 | 0.588235294117647
Polukranos, World Eater | 70 | 0.588235294117647
Atalya, Samite Master | 30 | 0.588235294117647
Jacques le Vert | 23 | 0.58974358974359
Palladia-Mors | 16 | 0.592592592592593
Anafenza, the Foremost | 582 | 0.592668024439919
Dragonlord Atarka | 51 | 0.593023255813954
Shisato, Whispering Hunter | 19 | 0.59375
Iwamori of the Open Fist | 19 | 0.59375
Arcades Sabboth | 41 | 0.594202898550725
Glint-Eye Nephilim | 28 | 0.595744680851064
Edric, Spymaster of Trest | 661 | 0.596032461677187
Jiwari, the Earth Aflame | 3 | 0.6
Meng Huo, Barbarian King | 3 | 0.6
Lena, Selfless Champion | 3 | 0.6
Tatyova, Benthic Druid | 231 | 0.6
Mavren Fein, Dusk Apostle | 3 | 0.6
Elbrus, the Binding Blade | 15 | 0.6
Darigaaz, the Igniter | 35 | 0.603448275862069
Kodama of the Center Tree | 20 | 0.606060606060606
Anthousa, Setessan Hero | 34 | 0.607142857142857
Tolsimir Wolfblood | 115 | 0.608465608465608
Spirit of the Night | 14 | 0.608695652173913
Hakim, Loreweaver | 28 | 0.608695652173913
Kaho, Minamo Historian | 75 | 0.609756097560976
Balthor the Stout | 11 | 0.611111111111111
Lieutenant Kirtar | 11 | 0.611111111111111
Brothers Yamazaki | 22 | 0.611111111111111
Mirri, Cat Warrior | 11 | 0.611111111111111
Kytheon, Hero of Akros | 117 | 0.612565445026178
Geist of Saint Traft | 348 | 0.612676056338028
Pharika, God of Affliction | 125 | 0.612745098039216
Ayesha Tanaka | 19 | 0.612903225806452
Oviya Pashiri, Sage Lifecrafter | 105 | 0.614035087719298
Ramses Overdark | 32 | 0.615384615384615
Soramaro, First to Dream | 24 | 0.615384615384615
Thelon of Havenwood | 157 | 0.615686274509804
Tibor and Lumia | 97 | 0.617834394904459
Mikaeus, the Lunarch | 78 | 0.619047619047619
Vhati il-Dal | 70 | 0.619469026548673
Witch-Maw Nephilim | 44 | 0.619718309859155
Crovax, Ascendant Hero | 31 | 0.62
Vaevictis Asmadi | 51 | 0.621951219512195
Kalitas, Bloodchief of Ghet | 28 | 0.622222222222222
Iname as One | 43 | 0.623188405797101
Ben-Ben, Akki Hermit | 20 | 0.625
Alhammarret, High Arbiter | 10 | 0.625
Varolz, the Scar-Striped | 270 | 0.625
Soraya the Falconer | 35 | 0.625
Seizan, Perverter of Truth | 77 | 0.626016260162602
Ink-Eyes, Servant of Oni | 32 | 0.627450980392157
Treva, the Renewer | 91 | 0.627586206896552
Jodah, Archmage Eternal | 403 | 0.627725856697819
Pia Nalaar | 22 | 0.628571428571429
Drana, Liberator of Malakir | 82 | 0.630769230769231
Titania, Protector of Argoth | 377 | 0.633613445378151
Marrow-Gnawer | 467 | 0.634510869565217
Teysa, Envoy of Ghosts | 259 | 0.634803921568627
Ghost Council of Orzhova | 87 | 0.635036496350365
Progenitus | 846 | 0.635135135135135
Kiyomaro, First to Stand | 14 | 0.636363636363636
Sliver Queen | 310 | 0.636550308008214
Exava, Rakdos Blood Witch | 72 | 0.63716814159292
Omnath, Locus of Rage | 1445 | 0.637687555163283
Greel, Mind Raker | 37 | 0.637931034482759
Thrun, the Last Troll | 96 | 0.64
Savra, Queen of the Golgari | 228 | 0.640449438202247
Wort, Boggart Auntie | 179 | 0.6415770609319
Cabal Patriarch | 9 | 0.642857142857143
Hythonia the Cruel | 27 | 0.642857142857143
Vorosh, the Hunter | 107 | 0.644578313253012
Elenda, the Dusk Rose | 68 | 0.647619047619048
Tymaret, the Murder King | 120 | 0.648648648648649
Reveka, Wizard Savant | 24 | 0.648648648648649
Erayo, Soratami Ascendant | 24 | 0.648648648648649
Ulrich of the Krallenhorde | 344 | 0.649056603773585
Vorel of the Hull Clade | 523 | 0.649689440993789
Silumgar, the Drifting Death | 78 | 0.65
Phelddagrif | 424 | 0.650306748466258
Celestial Kirin | 41 | 0.650793650793651
Jareth, Leonine Titan | 28 | 0.651162790697674
Gaddock Teeg | 249 | 0.651832460732984
Sliver Overlord | 1008 | 0.653272845106935
Haakon, Stromgald Scourge | 34 | 0.653846153846154
Dosan the Falling Leaf | 34 | 0.653846153846154
Tetsuko Umezawa, Fugitive | 72 | 0.654545454545455
O-Kagachi, Vengeful Kami | 199 | 0.654605263157895
Sek'Kuar, Deathkeeper | 243 | 0.654986522911051
Ghalta, Primal Hunger | 82 | 0.656
Garza Zol, Plague Queen | 42 | 0.65625
Garna, the Bloodflame | 25 | 0.657894736842105
Karametra, God of Harvests | 894 | 0.658321060382916
Yargle, Glutton of Urborg | 27 | 0.658536585365854
Multani, Maro-Sorcerer | 58 | 0.659090909090909
Selvala, Explorer Returned | 644 | 0.659160696008188
Ambassador Laquatus | 37 | 0.660714285714286
Dakkon Blackblade | 111 | 0.660714285714286
Sisters of Stone Death | 78 | 0.661016949152542
Sidisi, Brood Tyrant | 1394 | 0.66254752851711
Rhonas the Indomitable | 138 | 0.663461538461538
Isamaru, Hound of Konda | 142 | 0.663551401869159
Ulasht, the Hate Seed | 162 | 0.663934426229508
Veldrane of Sengir | 2 | 0.666666666666667
Riven Turnbull | 6 | 0.666666666666667
Maraxus of Keld | 24 | 0.666666666666667
Myojin of Cleansing Fire | 2 | 0.666666666666667
Ryusei, the Falling Star | 28 | 0.666666666666667
Lady Caleria | 18 | 0.666666666666667
Urgoros, the Empty One | 6 | 0.666666666666667
Cho-Manno, Revolutionary | 24 | 0.666666666666667
Arvad the Cursed | 34 | 0.666666666666667
Nighteyes the Desecrator | 2 | 0.666666666666667
Emrakul, the Aeons Torn | 20 | 0.666666666666667
Skullbriar, the Walking Grave | 378 | 0.667844522968198
Vorinclex, Voice of Hunger | 89 | 0.669172932330827
Reki, the History of Kamigawa | 81 | 0.669421487603306
General Tazri | 909 | 0.670353982300885
Lavinia of the Tenth | 114 | 0.670588235294118
Ashling the Pilgrim | 229 | 0.671554252199413
Raksha Golden Cub | 43 | 0.671875
Doran, the Siege Tower | 877 | 0.672546012269939
Isperia the Inscrutable | 134 | 0.673366834170854
Agrus Kos, Wojek Veteran | 33 | 0.673469387755102
Jenara, Asura of War | 428 | 0.674015748031496
Dragonlord Dromoka | 141 | 0.674641148325359
Mirri the Cursed | 27 | 0.675
Azusa, Lost but Seeking | 370 | 0.675182481751825
Yasova Dragonclaw | 445 | 0.675265553869499
Baral, Chief of Compliance | 529 | 0.675606641123882
Nebuchadnezzar | 50 | 0.675675675675676
Reya Dawnbringer | 23 | 0.676470588235294
Razia, Boros Archangel | 21 | 0.67741935483871
Bontu the Glorified | 70 | 0.679611650485437
Sigarda, Heron's Grace | 365 | 0.679702048417132
Shirei, Shizo's Caretaker | 370 | 0.680147058823529
Teneb, the Harvester | 275 | 0.680693069306931
Avacyn, Guardian Angel | 47 | 0.681159420289855
Tiana, Ship's Caretaker | 45 | 0.681818181818182
Lyzolda, the Blood Witch | 118 | 0.682080924855491
Kuon, Ogre Ascendant | 28 | 0.682926829268293
Valduk, Keeper of the Flame | 67 | 0.683673469387755
Palladia-Mors, the Ruiner | 13 | 0.684210526315789
Baird, Steward of Argive | 13 | 0.684210526315789
Chromium | 39 | 0.684210526315789
Higure, the Still Wind | 13 | 0.684210526315789
Jarad, Golgari Lich Lord | 576 | 0.684898929845422
Triad of Fates | 110 | 0.6875
Odric, Master Tactician | 198 | 0.6875
Sensei Golden-Tail | 42 | 0.688524590163934
Thalia, Heretic Cathar | 73 | 0.688679245283019
Nath of the Gilt-Leaf | 580 | 0.688836104513064
Wort, the Raidmother | 488 | 0.689265536723164
Grand Warlord Radha | 98 | 0.690140845070423
Athreos, God of Passage | 863 | 0.6904
Tishana, Voice of Thunder | 110 | 0.691823899371069
Lady Zhurong, Warrior Queen | 9 | 0.692307692307692
Bruse Tarl, Boorish Herder | 399 | 0.692708333333333
Adun Oakenshield | 70 | 0.693069306930693
Kangee, Aerie Keeper | 183 | 0.693181818181818
Mirko Vosk, Mind Drinker | 258 | 0.693548387096774
Infernal Kirin | 25 | 0.694444444444444
Noyan Dar, Roil Shaper | 419 | 0.69485903814262
Oyobi, Who Split the Heavens | 41 | 0.694915254237288
Trostani, Selesnya's Voice | 1003 | 0.695079695079695
Tahngarth, Talruum Hero | 16 | 0.695652173913043
Mannichi, the Fevered Dream | 30 | 0.697674418604651
The Gitrog Monster | 1211 | 0.697982708933718
Rakka Mar | 44 | 0.698412698412698
Tymna the Weaver | 44 | 0.698412698412698
Chandra, Fire of Kaladesh | 237 | 0.699115044247788
Jori En, Ruin Diver | 398 | 0.699472759226713
Gwafa Hazid, Profiteer | 240 | 0.699708454810496
Ishkanah, Grafwidow | 331 | 0.699788583509514
Captain Lannery Storm | 7 | 0.7
Josu Vess, Lich Knight | 21 | 0.7
Shalai, Voice of Plenty | 49 | 0.7
Surrak Dragonclaw | 807 | 0.70112945264987
Rubinia Soulsinger | 297 | 0.702127659574468
Aryel, Knight of Windgrace | 92 | 0.702290076335878
Obzedat, Ghost Council | 374 | 0.703007518796993
Evra, Halcyon Witness | 19 | 0.703703703703704
Visara the Dreadful | 38 | 0.703703703703704
Kraum, Ludevic's Opus | 396 | 0.704626334519573
Toshiro Umezawa | 187 | 0.705660377358491
Rosheen Meanderer | 288 | 0.705882352941177
Kazuul, Tyrant of the Cliffs | 96 | 0.705882352941177
Dragonlord Kolaghan | 36 | 0.705882352941177
Jace, Vryn's Prodigy | 283 | 0.7075
Niv-Mizzet, Dracogenius | 150 | 0.707547169811321
Darigaaz Reincarnated | 34 | 0.708333333333333
Danitha Capashen, Paragon | 17 | 0.708333333333333
Sekki, Seasons' Guide | 44 | 0.709677419354839
Llawan, Cephalid Empress | 22 | 0.709677419354839
Reaper King | 614 | 0.709826589595376
Stangg | 32 | 0.711111111111111
Ith, High Arcanist | 32 | 0.711111111111111
Hazezon Tamar | 225 | 0.712025316455696
Radiant, Archangel | 62 | 0.71264367816092
Daxos of Meletis | 327 | 0.713973799126638
Hazduhr the Abbot | 5 | 0.714285714285714
Mageta the Lion | 45 | 0.714285714285714
Korlash, Heir to Blackblade | 115 | 0.714285714285714
Ikra Shidiqi, the Usurper | 264 | 0.715447154471545
Admiral Beckett Brass | 252 | 0.715909090909091
Sygg, River Cutthroat | 344 | 0.718162839248434
Linessa, Zephyr Mage | 23 | 0.71875
Uril, the Miststalker | 655 | 0.718990120746433
Rith, the Awakener | 261 | 0.71900826446281
Tuvasa the Sunlit | 128 | 0.719101123595506
Whisper, Blood Liturgist | 41 | 0.719298245614035
Sigarda, Host of Herons | 593 | 0.719660194174757
Wasitora, Nekoru Queen | 95 | 0.71969696969697
Reyhan, Last of the Abzan | 185 | 0.719844357976654
Kongming, "Sleeping Dragon" | 18 | 0.72
Zada, Hedron Grinder | 572 | 0.720403022670025
Kira, Great Glass-Spinner | 62 | 0.720930232558139
Chisei, Heart of Oceans | 31 | 0.720930232558139
Blind Seer | 70 | 0.721649484536082
Shu Yun, the Silent Tempest | 833 | 0.722463139635733
King Macar, the Gold-Cursed | 164 | 0.722466960352423
Brigid, Hero of Kinsbaile | 47 | 0.723076923076923
Tromokratis | 81 | 0.723214285714286
Halfdane | 34 | 0.723404255319149
Gahiji, Honored One | 542 | 0.723631508678238
Horobi, Death's Wail | 176 | 0.724279835390947
Goreclaw, Terror of Qal Sisma | 71 | 0.724489795918367
Takeno, Samurai General | 29 | 0.725
Keranos, God of Storms | 492 | 0.725663716814159
Rishkar, Peema Renegade | 188 | 0.725868725868726
Axelrod Gunnarson | 8 | 0.727272727272727
Tsabo Tavoc | 56 | 0.727272727272727
Olivia, Mobilized for War | 302 | 0.727710843373494
Hallar, the Firefletcher | 75 | 0.728155339805825
Gerrard Capashen | 27 | 0.72972972972973
Kaseto, Orochi Archmage | 348 | 0.73109243697479
Samut, Voice of Dissent | 496 | 0.731563421828909
Ob Nixilis, the Fallen | 71 | 0.731958762886598
Kresh the Bloodbraided | 635 | 0.732410611303345
Ertai, the Corrupted | 228 | 0.733118971061093
Rhys the Redeemed | 874 | 0.733221476510067
Kambal, Consul of Allocation | 495 | 0.733333333333333
Kagemaro, First to Suffer | 22 | 0.733333333333333
Experiment Kraj | 356 | 0.735537190082645
Tetsuo Umezawa | 39 | 0.735849056603774
Rafiq of the Many | 926 | 0.73667462211615
Kopala, Warden of Waves | 14 | 0.736842105263158
Jaya Ballard, Task Mage | 140 | 0.736842105263158
Rakdos, Lord of Riots | 1003 | 0.736958119030125
Angus Mackenzie | 287 | 0.737789203084833
Kuro, Pitlord | 31 | 0.738095238095238
Najeela, the Blade-Blossom | 277 | 0.738666666666667
Krenko, Mob Boss | 1308 | 0.740656851642129
Thromok the Insatiable | 264 | 0.741573033707865
Kynaios and Tiro of Meletis | 1518 | 0.7426614481409
Gisa and Geralf | 921 | 0.742741935483871
Sidar Kondo of Jamuraa | 384 | 0.742746615087041
Grothama, All-Devouring | 29 | 0.743589743589744
Endrek Sahr, Master Breeder | 192 | 0.744186046511628
Ramos, Dragon Engine | 667 | 0.744419642857143
Ertai, Wizard Adept | 35 | 0.74468085106383
Hapatra, Vizier of Poisons | 827 | 0.745045045045045
Gwendlyn Di Corci | 76 | 0.745098039215686
Heliod, God of the Sun | 196 | 0.745247148288973
Momir Vig, Simic Visionary | 495 | 0.745481927710843
Odric, Lunarch Marshal | 441 | 0.747457627118644
Prime Speaker Zegana | 481 | 0.74805598755832
Lovisa Coldeyes | 220 | 0.748299319727891
Karador, Ghost Chieftain | 1433 | 0.749476987447699
Tetzimoc, Primal Death | 3 | 0.75
Lu Bu, Master-at-Arms | 18 | 0.75
Oros, the Avenger | 111 | 0.75
Yomiji, Who Bars the Way | 33 | 0.75
Hivis of the Scale | 6 | 0.75
Slimefoot, the Stowaway | 232 | 0.750809061488673
Adriana, Captain of the Guard | 160 | 0.751173708920188
Rune-Tail, Kitsune Ascendant | 127 | 0.751479289940828
Estrid, the Masked | 179 | 0.752100840336134
Brimaz, King of Oreskos | 152 | 0.752475247524752
Iname, Death Aspect | 67 | 0.752808988764045
Dromar, the Banisher | 61 | 0.753086419753086
Kolaghan, the Storm's Fury | 113 | 0.753333333333333
Neheb, the Worthy | 281 | 0.753351206434316
Skithiryx, the Blight Dragon | 324 | 0.753488372093023
Saffi Eriksdotter | 175 | 0.754310344827586
Lord of Tresserhorn | 169 | 0.754464285714286
Khorvath Brightflame | 34 | 0.755555555555556
Melek, Izzet Paragon | 839 | 0.755855855855856
Ravos, Soultender | 657 | 0.756041426927503
Vela the Night-Clad | 416 | 0.756363636363636
Basandra, Battle Seraph | 87 | 0.756521739130435
Kari Zev, Skyship Raider | 81 | 0.757009345794392
Sygg, River Guide | 287 | 0.757255936675462
Ruhan of the Fomori | 400 | 0.757575757575758
Volrath the Fallen | 94 | 0.758064516129032
Michiko Konda, Truth Seeker | 44 | 0.758620689655172
Ixidor, Reality Sculptor | 85 | 0.758928571428571
Leovold, Emissary of Trest | 612 | 0.759305210918114
Arcades, the Strategist | 284 | 0.759358288770054
Ludevic, Necro-Alchemist | 218 | 0.759581881533101
Grenzo, Dungeon Warden | 547 | 0.759722222222222
Zurgo Helmsmasher | 1044 | 0.759825327510917
Selenia, Dark Angel | 171 | 0.76
Temmet, Vizier of Naktamun | 203 | 0.760299625468165
Intet, the Dreamer | 378 | 0.76056338028169
Cao Cao, Lord of Wei | 64 | 0.761904761904762
Konda, Lord of Eiganjo | 32 | 0.761904761904762
Taigam, Sidisi's Hand | 77 | 0.762376237623762
Depala, Pilot Exemplar | 453 | 0.762626262626263
Circu, Dimir Lobotomist | 103 | 0.762962962962963
Ayli, Eternal Pilgrim | 934 | 0.763071895424837
Balthor the Defiled | 123 | 0.763975155279503
Dong Zhou, the Tyrant | 13 | 0.764705882352941
Skeleton Ship | 98 | 0.765625
Mistform Ultimus | 95 | 0.766129032258065
Numot, the Devastator | 220 | 0.766550522648084
Shauku, Endbringer | 23 | 0.766666666666667
Melira, Sylvok Outcast | 46 | 0.766666666666667
Márton Stromgald | 23 | 0.766666666666667
Grimgrin, Corpse-Born | 639 | 0.767106842737095
Zacama, Primal Calamity | 211 | 0.767272727272727
Glissa, the Traitor | 634 | 0.767554479418886
Talrand, Sky Summoner | 938 | 0.768222768222768
Aboshan, Cephalid Emperor | 63 | 0.768292682926829
Jalira, Master Polymorphist | 282 | 0.768392370572207
Liliana, Heretical Healer | 452 | 0.768707482993197
Alesha, Who Smiles at Death | 1659 | 0.768767377201112
Kentaro, the Smiling Cat | 10 | 0.769230769230769
Squee, Goblin Nabob | 50 | 0.769230769230769
Heidar, Rimewind Master | 30 | 0.769230769230769
Freyalise, Llanowar's Fury | 477 | 0.769354838709677
Isperia, Supreme Judge | 177 | 0.769565217391304
Merieke Ri Berit | 443 | 0.770434782608696
Iona, Shield of Emeria | 47 | 0.770491803278688
Tomorrow, Azami's Familiar | 81 | 0.771428571428571
Marath, Will of the Wild | 1048 | 0.772861356932153
Selvala, Heart of the Wilds | 582 | 0.772908366533865
Mazirek, Kraul Death Priest | 407 | 0.773764258555133
Meloku the Clouded Mirror | 48 | 0.774193548387097
Lazav, Dimir Mastermind | 817 | 0.774407582938389
Tajic, Blade of the Legion | 375 | 0.774793388429752
Kestia, the Cultivator | 31 | 0.775
Homura, Human Ascendant | 31 | 0.775
Kemba, Kha Regent | 507 | 0.775229357798165
Lathliss, Dragon Queen | 38 | 0.775510204081633
Linvala, Keeper of Silence | 83 | 0.775700934579439
Sidisi, Undead Vizier | 426 | 0.775956284153005
Vaevictis Asmadi, the Dire | 111 | 0.776223776223776
Lin Sivvi, Defiant Hero | 129 | 0.77710843373494
Major Teroh | 7 | 0.777777777777778
Maga, Traitor to Mortals | 98 | 0.777777777777778
Yosei, the Morning Star | 28 | 0.777777777777778
Livonya Silone | 7 | 0.777777777777778
Wrexial, the Risen Deep | 323 | 0.778313253012048
Phenax, God of Deception | 1104 | 0.779110797459421
Kumena, Tyrant of Orazca | 254 | 0.779141104294479
Kalitas, Traitor of Ghet | 219 | 0.779359430604982
Zedruu the Greathearted | 1227 | 0.781031190324634
Iroas, God of Victory | 540 | 0.781476121562952
Kurkesh, Onakke Ancient | 161 | 0.781553398058252
Scion of the Ur-Dragon | 1259 | 0.781987577639752
Ob Nixilis, Unshackled | 119 | 0.782894736842105
Jazal Goldmane | 105 | 0.783582089552239
Stitcher Geralf | 87 | 0.783783783783784
Atarka, World Render | 324 | 0.784503631961259
Yisan, the Wanderer Bard | 654 | 0.785114045618247
Naban, Dean of Iteration | 44 | 0.785714285714286
Malfegor | 176 | 0.785714285714286
Saskia the Unyielding | 1406 | 0.786793508673755
Shattergang Brothers | 484 | 0.786991869918699
Ojutai, Soul of Winter | 52 | 0.787878787878788
Phage the Untouchable | 171 | 0.788018433179724
Sram, Senior Edificer | 595 | 0.788079470198676
Vona, Butcher of Magan | 56 | 0.788732394366197
Kaervek the Merciless | 251 | 0.789308176100629
Torgaar, Famine Incarnate | 15 | 0.789473684210526
Arahbo, Roar of the World | 535 | 0.790251107828656
Keiga, the Tide Star | 49 | 0.790322580645161
Rorix Bladewing | 34 | 0.790697674418605
Anya, Merciless Angel | 95 | 0.791666666666667
Chromium, the Mutable | 80 | 0.792079207920792
Thassa, God of the Sea | 393 | 0.792338709677419
Gishath, Sun's Avatar | 569 | 0.792479108635098
Karlov of the Ghost Council | 910 | 0.792682926829268
Rashmi, Eternities Crafter | 961 | 0.792904290429043
Bladewing the Risen | 100 | 0.793650793650794
Kefnet the Mindful | 154 | 0.793814432989691
Mangara of Corondor | 58 | 0.794520547945205
Kamahl, Pit Fighter | 31 | 0.794871794871795
Raff Capashen, Ship's Mage | 70 | 0.795454545454545
Mikaeus, the Unhallowed | 354 | 0.795505617977528
Ghave, Guru of Spores | 1398 | 0.796127562642369
Geth, Lord of the Vault | 165 | 0.797101449275362
Azor, the Lawbringer | 87 | 0.798165137614679
Riku of Two Reflections | 1421 | 0.798314606741573
Chainer, Dementia Master | 317 | 0.798488664987406
Latulla, Keldon Overseer | 20 | 0.8
Squee, the Immortal | 24 | 0.8
Lady Sun | 8 | 0.8
Shimatsu the Bloodcloaked | 20 | 0.8
Xenagos, God of Revels | 1100 | 0.8
Kruphix, God of Horizons | 1103 | 0.800435413642961
Purphoros, God of the Forge | 718 | 0.801339285714286
Olivia Voldaren | 767 | 0.801462904911181
Medomai the Ageless | 154 | 0.802083333333333
Queen Marchesa | 1543 | 0.802392095683827
Tariel, Reckoner of Souls | 394 | 0.80244399185336
Balan, Wandering Knight | 114 | 0.802816901408451
Crosis, the Purger | 224 | 0.802867383512545
Yore-Tiller Nephilim | 45 | 0.803571428571429
Krav, the Unredeemed | 86 | 0.803738317757009
Rakdos the Defiler | 115 | 0.804195804195804
Thraximundar | 686 | 0.8042203985932
Anowon, the Ruin Sage | 186 | 0.805194805194805
Ishai, Ojutai Dragonspeaker | 434 | 0.805194805194805
Sapling of Colfenor | 178 | 0.805429864253394
Tasigur, the Golden Fang | 1513 | 0.805644302449414
Grand Arbiter Augustin IV | 923 | 0.806818181818182
Adamaro, First to Desire | 46 | 0.807017543859649
Braids, Conjurer Adept | 335 | 0.807228915662651
Maelstrom Wanderer | 1135 | 0.808404558404558
Darien, King of Kjeldor | 376 | 0.808602150537634
Oketra the True | 89 | 0.809090909090909
Bosh, Iron Golem | 140 | 0.809248554913295
Padeem, Consul of Innovation | 205 | 0.810276679841897
Derevi, Empyrial Tactician | 1684 | 0.810784785748676
Commander Eesha | 30 | 0.810810810810811
Roon of the Hidden Realm | 1289 | 0.811712846347607
Mayael the Anima | 1203 | 0.811740890688259
Kazarov, Sengir Pureblood | 13 | 0.8125
Varchild, Betrayer of Kjeldor | 13 | 0.8125
Archangel Avacyn | 335 | 0.813106796116505
Zo-Zu the Punisher | 244 | 0.813333333333333
Mathas, Fiend Seeker | 267 | 0.814024390243902
Karrthus, Tyrant of Jund | 346 | 0.814117647058824
Pir, Imaginative Rascal | 79 | 0.814432989690722
Mogis, God of Slaughter | 646 | 0.814627994955864
Brion Stoutarm | 409 | 0.814741035856574
Nezahal, Primal Tide | 44 | 0.814814814814815
Gyrus, Waker of Corpses | 22 | 0.814814814814815
Jor Kadeen, the Prevailer | 302 | 0.816216216216216
Urabrask the Hidden | 98 | 0.816666666666667
The Mimeoplasm | 1129 | 0.817523533671253
Commander Greven il-Vec | 9 | 0.818181818181818
Slinn Voda, the Rising Deep | 18 | 0.818181818181818
Nicol Bolas, the Ravager | 173 | 0.819905213270142
Zur the Enchanter | 1450 | 0.820135746606335
Dragonlord Silumgar | 187 | 0.820175438596491
Bruna, Light of Alabaster | 741 | 0.820598006644518
Lorthos, the Tidemaker | 115 | 0.821428571428571
Skyfire Kirin | 23 | 0.821428571428571
Kumano, Master Yamabushi | 60 | 0.821917808219178
Teysa, Orzhov Scion | 748 | 0.822882288228823
Daxos the Returned | 890 | 0.823311748381129
Kess, Dissident Mage | 767 | 0.823845327604726
Jhoira of the Ghitu | 1072 | 0.824615384615385
Muldrotha, the Gravetide | 738 | 0.825503355704698
Ephara, God of the Polis | 507 | 0.825732899022801
Varina, Lich Queen | 100 | 0.826446280991736
Vial Smasher the Fierce | 115 | 0.827338129496403
Akiri, Line-Slinger | 563 | 0.827941176470588
Nin, the Pain Artist | 361 | 0.827981651376147
Grenzo, Havoc Raiser | 330 | 0.829145728643216
Arcanis the Omnipotent | 267 | 0.829192546583851
Hazoret the Fervent | 107 | 0.829457364341085
Okaun, Eye of Chaos | 88 | 0.830188679245283
Sedris, the Traitor King | 436 | 0.83047619047619
Kami of the Crescent Moon | 208 | 0.832
Eight-and-a-Half-Tails | 304 | 0.832876712328767
Zhang He, Wei General | 5 | 0.833333333333333
Sunastian Falconer | 15 | 0.833333333333333
Naru Meha, Master Wizard | 20 | 0.833333333333333
Niv-Mizzet, the Firemind | 918 | 0.835304822565969
Kydele, Chosen of Kruphix | 807 | 0.835403726708075
Damia, Sage of Stone | 1051 | 0.835453100158983
Taniwha | 61 | 0.835616438356164
Jeleva, Nephalia's Scourge | 967 | 0.836505190311419
Uyo, Silent Prophet | 41 | 0.836734693877551
Zuberi, Golden Feather | 41 | 0.836734693877551
Nicol Bolas | 575 | 0.836972343522562
Fumiko the Lowblood | 72 | 0.837209302325581
Teferi, Mage of Zhalfir | 201 | 0.8375
Licia, Sanguine Tribune | 227 | 0.837638376383764
Lyra Dawnbringer | 47 | 0.839285714285714
Marchesa, the Black Rose | 1510 | 0.839355197331851
Lord Windgrace | 263 | 0.840255591054313
Narset, Enlightened Master | 1701 | 0.84083044982699
Ob Nixilis of the Black Oath | 212 | 0.841269841269841
Patron of the Moon | 181 | 0.841860465116279
Myojin of Infinite Rage | 16 | 0.842105263157895
Dragonlord Ojutai | 342 | 0.842364532019704
Mairsil, the Pretender | 343 | 0.842751842751843
Oona, Queen of the Fae | 763 | 0.843093922651934
The Scorpion God | 366 | 0.84331797235023
Hixus, Prison Warden | 38 | 0.844444444444444
Drana, Kalastria Bloodchief | 315 | 0.844504021447721
Brago, King Eternal | 1880 | 0.844564240790656
Captain Sisay | 736 | 0.845005740528129
Myojin of Seeing Winds | 11 | 0.846153846153846
Hisoka, Minamo Sensei | 11 | 0.846153846153846
Tana, the Bloodsower | 262 | 0.84789644012945
Heartless Hidetsugu | 290 | 0.847953216374269
Erebos, God of the Dead | 516 | 0.848684210526316
Djeru, With Eyes Open | 51 | 0.85
Ashling, the Extinguisher | 51 | 0.85
Thrasios, Triton Hero | 630 | 0.850202429149798
Gorm the Great | 23 | 0.851851851851852
Ezuri, Claw of Progress | 1668 | 0.851889683350358
Aurelia, the Warleader | 728 | 0.852459016393443
Atraxa, Praetors' Voice | 4279 | 0.853070175438597
Vish Kal, Blood Arbiter | 245 | 0.853658536585366
Yahenni, Undying Partisan | 392 | 0.854030501089325
Mirri, Weatherlight Duelist | 231 | 0.855555555555556
Yuriko, the Tiger's Shadow | 184 | 0.855813953488372
Ghoulcaller Gisa | 606 | 0.855932203389831
Oloro, Ageless Ascetic | 2614 | 0.856207009498854
Gisela, Blade of Goldnight | 707 | 0.856969696969697
Yuan Shao, the Indecisive | 6 | 0.857142857142857
Neheb, the Eternal | 545 | 0.858267716535433
Pia and Kiran Nalaar | 49 | 0.859649122807018
Dralnu, Lich Lord | 358 | 0.860576923076923
Akroma, Angel of Fury | 68 | 0.860759493670886
Rowan Kenrith | 63 | 0.863013698630137
Kothophed, Soul Hoarder | 70 | 0.864197530864197
Taigam, Ojutai Master | 206 | 0.865546218487395
Gonti, Lord of Luxury | 629 | 0.866391184573003
Sai, Master Thopterist | 65 | 0.866666666666667
Yidris, Maelstrom Wielder | 2131 | 0.867671009771987
Hanna, Ship's Navigator | 446 | 0.867704280155642
Sakashima the Impostor | 164 | 0.867724867724868
Prossh, Skyraider of Kher | 1697 | 0.868030690537084
The Scarab God | 1013 | 0.868037703513282
Elesh Norn, Grand Cenobite | 231 | 0.868421052631579
Sheoldred, Whispering One | 358 | 0.868932038834951
Bruna, the Fading Light | 199 | 0.868995633187773
Mizzix of the Izmagnus | 1615 | 0.869214208826695
Unesh, Criosphinx Sovereign | 297 | 0.870967741935484
Azami, Lady of Scrolls | 967 | 0.871171171171171
Thada Adel, Acquisitor | 176 | 0.871287128712871
Sydri, Galvanic Genius | 979 | 0.871772039180766
Edgar Markov | 1330 | 0.872131147540984
Silas Renn, Seeker Adept | 198 | 0.872246696035242
Nahiri, the Lithomancer | 454 | 0.873076923076923
Razaketh, the Foulblooded | 187 | 0.873831775700935
Nekusar, the Mindrazer | 2346 | 0.874394334699963
Lu Xun, Scholar General | 49 | 0.875
Zahid, Djinn of the Lamp | 7 | 0.875
Thantis, the Warweaver | 42 | 0.875
Diaochan, Artful Beauty | 92 | 0.876190476190476
Zirilan of the Claw | 200 | 0.87719298245614
Empress Galina | 93 | 0.877358490566038
Meren of Clan Nel Toth | 2999 | 0.877927400468384
Xantcha, Sleeper Agent | 94 | 0.878504672897196
Kaalia of the Vast | 2074 | 0.88067940552017
Akroma, Angel of Wrath | 60 | 0.882352941176471
Sun Quan, Lord of Wu | 92 | 0.884615384615385
Sen Triplets | 1013 | 0.887040280210158
Jin-Gitaxias, Core Augur | 150 | 0.887573964497041
Rasputin Dreamweaver | 103 | 0.887931034482759
Firesong and Sunspeaker | 184 | 0.888888888888889
Godo, Bandit Warlord | 121 | 0.889705882352941
The Locust God | 1006 | 0.891054030115146
Venser, Shaper Savant | 90 | 0.891089108910891
Norin the Wary | 419 | 0.891489361702128
Memnarch | 435 | 0.893223819301848
The Ur-Dragon | 844 | 0.895015906680806
Avacyn, Angel of Hope | 536 | 0.897822445561139
Etali, Primal Storm | 115 | 0.8984375
Feldon of the Third Path | 522 | 0.898450946643718
Xiahou Dun, the One-Eyed | 151 | 0.898809523809524
Starke of Rath | 56 | 0.903225806451613
Arixmethes, Slumbering Isle | 58 | 0.90625
Mishra, Artificer Prodigy | 301 | 0.906626506024096
Sharuum the Hegemon | 1039 | 0.906631762652705
Inalla, Archmage Ritualist | 699 | 0.907792207792208
Arjun, the Shifting Flame | 454 | 0.908
Hope of Ghirapur | 257 | 0.908127208480565
Kiki-Jiki, Mirror Breaker | 252 | 0.909747292418773
Gisela, the Broken Blade | 51 | 0.910714285714286
Traxos, Scourge of Kroog | 51 | 0.910714285714286
Slobad, Goblin Tinkerer | 121 | 0.916666666666667
Nazahn, Revered Bladesmith | 233 | 0.917322834645669
Karn, Silver Golem | 356 | 0.917525773195876
Kokusho, the Evening Star | 67 | 0.917808219178082
Daretti, Scrap Savant | 1194 | 0.920585967617579
Kalemne, Disciple of Iroas | 445 | 0.921325051759834
Arcum Dagsson | 414 | 0.924107142857143
Hokori, Dust Drinker | 105 | 0.929203539823009
Muzzio, Visionary Architect | 342 | 0.929347826086957
Breya, Etherium Shaper | 3131 | 0.92990792990793
Jhoira, Weatherlight Captain | 359 | 0.930051813471503
Yennett, Cryptic Sovereign | 80 | 0.930232558139535
Barrin, Master Wizard | 55 | 0.932203389830508
Teferi, Temporal Archmage | 655 | 0.933048433048433
Aminatou, the Fateshifter | 274 | 0.935153583617747
Chandler | 15 | 0.9375
Brudiclad, Telchor Engineer | 122 | 0.938461538461538
Kozilek, the Great Distortion | 595 | 0.939968404423381
Emrakul, the Promised End | 251 | 0.940074906367041
Ulamog, the Ceaseless Hunger | 274 | 0.944827586206897
Kozilek, Butcher of Truth | 277 | 0.965156794425087
Ulamog, the Infinite Gyre | 63 | 0.969230769230769
Saheeli, the Gifted | 165 | 0.993975903614458
Dr. Julius Jumblemorph | 2 | 1
Grusilda, Monster Masher | 4 | 1
Iizuka the Ruthless | 7 | 1
Tarox Bladewing | 2 | 1
Sylvia Brightspear | 1 | 1
Sidar Jabari | 5 | 1
Zndrsplt, Eye of Wisdom | 1 | 1
Zuo Ci, the Mocking Sage | 2 | 1
Zuo Ci, the Mocking Sage | 2 | 1
Verix Bladewing | 2 | 1
Phoebe, Head of S.N.E.A.K. | 3 | 1
Baron Von Count | 8 | 1
Lu Su, Wu Advisor | 1 | 1
Tawnos, Urza's Apprentice | 17 | 1
Liu Bei, Lord of Shu | 2 | 1
Gallowbraid | 4 | 1
Zhou Yu, Chief Commander | 3 | 1
Gosta Dirk | 1 | 1
Will Kenrith | 2 | 1
Rashida Scalebane | 2 | 1
Zetalpa, Primal Dawn | 9 | 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment