chart_variables

Data license: CC-BY

1 row where variableId = 902619

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
7854,902619 Number of people with mild or severe anemia from neglected tropical diseases 7854 Total number of individuals with moderate and severe anemia due to malaria  902619

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