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 = 5298 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
18018 Hughes, T. P., et al. (2018). Spatial and temporal patterns of mass bleaching of corals in the Anthropocene. Science. 
{
    "link": "https://science.sciencemag.org/content/359/6371/80",
    "retrievedDate": "13th April 2021",
    "additionalInfo": "Data on the frequency of coral bleaching events comes from the work of Hughes et al. (2018). This measures the number of moderate bleaching events (up to 30% of corals) and severe bleaching events (more than 30% corals) measured at 100 fixed global locations.\n\nOur World in Data have categorized these events by year based on the stage in the El Nino Southern Oscillation (ENSO) cycle. This is based on the Oceanic Nino Index (ONI) from this source: https://ggweather.com/enso/oni.htm\n\nThe ENSO or ONI categorizes years based on whether they are part of the El Nino (warm phase), La Nina (cool phase) or moderate (neither) stage of the cycle.",
    "dataPublishedBy": "Hughes, T. P., Anderson, K. D., Connolly, S. R., Heron, S. F., Kerry, J. T., Lough, J. M., ... & Wilson, S. K. (2018). Spatial and temporal patterns of mass bleaching of corals in the Anthropocene. Science, 359(6371), 80-83."
}
 2021-04-13 11:59:40 2021-04-13 11:59:40 Coral bleaching events by ENSO phase (Hughes et al. 2018) 5298 Data on the frequency of coral bleaching events comes from the work of Hughes et al. (2018). This measures the number of moderate bleaching events (up to 30% of corals) and severe bleaching events (more than 30% corals) measured at 100 fixed global locations. Our World in Data have categorized these events by year based on the stage in the El Nino Southern Oscillation (ENSO) cycle. This is based on the Oceanic Nino Index (ONI) from this source: https://ggweather.com/enso/oni.htm The ENSO or ONI categorizes years based on whether they are part of the El Nino (warm phase), La Nina (cool phase) or moderate (neither) stage of the cycle. https://science.sciencemag.org/content/359/6371/80 Hughes, T. P., Anderson, K. D., Connolly, S. R., Heron, S. F., Kerry, J. T., Lough, J. M., ... & Wilson, S. K. (2018). Spatial and temporal patterns of mass bleaching of corals in the Anthropocene. Science, 359(6371), 80-83.

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