WCA Statistics Website

[Kian]

Thanks. That revealed an interesting result: Congratulations to Kian Berry, who appears to have the most medals (28) without a single gold! Nick Pappas is close behind with 27. (And my daughter Rebecca is probably in the top 10, with 14!)

Yes, I figured I had that wonderful distinction. It's a running joke in the northeast. Thanks to Rowe and Dan for making sure I never win anything.

EDIT: Not sure if this is updated as of last weekend but if not I extended this lead by coming in 3rd at OH behind, guess who, Rowe and Dan.

[Lucas Garron]

I have six 13.36s and four 13.38s, making me the only person in first place for each of those results.

But... no 13.37s.

[Mr.Toad]

Also, my stats are divided by Brooks and Searle. I don't really care all that much, but it would be nice if this was fixed. I also seem to be showing up under the last name Searle instead of Brooks in most of the statistics.

I'll try to figure this out.

I just saw this, to solve it you just need to remove the bit in red from the query:

group by personId, personName

[macky]

I just saw this, to solve it you just need to remove the bit in red from the query:

group by personId, personName

Yes, I should remove that either way, but that shows him as "Anthony Searle" because that's the first name encountered with his WCA id. Either I find a way to have MySQL go through the data from the latest row, or I need to use subid=1 somewhere (maybe subquery, maybe in the php).

[qqwref]

Can you make a page for the bottom of the "best worst result" list? (That is, worst result.)

[Carson]

An interesting thought:

It would be neat to have a list of the average time required to win each event each year that a competition has taken place. I'm not sure if I am explaining this well... the average winning time of each occurrence of a specific event during the course of a year.

[Tim Reynolds]

An interesting thought:

It would be neat to have a list of the average time required to win each event each year that a competition has taken place. I'm not sure if I am explaining this well... the average winning time of each occurrence of a specific event during the course of a year.

	2011		2010		2009		2008		2007		2006		2005		2004
333	11.299		11.900 		13.118		13.224		14.178		15.659		17.934		19.396
444	52.164		54.928		58.553		1:04.550	1:11.277	1:16.532	1:30.212	1:31.624
555	1:36.436	1:36.298	1:41.308	1:54.779	2:09.807	2:28.572	3:02.212	2:54.018
222	3.818		4.147		5.114		5.163		6.288		7.404		8.881		10.870
333bf	1:52.778	1:50.932	1:54.976	1:58.020	2:27.421	3:19.773	5:42.239	10:59.078
333oh	20.304		22.107		24.140		25.470		27.079		32.113		44.459		43.515
333fm	32.7		33.1		34.0		34.1		35.5		31.3		35.0		31.0
333ft	1:30.620	1:24.716	1:35.776	1:37.772	1:18.426	2:56.020
minx	1:26.599	1:29.640	1:40.590	1:51.690	1:50.584	2:06.223
pyram	6.709		7.318		8.422		8.906		10.923		11.911		14.193
sq1	24.774		25.596		25.850		30.769		33.249		43.849		48.855		33.210
clock	12.458		12.540		12.051		14.443		12.748		14.089		14.100		11.767
666	3:07.895	3:15.692	3:30.542
777	4:51.563	4:51.234	5:18.497
magic	1.346		1.371		1.434		1.486		1.554		1.814		2.399		2.000
mmagic	3.476		3.460		4.009		3.600		3.470		3.873		4.003
444bf	9:31.138	12:50.516	14:09.820	13:55.358	25:36.573	10:08.450	n/a		19:14.000
555bf	20:18.784	21:48.800	24:49.000	28:29.500	40:48.000	38:02.667	n/a		2:34:36.000

There might be some mistakes, I converted the times by hand.

[Odder]

http://stats.cubing.net/single_avera..._same_time.php

I might be wrong, but if person A sets NR with time x, and then person B (same nationality as person A) sets a time of x, shouldn't this show up then?

(Henrik did 3.05 pyra single NR, some months later I had a 3.05 pyra single NR too )

[Carson]

What about a ranking of rolling means of 100 during competitions for 3x3x3, not including DNF's and not throwing out best or worst times? This would be based on the persons "current" rolling mean instead of their best rolling mean.


Edit: Also, what about a ranking of those people with the most lines of text on their WCA profile. I'm this could be done using the database without actually polling the site, but I would guess it would be a little more complex.

[Kian]

Clicking on links on this site hasn't worked for me in a few weeks. Just thought it was worth reporting because the site is awesome.