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 = 5173 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
17903 Our World in Data based on Huberman & Minns (2007) and PWT 9.1 (2019) 
{
    "link": "https://www.sciencedirect.com/science/article/abs/pii/S0014498307000058, https://www.rug.nl/ggdc/productivity/pwt/?lang=en",
    "additionalInfo": "From 1870\u20131938 the data is from Huberman & Minns (2007). From 1950\u20132017 the data is from Penn World Table (PWT) 9.1 (2019). PWT 9.1 sources its working hours data from the Total Economy Database, an updated version of the same source used by Huberman & Minns (TED, 2005).\n\nFurther details on the data from Huberman & Minns:\nThe measure is annual hours of full-time production workers (male and female) in non-agricultural activities. Annual hours are based on estimates of weekly working hours and weeks worked. The data \u201cbest approximate usual or normal hours\u201d worked (p. 543).\nThe original sources are: 1870\u20131913: Huberman (2004); 1929\u20131938: ILO (1934\u201339), except for Canada (Ostry and Zaidi, 1972), U.S. (Jones, 1963; Owen, 1988), and Australia (Butlin, 1977). These sources in turn rely on a variety of primary data sources, particularly establishment surveys and labor force surveys.\n\nFurther details on the data from PWT 9.1/TED:\nThe measure is labeled \u201cAverage annual hours worked by persons engaged\u201d (PWT label) and \u201cAverage annual hours worked per worker\u201d (TED label). It refers to actual hours worked and is calculated as total annual hours worked divided by persons employed. Annual hours are based on estimates of weekly working hours and weeks worked.\nThe original sources are National Accounts data when available; when unavailable, other databases (e.g., the Asian Productivity Organization\u2019s Asian Productivity Database) and academic publications are used. For a complete description of primary sources and definitions see TED\u2019s detailed sources and methods guide (https://www.conference-board.org/retrievefile.cfm?filename=TED_SMDetailed_nov2017.pdf&type=subsite)",
    "dataPublishedBy": "Huberman & Minns (2007); PWT 9.1 (2019)"
}
 2020-09-23 15:02:50 2020-09-23 15:02:50 Annual Working Hours – OWID (2020) 5173 From 1870–1938 the data is from Huberman & Minns (2007). From 1950–2017 the data is from Penn World Table (PWT) 9.1 (2019). PWT 9.1 sources its working hours data from the Total Economy Database, an updated version of the same source used by Huberman & Minns (TED, 2005). Further details on the data from Huberman & Minns: The measure is annual hours of full-time production workers (male and female) in non-agricultural activities. Annual hours are based on estimates of weekly working hours and weeks worked. The data “best approximate usual or normal hours” worked (p. 543). The original sources are: 1870–1913: Huberman (2004); 1929–1938: ILO (1934–39), except for Canada (Ostry and Zaidi, 1972), U.S. (Jones, 1963; Owen, 1988), and Australia (Butlin, 1977). These sources in turn rely on a variety of primary data sources, particularly establishment surveys and labor force surveys. Further details on the data from PWT 9.1/TED: The measure is labeled “Average annual hours worked by persons engaged” (PWT label) and “Average annual hours worked per worker” (TED label). It refers to actual hours worked and is calculated as total annual hours worked divided by persons employed. Annual hours are based on estimates of weekly working hours and weeks worked. The original sources are National Accounts data when available; when unavailable, other databases (e.g., the Asian Productivity Organization’s Asian Productivity Database) and academic publications are used. For a complete description of primary sources and definitions see TED’s detailed sources and methods guide (https://www.conference-board.org/retrievefile.cfm?filename=TED_SMDetailed_nov2017.pdf&type=subsite) https://www.sciencedirect.com/science/article/abs/pii/S0014498307000058, https://www.rug.nl/ggdc/productivity/pwt/?lang=en Huberman & Minns (2007); PWT 9.1 (2019)

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