charts_x_entities

Data license: CC-BY

7 rows where chartId = 1418

✎ View and edit SQL

This data as json, CSV (advanced)

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