sources
Data license: CC-BY
1 row where datasetId = 300 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
403 | Arroyo-Abad and Lindert (2016) | { "link": "http://gpih.ucdavis.edu", "retrievedDate": "21/09/2016", "additionalInfo": null, "dataPublishedBy": "Arroyo Abad, L. and P. Lindert. \"Fiscal Redistribution in the Americas since the Mid-Nineteenth Century\" in\u00a0Latin American Inequality in the Long Run, edited by L. Bertola and J. Williamson, forthcoming.\u00a0", "dataPublisherSource": "Various sources." } |
2016-09-21 21:24:56 | 2017-11-02 13:04:39 | Tax composition – Arroyo Abad and P. Lindert (2016) 300 | http://gpih.ucdavis.edu | Arroyo Abad, L. and P. Lindert. "Fiscal Redistribution in the Americas since the Mid-Nineteenth Century" in Latin American Inequality in the Long Run, edited by L. Bertola and J. Williamson, forthcoming. |
Advanced export
JSON shape: default, array, newline-delimited, object
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");