Sunday, March 2, 2014

So I didn't take part in the Paris Half Marathon 2014 which happened today. But since I love timing data and I had some relevant code lying around, I couldn't help generate a time distribution based on the race official results page.

So below is the corresponding chart:

For each interval of size one minute, it shows the number of runners that completed the race in that time interval. As expected, it looks a bit like a bell curve :). Maximum density is around 1h55 minutes with about 750 runners per minute.

Unfortunately, the 2014 results don't put the runner category and gender directly on the listing, so I didn't generate a gender breakdown. For reference, below is the time distribution for the 2013 edition with gender breakdown.

These charts were generated with google spreadsheet -- data was fetched by tweaking some code I put on github some time ago for another race.

In any case, it was interesting to see how to publish charts with google spreadsheet. Next time I'll probably try other chart libraries like chartjs