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 = 5301 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
18021 Cramer et al. (2020). Widespread loss of Caribbean acroporid corals was underway before coral bleaching and disease outbreaks. Science Advances. 
{
    "link": "https://advances.sciencemag.org/content/6/17/eaax9395",
    "retrievedDate": "23rd April 2021",
    "additionalInfo": "This study reconstructs historical trends in reef cover of the coral species Acropora in the Caribbean. It is measured by two variables:\n\u2013 the percentage of sites where Acropora was dominant\n\u2013 the percentage of sites where Acropora was present\n\nTo present this data as a time-series: where timings are given as a range, we have simplified the values into the mid-point year: e.g. 1960-1969 is given as the year 1965.",
    "dataPublishedBy": "Cramer, K. L., Jackson, J. B., Donovan, M. K., Greenstein, B. J., Korpanty, C. A., Cook, G. M., & Pandolfi, J. M. (2020). Widespread loss of Caribbean acroporid corals was underway before coral bleaching and disease outbreaks. Science Advances, 6(17), eaax9395."
}
 2021-04-23 05:10:00 2021-04-23 05:10:00 Caribbean reefs with acropora corals present (Cramer et al. 2020) 5301 This study reconstructs historical trends in reef cover of the coral species Acropora in the Caribbean. It is measured by two variables: – the percentage of sites where Acropora was dominant – the percentage of sites where Acropora was present To present this data as a time-series: where timings are given as a range, we have simplified the values into the mid-point year: e.g. 1960-1969 is given as the year 1965. https://advances.sciencemag.org/content/6/17/eaax9395 Cramer, K. L., Jackson, J. B., Donovan, M. K., Greenstein, B. J., Korpanty, C. A., Cook, G. M., & Pandolfi, J. M. (2020). Widespread loss of Caribbean acroporid corals was underway before coral bleaching and disease outbreaks. Science Advances, 6(17), eaax9395.

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