charts_x_entities

Data license: CC-BY

6 rows where chartId = 7467

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
7467,273 Number of interstate conflicts 7467 Africa 273
7467,276 Number of interstate conflicts 7467 Europe 276
7467,290 Number of interstate conflicts 7467 Americas 290
7467,355 Number of interstate conflicts 7467 World 355
7467,25487 Number of interstate conflicts 7467 Middle East 25487
7467,29325 Number of interstate conflicts 7467 Asia and Oceania 29325

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