sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 5541 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
21939 OWID based on UCDP/PRIO 
{
    "link": "https://ucdp.uu.se/downloads/index.html#armedconflict",
    "retrievedDate": "25/02/2022",
    "additionalInfo": "This dataset aggregates the number of conflicts per year (by conflict type and region) listed in UCDP/PRIO Armed Conflict Dataset version 21.1.\n\nConflicts within this dataset refer only to 'State-based' conflicts. UCDP defines state-based armed conflict as: \u201ca contested incompatibility that concerns\ngovernment and/or territory where the use of armed force between two parties, of which at least one is the government of a state, results in at least 25 battle-related deaths in a calendar year.\u201d\n\nThe conflict is listed in all years that the 25 deaths threshold is met (but not otherwise).\n\nThe data is organised by year and conflict. We aggregate this to provide the number of conflicts in each year, broken down by the conflict type and region. \nThis dataset runs from 1946 and aims to have global coverage over this period. Accordingly, we add a zero deaths observation for year-region-conflict type combinations that do appear in the dataset.\n\nThe labels for the conflict types we have used paraphrase UCDP/PRIO's technical definitions of 'Extrasystemic', 'Internal', 'Internationalised internal' and 'Interstate'.\n\nNote that in this dataset the location refers not (necessarily) to where fighting and deaths took place, but rather to the location of the 'incompatibility' between the participants that defines the conflict: usually the country or territory whose possession or governance is in dispute.\n",
    "dataPublishedBy": "Gleditsch, Nils Petter; Peter Wallensteen, Mikael Eriksson, Margareta Sollenberg & H\u00e5vard Strand (2002) Armed Conflict 1946\u20132001: A New Dataset. Journal of Peace Research 39(5): 615\u2013637. Pettersson, Therese, Shawn Davis, Amber Deniz, Garoun Engstr\u00f6m, Nanar Hawach, Stina H\u00f6gbladh, Margareta Sollenberg & Magnus \u00d6berg (2021). Organized violence 1989-2020, with a special emphasis on Syria. Journal of Peace Research 58(4)."
}
 2022-02-28 07:48:50 2022-02-28 07:48:50 Number of state-based conflicts, by conflict type and region (UCDP-PRIO) 5541 This dataset aggregates the number of conflicts per year (by conflict type and region) listed in UCDP/PRIO Armed Conflict Dataset version 21.1. Conflicts within this dataset refer only to 'State-based' conflicts. UCDP defines state-based armed conflict as: “a contested incompatibility that concerns government and/or territory where the use of armed force between two parties, of which at least one is the government of a state, results in at least 25 battle-related deaths in a calendar year.” The conflict is listed in all years that the 25 deaths threshold is met (but not otherwise). The data is organised by year and conflict. We aggregate this to provide the number of conflicts in each year, broken down by the conflict type and region. This dataset runs from 1946 and aims to have global coverage over this period. Accordingly, we add a zero deaths observation for year-region-conflict type combinations that do appear in the dataset. The labels for the conflict types we have used paraphrase UCDP/PRIO's technical definitions of 'Extrasystemic', 'Internal', 'Internationalised internal' and 'Interstate'. Note that in this dataset the location refers not (necessarily) to where fighting and deaths took place, but rather to the location of the 'incompatibility' between the participants that defines the conflict: usually the country or territory whose possession or governance is in dispute. https://ucdp.uu.se/downloads/index.html#armedconflict Gleditsch, Nils Petter; Peter Wallensteen, Mikael Eriksson, Margareta Sollenberg & Håvard Strand (2002) Armed Conflict 1946–2001: A New Dataset. Journal of Peace Research 39(5): 615–637. Pettersson, Therese, Shawn Davis, Amber Deniz, Garoun Engström, Nanar Hawach, Stina Högbladh, Margareta Sollenberg & Magnus Öberg (2021). Organized violence 1989-2020, with a special emphasis on Syria. Journal of Peace Research 58(4).

Advanced export

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

CSV options: 

CREATE TABLE "sources" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"name" VARCHAR(512) NULL  ,
	"description" TEXT NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL  ,
	"datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL,
	FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");