chart_dimensions

Data license: CC-BY

4 rows where chartId = 2357

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date)

id ▼ order property chartId variableId createdAt updatedAt
261000 0 y Difference in the value of goods exported to and imported by the US vs. GDP per capita 2357 Difference in the value of goods exported to and imported by the US (DOTS (2017)) 85967 2024-07-17 09:52:31  
261001 1 x Difference in the value of goods exported to and imported by the US vs. GDP per capita 2357 GDP per capita (constant 2015 US$) 905517 2024-07-17 09:52:31  
261002 2 size Difference in the value of goods exported to and imported by the US vs. GDP per capita 2357 Population (historical) 953903 2024-07-17 09:52:31  
261003 3 color Difference in the value of goods exported to and imported by the US vs. GDP per capita 2357 Countries Continents 123 2024-07-17 09:52:31  

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