Odd WCA stats/ Stats request Thread

TiLiMayor · Nov 16, 2013

Hi, I wanted to know, how many competitions have been made without including 3x3x3?

RCTACameron · Nov 17, 2013

Could someone please make a list of the best 2x2 podiums (https://www.worldcubeassociation.org/results/statistics.php#podiums_3x3 but for 2x2.) I have a feeling I'll be in a few of them.

Bindedsa · Nov 17, 2013

What are the ratios between 3x3 and 4x4 times, also 3x3 and OH?

Pro94 · Nov 17, 2013

TiLiMayor said:
Hi, I wanted to know, how many competitions have been made without including 3x3x3?

41 (~2.54%). Taking in consideration the upcoming competitions, 1'575 have 3x3 out of a total of 1'616 competitions.

I also found another interesting thing: in 2011, China had 11 competitions including 3x3 Fewest Moves, and only 2 of them had also Rubik's Cube.

TDM · Nov 17, 2013

Bindedsa said:
What are the ratios between 3x3 and 4x4 times, also 3x3 and OH?

3x3 - 4x4
3x3 - OH

TheNextFeliks · Nov 17, 2013

What is the most common time for each event?

Nathan Dwyer · Nov 17, 2013

Who has the most sub-10 clock averages?

antoineccantin · Nov 17, 2013

Nathan Dwyer said:
Who has the most sub-10 clock averages?

You!

loljk

Lid · Nov 17, 2013

Nathan Dwyer said:
Who has the most sub-10 clock averages?

clock averages
---------------------------------
Total sub12avgs: 1018
Total sub11avgs: 674
Total sub10avgs: 404
Total sub9avgs: 202
Total sub8avgs: 48
Total sub7avgs: 2
---------------------------------

[TABLE="class:grid,align:left"]
[TR][TD]#[/TD][TD]Competitor[/TD][TD]Country[/TD][TD]subXs[/TD][/TR]
[TR][TD]1[/TD][TD]Javier Tirado Ortiz[/TD][TD]Spain[/TD][TD]36[/TD][/TR]
[TR][TD]2[/TD][TD]Daniel Sheppard[/TD][TD]United Kingdom[/TD][TD]30[/TD][/TR]
[TR][TD]3[/TD][TD]Laura Ohrndorf[/TD][TD]Germany[/TD][TD]28[/TD][/TR]
[TR][TD]4[/TD][TD]Marcin Jakubowski[/TD][TD]Poland[/TD][TD]22[/TD][/TR]
[TR][TD]5[/TD][TD]Maarten Smit[/TD][TD]Netherlands[/TD][TD]18[/TD][/TR]
[TR][TD]6[/TD][TD]Yu Sajima (佐島優)[/TD][TD]Japan[/TD][TD]17[/TD][/TR]
[TR][TD]7[/TD][TD]David Woner[/TD][TD]USA[/TD][TD]14[/TD][/TR]
[TR][TD]8[/TD][TD]Ernesto Fernández Regueira[/TD][TD]Spain[/TD][TD]13[/TD][/TR]
[TR][TD]9[/TD][TD]Evan Liu[/TD][TD]USA[/TD][TD]12[/TD][/TR]
[TR][TD]10[/TD][TD]Pierre Bouvier[/TD][TD]France[/TD][TD]12[/TD][/TR]
[TR][TD]11[/TD][TD]Sam Zhixiao Wang (王志骁)[/TD][TD]China[/TD][TD]11[/TD][/TR]
[/TABLE]

cubizh · Nov 17, 2013

Worst of the Best
The following tables shows the NR holders of the top 20 sum of rank countries with worst ranking in the event they hold that record.
Data from Nov 16th export.
This theoretically can help see what the weaknesses of a country is, or where there is less/more competitiveness.

So for instance, all other single USA NR holders have world rank in that event < 15.
[TABLE="class:grid,align:left"]
[TR][TD] Single Rank [/TD][TD] Country [/TD][TD] Name [/TD][TD] Event [/TD][TD] Result [/TD][/TR]
[TR][TD] 15 [/TD][TD] USA [/TD][TD] Rami Sbahi [/TD][TD] 3x3 with feet [/TD][TD] 36.97 [/TD][/TR]
[TR][TD] 31 [/TD][TD] Poland [/TD][TD] Michal Halczuk [/TD][TD] 4x4 [/TD][TD] 32.18 [/TD][/TR]
[TR][TD] 33 [/TD][TD] China [/TD][TD] Yinghao Wang*(王鹰豪) [/TD][TD] pyraminx [/TD][TD] 2.77 [/TD][/TR]
[TR][TD] 89 [/TD][TD] Hungary [/TD][TD] Milán Baticz [/TD][TD] 2x2 [/TD][TD] 1.53 [/TD][/TR]
[TR][TD] 55 [/TD][TD] Japan [/TD][TD] Ryosuke Mondo*(門戸良介) [/TD][TD] multi blindfolded [/TD][TD] 9/10 51:07 [/TD][/TR]
[TR][TD] 44 [/TD][TD] United Kingdom [/TD][TD] Daniel Sheppard [/TD][TD] pyraminx [/TD][TD] 2.86 [/TD][/TR]
[TR][TD] 61 [/TD][TD] Germany [/TD][TD] Jan Bentlage [/TD][TD] 3x3 with feet [/TD][TD] 59.52 [/TD][/TR]
[TR][TD] 62 [/TD][TD] Canada [/TD][TD] Antoine Cantin [/TD][TD] pyraminx [/TD][TD] 3.02 [/TD][/TR]
[TR][TD] 107 [/TD][TD] Netherlands [/TD][TD] Maarten Smit [/TD][TD] 333bf [/TD][TD] 01:05.09 [/TD][/TR]
[TR][TD] 93 [/TD][TD] Indonesia [/TD][TD] Achmad Rizki Zakaria [/TD][TD] 6x6 [/TD][TD] 02:39.83 [/TD][/TR]
[TR][TD] 103 [/TD][TD] Brazil [/TD][TD] Carlos Alberto de Alcântara Jr [/TD][TD] 333fm [/TD][TD] 30 [/TD][/TR]
[TR][TD] 152 [/TD][TD] Italy [/TD][TD] Jacopo Melchiorri [/TD][TD] pyraminx [/TD][TD] 3.66 [/TD][/TR]
[TR][TD] 171 [/TD][TD] Russia [/TD][TD] Aleksey Grishin [/TD][TD] megaminx [/TD][TD] 01:17.06 [/TD][/TR]
[TR][TD] 286 [/TD][TD] Australia [/TD][TD] Jayden McNeill [/TD][TD] 3x3 with feet [/TD][TD] 02:06.19 [/TD][/TR]
[TR][TD] N/A [/TD][TD] Thailand [/TD][TD] <No competitor> [/TD][TD] 444bf [/TD][TD] N/A [/TD][/TR]
[TR][TD] 93 [/TD][TD] France [/TD][TD] Fabien Lebailly [/TD][TD] 3x3 with feet [/TD][TD] 01:11.17 [/TD][/TR]
[TR][TD] 88 [/TD][TD] Sweden [/TD][TD] Gunnar Krig [/TD][TD] 333oh [/TD][TD] 13.16 [/TD][/TR]
[TR][TD] 188 [/TD][TD] Finland [/TD][TD] Kim Jokinen [/TD][TD] 2x2 [/TD][TD] 1.83 [/TD][/TR]
[TR][TD] 133 [/TD][TD] Spain [/TD][TD] Carlos Méndez García-Barroso [/TD][TD] 333oh [/TD][TD] 13.83 [/TD][/TR]
[TR][TD] N/A [/TD][TD] Korea [/TD][TD] <No competitor> [/TD][TD] 444bf [/TD][TD] N/A [/TD][/TR]
[/TABLE]

[TABLE="class:grid,align:left"]
[TR][TD] Average Rank [/TD][TD] Country [/TD][TD] Name [/TD][TD] Event [/TD][TD] Result [/TD][/TR]
[TR][TD] 10 [/TD][TD] USA [/TD][TD] Rami Sbahi [/TD][TD] 3x3 with feet [/TD][TD] 39.10 [/TD][/TR]
[TR][TD] 22 [/TD][TD] Japan [/TD][TD] Yu Nakajima*(中島悠) [/TD][TD] 2x2 [/TD][TD] 2.46 [/TD][/TR]
[TR][TD] 30 [/TD][TD] China [/TD][TD] Xiao Xue*(薛晓) [/TD][TD] 3x3 with feet [/TD][TD] 54.77 [/TD][/TR]
[TR][TD] 30 [/TD][TD] Poland [/TD][TD] Michal Halczuk [/TD][TD] 4x4 [/TD][TD] 37.70 [/TD][/TR]
[TR][TD] 55 [/TD][TD] United Kingdom [/TD][TD] Robert Yau [/TD][TD] 7x7 [/TD][TD] 04:01.21 [/TD][/TR]
[TR][TD] 61 [/TD][TD] Netherlands [/TD][TD] Erik Akkersdijk [/TD][TD] pyraminx [/TD][TD] 4.82 [/TD][/TR]
[TR][TD] 51 [/TD][TD] Hungary [/TD][TD] Milán Baticz [/TD][TD] 3x3 [/TD][TD] 9.35 [/TD][/TR]
[TR][TD] 93 [/TD][TD] Thailand [/TD][TD] 2010CHAR01 [/TD][TD] pyraminx [/TD][TD] 5.25 [/TD][/TR]
[TR][TD] 58 [/TD][TD] Germany [/TD][TD] Jan Bentlage [/TD][TD] 3x3 with feet [/TD][TD] 01:08.14 [/TD][/TR]
[TR][TD] 64 [/TD][TD] Korea [/TD][TD] Do-Hyun Kim [/TD][TD] pyraminx [/TD][TD] 4.85 [/TD][/TR]
[TR][TD] 44 [/TD][TD] Canada [/TD][TD] Louis Cormier [/TD][TD] pyraminx [/TD][TD] 4.54 [/TD][/TR]
[TR][TD] [/TD][TD] [/TD][TD] Emily Wang [/TD][TD] 6x6 [/TD][TD] 02:38.48 [/TD][/TR]
[TR][TD] 59 [/TD][TD] Brazil [/TD][TD] Ronan Felipe Jorge [/TD][TD] megaminx [/TD][TD] 01:09.75 [/TD][/TR]
[TR][TD] 95 [/TD][TD] Indonesia [/TD][TD] Achmad Rizki Zakaria [/TD][TD] 6x6 [/TD][TD] 02:52.74 [/TD][/TR]
[TR][TD] 219 [/TD][TD] Australia [/TD][TD] Jayden McNeill [/TD][TD] 3x3 with feet [/TD][TD] 02:16.11 [/TD][/TR]
[TR][TD] 153 [/TD][TD] Taiwan [/TD][TD] Chia-Liang Tai*(戴嘉良) [/TD][TD] pyraminx [/TD][TD] 5.82 [/TD][/TR]
[TR][TD] 137 [/TD][TD] Russia [/TD][TD] Aleksey Grishin [/TD][TD] megaminx [/TD][TD] 01:23.07 [/TD][/TR]
[TR][TD] 71 [/TD][TD] Sweden [/TD][TD] Simon Westlund [/TD][TD] 3x3 [/TD][TD] 9.55 [/TD][/TR]
[TR][TD] 150 [/TD][TD] Philippines [/TD][TD] Richard Jay S. Apagar [/TD][TD] 2x2 [/TD][TD] 3.32 [/TD][/TR]
[TR][TD] 134 [/TD][TD] Italy [/TD][TD] Jacopo Melchiorri [/TD][TD] clock [/TD][TD] 11.55 [/TD][/TR]
[TR][TD] 118 [/TD][TD] Spain [/TD][TD] Dario Roa Sánchez [/TD][TD] megaminx [/TD][TD] 01:20.28 [/TD][/TR]
[/TABLE]

rowehessler · Nov 19, 2013

I was thinking of a cool statistic today. How many people have been world champion, average WR holder, and single WR holder for a single event at the same time? I'd like to think of it as the "Triple Crown" of cubing (normally a baseball term). These are the only ones i can think of currently:
2x2: Rowe Hessler
3x3: Yu Nakajima
4x4: Yuku Hayashi, Matyas Kuti, Feliks Zemdegs
5x5: Frank Morris, Matyas Kuti, Dan Cohen, Feliks Zemdegs
6x6: Dan Cohen, Kevin Hays
Onehanded: Ryan Patricio, Michal Pleskowicz
Megaminx: Erik Akkersdijk, Simon Westlund
Feet: Anssi Vanhala
Square1: Lars Vandenbergh

I think I got all of them, but its hard to figure them out from just looking at the database. Can anyone else verify this information? I think its a statistic thats worth keeping track of, seeing as its pretty rare

Carrot · Nov 19, 2013

You are wrong about Yohei Oka and pyraminx

TMOY · Nov 19, 2013

Square-1: Lars Vandenbergh (world champion 2003, held both WRs after Dutch Open 2004).

rowehessler · Nov 19, 2013

Carrot said:
You are wrong about Yohei Oka and pyraminx

kinda rushed through them. Thought so.

TMOY said:
Square-1: Lars Vandenbergh (world champion 2003, held both WRs after Dutch Open 2004).

awesome, ill add that in

Pro94 · Nov 19, 2013

Can we count also Magics?
If so Máté Horváth held for 3 times Master Magic WR single and twice WR avg. World Champion in 2007, 2009 and 2011.

Also I think Stefan Pochmann in Megaminx and Rubik's Clock.

rowehessler · Nov 19, 2013

Pro94 said:
Can we count also Magics?
If so Máté Horváth held for 3 times Master Magic WR single and twice WR avg. World Champion in 2007, 2009 and 2011.

Also I think Stefan Pochmann in Megaminx and Rubik's Clock.

yeah magics count, is it just mate horvath? and are you sure about stefan, i don't feel like checking right now.

Stefan · Nov 19, 2013

Pro94 said:
Also I think Stefan Pochmann in Megaminx and Rubik's Clock.

I totally didn't think about it when I read Rob's post. But now that you mention it, I think so, too. And Master Magic as well. Good old days

Pro94 · Nov 19, 2013

Megaminx:
WR single: 2005-04-23
World Champion: 2005-11-05
WR avg: 2006-04-21
Then he held both WRs since 2007-10-05 when Erik Akkersdijk broke them at WC2007.
https://www.worldcubeassociation.or...Id=&eventId=minx&years=&mixHist=Mixed+History

Rubik's Clock:
WR single: 2004-04-24
WR avg: 2004-04-24
World Champion: 2005-11-05
Also here both WRs were broken on the same day by Mátyás Kuti at Czech Open 2007.
https://www.worldcubeassociation.or...d=&eventId=clock&years=&mixHist=Mixed+History

I can't use Mixed History for Magics, but I'm quite sure that also Jaap Scherphuis should be on the list for Rubik's Magic.
EDIT: Yes it's possible; I had just to edit URL.

Some changes for MMagic list: add Stefan and remove Máté Horváth. He got both WR in 2007 and he won WC2007 but Milán Baticz took his WR avg. 2 months before. Mátyás Kuti broke both in 2008 and Máté Horváth was able to get back only WR avg. and he won WC2009.

Stefan · Nov 19, 2013

Note: This might not be exact, because of overlapping competitions and me being too lazy to think about whether/how it can be done fully exact.

Code:

222    Rowe Hessler
333    Yu Nakajima (中島悠)
333ft  Anssi Vanhala
333oh  Ryan Patricio
444    Yuki Hayashi (林祐樹), Mátyás Kuti, Feliks Zemdegs
555    Frank Morris, Mátyás Kuti, Dan Cohen, Feliks Zemdegs
666    Dan Cohen, Kevin Hays
777    Michał Halczuk
clock  Stefan Pochmann
magic  Jaap Scherphuis
minx   Stefan Pochmann, Erik Akkersdijk, Bálint Bodor, Simon Westlund
mmagic Stefan Pochmann
sq1    Lars Vandenbergh, Grzegorz Prusak

Code:

# Requested at: http://www.speedsolving.com/forum/showthread.php?26121-Odd-WCA-stats-Stats-request-Thread&p=923537&viewfull=1#post923537
# Note: This might not be exact, because of overlapping competitions and me being too lazy to think about whether/how it can be done fully exact.

source = 'WCA_export197_20131113.tsv.zip'

import zipfile, csv, re, time
start_time = time.time()

champ, singleHolder, averageHolder, triple_crowns = {}, {}, {}, {}
with zipfile.ZipFile(source) as zf:
    with zf.open('WCA_export_Results.tsv') as pf:
        for row in csv.DictReader(pf, delimiter='\t'):
            person, event = row['personId'], row['eventId']
            if re.match(r'WC\d{4}$', row['competitionId']) and row['roundId'] in ('f', 'c') and row['pos'] == '1' and int(row['best']) > 0:
                champ[event] = person
            if row['regionalSingleRecord'] == 'WR':
                singleHolder[event] = person
            if row['regionalAverageRecord'] == 'WR':
                averageHolder[event] = person
            if champ.get(event) == singleHolder.get(event) == averageHolder.get(event) == person:
                tcs = triple_crowns.setdefault(event, [])
                if row['personName'] not in tcs:
                    tcs.append(row['personName'])

with open('triple_crown.txt', 'w') as f:
    for event, tcs in sorted(triple_crowns.items()):
        f.write('{:6} {}\n'.format(event, ', '.join(tcs)))

print(time.time() - start_time)

Pro94 · Nov 19, 2013

Looks like the only event with average missing is Pyraminx. But many people were close with 2 out of 3 titles:

Andy Bellenir: World Champion in 2003, WR single but no WR avg;
Gunnar Krig: both WRs but not World Champion;
Piotr Kózka: both WRs but not World Champion;
Grzegorz Łuczyna: World Champion in 2007, WR avg. but no WR single;
Tomasz Kiedrowicz: both WRs but not World Champion;
Yohei Oka (岡要平): World Champion in 2009, WR avg. but no WR single;
Yohei Oka (岡要平): both WRs (late 2011) but not World Champion;
Oscar Roth Andersen: both WRs but no World Champion (3 times);

Odd WCA stats/ Stats request Thread

Veteran

Veteran

Veteran

Veteran

Legend

Veteran

Regular

Legend

Veteran

Veteran

Veteran

Veteran

Veteran

Veteran

Veteran

Veteran

Legend

Veteran

Legend

Veteran

Similar threads