Historical Olympic Medals Data (1994-2024)
Medal Counts and Performance Insights from 30 Years of Olympics
@kaggle.muhammadehsan02_historical_olympic_medals_data_1994_2024
Medal Counts and Performance Insights from 30 Years of Olympics
@kaggle.muhammadehsan02_historical_olympic_medals_data_1994_2024
This dataset offers an extensive collection of medal data from the Olympic Games spanning from 1994 to 2024. It provides a detailed breakdown of the medals awarded across both Summer and Winter Olympics, capturing the achievements of participating countries over a 30-year period.
The database is organized into tables, each corresponding to a specific Olympic Games year, and includes:
The dataset encompasses both Summer and Winter Olympic Games, providing a comprehensive view of global athletic performance across different seasons and types of events. It includes data from notable Olympics such as:
This dataset is valuable for a range of analytical purposes, including:
By providing a rich historical record of Olympic achievements, this dataset supports various research and analysis projects aimed at understanding the dynamics of international sports competition and national performance in the Olympic arena.
This dataset is also available on Kaggle, originally contributed by Youssef Ismail. You can find the dataset here: Olympic Games 1994-2024.
The purpose of this contribution is to build upon and share the data with the community, fostering deeper analysis and exploration of Olympic performances over the years.
CREATE TABLE n_1994_lillehammer_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_1996_atlanta_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_1998_nagano_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_2000_sydney_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_2002_saltlakecity_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_2004_athens_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_2006_torino_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_2008_beijing_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_2010_vancouver_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_2012_london_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_2014_sochi_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_2016_rio_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_2018_pyeongchang_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_2020_tokyo_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_2022_beijing_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);CREATE TABLE n_2024_paris_olympics_nations_medals (
"noc" VARCHAR,
"gold" BIGINT,
"silver" BIGINT,
"bronze" BIGINT,
"total" BIGINT
);Anyone who has the link will be able to view this.