chart_variables

Data license: CC-BY

1 row where variableId = 714401

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
6858,714401 Alcohol and drug use disorders deaths by age 6858 Deaths from substance use disorders among both sexes aged 50-69 year olds  714401

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