charts_x_entities

Data license: CC-BY

4 rows where chartId = 1370

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
1370,94020 Natural gas prices 1370 Netherlands TTF 94020
1370,367036 Natural gas prices 1370 US Henry Hub 367036
1370,369914 Natural gas prices 1370 UK NBP 369914
1370,369915 Natural gas prices 1370 Zeebrugge 369915

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