Odd WCA stats/ Stats request Thread

[cuberkid10]

I was curious about the bottom of the list so I tried to find the full list myself. My numbers don't quite match the ones on the WCA page but they're pretty close. Not sure what the problem is but the ranking should at least be correct.

I'm interested to see this data just for female cubers (if possible)

 

[Antonie faz fan]

The longest, with 105 characters is

Athanasios Papastathopoulos-Katsaros (Αθανάσιος Παπασταθόπουλος-Κατσαρός)

But it kind of feels like cheating since that includes his full name twice...

I reckon the longest just to include the name once is

Pablo Eduardo Nikolais Teixeira Bonifácio da Silva

(51 characters)

And that has been the case since 2013...

yeah it is just the same name just with greek characters

 

[SirWaffle]

I'm interested to see this data just for female cubers (if possible)

I dont have what you asked for but i do however have a few links to female ranks and stats you might be interested in

http://hem.bredband.net/_zlv_/rubiks/stats/kinch_ranks_female.html

http://hem.bredband.net/_zlv_/rubiks/stats/sum_of_female_ranks.html

http://hem.bredband.net/_zlv_/rubiks/stats/female_top20.html

 

[Sergeant Baboon]

I'm interested to see this data just for female cubers (if possible)

Again, can't guarantee these numbers are totally accurate, but probably pretty close.

1. 3x3: 4212
2. 2x2: 1566
3. Pyra: 863
4. 4x4: 601
5. Magic: 458
6. OH: 424
7. Skewb: 257
8. 5x5: 248
9. Minx: 205
10. Clock: 182
11. 3BLD: 164
12. Master Magic: 158
13. FMC: 132
14. Sq1: 81
15. 7x7: 64
16. 6x6: 61
17. Feet: 55
18. MBLD: 53 (46 new, 7 old)
19. 4BLD: 17
20. 5BLD: 10

Weird that there are more in 7x7 than in 6x6, but with a difference of only 3 people it very well could be within the range of whatever error I'm getting compared to the official WCA page.

R code (same Ruby code with very minor changes):

Spoiler

# Get the result data, then rename the columns.
result_data = read.csv(file = "WCA_export_Results.tsv", head = TRUE, sep = "\t")
results = data.frame(result_data$personId, result_data$competitionId, 
  result_data$eventId, result_data$average, result_data$value1,
  result_data$value2, result_data$value3, result_data$value4,
  result_data$value5)
names(results) = c("person", "comp", "event", "average", "s1", "s2", "s3",
  "s4", "s5")

# Get the person data.
person_data = read.csv(file = "WCA_export_Persons.tsv", head = TRUE, sep = "\t")
people = data.frame(person_data$id, person_data$subid, 
  person_data$countryId, person_data$gender)
names(people) = c("person", "subid", "country", "gender")
people = subset(people, subid == 1)

# Merge and filter to only women.
female_solves = merge(x = results, y = people, by.x = "person", by.y = "person")
female_solves = subset(female_solves, gender == "f")

 

[TMOY]

I was curious about the bottom of the list so I tried to find the full list myself. My numbers don't quite match the ones on the WCA page but they're pretty close. Not sure what the problem is but the ranking should at least be correct.

The reason of the difference is that you're using the database export, which doesn't exactly match the current state of the WCA database (the most recent results may be missing).

 

[Jakube]

Wow, Feliks, Collin and Mats just destroyed the "Best Podiums in Rubik's Cube" WR.

7.45+7.69+7.98 = 23.12

Old WR was 24.66.

 

[Robert-Y]

I just want to point out that Feliks only set the best single on one of the scrambles in the finals. I wonder if this is some sort of personal worst for him?

 

[BOSSCUBER666]

smallest gap between 3x3 single and average pb?

 

[Berd]

smallest gap between 3x3 single and average pb?

Mines pretty small. It's not the closest tho.

 

[AlexMaass]

interesting idea, find out when everytime an event was added, the first person to do all events

this is probably difficult though :/

 

[TheDubDubJr]

Spoiler: Top 100 1-Man Guildfords (Based on Official Averages)

Interesting Comparison
WR Averages all combined (in a Guildford) is 8:00.46

Rank	Name	Time
1	Lucas Wesche	9:25.21
2	Yu Nakajima (中島悠)	9:52.23
3	Louis Cormier	10:08.15
4	Robert Yau	10:08.88
5	Evan Liu	10:25.47
6	Kevin Costello III	10:39.93
7	Wojciech Knott	10:51.23
8	Antoine Cantin	10:55.61
9	Bence Barát	10:57.76
10	Mitchell Lane	11:11.26
11	Erik Akkersdijk	11:14.56
12	Simon Westlund	11:19.94
13	Michał Halczuk	11:20.28
14	Jong-Ho Jeong (정종호)	11:21.45
15	John Brechon	11:34.62
16	Jayden McNeill	11:43.75
17	Daniel Sheppard	11:45.13
18	Dan Cohen	11:50.81
19	Walker Welch	11:55.11
20	Ivan Zabrodin	12:04.30
21	Luboš Bartík	12:07.05
22	Matic Omulec	12:07.78
23	Sheng Cao (曹晟)	12:10.51
24	Jan Bentlage	12:16.40
25	Henri Gerber	12:23.33
26	Wilhelm Kilders	12:25.96
27	Mats Valk	12:26.11
28	Emanuel Rheinert	12:26.13
29	Yuhei Takagi (高木佑平)	12:46.54
30	Lee Chiang (蔣礪)	12:48.63
31	Yinghao Wang (王鹰豪)	13:04.89
32	Vincent Hartanto Utomo	13:12.31
33	Callum Hales-Jepp	13:13.62
34	Daniel Cano Salgado	13:14.70
35	Alberto Pérez de Rada Fiol	13:16.19
36	James Hildreth	13:24.39
37	Chris Wall	13:24.86
38	Dmitry Kryuzban	13:25.53
39	Rami Sbahi	13:25.88
40	Jiacheng Peng (彭家诚)	13:44.88
41	Daniel Wallin	13:46.60
42	Yu Sajima (佐島優)	13:57.46
43	Dániel Varga	14:11.55
44	Christopher Olson	14:16.34
45	Wataru Hashimura (端村航)	14:17.17
46	Sebastian Werb	14:17.78
47	Akash Rupela	14:18.21
48	AJ Blair	14:18.23
49	Viktor Ejlertsson	14:24.87
50	Joshua Feran	14:27.28
51	James Molloy	14:27.83
52	Zijia Feng (冯子甲)	14:32.20
53	Jakob Kogler	14:32.33
54	Linus Fresz	14:40.07
55	Corey Sakowski	14:48.68
56	Austin Reed	14:49.07
57	Liudi Sun (孙柳笛)	14:49.29
58	Chunyu Zhang (张春雨)	14:50.00
59	Marco Rota	14:51.54
60	Riley Woo	14:58.44
61	Michael Young	15:01.21
62	James Hamory	15:03.39
63	Nathaniel Berg	15:05.51
64	Edward Lin	15:07.20
65	Sébastien Auroux	15:07.46
66	José Leonardo Chaparro Prieto	15:09.07
67	Michael Andres Castillo Lemus	15:15.24
68	Wojciech Szatanowski	15:18.45
69	Niko Ronkainen	15:28.29
70	Evan Brown	15:29.44
71	Carlos Méndez García-Barroso	15:30.52
72	Yumu Tabuchi (田渕雄夢)	15:34.38
73	Angel Arrioja Landa	15:34.44
74	Yunqi Ouyang (欧阳韵奇)	15:38.94
75	Artem Melikian (Артем Мелікян)	15:43.21
76	Ben Whitmore	15:46.96
77	Ainesh Sevellaraja	15:49.74
78	Mason Langenderfer	15:54.35
79	Thompson Clarke	15:54.46
80	Timothy Sun	15:59.76
81	Henrik Buus Aagaard	16:02.69
82	Jiawen Wu (吴嘉文)	16:03.07
83	Nguyễn Việt Hoàng	16:10.64
84	Maarten Smit	16:20.79
85	Shintaro Nishijo	16:26.07
86	Nguyễn Ngọc Thịnh	16:27.39
87	Anders Berggren	16:34.26
88	Henry Savich	16:36.03
89	Conor Cronin	16:43.25
90	Ryan Jew	16:46.07
91	Ihor Bilchenko (Ігор Більченко)	16:50.38
92	Zhiyang Chen (陈至扬)	16:50.92
93	Filip Pasławski	17:06.49
94	Reto Bubendorf	17:13.90
95	Nikita Loyko	17:16.04
96	Shivam Bansal	17:16.95
97	Zhao-Zhe Zhong (鍾肇哲)	17:17.06
98	Albin Xhemajlaj	17:22.46
99	Kim Jokinen	17:47.98
100	Antonie Paterakis	17:55.54

 

[mycube]

Wow, Feliks, Collin and Mats just destroyed the "Best Podiums in Rubik's Cube" WR.

7.45+7.69+7.98 = 23.12

Old WR was 24.66.

A question to this podium WR, are there some better results of the three best persons in one round and not just in the final round? eg. at the third round of the china championship the three best person sum up to 22.88. are there even better results?

 

[TheCoolMinxer]

Spoiler: Top 100 1-Man Guildfords (Based on Official Averages)

Interesting Comparison
WR Averages all combined (in a Guildford) is 8:00.46

Rank	Name	Time
1	Lucas Wesche	9:25.21
2	Yu Nakajima (中島悠)	9:52.23
3	Louis Cormier	10:08.15
4	Robert Yau	10:08.88
5	Evan Liu	10:25.47
6	Kevin Costello III	10:39.93
7	Wojciech Knott	10:51.23
8	Antoine Cantin	10:55.61
9	Bence Barát	10:57.76
10	Mitchell Lane	11:11.26
11	Erik Akkersdijk	11:14.56
12	Simon Westlund	11:19.94
13	Michał Halczuk	11:20.28
14	Jong-Ho Jeong (정종호)	11:21.45
15	John Brechon	11:34.62
16	Jayden McNeill	11:43.75
17	Daniel Sheppard	11:45.13
18	Dan Cohen	11:50.81
19	Walker Welch	11:55.11
20	Ivan Zabrodin	12:04.30
21	Luboš Bartík	12:07.05
22	Matic Omulec	12:07.78
23	Sheng Cao (曹晟)	12:10.51
24	Jan Bentlage	12:16.40
25	Henri Gerber	12:23.33
26	Wilhelm Kilders	12:25.96
27	Mats Valk	12:26.11
28	Emanuel Rheinert	12:26.13
29	Yuhei Takagi (高木佑平)	12:46.54
30	Lee Chiang (蔣礪)	12:48.63
31	Yinghao Wang (王鹰豪)	13:04.89
32	Vincent Hartanto Utomo	13:12.31
33	Callum Hales-Jepp	13:13.62
34	Daniel Cano Salgado	13:14.70
35	Alberto Pérez de Rada Fiol	13:16.19
36	James Hildreth	13:24.39
37	Chris Wall	13:24.86
38	Dmitry Kryuzban	13:25.53
39	Rami Sbahi	13:25.88
40	Jiacheng Peng (彭家诚)	13:44.88
41	Daniel Wallin	13:46.60
42	Yu Sajima (佐島優)	13:57.46
43	Dániel Varga	14:11.55
44	Christopher Olson	14:16.34
45	Wataru Hashimura (端村航)	14:17.17
46	Sebastian Werb	14:17.78
47	Akash Rupela	14:18.21
48	AJ Blair	14:18.23
49	Viktor Ejlertsson	14:24.87
50	Joshua Feran	14:27.28
51	James Molloy	14:27.83
52	Zijia Feng (冯子甲)	14:32.20
53	Jakob Kogler	14:32.33
54	Linus Fresz	14:40.07
55	Corey Sakowski	14:48.68
56	Austin Reed	14:49.07
57	Liudi Sun (孙柳笛)	14:49.29
58	Chunyu Zhang (张春雨)	14:50.00
59	Marco Rota	14:51.54
60	Riley Woo	14:58.44
61	Michael Young	15:01.21
62	James Hamory	15:03.39
63	Nathaniel Berg	15:05.51
64	Edward Lin	15:07.20
65	Sébastien Auroux	15:07.46
66	José Leonardo Chaparro Prieto	15:09.07
67	Michael Andres Castillo Lemus	15:15.24
68	Wojciech Szatanowski	15:18.45
69	Niko Ronkainen	15:28.29
70	Evan Brown	15:29.44
71	Carlos Méndez García-Barroso	15:30.52
72	Yumu Tabuchi (田渕雄夢)	15:34.38
73	Angel Arrioja Landa	15:34.44
74	Yunqi Ouyang (欧阳韵奇)	15:38.94
75	Artem Melikian (Артем Мелікян)	15:43.21
76	Ben Whitmore	15:46.96
77	Ainesh Sevellaraja	15:49.74
78	Mason Langenderfer	15:54.35
79	Thompson Clarke	15:54.46
80	Timothy Sun	15:59.76
81	Henrik Buus Aagaard	16:02.69
82	Jiawen Wu (吴嘉文)	16:03.07
83	Nguyễn Việt Hoàng	16:10.64
84	Maarten Smit	16:20.79
85	Shintaro Nishijo	16:26.07
86	Nguyễn Ngọc Thịnh	16:27.39
87	Anders Berggren	16:34.26
88	Henry Savich	16:36.03
89	Conor Cronin	16:43.25
90	Ryan Jew	16:46.07
91	Ihor Bilchenko (Ігор Більченко)	16:50.38
92	Zhiyang Chen (陈至扬)	16:50.92
93	Filip Pasławski	17:06.49
94	Reto Bubendorf	17:13.90
95	Nikita Loyko	17:16.04
96	Shivam Bansal	17:16.95
97	Zhao-Zhe Zhong (鍾肇哲)	17:17.06
98	Albin Xhemajlaj	17:22.46
99	Kim Jokinen	17:47.98
100	Antonie Paterakis	17:55.54

Interesting Statistics! Can you do the Same with NxN relays and mini Guildford? And I am not even that far from joining the elite club (like top20/15) O.o

 

[YouCubing]

Number of WRs broken each year:
2015: 47 and counting
2014: 71
2013: 97
2012: 55
2011: 80
2010: 81
2009: 76
2008: 74
2007: 73
2006: 53
2005: 57
2004: 42
2003: 18
1982: 1 (lol)

 

[Isaac Lai]

Who has the lowest Megaminx/3x3 ratio? I'm guessing Zoe de Moffarts would be quite high up on the list.

 

[henrysavich]

Who has the lowest Megaminx/3x3 ratio? I'm guessing Zoe de Moffarts would be quite high up on the list.

Wtf is up with her sq1 single and avg ?!!

 

[Lid]

Wtf is up with her sq1 single and avg ?!!

https://www.speedsolving.com/forum/...an-officialy-beating-the-scramble-for-Square1
This was pre-randomstate.

 

[Isaac Lai]

Wtf is up with her sq1 single and avg ?!!

Something like what happened with Andrea Santambrogio I think.

 

[Evan Liu]

Finally bothered to figure out how to generate the PB streaks list using Stefan's code from the previous update, which I have quoted below (August 28, 2014). I cut the updated list off at a minimum streak of 30 competitions (51 people total). I knew I had tied Mats, but didn't know whether or not someone else had passed us.

Spoiler: Most consecutive competitions with at least one personal best, starting with your first competition (as of October 28, 2015)

Evan Liu                47 (ongoing)
Mats Valk               47 (ended at AmstelveenOpen2012)
Kevin Costello III      45 (ended at LexingtonFall2015)
Christopher Olson       43 (ended at FieldOfCubes2015)
Thompson Clarke         43 (ongoing)
Sébastien Auroux        42 (ended at GHSIngenhovenparkOpen2011)
Hunor Bózsing           41 (ended at FMCEurope2015)
Tim Reynolds            41 (ended at MITFall2010)
Robert Yau              40 (ongoing)
Bence Barát             39 (ended at ZonhovenOpen2012)
Milán Baticz            39 (ended at RomanianOpen2012)
Gaël Dusser             38 (ended at RubikkuChamp2012)
Jan Bentlage            38 (ended at HessenOpen2013)
Mike Hughey             38 (ended at DixonSummer2013)
Wojciech Szatanowski    38 (ended at PoznanOpen2014)
Geert Bicler            37 (ended at HEMMariCubikOpen2013)
Michael Gottlieb        37 (ongoing)
Bhargav Narasimhan      36 (ongoing)
Daniel Sheppard         36 (ended at Euro2014)
Marco Rota              36 (ongoing)
Kit Clement             35 (ended at MishawakaFall2014)
Nathan Dwyer            35 (ended at FMCUSA2014)
Jakub Cabaj             34 (ended at PolishOpen2013)
Michael Röhrer          34 (ended at MunichOpen2013)
Brúnó Bereczki          33 (ended at GELOpen2012)
Dan Dzoan               33 (ended at BerkeleyFall2009)
Javier Tirado Ortiz     33 (ended at DualGames2013)
Mike Kotch              33 (ended at WC2013)
Nikhil Mande            33 (ongoing)
Artem Melikian          32 (ongoing)
Chunyu Zhang            32 (ended at HefeiOpen2015)
Louis Cormier           32 (ended at NationalCapitalRegion2015)
Mariano D'Imperio       32 (ongoing)
Michael Kristel         32 (ended at GermanNationals2015)
Ryohei Yoshioka         32 (ended at KansaiOpen2014)
Bertalan Bodor          31 (ended at HungarianOpen2015)
Lucas Etter             31 (ongoing)
Nathaniel Berg          31 (ended at OsloFall2015)
Niklas Spies            31 (ended at AachenSummer2012)
Simon Westlund          31 (ongoing)
Tiemen De Meester       31 (ongoing)
Yumu Tabuchi            31 (ended at UTOpen2013)
Andrew Coghill          30 (ongoing)
Blake Thompson          30 (ended at FantabulousMichigan2015)
Corey Sakowski          30 (ended at Newark2013)
Edward Lin              30 (ended at CalDay2012)
Henrik Buus Aagaard     30 (ended at VejstrupOpen2011)
Joshua Feran            30 (ongoing)
Sebastian Weyer         30 (ended at GermanOpen2015)
Tomoaki Okayama         30 (ended at JapanOpen2012)
Wilhelm Kilders         30 (ongoing)

Spoiler: August 28, 2014

Mats Valk               47 (ended at AmstelveenOpen2012)
Sébastien Auroux        42 (ended at GHSIngenhovenparkOpen2011)
Tim Reynolds            41 (ended at MITFall2010)
Bence Barát             39 (ended at ZonhovenOpen2012)
Milán Baticz            39 (ended at RomanianOpen2012)
Gaël Dusser             38 (ended at RubikkuChamp2012)
Jan Bentlage            38 (ended at HessenOpen2013)
Mike Hughey             38 (ended at DixonSummer2013)
Wojciech Szatanowski    38 (ended at PoznanOpen2014)
Geert Bicler            37 (ended at HEMMariCubikOpen2013)
Thompson Clarke         37 (ongoing)
Daniel Sheppard         36 (ended at Euro2014)
Evan Liu                36 (ongoing)
Kevin Costello III      36 (ongoing)
Christopher Olson       35 (ongoing)
Jakub Cabaj             34 (ended at PolishOpen2013)
Kit Clement             34 (ongoing)
Michael Röhrer          34 (ended at MunichOpen2013)
Brúnó Bereczki          33 (ended at GELOpen2012)
Dan Dzoan               33 (ended at BerkeleyFall2009)
Hunor Bózsing           33 (ongoing)
Javier Tirado Ortiz     33 (ended at DualGames2013)
Mike Kotch              33 (ended at WC2013)
Nathan Dwyer            33 (ongoing)
Ryohei Yoshioka         32 (ended at KansaiOpen2014)
Niklas Spies            31 (ended at AachenSummer2012)
Yumu Tabuchi            31 (ended at UTOpen2013)
Corey Sakowski          30 (ended at Newark2013)
Edward Lin              30 (ended at CalDay2012)
Henrik Buus Aagaard     30 (ended at VejstrupOpen2011)
Tomoaki Okayama         30 (ended at JapanOpen2012)
Kai Jiptner             29 (ended at ErfurtOpen2013)
Krzysztof Kuncki        29 (ended at RadomOpen2013)
Louis Cormier           29 (ongoing)
Marcin Jakubowski       29 (ended at CzechOpen2011)
Michael Gottlieb        29 (ongoing)
Łukasz Cichecki         29 (ongoing)
Bertalan Bodor          28 (ongoing)
Ernie Pulchny           28 (ended at YaleSpring2013)
Przemysław Kaleta       28 (ended at KielceCubeAttack2014)
Robert Yau              28 (ongoing)
Sanio Kasumovic         28 (ended at GELOpen2012)
Simon Westlund          28 (ongoing)
Ting Sheng Bao Yang     28 (ongoing)
Dániel Varga            27 (ended at DutchOpen2011)
Edouard Chambon         27 (ended at SwissOpen2009)
Jean-Louis Mathieu      27 (ended at FrenchOpen2010)
John Brechon            27 (ended at DixonWinter2013)
Maarten Smit            27 (ended at AmstelveenOpen2013)
Mariano D'Imperio       27 (ongoing)
Tobias Droste           27 (ongoing)
Zach Goldman            27 (ended at CCFCFall2013)
Brandon Mikel           26 (ended at IowaCornLovers2014)
Chia-Liang Tai          26 (ended at CrossstraitCubing2014)
Chunyu Zhang 2          26 (ongoing)
Erik Akkersdijk         26 (ended at Netherlands2008)
Julian David            26 (ongoing)
Marco Rota              26 (ongoing)
Sebastian Weyer         26 (ongoing)
Vincent Hartanto Utomo  26 (ongoing)
Yuuki Kobayashi         26 (ongoing)
Artur Kristof           25 (ended at PoznanOpen2014)
Björn Korbanka          25 (ended at Euro2012)
Chester Lian            25 (ended at NewAlbany2013)
Everett Kelly           25 (ended at NiseiWeek2014)
Fubo Wang               25 (ended at BUAAOpen2013)
Joey Gouly              25 (ended at UKNationals2010)
Kanneti Sae Han         25 (ended at FrenchOpen2011)
Kåre Krig               25 (ended at KarlstadOpen2010)
Michał Pleskowicz       25 (ended at ManufakturaOpen2013)
Olivér Perge            25 (ended at ObeiObeiOpen2009)
Rafael Werneck Cinoto   25 (ended at AmericanaOpen2012)
Tim Habermaas           25 (ended at Euro2012)
Tim Wong                25 (ended at NiseiWeek2014)

 

[TheCoolMinxer]

most podiums without a 1st place? (I think it's Kian Barry(?) but I'd love to have a list