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 = 324 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
432 Global education (OECD + IIASA (2016)) 
{
    "link": "http://www.oecd.org/statistics/how-was-life-9789264214262-en.htm",
    "retrievedDate": "14/12/2016",
    "additionalInfo": "The series shows the share of the global population (older than 15) with at least basic education. The data for 1820 to 1960 is taken from the OECD (2014). The series measures the percentage of population aged over 15 enrolled in formal education. The estimate for 1820 is labelled a \u2019Best Guess' in the OECD publication and should be considered as such.\nThe data for 1970 and later is taken from the Wittgenstein Centre for Demography and Global Human Capital (2015). It shows the share of the population (older than 15 years) that has attained at least some basic education.",
    "dataPublishedBy": "Our World in Data based on IIASA and OECD",
    "dataPublisherSource": "OECD (2014) \u2013 How Was Life? - Global Well-being since 1820\nThe Wittgenstein Centre data was obtained through the \u2018Wittgenstein Centre Data Explorer Version 1.2.\u2019 The data for 2015 is a projection (Medium projection)."
}
 2016-12-14 22:43:04 2017-11-02 13:04:39 Global education (OECD + IIASA (2016)) 324 The series shows the share of the global population (older than 15) with at least basic education. The data for 1820 to 1960 is taken from the OECD (2014). The series measures the percentage of population aged over 15 enrolled in formal education. The estimate for 1820 is labelled a ’Best Guess' in the OECD publication and should be considered as such. The data for 1970 and later is taken from the Wittgenstein Centre for Demography and Global Human Capital (2015). It shows the share of the population (older than 15 years) that has attained at least some basic education. http://www.oecd.org/statistics/how-was-life-9789264214262-en.htm Our World in Data based on IIASA and OECD

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