charts_x_entities

Data license: CC-BY

6 rows where chartId = 3034

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
3034,34609 Wages relative to the price of energy 3034 London 34609
3034,36686 Wages relative to the price of energy 3034 Paris 36686
3034,36802 Wages relative to the price of energy 3034 Amsterdam 36802
3034,38029 Wages relative to the price of energy 3034 Beijing 38029
3034,38214 Wages relative to the price of energy 3034 Newcastle, England 38214
3034,38215 Wages relative to the price of energy 3034 Strasbourg, France 38215

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