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 = 1872 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
13880 Know Violence in Childhood Report (2017) 
{
    "link": "http://globalreport.knowviolenceinchildhood.org/the-report/",
    "retrievedDate": "5/12/2017",
    "additionalInfo": null,
    "dataPublishedBy": "Know Violence in Childhood",
    "dataPublisherSource": " Corporal punishment (home): UNICEF global databases, 2016, based on DHS, MICS and other nationally representative surveys, 2005-2015. (2) Bullying and physical fights (school): HBSC, 2009/2010 and GSHS, 2003-2013. (3) Physical and sexual violence against adolescent girls: UNICEF global databases, 2016, based on DHS, MICS and other nationally representative surveys, 2004-2015. (4) Child homicide rate: Data on homicide rates are from World Health Organization, Global Health Estimates (GHE) Summary Tables: Death by cause, age, sex and region, 2012. WHO,\u00a0Geneva,\u00a02014. (5) Violence against women: United Nations, 2015. The World's Women 2015: Trends and Statistics. New York: United Nations, Department of Economic and Social Affairs, Statistics Division.\u00a0Sales No. E.15.XVII.8, Statistical Annex."
}
 2017-12-05 16:00:21 2017-12-05 16:00:21 Child violence – Ending Violence in Childhood Report (2017) 1872   http://globalreport.knowviolenceinchildhood.org/the-report/ Know Violence in Childhood

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