Name: Standard Chartered Singapore Marathon 2022
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Standard Chartered Singapore Marathon 2022

Pos: Overall position of runner in the race based on gun time
Name: Name of runner
Gun Time: Time elapsed between when the race starts (gun goes off) and when the participant crosses the finish line
Net Time*: Time the person crosses the start line mats and crosses the finish line mat.
Representing: Country the runner is representing
Category (Pos): Runner's age and position within that age category
Gender (Pos): Runner's gender and position within that gender category
Net Pos: Overall position of runner in the race based on net time

*Net time will always be lower or equals to gun time

Tables

Full Marathon All

@kaggle.clement7903_standard_chartered_marathon_2022.full_marathon_all

354.81 kB
7,659 rows
8 columns

CREATE TABLE full_marathon_all (
  "pos" VARCHAR,
  "name" VARCHAR,
  "gun_time" VARCHAR,
  "net_time" VARCHAR,
  "representing" VARCHAR,
  "category_pos" VARCHAR  -- Category (Pos),
  "gender_pos" VARCHAR  -- Gender (Pos),
  "net_pos" DOUBLE
);

Full Marathon All 1st Half Timing

@kaggle.clement7903_standard_chartered_marathon_2022.full_marathon_all_1st_half_timing

268.27 kB
5,563 rows
6 columns

CREATE TABLE full_marathon_all_1st_half_timing (
  "pos" BIGINT,
  "name" VARCHAR,
  "time" VARCHAR,
  "country_representing" VARCHAR,
  "category_pos" VARCHAR  -- Category (Pos),
  "gender_pos" VARCHAR  -- Gender (Pos)
);

Full Marathon All 2nd Half Timing

@kaggle.clement7903_standard_chartered_marathon_2022.full_marathon_all_2nd_half_timing

271.88 kB
5,576 rows
6 columns

CREATE TABLE full_marathon_all_2nd_half_timing (
  "pos" BIGINT,
  "name" VARCHAR,
  "time" VARCHAR,
  "country_representing" VARCHAR,
  "category_pos" VARCHAR  -- Category (Pos),
  "gender_pos" VARCHAR  -- Gender (Pos)
);

Full Marathon Sg Only

@kaggle.clement7903_standard_chartered_marathon_2022.full_marathon_sg_only

161.3 kB
3,374 rows
6 columns

CREATE TABLE full_marathon_sg_only (
  "pos" BIGINT,
  "name" VARCHAR,
  "time" VARCHAR,
  "country_representing" VARCHAR,
  "category_pos" VARCHAR  -- Category (Pos),
  "gender_pos" VARCHAR  -- Gender (Pos)
);

Half Marathon All

@kaggle.clement7903_standard_chartered_marathon_2022.half_marathon_all

473.73 kB
11,611 rows
7 columns

CREATE TABLE half_marathon_all (
  "pos" VARCHAR,
  "name" VARCHAR,
  "gun_time" VARCHAR,
  "net_time" VARCHAR,
  "representing" VARCHAR,
  "category_pos" VARCHAR  -- Category (Pos),
  "gender_pos" VARCHAR  -- Gender (Pos)
);