charts_x_entities

Data license: CC-BY

16 rows where chartId = 653

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
653,13 Fossil fuel price index 653 United States 13
653,14 Fossil fuel price index 653 Japan 14
653,23 Fossil fuel price index 653 Australia 23
653,81 Fossil fuel price index 653 South Africa 81
653,136 Fossil fuel price index 653 Indonesia 136
653,170 Fossil fuel price index 653 Colombia 170
653,35435 Fossil fuel price index 653 Dubai 35435
653,35436 Fossil fuel price index 653 Brent 35436
653,35437 Fossil fuel price index 653 Nigerian Forcados 35437
653,37483 Fossil fuel price index 653 Northwest Europe 37483
653,94020 Fossil fuel price index 653 Netherlands TTF 94020
653,219452 Fossil fuel price index 653 West Texas Intermediate 219452
653,367036 Fossil fuel price index 653 US Henry Hub 367036
653,369913 Fossil fuel price index 653 South China 369913
653,369914 Fossil fuel price index 653 UK NBP 369914
653,369915 Fossil fuel price index 653 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");