chart_variables

Data license: CC-BY

10 rows where chartId = 1349

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
1349,42631 Livestock counts 1349 Asses (HYDE & FAO (2017)) 42631
1349,42632 Livestock counts 1349 Buffalo (HYDE & FAO (2017)) 42632
1349,42633 Livestock counts 1349 Cattle (HYDE & FAO (2017)) 42633
1349,42634 Livestock counts 1349 Goats (HYDE & FAO (2017)) 42634
1349,42635 Livestock counts 1349 Horses (HYDE & FAO (2017)) 42635
1349,42636 Livestock counts 1349 Mules (HYDE & FAO (2017)) 42636
1349,42637 Livestock counts 1349 Pigs (HYDE & FAO (2017)) 42637
1349,42638 Livestock counts 1349 Sheep (HYDE & FAO (2017)) 42638
1349,42639 Livestock counts 1349 Chickens (HYDE & FAO (2017)) 42639
1349,42640 Livestock counts 1349 Turkeys (HYDE & FAO (2017)) 42640

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