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 = 3026 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
15503 Fouquin and Hugot (CEPII 2016) 
{
    "link": "http://www.cepii.fr/cepii/en/bdd_modele/presentation.asp?id=32 ",
    "retrievedDate": "06/02/2018",
    "additionalInfo": "Fouquin and Hugot (CEPII 2016) have compiled aggregate country-year export trade data. A number of sources are consulted in compiling these figures; the top three sources are the IMF (2002 and 2015) (19,026 observations); Mitchell (2007a,b,c) (11,705 observations); and the World Bank (2015) (3,030 observations). For further information see Table 6, page 18 of Fouquin and Hugot (CEPII 2016)'s working paper at: http://www.cepii.fr/PDF_PUB/wp/2016/wp2016-14.pdf\n\nTo calculate export trade as a share of GDP, aggregate country-year export data (in nominal British pounds) has been divided by Fouquin and Hugot (CEPII 2016) nominal GDP data, and multiplied by 100.  \n\nAndorra has been dropped as it had very sparse coverage; 3 observations for the years 1993,1994,1996.",
    "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-04-26 14:50:31 2018-04-26 14:50:31 Total merchandise trade as share of GDP (Fouquin and Hugot (CEPII 2016)) (split) 3026 Fouquin and Hugot (CEPII 2016) have compiled aggregate country-year export trade data. A number of sources are consulted in compiling these figures; the top three sources are the IMF (2002 and 2015) (19,026 observations); Mitchell (2007a,b,c) (11,705 observations); and the World Bank (2015) (3,030 observations). For further information see Table 6, page 18 of Fouquin and Hugot (CEPII 2016)'s working paper at: http://www.cepii.fr/PDF_PUB/wp/2016/wp2016-14.pdf To calculate export trade as a share of GDP, aggregate country-year export data (in nominal British pounds) has been divided by Fouquin and Hugot (CEPII 2016) nominal GDP data, and multiplied by 100. Andorra has been dropped as it had very sparse coverage; 3 observations for the years 1993,1994,1996. 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");