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 = 3273 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
16777 World Bank, PovcalNet (2021) 
{
    "link": "http://iresearch.worldbank.org/PovcalNet/povDuplicateWB.aspx",
    "retrievedDate": "20/03/2021",
    "additionalInfo": "Estimates of the number of people living below different poverty lines have been obtained using the Povcal online tool (version released 16th March 2021).\n\nTo calculate the number of people between two poverty lines we subtracted estimates of the number of people under the lower line from the number under the higher line. To calculate the number of people above a poverty line we subtracted the estimated number below that line from the total population (as reported within the Povcal database).",
    "dataPublishedBy": "Our World in Data based on 'PovcalNet: the online tool for poverty measurement developed by the Development Research Group of the World Bank'",
    "dataPublisherSource": "World Bank, PovcalNet. Data are based on primary household survey data obtained from government statistical agencies and World Bank country departments."
}
 2019-04-19 22:33:40 2019-04-19 22:33:40 Distribution of population between different poverty thresholds (World Bank, PovcalNet (2021)) 3273 Estimates of the number of people living below different poverty lines have been obtained using the Povcal online tool (version released 16th March 2021). To calculate the number of people between two poverty lines we subtracted estimates of the number of people under the lower line from the number under the higher line. To calculate the number of people above a poverty line we subtracted the estimated number below that line from the total population (as reported within the Povcal database). http://iresearch.worldbank.org/PovcalNet/povDuplicateWB.aspx Our World in Data based on 'PovcalNet: the online tool for poverty measurement developed by the Development Research Group of the World Bank'

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