charts_x_entities

Data license: CC-BY

2 rows where entityId = 225505

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
5145,225505 Global fish discards by type of fishing gear 5145 Boat dredge 225505
5147,225505 Share of fish catch that is discarded by type of gear used 5147 Boat dredge 225505

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