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 = 334 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
442 OPHI Multidimensional Poverty Index - Alkire and Robles (2016) 
{
    "link": "http://www.ophi.org.uk/multidimensional-poverty-index/mpi-2015/mpi-data/",
    "retrievedDate": "31/01/2017",
    "additionalInfo": "Definitions\r\n\r\nPeople are considered 'multidimensional poor' if they are deprived in at least one third of the weighted indicators.\r\n\r\nThe ten indicators relate to: Years of Schooling, Child School Attendance, Child Mortality, Nutrition, Electricity, Sanitation, Drinking Water, Floor, Cooking Fuel, Asset Ownership. The first four of these indicators carry a weight of one sixth each (i.e. 0.166). The other six have a weight of one eighteenth each (i.e. 0.055)\r\n\r\nSurvey data\r\n\r\nYears correspond to the year reported for the underlying survey used as source in each country. Whenever surveys correspond to year intervals (e.g. 2011-2012), we display the end year for that interval.\r\n\r\nThe source notes that \"The global MPI was first released in 2010, for 104 developing countries, and has been updated yearly with the latest data available. Starting from winter 2014/2015, updates are now made twice a year, in summer and winter. In June 2015, the Global MPI was updated for 32 countries and 6 new countries have been added to the list of those last reported in 2014. In total it now covers 101 developing countries, using data ranging from 2005 to 2014.\"",
    "dataPublishedBy": "Alkire, S., and Robles, G. (2016) \u201cMultidimensional Poverty Index Winter 2016: Brief methodological note and results.\u201d Oxford Poverty and Human Development Initiative, University of Oxford, OPHI Briefing 44.",
    "dataPublisherSource": "Demographic and Health Survey (DHS), Multiple Indicators Cluster Survey (MICS), and World Health Survey (WHS). Certain countries use special datasets. The source provides MPI data tables listing in full the surveys used for each country."
}
 2017-01-31 23:27:55 2017-11-14 15:02:40 OPHI Multidimensional Poverty Index - Alkire and Robles (2016) 334 Definitions People are considered 'multidimensional poor' if they are deprived in at least one third of the weighted indicators. The ten indicators relate to: Years of Schooling, Child School Attendance, Child Mortality, Nutrition, Electricity, Sanitation, Drinking Water, Floor, Cooking Fuel, Asset Ownership. The first four of these indicators carry a weight of one sixth each (i.e. 0.166). The other six have a weight of one eighteenth each (i.e. 0.055) Survey data Years correspond to the year reported for the underlying survey used as source in each country. Whenever surveys correspond to year intervals (e.g. 2011-2012), we display the end year for that interval. The source notes that "The global MPI was first released in 2010, for 104 developing countries, and has been updated yearly with the latest data available. Starting from winter 2014/2015, updates are now made twice a year, in summer and winter. In June 2015, the Global MPI was updated for 32 countries and 6 new countries have been added to the list of those last reported in 2014. In total it now covers 101 developing countries, using data ranging from 2005 to 2014." http://www.ophi.org.uk/multidimensional-poverty-index/mpi-2015/mpi-data/ Alkire, S., and Robles, G. (2016) “Multidimensional Poverty Index Winter 2016: Brief methodological note and results.” Oxford Poverty and Human Development Initiative, University of Oxford, OPHI Briefing 44.

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