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

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
17976	Searchinger, T. D., Wirsenius, S., Beringer, T., & Dumas, P. (2018). Assessing the efficiency of changes in land use for mitigating climate change. Nature.	{ "link": "https://www.nature.com/articles/s41586-018-0757-z", "retrievedDate": "28th January 2021", "additionalInfo": "The Carbon Opportunity Cost (COC) of each crop is equal to the amount of carbon lost from native vegetation and soils in order to produce a given food product. If food products were not produced on a given plot of land, this land could be used to restore native vegetation and sequester carbon.\n\nBecause carbon storage is lost quickly but crop production can continue indefinitely, any system for evaluating the carbon costs of land use must in some way address the relative costs of emissions over time. Much of the discussion focuses on the value of up-front versus later mitigation. In general, this question can be thought as a question about what is the relative value of reducing emissions sooner rather than later. Searchinger et al. (2018) apply a 4% time 'discount rate' over 100 years. The the choice of a discount rate and a carbon value trajectory is a question of policy; the authors selected a 4% discount rate as their central scenario because it is roughly consistent with U.S. bioenergy policies.", "dataPublishedBy": "Searchinger, T. D., Wirsenius, S., Beringer, T., & Dumas, P. (2018). Assessing the efficiency of changes in land use for mitigating climate change. Nature, 564(7735), 249-253." }	2021-01-28 10:52:16	2021-01-28 10:52:16	Carbon Opportunity Costs by Food (Searchinger et al. 2018) 5247	The Carbon Opportunity Cost (COC) of each crop is equal to the amount of carbon lost from native vegetation and soils in order to produce a given food product. If food products were not produced on a given plot of land, this land could be used to restore native vegetation and sequester carbon. Because carbon storage is lost quickly but crop production can continue indefinitely, any system for evaluating the carbon costs of land use must in some way address the relative costs of emissions over time. Much of the discussion focuses on the value of up-front versus later mitigation. In general, this question can be thought as a question about what is the relative value of reducing emissions sooner rather than later. Searchinger et al. (2018) apply a 4% time 'discount rate' over 100 years. The the choice of a discount rate and a carbon value trajectory is a question of policy; the authors selected a 4% discount rate as their central scenario because it is roughly consistent with U.S. bioenergy policies.	https://www.nature.com/articles/s41586-018-0757-z	Searchinger, T. D., Wirsenius, S., Beringer, T., & Dumas, P. (2018). Assessing the efficiency of changes in land use for mitigating climate change. Nature, 564(7735), 249-253.

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