charts_x_entities

Data license: CC-BY

6 rows where chartId = 2785

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
2785,273 Coffee production by region 2785 Africa 273
2785,275 Coffee production by region 2785 Asia 275
2785,276 Coffee production by region 2785 Europe 276
2785,277 Coffee production by region 2785 Oceania 277
2785,294 Coffee production by region 2785 North America 294
2785,295 Coffee production by region 2785 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");