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 = 5232 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
17961 OWID based on Maddison Project Database 2020, GCIP, van Zanden et al. (2014), de la Escosura (2012) 
{
    "additionalInfo": "[Provide link to detailed documentation before this is circulated publicly]",
    "dataPublishedBy": "OWID based on Maddison Project Database, version 2020. Global Income and Consumption Project database.  Bolt, Jutta and Jan Luiten van Zanden (2020), \u201cMaddison style estimates of the evolution of the world economy. A new 2020 update \u201d; van Zanden, Jan Luiten van, Joerg Baten, Peter Foldvari, and Bas van Leeuwen. 2014. \u201cThe Changing Shape of Global Inequality 1820\u20132000; Exploring a New Dataset.\u201d Review of Income and Wealth 60 (2): 279\u201397; Prados de la Escosura, Leandro. 2012. \u201cOUTPUT PER HEAD IN PRE-INDEPENDENCE AFRICA: QUANTITATIVE CONJECTURES.\u201d Economic History of Developing Regions 27 (2): 1\u201336. "
}
 2020-12-14 11:10:01 2020-12-14 11:10:01 Reconstruction of historical poverty trends by country, 1820-2017 (OWID based on Maddison Project Database 2020 and van Zanden et al. (2014)) 5232 [Provide link to detailed documentation before this is circulated publicly]   OWID based on Maddison Project Database, version 2020. Global Income and Consumption Project database. Bolt, Jutta and Jan Luiten van Zanden (2020), “Maddison style estimates of the evolution of the world economy. A new 2020 update ”; van Zanden, Jan Luiten van, Joerg Baten, Peter Foldvari, and Bas van Leeuwen. 2014. “The Changing Shape of Global Inequality 1820–2000; Exploring a New Dataset.” Review of Income and Wealth 60 (2): 279–97; Prados de la Escosura, Leandro. 2012. “OUTPUT PER HEAD IN PRE-INDEPENDENCE AFRICA: QUANTITATIVE CONJECTURES.” Economic History of Developing Regions 27 (2): 1–36.

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