chart_variables

Data license: CC-BY

11 rows where chartId = 5026

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
5026,147013 Agricultural land area by farm size 5026 200-500ha_number 147013
5026,147014 Agricultural land area by farm size 5026 500-1000ha_number 147014
5026,147017 Agricultural land area by farm size 5026 under_1ha_area 147017
5026,147018 Agricultural land area by farm size 5026 1-2ha_area 147018
5026,147019 Agricultural land area by farm size 5026 2-5ha_area 147019
5026,147020 Agricultural land area by farm size 5026 5-10ha_area 147020
5026,147021 Agricultural land area by farm size 5026 10-20ha_area 147021
5026,147022 Agricultural land area by farm size 5026 20-50ha_area 147022
5026,147023 Agricultural land area by farm size 5026 50-100ha_area 147023
5026,147024 Agricultural land area by farm size 5026 100-200ha_area 147024
5026,147027 Agricultural land area by farm size 5026 over_1000ha_area 147027

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