“Simon,” people never say to me, “when will we next be getting a post from Sicycle? It’s my favourite thing in the world! What’s coming next? Have you run out of ideas?!”
Well, imaginary person, fear not – I’ve certainly not run out of ideas. The main reason for the lack of posts is simply that (boo) I have a job now, and when I’m not doing that, I’m revving a turbo to try to get into some semblance of the shape I was in previous to a three week jaunt to New Zealand and Australia, which left me with the cardiac fitness of a dead Walrus.
Still, I have been up to something fairly big since September 2015 (!), and so here’s a quick update onto what it actually is.
Essentially, I became fed up with searching the net for information of grand tour stage winners, so I decided to make my own, searchable database of all the grand tour stage winners, complete with their nationalities, ages, teams, bikes and the like.
I mean, how hard can it be?
Er, turns out pretty much. As of now, I have completed several aspects, but am left on the tricky parts. I have…
Got the names of every stage winner of every grand tour stage ever listed
The red boxes are cancelled/annulled stages, black are TTTs and light blue represents a rider winning stages in a row.
Listed riders with a breakdown of the number of stages they’ve won in each grand tour, with a yearly breakdown, as well as a combination statistic.
Obviously the colours are an aid here.
And here’s a bit more detail on the winningest riders.
Collated stats on the riders with the most wins, the number of winning nations, teams, and riders at each grand tour.
Kept track of which riders have won stages of multiple grand Tours in the same year
More thank you might think…
Listed all the winners’ ages at the time they won each individual stage
This helps produce some interesting graphs and charts, with the charts as below…
Plotted the number of winning riders from each nation over time
Something more useful (and finished) – a graph which basically shows it pays to be Italian if you want to win a grand tour stage.
Plotted the number of wins per nation at the Grand Tours
Again, it helps to be Italian here.
Began a painstaking process of team and bicycle research
So finding out which team everyone was in, and what bicycles they rode, is the killer. I’m currently a mere 57% through this step, which will be the death of me, and the sheer number of teams and bicycle makes is simply ridiculous.
It has produced some (work in progress) graphs though of the most successful bicycles though, which seem quite good.
And finally, theres a fun search function that allows you to look up individual riders, as well as the winners in each Grand Tour in a more presentable format, with the name of the person you’re currently searching for highlighted.
Here’s Mr Merckx…
And Mr Cavendish…
So there you go, thats what I’ve been doing. Please be impressed. It’s taken a lot of time, and will no doubt continue to be. Oh, and if anyone knows what bikes KAS used in the 70s (and don’t say “Kas” ones) FOR THE LOVE OF ALL THAT IS HOLY let me know.