sources

Data license: CC-BY

1 row where datasetId = 2979 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

{
    "link": "http://www.systemicpeace.org/inscrdata.html",
    "retrievedDate": "29/09/2015",
    "additionalInfo": "Death magnitude is a non-linear measure, please see the codebook for further details. For countries that experienced multiple episodes of genocide during the period, the midpoint is taking and summed to calculate the total death magnitude variable. Countries with multiple episodes of genocide include: Angola, Burundi, China, Indonesia, Iraq, Rwanda, Sri Lanka, Sudan, Uganda and the Democratic Republic of Congo.",
    "dataPublishedBy": "Integrated Network for Societal Conflict Research",
    "dataPublisherSource": "Political Instability Task Force (PITF)"
}

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