chart_variables

Data license: CC-BY

1 row where chartId = 1141

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
1141,42243 Average usual weekly hours worked, women 15 years and older 1141 Average weekly hours worked (women, 15+) (OECD Labor Force Statistics (2017)) 42243

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