chart_variables

Data license: CC-BY

1 row where variableId = 905898

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
463,905898 Tax revenue per capita and public health spending per capita 463 Domestic general government health expenditure per capita, PPP (current international $) 905898

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