chart_variables

Data license: CC-BY

2 rows where chartId = 7559

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
7559,820028 Number of new cars sold, by type 7559 Electric cars sold 820028
7559,820035 Number of new cars sold, by type 7559 Non-electric car sales 820035

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