charts_x_entities

Data license: CC-BY

6 rows where chartId = 7270

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
7270,276 Deaths in wars 7270 Europe 276
7270,289 Deaths in wars 7270 Sub-Saharan Africa 289
7270,290 Deaths in wars 7270 Americas 290
7270,355 Deaths in wars 7270 World 355
7270,29325 Deaths in wars 7270 Asia and Oceania 29325
7270,367338 Deaths in wars 7270 North Africa and the Middle East 367338

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");