charts_x_entities

Data license: CC-BY

7 rows where chartId = 1409

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
1409,367017 Wind energy generation by region 1409 Europe (EI) 367017
1409,367020 Wind energy generation by region 1409 North America (EI) 367020
1409,367024 Wind energy generation by region 1409 Africa (EI) 367024
1409,367025 Wind energy generation by region 1409 South and Central America (EI) 367025
1409,367029 Wind energy generation by region 1409 Asia Pacific (EI) 367029
1409,367031 Wind energy generation by region 1409 CIS (EI) 367031
1409,367032 Wind energy generation by region 1409 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");