Number of comps by person per year and total

K

keemy

Regular
Joined
Dec 29, 2007
Messages
151
WCA ID
2006CORR01
Was bored and wanted to see how far I was from top 10 (and see if I was making headway)

top 25(per year and overall)
http://dl.dropbox.com/u/922232/topcompsyear.txt

top 500(per year and overall)
http://dl.dropbox.com/u/922232/topcompslots.txt

Thanks to Patrick Jameson for making the script!!

(not the 100th post I intended to make but good enough heh)

Allowed use: Information and parts of it may be published online,
but only under the following conditions:
- A clearly visible link to World Cube Association website is added
(http://www.worldcubeassociation.org) with the notification that
World Cube Association is the source and owner of the information.
- A clearly visible notification is added that the published information
is not actual information.
- A clearly visible link to http://www.worldcubeassociation.org/results is
added with the notification that the actual information can be found via
that link.
- A clearly visible notification which date is taken for the source of the data.
- The style and format of the information must be clearly distinguishable
from the official WCA website
 
Last edited:
I like how (since I started going to comps) even years I have been top 25 but odd years I have just missed it. I hope to break this trend in 2011 though =].
 
WCA delegates and Organisational Teams

Is anyone bored enough to come up with the following?
  • Number of competitions by WCA delegate per year and total.
  • Number of competitions by Organisational Team per year and total.

Tim.
 
TimMc said:
Is anyone bored enough to come up with the following?

  • Number of competitions by WCA delegate per year and total.
  • Number of competitions by Organisational Team per year and total.
Click to expand...

Here's the SQL to get started.

SELECT wcaDelegate, COUNT( * ) AS total
FROM Competitions
WHERE year =2010
GROUP BY wcaDelegate
ORDER BY total DESC


But it's not perfect, since WCA delegates that are listed under multiple e-mail address show up as separate people (I show up under three different addresses), and competitions that have multiple delegates aren't split up. Not sure if that can be correctly complete in MySQL or if you need to do some other processing on the data.

And organizer is even more difficult because "Caltech Cube Club" will include different people depending on when it occurred. And sometimes the delegate is the organizer but not listed as such.
 
Ah, updated to this weekend I'm in the top 25 for competitions this year. We were looking at this in Toronto and realized the 4 of us in the room (Dave, Tim, Rowe and myself) were all in the top 48 for all time competitions. Pretty amazing how much time we've spent at tournaments.
 
Last edited:
You must log in or register to reply here.

Similar threads

J
4x4x4 Rubik's Cube God's Number : OBTM ≤ 53 and BT ≤ 51 Upper Bound
Replies
0
Views
29
Jiwon Byun Soongsil Univ
J
B
Overestimated number of cube states on cube20.org?
Replies
1
Views
369
xyzzy
X
B
God's number for the FTO
Replies
10
Views
852
BadDisplayName
B
iguana
What is God's number for a 3-gen scramble?
Replies
8
Views
677
Bruce MacKenzie
Bruce MacKenzie
A
4x4x4 OBTM (WTM) upper bound improved from 55 to 54
Replies
1
Views
489
SpeedCubingLord
SpeedCubingLord
Back
Top