chart_variables

Data license: CC-BY

1 row where variableId = 815906

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
4246,815906 Per capita nitrous oxide emissions by sector 4246 Per capita fugitive emissions of nitrous oxide from energy production 815906

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