sources

Data license: CC-BY

1 row where datasetId = 5290 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

{
    "link": "https://www.minneapolisfed.org/research/QR/QR2811.pdf",
    "retrievedDate": "28 March 2021",
    "additionalInfo": "The effective marginal tax rate on labor income incorporates taxes on both labor income (i.e., income tax and social security tax) and consumption (i.e., value-added, sales, excise, and property taxes). It is the fraction of additional labor income that is taken in the form of these taxes, holding investment, or equivalently savings, fixed. For more details on how this measure is calculated see Prescott 2004.",
    "dataPublishedBy": "Prescott, E. C. (2004). Why Do Americans Work So Much More Than Europeans? Changes in Hours Worked, 1950-2000. Federal Reserve Bank of Minneapolis Quarterly Review, 28(1), 1\u201313."
}

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