charts_x_entities

Data license: CC-BY

7 rows where chartId = 1402

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
1402,367017 Solar energy generation by region 1402 Europe (EI) 367017
1402,367020 Solar energy generation by region 1402 North America (EI) 367020
1402,367024 Solar energy generation by region 1402 Africa (EI) 367024
1402,367025 Solar energy generation by region 1402 South and Central America (EI) 367025
1402,367029 Solar energy generation by region 1402 Asia Pacific (EI) 367029
1402,367031 Solar energy generation by region 1402 CIS (EI) 367031
1402,367032 Solar energy generation by region 1402 Middle East (EI) 367032

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