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 = 942 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
6801 Violent Discipline - UNICEF Global Databases (2016) 
{
    "link": "https://data.unicef.org/topic/child-protection/violence/violent-discipline/",
    "retrievedDate": "29/09/2017",
    "additionalInfo": "\u2013 The source notes that in some instances observations differ from the standard definition or refer to only part of a country. \r\n\r\n\u2013 The dates associated to each observation correspond to the end of the survey used as underlying source \r\n\r\n\u2013 Most estimates come from the Multiple Indicator Cluster Surveys (MICS). The MICS include a standard set of questions covering different disciplinary methods. It does allow survey respondents to report both violent and nonviolent forms of discipline.\r\n\r\n\u2013The source notes that estimates reported in UNICEF publications and in MICS country reports prior to 2010 were calculated using household weights that did not take into account the last-stage selection of children for the administration of the child discipline module in MICS surveys. (A random selection of one child aged 2\u201314 is undertaken for the administration of the child discipline module.) In January 2010, it was decided that more accurate estimates are produced by using a household weight that takes the last-stage selection into account. MICS3 data were recalculated using this approach. All estimates produced after 2010 use the revised estimates.\r\n\r\n\u2013 When it was first implemented in MICS3, the child discipline module was administered only to mothers/primary caregivers, who were asked whether any of the disciplinary methods covered in the module had been used by any member of the household during the month preceding the interview. Beginning with MICS4, the methodology was changed: Any adult household member, not just the mother or primary caregiver, can now respond to the questions on child discipline.",
    "dataPublishedBy": "UNICEF; Data and Analytics Section; Division of Data, Research and Policy",
    "dataPublisherSource": "DHS, MICS and other nationally representative surveys."
}
 2017-09-29 17:49:59 2017-11-27 14:06:58 Violent discipline – UNICEF (2017) 942 – The source notes that in some instances observations differ from the standard definition or refer to only part of a country. – The dates associated to each observation correspond to the end of the survey used as underlying source – Most estimates come from the Multiple Indicator Cluster Surveys (MICS). The MICS include a standard set of questions covering different disciplinary methods. It does allow survey respondents to report both violent and nonviolent forms of discipline. –The source notes that estimates reported in UNICEF publications and in MICS country reports prior to 2010 were calculated using household weights that did not take into account the last-stage selection of children for the administration of the child discipline module in MICS surveys. (A random selection of one child aged 2–14 is undertaken for the administration of the child discipline module.) In January 2010, it was decided that more accurate estimates are produced by using a household weight that takes the last-stage selection into account. MICS3 data were recalculated using this approach. All estimates produced after 2010 use the revised estimates. – When it was first implemented in MICS3, the child discipline module was administered only to mothers/primary caregivers, who were asked whether any of the disciplinary methods covered in the module had been used by any member of the household during the month preceding the interview. Beginning with MICS4, the methodology was changed: Any adult household member, not just the mother or primary caregiver, can now respond to the questions on child discipline. https://data.unicef.org/topic/child-protection/violence/violent-discipline/ UNICEF; Data and Analytics Section; Division of Data, Research and Policy

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