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 = 5334 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
18054 Aizen et al. (2019). Global agricultural productivity is threatened by increasing pollinator dependence without a parallel increase in crop diversification. Global Change Biology. 
{
    "link": "https://onlinelibrary.wiley.com/doi/full/10.1111/gcb.14736",
    "additionalInfo": "Crops were characterized according to the extent to which biotic pollination contributes to their yield. A crop is considered to be pollinator-dependent if animal pollination is required to increase the quantity and/or the quality of fruits or seeds directly consumed by humans. This means that in the absence of pollination these crops would have lower yields, but most would still continue to grow.",
    "dataPublishedBy": "Aizen, M. A., Aguiar, S., Biesmeijer, J. C., Garibaldi, L. A., Inouye, D. W., Jung, C., ... & Seymour, C. L. (2019). Global agricultural productivity is threatened by increasing pollinator dependence without a parallel increase in crop diversification. Global change biology, 25(10), 3516-3527."
}
 2021-06-23 19:43:58 2021-06-23 19:43:58 Pollinator dependency of agriculture (Aizen et al. 2019) 5334 Crops were characterized according to the extent to which biotic pollination contributes to their yield. A crop is considered to be pollinator-dependent if animal pollination is required to increase the quantity and/or the quality of fruits or seeds directly consumed by humans. This means that in the absence of pollination these crops would have lower yields, but most would still continue to grow. https://onlinelibrary.wiley.com/doi/full/10.1111/gcb.14736 Aizen, M. A., Aguiar, S., Biesmeijer, J. C., Garibaldi, L. A., Inouye, D. W., Jung, C., ... & Seymour, C. L. (2019). Global agricultural productivity is threatened by increasing pollinator dependence without a parallel increase in crop diversification. Global change biology, 25(10), 3516-3527.

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