charts_x_entities

Data license: CC-BY

6 rows where chartId = 7470

✎ View and edit SQL

This data as json, CSV (advanced)

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