Odd WCA stats/ Stats request Thread

[Lid]

Possibly a mistake somewhere? Rob Yau and myself both have over 50 (and Breandan has 93)

True, but did you read the question - "most NR's broken by a single person (CR and WR don't count)"?

 

[DuffyEdge]

True, but did you read the question - "most NR's broken by a single person (CR and WR don't count)"?

Daniel still has over 50 NRs

 

[Lid]

OK, error found, somehow it counted as one when there where both single & avg records. Data updated above!

Spoiler: Bouns list including CR & WR also (70+)

225	2006BUUS01	Henrik Buus Aagaard (m), Denmark
202	2009ZEMD01	Feliks Zemdegs (m), Australia
190	2005AKKE01	Erik Akkersdijk (m), Netherlands
140	2005BATI01	Milán Baticz (m), Hungary
140	2010MOND01	Pablo Nicolás Oshiro Mondoñedo (m), Peru
135	2007COMP01	Emile Compion (m), South Africa
127	2008WEST02	Simon Westlund (m), Sweden
125	2008BARA01	Bence Barát (m), Hungary
124	2012BEAH01	Ciarán Beahan (m), Ireland
121	2011KUDA01	Nurym Kudaibergen (m), Kazakhstan
120	2004KRIG01	Gunnar Krig (m), Sweden
120	2010VYNN01	Ivan Vynnyk (Іван Винник) (m), Ukraine
117	2010OMUL02	Matic Omulec (m), Slovenia
116	2003VAND01	Lars Vandenbergh (m), Belgium
113	2009MAGN02	Hilmar Magnusson (m), Iceland
111	2012PATE01	Antonie Paterakis (m), Greece
102	2007GUIM01	Pedro Santos Guimarães (m), Brazil
101	2009BEAR01	Dene Beardsley (m), New Zealand
96	2009BALT02	Leandro Baltazar (m), Portugal
95	2009ROHR01	Michael Röhrer (m), Austria
93	2007VALL01	Breandan Vallance (m), United Kingdom
90	2007COHE01	Dan Cohen (m), USA
85	2012ADLO01	Aramayis Adloyan (Արամայիս Ադլոյան) (m), Armenia
84	2003POCH01	Stefan Pochmann (m), Germany
84	2010ARBO01	Morten Arborg (m), Norway
84	2011BENZ01	Boriss Benzerruki (m), Latvia
84	2013CONT01	Oscar Alberto Ceballos Contreras (m), Venezuela
83	2005VANH01	Anssi Vanhala (m), Finland
82	2006HALC01	Michał Halczuk (m), Poland
82	2006ORLA01	Bernett Orlando (m), India
81	2006ZAHR01	Martin Zahradník (m), Czech Republic
81	2010KOHL02	Erwan Kohler (m), Switzerland
80	2009KIMA01	Anatoly Kim (m), Belarus
79	2008HANK01	Kanneti Sae Han (คันธ์เนตี แซ่ห่าน) (m), France
78	2006GARR01	Lucas Garron (m), Germany
77	2008SEAR01	Anthony Brooks (m), USA
76	2008NUNE01	Gabriel Eduardo Núñez Serna (m), Argentina
75	2007HUBE01	Stefan Huber (m), Austria
74	2009BAUM01	Conor Baumann (m), Ireland
74	2009XIAN01	Teo Kai Xiang (m), Singapore
73	2009KRUU01	Uku Kruusamägi (m), Estonia
72	2003HARR01	Dan Harris (m), United Kingdom
72	2009CONT01	Giovanni Contardi (m), Italy
72	2010GREG01	Jure Gregorc (m), Slovenia
71	2009YAUR01	Robert Yau (m), United Kingdom

Own note "poor" Feliks only have 6 NRs, but 196 OcR+WR.

 

[Stefan]

£1.00. But actually can I take back that bet? Something tells me I'm wrong

Spoiler: Female Podiums

Using data from WCA_export451_20140827 and Stefan's WCA statistics tool.

[TABLE="class:grid,align:left"]
[TR][TD]Competition[/TD][TD]Event[/TD][TD]The Ladies[/TD][/TR]
[TR][TD]Swedish Open 2006[/TD][TD]3x3 multi blind old[/TD][TD]Mimmi Leckius[/TD][/TR]
[TR][TD]Utah Fall 2009[/TD][TD]4x4 blindfolded[/TD][TD]Shelley Chang[/TD][/TR]
[TR][TD]Berkeley Spring 2012[/TD][TD]4x4 blindfolded[/TD][TD]Shelley Chang[/TD][/TR]
[TR][TD]Dual Games 2013[/TD][TD]3x3 with feet[/TD][TD]Cristina Orenes Conesa[/TD][/TR]
[TR][TD]Viking Summer 2014[/TD][TD]4x4 blindfolded[/TD][TD]Mimmi Leckius[/TD][/TR]
[TR][TD]Ural Open 2014[/TD][TD]4x4 blindfolded[/TD][TD]Liliya Kamaltdinova, Yulia Kamaltdinova[/TD][/TR]
[/TABLE]

Spoiler: SQL code

SELECT Competitions.cellName Competition, Events.cellName Event, group_concat(Persons.name order by pos separator ', ') 'The Ladies'
FROM Results join Persons on Persons.id = personId join Competitions on Competitions.id = competitionId join Events on Events.id = eventId
WHERE roundId in ('f', 'c') and pos <= 3 and best > 0
GROUP BY competitionId, eventId
HAVING group_concat(distinct gender) = 'f'
ORDER BY year, month, day

 

[Stefan]

Consistently around 2/3 are DNFs, but at least we've also consistently been getting faster.

Spoiler: BLD statistics per year

Using data from WCA_export451_20140827 and Stefan's WCA forum statistics tool.

[TABLE="class:grid,align:left"]
[TR][TD]Year[/TD][TD]Attempts[/TD][TD]DNFs[/TD][TD]Average[/TD][TD]Best[/TD][TD]Worst[/TD][/TR]
[TR][TD="align:right"]2003[/TD][TD="align:right"]3[/TD][TD="align:right"]33.33%[/TD][TD="align:right"]315.50[/TD][TD="align:right"]236.00[/TD][TD="align:right"]395.00[/TD][/TR]
[TR][TD="align:right"]2004[/TD][TD="align:right"]58[/TD][TD="align:right"]68.97%[/TD][TD="align:right"]536.35[/TD][TD="align:right"]190.54[/TD][TD="align:right"]2100.00[/TD][/TR]
[TR][TD="align:right"]2005[/TD][TD="align:right"]245[/TD][TD="align:right"]61.22%[/TD][TD="align:right"]363.52[/TD][TD="align:right"]106.47[/TD][TD="align:right"]1198.00[/TD][/TR]
[TR][TD="align:right"]2006[/TD][TD="align:right"]651[/TD][TD="align:right"]64.52%[/TD][TD="align:right"]296.08[/TD][TD="align:right"]88.82[/TD][TD="align:right"]1114.00[/TD][/TR]
[TR][TD="align:right"]2007[/TD][TD="align:right"]1372[/TD][TD="align:right"]68.37%[/TD][TD="align:right"]255.47[/TD][TD="align:right"]70.27[/TD][TD="align:right"]904.00[/TD][/TR]
[TR][TD="align:right"]2008[/TD][TD="align:right"]3547[/TD][TD="align:right"]69.19%[/TD][TD="align:right"]224.14[/TD][TD="align:right"]48.05[/TD][TD="align:right"]914.00[/TD][/TR]
[TR][TD="align:right"]2009[/TD][TD="align:right"]5008[/TD][TD="align:right"]70.35%[/TD][TD="align:right"]217.23[/TD][TD="align:right"]35.96[/TD][TD="align:right"]921.00[/TD][/TR]
[TR][TD="align:right"]2010[/TD][TD="align:right"]7130[/TD][TD="align:right"]70.21%[/TD][TD="align:right"]207.83[/TD][TD="align:right"]30.90[/TD][TD="align:right"]1204.00[/TD][/TR]
[TR][TD="align:right"]2011[/TD][TD="align:right"]9125[/TD][TD="align:right"]68.68%[/TD][TD="align:right"]197.37[/TD][TD="align:right"]30.58[/TD][TD="align:right"]967.00[/TD][/TR]
[TR][TD="align:right"]2012[/TD][TD="align:right"]9677[/TD][TD="align:right"]67.29%[/TD][TD="align:right"]195.57[/TD][TD="align:right"]26.36[/TD][TD="align:right"]1538.00[/TD][/TR]
[TR][TD="align:right"]2013[/TD][TD="align:right"]12668[/TD][TD="align:right"]65.80%[/TD][TD="align:right"]177.00[/TD][TD="align:right"]23.80[/TD][TD="align:right"]1589.00[/TD][/TR]
[TR][TD="align:right"]2014[/TD][TD="align:right"]10441[/TD][TD="align:right"]65.21%[/TD][TD="align:right"]168.59[/TD][TD="align:right"]23.19[/TD][TD="align:right"]1141.00[/TD][/TR]
[/TABLE]

Spoiler: SQL code

SELECT
year Year,
solves+DNFs Attempts,
concat(round(100*DNFs/(solves+DNFs), 2), '%') DNFs,
round(total/solves/100, 2) Average,
round(best/100, 2) Best,
round(worst/100, 2) Worst
FROM
(SELECT
year,
sum((value1>0)+(value2>0)+(value3>0)+(value4>0)+(value5>0)) solves,
sum((value1=-1)+(value2=-1)+(value3=-1)+(value4=-1)+(value5=-1)) DNFs,
sum(if(value1>0,value1,0)+if(value2>0,value2,0)+if(value3>0,value3,0)+if(value4>0,value4,0)+if(value5>0,value5,0)) total,
min(least(if(value1>0,value1,999999),if(value2>0,value2,999999),if(value3>0,value3,999999),if(value4>0,value4,999999),if(value5>0,value5,999999))) best,
max(greatest(value1,value2,value3,value4,value5)) worst
FROM Results JOIN Competitions ON Competitions.id = competitionId
WHERE eventId = '333bf'
GROUP BY year) tmp
ORDER BY year;

 

[Tim Reynolds]

Most consecutive competitions, starting with your first competition, with at least 1 personal best:

Spoiler

Mats Valk 47
Sébastien Auroux 42
Tim Reynolds 41
Milan Baticz 39
Bence Barat 39
Jan Bentlage 38
Wojciech Szatanowski 38
Mike Hughey 38
Gael Dusser 38
Thompson Clarke 37 (ongoing)
Geert Bicler 37
Evan Liu 36 (ongoing)
Kevin Costello III 36 (ongoing)
Daniel Sheppard 36
Christopher Olson 35 (ongoing)
Michael Röhrer 34
Kit Clement 34 (ongoing)

 

[CHJ]

at my last comp i had a result in all 33 possible categories, is there anyone else who has done this?

 

[That70sShowDude]

Most consecutive competitions, starting with your first competition, with at least 1 personal best:

Spoiler

Mats Valk 47
Sébastien Auroux 42
Tim Reynolds 41
Milan Baticz 39
Bence Barat 39
Jan Bentlage 38
Wojciech Szatanowski 38
Mike Hughey 38
Gael Dusser 38
Thompson Clarke 37 (ongoing)
Geert Bicler 37
Evan Liu 36 (ongoing)
Kevin Costello III 36 (ongoing)
Daniel Sheppard 36
Christopher Olson 35 (ongoing)
Michael Röhrer 34
Kit Clement 34 (ongoing)

Argh, missed the list by 1 with my streak ending at Worlds, a comp with every event. No practice ftw.

 

[Sebastien]

Most consecutive competitions, starting with your first competition, with at least 1 personal best:

Spoiler

Mats Valk 47
Sébastien Auroux 42
Tim Reynolds 41
Milan Baticz 39
Bence Barat 39
Jan Bentlage 38
Wojciech Szatanowski 38
Mike Hughey 38
Gael Dusser 38
Thompson Clarke 37 (ongoing)
Geert Bicler 37
Evan Liu 36 (ongoing)
Kevin Costello III 36 (ongoing)
Daniel Sheppard 36
Christopher Olson 35 (ongoing)
Michael Röhrer 34
Kit Clement 34 (ongoing)

wait....WHAT?! I have never searched for such a streak myself but I have always been under the impression that I only set competition PBs quite rarely. If you had asked me about the longest streak for me, I would have estimated something like 5.

Could you share the code you used to generate that list? And could you possibly include first and last competition of thoses streaks?

 

[SolveThatCube]

Has anyone gotten a success on there 1st EVER 3BLD attempt?

 

[Sebastien]

well, yes, me for example.

 

[kinch2002]

Has anyone gotten a success on there 1st 3BLD attempt?

This is probably quite common. People often do a super safe solve on their first official attempt. Myself included
I'd be interested to see what the success rate on first attempt is like though, compared to overall success rate (Stefan already did this a few posts back).
4bld and 5bld too

 

[SolveThatCube]

This is probably quite common. People often do a super safe solve on their first official attempt. Myself included
I'd be interested to see what the success rate on first attempt is like though, compared to overall success rate (Stefan already did this a few posts back).
4bld and 5bld too

I meant their first EVER attempt.

 

[kinch2002]

I meant their first EVER attempt.

OK, well I think my first line still applies to that (minus official)

 

[Sebastien]

I meant their first EVER attempt.

That's a quite weird request then because this thread rather deals with statistics that can be made out of official results. However, again, me for example (time was around 30 minutes).

 

[SolveThatCube]

That's a quite weird request then because this thread rather deals with statistics that can be made out of official results. However, again, me for example (time was around 30 minutes).

I did not know that.

 

[Tim Major]

I did not know that.

Well how can you form statistics from data that doesn't exist? A lot of people have probably had success on their first solve. I'm pretty sure I did, can't remember as it was 4-5 years ago, but I'm sure it isn't uncommon to get a success on first attempt

 

[kinch2002]

I did not know that.

The title of the thread gives it away - 'WCA'
Yeah, this thread is only for statistics run off the WCA database.
Maybe Random Blindfold Cubing Discussion thread would be a better place for your question.

 

[guysensei1]

Most improvement from one comp to the next one?
Also: highest ratio for % improvement to number of days between consecutive comps?

 

[Tim Reynolds]

wait....WHAT?! I have never searched for such a streak myself but I have always been under the impression that I only set competition PBs quite rarely. If you had asked me about the longest streak for me, I would have estimated something like 5.

Could you share the code you used to generate that list? And could you possibly include first and last competition of thoses streaks?

One note about this stat is that it includes the first time you compete in an event. You got personal bests at your first 42 competitions. An example from each one:

Spoiler

GermanOpen2008 222 single 986
DutchMasters2008 222 single 552
DutchOpen2008 222 single 440
Germany2008 333 single 2141
GenevaOpen2008 333bf single 14547
Netherlands2008 333 single 2090
TheHagueOpen2008 333 single 2066
AachenOpen2009 333 single 2006
BeneluxOpen2009 333 single 1872
FrenchOpen2009 222 average 684
GermanOpen2009 333 single 1788
WC2009 333 single 1693
DutchOpen2009 333 single 1397
Germany2009 222 single 436
AachenOpen2010 333bf single 13333
ToulouseOpen2010 222 average 606
BeneluxOpen2010 333 average 1492
DanishOpen2010 222 single 419
MontpellierOpen2010 222 single 391
BristolSpring2010 333bf single 11822
GermanOpen2010 444bf single 87200
BelgianOpen2010 333bf single 11403
CologneOpen2010 555 average 11443
AlaniaOpen2010 444 average 6285
DusseldorfOpen2010 clock single 981
AustrianOpen2010 333fm single 27
EastGermanOpen2010 222 single 328
LemgoOpen2010 333bf single 11197
Germany2010 333oh average 2577
MunichOpen2010 555 average 11351
DutchOpen2010 333bf single 10333
VCUBESpiel2010 555 average 11192
DutchNationals2010 222 average 543
MPEIOpen2010 555 single 9821
AachenOpen2011 333oh single 1878
Altbier2011 222 single 291
FrenchOpen2011 333 average 1371
NemoAmsterdamOpen2011 444 single 5408
GermanOpen2011 555 average 11002
DanishOpen2011 333bf single 10086
HamburgOpen2011 222 average 451
BelgianOpen2011 magic single 100
AlaniaOpen2011 333oh average 2556
SchleswigHolstein2011 333oh average 2404
CzechOpen2011 333ft single 10205
DusseldorfOpen2011 333bf average 12302
DanishSpecial2011 333ft single 9430
AmstelveenOpen2011 222 single 272
WC2011 clock average 1135