chart_variables

Data license: CC-BY

7 rows where chartId = 6226

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
6226,537670 World income distribution 6226 Income_1820 537670
6226,537671 World income distribution 6226 Income_1929 537671
6226,537672 World income distribution 6226 Income_1950 537672
6226,537673 World income distribution 6226 Income_1960 537673
6226,537674 World income distribution 6226 Income_1970 537674
6226,537675 World income distribution 6226 Income_1980 537675
6226,537676 World income distribution 6226 Income_2000 537676

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