charts_x_entities
Data license: CC-BY
7 rows where chartId = 5691
This data as json, CSV (advanced)
Link | chartId | entityId |
---|---|---|
5691,273 | Deliberative democracy index 5691 | Africa 273 |
5691,275 | Deliberative democracy index 5691 | Asia 275 |
5691,276 | Deliberative democracy index 5691 | Europe 276 |
5691,277 | Deliberative democracy index 5691 | Oceania 277 |
5691,294 | Deliberative democracy index 5691 | North America 294 |
5691,295 | Deliberative democracy index 5691 | South America 295 |
5691,355 | Deliberative democracy index 5691 | World 355 |
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");