Olympics 124 Years Dataset(till 2020)

Summer olympics data set (124 years) & winter dataset (90 years)

@kaggle.nitishsharma01_olympics_124_years_datasettill_2020

Table List

3 tables(5.85 MB)

Athletes Summer Games

Athletes Winter Games

Regions

Athletes Winter Games

@kaggle.nitishsharma01_olympics_124_years_datasettill_2020.athletes_winter_games

925.02 KB
48564 rows
13 columns

unnamed_0 Unnamed: 0	name Name	sex Sex	age Age	team Team	noc NOC	games Games	year Year	season Season	city City	sport Sport	event Event	medal Medal
4	Christine Jacoba Aaftink	F	21	Netherlands	NED	1988 Winter	1988	Winter	Calgary	Speed Skating	Speed Skating Women's 500 metres	nan
5	Christine Jacoba Aaftink	F	21	Netherlands	NED	1988 Winter	1988	Winter	Calgary	Speed Skating	Speed Skating Women's 1,000 metres	nan
6	Christine Jacoba Aaftink	F	25	Netherlands	NED	1992 Winter	1992	Winter	Albertville	Speed Skating	Speed Skating Women's 500 metres	nan
7	Christine Jacoba Aaftink	F	25	Netherlands	NED	1992 Winter	1992	Winter	Albertville	Speed Skating	Speed Skating Women's 1,000 metres	nan
8	Christine Jacoba Aaftink	F	27	Netherlands	NED	1994 Winter	1994	Winter	Lillehammer	Speed Skating	Speed Skating Women's 500 metres	nan
9	Christine Jacoba Aaftink	F	27	Netherlands	NED	1994 Winter	1994	Winter	Lillehammer	Speed Skating	Speed Skating Women's 1,000 metres	nan
10	Per Knut Aaland	M	31	United States	USA	1992 Winter	1992	Winter	Albertville	Cross Country Skiing	Cross Country Skiing Men's 10 kilometres	nan
11	Per Knut Aaland	M	31	United States	USA	1992 Winter	1992	Winter	Albertville	Cross Country Skiing	Cross Country Skiing Men's 50 kilometres	nan
12	Per Knut Aaland	M	31	United States	USA	1992 Winter	1992	Winter	Albertville	Cross Country Skiing	Cross Country Skiing Men's 10/15 kilometres Pursuit	nan
13	Per Knut Aaland	M	31	United States	USA	1992 Winter	1992	Winter	Albertville	Cross Country Skiing	Cross Country Skiing Men's 4 x 10 kilometres Relay	nan


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