chart_variables

Data license: CC-BY

2 rows where variableId = 901298

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
6301,901298 GDP per capita in the long run comparison 6301 GDP per capita 901298
7543,901298 Global average GDP per capita over the long run 7543 GDP per capita 901298

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