charts_x_entities

Data license: CC-BY

7 rows where chartId = 1360

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
1360,367017 Oil production by region 1360 Europe (EI) 367017
1360,367020 Oil production by region 1360 North America (EI) 367020
1360,367024 Oil production by region 1360 Africa (EI) 367024
1360,367025 Oil production by region 1360 South and Central America (EI) 367025
1360,367029 Oil production by region 1360 Asia Pacific (EI) 367029
1360,367031 Oil production by region 1360 CIS (EI) 367031
1360,367032 Oil production by region 1360 Middle East (EI) 367032

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