charts_x_entities

Data license: CC-BY

6 rows where chartId = 1296

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
1296,321931 Births per year, by world region 1296 Northern America (UN) 321931
1296,321932 Births per year, by world region 1296 Latin America and the Caribbean (UN) 321932
1296,321934 Births per year, by world region 1296 Oceania (UN) 321934
1296,321935 Births per year, by world region 1296 Asia (UN) 321935
1296,321936 Births per year, by world region 1296 Europe (UN) 321936
1296,321937 Births per year, by world region 1296 Africa (UN) 321937

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