charts_x_entities

Data license: CC-BY

6 rows where chartId = 7275

✎ View and edit SQL

This data as json, CSV (advanced)

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