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

2 rows where datasetId = 6019 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
29565 Ray et al. (2019) 
{
    "link": "https://journals.plos.org/plosone/article?id=10.1371/journal.pone.0217148",
    "retrievedDate": "2023-05-26",
    "additionalInfo": "\nRay et al. (2019) modelled the impact of observed climate change on yields of the top ten global crops. These ten crops account for ~83% of global kilocalorie production.\n\nThe impact of climate change on crop yields is calculated as the difference between actual observed yields under current climate conditions and the yields that would have been achieved until historical climate conditions.\n\nHistorical climate is defined as the 30-year average weather prior to 1974. Current climate is defined as the historical climate plus the addition of the linear trend of the weather for the 35 years ending in 2008, from the year 1974.\n",
    "dataPublishedBy": "Ray DK, West PC, Clark M, Gerber JS, Prishchepov AV, et al. (2019) Climate change has likely already affected global food production. PLOS ONE 14(5): e0217148. https://doi.org/10.1371/journal.pone.0217148"
}
 2023-12-14 12:03:33 2024-02-26 23:23:37 Climate impact on crop yields (Ray et al. (2019)) 6019 Ray et al. (2019) modelled the impact of observed climate change on yields of the top ten global crops. These ten crops account for ~83% of global kilocalorie production. The impact of climate change on crop yields is calculated as the difference between actual observed yields under current climate conditions and the yields that would have been achieved until historical climate conditions. Historical climate is defined as the 30-year average weather prior to 1974. Current climate is defined as the historical climate plus the addition of the linear trend of the weather for the 35 years ending in 2008, from the year 1974. https://journals.plos.org/plosone/article?id=10.1371/journal.pone.0217148 Ray DK, West PC, Clark M, Gerber JS, Prishchepov AV, et al. (2019) Climate change has likely already affected global food production. PLOS ONE 14(5): e0217148. https://doi.org/10.1371/journal.pone.0217148
27632 Ray et al. (2019) 
{
    "link": "https://journals.plos.org/plosone/article?id=10.1371/journal.pone.0217148",
    "retrievedDate": "2023-05-26",
    "additionalInfo": "Ray et al. (2019) modelled the impact of observed climate change on yields of the top ten global crops. These ten crops account for ~83% of global kilocalorie production.\n\nThe impact of climate change on crop yields is calculated as the difference between actual observed yields under current climate conditions and the yields that would have been achieved until historical climate conditions.\n\nHistorical climate is defined as the 30-year average weather prior to 1974. Current climate is defined as the historical climate plus the addition of the linear trend of the weather for the 35 years ending in 2008, from the year 1974.\n",
    "dataPublishedBy": "Ray DK, West PC, Clark M, Gerber JS, Prishchepov AV, et al. (2019) Climate change has likely already affected global food production. PLOS ONE 14(5): e0217148. https://doi.org/10.1371/journal.pone.0217148"
}
 2023-05-26 12:17:06 2024-02-26 23:23:36 Climate impact on crop yields (Ray et al. (2019)) 6019 Ray et al. (2019) modelled the impact of observed climate change on yields of the top ten global crops. These ten crops account for ~83% of global kilocalorie production. The impact of climate change on crop yields is calculated as the difference between actual observed yields under current climate conditions and the yields that would have been achieved until historical climate conditions. Historical climate is defined as the 30-year average weather prior to 1974. Current climate is defined as the historical climate plus the addition of the linear trend of the weather for the 35 years ending in 2008, from the year 1974. https://journals.plos.org/plosone/article?id=10.1371/journal.pone.0217148 Ray DK, West PC, Clark M, Gerber JS, Prishchepov AV, et al. (2019) Climate change has likely already affected global food production. PLOS ONE 14(5): e0217148. https://doi.org/10.1371/journal.pone.0217148

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