charts_x_entities

Data license: CC-BY

4 rows where chartId = 1368

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
1368,35435 Crude oil spot prices 1368 Dubai 35435
1368,35436 Crude oil spot prices 1368 Brent 35436
1368,35437 Crude oil spot prices 1368 Nigerian Forcados 35437
1368,219452 Crude oil spot prices 1368 West Texas Intermediate 219452

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