charts_x_entities

Data license: CC-BY

7 rows where chartId = 5565

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
5565,273 Number of democracies by age 5565 Africa 273
5565,275 Number of democracies by age 5565 Asia 275
5565,276 Number of democracies by age 5565 Europe 276
5565,277 Number of democracies by age 5565 Oceania 277
5565,294 Number of democracies by age 5565 North America 294
5565,295 Number of democracies by age 5565 South America 295
5565,355 Number of democracies by age 5565 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");