How fast are the over 40's in competitions?

[Mike Hughey]

Unfortunately that's not straightforward due to them being removed from the WCA rankings.

So they are left out of the database dump? (I'm not in a convenient place to check myself right now.) The fact that they are still displayed on individual pages on the WCA website implies they are actually in the database. If they are not in the export, they must be putting in special effort to leave them out. (Although maybe they did it by moving the data to another table, so maybe they just don't export that table.)

 

[Logiqx]

So they are left out of the database dump? (I'm not in a convenient place to check myself right now.) The fact that they are still displayed on individual pages on the WCA website implies they are actually in the database. If they are not in the export, they must be putting in special effort to leave them out. (Although maybe they did it by moving the data to another table, so maybe they just don't export that table.)

All of the retired events (magic, mmagic, 333mbo and 333ft) have been removed from RanksSingle, RanksAverage, ConciseAverageResults and ConciseSingleResults in the WCA database. The individual times still exist in the Results table (which is what I actually use to identify seniors results) but the statistical extracts that I use to identify the gaps (unknown seniors) use the aforementioned tables to avoid excess load on the WCA server.

I could display the retired events without any kind of accurate rankings (i.e. unknown seniors would not be factored into the ranks due to the missing stats) but that'd put the retired events at odds with everything else in the senior rankings which now have accurate WR, CR and NR rankings.

Aside from the technical issues and inconsistencies described above, I'm not keen on the thought of providing rankings that have been dropped by the WCA, Cubing China and WCADB. I was slightly saddened to see feet disappear from the senior rankings but I built the site to automatically reflect the same list of events as the WCA website. Feet automatically disappeared the day the WCA dropped it from their site and nobody has a chance to beat any of the times now.

 

[Logiqx]

I've added a registration page to the rankings.

Now you can get people to sign up on the spot whilst chatting at comps!

It is accessible via the FAQ - https://logiqx.github.io/wca-ipy-www/Registration.html

 

[Logiqx]

Apologies for the bump but I think it's worth it for people who are unaware.

A quick announcement for all over 40s who have competed in a WCA competition. I maintain this website listing senior rankings, upcoming competitions, etc. If you aren't listed then please consider registering.

Senior Rankings

Senior Rankings

logiqx.github.io

Registration is via https://logiqx.github.io/wca-ipy-www/Registration.html

 

[Jimjoachim]

Apologies for the bump but I think it's worth it for people who are unaware.

A quick announcement for all over 40s who have competed in a WCA competition. I maintain this website listing senior rankings, upcoming competitions, etc. If you aren't listed then please consider registering.

Senior Rankings

Senior Rankings

logiqx.github.io

Registration is via https://logiqx.github.io/wca-ipy-www/Registration.html

Hi, just wanted to check if you got my request ok? I know it can take a few weeks to update.

I’m a cubing dad who has recently decided to give it a go instead of just watching the comps and now I’m hooked :


My ID is “2023MAGE02”

thanks, J