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 = 5147 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
17877 Obstfeld and Taylor (2005), IMF (2020) 
{
    "link": "https://www.imf.org/external/pubs/ft/weo/2019/01/weodata/index.aspx",
    "additionalInfo": "The data shown in the figure is the average absolute current account balance (as a percentage of GDP) for 15 countries in five-year blocks (from 1870\u201374 through to 2015\u201319). The countries in the sample are Argentina, Australia, Canada, Denmark, Finland, France, Germany, Italy, Japan, Netherlands, Norway, Spain, Sweden, UK, US. The 2018 data for Finland, France, Italy, Netherlands, Norway, Spain, the United States and the 2019 data for all countries are IMF estimates.",
    "dataPublishedBy": "Figure 2.2 from Maurice Obstfeld and Alan M. Taylor. 2005. Global Capital Markets: Integration, Crisis, and Growth (Japan\u2013US Center UFJ Bank Monographs on International Financial Markets). Cambridge: Cambridge University Press;  International Monetary Fund (2020) World Economic Outlook Database"
}
 2020-07-29 13:28:40 2020-07-29 13:28:40 TE-18.8 5147 The data shown in the figure is the average absolute current account balance (as a percentage of GDP) for 15 countries in five-year blocks (from 1870–74 through to 2015–19). The countries in the sample are Argentina, Australia, Canada, Denmark, Finland, France, Germany, Italy, Japan, Netherlands, Norway, Spain, Sweden, UK, US. The 2018 data for Finland, France, Italy, Netherlands, Norway, Spain, the United States and the 2019 data for all countries are IMF estimates. https://www.imf.org/external/pubs/ft/weo/2019/01/weodata/index.aspx Figure 2.2 from Maurice Obstfeld and Alan M. Taylor. 2005. Global Capital Markets: Integration, Crisis, and Growth (Japan–US Center UFJ Bank Monographs on International Financial Markets). Cambridge: Cambridge University Press; International Monetary Fund (2020) World Economic Outlook Database

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