chart_variables

Data license: CC-BY

2 rows where variableId = 821425

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
7671,821425 Annual number of wildfires 7671 Annual number of fires 821425
7683,821425 Annual area burnt per wildfire vs. number of fires 7683 Annual number of fires 821425

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