charts_x_entities

Data license: CC-BY

7 rows where chartId = 1356

✎ View and edit SQL

This data as json, CSV (advanced)

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