sources
Data license: CC-BY
1 row where datasetId = 979 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 |
---|---|---|---|---|---|---|---|---|
6838 | Population fed by Haber-Bosch fertilizers - Erisman et al. (2008) | { "link": "https://www.nature.com/articles/ngeo325", "retrievedDate": "2017-10-24", "additionalInfo": "\r\n\tAdditional information: \r\nEstimates of population sustained with and without the production of Haber-Bosch nitrogen are derived based on Figure 1 in Erisman et al. (2008) and its sources.\r\nWorld population figures were sourced from Gapminder for the years 1900-1949, and from the UN Population Division from 1950 onwards.\r\nThe share of the world's population reliant on Haber-Bosch fertilizer production for food production was estimated based on Figure 1 in Erisman et al. (2008). These figures are based on approximation, although coincide with several published projections of these estimates. Erisman et al. estimate that by 2000, 44% of the global population were sustained by Haber-Bosch nitrogen, rising to 48% by 2008. This approximately coincides with Smil (2002) estimates of 40% by 2000. OWID have extrapolated these estimates to 2015, assuming that approximately 50% (\u00b12%) rely on Haber-Bosch nitrogen.\r\nErisman, J. W., Sutton, M. A., Galloway, J., Klimont, Z., & Winiwarter, W. (2008). How a century of ammonia synthesis changed the world. Nature Geoscience, 1(10), 636-639. Available at: https://www.nature.com/articles/ngeo325 [accessed 14th October 2017].\r\nSmil, V. (2002). Nitrogen and food production: proteins for human diets. AMBIO: A Journal of the Human Environment, 31(2), 126-131. Available at: http://www.bioone.org/doi/abs/10.1579/0044-7447-31.2.126 [accessed 24th October 2017].\r\nStewart, W. M., Dibb, D. W., Johnston, A. E., & Smyth, T. J. (2005). The contribution of commercial fertilizer nutrients to food production. Agronomy Journal, 97(1), 1-6. Available at: https://dl.sciencesocieties.org/publications/aj/abstracts/97/1/0001 [accessed 24th October 2017].\r\n\r\n", "dataPublishedBy": "Erisman, J. W., Sutton, M. A., Galloway, J., Klimont, Z., & Winiwarter, W. (2008). How a century of ammonia synthesis changed the world. Nature Geoscience, 1(10), 636-639.", "dataPublisherSource": "Literature review and author's calculations" } |
2017-10-24 14:57:21 | 2017-11-02 13:04:39 | Population fed by Haber-Bosch fertilizers - FAO (2017) 979 | Additional information: Estimates of population sustained with and without the production of Haber-Bosch nitrogen are derived based on Figure 1 in Erisman et al. (2008) and its sources. World population figures were sourced from Gapminder for the years 1900-1949, and from the UN Population Division from 1950 onwards. The share of the world's population reliant on Haber-Bosch fertilizer production for food production was estimated based on Figure 1 in Erisman et al. (2008). These figures are based on approximation, although coincide with several published projections of these estimates. Erisman et al. estimate that by 2000, 44% of the global population were sustained by Haber-Bosch nitrogen, rising to 48% by 2008. This approximately coincides with Smil (2002) estimates of 40% by 2000. OWID have extrapolated these estimates to 2015, assuming that approximately 50% (±2%) rely on Haber-Bosch nitrogen. Erisman, J. W., Sutton, M. A., Galloway, J., Klimont, Z., & Winiwarter, W. (2008). How a century of ammonia synthesis changed the world. Nature Geoscience, 1(10), 636-639. Available at: https://www.nature.com/articles/ngeo325 [accessed 14th October 2017]. Smil, V. (2002). Nitrogen and food production: proteins for human diets. AMBIO: A Journal of the Human Environment, 31(2), 126-131. Available at: http://www.bioone.org/doi/abs/10.1579/0044-7447-31.2.126 [accessed 24th October 2017]. Stewart, W. M., Dibb, D. W., Johnston, A. E., & Smyth, T. J. (2005). The contribution of commercial fertilizer nutrients to food production. Agronomy Journal, 97(1), 1-6. Available at: https://dl.sciencesocieties.org/publications/aj/abstracts/97/1/0001 [accessed 24th October 2017]. | https://www.nature.com/articles/ngeo325 | Erisman, J. W., Sutton, M. A., Galloway, J., Klimont, Z., & Winiwarter, W. (2008). How a century of ammonia synthesis changed the world. Nature Geoscience, 1(10), 636-639. |
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");