chart_variables

Data license: CC-BY

1 row where variableId = 814847

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
920,814847 GDP per head vs. share of industry in employment 920 Share of employment in industry (Herrendorf et al. and GGDC-10 data) 814847

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