Odd WCA stats/ Stats request Thread

[Michael Womack]

what if there are some records that are the same for 4 or 5 years like magic stuck at .69 and 2x2 stuck at .69 would they conclude that the fastest time ever or what?

 

[asportking]

what if there are some records that are the same for 4 or 5 years like magic stuck at .69 and 2x2 stuck at .69 would they conclude that the fastest time ever or what?

No. Unless the record is .01 seconds, the record can always be broken.

 

[Stefan]

Milán Baticz is the only one who is top 100 in everything:

I first noticed it in the top 10 sums.

And wtf you need to be sub1 to be top 100 in magic. I still remember the golden days of getting WRs with 1.30 or so.

 

[Escher]

Does Milan not need a 5x5BLD success first?

Or are events without a non-DNF result not counting?

I wonder if there are more people who are top 100 in all of their events but only in the few they compete in.

 

[Rpotts]

Well even without the 5BLD success he's still tied 52nd in the world with DNF lol.

 

[Stefan]

Does Milan not need a 5x5BLD success first?

Oh darn, I didn't realize that his 52 in the top 10 statistic is red.

 

[AustinReed]

If 5BLD doesn't count, Dan Koen is there with him for that title.

 

[Stefan]

If 5BLD doesn't count, Dan Koen is there with him for that title.

What title? Can't be top-100-in-everything, as he has a 101 and a 113.

 

[Florian]

USA needs FewestMoves and MultiBlind WorldRecord to have a (current of past) WorldRecord in every discipline.

 

[bamilan]

Oh darn, I didn't realize that his 52 in the top 10 statistic is red.

Just wait for my next comp

Btw I've just seen that Yuxuan Wang got a magic round like this: 0.80 0.80 0.83 0.81 0.80, so 0.80 single and 0.80 average. Did it happen with somebody else too?
And could somebody please make a ranking list of the highest number of cubes tried in multiblind? (Zane had 23 success, I'm just interested in if anybody else has ever tried at least 23 )

 

[Stefan]

Btw I've just seen that Yuxuan Wang got a magic round like this: 0.80 0.80 0.83 0.81 0.80, so 0.80 single and 0.80 average. Did it happen with somebody else too?

Lukas Vogl, Pyraminx: 14.59, 14.59, 14.59, 14.59, 14.59 (likely false, I'll tell Ron)
Baramee Pookcharoen, Magic: 1.25, 1.27, 1.25, 1.25, 1.25

And could somebody please make a ranking list of the highest number of cubes tried in multiblind? (Zane had 23 success, I'm just interested in if anybody else has ever tried at least 23 )

All attempts of 18 or more cubes:

+-----------+----------------------------+----------------------------+
| attempted | personName                 | competitionId              |
+-----------+----------------------------+----------------------------+
|        25 | Zane Carney                | MelbourneCubeDay2011       |
|        21 | Zane Carney                | WC2011                     |
|        19 | Marcell Endrey             | WC2011                     |
|        18 | Aron Puddy-Mathew          | AustralianNationals2011    |
|        18 | Chester Lian               | USNationals2011            |
|        18 | Chester Lian               | USNationals2011            |
|        18 | Chester Lian               | USNationals2010            |
|        18 | Jakob Kogler               | GermanNationals2011        |
|        18 | Kai Jiptner                | MunichOpen2010             |
|        18 | Kai Jiptner                | CzechOpen2011              |
|        18 | Muhammad Iril Khairul Anam | IndonesianChampionship2010 |
|        18 | Tim Habermaas              | DusseldorfOpen2011         |
|        18 | Tim Habermaas              | CzechOpen2011              |
|        18 | Tim Habermaas              | GermanNationals2011        |
+-----------+----------------------------+----------------------------+

select round(99-(val-val%10000000)/10000000)+2*val%100 attempted, personName, competitionId
from
((select personName, competitionId, value1 val from results where eventId='333mbf') union all
(select personName, competitionId, value2 val from results where eventId='333mbf') union all
(select personName, competitionId, value3 val from results where eventId='333mbf')) helper
where val>0
order by 1 desc, 2
limit 14

 

[aronpm]

And could somebody please make a ranking list of the highest number of cubes tried in multiblind? (Zane had 23 success, I'm just interested in if anybody else has ever tried at least 23 )

I don't have the statistics but I am fairly sure that the second highest number is 19, by Marcell Endrey, and then 18, by Tim Habermaas and myself.

EDIT: Ah, ninja'd by Stefan

 

[bamilan]

What is the longest series of rankings achieved by the same person in "all results" in any of the events?
(I mean if it the ranking was 1.a, 2.a, 3.b, 4.a, 5.b, 6.b, 7.b, 8.a => then the answer would be 'b' with 3)

 

[Maniac]

What is the most common name? How many people have the same exact first and last name?

 

[qqwref]

What is the longest series of rankings achieved by the same person in "all results" in any of the events?
(I mean if it the ranking was 1.a, 2.a, 3.b, 4.a, 5.b, 6.b, 7.b, 8.a => then the answer would be 'b' with 3)

In 3x3avg, Feliks has 9 in a row.

Depending on how you order it, Yuxuan Wang can have up to 13 in Magic single (6x 0.80, 7x 0.81).

 

[Mr.Toad]

What is the most common name? How many people have the same exact first and last name?

Same first name:

+-------------+--------+
| firstName   | people |
+-------------+--------+
| Daniel      |    163 |
| David       |    129 |
| Muhammad    |    115 |
| Michael     |    109 |
| Kevin       |     85 |
| Lee         |     76 |
| Andrew      |     72 |
| Alex        |     70 |
| Kim         |     64 |
| Peter       |     59 |
| Ryan        |     59 |
| Adam        |     57 |
| Thomas      |     55 |
| Chris       |     50 |
| James       |     50 |
| Alexander   |     49 |
| Jason       |     49 |
| John        |     49 |
| Jonathan    |     49 |
| Christian   |     46 |
| José        |     43 |
| Brian       |     41 |
| Mark        |     41 |
| Joshua      |     39 |
| Eric        |     38 |
| Jacob       |     38 |
| Matthew     |     38 |
| Patrick     |     37 |
| Justin      |     36 |
| Richard     |     36 |
| Nicolas     |     35 |
| Brandon     |     34 |
| Juan        |     34 |
| Benjamin    |     33 |
| Luis        |     33 |
| Aaron       |     32 |
| Carlos      |     32 |
| Paul        |     32 |
| Ivan        |     31 |
| Sebastian   |     31 |
| Simon       |     31 |
| Victor      |     31 |
| Javier      |     30 |
| Martin      |     30 |
| Nguy?n      |     30 |
| Marco       |     29 |
| Nathan      |     29 |
| Nick        |     29 |
| Park        |     29 |
| William     |     29 |
| Ben         |     28 |
| Christopher |     28 |
| Gabriel     |     28 |
| Jorge       |     28 |
| Max         |     28 |
| Tim         |     28 |
| Anthony     |     27 |
| Joseph      |     27 |
| Yi          |     27 |
| Dan         |     26 |
| Lucas       |     26 |
| Sam         |     26 |
| Steven      |     26 |
| Tan         |     26 |
| Yu          |     26 |
| Adrian      |     25 |
| Alejandro   |     25 |
| Félix       |     25 |
| Matt        |     25 |
| Micha?      |     25 |
| Mohammad    |     25 |
| Tyler       |     25 |
| Yang        |     25 |
| Jack        |     24 |
| Róbert      |     24 |
| Vincent     |     24 |
| Wei         |     24 |
| Andy        |     23 |
| Erik        |     23 |
| Josh        |     23 |
| Maria       |     23 |
| Andreas     |     22 |
| Choi        |     22 |
| Joe         |     22 |
| Miguel      |     22 |
| Gábor       |     21 |
| Jan         |     21 |
| Mike        |     21 |
| Nicholas    |     21 |
| Pablo       |     21 |
| Ahmad       |     20 |
| Felipe      |     20 |
| Kai         |     20 |
| Kyle        |     20 |
| Samuel      |     20 |
| Austin      |     19 |
| Bruno       |     19 |
| Chen        |     19 |
| Jeremy      |     19 |
| Jessica     |     19 |
+-------------+--------+

No more than 3 persons share the same full name:

+----------------+--------+
| name           | people |
+----------------+--------+
| Hao Wang       |      3 |
| Li Li          |      3 |
| Wei Wang       |      3 |
| Wei Zhang      |      3 |
| Zheng Li       |      3 |
+----------------+--------+

 

[timeless]

Same first name:

[/QUOTE]
 
what about same last name?

 

[Mr.Toad]

The first and last name lists are not very meaningful because in the database 'name' represents the full name and it's impossible to decide what's what. In some countries they have two last names, and many people have several first names too, and also the concept of 'first name' and 'last name' is different in some parts of the world.

Anyway, assuming that the first word is the first name, and the rest is the last name, this is the list for the most popular last names:

+-------------+--------+
| firstName   | people |
+-------------+--------+
| Wang (???)  |    143 |
| Li (???)    |    113 |
| Zhang (???) |    105 |
| Chen (???)  |    102 |
| Liu (???)   |     85 |
| Chen        |     79 |
| Wang        |     77 |
| Li          |     70 |
| Wu (???)    |     63 |
| Lin (???)   |     53 |
| Zhang       |     47 |
| Liu         |     46 |
| Huang (???) |     43 |
| Wu          |     43 |
| Lin         |     42 |
| Zhang (??)  |     42 |
| Wang (??)   |     41 |
| Lee         |     40 |
| Li (??)     |     40 |
| Yang (???)  |     38 |
| Xu (???)    |     37 |
| Zhao (???)  |     36 |
| Nguyen      |     35 |
| Liu (??)    |     31 |
| Lu (???)    |     28 |
| Kumar       |     27 |
| Huang       |     26 |
| Sun (???)   |     26 |
| Hu (???)    |     25 |
| Chan        |     24 |
| Chang       |     24 |
| Jiang (???) |     24 |
| Kim         |     24 |
| Yang (??)   |     24 |
| Wong        |     22 |
| Xu          |     22 |
| Zheng (???) |     22 |
| Zhou (???)  |     22 |
| Singh       |     21 |
| Zhu (???)   |     21 |
| Yu          |     20 |
| Yu (???)    |     20 |
| Johnson     |     19 |
| Chen (??)   |     18 |
| Gao (???)   |     18 |
| Lu          |     18 |
| Ma (???)    |     18 |
| Tran        |     18 |
| Wu (??)     |     18 |
| He (???)    |     17 |
| Liang (???) |     17 |
| Zhao        |     16 |
| Guo (???)   |     15 |
| Gupta       |     15 |
| Park        |     15 |
| Shah        |     15 |
| Yang        |     15 |
| Smith       |     14 |
| Xie (???)   |     14 |
| Xu (??)     |     14 |
| Zhu         |     14 |
| Agarwal     |     13 |
| Brown       |     13 |
| Cheng       |     13 |
| Jiang       |     13 |
| Luo (???)   |     13 |
| Shi (???)   |     13 |
| Sun         |     13 |
| Fan (???)   |     12 |
| Sharma      |     12 |
| Shi (??)    |     12 |
| Tang        |     12 |
| Zeng (???)  |     12 |
| Zhong (???) |     12 |
| Cao (???)   |     11 |
| Chang (???) |     11 |
| Du (???)    |     11 |
| Ho          |     11 |
| Jain        |     11 |
| Lai         |     11 |
| Lam         |     11 |
| Le          |     11 |
| Wei         |     11 |
| Young       |     11 |
| Zhao (??)   |     11 |
| Zheng (??)  |     11 |
| Zhou (??)   |     11 |
| Cai (???)   |     10 |
| Feng        |     10 |
| Han (???)   |     10 |
| He          |     10 |
| Hong        |     10 |
| Kang        |     10 |
| Qiu (???)   |     10 |
| Rodriguez   |     10 |
| Shen (???)  |     10 |
| Song (???)  |     10 |
| Tan         |     10 |
| Tian (???)  |     10 |
| Wei (???)   |     10 |
+-------------+--------+

About the Wang ID problem, it was close: 2009WANG85

 

[Stefan]

No more than 3 persons share the same full name:

+----------------+--------+
| name           | people |
+----------------+--------+
| Hao Wang       |      3 |
| Li Li          |      3 |
| Wei Wang       |      3 |
| Wei Zhang      |      3 |
| Zheng Li       |      3 |
+----------------+--------+

Actually, there are more:

Hao Wang
Kevin Lee
Li Li
Peng Zhang
Wei Li
Wei Wang
Wei Zhang
Yan Zhang
Yang Liu
Yiming Liu
Zheng Li

 

[Mr.Toad]

Actually, there are more:

Hao Wang
Kevin Lee
Li Li
Peng Zhang
Wei Li
Wei Wang
Wei Zhang
Yan Zhang
Yang Liu
Yiming Liu
Zheng Li

I wasn't considering those with a number at the end as equals... but even if you disregard the number, the biggest group has only three members