charts_x_entities

Data license: CC-BY

7 rows where chartId = 1361

✎ View and edit SQL

This data as json, CSV (advanced)

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