chart_variables

Data license: CC-BY

1 row where chartId = 1455

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
1455,936127 Household air pollution deaths by region 1455 Total number of deaths from all causes attributed to household air pollution from solid fuels  936127

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