# WCA Statistics Website

Discussion in 'General Speedcubing Discussion' started by macky, Dec 22, 2011.

Welcome to the Speedsolving.com. You are currently viewing our boards as a guest which gives you limited access to join discussions and access our other features. By joining our free community of over 30,000 people, you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us and we'll help you get started. We look forward to seeing you on the forums!

Already a member? Login to stop seeing this message.
1. ### mackyPremium Member

401
2
Apr 4, 2006
Stanford, CA
WCA:
2003MAKI01
Since the official WCA Statistics page is necessarily limited in scope, I'm setting up a WCA Statistics Website (thanks Lucas!). For now, I've put an All-Time World Championship Medal Table.

Goals:
* (unofficial) updated statistics on one website
* user-submitted statistics code (php and MySQL)

Regarding the first point: Although popular statistics may be incorporated into the official WCA Statistics page, some statistics are inherently unofficial, e.g. different proposed global ranking systems. The hope, moreover, is to encourage cubers, especially those without server access, to learn and experiment with php and MySQL.

To do:
* think about how best to set up user submission

If you'd like to contribute statistics code or help with the project, please contact me.

macky

Last edited: Dec 23, 2011
2. ### SchmidtMember

Feb 4, 2011
8620 Danmark
WCA:
2012SCHM07
It is nothing much, but could you put numbers in front of the country names??

3. ### kinch2002Premium Member

Dec 22, 2008
Guildford! UK!
WCA:
2009SHEP01
kinch2002
I'd like to know what program(s) I can get hold of to run SQL queries on the data base myself. I do this sort of thing at work, but have no software at home...

4. ### collinbxyzMember

Sep 20, 2010
WCA:
2010BURN01
Collinbxyz
Great idea. I will try to contribute, but I don't know how much I could actually do.

Just a little error, at the bottom of the medal table, I see this:

5. ### PatrickJamesonPremium Member

997
0
Apr 15, 2008
Buffalo, NY
WCA:
2007JAME01
rubiksmaster12
That is supposed to be there. This is the "code"(MySQL script) that was run against the database in order to get the table. It is there for reference.

You can download the WCA db here.

You'll have to do research to be able to run queries against the database on your platform.

Last edited: Dec 22, 2011
6. ### Lucas GarronSuper-Duper ModeratorStaff Member

Here's my long list of crazy statistics ideas from a 3 years ago. I don't plan to spend time on this, so y'all should feel free to implement any of them that you find interesting.

7. ### oranjulesMember

87
0
Oct 29, 2010
WCA:
2010DESJ01
13.37 single is impossible to obtain, so do you want the averages ?
I wanted to do that but the database is too big, i can't import it -_- (even in zip format)
EDIT : ok, found a way to do it, here is the query :
Code:
SELECT competitionId, eventId, personName, personId, personCountryId
FROM results
WHERE average =1337
I don't know how to make the results pretty, so here is a non-pretty version
The most impressive thing is that a lot of them are well-known ! (Emily Wang, Milan Baticz, Jimmy Coll, Chester Lian, Joey Gouly...)

Last edited: Dec 23, 2011
8. ### KirjavaColourful

6,123
21
Mar 26, 2006
WCA:
2006BARL01
snkenjoi
Who the hell is Joey Gouly?

9. ### StefanMember

7,287
11
May 7, 2006
WCA:
2003POCH01
StefanPochmann
Not true... 21 people have managed that (four this year), Phillip Espinoza even twice! Edit: And I just saw him in your average list. Also, Pau Vela García got 13.37 average twice but never single. Besides those two, 61 people got one single or average 13.37.

Last edited: Dec 23, 2011
10. ### oranjulesMember

87
0
Oct 29, 2010
WCA:
2010DESJ01
these must be 11.37 +2, i saw in an other topic (maybe the "odd wca stats") that the stackmat timer can't do this time...

11. ### StefanMember

7,287
11
May 7, 2006
WCA:
2003POCH01
StefanPochmann
Unlikely:
There have been 22 single 13.37s.
There have been 11 single 11.37s.
Why would a big majority of the 11.37s get +2s?

Continuing down:
There have been 13 single 9.37s.
There have been 8 single 7.37s.
There have been 6 single 5.37s.
There have been 25 single 3.37s.
There have been 18 single 1.37s.

And for comparison:
There have been 366 single 13.36s.
There have been 358 single 13.38s.

Last edited: Dec 23, 2011
12. ### oranjulesMember

87
0
Oct 29, 2010
WCA:
2010DESJ01
well, i assume i'm wrong

23
0
May 24, 2011
Slovenia
MrCiguma
@Stefan
The big majority would be because it seems like the only explanation.

Though, there could be a mistake, like judge's handwriting being hard to read (I could definitely be the judge here ), judge writting the time incorectly, even judge intentionally writing wrong, or a QJ timer.

The 13.36, and 13.38 comparison actually favors the +2 theory,
since you can't get 13.37 on a Stackmat, it isn't as common as those two are.

EDIT:
Ok, it seems the non-memory timers are responsible for most of them.

Last edited: Dec 23, 2011
14. ### Blake4512Member

413
5
Dec 14, 2009
Michigan
WCA:
2010THOM03
xblakethompson
@Stefan 13.37 might not be an impossible time but it is really rare to get. The people that got a 13.37 single might have used the timers before the memory timer because the memory timer skips times.

15. ### HenrikMember

494
2
Aug 15, 2007
Fyn, Denmark
WCA:
2006BUUS01
henrikthedane

I don't know what timer version is used, but this proves that 13.37 should be possible.

(took like 10 sec to search on youtube, maybe because I knew there had been a video up sometime (and still is))

Last edited by a moderator: Apr 7, 2016
16. ### cmhardwPremium Member

4,102
84
Apr 5, 2006
Atlanta, Georgia
WCA:
2003HARD01
There should be a picture from Worlds 2007 where two people practicing on stage got 13.37 singles on 3x3 at the same time, and at timers fairly close to each other. I remember both solvers pausing so that audience members could take pictures (this was during warm-ups, not during any round). Sadly I don't remember who the two solvers were, I only remember the incident.

17. ### Blake4512Member

413
5
Dec 14, 2009
Michigan
WCA:
2010THOM03
xblakethompson
idk I could be wrong. We could ask some sport stackers or something and see if they think it's possible..?

18. ### GunnarMember

231
0
May 7, 2006
Norrköping, Sweden
WCA:
2004KRIG01
GunnarKrig
The times that seemingly can't be gotten on stackmats nowadays are possible on older timers. My timer is from 2005 and I can get 13.37, 9.99, 0.99, 1.00, 1.01 etc.

Maybe most (if not all) 13.37 was obtained with older timers?

By some weird reason it seems as they went from a perfectly fine time chip to a worse one a few years back. I hope the new 3-digit timers are more accurate.

19. ### KianMember

May 22, 2008
East Brunswick, NJ
WCA:
2007BARR01
xkiesterx
The DNFs, Sub X and WCA Growth tabs don't open for me. Is that the case for anyone else?

20. ### Hippolyte!!!Member

116
0
Apr 24, 2010
WCA:
2008MORE02
That's the case for me for the two first.