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 = 3165 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
16669 US Federal Reserve (2016); Bank of England (2012) 
{
    "link": "US data: http://www.federalreserve.gov/releases/Z1/default.htm; UK data: http://www.bankofengland.co.uk/publications/Pages/fsr/2012/fsr31.aspx",
    "additionalInfo": "Data for the United States is for security brokers and dealers, which covers investment banks and investment bank arms of universal banks. Data for the UK is for median leverage of UK banks.",
    "dataPublishedBy": "US Federal Reserve. 2016. \u2018Financial Accounts of the United States, Historical.\u2019 December 10; Bank of England. 2012. Financial Stability Report, Issue 31."
}
 2019-01-02 16:04:48 2019-01-02 16:04:48 Figure_17.21 3165 Data for the United States is for security brokers and dealers, which covers investment banks and investment bank arms of universal banks. Data for the UK is for median leverage of UK banks. US data: http://www.federalreserve.gov/releases/Z1/default.htm; UK data: http://www.bankofengland.co.uk/publications/Pages/fsr/2012/fsr31.aspx US Federal Reserve. 2016. ‘Financial Accounts of the United States, Historical.’ December 10; Bank of England. 2012. Financial Stability Report, Issue 31.

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