Name: All Olympic Medals Until 2024 (before Paris Games)
Creator: Kaggle
License: https://www.apache.org/licenses/

About this Dataset

All Olympic Medals Until 2024 (before Paris Games)

A list of all the medals awarded during the Olympic games, from Athens 1896 to Beijing 2022.
The data is in Tidy format, that is, each row is an observation, an an observation is a medal.

This means:

In most cases, there is a Gold, a Silver and a Bronze medal, for the same event, which means 3 distinct lines.
Sometimes more than one medal of the same find is awarded for the same event (usually 2 bronzes or 2 golds).
Some events lack certain medals (for example 2 golds but no silver).

The original data comes from Olympedia but it's been transformed.

The parsing and transformation of the original data is described here: https://www.kaggle.com/code/ericnarro/create-olympic-medals-dataset

IMPORTANT: Version 3 of the dataset fixes duplicate values, so it's important to not use previous versions.

Tables

Olympic Medals

@kaggle.ericnarro_all_olympic_medals_until_2024_before_paris_games.olympic_medals

271.12 kB
20,433 rows
12 columns

CREATE TABLE olympic_medals (
  "olympiad" VARCHAR,
  "discipline" VARCHAR,
  "event" VARCHAR,
  "winner" VARCHAR,
  "medal_type" VARCHAR,
  "olympic_city" VARCHAR,
  "olympic_year" BIGINT,
  "olympic_season" VARCHAR,
  "gender" VARCHAR,
  "code" VARCHAR,
  "committee" VARCHAR,
  "committee_type" VARCHAR
);