chart_variables

Data license: CC-BY

1 row where chartId = 3046

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
3046,98040 Additional people at risk of extreme poverty with high climate adaptation challenges 3046 SSP3 (difference in number in extreme poverty to baseline) 98040

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