chart_variables

Data license: CC-BY

2 rows where chartId = 6529

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
6529,123 Drug use disorder death rate 6529 Countries Continents 123
6529,527240 Drug use disorder death rate 6529 Death rate from drug use disorders among both sexes 527240

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