charts_x_entities

Data license: CC-BY

5 rows where entityId = 367033

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
5612,367033 Lithium production 5612 Rest of World (EI) 367033
5613,367033 Cobalt production 5613 Rest of World (EI) 367033
5614,367033 Graphite production 5614 Rest of World (EI) 367033
6363,367033 Primary energy consumption from solar and wind 6363 Rest of World (EI) 367033
6367,367033 Annual change in solar and wind energy generation 6367 Rest of World (EI) 367033

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