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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
22616	Bick, Fuchs-Schündeln, and Lagakos (2018)	{ "link": "https://www.aeaweb.org/articles?id=10.1257/aer.20151720", "retrievedDate": "12 November 2020", "additionalInfo": "Data comes from nationally representative household surveys that cover workers in all sectors, including the self-employed, which represent the majority of the workforce in low-income countries. Most of the data is from 2005 or within a few years of 2005.\n\nInternational comparability of hours data is kept as high as possible by satisfying the following three criteria:\n1. The surveys cover the entire calendar year (rather than, say, one month of the year). This is necessary to prevent any bias induced by seasonality in labor demand.\n2. Hours worked are measured in a consistent way: actual (rather than usual) hours in all jobs (not just the primary job), and in the week prior to the interview.\n3. Hours worked cover the production of goods or services counted in the National Income and Product Accounts (NIPA). Thus, the working hours cover unpaid work in agricultural or nonagricultural businesses, as well as wage employment, but do not cover home-produced services, such as child care.\n\nData not currently in the Grapher but available from the paper that might be of interest:\n\u2013 Employment rates\n\u2013 Average working hours by: sex, age group, educational attainment, sector (agriculture, manufacturing, services)", "dataPublishedBy": "Bick, A., Fuchs-Sch\u00fcndeln, N., & Lagakos, D. (2018). How do hours worked vary with income? Cross-country evidence and implications. American Economic Review, 108(1), 170\u2013199. https://doi.org/10.1257/aer.20151720", "dataPublisherSource": "Nationally representative household surveys" }	2022-05-24 17:31:00	2022-05-24 17:31:00	Working Hours by Income – Bick et al (2018) 5632	Data comes from nationally representative household surveys that cover workers in all sectors, including the self-employed, which represent the majority of the workforce in low-income countries. Most of the data is from 2005 or within a few years of 2005. International comparability of hours data is kept as high as possible by satisfying the following three criteria: 1. The surveys cover the entire calendar year (rather than, say, one month of the year). This is necessary to prevent any bias induced by seasonality in labor demand. 2. Hours worked are measured in a consistent way: actual (rather than usual) hours in all jobs (not just the primary job), and in the week prior to the interview. 3. Hours worked cover the production of goods or services counted in the National Income and Product Accounts (NIPA). Thus, the working hours cover unpaid work in agricultural or nonagricultural businesses, as well as wage employment, but do not cover home-produced services, such as child care. Data not currently in the Grapher but available from the paper that might be of interest: – Employment rates – Average working hours by: sex, age group, educational attainment, sector (agriculture, manufacturing, services)	https://www.aeaweb.org/articles?id=10.1257/aer.20151720	Bick, A., Fuchs-Schündeln, N., & Lagakos, D. (2018). How do hours worked vary with income? Cross-country evidence and implications. American Economic Review, 108(1), 170–199. https://doi.org/10.1257/aer.20151720

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