chart_variables

Data license: CC-BY

1 row where chartId = 6035

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
6035,936233 Deaths attributed to lack of access to handwashing facilities 6035 Total number of deaths from all causes attributed to no access to handwashing facility  936233

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