charts_x_entities

Data license: CC-BY

8 rows where chartId = 1369

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
1369,13 Coal prices 1369 United States 13
1369,14 Coal prices 1369 Japan 14
1369,23 Coal prices 1369 Australia 23
1369,81 Coal prices 1369 South Africa 81
1369,136 Coal prices 1369 Indonesia 136
1369,170 Coal prices 1369 Colombia 170
1369,37483 Coal prices 1369 Northwest Europe 37483
1369,369913 Coal prices 1369 South China 369913

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