Name: Olympics
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Olympics

About the Dataset

This dataset contain detailed records of the Olympic events and the athlete's who participated in them from year 1896 to 2016. Each row in the dataset represents an individual athlete and includes various attributes related to their personal information, the country they represent, the specifics of the Olympic event they participated in, and the outcomes they achieved. Below is a description of the columns included in the dataset:

Name: The full name of the athlete.
Gender: The gender of the athlete, typically represented as 'M' for male and 'F' for female.
Age: The age of the athlete at the time of their participation in the Olympic Games.
Height: The height of the athlete in centimeters.
Weight: The weight of the athlete in kilograms.
Team: The name of the team or delegation the athlete represents, often corresponding to their country.
Country Code: The three-letter code representing the country the athlete is associated with (e.g., USA for the United States, GBR for Great Britain).
Game: The specific Olympic event or sport in which the athlete competed.
Year: The year in which the athlete participated in the Olympic Games.
Season: The season of the Olympic Games (either Summer or Winter).
City: The host city where the Olympic Games were held.
Sport: The general sport category in which the athlete competed (e.g., Athletics, Swimming, Gymnastics).
Event: The specific event within the sport that the athlete competed in (e.g., 100m Freestyle, Long Jump, Marathon).
Medal: The type of medal won by the athlete, if any (Gold, Silver, Bronze). If the athlete did not win a medal, this field will be empty.

Tables

Athlete Events

@kaggle.harshvgh_olympics.athlete_events

5.94 MB
271,116 rows
15 columns

CREATE TABLE athlete_events (
  "id" BIGINT,
  "name" VARCHAR,
  "gender" VARCHAR,
  "age" DOUBLE,
  "height" DOUBLE,
  "weight" DOUBLE,
  "team" VARCHAR,
  "noc" VARCHAR,
  "games" VARCHAR,
  "year" BIGINT,
  "season" VARCHAR,
  "city" VARCHAR,
  "sport" VARCHAR,
  "event" VARCHAR,
  "medal" VARCHAR
);

Noc Regions

@kaggle.harshvgh_olympics.noc_regions

6.54 kB
230 rows
3 columns

CREATE TABLE noc_regions (
  "noc" VARCHAR,
  "region" VARCHAR,
  "notes" VARCHAR
);