2020 Tokyo Paralympics
Details about the participating Athletes, Teams, Countries/NPCs, Coaches, Sports
@kaggle.shivagovindasamy_2020_tokyo_paralympics
Details about the participating Athletes, Teams, Countries/NPCs, Coaches, Sports
@kaggle.shivagovindasamy_2020_tokyo_paralympics
==> Compiled Paralympics data over the years : 60 years of Paralympics
This a collection of data from the Tokyo Paralympics Games 2020 held at Tokyo, Japan during 24-Aug-2021 to 5-Sep-2021.
4426 Athletes, 212 Teams from 162 Countries/NPCs participated and competed against each other.
Each dataset file describes:
NPCs-list.csv : National Paralympic Committee's (NPCs) names and their corresponding short codesentries-by-discipline.csv: Different Sporting events at the Paralympics and their participant's gender countsparalympic-athletes.csv : List of participating athletes at the Tokyo Paralympics , their representing country and their sportparalympic-coaches.csv : List of Coaches of the participating teams (Team Sports only)paralympic-medal-tally.csv : Final Medal Tally of the Participating Countries/NPCsparalympic-medals.csv : List of Winning Athlete's/Team's detailsparalympic-teams.csv : List of participating Teams of different sportsThe data was collected from the Official Tokyo Paralympics Website
V2: Updated paralympic-athletes.csv with Athlete's date of birth, Gender and Age.V3: Removed Age column, since it can get obsolete.CREATE TABLE entries_by_discipline (
"discipline" VARCHAR,
"f" BIGINT,
"m" BIGINT,
"total" BIGINT
);CREATE TABLE npcs_list (
"country" VARCHAR,
"countrycode" VARCHAR
);CREATE TABLE paralympic_athletes (
"name" VARCHAR,
"country" VARCHAR,
"countrycode" VARCHAR,
"sport" VARCHAR,
"sport_code" VARCHAR,
"date_of_birth" TIMESTAMP,
"gender" VARCHAR
);CREATE TABLE paralympic_coaches (
"name" VARCHAR,
"country" VARCHAR,
"countrycode" VARCHAR,
"sport" VARCHAR,
"sport_code" VARCHAR,
"event" VARCHAR
);CREATE TABLE paralympic_medals (
"country" VARCHAR,
"countrycode" VARCHAR,
"name" VARCHAR,
"sport" VARCHAR,
"sport_short" VARCHAR,
"event" VARCHAR,
"medal" VARCHAR
);CREATE TABLE paralympic_medal_tally (
"rank" BIGINT,
"country" VARCHAR,
"country_code" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT,
"rank_by_total" BIGINT
);CREATE TABLE paralympic_teams (
"team" VARCHAR,
"country" VARCHAR,
"countrycode" VARCHAR,
"sport" VARCHAR,
"sport_code" VARCHAR,
"event" VARCHAR
);Anyone who has the link will be able to view this.