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

Olympic Events

@kaggle.leminhnguyen_winter_olympics_1924_2018.olympic_events

8.58 KB
23 rows
10 columns

event_city Event City	event_country Event Country	event_number Event Number	event_year Event Year	opening_ceremony Opening Ceremony	closing_ceremony Closing Ceremony	n_participants N Participants	n_countries N Countries	n_medals N Medals	n_disciplines N Disciplines
Chamonix	France	I	1924	24 January	5 February	312	19 countries	17	10
Sankt Moritz	Switzerland	II	1928	11 February	17 February	460	25 countries	14	8
Lake Placid	United States	III	1932	4 February	13 February	251	17 countries	14	7
Garmisch-Partenkirchen	Germany	IV	1936	6 February	16 February	669	28 countries	17	8
Sankt Moritz	Switzerland	V	1948	30 January	8 February	667	28 countries	22	9
Oslo	Norway	VI	1952	15 February	25 February	694	30 countries	22	8
Cortina d'Ampezzo	Italy	VII	1956	26 January	5 February	821	32 countries	24	8
Squaw Valley	United States	VIII	1960	18 February	28 February	665	30 countries	27	8
Innsbruck	Austria	IX	1964	29 January	9 February	1094	36 countries	34	10
Grenoble	France	X	1968	6 February	18 February	1160	37 countries	35	10


CREATE TABLE olympic_events (
  "event_city" VARCHAR,
  "event_country" VARCHAR,
  "event_number" VARCHAR,
  "event_year" BIGINT,
  "opening_ceremony" VARCHAR,
  "closing_ceremony" VARCHAR,
  "n_participants" BIGINT,
  "n_countries" VARCHAR,
  "n_medals" BIGINT,
  "n_disciplines" BIGINT
);