• 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

Lid said:
So you want me to paste all 8k+ avgs?
Click to expand...

No, I'm just saying your "no cut off" is false.

(Ideally, we could say something like "limit 100" and we'd not just get 100 rows but also a few more in case there are ties at the end (like 77 rows sharing place 98. It's on the todo-list for my tool, but I didn't get to it yet, hence my ugly hack that caused my bug.)
 
Last edited:
How many people finished all events? And how many of them did not finish with 5BLD? Kind of a ratio would be interesting, and what was the event they finished with?
E.g. I have everything except feet, so when I do an official feet mean I have finished all events with the last event feet :)

And second question: whats the lowest 3bld mean: 4bld single ratio? Mine is like 1.2 and really terrible. Also whats the highest ratio?
 
Last edited:
mycube said:
How many people finished all events? And how many of them did not finish with 5BLD? Kind of a ratio would be interesting, and what was the event they finished with?
E.g. I have everything except feet, so when I do an official feet mean I have finished all events with the last event feet :)

And second question: whats the lowest 3bld mean: 4bld single ratio? Mine is like 1.2 and really terrible. Also whats the highest ratio?
Click to expand...

I have FMC mean left :p
 
mycube said:
How many people finished all events? And how many of them did not finish with 5BLD? Kind of a ratio would be interesting, and what was the event they finished with?
E.g. I have everything except feet, so when I do an official feet mean I have finished all events with the last event feet :)

And second question: whats the lowest 3bld mean: 4bld single ratio? Mine is like 1.2 and really terrible. Also whats the highest ratio?
Click to expand...

Here is a list: http://www.speedsolving.com/forum/s...e-WCA-events&p=1006541&viewfull=1#post1006541
 
Is there any reason for the AVG competitions to be missing from the short name list? Maybe because their names start with a number?
Stefan said:
What do you mean it would leave Maryland and Washington out?



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]
Click to expand...
 
AvGalen said:
Is there any reason for the AVG competitions to be missing from the short name list? Maybe because their names start with a number?
Click to expand...

Inside tables, like on that page, we use shortened competition names (so they don't blow up the table widths). The actual names of the AVG competitions are "1 AVG competition 2013" and "2 AVG competition 2014", as shown at the top of each competition's page. And those are not that short.
 
If you look at my WCA profile you can see all my averages are ranked better then my singles. I competed in 4 events. Is there anyone who competed in all 18 events and did this? If not who competed the most events and had all there averages ranked better then their singles?
 
FailCuber said:
If you look at my WCA profile you can see all my averages are ranked better then my singles. I competed in 4 events. Is there anyone who competed in all 18 events and did this? If not who competed the most events and had all there averages ranked better then their singles?
Click to expand...

I competed in 13 events, and my avg ranks are almost better than my single ranks.
Only 5x5 and one-handed singles ranks beat avg ranks by small margin.

Does that mean I don't have pure luck in any of these events?!
 
Last edited:
Yay, 6666 posts.

FailCuber said:
If you look at my WCA profile you can see all my averages are ranked better then my singles. I competed in 4 events. Is there anyone who competed in all 18 events and did this? If not who competed the most events and had all there averages ranked better then their singles?
Click to expand...

That's a bit ambiguous/awkward/wrong because of obsolete events and because of people who somewhat tried but never got a successful single/average in some event(s), but here's my attempt:

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

[TABLE="class:grid,align:left"]
[TR][TD]Cuber[/TD][TD]Events[/TD][/TR]
[TR][TD]Mao-te Hsieh (謝茂德)[/TD][TD="align:right"]17[/TD][/TR]
[TR][TD]Yiqun Fan (樊轶群)[/TD][TD="align:right"]16[/TD][/TR]
[TR][TD]Zachary Lowry[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Ragil Setyadi[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Irwan Sarbeni[/TD][TD="align:right"]14[/TD][/TR]
[TR][TD]Shikhar Mohan[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Nick Edmonds[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Gabriel Torres Jacques[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Dominik Pasztetnik[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Mingtao Wu (吴铭涛)[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Aharon Campoli Tono[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Jingyu Jiang (江靖宇)[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Hanns Hub[/TD][TD="align:right"]13[/TD][/TR]
[TR][TD]Mark Skelton[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Christopher Fernández Trejo[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Patryk Bola[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Nguyễn Tài Đức[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Pedro Cuesta Unkhoff[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Ignacy Buczek[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Qifan Zhu (祝起凡)[/TD][TD="align:right"]12[/TD][/TR]
[TR][TD]Baptiste Lambin[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Paul Mahvi[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Ziqian Yin (尹子谦)[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Frank Provoost[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Kelsey McKenna[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]András Ferencz[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Federico Masilunas[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Aleksander Osiowski[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Eivind Fonn[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Nikolai Sitte[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Jakub Hanuszkiewicz[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Kim Se-Han[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Rizky Aditya Ramadhan[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Yucheng Lu (陆宇澄)[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Hamlet Fernando Guerrero Ramírez[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Paul Binner[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Jeff Goetz[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Ricky Meiler[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Shu Yi (易术)[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Ilya Zabrodsky[/TD][TD="align:right"]11[/TD][/TR]
[TR][TD]Quinnzon Radyatmadja Djauhari[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Joshua Li[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Kaj Wiklund[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Bartłomiej Sordyl[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Jakub Olejarz[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Alex Comeau[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Daniel García Murillo[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Arturo Medina Abad[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Max Hahnbück[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Jhojan Andres Lombana Garcia[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Xiaodong Sun (孙晓东)[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Dragan Okanović[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Aan Candra Nugroho[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Yusuke Morikawa (森川裕介)[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Daniel Matsukawa Kaczorowsky[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Michael Wittwer[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Maciej Prosowski[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Kentaro Nishi (西賢太郎)[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Rafa Serrano Hinojosa[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Jake Geren[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Philipp Żurowski[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Szymon Jeziorski[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Aditya Rajkumar[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Lê Việt Hưng[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Polux Eduardo Sánchez Moreno[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Sung Hyun Park (박성현)[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Moanish Barathiar[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]David Bergling[/TD][TD="align:right"]10[/TD][/TR]
[TR][TD]Phannuwat Maicharoenkun (ภาณุวัฒน์ มายเจริญกุล)[/TD][TD="align:right"]10[/TD][/TR]
[/TABLE]

Code: 
[NOPARSE]SELECT s.personId Cuber, Events
FROM RanksSingle s
  left join RanksAverage a on s.personId=a.personId and s.eventId=a.eventId
  join (SELECT personId, count(distinct eventId) Events FROM Results GROUP BY personId) tmp on tmp.personId=s.personId
GROUP BY s.personId
HAVING sum(if(a.worldRank, a.worldRank, 0) >= s.worldRank) = 0 and Events >= 10
ORDER BY Events desc;[/NOPARSE]
 
Last edited:
Working on some statistics on the number of competitors that have competed in a given region. Here's the heat map for countries:

http://www.openheatmap.com/view.html?map=AndoritePunctosColoraturas

[table="class: grid"]
[tr]
[td]country[/td]
[td]value[/td]
[/tr]
[tr]
[td]USA[/td]
[td]6329[/td]
[/tr]
[tr]
[td]China[/td]
[td]5025[/td]
[/tr]
[tr]
[td]India[/td]
[td]2773[/td]
[/tr]
[tr]
[td]Poland[/td]
[td]1646[/td]
[/tr]
[tr]
[td]Germany[/td]
[td]1424[/td]
[/tr]
[tr]
[td]Canada[/td]
[td]1271[/td]
[/tr]
[tr]
[td]Brazil[/td]
[td]1267[/td]
[/tr]
[tr]
[td]France[/td]
[td]1106[/td]
[/tr]
[tr]
[td]Indonesia[/td]
[td]1026[/td]
[/tr]
[tr]
[td]Japan[/td]
[td]889[/td]
[/tr]
[tr]
[td]Spain[/td]
[td]870[/td]
[/tr]
[tr]
[td]Taiwan[/td]
[td]718[/td]
[/tr]
[tr]
[td]Hungary[/td]
[td]680[/td]
[/tr]
[tr]
[td]Ukraine[/td]
[td]636[/td]
[/tr]
[tr]
[td]Thailand[/td]
[td]589[/td]
[/tr]
[tr]
[td]Philippines[/td]
[td]588[/td]
[/tr]
[tr]
[td]Korea[/td]
[td]571[/td]
[/tr]
[tr]
[td]Netherlands[/td]
[td]566[/td]
[/tr]
[tr]
[td]Mexico[/td]
[td]541[/td]
[/tr]
[tr]
[td]Russia[/td]
[td]535[/td]
[/tr]
[tr]
[td]Italy[/td]
[td]491[/td]
[/tr]
[tr]
[td]Sweden[/td]
[td]477[/td]
[/tr]
[tr]
[td]Colombia[/td]
[td]469[/td]
[/tr]
[tr]
[td]Denmark[/td]
[td]459[/td]
[/tr]
[tr]
[td]Peru[/td]
[td]451[/td]
[/tr]
[tr]
[td]Australia[/td]
[td]434[/td]
[/tr]
[tr]
[td]United Kingdom[/td]
[td]431[/td]
[/tr]
[tr]
[td]Iran[/td]
[td]401[/td]
[/tr]
[tr]
[td]Malaysia[/td]
[td]401[/td]
[/tr]
[tr]
[td]Belgium[/td]
[td]374[/td]
[/tr]
[tr]
[td]Vietnam[/td]
[td]337[/td]
[/tr]
[tr]
[td]Chile[/td]
[td]320[/td]
[/tr]
[tr]
[td]Singapore[/td]
[td]304[/td]
[/tr]
[tr]
[td]Hong Kong[/td]
[td]286[/td]
[/tr]
[tr]
[td]Romania[/td]
[td]258[/td]
[/tr]
[tr]
[td]Norway[/td]
[td]250[/td]
[/tr]
[tr]
[td]Czech Republic[/td]
[td]232[/td]
[/tr]
[tr]
[td]Israel[/td]
[td]190[/td]
[/tr]
[tr]
[td]Belarus[/td]
[td]177[/td]
[/tr]
[tr]
[td]Guatemala[/td]
[td]167[/td]
[/tr]
[tr]
[td]Austria[/td]
[td]163[/td]
[/tr]
[tr]
[td]Finland[/td]
[td]155[/td]
[/tr]
[tr]
[td]Slovenia[/td]
[td]125[/td]
[/tr]
[tr]
[td]Turkey[/td]
[td]116[/td]
[/tr]
[tr]
[td]New Zealand[/td]
[td]112[/td]
[/tr]
[tr]
[td]Venezuela[/td]
[td]110[/td]
[/tr]
[tr]
[td]Argentina[/td]
[td]109[/td]
[/tr]
[tr]
[td]Slovakia[/td]
[td]101[/td]
[/tr]
[tr]
[td]Switzerland[/td]
[td]95[/td]
[/tr]
[tr]
[td]Dominican Republic[/td]
[td]93[/td]
[/tr]
[tr]
[td]United Arab Emirates[/td]
[td]90[/td]
[/tr]
[tr]
[td]Serbia[/td]
[td]80[/td]
[/tr]
[tr]
[td]Croatia[/td]
[td]71[/td]
[/tr]
[tr]
[td]Mongolia[/td]
[td]70[/td]
[/tr]
[tr]
[td]Portugal[/td]
[td]60[/td]
[/tr]
[tr]
[td]Estonia[/td]
[td]59[/td]
[/tr]
[tr]
[td]Greece[/td]
[td]41[/td]
[/tr]
[tr]
[td]Georgia[/td]
[td]35[/td]
[/tr]
[tr]
[td]Macau[/td]
[td]35[/td]
[/tr]
[tr]
[td]Latvia[/td]
[td]34[/td]
[/tr]
[tr]
[td]South Africa[/td]
[td]33[/td]
[/tr]
[tr]
[td]Iceland[/td]
[td]32[/td]
[/tr]
[tr]
[td]Bosnia and Herzegovina[/td]
[td]23[/td]
[/tr]
[tr]
[td]Lithuania[/td]
[td]19[/td]
[/tr]
[tr]
[td]Andorra[/td]
[td]17[/td]
[/tr]
[tr]
[td]Ireland[/td]
[td]15[/td]
[/tr]
[tr]
[td]Jordan[/td]
[td]9[/td]
[/tr]
[/table]

And for the US States: http://www.openheatmap.com/view.html?map=SphygmomanometriesScoffingstockZymotically

[table="class: grid"]
[tr]
[td]state[/td]
[td]value[/td]
[/tr]
[tr]
[td]California[/td]
[td]1946[/td]
[/tr]
[tr]
[td]New Jersey[/td]
[td]1141[/td]
[/tr]
[tr]
[td]Massachusetts[/td]
[td]681[/td]
[/tr]
[tr]
[td]Nevada[/td]
[td]679[/td]
[/tr]
[tr]
[td]Pennsylvania[/td]
[td]511[/td]
[/tr]
[tr]
[td]Ohio[/td]
[td]493[/td]
[/tr]
[tr]
[td]New York[/td]
[td]418[/td]
[/tr]
[tr]
[td]Connecticut[/td]
[td]406[/td]
[/tr]
[tr]
[td]Indiana[/td]
[td]399[/td]
[/tr]
[tr]
[td]Illinois[/td]
[td]378[/td]
[/tr]
[tr]
[td]Maryland[/td]
[td]346[/td]
[/tr]
[tr]
[td]Texas[/td]
[td]316[/td]
[/tr]
[tr]
[td]Minnesota[/td]
[td]299[/td]
[/tr]
[tr]
[td]Michigan[/td]
[td]291[/td]
[/tr]
[tr]
[td]Virginia[/td]
[td]230[/td]
[/tr]
[tr]
[td]Georgia[/td]
[td]220[/td]
[/tr]
[tr]
[td]Florida[/td]
[td]197[/td]
[/tr]
[tr]
[td]Colorado[/td]
[td]169[/td]
[/tr]
[tr]
[td]Washington[/td]
[td]150[/td]
[/tr]
[tr]
[td]Iowa[/td]
[td]118[/td]
[/tr]
[tr]
[td]Wisconsin[/td]
[td]101[/td]
[/tr]
[tr]
[td]Rhode Island[/td]
[td]74[/td]
[/tr]
[tr]
[td]Utah[/td]
[td]65[/td]
[/tr]
[tr]
[td]Arizona[/td]
[td]64[/td]
[/tr]
[tr]
[td]North Carolina[/td]
[td]60[/td]
[/tr]
[tr]
[td]Kansas[/td]
[td]45[/td]
[/tr]
[tr]
[td]Kentucky[/td]
[td]45[/td]
[/tr]
[tr]
[td]Oklahoma[/td]
[td]40[/td]
[/tr]
[tr]
[td]West Virginia[/td]
[td]33[/td]
[/tr]
[tr]
[td]Nebraska[/td]
[td]29[/td]
[/tr]
[tr]
[td]Oregon[/td]
[td]26[/td]
[/tr]
[tr]
[td]Idaho[/td]
[td]23[/td]
[/tr]
[tr]
[td]Missouri[/td]
[td]19[/td]
[/tr]
[tr]
[td]Tennessee[/td]
[td]10[/td]
[/tr]
[/table]

EDIT: This was using data from WCA_export485_20141008
 
Last edited:
Neat. I have slightly larger numbers, though. Did you use the current export?

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

[TABLE="class:grid,align:left"]
[TR][TD]Country[/TD][TD]Competitors[/TD][/TR]
[TR][TD]USA[/TD][TD="align:right"]6355[/TD][/TR]
[TR][TD]China[/TD][TD="align:right"]5097[/TD][/TR]
[TR][TD]India[/TD][TD="align:right"]2790[/TD][/TR]
[TR][TD]Poland[/TD][TD="align:right"]1651[/TD][/TR]
[TR][TD]Germany[/TD][TD="align:right"]1424[/TD][/TR]
[TR][TD]Canada[/TD][TD="align:right"]1272[/TD][/TR]
[TR][TD]Brazil[/TD][TD="align:right"]1267[/TD][/TR]
[TR][TD]France[/TD][TD="align:right"]1106[/TD][/TR]
[TR][TD]Indonesia[/TD][TD="align:right"]1028[/TD][/TR]
[TR][TD]Japan[/TD][TD="align:right"]887[/TD][/TR]
[TR][TD]Spain[/TD][TD="align:right"]870[/TD][/TR]
[TR][TD]Taiwan[/TD][TD="align:right"]717[/TD][/TR]
[TR][TD]Hungary[/TD][TD="align:right"]679[/TD][/TR]
[TR][TD]Ukraine[/TD][TD="align:right"]635[/TD][/TR]
[TR][TD]Thailand[/TD][TD="align:right"]589[/TD][/TR]
[TR][TD]Philippines[/TD][TD="align:right"]588[/TD][/TR]
[TR][TD]Korea[/TD][TD="align:right"]572[/TD][/TR]
[TR][TD]Netherlands[/TD][TD="align:right"]566[/TD][/TR]
[TR][TD]Mexico[/TD][TD="align:right"]541[/TD][/TR]
[TR][TD]Russia[/TD][TD="align:right"]533[/TD][/TR]
[TR][TD]Italy[/TD][TD="align:right"]491[/TD][/TR]
[TR][TD]Sweden[/TD][TD="align:right"]477[/TD][/TR]
[TR][TD]Colombia[/TD][TD="align:right"]469[/TD][/TR]
[TR][TD]Denmark[/TD][TD="align:right"]459[/TD][/TR]
[TR][TD]Peru[/TD][TD="align:right"]451[/TD][/TR]
[TR][TD]Australia[/TD][TD="align:right"]434[/TD][/TR]
[TR][TD]United Kingdom[/TD][TD="align:right"]430[/TD][/TR]
[TR][TD]Malaysia[/TD][TD="align:right"]401[/TD][/TR]
[TR][TD]Iran[/TD][TD="align:right"]401[/TD][/TR]
[TR][TD]Belgium[/TD][TD="align:right"]374[/TD][/TR]
[TR][TD]Vietnam[/TD][TD="align:right"]337[/TD][/TR]
[TR][TD]Chile[/TD][TD="align:right"]320[/TD][/TR]
[TR][TD]Singapore[/TD][TD="align:right"]304[/TD][/TR]
[TR][TD]Hong Kong[/TD][TD="align:right"]286[/TD][/TR]
[TR][TD]Romania[/TD][TD="align:right"]258[/TD][/TR]
[TR][TD]Norway[/TD][TD="align:right"]250[/TD][/TR]
[TR][TD]Czech Republic[/TD][TD="align:right"]233[/TD][/TR]
[TR][TD]Israel[/TD][TD="align:right"]190[/TD][/TR]
[TR][TD]Belarus[/TD][TD="align:right"]178[/TD][/TR]
[TR][TD]Guatemala[/TD][TD="align:right"]167[/TD][/TR]
[TR][TD]Austria[/TD][TD="align:right"]163[/TD][/TR]
[TR][TD]Finland[/TD][TD="align:right"]155[/TD][/TR]
[TR][TD]Slovenia[/TD][TD="align:right"]124[/TD][/TR]
[TR][TD]New Zealand[/TD][TD="align:right"]122[/TD][/TR]
[TR][TD]Turkey[/TD][TD="align:right"]116[/TD][/TR]
[TR][TD]Venezuela[/TD][TD="align:right"]110[/TD][/TR]
[TR][TD]Argentina[/TD][TD="align:right"]109[/TD][/TR]
[TR][TD]Slovakia[/TD][TD="align:right"]101[/TD][/TR]
[TR][TD]Switzerland[/TD][TD="align:right"]95[/TD][/TR]
[TR][TD]Dominican Republic[/TD][TD="align:right"]93[/TD][/TR]
[TR][TD]United Arab Emirates[/TD][TD="align:right"]90[/TD][/TR]
[TR][TD]Serbia[/TD][TD="align:right"]80[/TD][/TR]
[TR][TD]Croatia[/TD][TD="align:right"]71[/TD][/TR]
[TR][TD]Mongolia[/TD][TD="align:right"]70[/TD][/TR]
[TR][TD]Portugal[/TD][TD="align:right"]60[/TD][/TR]
[TR][TD]Estonia[/TD][TD="align:right"]59[/TD][/TR]
[TR][TD]Greece[/TD][TD="align:right"]41[/TD][/TR]
[TR][TD]Macau[/TD][TD="align:right"]35[/TD][/TR]
[TR][TD]Georgia[/TD][TD="align:right"]35[/TD][/TR]
[TR][TD]Latvia[/TD][TD="align:right"]34[/TD][/TR]
[TR][TD]South Africa[/TD][TD="align:right"]33[/TD][/TR]
[TR][TD]Iceland[/TD][TD="align:right"]32[/TD][/TR]
[TR][TD]Bosnia and Herzegovina[/TD][TD="align:right"]23[/TD][/TR]
[TR][TD]Lithuania[/TD][TD="align:right"]19[/TD][/TR]
[TR][TD]Andorra[/TD][TD="align:right"]17[/TD][/TR]
[TR][TD]Ireland[/TD][TD="align:right"]15[/TD][/TR]
[TR][TD]Jordan[/TD][TD="align:right"]9[/TD][/TR]
[/TABLE]

Code: 
[NOPARSE]SELECT countryId Country, count(distinct personId) Competitors
FROM Results join Competitions on Competitions.id=competitionId
GROUP BY countryId
ORDER BY Competitors desc;[/NOPARSE]
Using data from WCA_export486_20141008 and Stefan's WCA Statistics Tools.

[TABLE="class:grid,align:left"]
[TR][TD]State[/TD][TD]Competitors[/TD][/TR]
[TR][TD]California[/TD][TD="align:right"]1950[/TD][/TR]
[TR][TD]New Jersey[/TD][TD="align:right"]1144[/TD][/TR]
[TR][TD]Massachusetts[/TD][TD="align:right"]681[/TD][/TR]
[TR][TD]Nevada[/TD][TD="align:right"]679[/TD][/TR]
[TR][TD]Pennsylvania[/TD][TD="align:right"]511[/TD][/TR]
[TR][TD]Ohio[/TD][TD="align:right"]492[/TD][/TR]
[TR][TD]New York[/TD][TD="align:right"]418[/TD][/TR]
[TR][TD]Connecticut[/TD][TD="align:right"]406[/TD][/TR]
[TR][TD]Indiana[/TD][TD="align:right"]399[/TD][/TR]
[TR][TD]Illinois[/TD][TD="align:right"]378[/TD][/TR]
[TR][TD]Maryland[/TD][TD="align:right"]346[/TD][/TR]
[TR][TD]Texas[/TD][TD="align:right"]315[/TD][/TR]
[TR][TD]Minnesota[/TD][TD="align:right"]299[/TD][/TR]
[TR][TD]Michigan[/TD][TD="align:right"]290[/TD][/TR]
[TR][TD]Virginia[/TD][TD="align:right"]230[/TD][/TR]
[TR][TD]Georgia[/TD][TD="align:right"]220[/TD][/TR]
[TR][TD]Florida[/TD][TD="align:right"]197[/TD][/TR]
[TR][TD]Colorado[/TD][TD="align:right"]169[/TD][/TR]
[TR][TD]Washington[/TD][TD="align:right"]150[/TD][/TR]
[TR][TD]Iowa[/TD][TD="align:right"]118[/TD][/TR]
[TR][TD]Wisconsin[/TD][TD="align:right"]101[/TD][/TR]
[TR][TD]Rhode Island[/TD][TD="align:right"]74[/TD][/TR]
[TR][TD]Utah[/TD][TD="align:right"]65[/TD][/TR]
[TR][TD]Arizona[/TD][TD="align:right"]64[/TD][/TR]
[TR][TD]North Carolina[/TD][TD="align:right"]60[/TD][/TR]
[TR][TD]Kansas[/TD][TD="align:right"]45[/TD][/TR]
[TR][TD]Kentucky[/TD][TD="align:right"]45[/TD][/TR]
[TR][TD]Oklahoma[/TD][TD="align:right"]40[/TD][/TR]
[TR][TD]West Virginia[/TD][TD="align:right"]33[/TD][/TR]
[TR][TD]Nebraska[/TD][TD="align:right"]29[/TD][/TR]
[TR][TD]Oregon[/TD][TD="align:right"]26[/TD][/TR]
[TR][TD]Idaho[/TD][TD="align:right"]22[/TD][/TR]
[TR][TD]Missouri[/TD][TD="align:right"]19[/TD][/TR]
[TR][TD]Tennessee[/TD][TD="align:right"]10[/TD][/TR]
[/TABLE]

Code: 
[NOPARSE]CREATE FUNCTION norm_state (s text) RETURNS text
RETURN if(s='CA' or s like 'California%', 'California',
       if(s='IA', 'Iowa',
       if(s like 'Maryland%', 'Maryland',
       if(s='MI', 'Michigan',
       s))));

CREATE FUNCTION state (cityName text) RETURNS text
RETURN norm_state(substring_index(cityName, ', ', -1));

SELECT State, count(distinct personId) Competitors
FROM
  Results natural join
  (select id competitionId, state(cityName) State from Competitions where countryId='USA') tmp
GROUP BY State
ORDER BY Competitors desc;

DROP FUNCTION state;
DROP FUNCTION norm_state;[/NOPARSE]
 
Last edited:
Kit Clement said:
I did use the current export (485) at the time I started this little project (~5 hours ago) but it looks like it has updated since then.
Click to expand...

Ok, that probably explains it then. Btw, did you also love fixing the inconsistent cityName entries? Gah, why do they do that... (I thought about asking for someone (or maybe each country's delegate) to fix the cityName entries, but then decided it's probably not that important. What do you think?)
 
Stefan said:
Ok, that probably explains it then. Btw, did you also love fixing the inconsistent cityName entries? Gah, why do they do that... (I thought about asking for someone (or maybe each country's delegate) to fix the cityName entries, but then decided it's probably not that important. What do you think?)
Click to expand...

Apologies, as I'm guilty of one of the cityName inconsistencies. :P

I do think it would be nice to fix it though. Not just for making the SQL easier, but it also looks more consistent to the user on the website.
 
Kit Clement said:
Working on some statistics on the number of competitors that have competed in a given region. Here's the heat map for countries:
http://www.openheatmap.com/view.html?map=AndoritePunctosColoraturas

[table="class: grid"]
[tr]
[td]country[/td]
[td]value[/td]
[/tr]
[tr]
[td]USA[/td]
[td]6329[/td]
[/tr]
[tr]
[td]China[/td]
[td]5025[/td]
[/tr]
[tr]
[td]India[/td]
[td]2773[/td]
[/tr]
[tr]
[td]Poland[/td]
[td]1646[/td]
[/tr]
[tr]
[td]Germany[/td]
[td]1424[/td]
[/tr]
[tr]
[td]Canada[/td]
[td]1271[/td]
[/tr]
[tr]
[td]Brazil[/td]
[td]1267[/td]
[/tr]
[tr]
[td]France[/td]
[td]1106[/td]
[/tr]
[tr]
[td]Indonesia[/td]
[td]1026[/td]
[/tr]
[tr]
[td]Japan[/td]
[td]889[/td]
[/tr]
[tr]
[td]Spain[/td]
[td]870[/td]
[/tr]
[tr]
[td]Taiwan[/td]
[td]718[/td]
[/tr]
[tr]
[td]Hungary[/td]
[td]680[/td]
[/tr]
[tr]
[td]Ukraine[/td]
[td]636[/td]
[/tr]
[tr]
[td]Thailand[/td]
[td]589[/td]
[/tr]
[tr]
[td]Philippines[/td]
[td]588[/td]
[/tr]
[tr]
[td]Korea[/td]
[td]571[/td]
[/tr]
[tr]
[td]Netherlands[/td]
[td]566[/td]
[/tr]
[tr]
[td]Mexico[/td]
[td]541[/td]
[/tr]
[tr]
[td]Russia[/td]
[td]535[/td]
[/tr]
[tr]
[td]Italy[/td]
[td]491[/td]
[/tr]
[tr]
[td]Sweden[/td]
[td]477[/td]
[/tr]
[tr]
[td]Colombia[/td]
[td]469[/td]
[/tr]
[tr]
[td]Denmark[/td]
[td]459[/td]
[/tr]
[tr]
[td]Peru[/td]
[td]451[/td]
[/tr]
[tr]
[td]Australia[/td]
[td]434[/td]
[/tr]
[tr]
[td]United Kingdom[/td]
[td]431[/td]
[/tr]
[tr]
[td]Iran[/td]
[td]401[/td]
[/tr]
[tr]
[td]Malaysia[/td]
[td]401[/td]
[/tr]
[tr]
[td]Belgium[/td]
[td]374[/td]
[/tr]
[tr]
[td]Vietnam[/td]
[td]337[/td]
[/tr]
[tr]
[td]Chile[/td]
[td]320[/td]
[/tr]
[tr]
[td]Singapore[/td]
[td]304[/td]
[/tr]
[tr]
[td]Hong Kong[/td]
[td]286[/td]
[/tr]
[tr]
[td]Romania[/td]
[td]258[/td]
[/tr]
[tr]
[td]Norway[/td]
[td]250[/td]
[/tr]
[tr]
[td]Czech Republic[/td]
[td]232[/td]
[/tr]
[tr]
[td]Israel[/td]
[td]190[/td]
[/tr]
[tr]
[td]Belarus[/td]
[td]177[/td]
[/tr]
[tr]
[td]Guatemala[/td]
[td]167[/td]
[/tr]
[tr]
[td]Austria[/td]
[td]163[/td]
[/tr]
[tr]
[td]Finland[/td]
[td]155[/td]
[/tr]
[tr]
[td]Slovenia[/td]
[td]125[/td]
[/tr]
[tr]
[td]Turkey[/td]
[td]116[/td]
[/tr]
[tr]
[td]New Zealand[/td]
[td]112[/td]
[/tr]
[tr]
[td]Venezuela[/td]
[td]110[/td]
[/tr]
[tr]
[td]Argentina[/td]
[td]109[/td]
[/tr]
[tr]
[td]Slovakia[/td]
[td]101[/td]
[/tr]
[tr]
[td]Switzerland[/td]
[td]95[/td]
[/tr]
[tr]
[td]Dominican Republic[/td]
[td]93[/td]
[/tr]
[tr]
[td]United Arab Emirates[/td]
[td]90[/td]
[/tr]
[tr]
[td]Serbia[/td]
[td]80[/td]
[/tr]
[tr]
[td]Croatia[/td]
[td]71[/td]
[/tr]
[tr]
[td]Mongolia[/td]
[td]70[/td]
[/tr]
[tr]
[td]Portugal[/td]
[td]60[/td]
[/tr]
[tr]
[td]Estonia[/td]
[td]59[/td]
[/tr]
[tr]
[td]Greece[/td]
[td]41[/td]
[/tr]
[tr]
[td]Georgia[/td]
[td]35[/td]
[/tr]
[tr]
[td]Macau[/td]
[td]35[/td]
[/tr]
[tr]
[td]Latvia[/td]
[td]34[/td]
[/tr]
[tr]
[td]South Africa[/td]
[td]33[/td]
[/tr]
[tr]
[td]Iceland[/td]
[td]32[/td]
[/tr]
[tr]
[td]Bosnia and Herzegovina[/td]
[td]23[/td]
[/tr]
[tr]
[td]Lithuania[/td]
[td]19[/td]
[/tr]
[tr]
[td]Andorra[/td]
[td]17[/td]
[/tr]
[tr]
[td]Ireland[/td]
[td]15[/td]
[/tr]
[tr]
[td]Jordan[/td]
[td]9[/td]
[/tr]
[/table]

And for the US States: http://www.openheatmap.com/view.html?map=SphygmomanometriesScoffingstockZymotically

[table="class: grid"]
[tr]
[td]state[/td]
[td]value[/td]
[/tr]
[tr]
[td]California[/td]
[td]1946[/td]
[/tr]
[tr]
[td]New Jersey[/td]
[td]1141[/td]
[/tr]
[tr]
[td]Massachusetts[/td]
[td]681[/td]
[/tr]
[tr]
[td]Nevada[/td]
[td]679[/td]
[/tr]
[tr]
[td]Pennsylvania[/td]
[td]511[/td]
[/tr]
[tr]
[td]Ohio[/td]
[td]493[/td]
[/tr]
[tr]
[td]New York[/td]
[td]418[/td]
[/tr]
[tr]
[td]Connecticut[/td]
[td]406[/td]
[/tr]
[tr]
[td]Indiana[/td]
[td]399[/td]
[/tr]
[tr]
[td]Illinois[/td]
[td]378[/td]
[/tr]
[tr]
[td]Maryland[/td]
[td]346[/td]
[/tr]
[tr]
[td]Texas[/td]
[td]316[/td]
[/tr]
[tr]
[td]Minnesota[/td]
[td]299[/td]
[/tr]
[tr]
[td]Michigan[/td]
[td]291[/td]
[/tr]
[tr]
[td]Virginia[/td]
[td]230[/td]
[/tr]
[tr]
[td]Georgia[/td]
[td]220[/td]
[/tr]
[tr]
[td]Florida[/td]
[td]197[/td]
[/tr]
[tr]
[td]Colorado[/td]
[td]169[/td]
[/tr]
[tr]
[td]Washington[/td]
[td]150[/td]
[/tr]
[tr]
[td]Iowa[/td]
[td]118[/td]
[/tr]
[tr]
[td]Wisconsin[/td]
[td]101[/td]
[/tr]
[tr]
[td]Rhode Island[/td]
[td]74[/td]
[/tr]
[tr]
[td]Utah[/td]
[td]65[/td]
[/tr]
[tr]
[td]Arizona[/td]
[td]64[/td]
[/tr]
[tr]
[td]North Carolina[/td]
[td]60[/td]
[/tr]
[tr]
[td]Kansas[/td]
[td]45[/td]
[/tr]
[tr]
[td]Kentucky[/td]
[td]45[/td]
[/tr]
[tr]
[td]Oklahoma[/td]
[td]40[/td]
[/tr]
[tr]
[td]West Virginia[/td]
[td]33[/td]
[/tr]
[tr]
[td]Nebraska[/td]
[td]29[/td]
[/tr]
[tr]
[td]Oregon[/td]
[td]26[/td]
[/tr]
[tr]
[td]Idaho[/td]
[td]23[/td]
[/tr]
[tr]
[td]Missouri[/td]
[td]19[/td]
[/tr]
[tr]
[td]Tennessee[/td]
[td]10[/td]
[/tr]
[/table]

EDIT: This was using data from WCA_export485_20141008
Click to expand...


Nice job Kit! I liked it.

Edit: Maybe we should start a campaign to host a competition in every state of the U.S?
 
Last edited:
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
433
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,045
Christopher Mowla
Christopher Mowla
Discomantis
Need help solving odd swaps on big cubes
Replies
15
Views
2,501
Discomantis
Discomantis
Back
Top