variables

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

24 rows where datasetId = 6224 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, updatedAt, timespan, display, descriptionShort, descriptionKey, grapherConfigETL, type, createdAt (date), updatedAt (date), descriptionKey (array)

id ▲ name unit description createdAt updatedAt code coverage timespan datasetId sourceId shortUnit display columnOrder originalMetadata grapherConfigAdmin shortName catalogPath dimensions schemaVersion processingLevel processingLog titlePublic titleVariant attributionShort attribution descriptionShort descriptionFromProducer descriptionKey descriptionProcessing licenses license grapherConfigETL type sort dataChecksum metadataChecksum
815555 Death rate in ongoing conflicts - Conflict type: interstate deaths per 100,000 people   2023-10-19 12:22:57 2024-07-25 23:14:51     1400-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "deaths per 100,000 people",
    "numDecimalPlaces": 1
}
 0     number_deaths_ongoing_conflicts_per_capita__conflict_type_interstate grapher/war/2023-09-21/brecke/brecke#number_deaths_ongoing_conflicts_per_capita__conflict_type_interstate 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "interstate"
        }
    ],
    "originalName": "Death rate in ongoing conflicts",
    "originalShortName": "number_deaths_ongoing_conflicts_per_capita"
}
 2 major           The estimated number of deaths per 100,000 people in ongoing interstate conflicts that year.   
[
    "The data has been collated from a range of historical studies by the political scientist Peter Brecke.",
    "An interstate conflict is a conflict between states that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "His data seeks to include combatant and civilian deaths, counting both direct deaths, due to fighting, and indirect deaths due to disease and starvation.",
    "The value of this data lies in giving us some insight into conflicts over the very long-run. But there are important limitations. The historical studies on which this data relies vary greatly in terms of how deaths are counted and the reliability of the estimates. Moreover, as Brecke makes clear, the data he has been able to collect provides an incomplete record \u2013 particularly for the distant past and outside of Europe."
]
 Brecke's catalog provides data per conflict. In order to create an annual time series, we sum the deaths recorded in each year across all conflicts, distributing deaths evenly across the duration of conflicts lasting more than one year. The catalog includes many conflicts for which Brecke was unable to find a deaths estimate. Given Brecke's stated definition of a conflict – political disagreements between organized groups, or between an organized group and civilians, that cause at least 32 deaths during a year – we assign such conflicts 32 deaths when creating the time series. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
   
{
    "selectedEntityNames": [
        "World"
    ]
}
 float 
[]
 66b629e406d2da15d182c331fad9c71e 43f347414d33a564c4a7c72f650776db
815554 Death rate in ongoing conflicts - Conflict type: internal deaths per 100,000 people   2023-10-19 12:22:55 2024-07-25 23:14:51     1400-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "deaths per 100,000 people",
    "numDecimalPlaces": 1
}
 0     number_deaths_ongoing_conflicts_per_capita__conflict_type_internal grapher/war/2023-09-21/brecke/brecke#number_deaths_ongoing_conflicts_per_capita__conflict_type_internal 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "internal"
        }
    ],
    "originalName": "Death rate in ongoing conflicts",
    "originalShortName": "number_deaths_ongoing_conflicts_per_capita"
}
 2 major           The estimated number of deaths per 100,000 people in ongoing internal conflicts that year.   
[
    "The data has been collated from a range of historical studies by the political scientist Peter Brecke.",
    "An internal conflict is a conflict between a state and a non-state armed groups, between non-state armed groups, or between an armed group and civilians, that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "His data seeks to include combatant and civilian deaths, counting both direct deaths, due to fighting, and indirect deaths due to disease and starvation.",
    "The value of this data lies in giving us some insight into conflicts over the very long-run. But there are important limitations. The historical studies on which this data relies vary greatly in terms of how deaths are counted and the reliability of the estimates. Moreover, as Brecke makes clear, the data he has been able to collect provides an incomplete record \u2013 particularly for the distant past and outside of Europe."
]
 Brecke's catalog provides data per conflict. In order to create an annual time series, we sum the deaths recorded in each year across all conflicts, distributing deaths evenly across the duration of conflicts lasting more than one year. The catalog includes many conflicts for which Brecke was unable to find a deaths estimate. Given Brecke's stated definition of a conflict – political disagreements between organized groups, or between an organized group and civilians, that cause at least 32 deaths during a year – we assign such conflicts 32 deaths when creating the time series. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
   
{
    "selectedEntityNames": [
        "World"
    ]
}
 float 
[]
 0dccfc22f3466db572247bb6e4c5a95e 26902476987a39efc024b7676914fb10
815553 Death rate in ongoing conflicts - Conflict type: all deaths per 100,000 people   2023-10-19 12:22:54 2024-07-25 23:14:50     1400-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "deaths per 100,000 people",
    "numDecimalPlaces": 1
}
 0     number_deaths_ongoing_conflicts_per_capita__conflict_type_all grapher/war/2023-09-21/brecke/brecke#number_deaths_ongoing_conflicts_per_capita__conflict_type_all 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "all"
        }
    ],
    "originalName": "Death rate in ongoing conflicts",
    "originalShortName": "number_deaths_ongoing_conflicts_per_capita"
}
 2 major           The estimated number of deaths per 100,000 people in ongoing armed conflicts that year.   
[
    "The data has been collated from a range of historical studies by the political scientist Peter Brecke.",
    "Brecke seeks to include only political disagreements between organized groups, or between an organized group and civilians, that cause at least 32 deaths during a year. This definition tries to exclude interpersonal and criminal violence.\n\n",
    "His data seeks to include combatant and civilian deaths, counting both direct deaths, due to fighting, and indirect deaths due to disease and starvation.",
    "The value of this data lies in giving us some insight into conflicts over the very long-run. But there are important limitations. The historical studies on which this data relies vary greatly in terms of how deaths are counted and the reliability of the estimates. Moreover, as Brecke makes clear, the data he has been able to collect provides an incomplete record \u2013 particularly for the distant past and outside of Europe."
]
 Brecke's catalog provides data per conflict. In order to create an annual time series, we sum the deaths recorded in each year across all conflicts, distributing deaths evenly across the duration of conflicts lasting more than one year. The catalog includes many conflicts for which Brecke was unable to find a deaths estimate. Given Brecke's stated definition of a conflict – political disagreements between organized groups, or between an organized group and civilians, that cause at least 32 deaths during a year – we assign such conflicts 32 deaths when creating the time series. 
[
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
   
{
    "selectedEntityNames": [
        "World"
    ]
}
 float 
[]
 3d6b68b915fc838067fcb04b05c20ac1 2763247a483e3d973e4ba29f876f9091
815283 Number of new conflicts per state-pair - Conflict type: interstate conflicts per state-pair   2023-10-10 15:24:56 2024-07-25 23:14:51     1816-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts per state-pair",
    "numDecimalPlaces": 5
}
 0     number_new_conflicts_per_country_pair__conflict_type_interstate grapher/war/2023-09-21/brecke/brecke#number_new_conflicts_per_country_pair__conflict_type_interstate 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "interstate"
        }
    ],
    "originalName": "Number of new conflicts per state-pair",
    "originalShortName": "number_new_conflicts_per_country_pair"
}
 2 major           The number of conflicts divided by the number of all state-pairs. This accounts for the changing number of states over time.Included are interstate conflicts that were ongoing that year.   
[
    "An interstate conflict is a conflict between states that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "We count a conflict as new in a region even if the conflict started at the same time in another region. The sum across all regions can therefore be higher than the total number of new conflicts.\n"
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 float 
[]
 e5255fa1317fd3f58784823dcd0da26a 708fe2a5e316dfb149009c73b4553a4a
815282 Number of new conflicts per state - Conflict type: interstate conflicts per state   2023-10-10 15:24:56 2024-07-25 23:14:51     1816-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts per state",
    "numDecimalPlaces": 3
}
 0     number_new_conflicts_per_country__conflict_type_interstate grapher/war/2023-09-21/brecke/brecke#number_new_conflicts_per_country__conflict_type_interstate 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "interstate"
        }
    ],
    "originalName": "Number of new conflicts per state",
    "originalShortName": "number_new_conflicts_per_country"
}
 2 major           The number of conflicts divided by the number of all states. This accounts for the changing number of states over time.Included are interstate conflicts that were ongoing that year.   
[
    "An interstate conflict is a conflict between states that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "We count a conflict as new in a region even if the conflict started at the same time in another region. The sum across all regions can therefore be higher than the total number of new conflicts.\n"
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 float 
[]
 cbf59885115cece4e3240b8aa65114f1 b3f40d8d2a70027c8a3eb776cb479c0b
815281 Number of ongoing conflicts per state-pair - Conflict type: interstate conflicts per state-pair   2023-10-10 15:24:56 2024-07-25 23:14:51     1816-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts per state-pair",
    "numDecimalPlaces": 5
}
 0     number_ongoing_conflicts_per_country_pair__conflict_type_interstate grapher/war/2023-09-21/brecke/brecke#number_ongoing_conflicts_per_country_pair__conflict_type_interstate 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "interstate"
        }
    ],
    "originalName": "Number of ongoing conflicts per state-pair",
    "originalShortName": "number_ongoing_conflicts_per_country_pair"
}
 2 major           The number of conflicts divided by the number of all state-pairs. This accounts for the changing number of states over time.Included are interstate conflicts that were ongoing that year.   
[
    "An interstate conflict is a conflict between states that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "We count a conflict as ongoing in a region even if the conflict is also ongoing in other regions. The sum across all regions can therefore be higher than the total number of ongoing conflicts."
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 float 
[]
 08d5eb78d8751031bd7675a18145fcf1 8917e59cbe5ed0da6cc9d43b134d88bc
815280 Number of ongoing conflicts per state - Conflict type: interstate conflicts per state   2023-10-10 15:24:56 2024-07-25 23:14:51     1816-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts per state",
    "numDecimalPlaces": 3
}
 0     number_ongoing_conflicts_per_country__conflict_type_interstate grapher/war/2023-09-21/brecke/brecke#number_ongoing_conflicts_per_country__conflict_type_interstate 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "interstate"
        }
    ],
    "originalName": "Number of ongoing conflicts per state",
    "originalShortName": "number_ongoing_conflicts_per_country"
}
 2 major           The number of conflicts divided by the number of all states. This accounts for the changing number of states over time.Included are interstate conflicts that were ongoing that year.   
[
    "An interstate conflict is a conflict between states that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "We count a conflict as ongoing in a region even if the conflict is also ongoing in other regions. The sum across all regions can therefore be higher than the total number of ongoing conflicts."
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 float 
[]
 7a773ce45e608d91761e75a9666f62c3 ab0938fc4394b899a6aa52b1dfd1de6a
815279 Number of new conflicts per state-pair - Conflict type: internal conflicts per state-pair   2023-10-10 15:24:55 2024-07-25 23:14:51     1816-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts per state-pair",
    "numDecimalPlaces": 5
}
 0     number_new_conflicts_per_country_pair__conflict_type_internal grapher/war/2023-09-21/brecke/brecke#number_new_conflicts_per_country_pair__conflict_type_internal 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "internal"
        }
    ],
    "originalName": "Number of new conflicts per state-pair",
    "originalShortName": "number_new_conflicts_per_country_pair"
}
 2 major           The number of conflicts divided by the number of all state-pairs. This accounts for the changing number of states over time.Included are internal conflicts that were ongoing that year.   
[
    "An internal conflict is a conflict between a state and a non-state armed groups, between non-state armed groups, or between an armed group and civilians, that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "We count a conflict as new in a region even if the conflict started at the same time in another region. The sum across all regions can therefore be higher than the total number of new conflicts.\n"
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 float 
[]
 26d6e09b5805637e0d648d2a3071f0d3 0bdfddbcaf08ebbbf8641afec5a77401
815278 Number of new conflicts per state - Conflict type: internal conflicts per state   2023-10-10 15:24:55 2024-07-25 23:14:51     1816-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts per state",
    "numDecimalPlaces": 3
}
 0     number_new_conflicts_per_country__conflict_type_internal grapher/war/2023-09-21/brecke/brecke#number_new_conflicts_per_country__conflict_type_internal 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "internal"
        }
    ],
    "originalName": "Number of new conflicts per state",
    "originalShortName": "number_new_conflicts_per_country"
}
 2 major           The number of conflicts divided by the number of all states. This accounts for the changing number of states over time.Included are internal conflicts that were ongoing that year.   
[
    "An internal conflict is a conflict between a state and a non-state armed groups, between non-state armed groups, or between an armed group and civilians, that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "We count a conflict as new in a region even if the conflict started at the same time in another region. The sum across all regions can therefore be higher than the total number of new conflicts.\n"
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 float 
[]
 4544dfc2936190b5ac0c70e14b87a4de a4b341fd367221d475a96cf3a0614077
815277 Number of ongoing conflicts per state-pair - Conflict type: internal conflicts per state-pair   2023-10-10 15:24:55 2024-07-25 23:14:51     1816-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts per state-pair",
    "numDecimalPlaces": 5
}
 0     number_ongoing_conflicts_per_country_pair__conflict_type_internal grapher/war/2023-09-21/brecke/brecke#number_ongoing_conflicts_per_country_pair__conflict_type_internal 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "internal"
        }
    ],
    "originalName": "Number of ongoing conflicts per state-pair",
    "originalShortName": "number_ongoing_conflicts_per_country_pair"
}
 2 major           The number of conflicts divided by the number of all state-pairs. This accounts for the changing number of states over time.Included are internal conflicts that were ongoing that year.   
[
    "An internal conflict is a conflict between a state and a non-state armed groups, between non-state armed groups, or between an armed group and civilians, that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "We count a conflict as ongoing in a region even if the conflict is also ongoing in other regions. The sum across all regions can therefore be higher than the total number of ongoing conflicts."
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 float 
[]
 34b1039fc865b73dedd0f26dcaa5a354 b2e25a559fe2b433bf09954855fe005c
815276 Number of ongoing conflicts per state - Conflict type: internal conflicts per state   2023-10-10 15:24:55 2024-07-25 23:14:51     1816-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts per state",
    "numDecimalPlaces": 3
}
 0     number_ongoing_conflicts_per_country__conflict_type_internal grapher/war/2023-09-21/brecke/brecke#number_ongoing_conflicts_per_country__conflict_type_internal 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "internal"
        }
    ],
    "originalName": "Number of ongoing conflicts per state",
    "originalShortName": "number_ongoing_conflicts_per_country"
}
 2 major           The number of conflicts divided by the number of all states. This accounts for the changing number of states over time.Included are internal conflicts that were ongoing that year.   
[
    "An internal conflict is a conflict between a state and a non-state armed groups, between non-state armed groups, or between an armed group and civilians, that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "We count a conflict as ongoing in a region even if the conflict is also ongoing in other regions. The sum across all regions can therefore be higher than the total number of ongoing conflicts."
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 float 
[]
 6e24304966c8a91fc8ce95f6efec6974 86f4cd19184aea0c443a2cf0d804f86a
815275 Number of new conflicts per state-pair - Conflict type: all conflicts per state-pair   2023-10-10 15:24:54 2024-07-25 23:14:51     1816-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts per state-pair",
    "numDecimalPlaces": 5
}
 0     number_new_conflicts_per_country_pair__conflict_type_all grapher/war/2023-09-21/brecke/brecke#number_new_conflicts_per_country_pair__conflict_type_all 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "all"
        }
    ],
    "originalName": "Number of new conflicts per state-pair",
    "originalShortName": "number_new_conflicts_per_country_pair"
}
 2 major           The number of conflicts divided by the number of all state-pairs. This accounts for the changing number of states over time.Included are armed conflicts that were ongoing that year.   
[
    "Brecke seeks to include only political disagreements between organized groups, or between an organized group and civilians, that cause at least 32 deaths during a year. This definition tries to exclude interpersonal and criminal violence.\n\n",
    "We count a conflict as new in a region even if the conflict also starts in other regions. The sum across all regions can therefore be higher than the total number of new conflicts.\n"
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 float 
[]
 906d3b900d6bae77b2d70dc447d17f1d b5e73c88d3f682f50133711cbb41090c
815274 Number of new conflicts per state - Conflict type: all conflicts per state   2023-10-10 15:24:54 2024-07-25 23:14:50     1816-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts per state",
    "numDecimalPlaces": 3
}
 0     number_new_conflicts_per_country__conflict_type_all grapher/war/2023-09-21/brecke/brecke#number_new_conflicts_per_country__conflict_type_all 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "all"
        }
    ],
    "originalName": "Number of new conflicts per state",
    "originalShortName": "number_new_conflicts_per_country"
}
 2 major           The number of conflicts divided by the number of all states. This accounts for the changing number of states over time.Included are armed conflicts that were ongoing that year.   
[
    "Brecke seeks to include only political disagreements between organized groups, or between an organized group and civilians, that cause at least 32 deaths during a year. This definition tries to exclude interpersonal and criminal violence.\n\n",
    "We count a conflict as new in a region even if the conflict also starts in other regions. The sum across all regions can therefore be higher than the total number of new conflicts.\n"
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 float 
[]
 cf4531cf0ada4e8066e0f03be4a020b2 16995a77e94f1735304753f4f9ed89fa
815273 Number of ongoing conflicts per state-pair - Conflict type: all conflicts per state-pair   2023-10-10 15:24:54 2024-07-25 23:14:50     1816-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts per state-pair",
    "numDecimalPlaces": 5
}
 0     number_ongoing_conflicts_per_country_pair__conflict_type_all grapher/war/2023-09-21/brecke/brecke#number_ongoing_conflicts_per_country_pair__conflict_type_all 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "all"
        }
    ],
    "originalName": "Number of ongoing conflicts per state-pair",
    "originalShortName": "number_ongoing_conflicts_per_country_pair"
}
 2 major           The number of conflicts divided by the number of all state-pairs. This accounts for the changing number of states over time.Included are armed conflicts that were ongoing that year.   
[
    "Brecke seeks to include only political disagreements between organized groups, or between an organized group and civilians, that cause at least 32 deaths during a year. This definition tries to exclude interpersonal and criminal violence.\n\n",
    "We count a conflict as ongoing in a region even if the conflict is also ongoing in other regions. The sum across all regions can therefore be higher than the total number of ongoing conflicts."
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 float 
[]
 f1891457f3ba091c8bc8433a3e1c95f3 97d12fca13929c24b56af8e0c22ff0ea
815272 Number of ongoing conflicts per state - Conflict type: all conflicts per state   2023-10-10 15:24:54 2024-07-25 23:14:50     1816-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts per state",
    "numDecimalPlaces": 3
}
 0     number_ongoing_conflicts_per_country__conflict_type_all grapher/war/2023-09-21/brecke/brecke#number_ongoing_conflicts_per_country__conflict_type_all 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "all"
        }
    ],
    "originalName": "Number of ongoing conflicts per state",
    "originalShortName": "number_ongoing_conflicts_per_country"
}
 2 major           The number of conflicts divided by the number of all states. This accounts for the changing number of states over time.Included are armed conflicts that were ongoing that year.   
[
    "Brecke seeks to include only political disagreements between organized groups, or between an organized group and civilians, that cause at least 32 deaths during a year. This definition tries to exclude interpersonal and criminal violence.\n\n",
    "We count a conflict as ongoing in a region even if the conflict is also ongoing in other regions. The sum across all regions can therefore be higher than the total number of ongoing conflicts."
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 float 
[]
 8dd373b21a964f756eeed1a1856832a3 c81a1c8f26444d549f574c15cf0f4730
812667 Deaths in ongoing conflicts - Conflict type: interstate deaths   2023-09-22 07:50:02 2024-07-25 23:14:51     1400-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "deaths",
    "numDecimalPlaces": 0
}
 0     number_deaths_ongoing_conflicts__conflict_type_interstate grapher/war/2023-09-21/brecke/brecke#number_deaths_ongoing_conflicts__conflict_type_interstate 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "interstate"
        }
    ],
    "originalName": "Deaths in ongoing conflicts",
    "originalShortName": "number_deaths_ongoing_conflicts"
}
 2 major           The estimated number of deaths in ongoing interstate conflicts that year.   
[
    "The data has been collated from a range of historical studies by the political scientist Peter Brecke.",
    "An interstate conflict is a conflict between states that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "His data seeks to include combatant and civilian deaths, counting both direct deaths, due to fighting, and indirect deaths due to disease and starvation.",
    "The value of this data lies in giving us some insight into conflicts over the very long-run. But there are important limitations. The historical studies on which this data relies vary greatly in terms of how deaths are counted and the reliability of the estimates. Moreover, as Brecke makes clear, the data he has been able to collect provides an incomplete record \u2013 particularly for the distant past and outside of Europe."
]
 Brecke's catalog provides data per conflict. In order to create an annual time series, we sum the deaths recorded in each year across all conflicts, distributing deaths evenly across the duration of conflicts lasting more than one year. The catalog includes many conflicts for which Brecke was unable to find a deaths estimate. Given Brecke's stated definition of a conflict – political disagreements between organized groups, or between an organized group and civilians, that cause at least 32 deaths during a year – we assign such conflicts 32 deaths when creating the time series.     
{
    "selectedEntityNames": [
        "World"
    ]
}
 int 
[]
 49e463da038fcc78e04b595ee80809b5 5e96376998d31f52cdefc7d5f7c245ea
812666 Number of ongoing conflicts - Conflict type: interstate conflicts   2023-09-22 07:50:02 2024-07-25 23:14:51     1400-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts",
    "numDecimalPlaces": 0
}
 0     number_ongoing_conflicts__conflict_type_interstate grapher/war/2023-09-21/brecke/brecke#number_ongoing_conflicts__conflict_type_interstate 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "interstate"
        }
    ],
    "originalName": "Number of ongoing conflicts",
    "originalShortName": "number_ongoing_conflicts"
}
 2 major           Included are interstate conflicts that were ongoing that year.   
[
    "An interstate conflict is a conflict between states that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "We count a conflict as ongoing in a region even if the conflict is also ongoing in other regions. The sum across all regions can therefore be higher than the total number of ongoing conflicts."
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 int 
[]
 a5e975691c6a97caba09cabb9adeb878 432da7c4ca29919726c0381b165d0980
812665 Number of new conflicts - Conflict type: internal conflicts   2023-09-22 07:50:02 2024-07-25 23:14:51     1400-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts",
    "numDecimalPlaces": 0
}
 0     number_new_conflicts__conflict_type_internal grapher/war/2023-09-21/brecke/brecke#number_new_conflicts__conflict_type_internal 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "internal"
        }
    ],
    "originalName": "Number of new conflicts",
    "originalShortName": "number_new_conflicts"
}
 2 major           Included are internal conflicts that were ongoing that year.   
[
    "An internal conflict is a conflict between a state and a non-state armed groups, between non-state armed groups, or between an armed group and civilians, that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "We count a conflict as new in a region even if the conflict started at the same time in another region. The sum across all regions can therefore be higher than the total number of new conflicts.\n"
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 int 
[]
 9f7c130fade5971434efc956a3ae30cd 5e31b91b79139aa2bfa5d9704df80e8d
812645 Number of new conflicts - Conflict type: interstate conflicts   2023-09-22 04:21:56 2024-07-25 23:14:51     1400-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts",
    "numDecimalPlaces": 0
}
 0     number_new_conflicts__conflict_type_interstate grapher/war/2023-09-21/brecke/brecke#number_new_conflicts__conflict_type_interstate 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "interstate"
        }
    ],
    "originalName": "Number of new conflicts",
    "originalShortName": "number_new_conflicts"
}
 2 major           Included are interstate conflicts that were ongoing that year.   
[
    "An interstate conflict is a conflict between states that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "We count a conflict as new in a region even if the conflict started at the same time in another region. The sum across all regions can therefore be higher than the total number of new conflicts.\n"
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 int 
[]
 1c7b323a4505cb53b72b1a0380f0d8b5 4e3ffd8d6a25b34877d92feb29f14d7f
812641 Deaths in ongoing conflicts - Conflict type: internal deaths   2023-09-22 04:21:56 2024-07-25 23:14:51     1400-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "deaths",
    "numDecimalPlaces": 0
}
 0     number_deaths_ongoing_conflicts__conflict_type_internal grapher/war/2023-09-21/brecke/brecke#number_deaths_ongoing_conflicts__conflict_type_internal 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "internal"
        }
    ],
    "originalName": "Deaths in ongoing conflicts",
    "originalShortName": "number_deaths_ongoing_conflicts"
}
 2 major           The estimated number of deaths in ongoing internal conflicts that year.   
[
    "The data has been collated from a range of historical studies by the political scientist Peter Brecke.",
    "An internal conflict is a conflict between a state and a non-state armed groups, between non-state armed groups, or between an armed group and civilians, that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "His data seeks to include combatant and civilian deaths, counting both direct deaths, due to fighting, and indirect deaths due to disease and starvation.",
    "The value of this data lies in giving us some insight into conflicts over the very long-run. But there are important limitations. The historical studies on which this data relies vary greatly in terms of how deaths are counted and the reliability of the estimates. Moreover, as Brecke makes clear, the data he has been able to collect provides an incomplete record \u2013 particularly for the distant past and outside of Europe."
]
 Brecke's catalog provides data per conflict. In order to create an annual time series, we sum the deaths recorded in each year across all conflicts, distributing deaths evenly across the duration of conflicts lasting more than one year. The catalog includes many conflicts for which Brecke was unable to find a deaths estimate. Given Brecke's stated definition of a conflict – political disagreements between organized groups, or between an organized group and civilians, that cause at least 32 deaths during a year – we assign such conflicts 32 deaths when creating the time series.     
{
    "selectedEntityNames": [
        "World"
    ]
}
 int 
[]
 b5c2149d41313423ff23edc77bf60b56 cdaa8a0262d3475b15f0ab4c8e0539be
812640 Number of ongoing conflicts - Conflict type: internal conflicts   2023-09-22 04:21:56 2024-07-25 23:14:51     1400-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts",
    "numDecimalPlaces": 0
}
 0     number_ongoing_conflicts__conflict_type_internal grapher/war/2023-09-21/brecke/brecke#number_ongoing_conflicts__conflict_type_internal 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "internal"
        }
    ],
    "originalName": "Number of ongoing conflicts",
    "originalShortName": "number_ongoing_conflicts"
}
 2 major           Included are internal conflicts that were ongoing that year.   
[
    "An internal conflict is a conflict between a state and a non-state armed groups, between non-state armed groups, or between an armed group and civilians, that causes at least 32 deaths during a year.\n\n",
    "We identify interstate conflicts in the Conflict Catalog using the approach by Seshat (while correcting any mistakes for the 200 deadliest conflicts): https://web.archive.org/web/20230606184656/https://seshatdatabank.info/cleaning-history-data-the-conflict-catalogue/\n",
    "We count a conflict as ongoing in a region even if the conflict is also ongoing in other regions. The sum across all regions can therefore be higher than the total number of ongoing conflicts."
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 int 
[]
 fc6a83db13167aee4c0c17a832cb175d 778e9d51b7062567aec3229beee2debe
812639 Number of new conflicts - Conflict type: all conflicts   2023-09-22 04:21:55 2024-07-25 23:14:50     1400-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts",
    "numDecimalPlaces": 0
}
 0     number_new_conflicts__conflict_type_all grapher/war/2023-09-21/brecke/brecke#number_new_conflicts__conflict_type_all 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "all"
        }
    ],
    "originalName": "Number of new conflicts",
    "originalShortName": "number_new_conflicts"
}
 2 major           Included are armed conflicts that were ongoing that year.   
[
    "Brecke seeks to include only political disagreements between organized groups, or between an organized group and civilians, that cause at least 32 deaths during a year. This definition tries to exclude interpersonal and criminal violence.\n\n",
    "We count a conflict as new in a region even if the conflict also starts in other regions. The sum across all regions can therefore be higher than the total number of new conflicts.\n"
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 int 
[]
 0f75f1db7e6dbc0e5150290a233b1182 581e1ea9afc99c8639e1942d013a5d1e
812638 Deaths in ongoing conflicts - Conflict type: all deaths   2023-09-22 04:21:55 2024-07-25 23:14:50     1400-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "deaths",
    "numDecimalPlaces": 0
}
 0     number_deaths_ongoing_conflicts__conflict_type_all grapher/war/2023-09-21/brecke/brecke#number_deaths_ongoing_conflicts__conflict_type_all 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "all"
        }
    ],
    "originalName": "Deaths in ongoing conflicts",
    "originalShortName": "number_deaths_ongoing_conflicts"
}
 2 major           The estimated number of deaths in ongoing armed conflicts that year.   
[
    "The data has been collated from a range of historical studies by the political scientist Peter Brecke.",
    "Brecke seeks to include only political disagreements between organized groups, or between an organized group and civilians, that cause at least 32 deaths during a year. This definition tries to exclude interpersonal and criminal violence.\n\n",
    "His data seeks to include combatant and civilian deaths, counting both direct deaths, due to fighting, and indirect deaths due to disease and starvation.",
    "The value of this data lies in giving us some insight into conflicts over the very long-run. But there are important limitations. The historical studies on which this data relies vary greatly in terms of how deaths are counted and the reliability of the estimates. Moreover, as Brecke makes clear, the data he has been able to collect provides an incomplete record \u2013 particularly for the distant past and outside of Europe."
]
 Brecke's catalog provides data per conflict. In order to create an annual time series, we sum the deaths recorded in each year across all conflicts, distributing deaths evenly across the duration of conflicts lasting more than one year. The catalog includes many conflicts for which Brecke was unable to find a deaths estimate. Given Brecke's stated definition of a conflict – political disagreements between organized groups, or between an organized group and civilians, that cause at least 32 deaths during a year – we assign such conflicts 32 deaths when creating the time series.     
{
    "selectedEntityNames": [
        "World"
    ]
}
 int 
[]
 12e45e7d3df7ce79eb383bf475c3fcd1 07e706935d60f88a0a808054a4024feb
812637 Number of ongoing conflicts - Conflict type: all conflicts   2023-09-22 04:21:55 2024-07-25 23:14:50     1400-2000 History of war (Brecke, 1999) 6224     
{
    "unit": "conflicts",
    "numDecimalPlaces": 0
}
 0     number_ongoing_conflicts__conflict_type_all grapher/war/2023-09-21/brecke/brecke#number_ongoing_conflicts__conflict_type_all 
{
    "filters": [
        {
            "name": "conflict_type",
            "value": "all"
        }
    ],
    "originalName": "Number of ongoing conflicts",
    "originalShortName": "number_ongoing_conflicts"
}
 2 major           Included are armed conflicts that were ongoing that year.   
[
    "Brecke seeks to include only political disagreements between organized groups, or between an organized group and civilians, that cause at least 32 deaths during a year. This definition tries to exclude interpersonal and criminal violence.\n\n",
    "We count a conflict as ongoing in a region even if the conflict is also ongoing in other regions. The sum across all regions can therefore be higher than the total number of ongoing conflicts."
]
       
{
    "selectedEntityNames": [
        "Africa",
        "Americas",
        "Asia and Oceania",
        "Europe",
        "Middle East"
    ]
}
 int 
[]
 1797983ac4aab824343bda17db309b9c 617fc3a35979ef0f0e3d0275dc5264db

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "variables" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(750) NULL  ,
	"unit" VARCHAR(255) NOT NULL  ,
	"description" TEXT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"code" VARCHAR(255) NULL  ,
	"coverage" VARCHAR(255) NOT NULL  ,
	"timespan" VARCHAR(255) NOT NULL  ,
	"datasetId" INTEGER NOT NULL  ,
	"sourceId" INTEGER NULL  ,
	"shortUnit" VARCHAR(255) NULL  ,
	"display" TEXT NOT NULL  ,
	"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
	"originalMetadata" TEXT NULL  ,
	"grapherConfigAdmin" TEXT NULL  ,
	"shortName" VARCHAR(255) NULL  ,
	"catalogPath" VARCHAR(767) NULL  ,
	"dimensions" TEXT NULL  ,
	"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
	"processingLevel" VARCHAR(30) NULL  ,
	"processingLog" TEXT NULL  ,
	"titlePublic" VARCHAR(512) NULL  ,
	"titleVariant" VARCHAR(255) NULL  ,
	"attributionShort" VARCHAR(512) NULL  ,
	"attribution" TEXT NULL  ,
	"descriptionShort" TEXT NULL  ,
	"descriptionFromProducer" TEXT NULL  ,
	"descriptionKey" TEXT NULL  ,
	"descriptionProcessing" TEXT NULL  ,
	"licenses" TEXT NULL  ,
	"license" TEXT NULL  ,
	"grapherConfigETL" TEXT NULL  ,
	"type" TEXT NULL  ,
	"sort" TEXT NULL  ,
	"dataChecksum" VARCHAR(64) NULL  ,
	"metadataChecksum" VARCHAR(64) NULL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");