charts_x_entities

Data license: CC-BY

5 rows where chartId = 4887

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
4887,355 Number of coral bleaching events 4887 World 355
4887,435 Number of coral bleaching events 4887 Australasia 435
4887,34705 Number of coral bleaching events 4887 Pacific 34705
4887,187394 Number of coral bleaching events 4887 Indian Ocean/Middle East 187394
4887,187395 Number of coral bleaching events 4887 West Atlantic 187395

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "charts_x_entities" (
	"chartId" INTEGER NOT NULL  ,
	"entityId" INTEGER NOT NULL  ,
	PRIMARY KEY ("chartId", "entityId"),
	FOREIGN KEY("chartId") REFERENCES "charts" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
	FOREIGN KEY("entityId") REFERENCES "entities" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "entityId" ON "charts_x_entities" ("entityId");