Summer Olympic Medals 1896 - 2020

Record of medals on Olympic Editions from 1896 to 2020(1)

@kaggle.ramontanoeiro_summer_olympic_medals_1986_2020

Table List

1 table(14.66 KB)

Summer Olympic Medals

@kaggle.ramontanoeiro_summer_olympic_medals_1986_2020.summer_olympic_medals

14.66 KB
1344 rows
8 columns

year Year	host_country Host Country	host_city Host City	country_name Country Name	country_code Country Code	gold Gold	silver Silver	bronze Bronze
1896	Greece	Athens	Great Britain	GBR	2	3	2
1896	Greece	Athens	Hungary	HUN	2	1	3
1896	Greece	Athens	France	FRA	5	4	2
1896	Greece	Athens	United States	USA	11	7	2
1896	Greece	Athens	Germany	GER	6	5	2
1896	Greece	Athens	Austria	AUT	2	1	2
1896	Greece	Athens	Mixed team	ZZX	1		1
1896	Greece	Athens	Greece	GRE	10	18	19
1896	Greece	Athens	Switzerland	SUI	1	2
1896	Greece	Athens	Australia	AUS	2


CREATE TABLE summer_olympic_medals (
  "year" BIGINT,
  "host_country" VARCHAR,
  "host_city" VARCHAR,
  "country_name" VARCHAR,
  "country_code" VARCHAR,
  "gold" BIGINT,
  "silver" BIGINT,
  "bronze" BIGINT
);