chart_variables

Data license: CC-BY

3 rows where chartId = 7795

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
7795,123 Temperature anomalies by region 7795 Countries Continents 123
7795,819376 Temperature anomalies by region 7795 Temperature anomaly 819376
7795,953899 Temperature anomalies by region 7795 Population 953899

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