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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
18035	Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science, 360(6392), 987-992.	{ "link": "https://science.sciencemag.org/content/360/6392/987", "additionalInfo": "Data is based on the largest meta-analysis of food system impact studies to date, from Poore & Nemecek's 2018 study.\n\nThe authors note the following about the scope of the studies included in this meta-analysis:\n\"We derived data from a comprehensive meta-analysis, identifying 1530 studies for potential inclusion, which were supplemented with additional data received from 139 authors. Studies were assessed against 11 criteria designed to standardize methodology, resulting in 570 suitable studies with a median reference year of 2010. The data set covers ~38,700 commercially viable farms in 119 countries and 40 products representing ~90% of global protein and calorie consumption'.\n\nAll comparisons here are based on the global mean value per food product across all studies.\n\nComparisons can be made in functional units: here all comparisons are made as impacts per kilogram of product.", "dataPublishedBy": "Poore, J., & Nemecek, T. (2018). Reducing food\u2019s environmental impacts through producers and consumers. Science, 360(6392), 987-992." }	2021-05-26 19:56:06	2021-05-26 19:56:06	Food emissions by life-cycle stage (Poore and Nemecek, 2018) 5315	Data is based on the largest meta-analysis of food system impact studies to date, from Poore & Nemecek's 2018 study. The authors note the following about the scope of the studies included in this meta-analysis: "We derived data from a comprehensive meta-analysis, identifying 1530 studies for potential inclusion, which were supplemented with additional data received from 139 authors. Studies were assessed against 11 criteria designed to standardize methodology, resulting in 570 suitable studies with a median reference year of 2010. The data set covers ~38,700 commercially viable farms in 119 countries and 40 products representing ~90% of global protein and calorie consumption'. All comparisons here are based on the global mean value per food product across all studies. Comparisons can be made in functional units: here all comparisons are made as impacts per kilogram of product.	https://science.sciencemag.org/content/360/6392/987	Poore, J., & Nemecek, T. (2018). Reducing food’s environmental impacts through producers and consumers. Science, 360(6392), 987-992.

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