Dataset: Olympic Swimming History (1912 To 2020)

About this Dataset

Olympic Swimming History (1912 To 2020)

Context
Swimming is one of the most popular Olympic sports where individual competitors race over various distance events in butterfly, backstroke, breaststroke, freestyle, and individual medley. Additionally, four swimmers can take part in a freestyle or medley relay. A medley relay consists of four swimmers each swimming a different stroke - ordered as backstroke, breaststroke, butterfly, and freestyle - over a set distance. Swimming has been a sport at every modern Summer Olympics but has only been open to women since 1912.

Content
This dataset only focuses on results from competitive Olympic pool swimming. One row per competitor or relay team.

Column	Description
Location	Hosting City
Year	Year of Olympics
Distance	In Meters. Relays are written as the number of swimmers by the distance swam by one swimmer (i.e. 4x200)
Stroke	Backstroke, Breaststroke, Butterfly, Freestyle, Medley, Individual Medley
Relay?	0 - Individual, 1 - Relay
Gender	Men or Women
Team	Three Letter Country Code
Athlete	Name of Athlete
Results	Time
Rank	0 - Did not Start/Finish or Disqualified, 1 - Gold, 2 - Silver, 3- Bronze, 4- No Medal, 5 - No Data

Acknowledgements
Data is collected from here and updated 4 April 2023.

Full webscraping code is available here.

Tables

Olympic Swimming Results 1912to2020

@kaggle.datasciencedonut_olympic_swimming_1912_to_2020.olympic_swimming_results_1912to2020

109.21 KB
4359 rows
10 columns


CREATE TABLE olympic_swimming_results_1912to2020 (
  "location" VARCHAR,
  "year" BIGINT,
  "distance_in_meters" VARCHAR,
  "stroke" VARCHAR,
  "relay" BIGINT,
  "gender" VARCHAR,
  "team" VARCHAR,
  "athlete" VARCHAR,
  "results" VARCHAR,
  "rank" BIGINT
);