chart_dimensions
Data license: CC-BY
8 rows where chartId = 3273
This data as json, CSV (advanced)
Suggested facets: createdAt (date)
id ▼ | order | property | chartId | variableId | createdAt | updatedAt |
---|---|---|---|---|---|---|
59510 | 0 | y | Coal by end user in the United Kingdom 3273 | Coal by end use (Gas) 143368 | 2023-02-09 10:09:04 | |
59511 | 1 | y | Coal by end user in the United Kingdom 3273 | Coal by end use (Industry) 143372 | 2023-02-09 10:09:04 | |
59512 | 2 | y | Coal by end user in the United Kingdom 3273 | Coal by end use (Railways) 143370 | 2023-02-09 10:09:04 | |
59513 | 3 | y | Coal by end user in the United Kingdom 3273 | Coal by end use (Electricity) 143367 | 2023-02-09 10:09:04 | |
59514 | 4 | y | Coal by end user in the United Kingdom 3273 | Coal by end use (Domestic) 143371 | 2023-02-09 10:09:04 | |
59515 | 5 | y | Coal by end user in the United Kingdom 3273 | Coal by end use (Collieries) 143366 | 2023-02-09 10:09:04 | |
59516 | 6 | y | Coal by end user in the United Kingdom 3273 | Coal by end use (Miscellaneous) 143373 | 2023-02-09 10:09:04 | |
59517 | 7 | y | Coal by end user in the United Kingdom 3273 | Coal by end use (Coke ovens & solid fuels) 143369 | 2023-02-09 10:09:04 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");