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 = 228 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
194 Extreme Poverty in absolute numbers - Ravallion (2016) updated with World Bank (2019) 
{
    "retrievedDate": "01/02/2016",
    "additionalInfo": "According to the 'International Poverty Line' set by the United Nations people are considered to live in extreme poverty when living on less than 1.90 international-$ per day. International $ are adjusted for price differences between countries and for price changes over time (inflation).\n\nThis visualization can be found in Ravallion (2016) \u2013 The Economics of Poverty: History, Measurement, and Policy. Oxford University Press. 28 January 2016. 736 Pages.\n\nWe have updated the visualization from Ravallion (2016) using the same sources the author relies on: Bourguignon and Morrison (2002) for the historical estimates and the World Bank for data from 1981 onwards. \n\nAll poverty estimates 1981 and later are taken from the World Bank's Povcal Net: iresearch.worldbank.org/PovcalNet/ (downloaded in February 2019).\nAll data from 1980 and earlier is taken from Bourguignon and Morrisson (2002) \u2013 Inequality Among World Citizens: 1820\u20131992. In American Economic Review, 92, 4, 727\u2013748. Bourguignon and Morrisson (2002) state that 'the poverty lines were calibrated so that poverty and extreme poverty headcounts in 1992 coincided roughly with estimates from other sources\u2019; here we rely on the midpoint of the two series published by Bourguignon and Morrison. \n\nThe absolute number of the world population is taken from the OurWorldInData world population data set: https://ourworldindata.org/world-population-growth. ",
    "dataPublishedBy": "Ravallion (2016) updated with World Bank (2019)",
    "dataPublisherSource": "World Bank and Bourguignon and Morrisson (2002)"
}
 2016-05-23 18:39:36 2017-11-15 15:43:42 Extreme Poverty in absolute numbers - Ravallion (2016) updated with World Bank (2019) 228 According to the 'International Poverty Line' set by the United Nations people are considered to live in extreme poverty when living on less than 1.90 international-$ per day. International $ are adjusted for price differences between countries and for price changes over time (inflation). This visualization can be found in Ravallion (2016) – The Economics of Poverty: History, Measurement, and Policy. Oxford University Press. 28 January 2016. 736 Pages. We have updated the visualization from Ravallion (2016) using the same sources the author relies on: Bourguignon and Morrison (2002) for the historical estimates and the World Bank for data from 1981 onwards. All poverty estimates 1981 and later are taken from the World Bank's Povcal Net: iresearch.worldbank.org/PovcalNet/ (downloaded in February 2019). All data from 1980 and earlier is taken from Bourguignon and Morrisson (2002) – Inequality Among World Citizens: 1820–1992. In American Economic Review, 92, 4, 727–748. Bourguignon and Morrisson (2002) state that 'the poverty lines were calibrated so that poverty and extreme poverty headcounts in 1992 coincided roughly with estimates from other sources’; here we rely on the midpoint of the two series published by Bourguignon and Morrison. The absolute number of the world population is taken from the OurWorldInData world population data set: https://ourworldindata.org/world-population-growth.   Ravallion (2016) updated with World Bank (2019)

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