Here you can find a running list of my endeavors in World Cube Association (WCA) statistics. My goal is to backfill as many of my previous statistics as possible. Most of these queries are for the Facebook group WCA Statistics. Most data is from either the WCA TSV Results export or SQL Developer Export.
Requested by Manu Singhal
This heatmap shows the number of people for which their first competition was in [row] year and their latest competition was in [column] year. Unfortunately the results are uninteresting due to how many people stop competing their first year. Perhaps this is a query I'll come back to in search of a better visualization.
This is part of a larger project related to the competition frequency heatmaps I posted a few months ago. My end goal with those is to exclude competitions that happened on the same day. No surprises here though; US, Poland, Sweden, and Colombia are the kings of spamming competitions this year.
