Olympic Cities Summary

Summary data of Olympic games with Latitude and Longitude of the Olympic cities

@kaggle.ericnarro_olympic_cities_summary

Table List

1 table(15.79 KB)

Olympic Cities

@kaggle.ericnarro_olympic_cities_summary.olympic_cities

15.79 KB
54 rows
16 columns

olympiad Olympiad	olympic_city Olympic City	olympic_year Olympic Year	olympic_season Olympic Season	total_medals Total Medals	total_medals_gold Total Medals Gold	total_medals_silver Total Medals Silver	total_medals_bronze Total Medals Bronze	number_committees Number Committees	number_disciplines Number Disciplines	number_events Number Events	country Country	continent Continent	iso_code_mapping ISO Code Mapping	latitude Latitude	longitude Longitude
Athina 1896	Athens	1896	summer	122	43	43	36	11	10	43	Greece	Europe	GRC	37.9755648	23.7348324
Paris 1900	Paris	1900	summer	287	96	94	97	19	22	89	France	Europe	FRA	48.8534951	2.3483915
St. Louis 1904	St. Louis	1904	summer	280	97	92	91	8	18	94	United States	North America	USA	38.6280278	-90.1910154
London 1908	London	1908	summer	324	110	107	107	19	24	104	United Kingdom	Europe	GBR	51.4893335	-0.1440550845276872
Stockholm 1912	Stockholm	1912	summer	317	106	107	104	19	19	103	Sweden	Europe	SWE	59.3251172	18.0710935
Antwerpen 1920	Antwerp	1920	summer	449	158	152	139	22	29	143	Belgium	Europe	BEL	51.2211097	4.3997081
Chamonix 1924	Chamonix	1924	winter	50	17	16	17	11	10	17	France	Europe	FRA	45.9246705	6.8727506
Paris 1924	Paris	1924	summer	392	129	132	131	31	23	121	France	Europe	FRA	48.8534951	2.3483915
Amsterdam 1928	Amsterdam	1928	summer	356	119	118	119	34	20	110	Netherlands	Europe	NLD	52.3730796	4.8924534
Sankt Moritz 1928	St. Moritz	1928	winter	41	14	12	15	12	8	13	Switzerland	Europe	CHE	46.4978958	9.8392428


CREATE TABLE olympic_cities (
  "olympiad" VARCHAR,
  "olympic_city" VARCHAR,
  "olympic_year" BIGINT,
  "olympic_season" VARCHAR,
  "total_medals" BIGINT,
  "total_medals_gold" BIGINT,
  "total_medals_silver" BIGINT,
  "total_medals_bronze" BIGINT,
  "number_committees" BIGINT,
  "number_disciplines" BIGINT,
  "number_events" BIGINT,
  "country" VARCHAR,
  "continent" VARCHAR,
  "iso_code_mapping" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);