charts_x_entities

Data license: CC-BY

10 rows where chartId = 596

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
596,6 Renewable energy investment 596 Germany 6
596,13 Renewable energy investment 596 United States 13
596,14 Renewable energy investment 596 Japan 14
596,37 Renewable energy investment 596 Brazil 37
596,81 Renewable energy investment 596 South Africa 81
596,113 Renewable energy investment 596 Mexico 113
596,137 Renewable energy investment 596 India 137
596,171 Renewable energy investment 596 China 171
596,172 Renewable energy investment 596 Chile 172
596,30400 Renewable energy investment 596 UK 30400

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