charts_x_entities

Data license: CC-BY

7 rows where chartId = 1357

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
1357,367017 Oil consumption by region 1357 Europe (EI) 367017
1357,367020 Oil consumption by region 1357 North America (EI) 367020
1357,367024 Oil consumption by region 1357 Africa (EI) 367024
1357,367025 Oil consumption by region 1357 South and Central America (EI) 367025
1357,367029 Oil consumption by region 1357 Asia Pacific (EI) 367029
1357,367031 Oil consumption by region 1357 CIS (EI) 367031
1357,367032 Oil consumption by region 1357 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");