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 = 2707 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
15439 Fouquin and Hugot (CEPII 2016) 
{
    "link": "http://www.cepii.fr/cepii/en/bdd_modele/presentation.asp?id=32",
    "retrievedDate": "19/03/2018",
    "additionalInfo": "To calculate country exports to the rest of the world, the total value of exports by country, per year, is divided by the country's GDP. Calculations use Fouquin and Hugot (CEPII 2016) dyadic trade data.\n\nThe time series 'World' corresponds to the World's total exports (i.e. the sum of exports reported by all countries in the dataset).\n\nThe total export values of regional income aggregates have been calculated using the World Bank's income groupings.\n\nGermany's time series is comprised of West Germany, and Germany. East Germany has been excluded for the purposes of Germany's calculations but is included in the World series.\nRussia's time series comprises Russia and the USSR. \n\nContinental groupings are defined according to OWID's classification. Europe has been split into Western Europe including: Austria, Belgium, Denmark, Finland, France, Germany, Greece, Hungary, Italy, the Netherlands, Norway, Portugal, Russia, Spain, Sweden, Switzerland, and the United Kingdom. Remaining European countries have been classified as Eastern Europe.",
    "dataPublishedBy": "Michel Fouquin & Jules Hugot , 2016. \"Two Centuries of Bilateral Trade and Gravity Data: 1827-2014,\" CEPII Working Paper 2016- 14 , May 2016 , CEPII ",
    "dataPublisherSource": "IMF Direction of Trade Statistics data set, manuscripts"
}
 2018-03-28 11:09:42 2018-07-07 13:50:08 Split of exports to different country groups - OWID calculations based on Fouquin and Hugot (CEPII 2016) dyadic data 2707 To calculate country exports to the rest of the world, the total value of exports by country, per year, is divided by the country's GDP. Calculations use Fouquin and Hugot (CEPII 2016) dyadic trade data. The time series 'World' corresponds to the World's total exports (i.e. the sum of exports reported by all countries in the dataset). The total export values of regional income aggregates have been calculated using the World Bank's income groupings. Germany's time series is comprised of West Germany, and Germany. East Germany has been excluded for the purposes of Germany's calculations but is included in the World series. Russia's time series comprises Russia and the USSR. Continental groupings are defined according to OWID's classification. Europe has been split into Western Europe including: Austria, Belgium, Denmark, Finland, France, Germany, Greece, Hungary, Italy, the Netherlands, Norway, Portugal, Russia, Spain, Sweden, Switzerland, and the United Kingdom. Remaining European countries have been classified as Eastern Europe. http://www.cepii.fr/cepii/en/bdd_modele/presentation.asp?id=32 Michel Fouquin & Jules Hugot , 2016. "Two Centuries of Bilateral Trade and Gravity Data: 1827-2014," CEPII Working Paper 2016- 14 , May 2016 , CEPII

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