Odd WCA stats/ Stats request Thread

Tim Reynolds said:
Yeah I've definitely posted this before, but I can't find it either. I'm including non-US citizens here because there's not many at the top of the rankings.

Code: 
SELECT personId, personName, COUNT( DISTINCT state ) 
FROM Results
JOIN (

SELECT id, SUBSTRING( cityName, INSTR( cityName,  "," ) +2 ) AS state
FROM Competitions
WHERE countryId =  "USA"
)States ON Results.competitionId = States.id
GROUP BY 1 
ORDER BY 3 DESC 
LIMIT 0 , 30
2003BURT01 Bob Burton 19
2007HASH01 Takao Hashimoto (橋本貴夫) 15
2005REYN01 Tim Reynolds 15
2004MAOT02 Tyson Mao (毛台勝) 14
2004ZAMO01 Adam Zamora 14
2007COHE01 Dan Cohen 14
2005CAMP01 Dave Campbell 13
2007HESS01 Rowe Hessler 13
2006NORS01 Bruce Norskog 13
2006MERT01 Jim Mertens 12
2008WONE01 David Woner 12
2004CHAN04 Shelley Chang 12
2009LIAN03 Chester Lian 11
2007BARR01 Kian Barry 11
2008SEAR01 Anthony Brooks 11
2009LIUE01 Evan Liu 11
2010CRIS01 Ethan Crislip 11
2011SAKO01 Corey Sakowski 11
2007SUNT01 Timothy Sun 11
2007ALIW01 Waris Ali 11
2006SAWL01 Jaclyn Sawler 11
Click to expand...

Could someone update the "Most U.S. States Competed In" statistic please?

The results may not be completely accurate because the WCA recognizes everyone who competed in FMC USA 2014 to have competed in Massachusetts according to their the maps.
 
Last edited:
Of all the people starting their WCA career in 1982, Guus now has the best 3x3 average record. And so on.

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

[TABLE="class:grid,align:left"]
[TR][TD]Year[/TD][TD]Average[/TD][TD]Cuber[/TD][/TR]
[TR][TD="align:right"]1982[/TD][TD="align:right"]17.86[/TD][TD]Guus Razoux Schultz[/TD][/TR]
[TR][TD="align:right"]2003[/TD][TD="align:right"]11.84[/TD][TD]Shotaro Makisumi (牧角章太郎)[/TD][/TR]
[TR][TD="align:right"]2004[/TD][TD="align:right"]10.53[/TD][TD]Edouard Chambon[/TD][/TR]
[TR][TD="align:right"]2005[/TD][TD="align:right"]8.79[/TD][TD]Erik Akkersdijk[/TD][/TR]
[TR][TD="align:right"]2006[/TD][TD="align:right"]8.25[/TD][TD]Yumu Tabuchi (田渕雄夢)[/TD][/TR]
[TR][TD="align:right"]2007[/TD][TD="align:right"]7.45[/TD][TD]Mats Valk[/TD][/TR]
[TR][TD="align:right"]2008[/TD][TD="align:right"]8.63[/TD][TD]Anthony Brooks[/TD][/TR]
[TR][TD="align:right"]2009[/TD][TD="align:right"]6.54[/TD][TD]Feliks Zemdegs[/TD][/TR]
[TR][TD="align:right"]2010[/TD][TD="align:right"]7.50[/TD][TD]Bill Wang[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]7.50[/TD][TD]Alexander Lau[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]7.69[/TD][TD]Kevin Costello III[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]8.92[/TD][TD]Hyeon Kyo Kyoung[/TD][/TR]
[TR][TD="align:right"]2014[/TD][TD="align:right"]10.94[/TD][TD]Dawei Xu (徐大卫)[/TD][/TR]
[/TABLE]

Code: 
[NOPARSE]SELECT substr(personId, 1, 4) Year, average 'Average[T]', group_concat(personId) Cuber
FROM Results
WHERE eventId='333' and (substr(personId, 1, 4), average) in
(SELECT substr(personId, 1, 4) year, min(average) bestAvg
FROM Results
WHERE eventId='333' and average>0
GROUP BY year)
GROUP BY Year
ORDER BY Year;[/NOPARSE]
 
Last edited:
Stefan said:
Of all the people starting their WCA career in 1982, Guus now has the best 3x3 average. And so on.

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

[TABLE="class:grid,align:left"]
[TR][TD]Year[/TD][TD]Average[/TD][TD]Cuber[/TD][/TR]
[TR][TD="align:right"]1982[/TD][TD="align:right"]17.86[/TD][TD]Guus Razoux Schultz[/TD][/TR]
[TR][TD="align:right"]2003[/TD][TD="align:right"]11.84[/TD][TD]Shotaro Makisumi (牧角章太郎)[/TD][/TR]
[TR][TD="align:right"]2004[/TD][TD="align:right"]10.53[/TD][TD]Edouard Chambon[/TD][/TR]
[TR][TD="align:right"]2005[/TD][TD="align:right"]8.79[/TD][TD]Erik Akkersdijk[/TD][/TR]
[TR][TD="align:right"]2006[/TD][TD="align:right"]8.25[/TD][TD]Yumu Tabuchi (田渕雄夢)[/TD][/TR]
[TR][TD="align:right"]2007[/TD][TD="align:right"]7.45[/TD][TD]Mats Valk[/TD][/TR]
[TR][TD="align:right"]2008[/TD][TD="align:right"]8.63[/TD][TD]Anthony Brooks[/TD][/TR]
[TR][TD="align:right"]2009[/TD][TD="align:right"]6.54[/TD][TD]Feliks Zemdegs[/TD][/TR]
[TR][TD="align:right"]2010[/TD][TD="align:right"]7.50[/TD][TD]Bill Wang[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]7.50[/TD][TD]Alexander Lau[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]7.69[/TD][TD]Kevin Costello III[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]8.92[/TD][TD]Hyeon Kyo Kyoung[/TD][/TR]
[TR][TD="align:right"]2014[/TD][TD="align:right"]10.94[/TD][TD]Dawei Xu (徐大卫)[/TD][/TR]
[/TABLE]

Code: 
[NOPARSE]SELECT substr(personId, 1, 4) Year, average 'Average[T]', group_concat(personId) Cuber
FROM Results
WHERE eventId='333' and (substr(personId, 1, 4), average) in
(SELECT substr(personId, 1, 4) year, min(average) bestAvg
FROM Results
WHERE eventId='333' and average>0
GROUP BY year)
GROUP BY Year
ORDER BY Year;[/NOPARSE]
Click to expand...

Is 2014 really that slow? Damn.
 
TDM said:
People from previous years have improved and then competed since then, so their times are going to be faster. In a few years the best person with 2014 in their WCA profile will be much faster than that.
Click to expand...

I'm just imagining there's someone going to a comp in 2015 who's been practicing for years and is sub-9.
 
How many of each year's freshies are among today's top X in 3x3 average:

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

[TABLE="class:grid,align:left"]
[TR][TD]Year[/TD][TD]top 10[/TD][TD]top 100[/TD][TD]top 1000[/TD][TD]top 10000[/TD][TD]all[/TD][/TR]
[TR][TD="align:right"]1982[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]3[/TD][TD="align:right"]4[/TD][/TR]
[TR][TD="align:right"]2003[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]1[/TD][TD="align:right"]31[/TD][TD="align:right"]50[/TD][/TR]
[TR][TD="align:right"]2004[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]5[/TD][TD="align:right"]43[/TD][TD="align:right"]121[/TD][/TR]
[TR][TD="align:right"]2005[/TD][TD="align:right"]0[/TD][TD="align:right"]3[/TD][TD="align:right"]10[/TD][TD="align:right"]101[/TD][TD="align:right"]272[/TD][/TR]
[TR][TD="align:right"]2006[/TD][TD="align:right"]0[/TD][TD="align:right"]3[/TD][TD="align:right"]29[/TD][TD="align:right"]157[/TD][TD="align:right"]447[/TD][/TR]
[TR][TD="align:right"]2007[/TD][TD="align:right"]1[/TD][TD="align:right"]10[/TD][TD="align:right"]50[/TD][TD="align:right"]303[/TD][TD="align:right"]870[/TD][/TR]
[TR][TD="align:right"]2008[/TD][TD="align:right"]0[/TD][TD="align:right"]10[/TD][TD="align:right"]95[/TD][TD="align:right"]647[/TD][TD="align:right"]1764[/TD][/TR]
[TR][TD="align:right"]2009[/TD][TD="align:right"]2[/TD][TD="align:right"]22[/TD][TD="align:right"]143[/TD][TD="align:right"]1057[/TD][TD="align:right"]3197[/TD][/TR]
[TR][TD="align:right"]2010[/TD][TD="align:right"]4[/TD][TD="align:right"]28[/TD][TD="align:right"]158[/TD][TD="align:right"]1377[/TD][TD="align:right"]3704[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]2[/TD][TD="align:right"]14[/TD][TD="align:right"]196[/TD][TD="align:right"]1423[/TD][TD="align:right"]3965[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]1[/TD][TD="align:right"]7[/TD][TD="align:right"]166[/TD][TD="align:right"]1401[/TD][TD="align:right"]3984[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]0[/TD][TD="align:right"]4[/TD][TD="align:right"]123[/TD][TD="align:right"]1841[/TD][TD="align:right"]5739[/TD][/TR]
[TR][TD="align:right"]2014[/TD][TD="align:right"]0[/TD][TD="align:right"]0[/TD][TD="align:right"]25[/TD][TD="align:right"]1626[/TD][TD="align:right"]7661[/TD][/TR]
[/TABLE]

Code: 
[NOPARSE]SELECT
  substr(personId, 1, 4) Year,
  sum(worldRank <= 10) 'top 10',
  sum(worldRank <= 100) 'top 100',
  sum(worldRank <= 1000) 'top 1000',
  sum(worldRank <= 10000) 'top 10000',
  count(*) 'all'
FROM RanksAverage
WHERE eventId = '333'
GROUP BY Year
ORDER BY Year;[/NOPARSE]
 
MatejMuzatko said:
What about competition with the lowest (BLD winning result)/(3x3x3 winning result) ratio? I've just seen that 3x3x3 winning average of the PLS szczecin (where maskow did WR) is barily sub12...
Click to expand...

Yeah, that one wins by a great marcin.

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

[TABLE="class:grid,align:left"]
[TR][TD]id[/TD][TD]win333bf / win333[/TD][TD]win333bf[/TD][TD]win333[/TD][TD]countryId[/TD][/TR]
[TR][TD]PLS Szczecin 2014[/TD][TD="align:right"]1.7865[/TD][TD="align:right"]21.17[/TD][TD="align:right"]11.85[/TD][TD]Poland[/TD][/TR]
[TR][TD]SLS Chorzow 2014[/TD][TD="align:right"]2.3080[/TD][TD="align:right"]23.68[/TD][TD="align:right"]10.26[/TD][TD]Poland[/TD][/TR]
[TR][TD]Bydgoszcz Summer 2014[/TD][TD="align:right"]2.3353[/TD][TD="align:right"]23.19[/TD][TD="align:right"]9.93[/TD][TD]Poland[/TD][/TR]
[TR][TD]Jember Open 2013[/TD][TD="align:right"]2.3582[/TD][TD="align:right"]37.33[/TD][TD="align:right"]15.83[/TD][TD]Indonesia[/TD][/TR]
[TR][TD]SLS Czestochowa 2013[/TD][TD="align:right"]2.4343[/TD][TD="align:right"]26.12[/TD][TD="align:right"]10.73[/TD][TD]Poland[/TD][/TR]
[TR][TD]Polish Nationals 2013[/TD][TD="align:right"]2.4511[/TD][TD="align:right"]23.80[/TD][TD="align:right"]9.71[/TD][TD]Poland[/TD][/TR]
[TR][TD]Cubers Eve 2013[/TD][TD="align:right"]2.4649[/TD][TD="align:right"]23.91[/TD][TD="align:right"]9.70[/TD][TD]Poland[/TD][/TR]
[TR][TD]GLS Autumn Reda 2013[/TD][TD="align:right"]2.5344[/TD][TD="align:right"]24.71[/TD][TD="align:right"]9.75[/TD][TD]Poland[/TD][/TR]
[TR][TD]Guangzhou Wushan Open 2014[/TD][TD="align:right"]2.5370[/TD][TD="align:right"]24.33[/TD][TD="align:right"]9.59[/TD][TD]China[/TD][/TR]
[TR][TD]Nanjing Spring Open 2010[/TD][TD="align:right"]2.5482[/TD][TD="align:right"]33.56[/TD][TD="align:right"]13.17[/TD][TD]China[/TD][/TR]
[TR][TD]Suzhou Open 2011[/TD][TD="align:right"]2.5547[/TD][TD="align:right"]30.58[/TD][TD="align:right"]11.97[/TD][TD]China[/TD][/TR]
[TR][TD]Krakow Cubing Spree 2014[/TD][TD="align:right"]2.5932[/TD][TD="align:right"]27.41[/TD][TD="align:right"]10.57[/TD][TD]Poland[/TD][/TR]
[TR][TD]Slovenian Open 2013[/TD][TD="align:right"]2.6278[/TD][TD="align:right"]27.75[/TD][TD="align:right"]10.56[/TD][TD]Slovenia[/TD][/TR]
[TR][TD]Ural Winter 2014[/TD][TD="align:right"]2.6524[/TD][TD="align:right"]33.58[/TD][TD="align:right"]12.66[/TD][TD]Russia[/TD][/TR]
[TR][TD]Xi'an Spring 2010[/TD][TD="align:right"]2.6627[/TD][TD="align:right"]30.94[/TD][TD="align:right"]11.62[/TD][TD]China[/TD][/TR]
[TR][TD]Zune Open 2012[/TD][TD="align:right"]2.6663[/TD][TD="align:right"]27.65[/TD][TD="align:right"]10.37[/TD][TD]Belgium[/TD][/TR]
[TR][TD]RCPO 2014[/TD][TD="align:right"]2.6676[/TD][TD="align:right"]27.77[/TD][TD="align:right"]10.41[/TD][TD]Philippines[/TD][/TR]
[TR][TD]Shanghai Winter 2010[/TD][TD="align:right"]2.7004[/TD][TD="align:right"]32.27[/TD][TD="align:right"]11.95[/TD][TD]China[/TD][/TR]
[TR][TD]Beijing Summer 2013[/TD][TD="align:right"]2.7040[/TD][TD="align:right"]29.96[/TD][TD="align:right"]11.08[/TD][TD]China[/TD][/TR]
[TR][TD]Liberty Science 2013[/TD][TD="align:right"]2.7089[/TD][TD="align:right"]27.36[/TD][TD="align:right"]10.10[/TD][TD]USA[/TD][/TR]
[TR][TD]STGO Verano 2014[/TD][TD="align:right"]2.7113[/TD][TD="align:right"]32.40[/TD][TD="align:right"]11.95[/TD][TD]Chile[/TD][/TR]
[TR][TD]Asian Championship 2014[/TD][TD="align:right"]2.7223[/TD][TD="align:right"]25.78[/TD][TD="align:right"]9.47[/TD][TD]Japan[/TD][/TR]
[TR][TD]SLS Bielsko-Biala 2014[/TD][TD="align:right"]2.7366[/TD][TD="align:right"]28.16[/TD][TD="align:right"]10.29[/TD][TD]Poland[/TD][/TR]
[TR][TD]Xi'an Lucky Open 2011[/TD][TD="align:right"]2.7504[/TD][TD="align:right"]33.72[/TD][TD="align:right"]12.26[/TD][TD]China[/TD][/TR]
[TR][TD]Austrian Open 2013[/TD][TD="align:right"]2.7666[/TD][TD="align:right"]29.99[/TD][TD="align:right"]10.84[/TD][TD]Austria[/TD][/TR]
[TR][TD]ATMOS 2014[/TD][TD="align:right"]2.7868[/TD][TD="align:right"]37.65[/TD][TD="align:right"]13.51[/TD][TD]India[/TD][/TR]
[TR][TD]Monticello Open 2014[/TD][TD="align:right"]2.7978[/TD][TD="align:right"]34.86[/TD][TD="align:right"]12.46[/TD][TD]Italy[/TD][/TR]
[TR][TD]Polish Open 2014[/TD][TD="align:right"]2.7993[/TD][TD="align:right"]25.39[/TD][TD="align:right"]9.07[/TD][TD]Poland[/TD][/TR]
[TR][TD]Polish Nationals 2014[/TD][TD="align:right"]2.8004[/TD][TD="align:right"]27.36[/TD][TD="align:right"]9.77[/TD][TD]Poland[/TD][/TR]
[TR][TD]Zonhoven Open 2012[/TD][TD="align:right"]2.8016[/TD][TD="align:right"]28.80[/TD][TD="align:right"]10.28[/TD][TD]Belgium[/TD][/TR]
[TR][TD]Bugella Open 2014[/TD][TD="align:right"]2.8097[/TD][TD="align:right"]36.61[/TD][TD="align:right"]13.03[/TD][TD]Italy[/TD][/TR]
[TR][TD]Guangdong Open 2014[/TD][TD="align:right"]2.8166[/TD][TD="align:right"]26.11[/TD][TD="align:right"]9.27[/TD][TD]China[/TD][/TR]
[TR][TD]SLS Rybnik 2014[/TD][TD="align:right"]2.8229[/TD][TD="align:right"]26.62[/TD][TD="align:right"]9.43[/TD][TD]Poland[/TD][/TR]
[TR][TD]Czech Open 2013[/TD][TD="align:right"]2.8234[/TD][TD="align:right"]29.90[/TD][TD="align:right"]10.59[/TD][TD]Czech Republic[/TD][/TR]
[TR][TD]Radom Open 2013[/TD][TD="align:right"]2.8261[/TD][TD="align:right"]28.60[/TD][TD="align:right"]10.12[/TD][TD]Poland[/TD][/TR]
[TR][TD]Guadalajara Open 2010[/TD][TD="align:right"]2.8351[/TD][TD="align:right"]41.96[/TD][TD="align:right"]14.80[/TD][TD]Mexico[/TD][/TR]
[TR][TD]Grudziadz Open 2013[/TD][TD="align:right"]2.8415[/TD][TD="align:right"]29.41[/TD][TD="align:right"]10.35[/TD][TD]Poland[/TD][/TR]
[TR][TD]Beijing 2013[/TD][TD="align:right"]2.8551[/TD][TD="align:right"]34.69[/TD][TD="align:right"]12.15[/TD][TD]China[/TD][/TR]
[TR][TD]Harbin Open 2009[/TD][TD="align:right"]2.8646[/TD][TD="align:right"]42.11[/TD][TD="align:right"]14.70[/TD][TD]China[/TD][/TR]
[TR][TD]Beijing Autumn 2014[/TD][TD="align:right"]2.8748[/TD][TD="align:right"]36.74[/TD][TD="align:right"]12.78[/TD][TD]China[/TD][/TR]
[TR][TD]Las Lomas 2014[/TD][TD="align:right"]2.8921[/TD][TD="align:right"]35.66[/TD][TD="align:right"]12.33[/TD][TD]Chile[/TD][/TR]
[TR][TD]Hunan Open 2010[/TD][TD="align:right"]2.8940[/TD][TD="align:right"]36.03[/TD][TD="align:right"]12.45[/TD][TD]China[/TD][/TR]
[TR][TD]SLS Jastrzebie 2013[/TD][TD="align:right"]2.9202[/TD][TD="align:right"]28.18[/TD][TD="align:right"]9.65[/TD][TD]Poland[/TD][/TR]
[TR][TD]Big Cube Krasnik 2014[/TD][TD="align:right"]2.9343[/TD][TD="align:right"]27.26[/TD][TD="align:right"]9.29[/TD][TD]Poland[/TD][/TR]
[TR][TD]BASC 3 2014[/TD][TD="align:right"]2.9770[/TD][TD="align:right"]29.77[/TD][TD="align:right"]10.00[/TD][TD]USA[/TD][/TR]
[TR][TD]Basauri Open 2011[/TD][TD="align:right"]2.9809[/TD][TD="align:right"]37.41[/TD][TD="align:right"]12.55[/TD][TD]Spain[/TD][/TR]
[TR][TD]Hangzhou Open 2010[/TD][TD="align:right"]2.9863[/TD][TD="align:right"]37.18[/TD][TD="align:right"]12.45[/TD][TD]China[/TD][/TR]
[TR][TD]Ha Noi Open 2014[/TD][TD="align:right"]2.9876[/TD][TD="align:right"]33.76[/TD][TD="align:right"]11.30[/TD][TD]Vietnam[/TD][/TR]
[/TABLE]

Code: 
[NOPARSE]SELECT id, win333bf / win333, win333bf 'win333bf[T]', win333 'win333[T]', countryId
FROM
(SELECT competitionId id, average win333 FROM Results WHERE eventId='333' and roundId in ('f','c') and pos=1 and average>0) a
natural join
(SELECT competitionId id, best win333bf FROM Results WHERE eventId='333bf' and roundId in ('f','c') and pos=1 and best>0) b
natural join Competitions
WHERE win333bf / win333 < 3
ORDER BY 2;[/NOPARSE]
 
Username said:
Manual search so probably not correct:

1. Ben Whitmore: 3+12=15
1. Antonie Paterakis: 11+4=15
3. Michał Pleskowicz: 11+5 =16
4. Cornelius Dieckmann: 5+14=19
4. Carlos Méndez García-Barroso: 18+1=19

Yes, I was kinda bored.
Click to expand...

I don't think so: https://www.speedsolving.com/forum/showthread.php?1688-Accomplishment-Thread&p=955702#post955702

EDIT: If you go by sum of world rankings, Ben wins anyway: 3+31=34, Antonie: 22+15 = 37. Oh well too bad. Maybe Antonie can think of another statistic that he might be ranked #1 in next time. :rolleyes:
 
Last edited:
Robert-Y said:
I don't think so: https://www.speedsolving.com/forum/showthread.php?1688-Accomplishment-Thread&p=955702#post955702

EDIT: If you go by sum of world rankings, Ben wins anyway: 3+31=34, Antonie: 22+15 = 37. Oh well too bad. Maybe Antonie can think of another statistic that he might be ranked #1 in next time. :rolleyes:
Click to expand...

Oh thanks for correcting me. Atleast my error wasn't something I should've found on the wca :p

On a completely unrelated note can we get a 2x2avg, 3x3avg and 4x4avg sum of ranks for finland? /s
 
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
434
MrCubert
MrCubert
J
Special Characters in my name appear odd in the weekly competitions
Replies
0
Views
485
J:org
J
D
reduction parity on odd cubes vs even cubes
Replies
5
Views
3,047
Christopher Mowla
Christopher Mowla
Discomantis
Need help solving odd swaps on big cubes
Replies
15
Views
2,504
Discomantis
Discomantis
Back
Top