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 = 2982 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
388 Global literacy since 1800 (OWID based on OECD & UNESCO (2019)) 
{
    "retrievedDate": "1st February 2019",
    "additionalInfo": "Global literacy series was compiled by Our World in Data from 1800 based on multiple sources. This is based on adult literacy rates (of those aged 15+ years old).\n\nData from 1820 to 1940 was based on estimates from the \"OECD (2014) \u2013 How Was Life? \u2013 Global Well-being since 1820.\" Available at: https://www.oecd-ilibrary.org/economics/how-was-life_9789264214262-en. The data point for 1820 has also been assumed for the year 1800.\n\n1950-1970 estimates sourced from: UNESCO. 1972. Literacy 1969-1971. Progress Achieved in Literacy throughout the World. Paris: UNESCO (https://unesdoc.unesco.org/in/rest/annotationSVC/DownloadWatermarkedAttachment/attach_import_c0206949-c3f1-4eac-a189-9c5bcfdac220?_=001736engo.pdf)\n\n1980-2000 estimates sourced from: Carr-Hill, R., & Pessoa, J. (2008). International literacy statistics: A review of concepts, methodology and current data. Montreal: UNESCO Institute for Statistics. Available at: http://uis.unesco.org/sites/default/files/documents/international-literacy-statistics-a-review-of-concepts-methodology-and-current-data-en_0.pdf \n\nAnd: UNESCO Institute for Statistics. (2013). Adult and youth literacy: National, regional and global trends, 1985\u20132015. Available at: http://uis.unesco.org/sites/default/files/documents/adult-and-youth-literacy-national-regional-and-global-trends-1985-2015-en_0.pdf\n\n2012-2016 estimates sourced from: UNESCO Statistics (http://data.uis.unesco.org/index.aspx?queryid=166&lang=en).",
    "dataPublishedBy": "Data compiled by Our World in Data based on OECD - How was Life? (2014) & UNESCO Reports"
}
 2017-10-01 15:54:20 2017-11-02 13:04:39 Global literacy since 1800 (OWID based on OECD & UNESCO (2019)) 2982 Global literacy series was compiled by Our World in Data from 1800 based on multiple sources. This is based on adult literacy rates (of those aged 15+ years old). Data from 1820 to 1940 was based on estimates from the "OECD (2014) – How Was Life? – Global Well-being since 1820." Available at: https://www.oecd-ilibrary.org/economics/how-was-life_9789264214262-en. The data point for 1820 has also been assumed for the year 1800. 1950-1970 estimates sourced from: UNESCO. 1972. Literacy 1969-1971. Progress Achieved in Literacy throughout the World. Paris: UNESCO (https://unesdoc.unesco.org/in/rest/annotationSVC/DownloadWatermarkedAttachment/attach_import_c0206949-c3f1-4eac-a189-9c5bcfdac220?_=001736engo.pdf) 1980-2000 estimates sourced from: Carr-Hill, R., & Pessoa, J. (2008). International literacy statistics: A review of concepts, methodology and current data. Montreal: UNESCO Institute for Statistics. Available at: http://uis.unesco.org/sites/default/files/documents/international-literacy-statistics-a-review-of-concepts-methodology-and-current-data-en_0.pdf And: UNESCO Institute for Statistics. (2013). Adult and youth literacy: National, regional and global trends, 1985–2015. Available at: http://uis.unesco.org/sites/default/files/documents/adult-and-youth-literacy-national-regional-and-global-trends-1985-2015-en_0.pdf 2012-2016 estimates sourced from: UNESCO Statistics (http://data.uis.unesco.org/index.aspx?queryid=166&lang=en).   Data compiled by Our World in Data based on OECD - How was Life? (2014) & UNESCO Reports

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