charts_x_entities

Data license: CC-BY

6 rows where chartId = 401

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
401,273 Population by world region 401 Africa 273
401,275 Population by world region 401 Asia 275
401,276 Population by world region 401 Europe 276
401,277 Population by world region 401 Oceania 277
401,294 Population by world region 401 North America 294
401,295 Population by world region 401 South America 295

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