charts_x_entities

Data license: CC-BY

6 rows where chartId = 2587

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
2587,273 Number of armed conflicts 2587 Africa 273
2587,276 Number of armed conflicts 2587 Europe 276
2587,290 Number of armed conflicts 2587 Americas 290
2587,355 Number of armed conflicts 2587 World 355
2587,25487 Number of armed conflicts 2587 Middle East 25487
2587,29325 Number of armed conflicts 2587 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");