chart_variables

Data license: CC-BY

2 rows where variableId = 930567

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
114,930567 Airliner hijackings and deaths in them 114 Hijacking incidents 930567
1110,930567 Fatal airliner accidents and hijacking incidents 1110 Hijacking incidents 930567

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