owid: sources: 1 row where datasetId = 670 sorted by id descending

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 = 670 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
2830	Broadberry et al. (2015); Brassley (2000); and Food and Agriculture Organization of the United Nations	{ "additionalInfo": "This dataset on agricultural yields in the United Kingdom was constructed from yield data from three key sources.\n\n\u2013 Data from 1270 - 1870 was taken from Broadberry et al (2015), made available by Bank of England. This comprises crop yield estimates only for England. For this dataset, we have assumed that yields in England are also representative of average UK yields. \n\n\u2013 Data from 1870 to 1960 is taken from Brassley (2000. This is provided over 5-year periods. We have assumed these figures for the first year in each 5-year set.\n\n\u2013 Data from 1961 onwards is sourced from the Food and Agriculture Organization of the United Nations.\n\nReferences:\nBroadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015). British economic growth, 1270\u20131870. Cambridge University Press.\n\nBrassley, P. (2000). Output and technical change in twentieth-century British agriculture. The Agricultural History Review, 60-84.\n\nFood and Agriculture Organization of the United Nations. Available at: https://www.fao.org/faostat/en/#data/QCL", "dataPublishedBy": "Broadberry et al. (2015); Brassley (2000); and Food and Agriculture Organization of the United Nations" }	2017-08-16 15:29:52	2017-11-02 13:04:39	Long-term yields in the United Kingdom (2022) 670	This dataset on agricultural yields in the United Kingdom was constructed from yield data from three key sources. – Data from 1270 - 1870 was taken from Broadberry et al (2015), made available by Bank of England. This comprises crop yield estimates only for England. For this dataset, we have assumed that yields in England are also representative of average UK yields. – Data from 1870 to 1960 is taken from Brassley (2000. This is provided over 5-year periods. We have assumed these figures for the first year in each 5-year set. – Data from 1961 onwards is sourced from the Food and Agriculture Organization of the United Nations. References: Broadberry, S., Campbell, B. M., Klein, A., Overton, M., & Van Leeuwen, B. (2015). British economic growth, 1270–1870. Cambridge University Press. Brassley, P. (2000). Output and technical change in twentieth-century British agriculture. The Agricultural History Review, 60-84. Food and Agriculture Organization of the United Nations. Available at: https://www.fao.org/faostat/en/#data/QCL		Broadberry et al. (2015); Brassley (2000); and Food and Agriculture Organization of the United Nations

Advanced export

JSON shape: default, array, newline-delimited, object

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