charts_x_entities

Data license: CC-BY

3 rows where chartId = 1532

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
1532,3818 Freshwater use by aggregated region 1532 OECD 3818
1532,34562 Freshwater use by aggregated region 1532 BRICS 34562
1532,36311 Freshwater use by aggregated region 1532 ROW 36311

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