chart_variables

Data license: CC-BY

1 row where variableId = 147403

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
5042,147403 Historical national accounts estimates of the distribution of people living at different income thresholds globally 5042 above 20$ a day 147403

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