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 = 5755 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
27022 Calculated by Our World in Data based on data from the UN Food and Agriculture Organization (FAO) 
{
    "link": "http://www.fao.org/faostat/en/#data",
    "retrievedDate": "2nd September 2022",
    "additionalInfo": "Data on vegetable oil production and land use by crop type is sourced directly from the UN Food and Agriculture Organization (FAO) database.\n\nOur World in Data have calculated each crop's share of total vegetable oil production and land use based on this data.\n\nLand use data is sourced as the 'Area harvested' variable from its crops database: http://www.fao.org/faostat/en/#data/QC\n\nOil production data is sourced from its Food Balances Sheets as the variable 'Production Quantity':http://www.fao.org/faostat/en/#data/FBS\n\nOur World in Data has also calculated oil yields per crop by dividing oil production by land area used to grow the crop. This is measured in tonnes per hectare. Note that this calculates the oil yield per hectare, which is different from the yield of the total crop: this is because not all of the crop can be used for oil.",
    "dataPublishedBy": "UN Food and Agriculture Organization (FAO)"
}
 2022-09-02 14:39:24 2022-09-02 14:39:24 Vegetable oil yields (FAO) 5755 Data on vegetable oil production and land use by crop type is sourced directly from the UN Food and Agriculture Organization (FAO) database. Our World in Data have calculated each crop's share of total vegetable oil production and land use based on this data. Land use data is sourced as the 'Area harvested' variable from its crops database: http://www.fao.org/faostat/en/#data/QC Oil production data is sourced from its Food Balances Sheets as the variable 'Production Quantity':http://www.fao.org/faostat/en/#data/FBS Our World in Data has also calculated oil yields per crop by dividing oil production by land area used to grow the crop. This is measured in tonnes per hectare. Note that this calculates the oil yield per hectare, which is different from the yield of the total crop: this is because not all of the crop can be used for oil. http://www.fao.org/faostat/en/#data UN Food and Agriculture Organization (FAO)

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