From DoomWiki.org

< User:Xymph
Revision as of 04:43, 2 June 2020 by Xymph (talk | contribs) (The list: add Compet-n demo counts, borders between sites)

Matching and linking speedrunners

When collecting information about speedrunners for their wiki articles, the first problem encountered is that quite a few players go by a variety of names/aliases between the wiki and the former and current Compet-n and DSDA sites, and that the demo sites use different identification systems.

To match them all up, I created a (single-table) database on my home server, with scripts to fill it. Initially all entries in the speedrunners category were loaded, then scripts for each of the demo sites matched up names/aliases and, upon manual verification/approval, added their names, IDs and profile status to the table.

  • For former Compet-n, a pre-formatted text listing of the players list was used.
  • For current Compet-n, Fx kindly provides read-only MySQL access.
  • For former and current DSDA, the HTML player pages were parsed into SimpleXML objects that could then be traversed.

A listing script produces the table below. Please let me know if you spot any mismatches.

From the table the speedrunners' external links sections will be verified/updated/added, and it will help in compiling record tables for maps and players.

The list

The table below matches speedrunner articles with their entries on the demo sites (state of 2020-06-02 04:41 CDT).

Path Old Compet-n New Compet-n Old DSDA New DSDA
ID Name ID Profile Demos Name ID Profile Demos Name ID Demos
Adam Hegyi adam Adam 'Adamh' Hegyi 1 Yes 528 Adam Hegyi 45 (archived 🏛) 0 Adam Hegyi adam_hegyi 0
Adam Landefeld Adam Landefeld 113 (archived 🏛) 0 Adam Landefeld adam_landefeld 0
Adam Williamson adamw Adam 'Adamw' Williamson 2 Yes 322 Adam Williamson 46 (archived 🏛) Yes (archived 🏛) 0 Adam Williamson adam_williamson 0
Adam Woodmansey (Khorus) Khorus 396 (archived 🏛) 0 Khorus khorus 0
Adolf Vojta (Gusta) vojta Adolf 'Gusta' Vojta 136 Yes 25 Gusta 82 (archived 🏛) 0 Gusta gusta 0
Albert Valls (Vrooomer) Albert 'Vrooomer' Valls 132 6 Albert Valls 13 (archived 🏛) Yes (archived 🏛) 0 Albert Valls albert_valls 0
Aleks Shahov (Plut) Plut 407 (archived 🏛) 0 Plut plut 0
Aleksey Kamenev (4shockblast) Aleksey '4shockblast' Kamenev 226 13 4shockblast 430 (archived 🏛) 0 4shockblast 4shockblast 0
Alexis Jeanson (Roofi) Roofi 594 (archived 🏛) 0 Roofi roofi 0
Anders Johnsen anders Anders 'Anders' Johnsen 5 Yes 331 Anders Johnsen 48 (archived 🏛) 0 Anders Johnsen anders_johnsen 0
Andrea Rovenski (Cyberdemon531) Cyberdemon531 484 (archived 🏛) 0 Cyberdemon531 cyberdemon531 0
Andreas Kren (Anthe) anthe Andreas 'Kren' Kren 80 142 Andreas Kren 234 (archived 🏛) 0 Andreas Kren andreas_kren 0
Andrew Bassett (AndrewB) andrew Andrew 'Andrewb' Bassett 6 Yes 20 Andrew Bassett 254 (archived 🏛) 0 Andrew Bassett andrew_bassett 0
Andrew Rehberger (Malinku) Malinku 260 (archived 🏛) 0 Malinku malinku 0
Andrew Stine (Linguica) Linguica 567 (archived 🏛) 0 Linguica linguica 0
Andrey Budko (entryway) Andrey 'Budko' Budko 20 12 Andrey Budko 56 (archived 🏛) 0 Andrey Budko andrey_budko 0
Andy Badorek Andy 'Badorek' Badorek 12 33 Andy Badorek 140 (archived 🏛) 0 Andy Badorek andy_badorek 0
Andy Kempling (aurikan) Andy 'Kempling' Kempling 75 41 Andy Kempling 88 (archived 🏛) 0 Andy Kempling andy_kempling 0
Andy Leaver (FearKeeper) Andy Leaver 275 (archived 🏛) 0 Andy Leaver andy_leaver 0
Andy Olivera Andy 'Olivera' Olivera 98 4 Andy Olivera 59 (archived 🏛) Yes (archived 🏛) 0 Andy Olivera andy_olivera 0
Andy Stewart (eschdoom) eschdoom 264 (archived 🏛) 0 eschdoom eschdoom 0
Anthony Soto (Swedish Fish) soto Anthony 'Soto' Soto 122 Yes 72 Anthony Soto 21 (archived 🏛) 0 Anthony Soto anthony_soto 0
Arnaud Florian (Oxyde) Arnaud 'PenumbraSix' Florian 243 0 Oxyde 496 (archived 🏛) 0 Oxyde oxyde 0
BeeWen BeeWen 421 (archived 🏛) 0 BeeWen beewen 0
bemused bemused 670 (archived 🏛) 0 bemused bemused 0
Benjogami Benjogami 603 (archived 🏛) 0 Benjogami benjogami 0
Blake Collins (Rayzik) Rayzik 516 (archived 🏛) 0 Rayzik rayzik 0
Boris Klimeš (dew) Boris 'dew' Klimeš 231 0 dew 217 (archived 🏛) 0 dew dew 0
Brad Spencer (Vorpal) Brad 'Vorpal' Spencer 204 2 Brad Spencer 19 (archived 🏛) 0 Brad Spencer brad_spencer 0
Brayden Hart (AD 79) AD_79 530 (archived 🏛) 0 AD_79 ad_79 0
Brett Harrell (Mechadon) Mechadon 238 (archived 🏛) 0 Mechadon mechadon 0
Brian Knox (Snakes) Snakes 276 (archived 🏛) 0 Snakes snakes 0
Carlos Guariglia Carlos Guariglia 75 (archived 🏛) 0 Carlos Guariglia carlos_guariglia 0
Casey Alvis (Altima Mantoid) casey Casey 'Altima Mantoid' Alvis 21 Yes 212 Altima Mantoid 47 (archived 🏛) 0 Altima Mantoid altima_mantoid 0
ChaingunnerX Chaingunner 486 (archived 🏛) 0
Chris Bourke (purist) Purist 443 (archived 🏛) 0 Purist purist 0
Chris Laverdure (Dashiva) dashiva Chris 'Dashiva' Laverdure 31 Yes 34 Dashiva 4 (archived 🏛) 0 Dashiva dashiva 0
Chris Ratcliff (Ryback) chris Chris 'Ryback' Ratcliff 25 Yes 292 Ryback 34 (archived 🏛) 0 Ryback ryback 0
Christian Lian (darkreaver) darkreaver 336 (archived 🏛) 0 darkreaver darkreaver 0
Christopher Shepherd (ArmouredBlood) ArmouredBlood 267 (archived 🏛) 0 ArmouredBlood armouredblood 0
Cody Stirm (Butts) Butts 239 (archived 🏛) 0 Butts butts 0
Daniel Jakobsson (dannebubinga) dannebubinga 341 (archived 🏛) 0 dannebubinga dannebubinga 0
Daniel Lindgren (Demonlord) daniel Daniel 'Demonlord' Lindgren 29 Yes 385 Daniel Lindgren 124 (archived 🏛) 0 Daniel Lindgren daniel_lindgren 0
Dario Casali Dario Casali 100 (archived 🏛) 0 Dario Casali dario_casali 0
Darkwave0000 Darkwave0000 461 (archived 🏛) 0
David Ficenec (mr.twister) David 'mr.twister' Ficenec 130 17 Twister 199 (archived 🏛) 0 Twister twister 0
David Spring (Springy) David 'Springy' Spring 232 0 David Spring 435 (archived 🏛) Yes (archived 🏛) 0 David Spring david_spring 0
Dean Joseph (deathz0r) deathz0r 182 (archived 🏛) 0 deathz0r deathz0r 0
Death-Destiny Death-Destiny 205 (archived 🏛) 0 Death-Destiny death-destiny 0
Doug Merrill (Opulent) opulent Doug 'Opulent' Merrill 99 Yes 51 Opulent 1 (archived 🏛) Yes (archived 🏛) 0 Opulent opulent 0
Dr. Zin Dr. Zin 187 (archived 🏛) 0 Dr. Zin dr_zin 0
Drew DeVore (stx-Vile) drew Drew 'stx-Vile' DeVore 39 Yes 257 stx-Vile 35 (archived 🏛) 0 Vile vile 0
Elmle ELMLE 600 (archived 🏛) 0 ELMLE elmle 0
Eric Baker (The Green Herring) Eric 'The Green Herring' Baker 43 11 The Green Herring 176 (archived 🏛) 0 The Green Herring the_green_herring 0
Erik Alm Erik 'Alm' Alm 8 73 Erik Alm 9 (archived 🏛) Yes (archived 🏛) 0 Erik Alm erik_alm 0
Esa Repo (Espi) Esa 'Espi' Repo 205 1 Espi 49 (archived 🏛) 0 Espi espi 0
Esko Koskimaa esko Esko 'esko' Koskimaa 46 Yes 20 Esko Koskimaa 119 (archived 🏛) 0 Esko Koskimaa esko_koskimaa 0
Fonze Fonze 561 (archived 🏛) 0 Fonze fonze 0
Franck Livolant (franckFRAG) franckFRAG 533 (archived 🏛) 0 franckFRAG franckfrag 0
Fredrik Johansson Fredrik Johansson 96 (archived 🏛) 0 Fredrik Johansson fredrik_johansson 0
Gene Bird Gene Bird 76 (archived 🏛) 0 Gene Bird gene_bird 0
George Bell George 'Bell' I. Bell 15 0 George Bell 133 (archived 🏛) 0 George Bell george_bell 0
Gggmork gggmork 221 (archived 🏛) 0 gggmork gggmork 0
Gonzalo Pérez de la Ossa Gonzalo Perez de la Ossa 158 (archived 🏛) 0 Gonzalo Perez de la Ossa gonzalo_perez_de_la_ossa 0
Graham Burgess (Grazza) Grazza 31 (archived 🏛) Yes (archived 🏛) 0 Grazza grazza 0
Gus Knezevich (Alfonzo) Alfonzo 483 (archived 🏛) 0 Alfonzo alfonzo 0
Gwyn Williams Gwyn Williams 167 (archived 🏛) 0 Gwyn Williams gwyn_williams 0
Henning Skogstø henning Henning 'Henning' Skogsto 61 Yes 254 Henning Skogsto 54 (archived 🏛) 0 Henning Skogsto henning_skogsto 0
Huy Pham (Doom Marine) Huy Pham 105 (archived 🏛) 0 Huy Pham huy_pham 0
Ian Cunnings (The Flange Peddler) Ian Cunnings 132 (archived 🏛) 0 Ian Cunnings ian_cunnings 0
Iikka Keränen (Fingers) Iikka Keranen 143 (archived 🏛) 0 Iikka Keranen iikka_keranen 0
Ilya Lazarev (joe-ilya) Joe-Ilya 462 (archived 🏛) Yes (archived 🏛) 0 Joe-Ilya joe-ilya 0
Istvan Pataki istvan Istvan 'Istvan' Pataki 64 Yes 147 Istvan Pataki 109 (archived 🏛) 0 Istvan Pataki istvan_pataki 0
J4rio J4rio 'j4rio' 166 17 j4rio 287 (archived 🏛) 0 j4rio j4rio 0
Jacek Dobrzyniecki (JudgeDeadd) JudgeDeadd 466 (archived 🏛) 0 JudgeDeadd judgedeadd 0
Jakub Razák Jakub 'Method_man' Razak 89 94 Method 126 (archived 🏛) 0 Method method 0
Jan Engelhardt (Hirogen2) hirogen2 418 (archived 🏛) 0 hirogen2 hirogen2 0
Jason Henry Jason 'Jason' Henry 69 7 Jason Henry 50 (archived 🏛) 0 Jason Henry jason_henry 0
Jason Masihdas (Amaster) Jason Masihdas 65 (archived 🏛) 0 Jason Masihdas jason_masihdas 0
Jason Root (Hellbent) Jason Root 145 (archived 🏛) 0 Jason Root jason_root 0
Jazz Mickle (jmickle) jmickle 515 (archived 🏛) 0 jmickle jmickle 0
Jean-Charles Dorne (JCD) JC 'JC' Dorne 150 22 JC 196 (archived 🏛) 0 JCD jcd 0
Jim Leonard (Xit Vono) vono Jim 'Xit Vono' Leonard 137 Yes 1095 Xit Vono 3 (archived 🏛) 0 Xit Vono xit_vono 0
Jochen Schneidau (Angus) Jochen 'Angus' Schneidau 65 9 Angus 10 (archived 🏛) 0 Angus angus 0
Joe Abene (DOOMMANN) joe Joe 'DOOMMANN' Abene 71 Yes 25 Joe Abene 367 (archived 🏛) 0 Joe Abene joe_abene 0
Jonas Feragen (Chrozoron) Jonas 'Chrozoron' Feragen 200 5 Chrozoron 89 (archived 🏛) 0 Chrozoron chrozoron 0
Jonathan Rimmer jonathan Jonathan 'Jonathan' Rimmer 72 Yes 65 Jonathan Rimmer 171 (archived 🏛) 0 Jonathan Rimmer jonathan_rimmer 0
Joonas Äijälä (Jodwin) Jodwin 236 (archived 🏛) 0 Jodwin jodwin 0
Josh Martel (Null) Null 429 (archived 🏛) 0 Null null 0
Josh Sealy (Joshy) Josh Sealy 237 (archived 🏛) 0 Josh Sealy josh_sealy 0
Joshua O'Sullivan (Dragonfly) Dragonfly 671 (archived 🏛) 0 Dragonfly dragonfly 0
Juho Ruohonen (ocelot) Juho 'ocelot' Ruohonen 96 34 Ocelot 6 (archived 🏛) 0 Ocelot ocelot 0
Justin Kelly (Breezeep) Breezeep 526 (archived 🏛) 0 Breezeep breezeep 0
Kai-Uwe Humpert (Gazelle) kai Kai-Uwe 'Gazelle' Humpert 73 Yes 255 Kai-Uwe Humpert 111 (archived 🏛) 0 Kai-Uwe Humpert kai-uwe_humpert 0
Kara Rader (Nanami) Kara Rader 118 (archived 🏛) 0 Kara Rader kara_rader 0
Kevin Reay (Magikal) Magikal 30 (archived 🏛) 0 Magikal magikal 0
Kieran Millar (Melon) Kieran Millar 361 (archived 🏛) 0 Kieran Millar kieran_millar 0
Killer5 Killer5 554 (archived 🏛) Yes (archived 🏛) 0 Killer5 killer5 0
Kim Bach (Torn) Kim 'Torn' Bach 168 7 Kim "Torn" Bach 106 (archived 🏛) 0 Kim "Torn" Bach kim_torn_bach 0
Ledmeister Ledmeister 71 (archived 🏛) 0 Ledmeister ledmeister 0
Lee Szymanski Lee Szymanski 107 (archived 🏛) 0 Lee Szymanski lee_szymanski 0
Looper Looper 'looper' 84 60 Looper 295 (archived 🏛) Yes (archived 🏛) 0 Looper looper 0
M. Phoenix Dailey (Archy) M. 'Archy' Phoenix Dailey 155 Yes 75 Archy 261 (archived 🏛) 0 Archy archy 0
Malcolm Sailor Malcolm Sailor 87 (archived 🏛) 0 Malcolm Sailor malcolm_sailor 0
Marijo Sedlić (Sedlo) sedlo Marijo 'Sedlo' Sedlić 85 Yes 173 Sedlo 53 (archived 🏛) 0 Sedlo sedlo 0
Martin Friberg (Cocoon) Martin Friberg 78 (archived 🏛) 0 Martin Friberg martin_friberg 0
Matt Cibulas (RottKing) RottKing 293 (archived 🏛) 0 RottKing rottking 0
Matt Powell (cannonball) Cannonball 364 (archived 🏛) Yes (archived 🏛) 0 Cannonball cannonball 0
Matthias Worch Matthias Worch 142 (archived 🏛) 0 Matthias Worch matthias_worch 0
Mattias Berggren Mattias Berggren 120 (archived 🏛) 0 Mattias Berggren mattias_berggren 0
Memfis Memfis 319 (archived 🏛) 0 Memfis memfis 0
Mephisto Mephisto 155 (archived 🏛) 0 Mephisto mephisto 0
Michael Grube (migru) Michael Grube 112 (archived 🏛) 0 Michael Grube michael_grube 0
Michael Jan Krizik (valkiriforce) Michael Jan Krizik 639 (archived 🏛) 0 Michael Jan Krizik michael_jan_krizik 0
Michael Krause Michael Krause 42 (archived 🏛) 0 Michael Krause michael_krause 0
Michael Reid (prower) Mike 'prower' Reid 109 5 Mike Reid 134 (archived 🏛) 0 Mike Reid mike_reid 0
Mike Alfredson (Use3D) Use3d 81 (archived 🏛) 0 Use3d use3d 0
NaZa DoomLover234 568 (archived 🏛) 0 DoomLover234 doomlover234 0
NoisyVelvet NoisyVelvet 606 (archived 🏛) 0 NoisyVelvet noisyvelvet 0
Owen Lloyd (Sarge Baldy) Sarge Baldy 179 (archived 🏛) 0 Sarge Baldy sarge_baldy 0
Patrick Martin Patrick 'Martin' Martin 87 33 Patrick Martin 123 (archived 🏛) 0 Patrick Martin patrick_martin 0
Paul Falstad Paul 'falstad' Falstad 49 5 Paul Falstad 38 (archived 🏛) 0 Paul Falstad paul_falstad 0
Paul Hiebert (Creaphis) Creaphis 242 (archived 🏛) 0 Creaphis creaphis 0
Peo Sjöblom peo Peo 'Peo' Sjoblom 104 Yes 279 Peo Sjoblom 98 (archived 🏛) 0 Peo Sjoblom peo_sjoblom 0
Philnemba Philnemba 283 (archived 🏛) 0 Philnemba philnemba 0
Phml Philip 'Phil' Renshaw 175 2 Phml 266 (archived 🏛) 0 Phml phml 0
Przemysław Woda (Belial) Przemysław 'Belial' Woda 169 4 Belial 90 (archived 🏛) 0 Belial belial 0
Qingshuo Wang (piXel reX) Qingshuo Wang 103 (archived 🏛) 0 Qingshuo Wang qingshuo_wang 0
Radek Pecka radek Radek 'Radek' Pecka 112 Yes 481 Radek Pecka 52 (archived 🏛) 0 Radek Pecka radek_pecka 0
Ralph Vickers (Ralphis) Ralph Vickers 63 (archived 🏛) 0 Ralph Vickers ralph_vickers 0
RestlessRodent GhostlyDeath 399 (archived 🏛) 0 GhostlyDeath ghostlydeath 0
Revved Revved 'Revved' 152 107 Revved 259 (archived 🏛) 0 Revved revved 0
Richard Hardacre (Cycloid) Cycloid 27 (archived 🏛) Yes (archived 🏛) 0 Cycloid cycloid 0
Richard J. Sham Richard 'Sham' J. Sham 120 2 Rich J. Sham 33 (archived 🏛) 0 Rich J. Sham rich_j_sham 0
Rob Young (RjY) RjY 26 (archived 🏛) 0 RjY rjy 0
Roger Moraga Roger Moraga 135 (archived 🏛) 0 Roger Moraga roger_moraga 0
Rudy Jurjako (Hellcat) Rudy 'Rudy' Jurjako 116 18 Rudy Jurjako 62 (archived 🏛) 0 Rudy Jurjako rudy_jurjako 0
scifista42 scifista42 558 (archived 🏛) 0
Scotty (mapper) Scotty 620 (archived 🏛) 0 Scotty scotty 0
Sebastian Graham (General Rainbow Bacon) DoomHero85 271 (archived 🏛) 0 DoomHero85 doomhero85 0
Seongbae Park (antares031) antares031 686 (archived 🏛) 0 antares031 antares031 0
Shadowman Shadowman 436 (archived 🏛) 0 Shadowman shadowman 0
Simon Broadhead (VolteFace) VolteFace 139 (archived 🏛) 0 VolteFace volteface 0
Simon Widlake Simon 'Widlake' Widlake 143 79 Simon Widlake 344 (archived 🏛) 0 Simon Widlake simon_widlake 0
Spectre01 Spectre01 595 (archived 🏛) 0 Spectre01 spectre01 0
Steffen Udluft (Rini) rini Steffen 'Rini' Udluft 115 Yes 194 Steffen Udluft 363 (archived 🏛) 0 Steffen Udluft steffen_udluft 0
Stephen Clark (The Ultimate DooMer) Stephen Clark 116 (archived 🏛) 0 Stephen Clark stephen_clark 0
Sverre André Kvernmo (Cranium) Sverre Kvernmo 110 (archived 🏛) 0 Sverre Kvernmo sverre_kvernmo 0
T. Elliot Cannon (Myscha the Sled Dog) Myscha, the Sled Dog 101 (archived 🏛) 0 Myscha, the Sled Dog myscha_the_sled_dog 0
Tatsuya Ito (Tatsurd-cacocaco) Tatsuya 'Tatsurd-cacocaco' Ito 149 130 Tatsurd-cacocaco 178 (archived 🏛) 0 Tatsurd-cacocaco tatsurd_cacocaco 0
Thomas Kroppen (Poeppy) poeppy Thomas 'Poeppy' Kroppen 106 Yes 30 Thomas Kroppen 366 (archived 🏛) 0 Thomas Kroppen thomas_kroppen 0
TimeOfDeath Chris 'TimeOfDeath' Balch 230 0 TimeOfDeath 204 (archived 🏛) 0 TimeOfDeath timeofdeath 0
Tristan Clark (Eris Falling) Eris Falling 438 (archived 🏛) 0 Eris Falling eris_falling 0
Varun Abhirama Krishna Varun Abhirama 64 (archived 🏛) 0 Varun Abhirama varun_abhirama 0
Vdgg Vdgg 'vdgg' 151 154 vdgg 229 (archived 🏛) 0 vdgg vdgg 0
Vick Bobkov (Virgil the Doom Poet) Virgil 70 (archived 🏛) 0 Virgil virgil 0
Vincent Catalaá (Peroxyd) vincent Vincent 'PerOxyd' Catalaa 135 Yes 270 Vincent Catalaa 55 (archived 🏛) 0 Vincent Catalaa vincent_catalaa 0
Vladimir Bespalov (Demonologist) Demonologist 401 (archived 🏛) 0 Demonologist demonologist 0
Vladimir Monakhov (skepticist) Vladimir 'Vladimir' Monakhov 228 0 Skepticist 206 (archived 🏛) 0 Skepticist skepticist 0
Vladislav Baymurzin (ClumsyDoomer) ClumsyDoomer 331 (archived 🏛) 0 ClumsyDoomer clumsydoomer 0
Walter Confalonieri (daimon) Walter Confalonieri 536 (archived 🏛) 0 Walter Confalonieri walter_confalonieri 0
William Huber (WH-Wilou84) William Huber 240 (archived 🏛) Yes (archived 🏛) 0 William Huber william_huber 0
Yashar Garibzadeh (GeminI) Yashar 'GeminI' Garibzadeh 54 35 Yashar Garibzadeh 18 (archived 🏛) 0 Yashar Garibzadeh yashar_garibzadeh 0
Yonatan Donner yonatan Yonatan 'Zem' Donner 145 Yes 194 Yonatan Donner 11 (archived 🏛) 0 Yonatan Donner yonatan_donner 0
Zachary Stephens (Ribbiks) Ribbiks 424 (archived 🏛) 0 Ribbiks ribbiks 0
Zan-zan-zawa-veia Zan-zan-zawa-veia 537 (archived 🏛) 0 Zan-zan-zawa-veia zan-zan-zawa-veia 0
Zvonimir Bužanić (fx) zvonimir Zvonimir 'fx' Bužanić 42 Yes 57 Zvonimir Bužanić 215 (archived 🏛) Yes (archived 🏛) 0 Zvonimir Bužanić zvonimir_buzanic 0