charts_x_entities

Data license: CC-BY

11 rows where chartId = 6997

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
6997,289 Terrorism deaths by region 6997 Sub-Saharan Africa 289
6997,293 Terrorism deaths by region 6997 Middle East & North Africa 293
6997,294 Terrorism deaths by region 6997 North America 294
6997,295 Terrorism deaths by region 6997 South America 295
6997,302 Terrorism deaths by region 6997 South Asia 302
6997,469 Terrorism deaths by region 6997 Central Asia 469
6997,473 Terrorism deaths by region 6997 Eastern Europe 473
6997,34613 Terrorism deaths by region 6997 East Asia 34613
6997,34614 Terrorism deaths by region 6997 Southeast Asia 34614
6997,35488 Terrorism deaths by region 6997 Central America & Caribbean 35488
6997,51752 Terrorism deaths by region 6997 Australasia & Oceania 51752

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