charts_x_entities

Data license: CC-BY

5 rows where chartId = 7476

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
7476,276 Deaths in wars by region 7476 Europe 276
7476,289 Deaths in wars by region 7476 Sub-Saharan Africa 289
7476,290 Deaths in wars by region 7476 Americas 290
7476,29325 Deaths in wars by region 7476 Asia and Oceania 29325
7476,367338 Deaths in wars by region 7476 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");