charts_x_entities

Data license: CC-BY

2 rows where entityId = 37233

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
5957,37233 What items of waste do we find in rivers and the ocean? 5957 Wood 37233
5958,37233 Most common items of waste in the ocean by region 5958 Wood 37233

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