chart_variables

Data license: CC-BY

2 rows where variableId = 247306

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
5545,247306 Which countries have managed to decouple agricultural output from more inputs? 5545 tfp 247306
7590,247306 Total factor productivity in agriculture 7590 tfp 247306

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