charts_x_entities

Data license: CC-BY

7 rows where chartId = 5686

✎ View and edit SQL

This data as json, CSV (advanced)

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