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 = 3021 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
14708 OECD, Balanced International Merchandise Trade Statistics (2015) 
{
    "link": "https://stats.oecd.org/Index.aspx?DataSetCode=BIMTS_CPA#",
    "retrievedDate": "02/03/2018",
    "additionalInfo": "The Balanced International Merchandise Trade Statistics (BIMTS) database follows a four step procedure in order to reconcile bilateral trade asymmetries, i.e. so that exports from country A to country B are consistent with the imports of country B from country A. For more information on the OECD\u2019s balancing methodology see the link provided above.\n\nTo calculate the total value of exports to the world, we sum the value of all products exported, by country, to all of its trading partners. Then to express total exports as a share of GDP, the total value of exports is divided by the exporting country\u2019s GDP. GDP data is taken from the World Bank\u2019s WDI available at: https://data.worldbank.org/indicator/NY.GDP.MKTP.CD ",
    "dataPublishedBy": "OECD",
    "dataPublisherSource": "National statistical offices and other international organisations"
}
 2018-03-02 17:58:06 2018-04-26 14:50:29 Total merchandise trade as a share of GDP (OECD (2016)) (split) 3021 The Balanced International Merchandise Trade Statistics (BIMTS) database follows a four step procedure in order to reconcile bilateral trade asymmetries, i.e. so that exports from country A to country B are consistent with the imports of country B from country A. For more information on the OECD’s balancing methodology see the link provided above. To calculate the total value of exports to the world, we sum the value of all products exported, by country, to all of its trading partners. Then to express total exports as a share of GDP, the total value of exports is divided by the exporting country’s GDP. GDP data is taken from the World Bank’s WDI available at: https://data.worldbank.org/indicator/NY.GDP.MKTP.CD https://stats.oecd.org/Index.aspx?DataSetCode=BIMTS_CPA# OECD

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