chart_variables

Data license: CC-BY

1 row where chartId = 7142

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
7142,900048 Foreign policy free from interference of other states index 7142 Foreign policymaking free from foreign influence (best estimate, aggregate: average) 900048

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