chart_variables

Data license: CC-BY

9 rows where chartId = 7072

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
7072,852184 Yields of important staple crops 7072 Barley yield 852184
7072,852348 Yields of important staple crops 7072 Maize yield 852348
7072,852357 Yields of important staple crops 7072 Millet yield 852357
7072,852381 Yields of important staple crops 7072 Oats yield 852381
7072,852459 Yields of important staple crops 7072 Potatoes yield 852459
7072,852477 Yields of important staple crops 7072 Rice yield 852477
7072,852480 Yields of important staple crops 7072 Rye yield 852480
7072,852495 Yields of important staple crops 7072 Sorghum yield 852495
7072,852542 Yields of important staple crops 7072 Wheat yield 852542

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