• Welcome to the Speedsolving.com, home of the web's largest puzzle community!
    You are currently viewing our forum as a guest which gives you limited access to join discussions and access our other features.

    Registration is fast, simple and absolutely free so please, join our community of 30,000+ people from around the world today!

    If you are already a member, simply login to hide this message and begin participating in the community!

WCA Statistics Website

macky

Premium Member
Joined
Apr 4, 2006
Messages
402
Likes
4
Location
Stanford, CA
WCA
2003MAKI01
Thread starter #1
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:
Joined
Sep 20, 2010
Messages
1,237
Likes
7
Location
Philadelphia PA
WCA
2010BURN01
YouTube
Collinbxyz
#4
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:

MySQL Query

SELECT personCountryId,
SUM(IF(pos = 1, 1, 0)) AS gold,
SUM(IF(pos = 2, 1, 0)) AS silver,
SUM(IF(pos = 3, 1, 0)) AS bronze,
SUM(IF(pos <= 3, 1, 0)) AS total
FROM Results
JOIN Competitions
WHERE Results.competitionId = Competitions.id AND
(competitionId = 'WC2011' OR
competitionId = 'WC2009' OR
competitionId = 'WC2007' OR
competitionId = 'WC2005' OR
competitionId = 'WC2003' OR
competitionId = 'WC1982')
AND best >0 AND (roundId = 'f' OR roundId = 'c')
GROUP BY personCountryId
ORDER BY gold DESC, silver DESC, bronze DESC, personCountryId
 

PatrickJameson

Premium Member
Joined
Apr 15, 2008
Messages
996
Likes
1
Location
Buffalo, NY
WCA
2007JAME01
YouTube
rubiksmaster12
#5
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:
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.

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...
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:
Joined
Oct 29, 2010
Messages
90
Likes
12
WCA
2010DESJ01
#7
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 :p
competitionId eventId personName personId personCountryId

BelgianOpen2008 333 Milán Baticz 2005BATI01 Hungary
PoznanOpen2008 222 Szczepan Łągiewka 2007LAGI01 Poland
BarcelonaOpen2009 333 Jimmy Coll 2006COLL01 Belgium
SanDiegoOpen2009 333 Phillip Espinoza 2007ESPI01 USA
TaiwanSpringOpen2009 333 Han-Cyun Chen (陳翰群) 2008CHEN06 Taiwan
MadridOpen2009 333 Alejandro Aguado Barahona 2007AGUA01 Spain
DutchOpen2009 pyram Olivier Polspoel 2007POLS01 Belgium
Thankscubing2009 333 Chester Lian 2009LIAN03 Malaysia
SpanishChampionship2009 pyram Pau Vela García 2009GARC04 Spain
SpanishChampionship2009 pyram Jordi Piqueras Gómez 2008PIQU01 Spain
ChicagoOpen2010 333 Justin Jaffray 2008JAFF01 Canada
TaiwanWinterOpen2010 333 Hsuan Chang (張璿) 2008CHAN09 Taiwan
NorwegianOpen2010 333 Hong Tan Lam 2008LAMH01 Norway
PolishOpen2010 333 Piotr Kózka 2005KOZK01 Poland
MadridOpen2010 333 Rodrigo Septién Rodríguez 2008SEPT01 Spain
BerkeleySpring2010 333 Justin Adsuara 2007ADSU01 USA
DiscoveryScience2010 333 Deven Nadudvari 2008NADU01 USA
BerkeleySummer2010 333 Dan Dzoan 2006DZOA03 USA
BerkeleySummer2010 333 David Gomes 2006GOME01 USA
USNationals2010 333 Joey Gouly 2007GOUL01 United Kingdom
USNationals2010 333 Emily Wang 2009WANG15 Canada
PolishNationals2010 333 Michał Robaczyk 2006ROBA01 Poland
PhilippinesOpen2010 333 Richard Jay S. Apagar 2010APAG01 Philippines
Euro2010 333 Moritz Karl 2008KARL02 Germany
MunichOpen2010 222 Hendrik Hammer 2010HAMM02 Germany
NaonedOpen2010 333 Antoine Piau 2008PIAU01 France
MITFall2010 333 Patricia Li 2009LIPA01 USA
SwedishCubedays2010 333 Harald Stiff 2009STIF01 Sweden
IshikawaGokokuShintoOpen2010 333 Nobuaki Suga (菅 信昭) 2007SUGA01 Japan
SpanishChampionship2010 333 Jorge Morata Carrasco 2008MORA02 Spain
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:
Joined
May 7, 2006
Messages
7,287
Likes
29
WCA
2003POCH01
YouTube
StefanPochmann
#9
13.37 single is impossible to obtain
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:
Joined
May 7, 2006
Messages
7,287
Likes
29
WCA
2003POCH01
YouTube
StefanPochmann
#11
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...
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:
Joined
May 24, 2011
Messages
23
Likes
0
Location
Slovenia
YouTube
MrCiguma
#13
@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 :p), 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:
Joined
Aug 15, 2007
Messages
494
Likes
2
Location
Fyn, Denmark
WCA
2006BUUS01
YouTube
henrikthedane
#15

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:

cmhardw

Premium Member
Joined
Apr 5, 2006
Messages
4,105
Likes
124
Location
Atlanta, Georgia
WCA
2003HARD01
#16
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.
 
Joined
May 7, 2006
Messages
231
Likes
0
Location
Norrköping, Sweden
WCA
2004KRIG01
YouTube
GunnarKrig
#18
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.
 
Top