charts_x_entities

Data license: CC-BY

10 rows where chartId = 2818

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
2818,1 How Europeans spend their time 2818 United Kingdom 1
2818,3 How Europeans spend their time 2818 France 3
2818,4 How Europeans spend their time 2818 Belgium 4
2818,6 How Europeans spend their time 2818 Germany 6
2818,10 How Europeans spend their time 2818 Sweden 10
2818,83 How Europeans spend their time 2818 Slovenia 83
2818,102 How Europeans spend their time 2818 Norway 102
2818,138 How Europeans spend their time 2818 Hungary 138
2818,155 How Europeans spend their time 2818 Finland 155
2818,156 How Europeans spend their time 2818 Estonia 156

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