Dataset: Commonwealth Games 2022

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.

More Reading Material

For Medal Standings: https://en.wikipedia.org/wiki/2022_Commonwealth_Games_medal_table.

Tables

Countrywise Athlete Count

@kaggle.varunnagpalspyz_commonwealth_games_2022.countrywise_athlete_count

3.2 KB
72 rows
2 columns


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

Event Schedule

@kaggle.varunnagpalspyz_commonwealth_games_2022.event_schedule

11.37 KB
28 rows
16 columns


CREATE TABLE event_schedule (
  "unnamed_0" BIGINT,
  "event_category" VARCHAR,
  "event_subtype" VARCHAR,
  "n_28ththu" VARCHAR,
  "n_29thfri" VARCHAR,
  "n_30thsat" VARCHAR,
  "n_31stsun" VARCHAR,
  "n_1stmon" VARCHAR,
  "n_2ndtue" VARCHAR,
  "n_3rdwed" VARCHAR,
  "n_4ththu" VARCHAR,
  "n_5thfri" VARCHAR,
  "n_6thsat" VARCHAR,
  "n_7thsun" VARCHAR,
  "n_8thmon" VARCHAR,
  "events" VARCHAR
);

Medal Standings

@kaggle.varunnagpalspyz_commonwealth_games_2022.medal_standings

11.37 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
);