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 = 3019 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
14701 NBER-United Nations Dataset 1962-2000 
{
    "link": "NBER-UN trade data: http://cid.econ.ucdavis.edu/nberus.html BOE Exchange Rate: https://www.bankofengland.co.uk/statistics/research-datasets CEPII (2016) GDP data: http://www.cepii.fr/cepii/en/bdd_modele/presentation.asp?id=32",
    "retrievedDate": "21/02/2018",
    "additionalInfo": "To calculate merchandise trade as a share of GDP, the NBER-UN data series uses Fouquin and Hugot (CEPII 2016)'s long run GDP series, converted from nominal British pounds to US$, using historical exchange rates sourced from the Bank of England (see 'A millennium of macroeconomic data' dataset, section VII). NBER-UN has national trade statistics of country exports to the world. \n\nThe total value of exports includes only trade in goods, classified according to the 4 digit Standard International Trade Classification, Revision 2. Authors give primacy to importers' reports whenever they are available, assumed to be more accurate. \n\nCountries Comoros, Saint Kitts and Nevis, and the Netherlands Antilles have been excluded from the sample as, in the case of the former two, multiple countries are included in these labels in the NBER-UN data, and hence would be inaccurate to calculate the trade share by national GDP. For the Netherlands Antilles there is insufficient alternative trade data by the World Bank and other sources to check whether the figures are correctly estimated.\n\nThe United Kingdom consists of: the UK, British Antarctic Territories, the Falkland Islands, and Saint Helena.\nGermany consists of: East Germany, West Germany, and Germany.\nRussia: the former USSR and Russia.\nFrance: French Guinea, Guadeloupe, Saint Pierre and Miquelon, and France.\nYemen: the Yemen Arab Republic, the Yemen People's Republic, and Yemen. ",
    "dataPublishedBy": "Robert Feenstra and Robert Lipsey, The Center for International Development, UC Davis",
    "dataPublisherSource": "Constructed from United Nations trade data. "
}
 2018-03-01 16:30:03 2018-04-26 14:50:28 Total merchandise trade as share of GDP (NBER-United Nations 1962-2000) (split) 3019 To calculate merchandise trade as a share of GDP, the NBER-UN data series uses Fouquin and Hugot (CEPII 2016)'s long run GDP series, converted from nominal British pounds to US$, using historical exchange rates sourced from the Bank of England (see 'A millennium of macroeconomic data' dataset, section VII). NBER-UN has national trade statistics of country exports to the world. The total value of exports includes only trade in goods, classified according to the 4 digit Standard International Trade Classification, Revision 2. Authors give primacy to importers' reports whenever they are available, assumed to be more accurate. Countries Comoros, Saint Kitts and Nevis, and the Netherlands Antilles have been excluded from the sample as, in the case of the former two, multiple countries are included in these labels in the NBER-UN data, and hence would be inaccurate to calculate the trade share by national GDP. For the Netherlands Antilles there is insufficient alternative trade data by the World Bank and other sources to check whether the figures are correctly estimated. The United Kingdom consists of: the UK, British Antarctic Territories, the Falkland Islands, and Saint Helena. Germany consists of: East Germany, West Germany, and Germany. Russia: the former USSR and Russia. France: French Guinea, Guadeloupe, Saint Pierre and Miquelon, and France. Yemen: the Yemen Arab Republic, the Yemen People's Republic, and Yemen. NBER-UN trade data: http://cid.econ.ucdavis.edu/nberus.html BOE Exchange Rate: https://www.bankofengland.co.uk/statistics/research-datasets CEPII (2016) GDP data: http://www.cepii.fr/cepii/en/bdd_modele/presentation.asp?id=32 Robert Feenstra and Robert Lipsey, The Center for International Development, UC Davis

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