charts_x_entities

Data license: CC-BY

6 rows where chartId = 7465

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
7465,273 Rate of wars 7465 Africa 273
7465,276 Rate of wars 7465 Europe 276
7465,290 Rate of wars 7465 Americas 290
7465,355 Rate of wars 7465 World 355
7465,25487 Rate of wars 7465 Middle East 25487
7465,29325 Rate of wars 7465 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");