charts_x_entities

Data license: CC-BY

5 rows where chartId = 4824

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
4824,84166 Share of species that are traded 4824 Mammals 84166
4824,84167 Share of species that are traded 4824 Birds 84167
4824,84168 Share of species that are traded 4824 Reptiles 84168
4824,84169 Share of species that are traded 4824 Amphibians 84169
4824,84171 Share of species that are traded 4824 Vertebrates 84171

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