Graphing the Tour De France

🔖 Cycling  Code 

Two things are going on right now:

  1. The Tour De France.

  2. I need to learn a new charting library.

I started looking around and Highcharts seemed like a nice JS solution with a complete API. It does require a license for commercial use, though.

At the same time, I found a bunch of cool historical data on the Tour De France. I set up a MySQL database, made a few PHP pages, and here we have the results.

The most interesting metric is the average speed of the winner over the years. It is amazing to see the acceleration, though there appears to be an plateau or possible even a decline in the last few years. Doping possibly?

What ages are winning the tour?

And the obligatory wins by country:

Now, back to watching the races.