make.opendata.ch wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
===== Tour de France history =====

We are trying to analyse historical data of Tour the France. We started checking online resources and extracting data from them. Unfortunately data are not easy to extract, official website of the Tour offers just very general data like distance of the whole tour + 
results, more interesting data like stages profiles, lengths etc. are missing.

Ideas we have:

  * very interesting would be to put together gps data from Tour and map all these races. There are a lot of services where people put there bike tracks (like bikemap.net, strava, mapmyride etc), for sure there are also stages of at least latest Tours. Plus we could probably get this from official website...
  * put the race data together with drugs or technique enhancements
  * various statistics like nationalities, teams tactics (one leader/domestics/leaders + spurters/climbers etc) etc.
  * how has Tour developed? how has the elevation/distance/distance per stage/number of stages changed? how have the sizes of teams changed?
  * another interesting challenge would be to get data of individual riders and see how they perform during the race (eg. trainingpeaks has some riders data including heart rate, watts, speed during the race etc.)

Besides these sports related ideas it would be interesting to correlate external historical events (such as advancements in technology or drug abuse in sports) with the trends discovered in the historical Tour de France data. For a further discussion of these topics we compiled a dataset through scraping //letour.fr// and //bikeraceinfo.com// that brings together the average overall performance of the Tour de France over years with the performance of the winning athlete.

{{url>http://docs.google.com/a/dergraf.org/spreadsheets/d/10tWLI0jpPBspbrBun_CEWtTdx-7LwiHN9yYBSdMpHc4/gviz/chartiframe?oid=122673592 371 773 noscroll noborder}}
Unfortunately the data between 1904 and 1914 is incomplete, that mainly comes from the different performance measuring system applied during the tour (points vs. time). For the years 1915-1918 and 1940-1946 no data exists due to the 1st and 2nd world wars.

The Winner data also **includes** athletes that were later disqualified due to e.g. doping.

===== Data =====

[[http://www.letour.fr/HISTO/us/TDF/|letour.fr]] > should be scraped and parsed

[[http://bikeraceinfo.com/tdf/tdfindex.html|bikeraceinfo.com]] > used for stages extraction (difficult)

[[https://cat6.trainingpeaks.com/races/tour-de-france.aspx|trainingpeaks.com]] > one rider's performance

[[http://www.sport-histoire.fr/Sport/Cyclisme/Tour_de_France/Editions/1986.php|sport-histoire.fr]]

[[http://ledicodutour.perso.sfr.fr/etapes/classements_etapes/classement_etapes_1987_1996/classement_etapes_1994.htm|ledicodutour.perso.sfr.fr]]

[[https://docs.google.com/spreadsheets/d/10tWLI0jpPBspbrBun_CEWtTdx-7LwiHN9yYBSdMpHc4/edit?usp=sharing|Own compiled dataset]]

===== Team =====

  * [[user:jajina]]
  * [[user:dergraf]]
  * and others

===== Links =====

  
{{tag>status:concept needs:dev needs:design needs:data needs:expert sport}}