Odd WCA stats/ Stats request Thread

[Eagle]

Best single in first competition

Hi everyone!

I just entered my first competition and got a 8.93 single. I'm a bit curious if that's the best time someone ever has gotten on his first competition. If you know any better time please tell me!
Thanks!!

 

[MarcelP]

That is pretty awesome. I got a 34.something as my first single best in competition.

 

[vd]

http://worldcubeassociation.org/results/p.php?i=2011PENG04

He has got 8.11 in round 2 of his first comp. Yout time is still pretty awesome, though.

 

[Stefan]

All sub-10:

2011PENG04 8.11
2011SANJ01 8.56
2012ROQU01 8.86
2012TANG08 8.93
2011LINA01 9.18
2012MURC01 9.21
2010DUON01 9.31
2011RETZ02 9.31
2011IIDA01 9.44
2011CHUN01 9.66
2010PHAM08 9.75
2010HOAN06 9.84
2010SUGA01 9.86
2011ZENG06 9.86
2009YAUR01 9.90
2010ZHON03 9.93
2011GOTT03 9.96

SELECT Results.personId, min(best)/100 foo
FROM Results, Competitions, (SELECT personId, min(year*10000+month*100+day) firstDate
FROM Results, Competitions
WHERE Competitions.id = competitionId
GROUP BY personId) tmp
WHERE Competitions.id = competitionId
AND Results.personId = tmp.personId
AND year*10000+month*100+day = firstDate
AND eventId = '333' AND best > 0
GROUP BY personId
ORDER BY foo

Next would be Feliks but he only managed 10.05.

And the best newcomer averages:

2011LINA01 10.00
2012ROQU01 10.36
2011IIDA01 10.87
2011ZENG06 11.08
2011SHAO01 11.27
2012NIGU01 11.37
2012MURC01 11.41
2012LOKW01 11.42
2011GOTT03 11.50
2012CHOS01 11.57
2011RETZ02 11.62
2007JEON01 11.76
2012LIYA01 11.84
2011SANC02 11.93
2011BARB03 11.94
2011LOPR01 11.98
2012KALE01 12.03
2011DAOQ02 12.12
2010TERU01 12.14
2010SUGA01 12.20
2012YUTA01 12.28
2011CHUN01 12.29
2011LAUA01 12.30
2012TANG08 12.32
2011HIEU01 12.36
2009PICH01 12.43
2011LUDW01 12.45
2012ZHAN26 12.51
2011SUNG01 12.54
2009ZEMD01 12.55

 

[evogler]

Is there a way to view the history of records for all events, sorted chronologically?
Like all the items on http://worldcubeassociation.org/results/regions.php?regionId=&eventId=&years=&history=History sorted by date...

 

[MAHTI-ANSSI]

Request: fastest over 50-year old OHers

 

[Pro94]

Over 20'000 competitors on WCA.
http://worldcubeassociation.org/results/persons.php?eventId=&regionId=&pattern=+&search=Search

 

[nickvu2]

Over 20'000 competitors on WCA.
http://worldcubeassociation.org/results/persons.php?eventId=®ionId=&pattern=+&search=Search

Would searching " " show people with only single names?

 

[TMOY]

http://www.worldcubeassociation.org/results/p.php?i=2012MUSO01

lo... given that there were exacty 16 competitors at that comp, it looks pretty much like:

- Hey man, we need a 16th competitor to get a third round of 3^3, would you like to compete ?
- But I can' even solve the cube !
- Not a problem. Just come on and sit there.

 

[Pro94]

Would searching " " show people with only single names?

From what i saw searching " " shows you every people on WCA.
I searched cubers in Asia and gave me 8746, then i searched cubers in Asia with " " in name and i got the same number; so i think no one is excluded.
But i need to type " " because if you choose "World" as region without any name it doesn't show you anyone.

Edit: you if choose in "region" a blank line you get the same number when you type " ".

 

[ben1996123]

http://www.worldcubeassociation.org/results/p.php?i=2012MUSO01

lo... given that there were exacty 16 competitors at that comp, it looks pretty much like:

- Hey man, we need a 16th competitor to get a third round of 3^3, would you like to compete ?
- But I can' even solve the cube !
- Not a problem. Just come on and sit there.

dikshit

http://www.worldcubeassociation.org/results/p.php?i=2010GOEL01

 

[Ollie]

dikshit

http://www.worldcubeassociation.org/results/p.php?i=2010GOEL01

is this a joke one?

EDIT: no! pronounced dixit

 

[MaeLSTRoM]

http://worldcubeassociation.org/results/misc/sum_of_ranks/

Woop.

 

[hcfong]

dikshit

http://www.worldcubeassociation.org/results/p.php?i=2010GOEL01

Did you check out the competition website? Bottom 5 all had 5 DNFs and I could have podiumed there.

 

[uberCuber]

http://worldcubeassociation.org/results/misc/sum_of_ranks/

Woop.

Now they just need to remove magic and mastermagic

 

[Noahaha]

I've competed in 4x4 at 10 competitions (all 10 that I've been to), but 3x3 at only 9 of them because I showed up late to Yale Fall 2012. My question is: of the people who have competed in 4x4 more times than they have competed in 3x3, who has competed in 3x3 the most times?

 

[Michael Womack]

Can someone give me the location of all of the past US nats. and worlds. and the winners of each one of them.

 

[TheNextFeliks]

Can someone give me the location of all of the past US nats. and worlds. and the winners of each one of them.

Come on. This is easy. Go to the WCA competition page and look for all of them. There aren't that many at all. That is just plain lazy.

 

[Bob]

Come on. This is easy. Go to the WCA competition page and look for all of them. There aren't that many at all. That is just plain lazy.

It's even easier than that:
http://www.cubingusa.com/wc2013/
http://www.cubingusa.com/usnationals2012/

 

[Coolster01]

Now they just need to remove magic and mastermagic

That would make my ranking drop a ton, and most others improve a ton. This is gonna cause a problem.