chart_variables

Data license: CC-BY

11 rows where chartId = 5078

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
5078,147005 Number of farms by size 5078 under_1ha_number 147005
5078,147006 Number of farms by size 5078 1-2ha_number 147006
5078,147007 Number of farms by size 5078 2-5ha_number 147007
5078,147008 Number of farms by size 5078 5-10ha_number 147008
5078,147009 Number of farms by size 5078 10-20ha_number 147009
5078,147010 Number of farms by size 5078 20-50ha_number 147010
5078,147011 Number of farms by size 5078 50-100ha_number 147011
5078,147012 Number of farms by size 5078 100-200ha_number 147012
5078,147013 Number of farms by size 5078 200-500ha_number 147013
5078,147014 Number of farms by size 5078 500-1000ha_number 147014
5078,147015 Number of farms by size 5078 over_1000ha_number 147015

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