chart_dimensions

Data license: CC-BY

6 rows where chartId = 2903

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date)

id ▼ order property chartId variableId createdAt updatedAt
250265 0 y Globalization over 5 centuries 2903 World trade based on Maddison (% of GDP) (Klasing and Milionis (2014))  97701 2024-05-31 07:03:42  
250266 1 y Globalization over 5 centuries 2903 World trade - upper bound (% of GDP) (Estevadeordal, Frantz, and Taylor (2003)) 97702 2024-05-31 07:03:42  
250267 2 y Globalization over 5 centuries 2903 World trade based on own estimates (% of GDP) (Klasing and Milionis (2014))  97700 2024-05-31 07:03:42  
250268 3 y Globalization over 5 centuries 2903 World trade - lower bound (% of GDP) (Estevadeordal, Frantz, and Taylor (2003)) 97703 2024-05-31 07:03:42  
250269 4 y Globalization over 5 centuries 2903 Trade (% of GDP) 905427 2024-05-31 07:03:42  
250270 5 y Globalization over 5 centuries 2903 Trade openness (share of exports and imports in GDP) 539765 2024-05-31 07:03:42  

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