Civil and other intra-state wars since 1816 (Correlates of War)
Every war fought mainly inside one state's territory from 1816 to 2007 — civil wars, regional internal wars and intercommunal wars — in the Correlates of War Intra-State War data, with the two sides, dates, region, type, outcome and battle deaths. One row per pairing of participants listed by COW (most wars have one row; wars with several participants on a side have more).
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 | COW intra-state war type. |
| side_a | Side A | string | Participant on Side A named on this row (the government in civil wars). |
| side_a_cow_code | Side A COW code | integer | COW state code of the Side A participant when it is a state. |
| side_b | Side B | string | Participant on Side B named on this row. |
| side_b_cow_code | Side B COW code | integer | COW state code of the Side B participant when it is a state. |
| internationalized | Internationalized | boolean | True when an outside state intervened in the war. |
| start_date | Start | date | Start of sustained combat (precision as known). |
| end_date | End | date | End of 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 fighting began. |
| region | Where fought | string | Region where the combat took place. |
| initiator | Initiator | string | Participant that began the war, as named by COW. |
| outcome | Outcome | string | Outcome of the war. |
| side_a_deaths | Side A battle deaths | integer | Battle-related combatant deaths suffered by the Side A participant on this row. |
| side_b_deaths | Side B battle deaths | integer | Battle-related combatant deaths suffered by the Side B participant on this row. |
| 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.
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.