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 = 5349 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
18069 West, Gerber, Engstrom, Mueller, Brauman, Carlson, Cassidy, Johnston, MacDonald, Ray & Siebert (2014). Leverage points for improving global food security and the environment. Science. 
{
    "link": "https://science.sciencemag.org/content/345/6194/325",
    "additionalInfo": "This data reprersents the nutrient balance of global croplands for nitrogen and phosphorous. It quantifies nutrient inputs to the crops across multiple sources \u2013 synthetic fertilizers, organic fertilizers such as manures, and nutrient fixation from legume crops. \n\nNutrient removal at harvest was estimated using nutrient density data for the dry fraction of harvested material. \"Excess nutrients\" is the difference between nutrient inputs and the amount harvested in crop material. This represents nutrients that are lost to the environment and can create ecological imbalances on ecosystems and in water bodies.",
    "dataPublishedBy": "West, P. C., Gerber, J. S., Engstrom, P. M., Mueller, N. D., Brauman, K. A., Carlson, K. M., ... & Siebert, S. (2014). Leverage points for improving global food security and the environment. Science, 345(6194), 325-328."
}
 2021-07-20 08:56:42 2021-07-20 08:56:42 Excess fertilizers (West et al. 2014) 5349 This data reprersents the nutrient balance of global croplands for nitrogen and phosphorous. It quantifies nutrient inputs to the crops across multiple sources – synthetic fertilizers, organic fertilizers such as manures, and nutrient fixation from legume crops. Nutrient removal at harvest was estimated using nutrient density data for the dry fraction of harvested material. "Excess nutrients" is the difference between nutrient inputs and the amount harvested in crop material. This represents nutrients that are lost to the environment and can create ecological imbalances on ecosystems and in water bodies. https://science.sciencemag.org/content/345/6194/325 West, P. C., Gerber, J. S., Engstrom, P. M., Mueller, N. D., Brauman, K. A., Carlson, K. M., ... & Siebert, S. (2014). Leverage points for improving global food security and the environment. Science, 345(6194), 325-328.

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