Olympic Games host cities and editions
Every Summer and Winter Olympic Games from Athens 1896 to the Games already awarded for the 2030s, with host city, host nation, opening and closing dates, and the number of nations, athletes and events. One row per edition, including Games that were cancelled.
Columns
Stable keys — use them in the API, SQL and code
| Key | Name | Type | Description |
|---|---|---|---|
| games | Games | string | — |
| games_wikidata | Games (Wikidata) | entity | — |
| year | Year | year | — |
| season | Season | string | Summer or Winter. |
| edition | Edition | integer | Official number of the Games (Olympiad for the Summer Games). |
| city | Host city | string | — |
| city_wikidata | City (Wikidata) | entity | Wikidata item of the (first) host city. |
| host_nation | Host nation | string | Host country as it was at the time. |
| country | Country | country | ISO 3166-1 alpha-3 code of the present-day country of the host city. |
| region | Region | string | Continent of the host city. |
| opening | Opening | date | Date of the opening ceremony. |
| closing | Closing | date | Date of the closing ceremony. |
| status | Status | string | Held, Cancelled or Upcoming. |
| postponed | Postponed | boolean | Held in a later year than its name (Tokyo 2020, held in 2021). |
| nations | Nations | integer | Number of National Olympic Committees taking part. |
| athletes | Athletes | integer | Number of athletes taking part. |
| events | Events | integer | Number of medal events. |
| sports | Sports | integer | Number of sports on the programme. |
| stadium | Main stadium | string | Main stadium as given in the Games article (two when events were split, e.g. Melbourne and Stockholm 1956). |
More in Sports
ATP singles match results, 2016–present
Every men's singles match at ATP tour level in the seasons from 2016 to the present — Grand Slams, Masters, other ATP tour events, the season-ending finals, the Olympics, team events and Davis Cup ties — with round, both players' countries and rankings, score and match length. One row per match.
Tennis singles titles and win–loss records by player (ATP and WTA, Open Era)
Every player with at least one tour-level singles match on the ATP or WTA tour since 1968: tour-level titles, Grand Slam titles, finals, match wins and losses and win percentage, computed from the match results. One row per player per tour.
NHL career statistics of every skater
Career regular-season NHL totals for every skater who has played in the league since 1917, as aggregated by the NHL. One row per player.
NBA players (all-time)
People recorded on Wikidata as having played for an NBA or BAA team since 1946, with birth date and place, citizenship, position, height, weight, years and number of franchises, draft details and Hall of Fame status. One row per player.
NFL regular-season standings, every season since 1920
Final regular-season standings of every NFL season (APFA in 1920–21) whose standings pass consistency checks: one row per team per season with wins, losses, ties, winning percentage, points for and against, division, conference and playoff seed.
NBA regular-season standings, every season since 1946–47
Final regular-season standings of every NBA (and BAA, 1946–49) season: one row per team per season with wins, losses, winning percentage, games behind, division, conference, conference rank and the clinch code printed in the standings.