Summer Olympic Games 1896-2032

Summary of Olympic Games: hosts, dates, number of disciplines and competitors.

@kaggle.julianowakowska_summer_olympic_games_18962032

Table List

1 table(11.43 KB)

Summer Olympic Games

@kaggle.julianowakowska_summer_olympic_games_18962032.summer_olympic_games

11.43 KB
32 rows
13 columns

year Year	no No.	host Host	games_dates_start Games Dates Start	games_dates_end Games Dates End	opened_by Opened By	sports Sports	competitors_total Competitors Total	competitors_men Competitors Men	competitors_women Competitors Women	events Events	nations Nations	top_nation Top Nation
1896	I	Athens	6.04.1896	15.04.1896	King George I	9	241	241	0	43	15	United States
1900	II	Paris	14.05.1900	28.10.1900	nan	19	1226	nan	nan	95	31	France
1904	III	St. Louis	01.07.1904	23.11.1904	Former Mayor David R. Francis	16	651	645	6	95	13	United States
1908	IV	London	27.04.1908	21.10.1908	King Edward VII	22	2008	1971	37	110	22	Great Britain
1912	V	Stockholm	06.07.1912	22.07.1912	King Gustaf V	14	2407	2359	48	102	28	United States
1920	VII	Antwerp	14.08.1920	12.09.1920	King Albert I	22	2626	2561	65	156	29	United States
1924	VIII	Paris	05.07.1924	27.07.1924	President Gaston Doumergue	17	3089	2954	135	126	44	United States
1928	IX	Amsterdam	28.07.1928	12.08.1928	Duke Henry of Mecklenburg-Schwerin	14	2883	2606	277	109	46	United States
1932	X	Los Angeles	30.07.1932	14.08.1932	Vice President Charles Curtis	14	1332	1206	126	117	37	United States
1936	XI	Berlin	01.08.1936	16.08.1936	Chancellor Adolf Hitler	19	3963	3632	331	129	49	Germany


CREATE TABLE summer_olympic_games (
  "year" BIGINT,
  "no" VARCHAR,
  "host" VARCHAR,
  "games_dates_start" VARCHAR,
  "games_dates_end" VARCHAR,
  "opened_by" VARCHAR,
  "sports" VARCHAR,
  "competitors_total" VARCHAR,
  "competitors_men" VARCHAR,
  "competitors_women" VARCHAR,
  "events" VARCHAR,
  "nations" VARCHAR,
  "top_nation" VARCHAR
);