chart_variables

Data license: CC-BY

1 row where variableId = 814850

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
923,814850 GDP per head vs. share of industry in GDP 923 Share of industry in GDP at current prices (Herrendorf et al. and GGDC-10 data) 814850

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