Olympic Medal Data (Summer+Winter)

Exploring Olympic Medal History: All-Time Winners (Summer & Winter)

@kaggle.parthdande_olympic_medal_data_summer_winter

Table List

1 table(16.65 KB)

Olympic Medal Data

@kaggle.parthdande_olympic_medal_data_summer_winter.olympic_medal_data

16.65 KB
157 rows
14 columns

unnamed_0 Unnamed: 0	team Team	summer_gold Summer Gold	summer_silver Summer Silver	summer_bronze Summer Bronze	summer_tot Summer Tot	winter_gold Winter Gold	winter_silver Winter Silver	winter_bronze Winter Bronze	winter_total Winter Total	combined_gold Combined Gold	combined_silver Combined Silver	combined_bronze Combined Bronze	combined_total Combined Total
	Total Medals	5460	5429	5892	16781	1171	1169	1160	3500	6631	6598	7052	20281
1	United States	1061	830	738	2629	114	121	95	330	1175	951	833	2959
2	Soviet Union	395	319	296	1010	78	57	59	194	473	376	355	1204
3	Great Britain	284	318	314	916	12	5	17	34	296	323	331	950
4	China	263	199	174	636	22	32	23	77	285	231	197	713
5	France	223	251	277	751	41	42	55	138	264	293	332	889
6	Italy	217	188	213	618	42	43	56	141	259	231	269	759
7	Germany	201	207	247	655	104	98	65	267	305	305	312	922
8	Hungary	181	154	176	511	2	2	6	10	183	156	182	521
9	Japan	169	150	178	497	17	29	30	76	186	179	208	573


CREATE TABLE olympic_medal_data (
  "unnamed_0" BIGINT,
  "team" VARCHAR,
  "summer_gold" BIGINT,
  "summer_silver" BIGINT,
  "summer_bronze" BIGINT,
  "summer_tot" BIGINT,
  "winter_gold" BIGINT,
  "winter_silver" BIGINT,
  "winter_bronze" BIGINT,
  "winter_total" BIGINT,
  "combined_gold" BIGINT,
  "combined_silver" BIGINT,
  "combined_bronze" BIGINT,
  "combined_total" BIGINT
);