charts_x_entities

Data license: CC-BY

7 rows where chartId = 5786

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
5786,273 Free countries and territories 5786 Africa 273
5786,275 Free countries and territories 5786 Asia 275
5786,276 Free countries and territories 5786 Europe 276
5786,277 Free countries and territories 5786 Oceania 277
5786,294 Free countries and territories 5786 North America 294
5786,295 Free countries and territories 5786 South America 295
5786,355 Free countries and territories 5786 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");