chart_variables

Data license: CC-BY

1 row where variableId = 104398

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
3441,104398 Rotavirus deaths that were preventable in children under five 3441 Avertable deaths if rotavirus vaccine coverage was 100% (Troegers, 2018) 104398

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