Tour De France Winners (1903-2019)

Data on TdF Winners from Wikipedia

@kaggle.asanchez1994_tour_de_france_winners_19032019

Table List

1 table(14.98 KB)

Tdf Winners

@kaggle.asanchez1994_tour_de_france_winners_19032019.tdf_winners

14.98 KB
106 rows
12 columns

year Year	country Country	cyclist Cyclist	sponsor_team Sponsor/team	distance_km Distance Km	overall_time Overall Time	margin Margin	stage_wins Stage Wins	stages_in_lead Stages In Lead	overall_time_sec Overall Time Sec	margin_sec Margin Sec
1903	France	Maurice Garin	La Française	2428	3 days 22:33:14.000000000	0 days 02:59:21.000000000	3	6	340394	10761
1904	France	Maurice Garin Henri Cornet[E]	Conte	2428	4 days 00:05:55.000000000	0 days 02:16:14.000000000	1	3	345955	8174
1905	France	Louis Trousselier	Peugeot–Wolber	2994	nan	nan	5	10
1906	France	René Pottier	Peugeot–Wolber	4637	nan	nan	5	12
1907	France	Lucien Petit-Breton	Peugeot–Wolber	4488	nan	nan	2	5
1908	France	Lucien Petit-Breton	Peugeot–Wolber	4497	nan	nan	5	13
1909	Luxembourg	François Faber	Alcyon–Dunlop	4498	nan	nan	6	13
1910	France	Octave Lapize	Alcyon–Dunlop	4734	nan	nan	4	3
1911	France	Gustave Garrigou	Alcyon–Dunlop	5343	nan	nan	2	13
1912	Belgium	Odile Defraye	Alcyon–Dunlop	5289	nan	nan	3	13


CREATE TABLE tdf_winners (
  "year" BIGINT,
  "country" VARCHAR,
  "cyclist" VARCHAR,
  "sponsor_team" VARCHAR,
  "distance_km" BIGINT,
  "overall_time" VARCHAR,
  "margin" VARCHAR,
  "stage_wins" BIGINT,
  "stages_in_lead" BIGINT,
  "controversial" BOOLEAN,
  "overall_time_sec" DOUBLE,
  "margin_sec" DOUBLE
);