owid: sources: 1 row where datasetId = 236 sorted by id descending

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 = 236 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
202	Bourguignon and Morrison (2002) and World Bank (PovcalNet) (2015)	{ "link": "https://www.aeaweb.org/articles?id=10.1257/00028280260344443 and https://data.worldbank.org/", "retrievedDate": "01/10/2015", "additionalInfo": "The share of people of living in poverty and extreme poverty is taken from Bourguignon and Morrison (2002), and \u2018the poverty lines were calibrated so that poverty and extreme poverty headcounts in 1992 coincided roughly with estimates from other sources\u2019. And in footnote they say \u2018these definitions correspond to poverty lines equal to consumption per capita of $2 and $1 a day, expressed in 1985 PPP.\u2019\r\n\r\nTo this I added the share of people living living below the international poverty line which, since the revision in 2015, is $1.90 at 2011 purchasing-power parity (PPP). The revisions in the definition of the poverty line and the PPP adjustment make the poverty figures in levels not comparable to earlier data \u2013 to illustrate this I have plotted both series for the time from 1981 to 1992. The World Bank data was downloaded in October 2015.", "dataPublishedBy": "The author of this data set (Max Roser) combined two sources: World Bank PovcalNet data post 1981. And for all previous data Bourguignon and Morrison (2002) \u2013 Inequality Among World Citizens: 1820\u20131992. In American Economic Review, 92, 4, 727\u2013744. ", "dataPublisherSource": "Scholarly work, census data." }	2016-06-01 04:38:16	2017-11-14 14:31:15	Bourguignon and Morrison (2002) and World Bank (PovcalNet) (2015) 236	The share of people of living in poverty and extreme poverty is taken from Bourguignon and Morrison (2002), and ‘the poverty lines were calibrated so that poverty and extreme poverty headcounts in 1992 coincided roughly with estimates from other sources’. And in footnote they say ‘these definitions correspond to poverty lines equal to consumption per capita of $2 and $1 a day, expressed in 1985 PPP.’ To this I added the share of people living living below the international poverty line which, since the revision in 2015, is $1.90 at 2011 purchasing-power parity (PPP). The revisions in the definition of the poverty line and the PPP adjustment make the poverty figures in levels not comparable to earlier data – to illustrate this I have plotted both series for the time from 1981 to 1992. The World Bank data was downloaded in October 2015.	https://www.aeaweb.org/articles?id=10.1257/00028280260344443 and https://data.worldbank.org/	The author of this data set (Max Roser) combined two sources: World Bank PovcalNet data post 1981. And for all previous data Bourguignon and Morrison (2002) – Inequality Among World Citizens: 1820–1992. In American Economic Review, 92, 4, 727–744.

Advanced export

JSON shape: default, array, newline-delimited, object

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