Chess Olympiad Data

Year First Second Third

@kaggle.shreyaskeote23_chess_olympiad_data

Table List

2 tables(22.17 KB)

Results

@kaggle.shreyaskeote23_chess_olympiad_data.results

18.08 KB
53 rows
7 columns

unnamed_0 Unnamed: 0	year Year	event Event	host Host	gold Gold	silver Silver	bronze Bronze
	1924	1st unofficial Chess Olympiad The Chess Olympiad (individual)	Paris, France	Czechoslovakia 31Karel Hromádka, Jan Schulz, Karel Vaněk, Karel Skalička	Hungary 30Árpád Vajda, Károly Sterk, Endre Steiner, Kornél Havasi	Switzerland 29Erwin Voellmy, Otto Zimmermann, Hans Johner, Oskar Naegeli
1	1926	2nd unofficial Chess Olympiad The Team Tournament (part of FIDE summit)	Budapest, Hungary	Hungary 9Endre Steiner, Árpád Vajda, Károly Sterk, György Négyesy, Elek Bakonyi, Sándor Zinner	Kingdom of Serbs, Croats and Slovenes 8Boris Kostić, Lajos Asztalos, Stevan Ćirić, Imre György	Romania 5János Balogh, Miklós Bródy, Alexandru Tyroler, Iosif Mendelssohn, Zeno Proca
2	1927	1st Chess Olympiad	London, United Kingdom	Hungary 40Géza Maróczy, Géza Nagy, Árpád Vajda, Kornél Havasi, Endre Steiner	Denmark 38½Orla Hermann Krause, Holger Norman-Hansen, Erik Andersen, Karl Ruben	England 36½Henry Atkins, Fred Yates, George Thomas, Reginald Michell, Edmund Spencer
3	1928	2nd Chess Olympiad	The Hague, Netherlands	Hungary 44Géza Nagy, Endre Steiner, Árpád Vajda, Kornél Havasi	United States 39½Isaac Kashdan, Herman Steiner, Samuel Factor, Erling Tholfsen, Milton Hanauer	Poland 37Kazimierz Makarczyk, Paulin Frydman, Teodor Regedziński, Mieczysław Chwojnik, Abram Blass
4	1930	3rd Chess Olympiad	Hamburg, Germany	Poland 48½Akiba Rubinstein, Savielly Tartakower, Dawid Przepiórka, Kazimierz Makarczyk, Paulin Frydman	Hungary 47Géza Maróczy, Sándor Takács, Árpád Vajda, Kornél Havasi, Endre Steiner	Germany 44½Carl Ahues, Friedrich Sämisch, Carl Carls, Kurt Richter, Heinrich Wagner
5	1931	4th Chess Olympiad	Prague, Czechoslovakia	United States 48Isaac Kashdan, Frank Marshall, Arthur Dake, Israel Horowitz, Herman Steiner	Poland 47Akiba Rubinstein, Savielly Tartakower, Dawid Przepiórka, Kazimierz Makarczyk, Paulin Frydman	Czechoslovakia 46½Salo Flohr, Karl Gilg, Josef Rejfíř, Karel Opočenský, Karel Skalička
6	1933	5th Chess Olympiad	Folkestone, United Kingdom	United States 39Isaac Kashdan, Frank Marshall, Reuben Fine, Arthur Dake, Albert Simonson	Czechoslovakia 37½Salo Flohr, Karel Treybal, Josef Rejfíř, Karel Opočenský, Karel Skalička	Sweden 34Gideon Ståhlberg, Gösta Stoltz, Erik Lundin, Karl Berndtsson
7	1935	6th Chess Olympiad	Warsaw, Poland	United States 54Reuben Fine, Frank Marshall, Abraham Kupchik, Arthur Dake, Israel Horowitz	Sweden 52½Gideon Ståhlberg, Gösta Stoltz, Erik Lundin, Gösta Danielsson, Ernst Larsson	Poland 52Savielly Tartakower, Paulin Frydman, Mieczysław Najdorf, Henryk Friedman, Kazimierz Makarczyk
8	1936	3rd unofficial Chess Olympiad non-FIDE unofficial Chess Olympiad	Munich, Germany	Hungary 110½Géza Maróczy, Lajos Steiner, Endre Steiner, Kornél Havasi, László Szabó, Gedeon Barcza, Árpád Vajda, Ernő Gereben, János Balogh, Imre Korody	Poland 108Paulin Frydman, Mieczysław Najdorf, Teodor Regedziński, Kazimierz Makarczyk, Henryk Friedman, Leon Kremer, Henryk Pogorieły, Antoni Wojciechowski, Franciszek Sulik, Jerzy Jagielski	Germany 106½Kurt Richter, Carl Ahues, Ludwig Engels, Carl Carls, Ludwig Rellstab, Friedrich Sämisch, Ludwig Rödl, Herbert Heinicke, Wilhelm Ernst, Paul Michel
9	1937	7th Chess Olympiad	Stockholm, Sweden	United States 54½Samuel Reshevsky, Reuben Fine, Isaac Kashdan, Frank Marshall, Israel Horowitz	Hungary 48½ Andor Lilienthal, László Szabó, Endre Steiner, Kornél Havasi, Árpád Vajda	Poland 47Savielly Tartakower, Mieczysław Najdorf, Paulin Frydman, Izaak Appel, Teodor Regedziński


CREATE TABLE results (
  "unnamed_0" BIGINT,
  "year" BIGINT,
  "event" VARCHAR,
  "host" VARCHAR,
  "gold" VARCHAR,
  "silver" VARCHAR,
  "bronze" VARCHAR
);