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 = 396 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
518 Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015) 
{
    "link": "http://www.bankofengland.co.uk/research/Pages/datasets/default.aspx",
    "retrievedDate": "18/04/2017",
    "additionalInfo": "Data on nominal weekly wages was spliced by the Bank of England and is based on the following sources:\r\nN. Crafts and T. Mills Trends in Real Wages in Britain, 1750-1913, Explorations in Economic History (1994)\r\nFeinstein (1998)\r\nC. H. Feinstein New Estimates of Average Earnings in the United Kingdom, Economic History Review (1990)\r\nC.H. Feinstein, National Income Expenditure and Output of the United Kingdom 1855-1965\r\nONS: Series code LNMQ\r\nONS: Series code KAB9\r\n\r\nThe cost of living index is referred to by the Bank of England as \"Headline Consumer Price Index (CPI) - original method in version 1.0\" and is indexed to 2015. It is spliced by the BoE based on the following sources: Feinstein (1998), Allen (2007), Feinstein (1991), Capie and Collins (1983), Ministry of Labour, ONS retail prices 1919-1990, O'Donoghue et al (2004), and the ONS website. \r\nThe real weekly wage was calculated based on these two series. \r\n\r\nFor all details see the original source.",
    "dataPublishedBy": "Bank of England in the \"Three centuries of macroeconomic data\" database",
    "dataPublisherSource": "Please see additional information. "
}
 2017-04-18 07:58:29 2023-07-07 15:38:50 UK Nominal wage data, price data, and real wage – Bank of England ("Three centuries of macroeconomic data") (2017) 396 Data on nominal weekly wages was spliced by the Bank of England and is based on the following sources: N. Crafts and T. Mills Trends in Real Wages in Britain, 1750-1913, Explorations in Economic History (1994) Feinstein (1998) C. H. Feinstein New Estimates of Average Earnings in the United Kingdom, Economic History Review (1990) C.H. Feinstein, National Income Expenditure and Output of the United Kingdom 1855-1965 ONS: Series code LNMQ ONS: Series code KAB9 The cost of living index is referred to by the Bank of England as "Headline Consumer Price Index (CPI) - original method in version 1.0" and is indexed to 2015. It is spliced by the BoE based on the following sources: Feinstein (1998), Allen (2007), Feinstein (1991), Capie and Collins (1983), Ministry of Labour, ONS retail prices 1919-1990, O'Donoghue et al (2004), and the ONS website. The real weekly wage was calculated based on these two series. For all details see the original source. http://www.bankofengland.co.uk/research/Pages/datasets/default.aspx Bank of England in the "Three centuries of macroeconomic data" 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");