owid: sources: 1 row where datasetId = 5062 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 = 5062 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
17793	Cereal allocation to food, feed, fuel (OWID based on FAO)	{ "link": "http://www.fao.org/faostat/en/?#data/", "retrievedDate": "26th February 2020", "additionalInfo": "This dataset reports the quantity of cereal crops allocated directly to human food; used as animal feed; and allocated to other uses (predominantly industrial uses such as biofuel production).\n\nThe dataset combines two sets of variables: in the Food Balance Sheets the FAO include data via their \u2018old methodology\u2019 from 1961 to 2013, and \u2018new methodology\u2019 separately from 2014 to 2017.\n\nThe variables included were \u2018Cereals \u2013 Food\u2019, \u2018Cereals \u2013 Feed\u2019 and \u2018Cereals \u2013 Other Uses\u2019, all measured in 1000 tonnes.\n\nWe have combined these two sets of data to get a complete series from 1961 to 2017 (in tonnes).\n\nThe share of cereals allocated to each use (Food, Feed and Other Uses) have also been calculated by dividing each individual variable by the sum of all three. For example:\nShare of cereals allocated to food = [Food / (Food + Feed + Other Uses) * 100].\n\nThis calculates the share of cereals available domestically (after trade) allocated to each use, excluding supply chain losses and seed resown from the crop.", "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)" }	2020-02-26 21:06:42	2020-02-26 21:06:42	Cereal allocation to food, feed, fuel (OWID based on FAO) 5062	This dataset reports the quantity of cereal crops allocated directly to human food; used as animal feed; and allocated to other uses (predominantly industrial uses such as biofuel production). The dataset combines two sets of variables: in the Food Balance Sheets the FAO include data via their ‘old methodology’ from 1961 to 2013, and ‘new methodology’ separately from 2014 to 2017. The variables included were ‘Cereals – Food’, ‘Cereals – Feed’ and ‘Cereals – Other Uses’, all measured in 1000 tonnes. We have combined these two sets of data to get a complete series from 1961 to 2017 (in tonnes). The share of cereals allocated to each use (Food, Feed and Other Uses) have also been calculated by dividing each individual variable by the sum of all three. For example: Share of cereals allocated to food = [Food / (Food + Feed + Other Uses) * 100]. This calculates the share of cereals available domestically (after trade) allocated to each use, excluding supply chain losses and seed resown from the crop.	http://www.fao.org/faostat/en/?#data/	Food and Agriculture Organization of the United Nations (FAO) (2020)

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