chart_variables

Data license: CC-BY

1 row where variableId = 1419

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId variableId
351,1419 Unpaid parking violations per diplomat in New York City by country of origin 351 Diplomatic parking violations (Fisman and Miguel (2007)) 1419

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