sources
Data license: CC-BY
1 row where datasetId = 5239 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 |
---|---|---|---|---|---|---|---|---|
17968 | Evans, D. L., Quinton, J. N., Davies, J. A. C., Zhao, J., & Govers, G. (2020). Soil lifespans and how they can be extended by land use and management change. | { "link": "https://iopscience.iop.org/article/10.1088/1748-9326/aba2fd", "retrievedDate": "11th January 2021", "dataPublishedBy": "Evans, D. L., Quinton, J. N., Davies, J. A. C., Zhao, J., & Govers, G. (2020). Soil lifespans and how they can be extended by land use and management change. Environmental Research Letters, 15(9), 0940b2." } |
2021-01-11 12:57:57 | 2021-01-11 12:57:57 | Soil Lifespans (Evans et al. 2020) 5239 | https://iopscience.iop.org/article/10.1088/1748-9326/aba2fd | Evans, D. L., Quinton, J. N., Davies, J. A. C., Zhao, J., & Govers, G. (2020). Soil lifespans and how they can be extended by land use and management change. Environmental Research Letters, 15(9), 0940b2. |
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");