Ironman 140.6 Results Dataset (2002-2024)
Contains all non-WC Ironman Results from 2002 to 2024 (as of 12/12)
@kaggle.miguswong_ironman_140_6_results_dataset_2002_2024
Contains all non-WC Ironman Results from 2002 to 2024 (as of 12/12)
@kaggle.miguswong_ironman_140_6_results_dataset_2002_2024
This data set contains 3 csv files that were scraped from https://www.coachcox.co.uk/imstats/ and contain Results from 140.6 Ironmans from 2002 to 2024. The dataset does not include world championship data (typically held in Kona, HI, USA).
CREATE TABLE races (
"year" BIGINT,
"link" VARCHAR,
"totalkonaslots" BIGINT,
"malekonaslots" DOUBLE,
"femalekonaslots" DOUBLE,
"male1st" BIGINT,
"female1st" BIGINT,
"finishers" BIGINT,
"dnf" BIGINT,
"dq" BIGINT,
"id" BIGINT,
"seriesid" BIGINT
);CREATE TABLE results (
"bib" BIGINT,
"name" VARCHAR,
"athletelink" VARCHAR,
"country" VARCHAR,
"gender" VARCHAR,
"division" VARCHAR,
"divlink" VARCHAR,
"divisionrank" DOUBLE,
"overalltime" VARCHAR,
"overallrank" DOUBLE,
"swimtime" VARCHAR,
"swimrank" DOUBLE,
"biketime" VARCHAR,
"bikerank" DOUBLE,
"runtime" VARCHAR,
"runrank" DOUBLE,
"finishstatus" VARCHAR,
"raceid" BIGINT,
"athleteid" DOUBLE
);CREATE TABLE series (
"id" BIGINT,
"location" VARCHAR,
"continent" VARCHAR,
"link" VARCHAR
);Anyone who has the link will be able to view this.