sources

Data license: CC-BY

1 row where datasetId = 2716 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

{
    "link": "http://www.longtermproductivity.com/download.html",
    "retrievedDate": "03/04/2018",
    "additionalInfo": "The Long-Term Productivity database was created as a project at the Bank of France in 2013 by Antonin Bergeaud, Gilbert Cette and Remy Lecat. This database covers productivity relevant statistics, at least for the period 1890 to present, and includes 17 countries in the latest version (2016).\n\nThe starting database used was built by Cette, Kocoglu and Mairesse (2009) on the United States, Japan, France and the United Kingdom over the 1890-2006 period. ",
    "dataPublishedBy": "Bergeaud, A., Cette, G. and Lecat, R. (2016): \"Productivity Trends in Advanced Countries between 1890 and 2012,\" Review of Income and Wealth, vol. 62(3), pages 420\u2013444.",
    "dataPublisherSource": "Historical data series"
}

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