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 = 3032 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
15578 Klasing and Milionis (2014) 
{
    "link": "https://www.sciencedirect.com/science/article/pii/S0022199613001074?via%3Dihub",
    "retrievedDate": "20/07/2018",
    "additionalInfo": "For consistency, the 62 countries used in Klasing and Milionis are used to calculate the world trade to GDP ratio for the period 1950-2011. The list can be found in Appendix A2 of their paper.",
    "dataPublishedBy": "Klasing, Mariko J. and Milionis, P. (2014). \"Quantifying the Evolution of World Trade, 1870-1949\". Journal of International Economics 92(1), pp. 185-197",
    "dataPublisherSource": "Historical import and export figures."
}
 2018-07-20 17:07:58 2018-07-20 17:07:58 World trade based on own estimates (% of GDP) (Klasing and Milionis (2014)) (split) 3032 For consistency, the 62 countries used in Klasing and Milionis are used to calculate the world trade to GDP ratio for the period 1950-2011. The list can be found in Appendix A2 of their paper. https://www.sciencedirect.com/science/article/pii/S0022199613001074?via%3Dihub Klasing, Mariko J. and Milionis, P. (2014). "Quantifying the Evolution of World Trade, 1870-1949". Journal of International Economics 92(1), pp. 185-197

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