owid: sources: 1 row where datasetId = 5800 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 = 5800 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
27091	Jolliffe et al. (2022)	{ "link": "https://openknowledge.worldbank.org/handle/10986/37061", "retrievedDate": "2022-10-04", "additionalInfo": "Harmonized national poverty lines, expressed as income or consumption per person per day in 2017 international-$.\n\nAs a part of the process of setting the International Poverty Line used by the UN and the World Bank as its definition of extreme poverty, Jolliffe et al. (2022) created a dataset of the poverty lines adopted nationally in different countries.\n\nOfficial definitions of poverty in different countries are often not directly comparable due to the different ways poverty is measured. For example, countries account for the size of households in different ways in their poverty measures.\n\nThe authors take steps to harmonize national poverty lines, in order to allow for comparisons between these different poverty definitions. They are the poverty line in international-$ which, within the World Bank\u2019s Poverty and Inequality Platform (PIP) data, yields the same poverty rate as the officially reported rate using national definitions in a given year.", "dataPublishedBy": "Jolliffe, D.M., Mahler, D. G., Lakner, C., Atamanov, A., Tetteh-Baah, S. K. (2022). Assessing the Impact of the 2017 PPPs on the International Poverty Line and Global Poverty. Washington, DC: World Bank." }	2022-10-11 12:53:36	2022-10-11 12:53:36	National poverty lines (Jolliffe et al., 2022) 5800	Harmonized national poverty lines, expressed as income or consumption per person per day in 2017 international-$. As a part of the process of setting the International Poverty Line used by the UN and the World Bank as its definition of extreme poverty, Jolliffe et al. (2022) created a dataset of the poverty lines adopted nationally in different countries. Official definitions of poverty in different countries are often not directly comparable due to the different ways poverty is measured. For example, countries account for the size of households in different ways in their poverty measures. The authors take steps to harmonize national poverty lines, in order to allow for comparisons between these different poverty definitions. They are the poverty line in international-$ which, within the World Bank’s Poverty and Inequality Platform (PIP) data, yields the same poverty rate as the officially reported rate using national definitions in a given year.	https://openknowledge.worldbank.org/handle/10986/37061	Jolliffe, D.M., Mahler, D. G., Lakner, C., Atamanov, A., Tetteh-Baah, S. K. (2022). Assessing the Impact of the 2017 PPPs on the International Poverty Line and Global Poverty. Washington, DC: World Bank.

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