owid: sources: 1 row where datasetId = 4129 sorted by id descending

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 = 4129 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
16958	Lee-Lee (2016), Barro-Lee (2018) and UNDP, HDR (2018)	{ "link": "http://www.barrolee.com/Lee_Lee_LRdata_dn.htm; http://www.barrolee.com/data/yrsch2.htm; and http://hdr.undp.org/en/indicators/103006", "retrievedDate": "24/05/19", "additionalInfo": "This series combines figures from three published datasets: Lee-Lee (2016); Barro-Lee (2018) and UNDP HDR (2018).\n\nFor the period 1870-1949 inclusive, the estimates correspond to population aged 25-64, and are taken from Lee-Lee (2016).\n\nFor the period 1950-1990 inclusive, the estimates correspond to population aged 25+, and are taken from Barro-Lee (2018).\n\nFor the period 1991-2017 inclusive, the estimated correspond to population aged 25+, and are taken from the UNDP, HDR (2018). \n\nFull references:\nLee, Jong-Wha and Hanol Lee, 2016, \u201cHuman Capital in the Long Run,\u201d Journal of Development Economics, vol. 122, pp. 147-169.\n\nBarro, Robert and Jong-Wha Lee, 2013, \"A New Data Set of Educational Attainment in the World, 1950-2010.\" Journal of Development Economics, vol 104, pp.184-198.\n\nUnited Nations Development Programme, Human Development Report (2018 Statistical Update).", "dataPublishedBy": "Lee-Lee (2016); Barro-Lee (2018) and UNDP HDR (2018). See dataset description for full references." }	2019-05-24 11:38:03	2019-05-24 11:38:03	Years of Schooling - based on Lee-Lee (2016), Barro-Lee (2018); and UNDP (2018) 4129	This series combines figures from three published datasets: Lee-Lee (2016); Barro-Lee (2018) and UNDP HDR (2018). For the period 1870-1949 inclusive, the estimates correspond to population aged 25-64, and are taken from Lee-Lee (2016). For the period 1950-1990 inclusive, the estimates correspond to population aged 25+, and are taken from Barro-Lee (2018). For the period 1991-2017 inclusive, the estimated correspond to population aged 25+, and are taken from the UNDP, HDR (2018). Full references: Lee, Jong-Wha and Hanol Lee, 2016, “Human Capital in the Long Run,” Journal of Development Economics, vol. 122, pp. 147-169. Barro, Robert and Jong-Wha Lee, 2013, "A New Data Set of Educational Attainment in the World, 1950-2010." Journal of Development Economics, vol 104, pp.184-198. United Nations Development Programme, Human Development Report (2018 Statistical Update).	http://www.barrolee.com/Lee_Lee_LRdata_dn.htm; http://www.barrolee.com/data/yrsch2.htm; and http://hdr.undp.org/en/indicators/103006	Lee-Lee (2016); Barro-Lee (2018) and UNDP HDR (2018). See dataset description for full references.

Advanced export

JSON shape: default, array, newline-delimited, object

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