charts_x_entities

Data license: CC-BY

5 rows where chartId = 2766

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
2766,273 Cocoa bean production by region 2766 Africa 273
2766,275 Cocoa bean production by region 2766 Asia 275
2766,277 Cocoa bean production by region 2766 Oceania 277
2766,294 Cocoa bean production by region 2766 North America 294
2766,295 Cocoa bean production by region 2766 South America 295

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