Name: Olympics 124 Years Dataset(till 2020)
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Olympics 124 Years Dataset(till 2020)

The modern Olympic Games have been held every four years since 1896, so there have been a total of 27 summer Olympics and 22 winter Olympics as of my training data cutoff in 2021. I used two different datasets for this project, and I performed multiple functions to create a valuable dataset from the two. The first dataset was completely different from the other, so I used Pandas to perform different tasks and create a compatible dataset for this project.

Tables

Athletes Summer Games

@kaggle.nitishsharma01_olympics_124_years_datasettill_2020.athletes_summer_games

5.18 MB
237,673 rows
13 columns

CREATE TABLE athletes_summer_games (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "name" VARCHAR,
  "sex" VARCHAR,
  "age" DOUBLE,
  "team" VARCHAR,
  "noc" VARCHAR,
  "games" VARCHAR,
  "year" BIGINT,
  "season" VARCHAR,
  "city" VARCHAR,
  "sport" VARCHAR,
  "event" VARCHAR,
  "medal" VARCHAR
);

Athletes Winter Games

@kaggle.nitishsharma01_olympics_124_years_datasettill_2020.athletes_winter_games

947.22 kB
48,564 rows
13 columns

CREATE TABLE athletes_winter_games (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "name" VARCHAR,
  "sex" VARCHAR,
  "age" DOUBLE,
  "team" VARCHAR,
  "noc" VARCHAR,
  "games" VARCHAR,
  "year" BIGINT,
  "season" VARCHAR,
  "city" VARCHAR,
  "sport" VARCHAR,
  "event" VARCHAR,
  "medal" VARCHAR
);

Regions

@kaggle.nitishsharma01_olympics_124_years_datasettill_2020.regions

8.46 kB
234 rows
4 columns

CREATE TABLE regions (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "noc" VARCHAR,
  "region" VARCHAR,
  "notes" VARCHAR
);