charts_x_entities

Data license: CC-BY

7 rows where chartId = 1401

✎ View and edit SQL

This data as json, CSV (advanced)

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