chart_variables

Data license: CC-BY

1 row where variableId = 1971

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
678,1971 The demographic transition in England and Wales 678 Crude Birth Rate (OWID based on Wrigley and Schofield (1981), Mitchell (2010), and UK ONS (2016)) 1971

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