Stage finishes – mapping the locations and results of Tour de France (1903–2016)

Figures & data

Figure 1. Basic structure of database tables in the program MS Access.

Table 1. Example of a question and the corresponding SQL syntax for displaying the answer.

Example question	SQL syntax
How many stage finish places were included in the itinerary of the Tour de France before World War II?	Select *,COUNT(finish) AS count_places from tdf_stage_winners,tdf_places WHERE tdf_stage_winners.id_finish = tdf_places.id_place AND year ≤ 1939 GROUP BY id_finish ORDER BY ‘count_places’ DESC’);
How many cyclists won in individual stages in all editions of the Tour de France?	Select winner,nationality,COUNT(winner) AS countw from tdf_stage_winners WHERE winner != “AND year ≥ 1903 AND rok ≤ 2016 GROUP BY winner ORDER BY ‘countw’ DESC’);
What are the most successful nations as regards the number of triumphs in stages?	Select nationality,COUNT(*) AS countn from tdf_stage_winners WHERE year ≥ 1903 AND year ≤ 2016 GROUP BY nationality ORDER BY ‘countn’ DESC’);
Which nations triumphed more than 1 time in Paris?	Select nationality,COUNT(*) AS countn from tdf_stage_winners WHERE id_finish = 434 GROUP BY nationality HAVING countn > 1 ORDER BY ‘countn’ DESC

Figure 2. Representation of finish places of the Tour de France in selected periods.

Figure 3. Visits to individual regions of France during the long history of the Tour de France (1903–2016).