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 = 5788 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
27080 World Bank Poverty and Inequality Platform (2022) 
{
    "link": "https://pip.worldbank.org/",
    "retrievedDate": "2022-10-03",
    "additionalInfo": "The Poverty and Inequality Platform (PIP) is an interactive computational tool that offers users quick access to the World Bank\u2019s estimates of poverty, inequality, and shared prosperity. PIP provides a comprehensive view of global, regional, and country-level trends for more than 150 economies around the world.\n\nThis is the 2011 PPPs dataset of PIP, there is also a 2017 PPPs dataset, which is the main PIP dataset at OWID.\n\nVersion 20220909_2011_02_02_PROD\n\nYou can read more information about PIP data and methodology in <a href=\"https://github.com/owid/poverty-data\">GitHub</a>.",
    "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."
}
 2022-09-29 09:35:04 2023-06-19 14:10:33 World Bank Poverty and Inequality Platform (PIP) - 2011 PPPs 5788 The Poverty and Inequality Platform (PIP) is an interactive computational tool that offers users quick access to the World Bank’s estimates of poverty, inequality, and shared prosperity. PIP provides a comprehensive view of global, regional, and country-level trends for more than 150 economies around the world. This is the 2011 PPPs dataset of PIP, there is also a 2017 PPPs dataset, which is the main PIP dataset at OWID. Version 20220909_2011_02_02_PROD You can read more information about PIP data and methodology in <a href="https://github.com/owid/poverty-data">GitHub</a>. 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");