charts_x_entities
Data license: CC-BY
7 rows where chartId = 828
This data as json, CSV (advanced)
Link | chartId | entityId |
---|---|---|
828,273 | Living Planet Index 828 | Africa 273 |
828,294 | Living Planet Index 828 | North America 294 |
828,300 | Living Planet Index 828 | Europe and Central Asia 300 |
828,343 | Living Planet Index 828 | Latin America and the Caribbean 343 |
828,355 | Living Planet Index 828 | World 355 |
828,52991 | Living Planet Index 828 | Asia and Pacific 52991 |
828,145639 | Living Planet Index 828 | Freshwater 145639 |
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");