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 = 4096 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
16926 World Bank Poverty and Inequality Platform (2022) 
{
    "link": "https://pip.worldbank.org/",
    "retrievedDate": "2022-10-03",
    "additionalInfo": "PIP provides regional aggregate figures for the number of people living below the international poverty line of int-$ 2.15 using 2011 PPPs.\n\nUnfortunately, for certain regions and years the data survey coverage is too low and the results are suppressed.  From 1990 onwards  it is only for South Asia and South Saharan Africa (on different years) that regional estimates are sometimes missing.\n\nFor these years we calculate the number of poor in the region as the difference between the estimated total number of poor across the world and the sum of the number of poor across all other regions.\n\nPrior to 1990 estimates for more than one region are missing, precluding this method.",
    "dataPublishedBy": "World Bank Poverty and Inequality Platform",
    "dataPublisherSource": "World Bank. Data are based on primary household survey data obtained from government statistical agencies and World Bank country departments."
}
 2019-04-24 18:34:37 2023-06-19 14:10:49 Number of people living in extreme poverty, by world region (World Bank PIP) 4096 PIP provides regional aggregate figures for the number of people living below the international poverty line of int-$ 2.15 using 2011 PPPs. Unfortunately, for certain regions and years the data survey coverage is too low and the results are suppressed. From 1990 onwards it is only for South Asia and South Saharan Africa (on different years) that regional estimates are sometimes missing. For these years we calculate the number of poor in the region as the difference between the estimated total number of poor across the world and the sum of the number of poor across all other regions. Prior to 1990 estimates for more than one region are missing, precluding this method. https://pip.worldbank.org/ World Bank Poverty and Inequality Platform

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