charts_x_entities

Data license: CC-BY

13 rows where chartId = 3574

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
3574,19 African elephant carcass ratio 3574 Angola 19
3574,36 African elephant carcass ratio 3574 Botswana 36
3574,43 African elephant carcass ratio 3574 Cameroon 43
3574,60 African elephant carcass ratio 3574 Zambia 60
3574,64 African elephant carcass ratio 3574 Tanzania 64
3574,68 African elephant carcass ratio 3574 Uganda 68
3574,80 African elephant carcass ratio 3574 Zimbabwe 80
3574,109 African elephant carcass ratio 3574 Mozambique 109
3574,115 African elephant carcass ratio 3574 Mali 115
3574,117 African elephant carcass ratio 3574 Malawi 117
3574,129 African elephant carcass ratio 3574 Kenya 129
3574,173 African elephant carcass ratio 3574 Chad 173
3574,273 African elephant carcass ratio 3574 Africa 273

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