chart_variables

Data license: CC-BY

9 rows where chartId = 4677

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
4677,848555 Oil yields by crop type 4677 Palm oil yield per crop 848555
4677,848561 Oil yields by crop type 4677 Sunflower oil yield per crop 848561
4677,848567 Oil yields by crop type 4677 Rapeseed oil yield per crop 848567
4677,848573 Oil yields by crop type 4677 Soybean oil yield per crop 848573
4677,848576 Oil yields by crop type 4677 Olive oil yield per crop 848576
4677,848583 Oil yields by crop type 4677 Coconut oil yield per crop 848583
4677,848589 Oil yields by crop type 4677 Groundnut oil yield per crop 848589
4677,848596 Oil yields by crop type 4677 Cottonseed oil yield per crop 848596
4677,848602 Oil yields by crop type 4677 Sesame oil yield per crop 848602

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