Dataset: 2021 Paralympic Games In Tokyo

About this Dataset

2021 Paralympic Games In Tokyo

Context

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.

Acknowledgements

Data source: Tokyo 2020 Paralympic Games website
Cover image: Photo by Erik Zünder on Unsplash

Tables

Athletes

@kaggle.alexkoshchii_2021_paralympic_games_in_tokyo.athletes

86.68 KB
4527 rows
4 columns


CREATE TABLE athletes (
  "name" VARCHAR,
  "npc" VARCHAR,
  "discipline" VARCHAR,
  "npccode" VARCHAR
);

Coaches

@kaggle.alexkoshchii_2021_paralympic_games_in_tokyo.coaches

5.33 KB
91 rows
4 columns


CREATE TABLE coaches (
  "name" VARCHAR,
  "npc" VARCHAR,
  "discipline" VARCHAR,
  "gender" VARCHAR
);

Genderbydiscipline

@kaggle.alexkoshchii_2021_paralympic_games_in_tokyo.genderbydiscipline

3.91 KB
23 rows
4 columns


CREATE TABLE genderbydiscipline (
  "discipline" VARCHAR,
  "f" BIGINT,
  "m" BIGINT,
  "total" BIGINT
);

Medallists

@kaggle.alexkoshchii_2021_paralympic_games_in_tokyo.medallists

51.55 KB
1587 rows
9 columns


CREATE TABLE medallists (
  "rank" BIGINT,
  "name" VARCHAR,
  "team_npc" VARCHAR,
  "sport" VARCHAR,
  "gold" BIGINT,
  "silver" BIGINT,
  "bronze" BIGINT,
  "total" BIGINT,
  "rank_by_total" BIGINT
);

Medals

@kaggle.alexkoshchii_2021_paralympic_games_in_tokyo.medals

7.38 KB
86 rows
7 columns


CREATE TABLE medals (
  "rank" BIGINT,
  "team_npc" VARCHAR,
  "gold" BIGINT,
  "silver" BIGINT,
  "bronze" BIGINT,
  "total" BIGINT,
  "rank_by_total" BIGINT
);

Multimedallists

@kaggle.alexkoshchii_2021_paralympic_games_in_tokyo.multimedallists

13.43 KB
381 rows
8 columns


CREATE TABLE multimedallists (
  "rank" BIGINT,
  "name" VARCHAR,
  "team" VARCHAR,
  "sport" VARCHAR,
  "gold" BIGINT,
  "silver" BIGINT,
  "bronze" BIGINT,
  "total" BIGINT
);