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 = 2991 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
484 Share of the population living in extreme poverty by world region - PovcalNet World Bank 
{
    "link": "http://iresearch.worldbank.org/PovcalNet/povDuplicateWB.aspx",
    "retrievedDate": "13/03/2017",
    "additionalInfo": "The share of population living in extreme poverty by world region is calculated dividing the absolute number of people living in extreme poverty by the population living in the region.\n\nTo calculate the share of population living in extreme poverty at world level OWID team uses the total world population, not the sum of the 6 regions. In fact, as explained below, the six world regions do not take into account high-income countries.\nPovcalNet provides regional aggregation using 2011 PPPs and $1.90/day poverty line for reference years 1987, 1990, 1993, 1996, 1999, 2002, 2005, 2008, 2010, 2011, 2012 and 2013.\nUnfortunately, for certain regions and years the data survey coverage is too low and the results are suppressed. Therefore, OWID team calculated the number of the missing variable subtracting the sum of the observed regions from the World Total. For example, dis-aggregated data is not available for Middle East and North Africa (MENA) in 2013:\n\nMENA 2013 = World Total - (East Asia and Pacific + Europe and Central Asia + Latin America and the Caribbean + South Asia + Sub-Saharan Africa).\n\nWarning:\nThe most recent figures from the MENA reason do not necessarily reflect the geopolitical turmoil in the region.\n\nHigh-income countries are not included in PovcalNet tables used for this calculations.",
    "dataPublishedBy": "OWID team's own calculations based on PovcalNet : the on-line tool for poverty measurement developed by the Development Research Group of the World Bank",
    "dataPublisherSource": "World Bank, Development Research Group.\u00a0Data are based on primary household survey data obtained from government statistical agencies and World Bank country departments."
}
 2017-03-14 04:44:10 2017-11-02 13:04:39 Share of population living in extreme poverty by region (PovcalNet (World Bank) (2017)) (split) 2991 The share of population living in extreme poverty by world region is calculated dividing the absolute number of people living in extreme poverty by the population living in the region. To calculate the share of population living in extreme poverty at world level OWID team uses the total world population, not the sum of the 6 regions. In fact, as explained below, the six world regions do not take into account high-income countries. PovcalNet provides regional aggregation using 2011 PPPs and $1.90/day poverty line for reference years 1987, 1990, 1993, 1996, 1999, 2002, 2005, 2008, 2010, 2011, 2012 and 2013. Unfortunately, for certain regions and years the data survey coverage is too low and the results are suppressed. Therefore, OWID team calculated the number of the missing variable subtracting the sum of the observed regions from the World Total. For example, dis-aggregated data is not available for Middle East and North Africa (MENA) in 2013: MENA 2013 = World Total - (East Asia and Pacific + Europe and Central Asia + Latin America and the Caribbean + South Asia + Sub-Saharan Africa). Warning: The most recent figures from the MENA reason do not necessarily reflect the geopolitical turmoil in the region. High-income countries are not included in PovcalNet tables used for this calculations. http://iresearch.worldbank.org/PovcalNet/povDuplicateWB.aspx OWID team's own calculations based on PovcalNet : the on-line 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");