owid: post_charts: 5 rows where chartId = 3868 sorted by postId descending

This table is generated from the HTML content of the posts table and extracts iframe links to grapher charts.

Data license: CC-BY

5 rows where chartId = 3868 sorted by postId descending

descending

id	postId ▲	chartId	kind	through_redirect
2413	Is the world making progress in decarbonizing energy? 36046	Primary energy consumption 3868	link	0
2315	Energy Mix 34888	Primary energy consumption 3868	link	0
2295	Energy Country Profile 34886	Primary energy consumption 3868	embed	0
2265	Energy Production and Consumption 34882	Primary energy consumption 3868	prominent-link	1
2273	Energy Production and Consumption 34882	Primary energy consumption 3868	embed	0

Advanced export

JSON shape: default, array, newline-delimited, object

CREATE TABLE post_charts (
                `id` integer NOT NULL PRIMARY KEY,
                `postId` integer NOT NULL,
                `chartId` integer NOT NULL,
                `kind` TEXT NOT NULL,
                `through_redirect` integer NOT NULL,
                CONSTRAINT `FK_post_charts_chartId` FOREIGN KEY (`chartId`) REFERENCES `charts` (`id`) ON DELETE CASCADE,
                CONSTRAINT `FK_post_charts_postId` FOREIGN KEY (`postId`) REFERENCES `posts` (`id`) ON DELETE CASCADE
            );