Former countries and historical states
Countries, kingdoms, empires, republics and other states that no longer exist, with the years they were founded and dissolved, how long they lasted, capital, form of government, and the states they replaced and were replaced by. One row per historical state.
Columns
Stable keys — use them in the API, SQL and code
| Key | Name | Type | Description |
|---|---|---|---|
| name | State | string | — |
| wikidata | Wikidata | entity | — |
| founded | Founded | year | Year of inception (P571). Negative = BCE. |
| dissolved | Dissolved | year | Year of dissolution (P576). Negative = BCE. |
| duration_years | Lasted | integer · years | Dissolved minus founded. |
| founded_date | Founded (date) | date | Inception at the precision Wikidata records. |
| dissolved_date | Dissolved (date) | date | Dissolution at the precision Wikidata records. |
| type | Type | string | Other classes Wikidata gives the state (e.g. empire, kingdom, colony), besides 'historical country'. |
| capital | Capital | string | Capital(s) as listed in Wikidata (P36). |
| government | Government | string | Basic form of government (P122). |
| continent | Continent | string | Continent(s) (P30). |
| replaces | Preceded by | string | States it replaced (P1365). |
| replaced_by | Succeeded by | string | States that replaced it (P1366). |
| lat | Latitude | number | — |
| lon | Longitude | number | — |
| sitelinks | Wikipedia languages | integer | Number of Wikimedia sites with an article on the state (notability proxy). |
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.
U.S. National Park Service visits by park and year
Recreation and non-recreation visits to every reporting unit of the U.S. National Park System — national parks, monuments, historic sites, seashores, recreation areas and more — for each calendar year since 1979. One row per park unit per year.
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.
Lighthouses of the world
Lighthouses recorded in Wikidata, with country, location, year built, tower height, focal height and light range, and coordinates. One row per lighthouse.
Every orbital and deep-space launch since Sputnik
Every launch attempt that aimed to reach Earth orbit or beyond, from Sputnik 1 in 1957 to the present, with date, rocket, launch site, launch provider, country and outcome. One row per launch attempt.
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.