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 = 5540 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
21938 UCDP 
{
    "link": "https://ucdp.uu.se/downloads/index.html#ged_global",
    "retrievedDate": "25/02/2022",
    "additionalInfo": "This data counts civilian and military deaths in conflicts and one-sided violence. The data counts only direct violent deaths (i.e. excluding deaths from disease or famine).\n\nIt is based on the UCDP Georeferenced Event Dataset (GED) Global version 21.1. This presents deaths estimates for individual events. We aggregate deaths across years, broken down by conflict/violence type and by region.\n\n\n\n ",
    "dataPublishedBy": "Sundberg, Ralph, and Erik Melander, 2013, \u201cIntroducing the UCDP Georeferenced Event Dataset\u201d, Journal of Peace Research, vol.50, no.4, 523-532",
    "dataPublisherSource": "Global newswire reporting; Global monitoring and translation of local news performed by the BBC; Secondary sources such as local media, NGO and IGO reports, field reports, books etc."
}
 2022-02-26 15:05:59 2022-02-26 15:05:59 Violent deaths in conflicts and one-sided violence since 1989, by region and type of violence (UCDP 2022) 5540 This data counts civilian and military deaths in conflicts and one-sided violence. The data counts only direct violent deaths (i.e. excluding deaths from disease or famine). It is based on the UCDP Georeferenced Event Dataset (GED) Global version 21.1. This presents deaths estimates for individual events. We aggregate deaths across years, broken down by conflict/violence type and by region. https://ucdp.uu.se/downloads/index.html#ged_global 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");