charts_x_entities

Data license: CC-BY

7 rows where chartId = 5793

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
5793,273 Democracy index 5793 Africa 273
5793,275 Democracy index 5793 Asia 275
5793,276 Democracy index 5793 Europe 276
5793,277 Democracy index 5793 Oceania 277
5793,294 Democracy index 5793 North America 294
5793,295 Democracy index 5793 South America 295
5793,355 Democracy index 5793 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");