Name: Commonwealth Games 2022
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Commonwealth Games 2022

Context

The 2022 Commonwealth Games, officially known as the XXII Commonwealth Games and commonly known as Birmingham 2022, is an international multi-sport event for members of the Commonwealth of Nations that is currently taking place in Birmingham, England, from 28 July to 8 August 2022.

Here I present to you some data regarding these games including Medal Standings, Athlete Counts, Event Schedule and more to be updated soon...

Sources

The data is sourced from Wikipedia: https://en.wikipedia.org/wiki/2022_Commonwealth_Games
and the official games website: https://www.birmingham2022.com/

Inspiration

I have always wanted to work with comprehensive data regarding any big event such as sporting events like the Olympics, Commonwealth Games etc. So I will try to create different kinds of datasets related to CWGXXII and save them here for public use. I will also try to create an EDA notebook soon.

Countrywise Athlete Count

@kaggle.varunnagpalspyz_commonwealth_games_2022.countrywise_athlete_count

3.28 kB
72 rows
2 columns

CREATE TABLE countrywise_athlete_count (
  "country" VARCHAR,
  "athletes" BIGINT
);

Event Schedule

@kaggle.varunnagpalspyz_commonwealth_games_2022.event_schedule

11.64 kB
28 rows
16 columns

CREATE TABLE event_schedule (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "event_category" VARCHAR,
  "event_subtype" VARCHAR,
  "n_28ththu" VARCHAR  -- 28thThu,
  "n_29thfri" VARCHAR  -- 29thFri,
  "n_30thsat" VARCHAR  -- 30thSat,
  "n_31stsun" VARCHAR  -- 31stSun,
  "n_1stmon" VARCHAR  -- 1stMon,
  "n_2ndtue" VARCHAR  -- 2ndTue,
  "n_3rdwed" VARCHAR  -- 3rdWed,
  "n_4ththu" VARCHAR  -- 4thThu,
  "n_5thfri" VARCHAR  -- 5thFri,
  "n_6thsat" VARCHAR  -- 6thSat,
  "n_7thsun" VARCHAR  -- 7thSun,
  "n_8thmon" VARCHAR  -- 8thMon,
  "events" VARCHAR
);

Medal Standings

@kaggle.varunnagpalspyz_commonwealth_games_2022.medal_standings

11.64 kB
43 rows
14 columns

CREATE TABLE medal_standings (
  "country_name" VARCHAR,
  "men_gold" BIGINT,
  "men_silver" BIGINT,
  "men_bronze" BIGINT,
  "women_gold" BIGINT,
  "women_silver" BIGINT,
  "women_bronze" BIGINT,
  "mixed_gold" BIGINT,
  "mixed_silver" BIGINT,
  "mixed_bronze" BIGINT,
  "total_gold" BIGINT,
  "total_silver" BIGINT,
  "total_bronze" BIGINT,
  "total" BIGINT
);

Commonwealth Games 2022

About this Dataset