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 = 2808 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
15545 Huberman and Minns (2007) 
{
    "link": "http://personal.lse.ac.uk/minns/Huberman_Minns_EEH_2007.pdf",
    "retrievedDate": "13/06/2018",
    "additionalInfo": "The New World includes Europe, the United States, Australia, and Canada while the Old World consists of all other countries included in Huberman and Minns's sample. The 'Old World (weighted)' and 'New World (weighted)' series are population weighted averages.\n\nSee table 1 for further information regarding sources the authors consulted in producing hours of work per week estimates.\nSee table 2 for more information about vacation and holidays estimates.",
    "dataPublishedBy": "Huberman, M. and Minns, C., 2007. The times they are not changin\u2019: Days and hours of work in Old and New Worlds, 1870\u20132000. Explorations in Economic History, 44(4), pp.538-567.",
    "dataPublisherSource": "Authors' calculations based on scholarly sources, ILO, and Eurostat."
}
 2018-06-13 11:12:35 2018-07-25 09:55:24 Days and hours of work in Old and New Worlds - Huberman and Minns (2007) 2808 The New World includes Europe, the United States, Australia, and Canada while the Old World consists of all other countries included in Huberman and Minns's sample. The 'Old World (weighted)' and 'New World (weighted)' series are population weighted averages. See table 1 for further information regarding sources the authors consulted in producing hours of work per week estimates. See table 2 for more information about vacation and holidays estimates. http://personal.lse.ac.uk/minns/Huberman_Minns_EEH_2007.pdf Huberman, M. and Minns, C., 2007. The times they are not changin’: Days and hours of work in Old and New Worlds, 1870–2000. Explorations in Economic History, 44(4), pp.538-567.

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