charts_x_entities

Data license: CC-BY

6 rows where chartId = 5599

✎ View and edit SQL

This data as json, CSV (advanced)

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