charts_x_entities

Data license: CC-BY

12 rows where chartId = 1550

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
1550,1 Genuine savings per capita 1550 United Kingdom 1
1550,3 Genuine savings per capita 1550 France 3
1550,6 Genuine savings per capita 1550 Germany 6
1550,7 Genuine savings per capita 1550 Switzerland 7
1550,13 Genuine savings per capita 1550 United States 13
1550,21 Genuine savings per capita 1550 Argentina 21
1550,23 Genuine savings per capita 1550 Australia 23
1550,37 Genuine savings per capita 1550 Brazil 37
1550,113 Genuine savings per capita 1550 Mexico 113
1550,170 Genuine savings per capita 1550 Colombia 170
1550,172 Genuine savings per capita 1550 Chile 172
1550,355 Genuine savings per capita 1550 World 355

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