chart_variables

Data license: CC-BY

1 row where chartId = 7442

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
7442,816856 Death rate in armed conflicts based on where they occurred 7442 Death rate in ongoing conflicts in a country (best estimate) - Conflict type: all 816856

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