Pro94
Veteran
Rubik's Clock WR (5.27) was set 527 days ago.
Odd WCA stats/ Stats request Thread
- Thread starter anders
- Start date
Robert-Y
Legend
This is kind of off topic but related to Japan Open: http://jrca.cc/modules/eguide/event.php?eid=53
If you look through the results by person: http://www.worldcubeassociation.org/results/c.php?byPerson=By+Person&competitionId=JapanOpen2013
You will notice that some competitors only competed in a few events, some competed but not even in Rubik's cube. I was wondering about the competing fees. It seems to me that every event costs 500 yen unless I mistranslated something. This is roughly over £3 or $5. Seems expensive but I guess it might be normal in Japan. Who knows, maybe that's actually cheap for them...
If you look through the results by person: http://www.worldcubeassociation.org/results/c.php?byPerson=By+Person&competitionId=JapanOpen2013
You will notice that some competitors only competed in a few events, some competed but not even in Rubik's cube. I was wondering about the competing fees. It seems to me that every event costs 500 yen unless I mistranslated something. This is roughly over £3 or $5. Seems expensive but I guess it might be normal in Japan. Who knows, maybe that's actually cheap for them...
Stefan
Legend
Looks like it's the only one since removal of magics. And only one competition that had full podiums for the previously 19 events had fewer competitors:
http://www.worldcubeassociation.org/results/c.php?top3=Top+3&competitionId=SwedishChampionship2011
(77 competitors vs Japan's 83)
Though I'd call its fewest moves podium "overfull".
Code:
It's an ugly hack, don't look.
select aaa.competitionId, count(*), competitors from
(
SELECT competitionId, eventId, sum(if(best>0,1,0)) c
FROM `Results`
WHERE roundId in ('c','f')
group by competitionId, eventId
) aaa,
(select competitionId, count(distinct personId) competitors from Results group by competitionId) bbb
where aaa.competitionId=bbb.competitionId and c>=3
GROUP BY aaa.competitionId
order by 2 desc, 3Stefan
Legend
I think I vaguely remember a Japanese competition where they had a limit of four events per competitor. Maybe it was similar to that.
Ton
Veteran
- Joined
- Oct 17, 2007
- Messages
- 738
- Location
- Den Haag, The Netherlands
- WCA ID
- 2003DENN01
- YouTube
- Visit Channel
The Czech Open has always ALL events since 2009 and is also a 3 day competition!
2012 http://www.worldcubeassociation.org/results/c.php?top3=Top+3&competitionId=CzechOpen2012
2011 http://www.worldcubeassociation.org/results/c.php?top3=Top+3&competitionId=CzechOpen2011
etc
And Czech is a small competition around 50 each year
And yes 2013 will have all event, and we even will have medals for all events ....
Last edited:
MaeLSTRoM
Veteran
True, but for both of these, 3rd place in 5BLD doesn't have a result, it's DNF, so the podium isn't "full" which is what rob was asking about.
Pro94
Veteran
Cube Camp Kanazawa 2012 had full podium in 13 event (including 4-5 BLD) + Rubik's Clock and Square-1 where lots of people got a DNF avg. in finals.
http://worldcubeassociation.org/results/c.php?i=CubeCampKanazawa2012&allResults=1#clock
http://worldcubeassociation.org/results/c.php?i=CubeCampKanazawa2012&allResults=1#clock
Stefan
Legend
13 events is nowhere near all 19 events, though.
Faz
Former Clock NR Holder
- Joined
- Apr 24, 2008
- Messages
- 4,250
- Location
- Melbourne, Australia
- WCA ID
- 2009ZEMD01
- YouTube
- Visit Channel
Can someone make a list of most sub-2 2x2 singles? I'm curious
Lid
Veteran
I found 525 sub2 singles done by 226 persons:
By Country
Code:
Feliks Zemdegs 25 Australia
Cameron Stollery 23 Australia
Rowe Hessler 23 USA
Christopher Olson 22 USA
Micha? Pleskowicz 18 Poland
Mats Valk 14 Netherlands
Yinghao Wang (???) 14 China
Justin Jaffray 13 Canada
Erik Akkersdijk 10 Netherlands
Code:
Cornelius Dieckmann 9 Germany
Milán Baticz 9 Hungary
Carlos Méndez García-Barroso 7 Spain
Andy Smith 6 USA
Anthony Brooks 6 USA
Dan Dzoan 6 USA
Nipat Charoenpholphant (??????? ???????????? 6 Thailand
Austin Reed 5 USA
Bill Wang 5 Canada
Edward Lin 5 USA
John Brechon 5 USA
Yu Nakajima (???) 5 Japan
Ben Whitmore 4 United King
Bence Barát 4 Hungary
Forte Shinko 4 Canada
Gabriel Dechichi Barbar 4 Brazil
Jayden McNeill 4 Australia
Louis Cormier 4 Canada
Micha? Robaczyk 4 Poland
Simon Westlund 4 Sweden
Timothy Sun 4 USA
Weixing Zhang (???) 4 China
Zhouheng Sun (???) 4 China
Antoine Piau 3 France
Asia Konvittayayotin (?????? ????????????) 3 Thailand
Eric Limeback 3 Canada
Justin Adsuara 3 USA
Kevin Guillaumond 3 France
Lee Kyeong-Sub (???) 3 Korea
Michael Young 3 USA
Philippe Virouleau 3 France
Tim Reynolds 3 USA
Yumu Tabuchi (????) 3 Japan
Andrea Lo Sardo 2 Italy
Arifumi Fushimi (????) 2 Japan
Daniel Sheppard 2 United King
Edouard Chambon 2 France
Erik Johnson 2 USA
Henrik Buus Aagaard 2 Denmark
Ivan Vynnyk (???? ??????) 2 Ukraine
Jakub Cabaj 2 Poland
Javier París 2 Spain
Jorge Castillo Matas 2 Spain
Kevin Zhou 2 USA
Kirk Nicklaus Manibuy 2 Indonesia
Lucas Garron 2 Germany
?ukasz Cia?o? 2 Poland
Marvin Llaneta 2 Philippines
Mateusz Fydrych 2 Poland
Mitchell Lane 2 USA
Niklas Spies 2 Germany
Nikolay Evdokimov 2 Russia
Oskar Åsbrink 2 Sweden
Patrick Jameson 2 USA
Péter Trombitás 2 Hungary
Qingbin Chen (???) 2 China
Ravi Fernando 2 USA
Richard Jay S. Apagar 2 Philippines
Rowan Kinneavy 2 United King
Sébastien Auroux 2 Germany
Steven Turner 2 USA
Thompson Clarke 2 Canada
Xiaofeng Zheng (???) 2 China
Yuxuan Wang (???) 2 China
Adrian Jorghy 1 Indonesia
Aksel Stadel Borum 1 Denmark
Albert Stanula 1 Poland
Alberto Pérez de Rada Fiol 1 Spain
Alexey Oblaukhov 1 Russia
Alfrisa Diva Wandana 1 Indonesia
Alvin Febrianth 1 Indonesia
Anders Bogan 1 USA
Andreas Pohl 1 Germany
Andrés Alfaro 1 Chile
Andrew Ricci 1 USA
Andy Bridger 1 USA
Antoine Cantin 1 Canada
Anton Bedrichenko 1 Russia
Anton Rostovikov 1 Russia
Arnaud van Galen 1 Netherlands
Auguste Olivry 1 France
Bob Burton 1 USA
Brock Hamann 1 Australia
Cameron Almasi 1 USA
Carl Thiringer 1 Sweden
Chengbiao Liu (???) 1 China
Chia-Wei Lu (???) 1 Taiwan
Christian Kaserer 1 Italy
Daniel Adrian López de Andrade 1 Brazil
Daniel Mazurek 1 Poland
Dániel Varga 1 Hungary
Daniel Wu 1 USA
Dario Roa Sánchez 1 Spain
David Gomes 1 USA
David Shi 1 USA
David Woner 1 USA
Devin Corr-Robinett 1 USA
Didier Batista Ferreira 1 Portugal
Dmitry Kryuzban 1 Russia
Dmitry Zvyagintsev 1 Russia
Ernie Pulchny 1 USA
Ethan Crislip 1 USA
Fandy Ramadhan Ganefianto 1 Indonesia
Filip Miazek 1 Poland
Filippo Brancaleoni 1 Italy
Frank Egan 1 USA
Frédéric Meinnel 1 France
Gabriel Guay 1 Canada
Gaël Servignat 1 France
Giovanni Tessari 1 Italy
Giulio Grammatica 1 Italy
Gonzalo Serrano 1 Chile
Guillain Potron 1 France
Gunnar Krig 1 Sweden
Hampus Hansson 1 Sweden
Haowei Fan (???) 1 China
Hendry Cahyadi 1 Indonesia
Jacco Krijnen 1 Netherlands
Jack Johnston 1 USA
Jacob Lange 1 Sweden
Jai Gambhir 1 Canada
Jakub Kipa 1 Poland
James Creswell 1 USA
Jan Bentlage 1 Germany
Javier Enrique Espinoza Grijalva 1 Mexico
Javier Martínez Bautista 1 Mexico
Jedrick Remonde 1 Philippines
Jessica Uribe 1 USA
Jiawen Wu (???) 1 China
John Edison Ubaldo 1 Philippines
John Tamanas 1 USA
Jonathan Esteban Rivera Castillón 1 Mexico
Jonathan Hamstad 1 Norway
Joon Cha 1 Korea
José Garrido 1 Chile
Joseph Dzaluk 1 USA
Jules Desjardin 1 France
Jules Manalang 1 USA
Kai Han (??) 1 China
Kai Liu (??) 1 China
Kailong Li (???) 1 China
Kanneti Sae Han (????????? ???????) 1 France
Kian Barry 1 USA
Kit Clement 1 USA
Kristian Muggerud 1 Norway
Laetitia Lemoine 1 France
Lars Van den broeck 1 Belgium
Lars Vennike Nielsson 1 Denmark
Loïc Petit 1 France
Lorenzo Vigani Poli 1 Italy
Louis Sarthou 1 France
?ukasz Cichecki 1 Poland
Maarten Smit 1 Netherlands
Maciej Dura?ski 1 Poland
Marcin Jakubowski 1 Poland
Marcin Zalewski 1 Poland
Mariusz Wi?niewski 1 Poland
Marwin-Peter Kurth 1 Germany
Matt DiPalma 1 USA
Matteo Provasi 1 Italy
Maxim Novikov 1 Russia
Michael Gottlieb 1 USA
Michael Nguyen 1 USA
Michael Perkins 1 USA
Micha? Matczak 1 Poland
Mike Kotch 1 USA
Morten Arborg 1 Norway
Muhammad Jihan Khalilurrahman 1 Indonesia
Neel Shah 1 Canada
Nicola Giordani 1 Italy
Nicolò Simone 1 Italy
Niko Ronkainen 1 Finland
Niño Francis Reyes 1 Philippines
Oscar Roth Andersen 1 Denmark
Paolo Girotti 1 Italy
Paolo Moriello 1 Italy
Pawe? W?oszek 1 Poland
Phil Thomas 1 USA
Piti Pichedpan (???? ???????????) 1 Thailand
Przemys?aw Kaleta 1 Poland
Quentin Lefebvre 1 France
Rashdaleena Athiefa Abdul Rashid 1 Malaysia
Rémi Esturoune 1 France
Robert Yau 1 United King
Rongjin Huang (???) 1 China
Sei Sugama (???) 1 Japan
Sergey Ryabko 1 Russia
Sergi Sabat 1 Spain
Shuto Ueno (????) 1 Japan
Sixuan Lou (???) 1 China
S?awomir Kapka 1 Poland
Sukesh Subaharan 1 India
Syuhei Omura (????) 1 Japan
Thomas Watiotienne 1 France
Tim Major 1 Australia
Ting Sheng Bao Yang 1 Spain
Tomasz Kaczorowski 1 Poland
Tomasz Kie?basa 1 Poland
Tse-Kan Lin (???) 1 Taiwan
Uriel Gayosso Ruiz 1 Mexico
Vegard Seim Karstang 1 Norway
Vicente Albíter Alpízar 1 Mexico
Vidar Klungre 1 Norway
Vincent Hartanto Utomo 1 Indonesia
Vincent Sheu 1 USA
Vishal Harpalani 1 USA
Walker Welch 1 USA
Wataru Hashimura (???) 1 Japan
Weimin Fang (???) 1 China
Weston Mizumoto 1 USA
Wonder Dygico 1 Philippines
Yan-Hung Lai (???) 1 Taiwan
Yinqin Li (???) 1 China
Yuhei Takagi (????) 1 Japan
Yui Tomita (????) 1 Japan
Yunsu Nam (???) 1 Korea
Zhou Yichen (???) 1 China
Code:
USA 134
Australia 54
Poland 43
China 39
Canada 35
Code:
Netherlands 27
France 23
Germany 18
Hungary 16
Japan 16
Spain 15
Italy 12
Sweden 10
Thailand 10
Indonesia 9
Russia 9
United Kingdom 9
Philippines 8
Brazil 5
Denmark 5
Korea 5
Mexico 5
Norway 5
Chile 3
Taiwan 3
Ukraine 2
Belgium 1
Finland 1
India 1
Malaysia 1
Portugal 1
TheNextFeliks
Veteran
Have there been any comps without only one event? If so which event? (I'm guessing multi or fmc)
JasonK
Premium Member
I would imagine there's been quite a few, but off the top of my head Australian Nationals 2012 had everything except feet.
kcl
Legend
In my 2^3 average at Worlds 2011, all three counting times were 6.06. The average was not very hard to compute
That's just plain awesome.
RCTACameron
Veteran
- Joined
- Jul 13, 2010
- Messages
- 1,597
- Location
- Melbourne, Australia
- WCA ID
- 2010STOL01
- YouTube
- Visit Channel
Wow, that's cool that I'm equal second.
And that Australia is second in the countries, only to the US which is so much bigger.I can't do queries or anything but I might as well add a hand generated list of most appearances in the 2x2 top 100 average results:
Code:
Rank Name Country Appearances
1 Christopher Olson USA 15
1 Cameron Stollery Australia 15
3 Feliks Zemdegs Australia 10
4 Michal Pleskowicz Poland 6
4 Justin Jaffray Canada 6
4 Rowe Hessler USA 6
7 Yinghao Wang China 5
8 Carlos Méndez García-BarrosoSpain 4
8 Mats Valk Netherlands 4
8 Edward Lin USA 4
8 Bill Wang Canada 4
11 Zhou Yichen China 3
12 Gabriel Dechichi Barbar Brazil 2
12 Qingbin Chen China 2
12 Yu Nakajima Japan 2
12 Lee Kyeong-Sub Korea 2
12 Bence Barát Hungary 2
12 Cornelius Dieckmann Netherlands 2
17 Dan Cohen USA 1
17 Ben Whitmore UK 1
17 Milán Baticz Hungary 1
17 John Brechon USA 1
17 Andy Smith USA 1
17 Nipat Charoenpholphant Thailand 1
17 Jayden McNeil Australia 1
Code:
Rank Country Appearances
1 USA 28
2 Australia 26
3 Canada 10
3 China 10
5 Poland 6
6 Netherlands 6
7 Spain 4
8 Hungary 3
9 Brazil 2
9 Japan 2
9 Korea 2
12 UK 1
12 Thailand 1Grr Australia is so close to #1. :/
It's amazing that 45% of the top 100 results are by just 3 people, and 54% are by just 2 countries.
Yeah, I basically did this because I knew me and Australia would be around the top. 
Edit: Can someone please make a list of top 1 or top 3 podiums for every event? So like this but with all events.
Last edited:
AvGalen
Premium Member
Without even reading anything about the topic at hand, I am going to make a wild guess:
Australia and NL
Faz, Mats+Erik
(coincidentally they both have roughly the same amount of people living there)
EMI
Veteran
Propably quite many. Everything except feet is relatively common I guess.
Username
Legend
It's about 2x2: USA (Chris) and Australia (Faz, Cameron)
Geert
Premium Member
I would like to see a list of competitors who could/would have witnessed the most world records.
(not taking into account that some comps are 2/3 days and someone may have only been to the comp for example on Sunday when the WR was set on Saturday)
I don't know if it's possible to exclude the person the set the WR, else Faz would probably be first place
(not taking into account that some comps are 2/3 days and someone may have only been to the comp for example on Sunday when the WR was set on Saturday)
I don't know if it's possible to exclude the person the set the WR, else Faz would probably be first place
Stefan
Legend
I would like to see a list of competitors who could/would have witnessed the most world records.
(not taking into account that some comps are 2/3 days and someone may have only been to the comp for example on Sunday when the WR was set on Saturday)
I don't know if it's possible to exclude the person the set the WR, else Faz would probably be first place
Top 100 (and Faz is 63rd place):
(whoa, after Lars the next six are from the Netherlands)
Code:
238 Lars Vandenbergh
230 Ton Dennenbroek
210 Ron van Bruchem
164 Arnaud van Galen
158 Jaap Scherphuis
154 Erik Akkersdijk
148 Joël van Noort
134 Bob Burton
130 Clément Gallet
130 Chris Hardwick
128 István Kocza
124 Anders Larsson
116 Frédérick Badie
114 Shotaro Makisumi (?????)
114 Dan Harris
110 Milán Baticz
108 Stefan Pochmann
106 Edouard Chambon
106 Shelley Chang
104 Lars Petrus
102 Leyan Lo
102 Frank Morris
102 Maria Oey
100 Jasmine Lee
96 Adam Zamora
92 Jean-Louis Mathieu
92 Rama Temmink
92 Olivér Nagy
90 Gilles van den Peereboom
88 Gunnar Krig
86 Guus Razoux Schultz
86 Peter Jansen
84 Kåre Krig
84 Tyson Mao (???)
82 Joey Gouly
80 Rune Wesström
80 Zbigniew Zborowski
78 Arjan Bosse
76 Tomasz Zolnowski
76 Henrik Buus Aagaard
76 François Courtès
74 Olivér Perge
74 Hans van der Zijden
74 Dror Vomberg
74 Gábor Szabó
72 Oliver Wolff
72 Ian Winokur
70 Tim Reynolds
70 Doug Li
70 Máté Horváth
68 Bertalan Bodor
68 Ryan Patricio
68 Koen Heltzel
68 Alexander Ooms
66 Keith Sauer
66 Bence Barát
66 Tommy Gustavsson
64 Mátyás Kuti
64 Masayuki Akimoto (????)
64 Mats Valk
62 Peter Still
62 Brent Morgan
60 Feliks Zemdegs
60 Sébastien Auroux
60 Michael Grimsley
58 Jason Baum
58 Markus Pirzer
58 Pawel Wloszek
58 Richard Patterson
56 Dave Campbell
56 Róbert Örkényi
56 Sinpei Araki (????)
56 Dan Dzoan
54 Tim McMahon
54 Sanio Kasumovic
54 Tim Major
54 Cameron Stollery
54 Thibaut Jacquinot
54 Zane Carney
54 Wiktoria Zborowska
52 Kirstine Buus Aagaard
52 Fumiki Koseki (????)
52 Ernesto Fernández Regueira
52 Yumu Tabuchi (????)
52 Dániel Varga
52 Michel Hop
52 Andy Camann
52 Takao Hashimoto (????)
52 Chris Krueger
52 Braden Helmer
52 Breandan Vallance
50 Clancy Cochran
50 Michal Halczuk
50 Oscar Roth Andersen
50 Jon Morris
50 Joe Allen
50 Lukasz Cialon
50 Hanneke Rijks
48 Michal Robaczyk
48 Brúnó Bereczki
SELECT sum(wrs) witnessed, personName FROM
(SELECT * FROM (SELECT competitionId, sum(if(regionalSingleRecord='WR',1,0)+if(regionalSingleRecord='WR',1,0)) wrs FROM Results GROUP BY competitionId) tmp WHERE wrs) a,
(SELECT distinct personName, personId, competitionId FROM Results) b
WHERE a.competitionId=b.competitionId
GROUP BY personId
ORDER BY witnessed desc
LIMIT 100Hippolyte!!!
Regular
Could someone make a ranking for the total of official solves ever done (by persons)? (we have that just by year in the WCA statistics)
Thanks!
EDIT: (well, we already knew, but this is quite impressive with this stat)
Thanks!
EDIT:
Top-7: a belgian ans 6 dutch people. We know were we have to travel to see WR
(well, we already knew, but this is quite impressive with this stat)
Last edited:
Similar threads
- Deleted member 36445
- General Speedcubing Discussion
