owid: sources: 1 row where datasetId = 3016 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 = 3016 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
6792	OECD Gender, Institutions and Development Database (2014)	{ "link": "https://stats.oecd.org/Index.aspx?DataSetCode=GIDDB2014#", "retrievedDate": "19/09/2017", "additionalInfo": "OECD Gender, Institutions and Development Database (2014) \r\n\r\nThe source does not specify the actual measurement methodology. \r\n\r\nFor most countries, estimates correspond to 15-64 year olds. Except: for Australia (15+ year olds), China and Hungary (15-74 year olds) and Sweden (25-64 year olds). \r\n\r\nEstimates refer to different survey years (see source for more details).\r\n\r\nThis dataset was produced using a number of different sources. These include the Economic Commission for Latin America and the Caribbean (HETUS), OECD Time Use Database, United Nations Economic Commission for Europe, and diverse national sources for countries not covered in the previous databases.\r\n\r\nDifferent sources use different reference years, as well as different definitions of unpaid care work. Because of this cross-country comparisons should be made with caution. \r\n\r\nFor the OECD, you can find details regarding all activities included, and the corresponding survey years for each country, here: http://www.oecd.org/gender/data/balancingpaidworkunpaidworkandleisure.htm. ", "dataPublishedBy": "Gender, Institutions and Development Database 2014", "dataPublisherSource": "Time use statistics" }	2017-09-19 14:45:34	2018-03-16 10:46:20	Female to male ratio of time devoted to unpaid care work (OECD (2014)) (split) 3016	OECD Gender, Institutions and Development Database (2014) The source does not specify the actual measurement methodology. For most countries, estimates correspond to 15-64 year olds. Except: for Australia (15+ year olds), China and Hungary (15-74 year olds) and Sweden (25-64 year olds). Estimates refer to different survey years (see source for more details). This dataset was produced using a number of different sources. These include the Economic Commission for Latin America and the Caribbean (HETUS), OECD Time Use Database, United Nations Economic Commission for Europe, and diverse national sources for countries not covered in the previous databases. Different sources use different reference years, as well as different definitions of unpaid care work. Because of this cross-country comparisons should be made with caution. For the OECD, you can find details regarding all activities included, and the corresponding survey years for each country, here: http://www.oecd.org/gender/data/balancingpaidworkunpaidworkandleisure.htm.	https://stats.oecd.org/Index.aspx?DataSetCode=GIDDB2014#	Gender, Institutions and Development Database 2014

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