charts_x_entities
Data license: CC-BY
6 rows where chartId = 7456
This data as json, CSV (advanced)
Link | chartId | entityId |
---|---|---|
7456,273 | Deaths in interstate conflicts 7456 | Africa 273 |
7456,276 | Deaths in interstate conflicts 7456 | Europe 276 |
7456,290 | Deaths in interstate conflicts 7456 | Americas 290 |
7456,355 | Deaths in interstate conflicts 7456 | World 355 |
7456,25487 | Deaths in interstate conflicts 7456 | Middle East 25487 |
7456,29325 | Deaths in interstate conflicts 7456 | Asia and Oceania 29325 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");