Winter Olympics (1924 - 2018)

This dataset contains the data of all the past Winter Olympic events

@kaggle.leminhnguyen_winter_olympics_1924_2018

Table List

3 tables(71.73 KB)

Discipline Details

Events Medals

Olympic Events

Discipline Details

@kaggle.leminhnguyen_winter_olympics_1924_2018.discipline_details

55.55 KB
1050 rows
13 columns

event_number Event Number	event_year Event Year	discipline Discipline	category Category	date Date	n_participants N Participants	n_country_participants N Country Participants	gold_medalist Gold Medalist	gold_country Gold Country	silver_medalist Silver Medalist	silver_country Silver Country	bronze_medalist Bronze Medalist	bronze_country Bronze Country
I	1924	Figure Skating	Pairs, Mixed	31 January 1924	18	7	Austria	AUT	Finland	FIN	France 1	FRA
I	1924	Military Ski Patrol	Military Ski Patrol, Men	29 January 1924	24	6	Switzerland	SUI	Finland	FIN	France	FRA
I	1924	Cross Country Skiing	50 kilometres, Men	30 January 1924	33	11	Thorleif Haug	NOR	Thoralf Strømstad	NOR	Johan Grøttumsbraaten	NOR
I	1924	Cross Country Skiing	18 kilometres, Men	2 February 1924	41	12	Thorleif Haug	NOR	Johan Grøttumsbraaten	NOR	Tapani Niku	FIN
I	1924	Speed Skating	Allround, Men	26 – 27 January 1924	23	9	Clas Thunberg	FIN	Roald Larsen	NOR	Julius Skutnabb	FIN
I	1924	Speed Skating	10,000 metres, Men	27 January 1924	16	6	Julius Skutnabb	FIN	Clas Thunberg	FIN	Roald Larsen	NOR
I	1924	Speed Skating	5,000 metres, Men	26 January 1924	22	10	Clas Thunberg	FIN	Julius Skutnabb	FIN	Roald Larsen	NOR
I	1924	Speed Skating	1,500 metres, Men	27 January 1924	22	9	Clas Thunberg	FIN	Roald Larsen	NOR	Sigurd Moen	NOR
I	1924	Speed Skating	500 metres, Men	26 January 1924	27	10	Charley Jewtraw	USA	Oskar Olsen	NOR	Clas Thunberg	FIN
I	1924	Ice Hockey	Ice Hockey, Men	28 January – 3 February 1924	81	8	Canada	CAN	United States	USA	Great Britain	GBR


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
);