chart_variables

Data license: CC-BY

2 rows where variableId = 899572

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
732,899572 Global damage costs from natural disasters 732 Total economic damages 899572
1525,899572 Economic damage by natural disaster type 1525 Total economic damages 899572

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