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 = 390 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
511 Ramey and Francis (2009) 
{
    "link": "https://www.aeaweb.org/articles?id=10.1257/mac.1.2.189",
    "retrievedDate": "14/04/2017",
    "additionalInfo": "Following Ramey and Francis (2009), \"the activities included in home production are: planning, purchasing goods and services (except medical and personal care services), care of children and adults (both in the household and outside the household), general cleaning, care and repair of the house and grounds (including yard work, but excluding gardening), preparing and clearing food, making, mending, and laundering of clothing and other household textiles.\".\nRamey and Francis (2009) estimations are based on data assembled by Ramey (2009).\n\nRamey (2009)'s data are assembled and estimated from samples based on a multitude of different sources, including diaries, U.S. census, historical statistics, and surveys from the Bureau of Labour Statistics and the American Heritage Time Use Survey. For more details on how these data are constructed see Ramey (2009), pp.3-4, and Appendix A.",
    "dataPublishedBy": "Ramey, Valerie R. (2009); Francis, Neville. A Century of Work and Leisure. American Economic Journal: Macroeconomics.",
    "dataPublisherSource": "Authors own calculations based on 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."
}
 2017-04-14 21:02:34 2017-11-02 13:04:39 Weekly home production hours in the USA - Ramey (2009) & Ramey Francis (2009) 390 Following Ramey and Francis (2009), "the activities included in home production are: planning, purchasing goods and services (except medical and personal care services), care of children and adults (both in the household and outside the household), general cleaning, care and repair of the house and grounds (including yard work, but excluding gardening), preparing and clearing food, making, mending, and laundering of clothing and other household textiles.". Ramey and Francis (2009) estimations are based on data assembled by Ramey (2009). Ramey (2009)'s data are assembled and estimated from samples based on a multitude of different sources, including diaries, U.S. census, historical statistics, and surveys from the Bureau of Labour Statistics and the American Heritage Time Use Survey. For more details on how these data are constructed see Ramey (2009), pp.3-4, and Appendix A. https://www.aeaweb.org/articles?id=10.1257/mac.1.2.189 Ramey, Valerie R. (2009); Francis, Neville. A Century of Work and Leisure. American Economic Journal: Macroeconomics.

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