chart_variables

Data license: CC-BY

1 row where chartId = 4347

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
4347,143148 Cumulative share of marriages in England and Wales ending in divorce 4347 Cumulative share of marriages ending in divorce (England and Wales, UK ONS) 143148

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