Olympic Games

Countries and medals from 1896 to 2022

@kaggle.andreinovikov_olympic_games

Table List

1 table(17.21 KB)

Olympic Games

@kaggle.andreinovikov_olympic_games.olympic_games

17.21 KB
1781 rows
11 columns

year Year	games_type Games Type	host_country Host Country	host_city Host City	athletes Athletes	teams Teams	competitions Competitions	country Country	gold Gold	silver Silver	bronze Bronze
2022	Winter	China	Beijing	2834	91	109	Australia	1	2	1
2022	Winter	China	Beijing	2834	91	109	Austria	7	7	4
2022	Winter	China	Beijing	2834	91	109	Belarus		2
2022	Winter	China	Beijing	2834	91	109	Belgium	1		1
2022	Winter	China	Beijing	2834	91	109	Canada	4	8	14
2022	Winter	China	Beijing	2834	91	109	Czechia	1		1
2022	Winter	China	Beijing	2834	91	109	Estonia			1
2022	Winter	China	Beijing	2834	91	109	Finland	2	2	4
2022	Winter	China	Beijing	2834	91	109	France	5	7	2
2022	Winter	China	Beijing	2834	91	109	Germany	12	10	5


CREATE TABLE olympic_games (
  "year" BIGINT,
  "games_type" VARCHAR,
  "host_country" VARCHAR,
  "host_city" VARCHAR,
  "athletes" BIGINT,
  "teams" BIGINT,
  "competitions" BIGINT,
  "country" VARCHAR,
  "gold" BIGINT,
  "silver" BIGINT,
  "bronze" BIGINT
);