sources
Data license: CC-BY
1 row where datasetId = 5307 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
18027 | Mueller, N. et al. (2012). Closing yield gaps through nutrient and water management. Nature. | { "link": "https://www.nature.com/articles/nature11420", "additionalInfo": "Attainable yields are estimates of\u00a0feasible crop yields calculated from\u00a0high-yielding areas of similar climate. They are more conservative than biophysical \u2018potential yields\u2019, but should be achievable using current technologies and management (e.g. fertilizers and irrigation). Attainable yields are based on assessments for the year 2000. Attainable yield pre-2000 may be lower; and post-2000 may be higher than these values.\n\nYield gaps have been calculated by Our World in Data as the difference between actual observed yields (as reported by the UN FAO: http://www.fao.org/faostat/en/) and attainable yields, as reported by Mueller et al. (2012).", "dataPublishedBy": "Mueller, N. D., Gerber, J. S., Johnston, M., Ray, D. K., Ramankutty, N., & Foley, J. A. (2012). Closing yield gaps through nutrient and water management. Nature, 490(7419), 254-257." } |
2021-05-14 22:00:02 | 2021-05-14 22:00:02 | Attainable yields (Mueller et al. 2012) 5307 | Attainable yields are estimates of feasible crop yields calculated from high-yielding areas of similar climate. They are more conservative than biophysical ‘potential yields’, but should be achievable using current technologies and management (e.g. fertilizers and irrigation). Attainable yields are based on assessments for the year 2000. Attainable yield pre-2000 may be lower; and post-2000 may be higher than these values. Yield gaps have been calculated by Our World in Data as the difference between actual observed yields (as reported by the UN FAO: http://www.fao.org/faostat/en/) and attainable yields, as reported by Mueller et al. (2012). | https://www.nature.com/articles/nature11420 | Mueller, N. D., Gerber, J. S., Johnston, M., Ray, D. K., Ramankutty, N., & Foley, J. A. (2012). Closing yield gaps through nutrient and water management. Nature, 490(7419), 254-257. |
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");