charts_x_entities

Data license: CC-BY

4 rows where entityId = 234182

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
5217,234182 Fish stocks and fishing intensity by group 5217 Cod and haddock 234182
5219,234182 Health of fish stocks by fish group 5219 Cod and haddock 234182
5223,234182 Fishing intensity 5223 Cod and haddock 234182
5225,234182 Annual fish catch relative to mean catch 5225 Cod and haddock 234182

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