Tour De France Winning Ways
What does it take to become a Tour victor ...
@kaggle.gulliverwoods_tour_de_france_winner_data
What does it take to become a Tour victor ...
@kaggle.gulliverwoods_tour_de_france_winner_data
A collection of personal information about the year on year winner of the Tour de France from 1903 to the most recent tour. Basic information is also included on each Tour. Information is collated from www.procyclingstats.com and personal Wikipedia entries about the rider.
CREATE TABLE tour_winners_data_1 (
"year" BIGINT,
"tour_no" BIGINT,
"winner" VARCHAR,
"country" VARCHAR,
"team" VARCHAR,
"tour_overall_length_km" BIGINT -- Tour Overall Length (km),
"age" BIGINT,
"bmi" DOUBLE,
"weight_kg" DOUBLE -- Weight (Kg),
"height_m" DOUBLE -- Height (m),
"rider_type_pps" VARCHAR -- Rider Type (PPS),
"close_rider_type_pps" VARCHAR -- Close Rider Type (PPS)
);CREATE TABLE tour_winners_data_2 (
"year" BIGINT,
"tour_no" BIGINT,
"winner" VARCHAR,
"pre_tour_gc_wins" BIGINT,
"pre_tour_wins" BIGINT,
"total_completed_stage_races" BIGINT,
"total_completed_day_races" BIGINT
);CREATE TABLE tour_winners_data_3 (
"year" BIGINT,
"tour_no" BIGINT,
"winner" VARCHAR,
"gt_wins" BIGINT,
"nat_tt_wins" BIGINT,
"nat_rr_wins" BIGINT,
"worlds_rr_wins" BIGINT
);Anyone who has the link will be able to view this.