sources
Data license: CC-BY
1 row where datasetId = 292 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 |
---|---|---|---|---|---|---|---|---|
395 | Federico and Tena-Junguito (2016) | { "link": "https://e-archivo.uc3m.es/bitstream/handle/10016/22354/wh1602.pdf?sequence=1", "retrievedDate": "09/09/2016", "additionalInfo": null, "dataPublishedBy": "Federico, Giovanni and Antonio Tena-Junguito\u00a0 (2016 b). 'A tale of two globalizations: gains from trade and openness 1800-2010'. London, Centre for Economic Policy Research. (CEPR WP.11128).", "dataPublisherSource": "Various sources . Further details available in the online appendix of Federico Giovanni and Antonio Tena-Junguito (2016a) \u201cWorld trade, 1800-1938: a new data-set\u201d EHES Working paper n.93. http://www.ehes.org/EHES_93.pdf." } |
2016-09-09 22:18:36 | 2017-11-02 13:04:39 | Trade – Giovanni and Tena-Junguito (2016) 292 | https://e-archivo.uc3m.es/bitstream/handle/10016/22354/wh1602.pdf?sequence=1 | Federico, Giovanni and Antonio Tena-Junguito (2016 b). 'A tale of two globalizations: gains from trade and openness 1800-2010'. London, Centre for Economic Policy Research. (CEPR WP.11128). |
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");