Name: 120 Years Of Olympic History
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

120 Years Of Olympic History

Historical data on the modern Olympic Games, from Athens 1896 to Rio 2016. Each row corresponds to an individual athlete competing in an individual event, including the athlete's name, sex, age, height, weight, country, and medal, and the event's name, sport, games, year, and city.
ID Unique number for each athlete
Name Athlete's name
Sex Male (M) or Female (F)
Age Integer
Height In centimeters
Weight In kilograms
Team Team name
NOC National Olympic Committee 3-letter code
Games Year and season
Year Integer
Season summer or Winter
City Host city
Sport Sport
Event Event
Medal Gold, Silver, Bronze, or NA

Tables

Athlete Events

@kaggle.mysarahmadbhat_120_years_of_olympic_history.athlete_events

5.94 MB
271,116 rows
15 columns

CREATE TABLE athlete_events (
  "id" BIGINT,
  "name" VARCHAR,
  "sex" 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
);

Athlete Events Data Dictionary

@kaggle.mysarahmadbhat_120_years_of_olympic_history.athlete_events_data_dictionary

2.48 kB
15 rows
2 columns

CREATE TABLE athlete_events_data_dictionary (
  "field" VARCHAR,
  "description" VARCHAR
);

Country Definitions

@kaggle.mysarahmadbhat_120_years_of_olympic_history.country_definitions

6.54 kB
230 rows
3 columns

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

Country Definitions Data Dictionary

@kaggle.mysarahmadbhat_120_years_of_olympic_history.country_definitions_data_dictionary

2.43 kB
3 rows
2 columns

CREATE TABLE country_definitions_data_dictionary (
  "field" VARCHAR,
  "description" VARCHAR
);