Data Sources
120 years of Olympic history: athletes and results, 271116 rows and 15 columns
- ID – Unique number for each athlete
- Name – Athlete’s name
- Sex – M or F
- Age – Integer
- Height – In centimeters
- Weight – In kilograms
- Team – Team name
- NOC – National Olympic Committee 3-letter code
- Games – Year and season
- Year – Integer
- Season – Summer or Winter
- City – Host city
- Sport – Sport
- Event – Event
- Medal – Gold, Silver, Bronze, or NA
Olympic Summer & Winter Games, 1896-2022
More than 21,000 medals, 162,000 results, 74,000 athletes, 20,000 biographies, and 53 hosts. The data was created from Olympics.
olympic_athletes.csv | personal information about athletes (name, short bio, etc.) 75904 rows × 7 columns : athlete_url athlete_full_name games_participations first_game athlete_year_birth athlete_medals bio |
olympic_medals.csv | general information on medalists (Athlete or Team) 21697 rows × 12 columns discipline_title slug_game event_title event_gender medal_type participant_type participant_title athlete_url athlete_full_name country_name country_code country_3_letter_code |
olympic_hosts.csv | hosts (year, city, country, etc) 52 rows x 7 columns : game_slug game_end_date game_start_date game_location game_name game_season game_year |
olympic_results.csv | general information on results (Athlete or Team) 162804 rows × 15 columns discipline_title event_title slug_game participant_type medal_type athletes rank_equal rank_position country_name country_code country_3_letter_code athlete_url athlete_full_name value_unit value_type |
olympic_results.pkl | general information on results (Athlete or Team) |
Flourish : How to visualize the Olympics
Paris 2024 countdown, competition ?
Dataviz found on the web
- Country teams
- Top countries by number of medals ( map, color squares, stacked /bars, areas over time)
- Country rank over time
- Number of competing countries over time (line)
- Team details (state of origin map, university bar, height/weight scatter)
- country medals/gdp per cap over time (scatter+size)
- Sports
- Evolution of performance (line, scatter)
- Number of disciplines by type over time (bar)
- height by sport (box)
- age/sex distribution by sport
- Hosts
- Host countries distribution (bar)
- Host continent (pie)
- country medals/gdp per cap over time (scatter+size)
- budget over time (circle size), costs and revenues over time (bars)
- map of venues
- Individuals
- google search by gender and sport (bar)
- number of athletes over time (line + )
- number of medals by age (bar)
- number of male/female over time (lines, stacked bars)
- medals per athlete by country (bar)