Grand Tour Stages – Update

“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.

bnames

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.

b2

And here’s a bit more detail on the winningest riders.

b4

Collated stats on the riders with the most wins, the number of winning nations, teams, and riders at each grand tour.

stats

Kept track of which riders have won stages of multiple grand Tours in the same year

More thank you might think…

rec

records

Listed all the winners’ ages at the time they won each individual stage

agesready

This helps produce some interesting graphs and charts, with the charts as below…

ageschart

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.

swpn

Plotted the number of wins per nation at the Grand Tours

Again, it helps to be Italian here.

gtwpbn

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.

Bikes

It has produced some (work in progress) graphs though of the most successful bicycles though, which seem quite good.

allgbtb

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…

searchmerckx

And Mr Cavendish…

cavendishsearch

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.

 

 

Advertisements

4 thoughts on “Grand Tour Stages – Update

  1. Hi Simon,

    My anorak mate thinks Kas rode Colnago’s in the ’70’s – but is going to do some further investigating. I’ll let you know if he finds anything definitive.

  2. Here you go – from a Cycling News 50th Anniversary interview with Ernesto Colnago:

    http://www.cyclingnews.com/features/tales-from-the-classic-peloton-january-8-2004-5/

    CN: You also made the bikes for the KAS team from Spain in those days, so you must have known Jose-Manuel Fuente…

    EC: Chicco, that’s what we called him… plus there were Galdos and Lasa on that team who were good riders.

    CN: How would you compare Chicco Fuente with the climbers of today?

    EC: Oh I’d say that Chicco was a rider who was kind of shortsighted. He couldn’t ride by a program but had to follow his impulses. His efforts wouldn’t go for two hours; he’d just give it all… boom! I remember in the 1974 Giro that Merckx won by 12″ over Baronchelli and Gimondi, there was one stage where Fuente took off from the start and attacked everybody on the first climb over Monte Grappa. But before the start, he was smoking a cigarette! You just don’t do that… he was an exuberant guy, but in cycling sometimes that’s not so great. Galdos was a very nice guy; I met him years later in Spain where he had opened a pizzeria.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s