2021 Paralympic Games In Tokyo
Data on Medals, Athletes, Coaches, Disciplines, and Medalists
@kaggle.alexkoshchii_2021_paralympic_games_in_tokyo
Data on Medals, Athletes, Coaches, Disciplines, and Medalists
@kaggle.alexkoshchii_2021_paralympic_games_in_tokyo
The 2020 (2021) Summer Paralympics are the 16th Summer Paralympic Games and took place in Tokyo, Japan between 24 August and 5 September 2021.
Now that the Tokyo 2020 Paralympic Games are over it is time to analyze their results! This freshly scraped dataset contains details of over 4400 athletes (and their coaches) participating in 23 different disciplines. It also includes medal count information of athletes who won medals.
Data source: Tokyo 2020 Paralympic Games website
Cover image: Photo by Erik Zünder on Unsplash
CREATE TABLE athletes (
"name" VARCHAR,
"npc" VARCHAR,
"discipline" VARCHAR,
"npccode" VARCHAR
);
CREATE TABLE coaches (
"name" VARCHAR,
"npc" VARCHAR,
"discipline" VARCHAR,
"gender" VARCHAR
);
CREATE TABLE genderbydiscipline (
"discipline" VARCHAR,
"f" BIGINT,
"m" BIGINT,
"total" BIGINT
);
CREATE TABLE medallists (
"rank" BIGINT,
"name" VARCHAR,
"team_npc" VARCHAR,
"sport" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT,
"rank_by_total" BIGINT
);
CREATE TABLE medals (
"rank" BIGINT,
"team_npc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT,
"rank_by_total" BIGINT
);
CREATE TABLE multimedallists (
"rank" BIGINT,
"name" VARCHAR,
"team" VARCHAR,
"sport" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);
Anyone who has the link will be able to view this.