chart_variables

Data license: CC-BY

1 row where chartId = 3723

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
3723,105715 Unemployed jobseekers relying on contacts for job search 3723 Percentage of unemployed using friends, relatives, trade unions, etc. in job search 105715

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