charts_x_entities

Data license: CC-BY

4 rows where entityId = 34562

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
1532,34562 Freshwater use by aggregated region 1532 BRICS 34562
1538,34562 How have things changed? 1538 BRICS 34562
1797,34562 Industry jobs as a share of total employment 1797 BRICS 34562
2298,34562 Female labor force by age 2298 BRICS 34562

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