Colonial and imperial wars since 1816 (Correlates of War)
Every war a recognised state fought outside its borders against a non-state opponent — a colony, a people or a state not recognised as a member of the international system — from 1816 to 2007, in the Correlates of War Extra-State War data, with dates, region, type, outcome and battle deaths on each side. One row per state participant per war.
Columns
Stable keys — use them in the API, SQL and code
| Key | Name | Type | Description |
|---|---|---|---|
| id | Row | string | COW war number plus the participant codes and names on the row. |
| war_num | War no. | integer | COW war number. |
| war | War | string | War name, as given by COW. |
| war_type | Type | string | Colonial or imperial war (COW codebook). |
| state | State | string | State participant (Side A), as named by COW. |
| state_cow_code | State COW code | integer | COW state code of the Side A participant. |
| opponent | Opponent (Side B) | string | Participant on the other side named on this row. |
| opponent_cow_code | Opponent COW code | integer | COW state code of the Side B participant when it is a state. |
| start_date | Start | date | Start of the state's sustained combat (precision as known). |
| end_date | End | date | End of the state's sustained combat (blank if unknown or ongoing in 2007). |
| start_date_2 | Resumed | date | Start of a second spell of fighting, if any. |
| end_date_2 | Ended again | date | End of the second spell, if any. |
| start_year | Year | year | Year the state's fighting began. |
| region | Where fought | string | Region where the combat took place. |
| state_initiated | State initiated | boolean | True when COW codes the Side A state as having started the war. |
| intervention | Intervention | boolean | True when an additional state intervened in the war. |
| outcome | Outcome | string | Outcome of the war (Side A is the state). |
| state_deaths | State battle deaths | integer | Battle-related combatant deaths suffered by the state participant. |
| nonstate_deaths | Non-state battle deaths | integer | Battle-related combatant deaths suffered by the non-state participant (on the initial state's row only). |
| transformed_from | Transformed from war no. | integer | COW number of a war that turned into this one. |
| transformed_to | Transformed into war no. | integer | COW number of the war this one turned into. |
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.
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.
Major battles in history
Battles recorded in Wikidata that have articles in at least 10 language editions of Wikipedia, with date, the war each was part of, location, present-day country, coordinates, participants and deaths where recorded. One row per battle.