World's fairs (Expos) since 1851
Every World Expo, Specialised Expo and Horticultural Expo recognised by the Bureau International des Expositions (BIE), from the Great Exhibition of 1851 to the expos already scheduled, with dates, site area, visitors and number of participating countries. One row per expo.
Columns
Stable keys — use them in the API, SQL and code
| Key | Name | Type | Description |
|---|---|---|---|
| id | ID | string | — |
| year | Year | year | Official expo year. |
| name | Expo | string | Name of the expo's Wikipedia article, e.g. 'Great Exhibition'. |
| expo_wikidata | Expo (Wikidata) | entity | — |
| type | Type | string | BIE category: World Expo, Specialised Expo or Horticultural Expo. |
| city | City | string | — |
| country | Country | string | Host country as named at the time. |
| country_code | Country code | country | Present-day ISO code of the host country; blank for dissolved states. |
| start_date | Opened | date | — |
| end_date | Closed | date | — |
| area_ha | Area | number · ha | Site area in hectares. |
| visitors | Visitors | integer | Total visits reported. |
| participants | Participants | integer | Number of participating countries (and, for recent expos, organisations). |
| theme | Theme | string | — |
More in History & Events
The 25,000 most famous people in history
The 25,000 people with the highest Historical Popularity Index in MIT Media Lab / Datawheel's Pantheon — a measure of how widely and lastingly they are known across Wikipedia's languages — with occupation, birth and death years, birthplace and country. One row per person.
Every member of the U.S. Congress since 1789
Every person who has served in the U.S. Senate or House of Representatives since the First Congress in 1789, including current members and non-voting delegates, with party, chamber, state, first and last year of service and number of terms. One row per person.
Heads of state of every country, all time
Everyone recorded in Wikidata as holding the head-of-state office of a present-day sovereign state — monarchs, presidents and their historical equivalents — with start and end dates and party. One row per term of office per country.
Atlantic hurricanes and tropical storms since 1851
Every tropical cyclone in the North Atlantic, Gulf of Mexico and Caribbean in NOAA's HURDAT2 best-track database, from 1851 to the last completed season. One row per storm, with peak wind, lowest pressure, Saffir–Simpson category, landfalls and accumulated cyclone energy.
Earthquakes of magnitude 2.5+ in the past 30 days
Every earthquake of magnitude 2.5 or greater recorded worldwide by the U.S. Geological Survey in the last 30 days. One row per earthquake, with time, location, depth, magnitude and USGS alert information.
Super Bowl champions
Every Super Bowl since the first in January 1967: date, season, winner, loser, final score, stadium, city, attendance and the game's Most Valuable Player. One row per Super Bowl.