charts_x_entities

Data license: CC-BY

4 rows where entityId = 227282

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
5216,227282 Fish stocks and fishing intensity by region 5216 US West Coast 227282
5218,227282 Health of fish stocks by region 5218 US West Coast 227282
5222,227282 Fishing intensity by region 5222 US West Coast 227282
5224,227282 Annual fish catch relative to mean catch by region 5224 US West Coast 227282

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