charts_x_entities

Data license: CC-BY

14 rows where chartId = 5223

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
5223,225490 Fishing intensity 5223 Tuna 225490
5223,227283 Fishing intensity 5223 Bivalves and gastropods 227283
5223,227284 Fishing intensity 5223 Mackerels 227284
5223,227285 Fishing intensity 5223 Cephalopods (e.g. octopus, squid) 227285
5223,227286 Fishing intensity 5223 Crabs and lobsters 227286
5223,227288 Fishing intensity 5223 Forage fish 227288
5223,227290 Fishing intensity 5223 Other marine fish 227290
5223,227291 Fishing intensity 5223 Other marine percoidids 227291
5223,227292 Fishing intensity 5223 Other scorpaenids 227292
5223,227295 Fishing intensity 5223 Shrimps 227295
5223,234181 Fishing intensity 5223 Sharks and rays 234181
5223,234182 Fishing intensity 5223 Cod and haddock 234182
5223,234183 Fishing intensity 5223 Flounder 234183
5223,234184 Fishing intensity 5223 Perch and rockfish 234184

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