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 = 4913 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
17644 Share of food lost by food type and region (FAO, 2019) 
{
    "link": "http://www.fao.org/3/ca6030en/ca6030en.pdf",
    "retrievedDate": "5th February 2020",
    "additionalInfo": "Data represents the share of food lost (from post-harvest through to, but not including, retail level) by food group and by region. From the source: \u201cPercentage of food loss refers to the physical quantity lost for different commodities divided by the amount produced. An economic weight is used to aggregate percentages at regional or commodity group levels, so that higher-value commodities carry more weight in loss estimation than lower-value ones\u201d.\n\nThis data is sourced from the UN FAO\u2019s 2019 State of Food and Agriculture report.\n\nFAO. 2019. The State of Food and Agriculture 2019. Moving forward on food loss and waste reduction. Rome. Available at: http://www.fao.org/3/ca6030en/ca6030en.pdf\n\nThe data was made available in the UN FAO\u2019s interactive report accompanying the chart: http://www.fao.org/state-of-food-agriculture/en/.",
    "dataPublishedBy": "UN Food and Agriculture Organization (FAO)"
}
 2020-02-07 12:29:12 2020-02-07 12:29:12 Share of food lost by food type and region (FAO, 2019) 4913 Data represents the share of food lost (from post-harvest through to, but not including, retail level) by food group and by region. From the source: “Percentage of food loss refers to the physical quantity lost for different commodities divided by the amount produced. An economic weight is used to aggregate percentages at regional or commodity group levels, so that higher-value commodities carry more weight in loss estimation than lower-value ones”. This data is sourced from the UN FAO’s 2019 State of Food and Agriculture report. FAO. 2019. The State of Food and Agriculture 2019. Moving forward on food loss and waste reduction. Rome. Available at: http://www.fao.org/3/ca6030en/ca6030en.pdf The data was made available in the UN FAO’s interactive report accompanying the chart: http://www.fao.org/state-of-food-agriculture/en/. http://www.fao.org/3/ca6030en/ca6030en.pdf 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");