charts_x_entities

Data license: CC-BY

7 rows where chartId = 5684

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
5684,273 Liberal democracy index 5684 Africa 273
5684,275 Liberal democracy index 5684 Asia 275
5684,276 Liberal democracy index 5684 Europe 276
5684,277 Liberal democracy index 5684 Oceania 277
5684,294 Liberal democracy index 5684 North America 294
5684,295 Liberal democracy index 5684 South America 295
5684,355 Liberal democracy index 5684 World 355

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