chart_variables

Data license: CC-BY

1 row where variableId = 97806

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
2954,97806 Average daily hours of work in winter, by industry 2954 Average daily minutes of work in winter, weighted by employees (Atack and Bateman (1992)) 97806

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