charts_x_entities

Data license: CC-BY

6 rows where chartId = 7463

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
7463,276 Number of wars 7463 Europe 276
7463,289 Number of wars 7463 Sub-Saharan Africa 289
7463,290 Number of wars 7463 Americas 290
7463,355 Number of wars 7463 World 355
7463,29325 Number of wars 7463 Asia and Oceania 29325
7463,367338 Number of wars 7463 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");