Winter Olympics Data

Comprehensive Winter Olympics Data (1924-2018)

@kaggle.gopalmahadevan_winter_olympics_data

Table List

1 table(43.95 KB)

Winter

@kaggle.gopalmahadevan_winter_olympics_data.winter

43.95 KB
3274 rows
9 columns

year Year	city City	sport Sport	discipline Discipline	country Country	gender Gender	event Event	medal Medal	athlete Athlete
1924	Chamonix	Biathlon	Biathlon	FIN	Men	Military Patrol	Silver	FIN
1924	Chamonix	Biathlon	Biathlon	FRA	Men	Military Patrol	Bronze	FRA
1924	Chamonix	Biathlon	Biathlon	SUI	Men	Military Patrol	Gold	SUI
1924	Chamonix	Bobsleigh	Bobsleigh	BEL	Men	Four-Man	Bronze	BEL
1924	Chamonix	Bobsleigh	Bobsleigh	GBR	Men	Four-Man	Silver	GBR
1924	Chamonix	Bobsleigh	Bobsleigh	SUI	Men	Four-Man	Gold	SUI
1924	Chamonix	Curling	Curling	FRA	Men	Curling	Bronze	FRA
1924	Chamonix	Curling	Curling	GBR	Men	Curling	Gold	GBR
1924	Chamonix	Curling	Curling	SWE	Men	Curling	Silver	SWE
1924	Chamonix	Ice Hockey	Ice Hockey	CAN	Men	Ice Hockey	Gold	CAN


CREATE TABLE winter (
  "year" BIGINT,
  "city" VARCHAR,
  "sport" VARCHAR,
  "discipline" VARCHAR,
  "country" VARCHAR,
  "gender" VARCHAR,
  "event" VARCHAR,
  "medal" VARCHAR,
  "athlete" VARCHAR
);