charts_x_entities

Data license: CC-BY

6 rows where chartId = 2780

✎ View and edit SQL

This data as json, CSV (advanced)

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