chart_variables

Data license: CC-BY

1 row where chartId = 3590

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
3590,922335 Number of deaths from pneumonia in children under five 3590 Deaths from lower respiratory infections, among individuals aged <5 years  922335

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