Winter Olympics (1924 - 2018) by Kaggle | Sports

About this Dataset

Winter Olympics (1924 - 2018)

Context

As Winter Olympic 2022 is approaching, I aim to better understand the different disciplines and sports that are competed at the event, so that I can better appreciate the event overall. Thus, I have scraped the following data

Content

There are 3 CSV. The first one olympic_events.csv, include the information about the different Olympic events on a high level, with information such as name of the event, where and when it took place, number of overall participants, etc.
events_medals.csv dive deeper into which are the countries that have won a medal, how many have they won, etc.
The last one, discipline_details.csv, dive deeper into all the sport competed at each individual event

Acknowledgements

This data has been collected through https://olympedia.org/

Inspiration

Which countries have improved the most in recent year?
Does the location of the event, whether it is in Asia, Europe, etc. affect individual countries performance?

Tables

Discipline Details

@kaggle.leminhnguyen_winter_olympics_1924_2018.discipline_details

55.55 KB
1050 rows
13 columns


CREATE TABLE discipline_details (
  "event_number" VARCHAR,
  "event_year" BIGINT,
  "discipline" VARCHAR,
  "category" VARCHAR,
  "date" VARCHAR,
  "n_participants" BIGINT,
  "n_country_participants" BIGINT,
  "gold_medalist" VARCHAR,
  "gold_country" VARCHAR,
  "silver_medalist" VARCHAR,
  "silver_country" VARCHAR,
  "bronze_medalist" VARCHAR,
  "bronze_country" VARCHAR
);

Events Medals

@kaggle.leminhnguyen_winter_olympics_1924_2018.events_medals

7.6 KB
410 rows
7 columns


CREATE TABLE events_medals (
  "event_number" VARCHAR,
  "event_year" BIGINT,
  "country" VARCHAR,
  "gold" BIGINT,
  "silver" BIGINT,
  "bronze" BIGINT,
  "total" BIGINT
);

Olympic Events

@kaggle.leminhnguyen_winter_olympics_1924_2018.olympic_events

8.58 KB
23 rows
10 columns


CREATE TABLE olympic_events (
  "event_city" VARCHAR,
  "event_country" VARCHAR,
  "event_number" VARCHAR,
  "event_year" BIGINT,
  "opening_ceremony" VARCHAR,
  "closing_ceremony" VARCHAR,
  "n_participants" BIGINT,
  "n_countries" VARCHAR,
  "n_medals" BIGINT,
  "n_disciplines" BIGINT
);