charts_x_entities
Data license: CC-BY
4 rows where entityId = 227279
This data as json, CSV (advanced)
Link | chartId | entityId |
---|---|---|
5216,227279 | Fish stocks and fishing intensity by region 5216 | US Alaska 227279 |
5218,227279 | Health of fish stocks by region 5218 | US Alaska 227279 |
5222,227279 | Fishing intensity by region 5222 | US Alaska 227279 |
5224,227279 | Annual fish catch relative to mean catch by region 5224 | US Alaska 227279 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");