chart_variables

Data license: CC-BY

1 row where chartId = 6125

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
6125,940319 Death rate from indoor air pollution 6125 Deaths from all causes attributed to household air pollution from solid fuels per 100,000 people  940319

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