chart_variables

Data license: CC-BY

3 rows where chartId = 653

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
653,943969 Fossil fuel price index 653 Coal price index 943969
653,943974 Fossil fuel price index 653 Gas price index 943974
653,943983 Fossil fuel price index 653 Oil spot crude price index 943983

Advanced export

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

CSV options: 

CREATE TABLE chart_variables
            (
                `chartId` integer NOT NULL,
                `variableId` integer NOT NULL,
                PRIMARY KEY (`chartId`, `variableId`),
                CONSTRAINT `FK_chart_variables_chartId` FOREIGN KEY (`chartId`) REFERENCES `charts` (`id`) ON DELETE CASCADE,
                CONSTRAINT `FK_chart_variables_variableId` FOREIGN KEY (`variableId`) REFERENCES `variables` (`id`) ON DELETE CASCADE
            );