chart_variables

Data license: CC-BY

1 row where variableId = 1979

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
684,1979 How much we think we spend on healthcare vs. how much we actually do 684 How much we actually spend on health expenditure (IPSOS (2016)) 1979

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