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 = 2889 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
15617 Cuaresma et al (2018); OECD (2018); UN (2017) 
{
    "link": "https://dataverse.harvard.edu/dataset.xhtml?persistentId=doi:10.7910/DVN/XS5KQA",
    "retrievedDate": "23/08/2018",
    "additionalInfo": "The poverty projections are based on the Shared Socioeconomic Pathways framework developed at IIASA. In particular these figures relate to SSP2, the baseline scenario employed by Crespo Cuaresma et al. (2018). Population projections from UN World Population Prospects: The 2017 Revision.\n\nThe sources of the fragile states lists are as follows:\nOECD States of Fragility, 2018\nOECD Resource Flows to Fragile and Conflict-Affected States: Annual Report 2008\nWorld Bank 2019 \u2013 FY19 List of fragile situations\nWorld Bank 2009 \u2013 FY09 Fragile States list",
    "dataPublishedBy": "J. Crespo Cuaresma, W. Fengler, H. Kharas et al., 2018. \"Will the Sustainable Development Goals be fulfilled? Assessing present and future global poverty\". Palgrave Communications volume 4, Article number: 29",
    "dataPublisherSource": "Surveys and projections from World Bank, IMF, UNU-WIDER WIID, IIASA, CIA World Factbook"
}
 2018-08-23 11:00:04 2018-08-23 11:09:52 Projected extreme poverty among different groupings of fragile states (Crespo Cuaresma et al, 2018; OECD; World Bank) 2889 The poverty projections are based on the Shared Socioeconomic Pathways framework developed at IIASA. In particular these figures relate to SSP2, the baseline scenario employed by Crespo Cuaresma et al. (2018). Population projections from UN World Population Prospects: The 2017 Revision. The sources of the fragile states lists are as follows: OECD States of Fragility, 2018 OECD Resource Flows to Fragile and Conflict-Affected States: Annual Report 2008 World Bank 2019 – FY19 List of fragile situations World Bank 2009 – FY09 Fragile States list https://dataverse.harvard.edu/dataset.xhtml?persistentId=doi:10.7910/DVN/XS5KQA J. Crespo Cuaresma, W. Fengler, H. Kharas et al., 2018. "Will the Sustainable Development Goals be fulfilled? Assessing present and future global poverty". Palgrave Communications volume 4, Article number: 29

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