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 = 4176 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
17004 Our World in Data based on UCDP GED, One-sided, Non-state and Battle-related datasets (v19.1) 
{
    "link": "https://ucdp.uu.se/downloads/",
    "retrievedDate": "02/06/2019",
    "additionalInfo": "UCDP (GED) v19.1 provides estimates for direct conflict deaths (i.e. excluding indirect deaths from disease, malnutrition, exposure etc.) of both civilians and military personnel occurring in individual geo-referenced events. Taking the 'best' deaths estimates, we have aggregated these to country-year observations.\n\nUCDP documentation makes it clear that the dataset is intended to have global coverage since 1989, except for the case of Syria. As such, any country-year (as defined by the Gleditsch and Ward system of states) in which no events are recorded in the data were attributed zero deaths, except for Syria in this period.\n\nThe World total figures are not an aggregation of the GED dataset (given the lack of coverage just mentioned). Instead it combines the three non-georeferenced datasets UCDP provides, covering three kinds of violence: One-sided violence, Non-state conflicts and State-based conflicts.\n\nDeath rates are calculated using UN population figures.",
    "dataPublishedBy": "Sundberg, Ralph, and Erik Melander, 2013, \u201cIntroducing the UCDP Georeferenced Event Dataset\u201d, Journal of Peace Research, vol.50, no.4, 523-532"
}
 2019-07-31 10:57:19 2019-07-31 10:57:19 Conflict deaths – UCDP Georeferenced Event Data (2019) 4176 UCDP (GED) v19.1 provides estimates for direct conflict deaths (i.e. excluding indirect deaths from disease, malnutrition, exposure etc.) of both civilians and military personnel occurring in individual geo-referenced events. Taking the 'best' deaths estimates, we have aggregated these to country-year observations. UCDP documentation makes it clear that the dataset is intended to have global coverage since 1989, except for the case of Syria. As such, any country-year (as defined by the Gleditsch and Ward system of states) in which no events are recorded in the data were attributed zero deaths, except for Syria in this period. The World total figures are not an aggregation of the GED dataset (given the lack of coverage just mentioned). Instead it combines the three non-georeferenced datasets UCDP provides, covering three kinds of violence: One-sided violence, Non-state conflicts and State-based conflicts. Death rates are calculated using UN population figures. https://ucdp.uu.se/downloads/ Sundberg, Ralph, and Erik Melander, 2013, “Introducing the UCDP Georeferenced Event Dataset”, Journal of Peace Research, vol.50, no.4, 523-532

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");