chart_dimensions

Data license: CC-BY

8 rows where chartId = 912

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date)

id ▼ order property chartId variableId createdAt updatedAt
229316 0 y Long-term energy transitions 912 Primary electricity (Energy History, Harvard (2016)) 8669 2023-12-21 12:27:27  
229317 1 y Long-term energy transitions 912 Natural Gas (Energy History, Harvard (2016)) 8668 2023-12-21 12:27:27  
229318 2 y Long-term energy transitions 912 Oil (Energy History, Harvard (2016)) 8667 2023-12-21 12:27:27  
229319 3 y Long-term energy transitions 912 Coal (Energy History, Harvard (2016)) 8666 2023-12-21 12:27:27  
229320 4 y Long-term energy transitions 912 Water & Wind (Energy History, Harvard (2016)) 8665 2023-12-21 12:27:27  
229321 5 y Long-term energy transitions 912 Fuelwood (Energy History, Harvard (2016)) 8664 2023-12-21 12:27:27  
229322 6 y Long-term energy transitions 912 Animal muscle (Energy History, Harvard (2016)) 8663 2023-12-21 12:27:27  
229323 7 y Long-term energy transitions 912 Human muscle (Energy History, Harvard (2016)) 8662 2023-12-21 12:27:27  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "chart_dimensions" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"order" INTEGER NOT NULL  ,
	"property" VARCHAR(255) NOT NULL  ,
	"chartId" INTEGER NOT NULL  ,
	"variableId" INTEGER NOT NULL  ,
	"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	"updatedAt" DATETIME NULL,
	FOREIGN KEY("chartId") REFERENCES "charts" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
	FOREIGN KEY("variableId") REFERENCES "variables" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "chart_dimensions_chartId_78d6a092_fk_charts_id" ON "chart_dimensions" ("chartId");
CREATE INDEX "chart_dimensions_variableId_9ba778e6_fk_variables_id" ON "chart_dimensions" ("variableId");