Odd WCA stats/ Stats request Thread

By request of Alex Maass:

Average by country:

Nigeria 14.94
Albania 17.53
Cote d_Ivoire 19.09
Aruba 19.41333333
Afghanistan 19.68
Pakistan 22.625
Kosovo 22.8
Costa Rica 23.39
Vietnam 23.91520661
Egypt 24.19
Luxembourg 24.324
Palestine 24.49
Angola 25.63
Armenia 26.535
Taiwan 26.838297
Hong Kong 27.39443182
Philippines 27.89897582
Singapore 28.25649215
Thailand 29.15449686
Korea 29.48560531
Indonesia 29.58437016
Lithuania 31.395
Macau 31.789
Poland 32.21317295
Bosnia and Herzegovina 32.56375
Czech Republic 32.79637363
Austria 32.84108696
Latvia 33.7162963
Belarus 33.74361386
Croatia 33.77
Mongolia 33.78492537
Russia 34.07456554
Slovenia 34.324375
Iceland 34.41454545
Argentina 34.69523077
Mexico 34.82997552
Montenegro 35.36
Hungary 35.60818627
China 35.70901758
Ireland 35.98029412
Malaysia 36.12631169
United Kingdom 36.20874396
Italy 36.27345372
Paraguay 36.535
Chile 36.86044118
Belgium 37.40509091
Dominican Republic 37.57288235
Kazakhstan 37.643
Switzerland 37.6471028
Colombia 37.67353612
Slovakia 38.12882353
Moldova 38.4934375
Denmark 38.51756477
Germany 38.61949758
Venezuela 39.00047368
Bulgaria 39.26692308
Serbia 39.28373333
Sweden 39.39269767
Japan 39.58274818
Australia 39.66205414
Turkey 40.2481746
Georgia 40.25666667
Cyprus 40.28
Bolivia 40.30964286
Canada 40.41724963
Finland 40.81785185
Peru 41.07989324
New Zealand 41.2003252
Israel 42.06314136
USA 43.14881879
Greece 43.18153846
Sudan 43.22
Ukraine 44.57683463
France 45.08138723
Netherlands 45.20034483
Senegal 45.37
Estonia 46.3295122
Portugal 47.2414
Ecuador 47.62
Guatemala 47.94439153
Spain 48.10491765
Lebanon 48.74333333
Uruguay 48.77567568
Mauritius 48.9
Romania 49.85645038
Iran 49.87777228
Norway 50.19466926
Brazil 53.2885472
Sri Lanka 53.952
Azerbaijan 54.17363636
India 55.37680851
Saudi Arabia 57.15666667
South Africa 58.84578544
Morocco 62.82833333
Trinidad and Tobago 64.12
Bangladesh 65.16
Zimbabwe 66.76
Monaco 68.01
Puerto Rico 68.15666667
Algeria 71.21857143
United Arab Emirates 74.0175
Andorra 78.9075
Jordan 78.97666667
Zambia 81.72
Tunisia 88.483
El Salvador 99.12
Cuba 107.365
Malawi 116.18
Jamaica 145.09
 
AlexMaass said:
belize pls, wish it included cubers that have since then switch nationalities
Click to expand...
Something like this?
Code: 
┌──────────────────────────────────────────────────────────────────────────
│ 2015-09-17 @ 23:29:20
├──────────────────────────────────────────────────────────────────────────
│ Event: Rubik's Cube (333)
│ Year : ALL
├──────────────────────────────────────────────────────────────────────────
│ Total solves: 1016870
│ Total good  : 989675
│ Total DNF   :  26196
│ Total DNS   :    999
│ Total sub10 :  26543
│ Global mean :  26.32
│ Total competitors: 42674
├──────────────────────────────────────────────────────────────────────────
│ By Country
├────────┬────────┬──────┬──────┬────────┬─────────┬───────────────────────
│  total │   good │  dnf │  dns │   mean │ pperson │ country (competitors)
├────────┼────────┼──────┼──────┼────────┼─────────┼───────────────────────
│ 185354 │ 180631 │ 4580 │  143 │  27.91 │   23.42 │ USA (7914)
│ 101554 │  98092 │ 3301 │  161 │  24.19 │   17.54 │ China (5789)
│  64662 │  63054 │ 1573 │   35 │  21.83 │   39.87 │ Poland (1622)
│  51533 │  49343 │ 2004 │  186 │  40.39 │   12.47 │ India (4134)
│  46498 │  45499 │  980 │   19 │  22.19 │   43.74 │ Germany (1063)
│  37465 │  36603 │  810 │   52 │  35.21 │   20.87 │ Brazil (1795)
│  37204 │  36626 │  547 │   31 │  22.45 │   38.63 │ Japan (963)
│  33073 │  32326 │  735 │   12 │  26.73 │   32.17 │ France (1028)
│  32569 │  31713 │  849 │    7 │  28.26 │   23.67 │ Canada (1376)
│  29472 │  28775 │  683 │   14 │  28.16 │   33.30 │ Spain (885)
│  21890 │  21317 │  562 │   11 │  21.93 │   48.11 │ Italy (455)
│  21889 │  21360 │  522 │    7 │  22.42 │   20.85 │ Indonesia (1050)
│  20684 │  20339 │  311 │   34 │  18.74 │   25.76 │ Taiwan (803)
│  19490 │  19022 │  450 │   18 │  22.08 │   27.96 │ Russia (697)
│  18805 │  18381 │  403 │   21 │  21.23 │   23.92 │ Philippines (786)
│  17215 │  16696 │  506 │   13 │  28.50 │   21.60 │ Ukraine (797)
│  16934 │  16502 │  413 │   19 │  22.01 │   39.38 │ United Kingdom (430)
│  16923 │  16601 │  313 │    9 │  24.62 │   59.38 │ Netherlands (285)
│  16764 │  16404 │  354 │    6 │  22.24 │   34.78 │ Hungary (482)
│  14699 │  14282 │  413 │    4 │  26.94 │   25.56 │ Peru (575)
│  14653 │  14263 │  376 │   14 │  27.25 │   22.93 │ Australia (639)
│  13680 │  13360 │  313 │    7 │  26.50 │   31.38 │ Sweden (436)
│  12464 │  12140 │  317 │    7 │  26.90 │   14.79 │ Mexico (843)
│  12444 │  12098 │  332 │   14 │  20.99 │   17.00 │ Korea (732)
│  11980 │  11514 │  446 │   20 │  25.70 │   20.98 │ Colombia (571)
│  11745 │  11218 │  521 │    6 │  25.42 │   28.23 │ Chile (416)
│   9312 │   9142 │  158 │   12 │  20.55 │   26.53 │ Thailand (351)
│   8969 │   8839 │  125 │    5 │  23.84 │   51.84 │ Belgium (173)
│   8148 │   7977 │  163 │    8 │  23.84 │   20.47 │ Malaysia (398)
│   7832 │   7640 │  180 │   12 │  24.78 │   39.16 │ Denmark (200)
│   7476 │   7283 │  188 │    5 │  29.57 │   28.86 │ Norway (259)
│   6763 │   6445 │  303 │   15 │  32.16 │   15.73 │ Iran (430)
│   6512 │   6321 │  188 │    3 │  33.20 │   24.12 │ Romania (270)
│   5595 │   5398 │  193 │    4 │  28.31 │   28.40 │ Venezuela (197)
│   5510 │   5377 │  129 │    4 │  24.20 │   26.75 │ Belarus (206)
│   5300 │   5122 │  174 │    4 │  20.17 │   13.80 │ Vietnam (384)
│   4914 │   4800 │  110 │    4 │  24.48 │   36.13 │ Finland (136)
│   4704 │   4571 │  132 │    1 │  19.71 │   47.04 │ Austria (100)
│   4329 │   4174 │  154 │    1 │  20.62 │   19.77 │ Hong Kong (219)
│   4220 │   4112 │  106 │    2 │  26.95 │   21.64 │ Argentina (195)
│   4178 │   4067 │  110 │    1 │  30.04 │   23.87 │ Dominican Republic (175)
│   3820 │   3699 │  121 │    0 │  42.76 │   14.31 │ South Africa (267)
│   2979 │   2921 │   58 │    0 │  23.71 │   26.84 │ Switzerland (111)
│   2955 │   2859 │   95 │    1 │  36.80 │   15.31 │ Guatemala (193)
│   2710 │   2648 │   62 │    0 │  27.71 │   21.85 │ New Zealand (124)
│   2695 │   2588 │  107 │    0 │  29.20 │   20.57 │ Turkey (131)
│   2395 │   2346 │   48 │    1 │  23.16 │   26.03 │ Czech Republic (92)
│   2303 │   2277 │   24 │    2 │  20.08 │   35.98 │ Slovenia (64)
│   2189 │   2102 │   81 │    6 │  25.02 │    9.08 │ Singapore (241)
│   1882 │   1813 │   68 │    1 │  34.52 │    9.65 │ Israel (195)
│   1505 │   1447 │   58 │    0 │  38.72 │   13.44 │ Uruguay (112)
│   1432 │   1396 │   36 │    0 │  23.56 │   27.54 │ Slovakia (52)
│   1291 │   1263 │   28 │    0 │  28.74 │   24.36 │ Portugal (53)
│   1150 │   1122 │   21 │    7 │  29.08 │   28.05 │ Estonia (41)
│   1080 │   1053 │   27 │    0 │  26.74 │   37.24 │ Latvia (29)
│   1055 │   1010 │   45 │    0 │  26.36 │   15.07 │ Mongolia (70)
│   1052 │   1007 │   39 │    6 │  33.25 │   12.67 │ Serbia (83)
│   1044 │   1016 │   24 │    4 │  25.64 │   18.98 │ Greece (55)
│    900 │    875 │   24 │    1 │  25.68 │   16.98 │ Croatia (53)
│    755 │    742 │   13 │    0 │  23.66 │   21.57 │ Ireland (35)
│    590 │    557 │   30 │    3 │  79.75 │    9.37 │ Tunisia (63)
│    500 │    482 │   18 │    0 │  31.60 │   11.36 │ Georgia (44)
│    478 │    467 │   11 │    0 │  22.68 │   23.90 │ Lithuania (20)
│    455 │    445 │   10 │    0 │  34.12 │    8.13 │ Bolivia (56)
│    450 │    442 │    8 │    0 │  16.70 │   75.00 │ Armenia (6)
│    445 │    438 │    7 │    0 │  23.72 │   19.35 │ Iceland (23)
│    386 │    372 │   14 │    0 │  18.03 │   32.17 │ Macau (12)
│    380 │    369 │   11 │    0 │  32.58 │   11.88 │ Moldova (32)
│    323 │    315 │    8 │    0 │  27.24 │   21.53 │ Bulgaria (15)
│    315 │    313 │    2 │    0 │  21.08 │   31.50 │ Kazakhstan (10)
│    192 │    189 │    3 │    0 │  15.91 │   48.00 │ Nigeria (4)
│    188 │    186 │    2 │    0 │  28.94 │   47.00 │ Aruba (4)
│    160 │    155 │    5 │    0 │  46.85 │    7.27 │ Azerbaijan (22)
│    155 │    152 │    3 │    0 │  25.42 │   19.38 │ Bosnia and Herzegovina (8)
│    140 │    138 │    2 │    0 │  17.13 │    NONE │ Belize (-)
│    125 │    118 │    7 │    0 │  54.85 │   15.63 │ El Salvador (8)
│    115 │    110 │    5 │    0 │  21.27 │   23.00 │ Pakistan (5)
│    110 │    109 │    1 │    0 │  25.19 │   22.00 │ Luxembourg (5)
│    110 │    106 │    4 │    0 │  30.80 │   22.00 │ Sri Lanka (5)
│     75 │     69 │    6 │    0 │  59.54 │   10.71 │ Jordan (7)
│     55 │     49 │    6 │    0 │  66.30 │    6.88 │ Algeria (8)
│     50 │     29 │    5 │   16 │  64.05 │    6.25 │ United Arab Emirates (8)
│     50 │     49 │    1 │    0 │  55.98 │    8.33 │ Morocco (6)
│     37 │     36 │    1 │    0 │  73.93 │   18.50 │ Cyprus (2)
│     34 │     32 │    2 │    0 │  48.41 │   11.33 │ Puerto Rico (3)
│     30 │     30 │    0 │    0 │  23.69 │   15.00 │ Montenegro (2)
│     25 │     23 │    2 │    0 │  26.91 │    NONE │ Macedonia (-)
│     25 │     23 │    2 │    0 │  68.57 │    6.25 │ Andorra (4)
│     25 │     23 │    2 │    0 │  26.67 │   25.00 │ Egypt (1)
│     20 │     19 │    1 │    0 │  21.83 │   20.00 │ Cote d_Ivoire (1)
│     20 │     19 │    1 │    0 │  21.25 │   20.00 │ Albania (1)
│     20 │     20 │    0 │    0 │  21.96 │   20.00 │ Afghanistan (1)
│     20 │     20 │    0 │    0 │  45.02 │    6.67 │ Lebanon (3)
│     15 │     15 │    0 │    0 │  57.64 │    5.00 │ Saudi Arabia (3)
│     15 │     14 │    1 │    0 │  30.29 │   15.00 │ Angola (1)
│     15 │     14 │    1 │    0 │  60.95 │    5.00 │ Bangladesh (3)
│     15 │     15 │    0 │    0 │  26.04 │   15.00 │ Palestine (1)
│     15 │     15 │    0 │    0 │  24.46 │   15.00 │ Kosovo (1)
│     10 │      9 │    1 │    0 │  64.35 │   10.00 │ Senegal (1)
│     10 │     10 │    0 │    0 │ 113.99 │    5.00 │ Cuba (2)
│     10 │      8 │    2 │    0 │ 124.51 │   10.00 │ Jamaica (1)
│     10 │     10 │    0 │    0 │  36.18 │    5.00 │ Paraguay (2)
│     10 │     10 │    0 │    0 │  56.71 │   10.00 │ Mauritius (1)
│      5 │      5 │    0 │    0 │  83.24 │    5.00 │ Zambia (1)
│      5 │      4 │    1 │    0 │  41.84 │    5.00 │ Sudan (1)
│      5 │      5 │    0 │    0 │  75.46 │    5.00 │ Monaco (1)
│      5 │      5 │    0 │    0 │  24.53 │    5.00 │ Costa Rica (1)
│      5 │      4 │    1 │    0 │ 112.19 │    5.00 │ Malawi (1)
│      5 │      5 │    0 │    0 │  67.15 │    5.00 │ Zimbabwe (1)
│      5 │      3 │    2 │    0 │ 134.25 │    5.00 │ Madagascar (1)
│      5 │      4 │    1 │    0 │  61.30 │    5.00 │ Trinidad and Tobago (1)
│      5 │      5 │    0 │    0 │  46.32 │    5.00 │ Ecuador (1)
├────────┴────────┴──────┴──────┴────────┴─────────┴───────────────────────
│ Total counties: 112
└──────────────────────────────────────────────────────────────────────────
 
G2013 said:
I haven't found it, but which person has the longest name [of course, in the WCA database]? Each symbol counts, including spaces.

In my country there are 2 with really long names
Click to expand...

i bet its KAVIN TANGTARTHARAKUL
but probably not. there are probably some crazier names out there...
 
G2013 said:
I haven't found it, but which person has the longest name [of course, in the WCA database]? Each symbol counts, including spaces.

In my country there are 2 with really long names
Click to expand...

The longest, with 105 characters is

Athanasios Papastathopoulos-Katsaros (Αθανάσιος Παπασταθόπουλος-Κατσαρός)

But it kind of feels like cheating since that includes his full name twice...

I reckon the longest just to include the name once is

Pablo Eduardo Nikolais Teixeira Bonifácio da Silva

(51 characters)

And that has been the case since 2013...
 
Last edited:
Kit Clement said:
Whoever cleaned up the inconsistencies surrounding how states were entered into the database, thank you, you made my life really easy on this statistic.

RankNameNumber of States
1Bob Burton20
2Kit Clement18
3Brandon Mikel17
4Tim Reynolds16
5Takao Hashimoto (橋本貴夫)15
Dan Cohen15
7Jim Mertens14
Shelley Chang14
Adam Zamora14
Tyson Mao (毛台勝)14
Christopher Olson14
Anthony Brooks14
13Ryan DeLine13
Corey Sakowski13
Rowe Hessler13
Bruce Norskog13
Dave Campbell13
Chester Lian13
19AJ Blair12
Walker Welch12
Evan Liu12
Jeremy Fleischman12
Kian Barry12
Felix Lee12
Shaden Smith12
John Brechon12
David Woner12
28James Hildreth11
Mike Hughey11
Ethan Crislip11
Jaclyn Sawler11
James LaChance11
Chris Krueger11
Shane Rowland11
Timothy Sun11
Chris Hardwick11
Waris Ali11
Joshua Feran11
39Tristan Wright10
Bobby D'Angelo10
Kyle Barry10
Ryan Olson10
John Tamanas10
Anthony Hsu10
Marie Hughey10
Rebecca Hughey10
Noah Arthurs10
Kevin Hays10
Aina Hashimoto (橋本愛那)10
Leyan Lo10
Kevin Costello III10
Dan Selzer10
Phil Yu10
Jason Baum10
55Lauren Klemz9
Andrew Hwang9
Quentin McLean9
Sam Boyles9
Gavin Nelson9
Kevin Zhou9
Justin Jaffray9
Carson Penticuff9
Frank Morris9
Mike Kotch9
Justin Mallari9
Eric Zhao9
Sreeram Venkatarao9
Ian Winokur9
Bryan Logan9
Pavan Ravindra9
Henry Savich9
Chris Braiedy9
Kennan LeJeune9
74Weston Mizumoto8
Michael Young8
Nathan Dwyer8
Devin Corr-Robinett8
Clark Cheng8
Joe Epstein8
Daniel Hayes8
Jackson Warley8
Casey Pernsteiner8
Matthew Bahner8
Alex Ozer8
Dan Dzoan8
Lucas Garron8
Chris Dzoan8
Michael Gottlieb8
Shotaro Makisumi (牧角章太郎)8
Ravi Fernando8
Arthur Adams8
Myles Casanas8
Christopher Resendiz8
Collin Burns8
Zach Goldman8
Kate Sosik8
Adomous Wright8
Ilkyoo Choi (최일규)8
Mike Stewart8
Julianna Bennett8
Brandon Delacruz8
Louis Cormier8
Damian Bias8
Alese Devin8
Lucas Etter8
Zachary Nikolaus8
Phillip Lewicki8
Daniel Kottenstette8
Jasmine Lee8
Peter Still8

Note that this will not preserve unicode in Windows, but it will on Mac/Linux. I also removed FMC USA from these results -- no info regarding what state they were actually in, and it's probably safe to assume that FMC USA competitors were competing in a state they had already competed in.
Code: 
results = read.csv("WCA_export_Results.tsv", sep="\t", encoding="UTF-8")
competitions = read.csv("WCA_export_Competitions.tsv", sep="\t", encoding="UTF-8")
competitionsUSA = competitions[competitions$countryId == "USA",]

competitionsUSA_list = competitionsUSA$id

resultsUSA = results[results$competitionId %in% competitionsUSA_list,]

competitionsUSA$State = lapply(strsplit(as.character(competitionsUSA$cityName), ", "), "[", 2)

mergedtable = merge(competitionsUSA, resultsUSA, by.x = 'id', by.y = 'competitionId')
mergedtable = mergedtable[mergedtable$id != "FMCUSA2014",]

countstates = function(name) {
  dummy = mergedtable[mergedtable$personName == as.character(name),]
  number = length(unique(dummy$State))
  return(number)
}

competitors = as.character(unique(mergedtable$personName))
numComps = sapply(competitors, countstates) #really slow
outTable = as.data.frame(cbind(competitors, numComps))
outTable = outTable[order(-numComps),]
outTable$competitors = as.character(outTable$competitors)
write.csv(outTable,"outTable.csv",fileEncoding="UTF-8")

con <- file("outTable.csv", open="w", encoding="UTF-8")
write.table(outTable, con, sep=",",row.names=FALSE)
close(con)

I'll have to do a refresh of this statistic once Utah results are uploaded and I go to my first Oregon competition. :)
Click to expand...

And here's the refresh!

RankCompetitorNumber of States
1Kit Clement20
Bob Burton20
3Brandon Mikel17
4Tim Reynolds16
5Takao Hashimoto (橋本貴夫)15
Christopher Olson15
Anthony Brooks15
Dan Cohen15
9Jim Mertens14
Shelley Chang14
Adam Zamora14
Tyson Mao (毛台勝)14
13Ryan DeLine13
Evan Liu13
Corey Sakowski13
Rowe Hessler13
Bruce Norskog13
Dave Campbell13
Chester Lian13
Shaden Smith13
21AJ Blair12
Walker Welch12
Jeremy Fleischman12
Kian Barry12
Felix Lee12
Chris Hardwick12
John Brechon12
David Woner12
29James Hildreth11
Mike Hughey11
Ethan Crislip11
Jaclyn Sawler11
James LaChance11
Chris Krueger11
Shane Rowland11
Timothy Sun11
Waris Ali11
Joshua Feran11
39Tristan Wright10
Bobby D'Angelo10
Kyle Barry10
Ryan Olson10
John Tamanas10
Anthony Hsu10
Marie Hughey10
Rebecca Hughey10
Noah Arthurs10
Kevin Hays10
Aina Hashimoto (橋本愛那)10
Leyan Lo10
Kevin Costello III10
Dan Selzer10
Sreeram Venkatarao10
Phil Yu10
Jason Baum10
56Lauren Klemz9
Andrew Hwang9
Quentin McLean9
Sam Boyles9
Gavin Nelson9
Kevin Zhou9
Justin Jaffray9
Carson Penticuff9
Frank Morris9
Mike Kotch9
Justin Mallari9
Eric Zhao9
Ian Winokur9
Bryan Logan9
Pavan Ravindra9
Lucas Etter9
Henry Savich9
Kennan LeJeune9
Chris Braiedy9
75Weston Mizumoto8
Michael Young8
Nathan Dwyer8
Devin Corr-Robinett8
Clark Cheng8
Joe Epstein8
Chris Tran8
Daniel Hayes8
Jackson Warley8
Casey Pernsteiner8
Matthew Bahner8
Alex Ozer8
Dan Dzoan8
Lucas Garron8
Chris Dzoan8
Michael Gottlieb8
Shotaro Makisumi (牧角章太郎)8
Ravi Fernando8
Arthur Adams8
Myles Casanas8
Christopher Resendiz8
Zach Goldman8
Collin Burns8
Kate Sosik8
Adomous Wright8
Ilkyoo Choi (최일규)8
Mike Stewart8
Julianna Bennett8
Brandon Delacruz8
Louis Cormier8
Damian Bias8
Alese Devin8
Zachary Nikolaus8
Phillip Lewicki8
Daniel Kottenstette8
Drew Brads8
Jasmine Lee8
Peter Still8
 
bubbagrub said:
The longest, with 105 characters is
I reckon the longest just to include the name once is

Pablo Eduardo Nikolais Teixeira Bonifácio da Silva

(51 characters)

And that has been the case since 2013...
Click to expand...

Someone with a longer name registered at Worlds. Teresa Cristina Alves da Silva Gonzalez de Carvalho's name is 1 character longer, including spaces, but it makes sense to me to exclude spaces when considering the length of a name. In this case, Pablo and Teresa are tied.

Here's the top 100 list (based on WCA_export031_20150923)

NameCharactersCountry
1Pablo Eduardo Nikolais Teixeira Bonifácio da Silva44Brazil
2Teresa Cristina Alves da Silva Gonzalez de Carvalho44Brazil
3Stanislaus Mahesworo Christandito Tandelilin41Indonesia
4Periyathottam Sirunallikovil Yokaraaj Surend41India
5Munguluri Nagagopala Jagannandha Surya Anand40India
6Lucas Gabriel De Oliveira Passos Albuquerque39Brazil
7Carlos Adriano Trindade de Albuquerque Filho39Brazil
8Guilherme Miguel Bissoli Cordeiro dos Santos39Brazil
9Gustavo Castanho Garrine Moreira dos Santos38Brazil
10Leonardho Justino dos Santos Braga de Lucena38Brazil
11Francisco de Asís Montalvo Martín de Almagro38Spain
12Muhammad Daniel Hakimi bin Mohammad Firdaus38Malaysia
13Luiz Fernando Merli de Oliveira Sementille37Brazil
14Velidi Venkata Jagan Mohana Murali Krishna37India
15Andres Enrique Martin Vasquez Huillcamisa37Peru
16Edgar Henrique Bissoli Cordeiro dos Santos37Brazil
17Khan Mohammed Safdar Mohammed Ishtiyaque36India
18Alec Chandler Nogueira Marques Rodrigues36Brazil
19Paulo Vinicius Nogueira Tonel de Oliveira36Brazil
20Raphael Vasconcellos Ludovico de Almeida36Brazil
21Fernanda Rafaela Lima Carneiro dos Santos36Brazil
22Péricles José Carvalho de Oliveira Júnior36Brazil
23Jeferson Henrique Marques Dias dos Santos36Brazil
24Marcos Vinícius Vieira Takahashi da Silva36Brazil
25Marcos Alberto Gonçalves dos Santos Filho36Brazil
26Guilherme Henrique Alves Galhardo Silva35Brazil
27André Rodrigo César Pinheiro Monte Amado35Brazil
28Helen Christina Pereira dos Santos Silva35Brazil
29Johannes Antonius Van Hezewyk Contreras35Mexico
30Marcos Henrique de Paula Rosa Nascimento35Brazil
31Wellington Wagner dos Santos Silva Filho35Brazil
32Prasetyo Adyputera Sesiliaan Lonakioek35Indonesia
33David de Jesus Ulises Hernandez Gonzalez35Mexico
34Bruno Hallyson Capistrano Costa Pereira35Brazil
35Francisco Sebastian Guerrero Costañeda35Mexico
36Athanasios Papastathopoulos-Katsaros35Greece
37Francisco Eduardo Martins Serra Espuny34Brazil
38Pierre-Alexandre Langlois Gaudreault34Canada
39Maximiliano Rodrigo Gonzalez Olivares34Chile
40Juan Antonio Montalvo Martín de Almagro34Spain
41Guruprasadh Kuppusamy Sundaramoorthy34India
42Eduardo Carvalheira Teixeira de Aguiar34Brazil
43Vitor Manoel Teixeira de Moraes Almeida34Brazil
44Tácito Sampaio Gaspar de Oliveira Filho34Brazil
45João Pedro Martins Pires Marques Freire34Portugal
46Alejandro Edmundo Andres Barrios Rocha34Peru
47Pedro Henrique Maciel Ceccopieiri Belo34Brazil
48Evenlly Michaela Figueredo Boaventura34Brazil
49Harshavardhan Chettipalli Somashekar34India
50Seyyed Mohamadmasih Hashemi Fesharaki34Iran
51Matheus Dulcini Demarzo Alves Ferreira34Brazil
52Pranav Srikar Bangalore Sathya Chandan34India
53Gustavo Gonçalves de Araujo Vilas Boas33Brazil
54Jheferson Alexander García Dominguez33Colombia
55Gustavo de Camargo Casemiro Rodrigues33Brazil
56Marius Rombout Ferreira van Riemsdijk33Brazil
57Douglas Henrique Evangelista de Assis33Brazil
58Mauricio Fernando Hernández Dionicio33Mexico
59Vinicius Pereira de Almeida Rodrigues33Brazil
60Marcus Vinicius Mota Pinheiro da Costa33Brazil
61Kevin Jesus Alexander Guarniz Aguilar33Peru
62Mariana Carolayne da Silva Nascimento33Brazil
63Ricardo Bittencourt de Almeida Júnior33Brazil
64Stephany Emperatriz Cruces Maldonado33Peru
65Priscila Alexandra Esquivel Martinez33Peru
66Mohamed Haryz Izzudin Bin Mohamed Rafy33Malaysia
67Guilherme Barros Alexandre d'Almeida33Brazil
68Állisson Marllon Cássio Alves Barbosa33Brazil
69Mohammad Harith Izzuddin Bin Mohd Naim33Malaysia
70Alejandro Valentín Becerril Calvillo33Mexico
71Luis Henrique Da Silva Gongra Oliveira33Brazil
72Flavio Henrique da Cruz Rosa Gonçalves33Brazil
73Manunandhan Navilarasu Subrahmanyan33India
74Kaileygh Desirée Montes de Oca Aguirre33Mexico
75Andrezza Anizia Torres Sampaio Barros33Brazil
76Leonardo Rodrigues Bertoldi Trujillo33Brazil
77Jorge Miguel Aarón Barrientos Álvarez33Mexico
78Daniel Alexander González Mazariegos33Guatemala
79Stephanie Alejandra Frías Betancourt33Mexico
80Karuna Gandikota Srinivasulluchetty33India
81Larissa Aparecida de Oliveira Freitas33Brazil
82Elizabeth Paola Matos Holguin-Veras32Dominican Republic
83Eduardo Bernieri Schiavon de Andrade32Brazil
84Deborah Katharina Martins Rodrigues32Brazil
85João Pedro de Castro Message Oliveira32Brazil
86Victor Ebubechukwu Tobechukwu Asiwe32Nigeria
87Francisco das Chagas Pereira da Silva32Brazil
88Daniel Felipe Castiblanco Sepúlveda32Colombia
89Marcela Bertoldi Trujillo Campiteli32Brazil
90Yannick Tonatiuh Napsuciale Heredia32Mexico
91Dario Alexander Rodríguez Hernández32Mexico
92Sandra Regina da Conceicao Eliziario32Brazil
93Berenilson Soares de Oliveira Junior32Brazil
94Alessandro Tavares da Silva Bernardo32Brazil
95Luiz Guilherme de Lizio Póvoa Ribeiro32Brazil
96Christian Xavier Castillo Rodriguez32Colombia
97Luiz Fernando de Medeiros Paiva Moura32Brazil
98Walter Alexander Junior Licas Torres32Peru
99Miguel Enrique Lopes Carneiro Araujo32Brazil
100Muhammad Ali Imran bin Muhammad Radzi32Malaysia

But because the original post asked to include spaces...
NameCharactersCountry
1Teresa Cristina Alves da Silva Gonzalez de Carvalho51Brazil
2Pablo Eduardo Nikolais Teixeira Bonifácio da Silva50Brazil
3Carlos Adriano Trindade de Albuquerque Filho44Brazil
4Leonardho Justino dos Santos Braga de Lucena44Brazil
5Periyathottam Sirunallikovil Yokaraaj Surend44India
6Lucas Gabriel De Oliveira Passos Albuquerque44Brazil
7Guilherme Miguel Bissoli Cordeiro dos Santos44Brazil
8Stanislaus Mahesworo Christandito Tandelilin44Indonesia
9Munguluri Nagagopala Jagannandha Surya Anand44India
10Francisco de Asís Montalvo Martín de Almagro44Spain
11Gustavo Castanho Garrine Moreira dos Santos43Brazil
12Muhammad Daniel Hakimi bin Mohammad Firdaus43Malaysia
13Edgar Henrique Bissoli Cordeiro dos Santos42Brazil
14Luiz Fernando Merli de Oliveira Sementille42Brazil
15Velidi Venkata Jagan Mohana Murali Krishna42India
16Fernanda Rafaela Lima Carneiro dos Santos41Brazil
17Andres Enrique Martin Vasquez Huillcamisa41Peru
18Marcos Alberto Gonçalves dos Santos Filho41Brazil
19Péricles José Carvalho de Oliveira Júnior41Brazil
20Jeferson Henrique Marques Dias dos Santos41Brazil
21Marcos Vinícius Vieira Takahashi da Silva41Brazil
22Paulo Vinicius Nogueira Tonel de Oliveira41Brazil
23Wellington Wagner dos Santos Silva Filho40Brazil
24Marcos Henrique de Paula Rosa Nascimento40Brazil
25Alec Chandler Nogueira Marques Rodrigues40Brazil
26André Rodrigo César Pinheiro Monte Amado40Brazil
27David de Jesus Ulises Hernandez Gonzalez40Mexico
28Khan Mohammed Safdar Mohammed Ishtiyaque40India
29Raphael Vasconcellos Ludovico de Almeida40Brazil
30Helen Christina Pereira dos Santos Silva40Brazil
31Guilherme Henrique Alves Galhardo Silva39Brazil
32Vitor Manoel Teixeira de Moraes Almeida39Brazil
33Bruno Hallyson Capistrano Costa Pereira39Brazil
34Juan Antonio Montalvo Martín de Almagro39Spain
35Tácito Sampaio Gaspar de Oliveira Filho39Brazil
36Johannes Antonius Van Hezewyk Contreras39Mexico
37João Pedro Martins Pires Marques Freire39Portugal
38Mohamed Haryz Izzudin Bin Mohamed Rafy38Malaysia
39Francisco Eduardo Martins Serra Espuny38Brazil
40Marcus Vinicius Mota Pinheiro da Costa38Brazil
41Gustavo Gonçalves de Araujo Vilas Boas38Brazil
42Pedro Henrique Maciel Ceccopieiri Belo38Brazil
43Alejandro Edmundo Andres Barrios Rocha38Peru
44Luis Henrique Da Silva Gongra Oliveira38Brazil
45Mohammad Harith Izzuddin Bin Mohd Naim38Malaysia
46Matheus Dulcini Demarzo Alves Ferreira38Brazil
47Eduardo Carvalheira Teixeira de Aguiar38Brazil
48Kaileygh Desirée Montes de Oca Aguirre38Mexico
49Flavio Henrique da Cruz Rosa Gonçalves38Brazil
50Prasetyo Adyputera Sesiliaan Lonakioek38Indonesia
51Francisco Sebastian Guerrero Costañeda38Mexico
52Pranav Srikar Bangalore Sathya Chandan38India
53Larissa Aparecida de Oliveira Freitas37Brazil
54Maximiliano Rodrigo Gonzalez Olivares37Chile
55Luiz Fernando de Medeiros Paiva Moura37Brazil
56Állisson Marllon Cássio Alves Barbosa37Brazil
57Marius Rombout Ferreira van Riemsdijk37Brazil
58Luiz Guilherme de Lizio Póvoa Ribeiro37Brazil
59Muhammad Farhan Bin Hardy Adrian Chin37Malaysia
60Muhammad Ali Imran bin Muhammad Radzi37Malaysia
61João Pedro de Castro Message Oliveira37Brazil
62Muhammad Syafi Hakim Bin Mohd Zuhairi37Malaysia
63Francisco das Chagas Pereira da Silva37Brazil
64Jorge Miguel Aarón Barrientos Álvarez37Mexico
65Kevin Jesus Alexander Guarniz Aguilar37Peru
66Andrezza Anizia Torres Sampaio Barros37Brazil
67Mariana Carolayne da Silva Nascimento37Brazil
68Douglas Henrique Evangelista de Assis37Brazil
69Ricardo Bittencourt de Almeida Júnior37Brazil
70Seyyed Mohamadmasih Hashemi Fesharaki37Iran
71Evenlly Michaela Figueredo Boaventura37Brazil
72Vinicius Pereira de Almeida Rodrigues37Brazil
73Gustavo de Camargo Casemiro Rodrigues37Brazil
74Miguel Enrique Lopes Carneiro Araujo36Brazil
75Mauricio Fernando Hernández Dionicio36Mexico
76Daniel Alexander González Mazariegos36Guatemala
77Gabriel Leonardo Martins de Oliveira36Brazil
78Berenilson Soares de Oliveira Junior36Brazil
79Muhammad Irfan Syafiq bin Mohd Anuar36Malaysia
80Samantha Cristina Fernandes da Silva36Brazil
81João Vitor Areias Barreto de Almeida36Brazil
82Alessandro Tavares da Silva Bernardo36Brazil
83Guruprasadh Kuppusamy Sundaramoorthy36India
84Sandra Regina da Conceicao Eliziario36Brazil
85Eduardo Bernieri Schiavon de Andrade36Brazil
86Charles Henrique Escorcio dos Santos36Brazil
87Harshavardhan Chettipalli Somashekar36India
88Jheferson Alexander García Dominguez36Colombia
89Guilherme Barros Alexandre d'Almeida36Brazil
90Sandro Roberto Pires da Silva Junior36Brazil
91Karen Haidee Suárez del Real Rosales36Mexico
92Alejandro Valentín Becerril Calvillo36Mexico
93Renato de Oliveira Noronha Rodrigues36Brazil
94Caio Henrique Mugarte Tonhar Moreira36Brazil
95José Luiz Martins de Almeida e Souza36Brazil
96Athanasios Papastathopoulos-Katsaros36Greece
97Stephanie Alejandra Frías Betancourt36Mexico
98Leonardo Rodrigues Bertoldi Trujillo36Brazil
99Walter Alexander Junior Licas Torres36Peru
100Muhammad Zikry Shafiq Bin Zulkarnain36Malaysia
 
Ninja Storm said:
What are the largest single-day competitions?
Click to expand...

RankCompIDNumber of Competitors
1SCMUJuhuOpen2015189
2FMCEurope2015176
3BeijingSummerOpen2009162
4ShenYangOpen2011154
5SuzhouOpen2014153
6SanFranciscoOpen2009150
7BeijingMetropolisOpen2009149
GuangdongOpen2008149
9KrakowCubingSpree2014147
ShenyangOpen2014147
SLSJastrzebie2013147
12PantheonCubeOpen2014139
TorontoOpenSpring2015139
14SLSBielskoBiala2014136
SLSTarnowskieGory2014136
16LibertyScience2013134
17RedCrossCubingOpen2014131
18NorwichSummer2015129
19BUAAOpen2010127
20IETEC2015124
MITSpring2015124
22DoylestownSpring2015123
23RiverHillWinter2015122
24France2012121
Indiana2014121
26TaiwanSummer2012120
27DuanwuFestivalOpen2009119
JoanaDArcOpen2014119
29TokyoOpen2006118
30GuangzhouCCSA2013116
TorontoOpenWinter2013116
32BayAreaSpeedcubin42014115
KCAKoreaOpen2008115
PragyanOpen2011115
35GeniusKidIndiaOpen2014113
GuangzhouNewYear2015113
37BerkeleyFall2014111
SLSCzestochowa2013111
ZhengzhouOpen2015111
40CanadianCubingFifty2014110
MITFall2014110
42BerkeleySpring2014108
CaltechFall2013108
NationalTPolyOpen2014108
NiseiWeek2015108
46TorontoWinter2011107
47FECAPOpen2015106
PragyanOpen2012106
49ShantouOpen2015105
SPCSStanfordSpring2015105
TorontoOpenWinter2015105
52Atlanta2015104
UTNOtono2015104
54BeijingSpringOpen2009103
LexingtonSpring2015103
56CaltechWinter2007102
HarbinOpen2009102
58IGARubik2014101
LawrenceSpring2015101
ShanghaiWeisuoOpen2009101
TorontoOpenSpring2014101
UtahMegacomp2015101
63BerkeleySummer2015100
PrincetonWinter2014100
RiverHillSummer2014100
TorontoFall2010100
TorontoWinter2010100
68Germany200999
PuneFallOpen201599
70PrincetonFall201098
ShenzhenOpen201598
72HarvardFall201497
NanjingNormalUniveristy201397
SLSSwierklany201397
TaiwanWinterOpen200997
TorontoOpenFall201497
77NanjingSpring201296
78Indiana201295
Indiana201395
TaiwanSummer201095
81ChangChun201094
GLSSummer201394
HarbinOpen201494
JapanOpen200794
Johannesburg201494
NanjingOpen200994
NewarkWinter200994
88BASC7201593
BeijingSummer201493
BerkeleySpring201593
DneprCubeDay201493
ICTOpen201593
NanjingSpringOpen201093
ParaxCubecomp201593
RoseCity201593
TorontoSummer201093
97CaltechWinter201492
KharkivSpecial201592
PolishOpen200892
RybnikOpen201392

Code: 
results = read.csv("WCA_export_Results.tsv", sep="\t", encoding="UTF-8")
competitions = read.csv("WCA_export_Competitions.tsv", sep="\t", encoding="UTF-8")

oneday = as.character(competitions$id[competitions$day == competitions$endDay])

numComp = function(comp) {
  dump = results$personName[results$competitionId == comp]
  return(length(unique(dump)))
}


num = sapply(oneday, numComp) #long wait

output = as.data.frame(cbind(oneday, num))
output = output[order(-num),]
write.csv(output, "OneDayComps.csv")
 
Kit Clement said:
RankCompIDNumber of Competitors
1SCMUJuhuOpen2015189
2FMCEurope2015176
3BeijingSummerOpen2009162
4ShenYangOpen2011154
5SuzhouOpen2014153
6SanFranciscoOpen2009150
7BeijingMetropolisOpen2009149
GuangdongOpen2008149
9KrakowCubingSpree2014147
ShenyangOpen2014147
SLSJastrzebie2013147
12PantheonCubeOpen2014139
TorontoOpenSpring2015139
14SLSBielskoBiala2014136
SLSTarnowskieGory2014136
16LibertyScience2013134
17RedCrossCubingOpen2014131
18NorwichSummer2015129
19BUAAOpen2010127
20IETEC2015124
MITSpring2015124
22DoylestownSpring2015123
23RiverHillWinter2015122
24France2012121
Indiana2014121
26TaiwanSummer2012120
27DuanwuFestivalOpen2009119
JoanaDArcOpen2014119
29TokyoOpen2006118
30GuangzhouCCSA2013116
TorontoOpenWinter2013116
32BayAreaSpeedcubin42014115
KCAKoreaOpen2008115
PragyanOpen2011115
35GeniusKidIndiaOpen2014113
GuangzhouNewYear2015113
37BerkeleyFall2014111
SLSCzestochowa2013111
ZhengzhouOpen2015111
40CanadianCubingFifty2014110
MITFall2014110
42BerkeleySpring2014108
CaltechFall2013108
NationalTPolyOpen2014108
NiseiWeek2015108
46TorontoWinter2011107
47FECAPOpen2015106
PragyanOpen2012106
49ShantouOpen2015105
SPCSStanfordSpring2015105
TorontoOpenWinter2015105
52Atlanta2015104
UTNOtono2015104
54BeijingSpringOpen2009103
LexingtonSpring2015103
56CaltechWinter2007102
HarbinOpen2009102
58IGARubik2014101
LawrenceSpring2015101
ShanghaiWeisuoOpen2009101
TorontoOpenSpring2014101
UtahMegacomp2015101
63BerkeleySummer2015100
PrincetonWinter2014100
RiverHillSummer2014100
TorontoFall2010100
TorontoWinter2010100
68Germany200999
PuneFallOpen201599
70PrincetonFall201098
ShenzhenOpen201598
72HarvardFall201497
NanjingNormalUniveristy201397
SLSSwierklany201397
TaiwanWinterOpen200997
TorontoOpenFall201497
77NanjingSpring201296
78Indiana201295
Indiana201395
TaiwanSummer201095
81ChangChun201094
GLSSummer201394
HarbinOpen201494
JapanOpen200794
Johannesburg201494
NanjingOpen200994
NewarkWinter200994
88BASC7201593
BeijingSummer201493
BerkeleySpring201593
DneprCubeDay201493
ICTOpen201593
NanjingSpringOpen201093
ParaxCubecomp201593
RoseCity201593
TorontoSummer201093
97CaltechWinter201492
KharkivSpecial201592
PolishOpen200892
RybnikOpen201392

Code: 
results = read.csv("WCA_export_Results.tsv", sep="\t", encoding="UTF-8")
competitions = read.csv("WCA_export_Competitions.tsv", sep="\t", encoding="UTF-8")

oneday = as.character(competitions$id[competitions$day == competitions$endDay])

numComp = function(comp) {
  dump = results$personName[results$competitionId == comp]
  return(length(unique(dump)))
}


num = sapply(oneday, numComp) #long wait

output = as.data.frame(cbind(oneday, num))
output = output[order(-num),]
write.csv(output, "OneDayComps.csv")
Click to expand...

Aye! I went to (one of the) #58(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
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,502
Discomantis
Discomantis
Back
Top