charts_x_entities
Data license: CC-BY
6 rows where chartId = 1294
This data as json, CSV (advanced)
Link | chartId | entityId |
---|---|---|
1294,321931 | Number of deaths, by world region 1294 | Northern America (UN) 321931 |
1294,321932 | Number of deaths, by world region 1294 | Latin America and the Caribbean (UN) 321932 |
1294,321934 | Number of deaths, by world region 1294 | Oceania (UN) 321934 |
1294,321935 | Number of deaths, by world region 1294 | Asia (UN) 321935 |
1294,321936 | Number of deaths, by world region 1294 | Europe (UN) 321936 |
1294,321937 | Number of deaths, by world region 1294 | Africa (UN) 321937 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");