charts_x_entities

Data license: CC-BY

6 rows where entityId = 367027

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
1379,367027 Oil production 1379 OPEC (EI) 367027
1538,367027 How have things changed? 1538 OPEC (EI) 367027
3878,367027 Fossil fuel production 3878 OPEC (EI) 367027
5480,367027 Oil reserves 5480 OPEC (EI) 367027
6363,367027 Primary energy consumption from solar and wind 6363 OPEC (EI) 367027
6367,367027 Annual change in solar and wind energy generation 6367 OPEC (EI) 367027

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