Competed In Both Summer And Winter Olympics

List of athletes who competed in both the Summer and Winter Olympics games

@kaggle.igalbronshtein_competed_in_both_summer_and_winter_olympic

Table List

1 table(22.19 KB)

Athletes

@kaggle.igalbronshtein_competed_in_both_summer_and_winter_olympic.athletes

22.19 KB
136 rows
16 columns

athlete Athlete	nation Nation	summer_games Summer Games	summer_sport Summer Sport	winter_games Winter Games	winter_sport Winter Sport	number_of_summer_games Number Of Summer Games	number_of_winter_games Number Of Winter Games	total_number_of_games Total Number Of Games	medals_in_both Medals In Both	olympicscom_profile Olympicscom Profile	wikipedia_profile Wikipedia Profile	gold Gold	silver Silver	bronze Bronze	birth Birth
István Déván	Hungary	1912	Athletics	1924	Cross-country skiing/Nordic combined	1	1	2	No	https://olympics.com/en/athletes/istvan-devan	https://en.wikipedia.org//wiki/Istv%C3%A1n_D%C3%A9v%C3%A1n				1891
Väinö Bremer	Finland	1924	Modern pentathlon	1924	Military patrol at the Winter Olympics	1	1	2	No	https://olympics.com/en/athletes/vaino-elias-bremer	https://en.wikipedia.org//wiki/V%C3%A4in%C3%B6_Bremer		1		1899
Anton Collin	Finland	1924	Cycling	1924	Cross-country skiing	1	1	2	No	https://olympics.com/en/athletes/anton-collin	https://en.wikipedia.org//wiki/Anton_Collin				1891
Roberts Plūme	Latvia	1924/1928	Cycling	1924	Cross-country skiing	2	1	3	No	https://olympics.com/en/athletes/roberts-plume	https://en.wikipedia.org//wiki/Roberts_Pl%C5%ABme				1897
Charles Stoffel	Switzerland	1924/1928	Equestrian	1924/1928	Bobsleigh	2	2	4	No	https://olympics.com/en/athletes/charles-stoffel	https://en.wikipedia.org//wiki/Charles_Stoffel				1893
Giuseppe Crivelli	Italy	1924	Rowing	1928	Bobsleigh	1	1	2	No	https://olympics.com/en/athletes/giuseppe-crivelli	https://en.wikipedia.org//wiki/Giuseppe_Crivelli			1	1900
Max Houben	Belgium	1920	Athletics	1928/1932/1936/1948	Bobsleigh	1	4	5	No	https://olympics.com/en/athletes/max-houben	https://en.wikipedia.org//wiki/Max_Houben		1		1898
Léon Tom	Belgium	1912/1920/1924/1928	Fencing	1928	Bobsleigh	4	1	5	No	https://olympics.com/en/athletes/leon-tom	https://en.wikipedia.org//wiki/L%C3%A9on_Tom		2		1888
Tibor Heinrich von Omorovicza	Hungary	1928/1936	Sailing	1928	Ice hockey	2	1	3	No	https://olympics.com/en/athletes/tibor-heinrich	https://en.wikipedia.org//wiki/Tibor_Heinrich_von_Omorovicza				1898
Karl Schäfer	Austria	1928	Swimming	1928/1932/1936	Figure skating	1	3	4	No	https://olympics.com/en/athletes/karl-schafer	https://en.wikipedia.org//wiki/Karl_Sch%C3%A4fer	2			1909


CREATE TABLE athletes (
  "athlete" VARCHAR,
  "nation" VARCHAR,
  "summer_games" VARCHAR,
  "summer_sport" VARCHAR,
  "winter_games" VARCHAR,
  "winter_sport" VARCHAR,
  "number_of_summer_games" BIGINT,
  "number_of_winter_games" BIGINT,
  "total_number_of_games" BIGINT,
  "medals_in_both" VARCHAR,
  "olympicscom_profile" VARCHAR,
  "wikipedia_profile" VARCHAR,
  "gold" BIGINT,
  "silver" BIGINT,
  "bronze" BIGINT,
  "birth" BIGINT
);