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. macky

    macky Premium Member

    400
    0
    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. Schmidt

    Schmidt Member

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

    kinch2002 Premium Member

    2,503
    2
    Dec 22, 2008
    Guildford! UK!
    WCA:
    2009SHEP01
    YouTube:
    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. collinbxyz

    collinbxyz Member

    1,237
    4
    Sep 20, 2010
    Philadelphia PA
    WCA:
    2010BURN01
    YouTube:
    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. PatrickJameson

    PatrickJameson Premium Member

    997
    0
    Apr 15, 2008
    Buffalo, NY
    WCA:
    2007JAME01
    YouTube:
    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 Garron

    Lucas Garron Super-Duper Moderator Staff 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. oranjules

    oranjules Member

    86
    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 :p
    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. Kirjava

    Kirjava Colourful

    6,129
    4
    Mar 26, 2006
    WCA:
    2006BARL01
    YouTube:
    snkenjoi
    Who the hell is Joey Gouly?
     
  9. Stefan

    Stefan Member

    7,289
    2
    May 7, 2006
    WCA:
    2003POCH01
    YouTube:
    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. oranjules

    oranjules Member

    86
    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. Stefan

    Stefan Member

    7,289
    2
    May 7, 2006
    WCA:
    2003POCH01
    YouTube:
    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. oranjules

    oranjules Member

    86
    0
    Oct 29, 2010
    WCA:
    2010DESJ01
    well, i assume i'm wrong :p
     
  13. stricgoogle

    stricgoogle Member

    23
    0
    May 24, 2011
    Slovenia
    YouTube:
    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 :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: Dec 23, 2011
  14. Blake4512

    Blake4512 Member

    410
    1
    Dec 14, 2009
    Michigan
    WCA:
    2010THOM03
    YouTube:
    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. Henrik

    Henrik Member

    493
    0
    Aug 15, 2007
    Fyn, Denmark
    WCA:
    2006BUUS01
    YouTube:
    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. cmhardw

    cmhardw Premium Member

    4,091
    10
    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. Blake4512

    Blake4512 Member

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

    Gunnar Member

    231
    0
    May 7, 2006
    Norrköping, Sweden
    WCA:
    2004KRIG01
    YouTube:
    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. Kian

    Kian Member

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

    Hippolyte!!! Member

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

Share This Page