• Welcome to SpeedSolving.com — the world’s largest puzzle community!

    You’re currently browsing as a guest, which means you have limited access to discussions, resources, member profiles, and community features.

    Join 50,000+ cubers and puzzle enthusiasts from around the world to ask questions, share solves, improve faster, and be part of the community.

    Registration is free, fast, and easy — create your account today.

    Already a member? Log in here to hide this message and start participating.

Odd WCA stats/ Stats request Thread

Yep, that one. Says "Multiple cities". You guys are extremely consistent with including the state with the city. Guess you have to. Still waiting for a Springfield competition, though.
 
Stefan said:
Odd: Of the 389 competitions in USA that the database knows, only one doesn't have a comma (like "Dallas, Texas") in the "cityName".
Click to expand...

Stefan said:
Yep, that one. Says "Multiple cities". You guys are extremely consistent with including the state with the city. Guess you have to. Still waiting for a Springfield competition, though.
Click to expand...
Or in Dallas, Oregon
 
Stefan said:
Yep, that one. Says "Multiple cities". You guys are extremely consistent with including the state with the city. Guess you have to. Still waiting for a Springfield competition, though.
Click to expand...

What might be fun: Have our next FMC USA competition in Springfield. It might be sad, though, because it would leave Maryland and Washington out.
 
Mike Hughey said:
What might be fun: Have our next FMC USA competition in Springfield. It might be sad, though, because it would leave Maryland and Washington out.
Click to expand...

What do you mean it would leave Maryland and Washington out?

chungdavi said:
May I know which competition has the longest name?
Click to expand...

Using data from WCA_export475_20140924 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Name[/TD][TD]Length[/TD][TD]Country[/TD][/TR]
[TR][TD]TUT 2013[/TD][TD="align:right"]8[/TD][TD]China[/TD][/TR]
[TR][TD]ABHC 2014[/TD][TD="align:right"]9[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]SIGI 2014[/TD][TD="align:right"]9[/TD][TD]Mexico[/TD][/TR]
[TR][TD]DRACO 2013[/TD][TD="align:right"]10[/TD][TD]Brazil[/TD][/TR]
[TR][TD]Fénix 2014[/TD][TD="align:right"]10[/TD][TD]Mexico[/TD][/TR]
[TR][TD]Osaka 2011[/TD][TD="align:right"]10[/TD][TD]Japan[/TD][/TR]
[TR][TD]Bayani 2012[/TD][TD="align:right"]11[/TD][TD]Philippines[/TD][/TR]
[TR][TD]Linkub 2014[/TD][TD="align:right"]11[/TD][TD]Sweden[/TD][/TR]
[TR][TD]PKU FM 2012[/TD][TD="align:right"]11[/TD][TD]China[/TD][/TR]
[TR][TD]Altbier 2011[/TD][TD="align:right"]12[/TD][TD]Germany[/TD][/TR]
[TR][TD]Altbier 2012[/TD][TD="align:right"]12[/TD][TD]Germany[/TD][/TR]
[TR][TD]Bangkok 2012[/TD][TD="align:right"]12[/TD][TD]Thailand[/TD][/TR]
[TR][TD]Boulder 2008[/TD][TD="align:right"]12[/TD][TD]USA[/TD][/TR]
[TR][TD]Boulder 2009[/TD][TD="align:right"]12[/TD][TD]USA[/TD][/TR]
[TR][TD]BW Open 2012[/TD][TD="align:right"]12[/TD][TD]Germany[/TD][/TR]
[TR][TD]BW Open 2013[/TD][TD="align:right"]12[/TD][TD]Germany[/TD][/TR]
[TR][TD]Cal Day 2012[/TD][TD="align:right"]12[/TD][TD]USA[/TD][/TR]
[TR][TD]DJ Open 2013[/TD][TD="align:right"]12[/TD][TD]India[/TD][/TR]
[TR][TD]DJ Open 2014[/TD][TD="align:right"]12[/TD][TD]India[/TD][/TR]
[TR][TD]FMC USA 2014[/TD][TD="align:right"]12[/TD][TD]USA[/TD][/TR]
[TR][TD]Indiana 2011[/TD][TD="align:right"]12[/TD][TD]USA[/TD][/TR]
[TR][TD]Indiana 2012[/TD][TD="align:right"]12[/TD][TD]USA[/TD][/TR]
[TR][TD]Indiana 2013[/TD][TD="align:right"]12[/TD][TD]USA[/TD][/TR]
[TR][TD]Indiana 2014[/TD][TD="align:right"]12[/TD][TD]USA[/TD][/TR]
[TR][TD]MIT FMC 2014[/TD][TD="align:right"]12[/TD][TD]USA[/TD][/TR]
[TR][TD]Taiyuan 2010[/TD][TD="align:right"]12[/TD][TD]China[/TD][/TR]
[TR][TD]Taiyuan 2011[/TD][TD="align:right"]12[/TD][TD]China[/TD][/TR]
[TR][TD]Tsukuba 2012[/TD][TD="align:right"]12[/TD][TD]Japan[/TD][/TR]
[TR][TD]UK Open 2006[/TD][TD="align:right"]12[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]UK Open 2007[/TD][TD="align:right"]12[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]UK Open 2008[/TD][TD="align:right"]12[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]UK Open 2009[/TD][TD="align:right"]12[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]UK Open 2010[/TD][TD="align:right"]12[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]UK Open 2011[/TD][TD="align:right"]12[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]UK Open 2012[/TD][TD="align:right"]12[/TD][TD]United Kingdom[/TD][/TR]
[TR][TD]US Open 2007[/TD][TD="align:right"]12[/TD][TD]USA[/TD][/TR]
[TR][TD]UT Open 2010[/TD][TD="align:right"]12[/TD][TD]Japan[/TD][/TR]
[TR][TD]UT Open 2011[/TD][TD="align:right"]12[/TD][TD]Japan[/TD][/TR]
[TR][TD]UT Open 2012[/TD][TD="align:right"]12[/TD][TD]Japan[/TD][/TR]
[TR][TD]UT Open 2013[/TD][TD="align:right"]12[/TD][TD]Japan[/TD][/TR]
[TR][TD]Wiscube 2014[/TD][TD="align:right"]12[/TD][TD]USA[/TD][/TR]
[/TABLE]

Code: 
[NOPARSE]SELECT name Name, char_length(name) Length, countryId Country
FROM Competitions
WHERE char_length(name) <= 12
ORDER BY 2, 1;[/NOPARSE]
UK Open 2006-2012
R.I.P.

Using data from WCA_export475_20140924 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Name[/TD][TD]Length[/TD][TD]Country[/TD][/TR]
[TR][TD]Henan University of Science & Technology Open 2011[/TD][TD="align:right"]50[/TD][TD]China[/TD][/TR]
[TR][TD]Campeonato de Cubos Mágicos de São Carlos/SP 2013[/TD][TD="align:right"]49[/TD][TD]Brazil[/TD][/TR]
[TR][TD]III Torneo Nacional de Speedcubing Colombia 2013[/TD][TD="align:right"]48[/TD][TD]Colombia[/TD][/TR]
[TR][TD]Beijing Mangshan National Forest Park Open 2010[/TD][TD="align:right"]47[/TD][TD]China[/TD][/TR]
[TR][TD]S.P.Q.R. Italian Rubik's Cube Championship 2010[/TD][TD="align:right"]47[/TD][TD]Italy[/TD][/TR]
[TR][TD]Singapore Special Rubik's Cube Competition 2013[/TD][TD="align:right"]47[/TD][TD]Singapore[/TD][/TR]
[TR][TD]Discovery Science Center 10th Anniversary 2008[/TD][TD="align:right"]46[/TD][TD]USA[/TD][/TR]
[TR][TD]Drexel's Winter 2010 Rubik's Cube Competition[/TD][TD="align:right"]45[/TD][TD]USA[/TD][/TR]
[TR][TD]United States Rubik's Cube Championships 2010[/TD][TD="align:right"]45[/TD][TD]USA[/TD][/TR]
[TR][TD]Avecina Autumn Rubik's Cube Competition 2012[/TD][TD="align:right"]44[/TD][TD]Iran[/TD][/TR]
[TR][TD]Pista'y Dayat Speed Cubing Championship 2014[/TD][TD="align:right"]44[/TD][TD]Philippines[/TD][/TR]
[TR][TD]Reno/Lake Tahoe Winter 2010 Cube Competition[/TD][TD="align:right"]44[/TD][TD]USA[/TD][/TR]
[/TABLE]

Code: 
[NOPARSE]SELECT name Name, char_length(name) Length, countryId Country
FROM Competitions
WHERE char_length(name) >= 44
ORDER BY 2 desc, 1;[/NOPARSE]
 
Last edited:
Oops. But anyway, why was it changed from Open to Championship after such a long time?

Edit: Found it.
kinch2002 said:
we are renaming this competition to UK Championship 2013 to reflect the fact that it is the major competition of the year and we want to properly name people as UK champions
Click to expand...

Edit 2: Fun fact: Thom is the only one who competed in all seven UK Open. Best place #5. Then they rename it and suddenly he wins :)

Using data from WCA_export475_20140924 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Cuber[/TD][TD]Number[/TD][TD]Years[/TD][/TR]
[TR][TD]Thom Barlow[/TD][TD="align:right"]7[/TD][TD]'06, '07, '08, '09, '10, '11, '12[/TD][/TR]
[TR][TD]Greg Austin[/TD][TD="align:right"]6[/TD][TD]'06, '07, '08, '09, '10, '12[/TD][/TR]
[TR][TD]Joey Gouly[/TD][TD="align:right"]6[/TD][TD]'07, '08, '09, '10, '11, '12[/TD][/TR]
[TR][TD]Breandan Vallance[/TD][TD="align:right"]6[/TD][TD]'07, '08, '09, '10, '11, '12[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD="align:right"]5[/TD][TD]'06, '07, '08, '09, '10[/TD][/TR]
[TR][TD]Sean Connolly[/TD][TD="align:right"]5[/TD][TD]'06, '07, '08, '10, '11[/TD][/TR]
[TR][TD]Charlie Cooper[/TD][TD="align:right"]5[/TD][TD]'07, '08, '09, '10, '11[/TD][/TR]
[TR][TD]Simon Crawford[/TD][TD="align:right"]5[/TD][TD]'08, '09, '10, '11, '12[/TD][/TR]
[TR][TD]Michael Erskine[/TD][TD="align:right"]5[/TD][TD]'08, '09, '10, '11, '12[/TD][/TR]
[TR][TD]Rowan Kinneavy[/TD][TD="align:right"]5[/TD][TD]'08, '09, '10, '11, '12[/TD][/TR]
[TR][TD]Joe Wallace[/TD][TD="align:right"]4[/TD][TD]'06, '07, '08, '09[/TD][/TR]
[TR][TD]Adam Wills[/TD][TD="align:right"]4[/TD][TD]'08, '09, '10, '11[/TD][/TR]
[TR][TD]Agassi Yiu (姚震聲)[/TD][TD="align:right"]4[/TD][TD]'08, '09, '10, '11[/TD][/TR]
[TR][TD]Andrew Coghill[/TD][TD="align:right"]4[/TD][TD]'09, '10, '11, '12[/TD][/TR]
[TR][TD]Daniel Sheppard[/TD][TD="align:right"]4[/TD][TD]'09, '10, '11, '12[/TD][/TR]
[TR][TD]Ben Whitmore[/TD][TD="align:right"]4[/TD][TD]'09, '10, '11, '12[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD="align:right"]3[/TD][TD]'06, '07, '08[/TD][/TR]
[TR][TD]Dan Harris[/TD][TD="align:right"]3[/TD][TD]'06, '07, '08[/TD][/TR]
[TR][TD]David Pemberton[/TD][TD="align:right"]3[/TD][TD]'06, '07, '08[/TD][/TR]
[TR][TD]Martin Berger[/TD][TD="align:right"]3[/TD][TD]'06, '08, '09[/TD][/TR]
[TR][TD]Arnaud van Galen[/TD][TD="align:right"]3[/TD][TD]'06, '09, '11[/TD][/TR]
[TR][TD]Chieh Lee (李杰)[/TD][TD="align:right"]3[/TD][TD]'07, '08, '09[/TD][/TR]
[TR][TD]Kang Lee (李綱)[/TD][TD="align:right"]3[/TD][TD]'07, '08, '09[/TD][/TR]
[TR][TD]Chris Lennon[/TD][TD="align:right"]3[/TD][TD]'07, '08, '09[/TD][/TR]
[TR][TD]Christopher Ness[/TD][TD="align:right"]3[/TD][TD]'08, '09, '10[/TD][/TR]
[TR][TD]James Dean Ludlow[/TD][TD="align:right"]3[/TD][TD]'09, '10, '11[/TD][/TR]
[TR][TD]Niamh McElhill[/TD][TD="align:right"]3[/TD][TD]'09, '10, '11[/TD][/TR]
[TR][TD]Conor Winters[/TD][TD="align:right"]3[/TD][TD]'09, '10, '11[/TD][/TR]
[TR][TD]Ayano Maria Yoshida[/TD][TD="align:right"]3[/TD][TD]'09, '10, '11[/TD][/TR]
[TR][TD]Chris Dickson[/TD][TD="align:right"]3[/TD][TD]'09, '11, '12[/TD][/TR]
[TR][TD]Martin Smith[/TD][TD="align:right"]3[/TD][TD]'09, '11, '12[/TD][/TR]
[TR][TD]Sam Zhixiao Wang (王志骁)[/TD][TD="align:right"]3[/TD][TD]'10, '11, '12[/TD][/TR]
[TR][TD]Robert Yau[/TD][TD="align:right"]3[/TD][TD]'10, '11, '12[/TD][/TR]
[TR][TD]Luke Hudlass-Galley[/TD][TD="align:right"]3[/TD][TD]'10, '11, '12[/TD][/TR]
[TR][TD]Leon Parfitt[/TD][TD="align:right"]3[/TD][TD]'10, '11, '12[/TD][/TR]
[/TABLE]

Code: 
[NOPARSE]SELECT
  personId Cuber,
  count(distinct competitionId) Number,
  group_concat(distinct concat("'",substring(competitionId,9)) order by competitionId separator ', ') Years
FROM Results
WHERE competitionId like 'UKOpen20%'
GROUP BY personId
HAVING Number >= 3
ORDER BY Number desc, Years, Cuber;[/NOPARSE]
 
Last edited:
Similar statistic for the major comps in USA (one each year, US Open/Nats, and WC for '05/'13 because it "replaced" the US Open/Nats in those years):
Using data from WCA_export475_20140924 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Cuber[/TD][TD]Number[/TD][TD]Years[/TD][/TR]
[TR][TD]Shelley Chang[/TD][TD="align:right"]11[/TD][TD]'04, '05, '06, '07, '08, '09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Adam Zamora[/TD][TD="align:right"]11[/TD][TD]'04, '05, '06, '07, '08, '09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD="align:right"]10[/TD][TD]'05, '06, '07, '08, '09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Tyson Mao (毛台勝)[/TD][TD="align:right"]9[/TD][TD]'05, '06, '07, '08, '09, '10, '11, '12, '13[/TD][/TR]
[TR][TD]Jasmine Lee[/TD][TD="align:right"]8[/TD][TD]'04, '05, '08, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Stefan Pochmann[/TD][TD="align:right"]8[/TD][TD]'05, '07, '08, '09, '10, '11, '12, '13[/TD][/TR]
[TR][TD]Dan Dzoan[/TD][TD="align:right"]8[/TD][TD]'06, '07, '08, '09, '10, '11, '12, '13[/TD][/TR]
[TR][TD]Chris Krueger[/TD][TD="align:right"]8[/TD][TD]'06, '07, '08, '09, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Tim Reynolds[/TD][TD="align:right"]8[/TD][TD]'06, '08, '09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Devin Corr-Robinett[/TD][TD="align:right"]8[/TD][TD]'06, '08, '09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Bruce Norskog[/TD][TD="align:right"]8[/TD][TD]'06, '08, '09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD="align:right"]8[/TD][TD]'07, '08, '09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Leyan Lo[/TD][TD="align:right"]7[/TD][TD]'04, '05, '06, '07, '08, '09, '10[/TD][/TR]
[TR][TD]Ian Winokur[/TD][TD="align:right"]7[/TD][TD]'04, '05, '08, '09, '10, '13, '14[/TD][/TR]
[TR][TD]Shotaro Makisumi (牧角章太郎)[/TD][TD="align:right"]7[/TD][TD]'04, '05, '09, '10, '11, '12, '13[/TD][/TR]
[TR][TD]Daniel Lo[/TD][TD="align:right"]7[/TD][TD]'05, '06, '07, '10, '12, '13, '14[/TD][/TR]
[TR][TD]Casey Pernsteiner[/TD][TD="align:right"]7[/TD][TD]'05, '06, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Dave Campbell[/TD][TD="align:right"]7[/TD][TD]'05, '07, '09, '10, '11, '12, '13[/TD][/TR]
[TR][TD]Peter Still[/TD][TD="align:right"]7[/TD][TD]'05, '08, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Ambie Valdés[/TD][TD="align:right"]7[/TD][TD]'06, '07, '08, '10, '11, '12, '13[/TD][/TR]
[TR][TD]Toby Mao (毛台立)[/TD][TD="align:right"]7[/TD][TD]'06, '07, '09, '10, '11, '12, '13[/TD][/TR]
[TR][TD]Chris Dzoan[/TD][TD="align:right"]7[/TD][TD]'06, '07, '09, '10, '11, '13, '14[/TD][/TR]
[TR][TD]Arthur Adams[/TD][TD="align:right"]7[/TD][TD]'06, '08, '09, '10, '11, '12, '13[/TD][/TR]
[TR][TD]Lucas Garron[/TD][TD="align:right"]7[/TD][TD]'06, '08, '09, '10, '11, '13, '14[/TD][/TR]
[TR][TD]Mike Hughey[/TD][TD="align:right"]7[/TD][TD]'07, '08, '09, '10, '11, '12, '13[/TD][/TR]
[TR][TD]Dan Cohen[/TD][TD="align:right"]7[/TD][TD]'07, '08, '09, '10, '11, '13, '14[/TD][/TR]
[TR][TD]Timothy Sun[/TD][TD="align:right"]7[/TD][TD]'07, '08, '09, '10, '12, '13, '14[/TD][/TR]
[TR][TD]Jeremy Fleischman[/TD][TD="align:right"]7[/TD][TD]'08, '09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Takao Hashimoto (橋本貴夫)[/TD][TD="align:right"]7[/TD][TD]'08, '09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Andrew Nelson[/TD][TD="align:right"]7[/TD][TD]'08, '09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Felix Lee[/TD][TD="align:right"]7[/TD][TD]'08, '09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Jeremy Dixon[/TD][TD="align:right"]6[/TD][TD]'04, '05, '06, '07, '09, '12[/TD][/TR]
[TR][TD]Chris Hardwick[/TD][TD="align:right"]6[/TD][TD]'04, '05, '06, '08, '10, '13[/TD][/TR]
[TR][TD]Lars Petrus[/TD][TD="align:right"]6[/TD][TD]'04, '05, '06, '09, '12, '13[/TD][/TR]
[TR][TD]Ravi Fernando[/TD][TD="align:right"]6[/TD][TD]'06, '08, '09, '11, '12, '13[/TD][/TR]
[TR][TD]Nick Young[/TD][TD="align:right"]6[/TD][TD]'08, '09, '10, '11, '12, '13[/TD][/TR]
[TR][TD]Marie Hughey[/TD][TD="align:right"]6[/TD][TD]'08, '09, '10, '11, '12, '13[/TD][/TR]
[TR][TD]Rebecca Hughey[/TD][TD="align:right"]6[/TD][TD]'08, '09, '10, '11, '12, '13[/TD][/TR]
[TR][TD]David Gomes[/TD][TD="align:right"]6[/TD][TD]'09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Jim Mertens[/TD][TD="align:right"]6[/TD][TD]'09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Cameron Brown[/TD][TD="align:right"]6[/TD][TD]'09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Weston Mizumoto[/TD][TD="align:right"]6[/TD][TD]'09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Anthony Brooks[/TD][TD="align:right"]6[/TD][TD]'09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Jackson Warley[/TD][TD="align:right"]6[/TD][TD]'09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Kevin Hays[/TD][TD="align:right"]6[/TD][TD]'09, '10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Michael Grimsley[/TD][TD="align:right"]5[/TD][TD]'04, '05, '06, '07, '13[/TD][/TR]
[TR][TD]Frank Morris[/TD][TD="align:right"]5[/TD][TD]'04, '05, '06, '08, '09[/TD][/TR]
[TR][TD]Ryan Patricio[/TD][TD="align:right"]5[/TD][TD]'05, '06, '07, '08, '09[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD="align:right"]5[/TD][TD]'05, '07, '08, '09, '13[/TD][/TR]
[TR][TD]Tristan Wright[/TD][TD="align:right"]5[/TD][TD]'06, '08, '10, '11, '12[/TD][/TR]
[TR][TD]Alexander Lin[/TD][TD="align:right"]5[/TD][TD]'07, '08, '09, '10, '13[/TD][/TR]
[TR][TD]John George[/TD][TD="align:right"]5[/TD][TD]'07, '08, '10, '11, '14[/TD][/TR]
[TR][TD]Patrick Kelly[/TD][TD="align:right"]5[/TD][TD]'07, '09, '10, '12, '13[/TD][/TR]
[TR][TD]Justin Jaffray[/TD][TD="align:right"]5[/TD][TD]'09, '10, '11, '12, '13[/TD][/TR]
[TR][TD]David Woner[/TD][TD="align:right"]5[/TD][TD]'09, '10, '11, '12, '13[/TD][/TR]
[TR][TD]Myles Casanas[/TD][TD="align:right"]5[/TD][TD]'09, '10, '11, '12, '13[/TD][/TR]
[TR][TD]Vincent Sheu[/TD][TD="align:right"]5[/TD][TD]'09, '10, '12, '13, '14[/TD][/TR]
[TR][TD]Justin Adsuara[/TD][TD="align:right"]5[/TD][TD]'09, '10, '12, '13, '14[/TD][/TR]
[TR][TD]Michael Young[/TD][TD="align:right"]5[/TD][TD]'09, '10, '12, '13, '14[/TD][/TR]
[TR][TD]Kevin Zhou[/TD][TD="align:right"]5[/TD][TD]'09, '10, '12, '13, '14[/TD][/TR]
[TR][TD]Evan Liu[/TD][TD="align:right"]5[/TD][TD]'09, '10, '12, '13, '14[/TD][/TR]
[TR][TD]Kian Barry[/TD][TD="align:right"]5[/TD][TD]'10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Sarah Strong[/TD][TD="align:right"]5[/TD][TD]'10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Matthew Bahner[/TD][TD="align:right"]5[/TD][TD]'10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]AJ Blair[/TD][TD="align:right"]5[/TD][TD]'10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Chester Lian[/TD][TD="align:right"]5[/TD][TD]'10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Patricia Li[/TD][TD="align:right"]5[/TD][TD]'10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Alex Thielemier[/TD][TD="align:right"]5[/TD][TD]'10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Austin Thielemier[/TD][TD="align:right"]5[/TD][TD]'10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Jonathan Cookmeyer[/TD][TD="align:right"]5[/TD][TD]'10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]James Donahue[/TD][TD="align:right"]5[/TD][TD]'10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Justin Mallari[/TD][TD="align:right"]5[/TD][TD]'10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Daniel Wu[/TD][TD="align:right"]5[/TD][TD]'10, '11, '12, '13, '14[/TD][/TR]
[TR][TD]Phil Yu[/TD][TD="align:right"]5[/TD][TD]'10, '11, '12, '13, '14[/TD][/TR]
[/TABLE]

Code: 
[NOPARSE]SELECT
  personId Cuber,
  count(distinct competitionId) Number,
  group_concat(distinct concat("'",substring(year,-2)) order by year separator ', ') Years
FROM Results join Competitions on Competitions.id=competitionId
WHERE countryId='USA' and competitionId rlike '^US|^WC'
GROUP BY personId
HAVING Number >= 5
ORDER BY Number desc, Years, Cuber;[/NOPARSE]
 
Last edited:
cmhardw said:
Can you do the same statistic for World Championships only (including 1982)?
Click to expand...

Using data from WCA_export475_20140924 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]Cuber[/TD][TD]Number[/TD][TD]Years[/TD][/TR]
[TR][TD]Lars Petrus[/TD][TD="align:right"]6[/TD][TD]1982, 2003, 2005, 2007, 2011, 2013[/TD][/TR]
[TR][TD]Ron van Bruchem[/TD][TD="align:right"]6[/TD][TD]2003, 2005, 2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Chris Hardwick[/TD][TD="align:right"]6[/TD][TD]2003, 2005, 2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Jasmine Lee[/TD][TD="align:right"]6[/TD][TD]2003, 2005, 2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Lars Vandenbergh[/TD][TD="align:right"]6[/TD][TD]2003, 2005, 2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Bob Burton[/TD][TD="align:right"]5[/TD][TD]2003, 2005, 2007, 2009, 2013[/TD][/TR]
[TR][TD]Anders Larsson[/TD][TD="align:right"]5[/TD][TD]2003, 2005, 2007, 2011, 2013[/TD][/TR]
[TR][TD]Shelley Chang[/TD][TD="align:right"]5[/TD][TD]2005, 2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Adam Zamora[/TD][TD="align:right"]5[/TD][TD]2005, 2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Peter Still[/TD][TD="align:right"]5[/TD][TD]2005, 2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Frédérick Badie[/TD][TD="align:right"]4[/TD][TD]2003, 2005, 2007, 2009[/TD][/TR]
[TR][TD]Ton Dennenbroek[/TD][TD="align:right"]4[/TD][TD]2003, 2005, 2007, 2009[/TD][/TR]
[TR][TD]Frank Morris[/TD][TD="align:right"]4[/TD][TD]2003, 2005, 2007, 2009[/TD][/TR]
[TR][TD]Jaap Scherphuis[/TD][TD="align:right"]4[/TD][TD]2003, 2005, 2007, 2009[/TD][/TR]
[TR][TD]Dror Vomberg[/TD][TD="align:right"]4[/TD][TD]2003, 2005, 2007, 2009[/TD][/TR]
[TR][TD]Shotaro Makisumi (牧角章太郎)[/TD][TD="align:right"]4[/TD][TD]2003, 2005, 2007, 2013[/TD][/TR]
[TR][TD]Edouard Chambon[/TD][TD="align:right"]4[/TD][TD]2005, 2007, 2009, 2011[/TD][/TR]
[TR][TD]Joël van Noort[/TD][TD="align:right"]4[/TD][TD]2005, 2007, 2009, 2011[/TD][/TR]
[TR][TD]Stefan Pochmann[/TD][TD="align:right"]4[/TD][TD]2005, 2007, 2009, 2013[/TD][/TR]
[TR][TD]Tyson Mao (毛台勝)[/TD][TD="align:right"]4[/TD][TD]2005, 2007, 2009, 2013[/TD][/TR]
[TR][TD]Dave Campbell[/TD][TD="align:right"]4[/TD][TD]2005, 2009, 2011, 2013[/TD][/TR]
[TR][TD]István Kocza[/TD][TD="align:right"]4[/TD][TD]2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Tim Reynolds[/TD][TD="align:right"]4[/TD][TD]2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Sinpei Araki (荒木慎平)[/TD][TD="align:right"]4[/TD][TD]2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Henrik Buus Aagaard[/TD][TD="align:right"]4[/TD][TD]2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Kirstine Buus Aagaard[/TD][TD="align:right"]4[/TD][TD]2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Dan Dzoan[/TD][TD="align:right"]4[/TD][TD]2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Jean-Louis Mathieu[/TD][TD="align:right"]4[/TD][TD]2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Takao Hashimoto (橋本貴夫)[/TD][TD="align:right"]4[/TD][TD]2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Rowe Hessler[/TD][TD="align:right"]4[/TD][TD]2007, 2009, 2011, 2013[/TD][/TR]
[TR][TD]Guus Razoux Schultz[/TD][TD="align:right"]3[/TD][TD]1982, 2007, 2009[/TD][/TR]
[TR][TD]Dan Harris[/TD][TD="align:right"]3[/TD][TD]2003, 2005, 2007[/TD][/TR]
[TR][TD]Brent Morgan[/TD][TD="align:right"]3[/TD][TD]2003, 2005, 2007[/TD][/TR]
[TR][TD]Masayuki Akimoto (秋元正行)[/TD][TD="align:right"]3[/TD][TD]2003, 2005, 2009[/TD][/TR]
[TR][TD]Ian Winokur[/TD][TD="align:right"]3[/TD][TD]2003, 2005, 2013[/TD][/TR]
[TR][TD]Ernesto Fernández Regueira[/TD][TD="align:right"]3[/TD][TD]2005, 2007, 2009[/TD][/TR]
[TR][TD]Ryan Patricio[/TD][TD="align:right"]3[/TD][TD]2005, 2007, 2009[/TD][/TR]
[TR][TD]Jean Pons[/TD][TD="align:right"]3[/TD][TD]2005, 2007, 2009[/TD][/TR]
[TR][TD]Oliver Wolff[/TD][TD="align:right"]3[/TD][TD]2005, 2007, 2009[/TD][/TR]
[TR][TD]Erik Akkersdijk[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2011[/TD][/TR]
[TR][TD]Milán Baticz[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2011[/TD][/TR]
[TR][TD]Fumiki Koseki (古関章記)[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2011[/TD][/TR]
[TR][TD]Yu Araki (荒木由布)[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2011[/TD][/TR]
[TR][TD]Arnaud van Galen[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2011[/TD][/TR]
[TR][TD]Thibaut Jacquinot[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2011[/TD][/TR]
[TR][TD]Ryosuke Mondo (門戸良介)[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2011[/TD][/TR]
[TR][TD]Takayuki Ookusa (大艸尊之)[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2011[/TD][/TR]
[TR][TD]Yumu Tabuchi (田渕雄夢)[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2011[/TD][/TR]
[TR][TD]Máté Horváth[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2011[/TD][/TR]
[TR][TD]Gunnar Krig[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2013[/TD][/TR]
[TR][TD]Kåre Krig[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2013[/TD][/TR]
[TR][TD]Toby Mao (毛台立)[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2013[/TD][/TR]
[TR][TD]Harris Chan[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2013[/TD][/TR]
[TR][TD]Joey Gouly[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2013[/TD][/TR]
[TR][TD]Kai Jiptner[/TD][TD="align:right"]3[/TD][TD]2007, 2009, 2013[/TD][/TR]
[TR][TD]Marcell Endrey[/TD][TD="align:right"]3[/TD][TD]2007, 2011, 2013[/TD][/TR]
[TR][TD]Jesús Masanet García[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Jeremy Fleischman[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Dan Cohen[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Mats Valk[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Breandan Vallance[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Oscar Roth Andersen[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Sébastien Auroux[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Bence Barát[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]François Courtès[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Pierre Lemerle[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Sylviane Mathieu[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Hanneke Rijks[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Simon Westlund[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Cornelius Dieckmann[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Radu Făciu[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Anti Ingel[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[TR][TD]Javier Tirado Ortiz[/TD][TD="align:right"]3[/TD][TD]2009, 2011, 2013[/TD][/TR]
[/TABLE]

Code: 
[NOPARSE]SELECT
  personId Cuber,
  count(distinct competitionId) Number,
  group_concat(distinct substring(competitionId,3) order by competitionId separator ', ') Years
FROM Results
WHERE competitionId rlike '^WC(19|20)[0-9][0-9]$'
GROUP BY personId
HAVING Number >= 3
ORDER BY Number desc, Years, Cuber;[/NOPARSE]
 
You must log in or register to reply here.

Similar threads

Minetoucubing
Odd or fake QJ megaminx?
Replies
0
Views
188
Minetoucubing
Minetoucubing
MrCubert
SS Oddballs Redemption 2026
Replies
2
Views
432
MrCubert
MrCubert
J
Special Characters in my name appear odd in the weekly competitions
Replies
0
Views
484
J:org
J
D
reduction parity on odd cubes vs even cubes
Replies
5
Views
3,042
Christopher Mowla
Christopher Mowla
Discomantis
Need help solving odd swaps on big cubes
Replies
15
Views
2,501
Discomantis
Discomantis
Back
Top