chart_variables

Data license: CC-BY

1 row where variableId = 918208

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
2138,918208 Prevalence of substance use disorders across age groups 2138 Current cases of substance use disorders in those aged 5-14 years, per 100 people  918208

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