Odd WCA stats/ Stats request Thread

[cuberkid10]

Whats the most single events a female cuber has won? Im talking about at all the competitions combined, coming in 1st for any event. (Finals)

 

[vcuber13]

possibly emily.
12 by my count

 

[shelley]

probably emily.

I actually tie Emily with 11 first place finishes in 3BLD and one in 4BLD.
Laetitia Lemoine is not far behind with 11 first place finishes in megaminx, magic and master magic.

This is just off the top of my head though, someone who can do an actual database search might give you a better answer.

 

[caseyd]

I know I have the worst magic average to ever win nationals, 1.45

 

[qqwref]

2011: 1.45
2010: 1.29
2009: 1.41
2008: 1.27
2006: 1.34
2004: not held

I think you're right - although only on a technicality (the winning average in 2007 was 1.65, but this was just called US Open, because at the time they wanted to do a Nationals only every two years)

 

[cubernya]

Yeah I noticed winning magic average on live results and I was like no...that's it?

 

[Tim Reynolds]

I actually tie Emily with 11 first place finishes in 3BLD and one in 4BLD.
Laetitia Lemoine is not far behind with 11 first place finishes in megaminx, magic and master magic.

This is just off the top of my head though, someone who can do an actual database search might give you a better answer.

Shelley 13 (I think you missed a 3bld)
Emily 12
Laetitia 11
Laura Ohrndorf 9
Son Seul-Gi 6
Charlie 5

 

[qqwref]

In a related question of the most number of events a single female cuber has won, the two leaders are probably Emily with 6 (4x4, 5x5, 6x6, 7x7, OH, megaminx) and then Laetitia with 4 (FM, megaminx, magic, master magic).

I've apparently won 12 different events o_0 I wonder if anyone has won every single event...?

 

[mr. giggums]

In a related question of the most number of events a single female cuber has won, the two leaders are probably Emily with 6 (4x4, 5x5, 6x6, 7x7, OH, megaminx) and then Laetitia with 4 (FM, megaminx, magic, master magic).

I've apparently won 12 different events o_0 I wonder if anyone has won every single event...?

Bence has won every event.

 

[vcuber13]

his 4bld win was a dnf, that doesnt count

 

[cuberkid10]

Durn, I missed that list. Haha I have 2 wins.

 

[James Ludlow]

At this moment in time I am rinked 348 in the world for both Megaminx single and Megaminx avg.

My question is how many people and across which events also share this stat?

 

[samkli]

Feliks Zemdegs.. he is ranked 1 in both 3x3 single and average

 

[qqwref]

At this moment in time I am rinked 348 in the world for both Megaminx single and Megaminx avg.

My question is how many people and across which events also share this stat?

Unfortunately this statistic is very delicate, so the list changes (substantially!) almost every time a competition is added to the database. It might be interesting to look at, but any list posted will almost certainly be completely wrong in a week or two.

 

[Mr.Toad]

Request

Some of us really enjoy creating lists with the WCA database public export (link1, link2, link3). It's a pity that it doesn't include dates of birth. Is there any possibility of getting the full version?

 

[Tim Reynolds]

In a related question of the most number of events a single female cuber has won, the two leaders are probably Emily with 6 (4x4, 5x5, 6x6, 7x7, OH, megaminx) and then Laetitia with 4 (FM, megaminx, magic, master magic).

I've apparently won 12 different events o_0 I wonder if anyone has won every single event...?

Bence leads with 18 (missing 4BLD)
Tim Sun (5BLD and 6x6) and Erik (4BLD and 5BLD) have 17

2008BARA01 	Bence Barát 	18
2005AKKE01 	Erik Akkersdijk 	17
2007SUNT01 	Timothy Sun 	17
2007COHE01 	Dan Cohen 	15
2006ORLA01 	Bernett Orlando 	15
2007GUIM01 	Pedro Santos Guimarães 	14
2005BATI01 	Milán Baticz 	14
2009ZEMD01 	Feliks Zemdegs 	14
2007YUNQ01 	Yunqi Ouyang (欧阳韵奇) 	14
2004KRIG01 	Gunnar Krig 	14
2006BUUS01 	Henrik Buus Aagaard 	13
2008WEST02 	Simon Westlund 	13
2004GALL02 	Clément Gallet 	12
2006GOTT01 	Michael Gottlieb 	12
2008AURO01 	Sébastien Auroux 	12
2008WONE01 	David Woner 	12
2009YAUR01 	Robert Yau 	11
2008YOUN02 	Michael Young 	11
2007RUIZ01 	Uriel Gayosso Ruíz 	11
2006GARR01 	Lucas Garron 	11
2005REYN01 	Tim Reynolds 	11
2008BAOY01 	Ting Sheng Bao Yang 	11
2006KUTI01 	Mátyás Kuti 	10
2007HESS01 	Rowe Hessler 	10
2006EIDE01 	Derrick Eide 	10
2009MACA01 	Matias Macaya 	10
2008SEPP01 	Ville Seppänen 	10
2005VANH01 	Anssi Vanhala 	10

 

[Bryan]

Some of us really enjoy creating lists with the WCA database public export (link1, link2, link3). It's a pity that it doesn't include dates of birth. Is there any possibility of getting the full version?

Some countries have really strict laws on what kind of information can be made public. I can't see the WCA making this information public without causing people a lot of hassle.

 

[Kian]

I'm interested to know who has placed the most times in all events without a win. If I counted correctly I have placed 23 times in 7 different events without any wins, which seems remarkable to me.

 

[Hippolyte!!!]

Talking with Dave I mentioned that China is pretty good at memory competitions, then Dave said they're pretty good at many things, then I said it has to do with them being so many, and that it helps even more in team games because it's not enough to happen to have one good player. Then we translated that to cubing. Which country is the best, judged by the average of their top 10 cubers (3x3 average)? Again, it's not enough to happen to have one good player, so Feliks can dominate all he wants but Australia is still nowhere near the top

 1  USA                    10.2900            
 2  Japan                  10.4230            
 3  Thailand               10.4600            
 4  China                  10.5210            
 5  Germany                10.8600            
 6  Poland                 11.0020            
 7  Italy                  11.1000            
 8  Taiwan                 11.1020            
 9  Indonesia              11.1860            
10  Canada                 11.4840            
11  Malaysia               11.8220            
12  France                 11.8220            
13  United Kingdom         11.9440            
14  Hungary                12.1120            
15  Korea                  12.1290            
16  Philippines            12.1720            
17  Sweden                 12.2380            
18  Spain                  12.2550            
19  Netherlands            12.3210            
20  Russia                 12.4670            
21  Brazil                 12.4950            
22  Vietnam                12.5800            
23  Australia              12.7800            
24  Hong Kong              12.9400            
25  Singapore              13.9800            
26  Finland                14.4540            
27  Chile                  14.5090            
28  Norway                 14.5440            
29  Austria                14.6180            
30  Denmark                15.2320            
31  Israel                 16.0330            
32  India                  16.0360            
33  Mexico                 16.3790            
34  New Zealand            16.5420            
35  Belgium                17.3660            
36  Ukraine                17.4970            
37  Colombia               18.6490            
38  Romania                19.0260            
39  Peru                   19.8930            
40  Switzerland            20.8720            
41  Argentina              22.5860            
42  Slovenia               23.0110            
43  Portugal               24.9430            
44  Estonia                27.4000            
45  Czech Republic         27.5890            
46  Greece                 39.9910            
47  Slovakia               42.2470

Query (not exactly recommended):

select
	@num2 :=  @num2 + 1 as row_number,
	o.country,
	o.score
from
(

	select 
		n.country,
		(sum(n.average) / 1000) as score,
		max(n.row_number) as row_counter
	from
	(
		select 
			m.country,
			m.person,
			m.average,	
			@num := if(@group = m.country, @num + 1, 1) as row_number,
			@group := m.country as dummy,
			@num2:= 0
		from 
		(
			select 
				results.personCountryId as country,
				results.personName as person,
				min(results.average) as average
			      
			from   results
			where results.eventId like '333' and results.average > 0
			group by results.personId, results.personCountryId
			order by results.personCountryId, average
		)
		m
	)
	n
	where
		n.row_number <=10
	group by n.country
	order by score 
)
o
	where o.row_counter >=10

For the write-up, I tried to reconstruct how we started this conversation, and Dave found it ironic that I couldn't remember that I had started it by talking about memory competitions. Pfft.

Because with Yu and Arifum, Japan has 3 sub-10 cubers and because this is the case for several country, I do the same with the top-3 per country.
But I don't know how to use the WCA database, so I do this with a calc, so I only do for the countries with a sub-10 cuber.

Thailand: 9,05
Japan: 9,46
USA: 9,53
Germany: 9,64
Italy: 9,67
China: 9,74
Netherlands: 9,89
Poland: 9,91
United Kingdom: 10
Indonesia: 10,24
Canada: 10,31
Sweden: 10,51
France: 10,56
Australia: 10,82
Hungary: 10,95
Norway: 11,88
Austria: 12,08

 

[Robert-Y]

Well it's actuallly 9.71 for UK because Breandan got a 8.81 avg at Canadian Open last weekend. Also Rowan hasn't gotten his sub 10 avg yet . I'll hopefully beat my official avg soon. I hope to beat it before... 2013.