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
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_medal_tally (
"rank" BIGINT,
"country" VARCHAR,
"country_code" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT,
"rank_by_total" BIGINT
);
CREATE TABLE paralympic_medals (
"country" VARCHAR,
"countrycode" VARCHAR,
"name" VARCHAR,
"sport" VARCHAR,
"sport_short" VARCHAR,
"event" VARCHAR,
"medal" VARCHAR
);
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.