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 = 5060 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
17791 Calories lost by food group and region (WRI, 2013) 
{
    "link": "http://pdf.wri.org/reducing_food_loss_and_waste.pdf",
    "retrievedDate": "22nd February 2020",
    "additionalInfo": "Data on food losses and waste includes all supply chain stages, from (and including) on-farm harvesting through to final food waste.\n\nFigures are based only on food intended for direct human consumption: this means crops diverted for animal feed or industrial uses are not included as losses.\n\nThe original authors of this study \u2013 Lipinski et al. (2013) of the World Resources Institute \u2013 calculate these figures based on the regional percentage losses expressed in the landmark UN FAO report on food losses: FAO (2011). Global food losses and food waste \u2013 Extent, causes and prevention. Rome.\n\nThis data is expressed for the year 2009 due to poor data availability and updated estimates since then. It is likely that, especially when expressed in relative terms (each region or food group's contribution to food losses) remains similar today.",
    "dataPublishedBy": "Lipinski, B. et al. (2013). \u201cReducing Food Loss and Waste.\u201d Working Paper, Installment 2 of Creating a Sustainable Food Future. Washington, DC: World Resources Institute."
}
 2020-02-24 17:32:19 2020-02-24 17:32:19 Calories lost by food group and region (WRI, 2013) 5060 Data on food losses and waste includes all supply chain stages, from (and including) on-farm harvesting through to final food waste. Figures are based only on food intended for direct human consumption: this means crops diverted for animal feed or industrial uses are not included as losses. The original authors of this study – Lipinski et al. (2013) of the World Resources Institute – calculate these figures based on the regional percentage losses expressed in the landmark UN FAO report on food losses: FAO (2011). Global food losses and food waste – Extent, causes and prevention. Rome. This data is expressed for the year 2009 due to poor data availability and updated estimates since then. It is likely that, especially when expressed in relative terms (each region or food group's contribution to food losses) remains similar today. http://pdf.wri.org/reducing_food_loss_and_waste.pdf Lipinski, B. et al. (2013). “Reducing Food Loss and Waste.” Working Paper, Installment 2 of Creating a Sustainable Food Future. Washington, DC: World Resources Institute.

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