charts_x_entities

Data license: CC-BY

4 rows where chartId = 3565

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
3565,101 Indian rhino population 3565 Pakistan 101
3565,107 Indian rhino population 3565 Nepal 107
3565,137 Indian rhino population 3565 India 137
3565,355 Indian rhino population 3565 World 355

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