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 = 2999 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
512 Ramey (2009) 
{
    "link": "http://econweb.ucsd.edu/~vramey/research/Home_Production_published.pdf",
    "retrievedDate": "14/04/2017",
    "additionalInfo": "Ramey (2009), following M.T. Reid, Economics of Household Production (1934), defines 'Home Production' as \"those unpaid activities which are carried on, by and for the members, which activities might be replaced by market goods, or paid services, if circumstances such as income, market conditions, and personal inclinations permit the service being delegated to someone outside the household group\".\nFor more details on how these data are constructed see Ramey (2009), pp.3-4, and Appendix A.",
    "dataPublishedBy": "Ramey, Valerie R. Time Spent in Home Production in the Twentieth-Century United States: New Estimates from Old Data. The Journal of Economic History, 2009.",
    "dataPublisherSource": "Authors own calculations based on different primary sources such as diaries, U.S. census, historical statistics, and surveys from the Bureau of Labour Statistics and the American Heritage Time Use Survey."
}
 2017-04-14 21:16:15 2017-11-02 13:04:39 Home production working hours per week in the US, by demographic group (Ramey (2009)) (split) 2999 Ramey (2009), following M.T. Reid, Economics of Household Production (1934), defines 'Home Production' as "those unpaid activities which are carried on, by and for the members, which activities might be replaced by market goods, or paid services, if circumstances such as income, market conditions, and personal inclinations permit the service being delegated to someone outside the household group". For more details on how these data are constructed see Ramey (2009), pp.3-4, and Appendix A. http://econweb.ucsd.edu/~vramey/research/Home_Production_published.pdf Ramey, Valerie R. Time Spent in Home Production in the Twentieth-Century United States: New Estimates from Old Data. The Journal of Economic History, 2009.

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