charts_x_entities

Data license: CC-BY

6 rows where chartId = 6742

✎ View and edit SQL

This data as json, CSV (advanced)

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