charts_x_entities

Data license: CC-BY

4 rows where entityId = 367010

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
552,367010 Solar (photovoltaic) panels cumulative capacity 552 Asia (IRENA) 367010
1405,367010 Installed solar energy capacity 1405 Asia (IRENA) 367010
1411,367010 Installed wind energy capacity 1411 Asia (IRENA) 367010
1416,367010 Installed geothermal energy capacity 1416 Asia (IRENA) 367010

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