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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
2806	Our World In Data based on OECD (2017) and Long (1958)	{ "link": "OECD.stat: http://stats.oecd.org/. Long (1958): http://econpapers.repec.org/bookchap/nbrnberbk/long58-1.htm. Heckman and Killingsworth (1986): http://public.econ.duke.edu/~vjh3/e262p/readings/Killingsworth_Heckman.pdf", "retrievedDate": "31/07/2017", "additionalInfo": "Estimates in this series come primarily from OECD.stat. However, for Canada, Germany, Great Britain and the US, we combined estimates from Long (1958) and Heckman and Killingsworth (1986), in order to provide a longer perspective. Details on how we combined these sources can be found in this online table (https://ourworldindata.org/wp-content/uploads/2017/07/OECD-historical-female-participation-OWID.xlsx).\n\nIt is important to bear in mind that OECD estimates correspond to population ages 15+, while other estimates correspond to population 14+. Also, for France 1962-1966 we assigned missing values where the OECD.stat file reports zero.", "dataPublishedBy": "Long, C. D. (1958) The labor force under changing income and employment. Princeton University Press. Heckman J. and Killingsworth M. (1986) Female Labor Supply: A Survey. in Handbook of Labor Economics, Volume I, Edited by O. Ashenfelter and R. Layard. OECD.Stat", "dataPublisherSource": "Mainly census data (see underlying sources for more details)." }	2017-07-31 20:01:04	2017-11-02 13:04:39	Female labor force participation rate - OWID (2017) 656	Estimates in this series come primarily from OECD.stat. However, for Canada, Germany, Great Britain and the US, we combined estimates from Long (1958) and Heckman and Killingsworth (1986), in order to provide a longer perspective. Details on how we combined these sources can be found in this online table (https://ourworldindata.org/wp-content/uploads/2017/07/OECD-historical-female-participation-OWID.xlsx). It is important to bear in mind that OECD estimates correspond to population ages 15+, while other estimates correspond to population 14+. Also, for France 1962-1966 we assigned missing values where the OECD.stat file reports zero.	OECD.stat: http://stats.oecd.org/. Long (1958): http://econpapers.repec.org/bookchap/nbrnberbk/long58-1.htm. Heckman and Killingsworth (1986): http://public.econ.duke.edu/~vjh3/e262p/readings/Killingsworth_Heckman.pdf	Long, C. D. (1958) The labor force under changing income and employment. Princeton University Press. Heckman J. and Killingsworth M. (1986) Female Labor Supply: A Survey. in Handbook of Labor Economics, Volume I, Edited by O. Ashenfelter and R. Layard. OECD.Stat

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