post_charts

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

Data license: CC-BY

11 rows where postId = 596 sorted by postId descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind, through_redirect

id postId ▲ chartId kind through_redirect
13 Food Supply 596 GDP per capita 4659 link 1
14 Food Supply 596 Prevalence of undernourishment vs. daily supply of calories 848 embed 0
15 Food Supply 596 Daily per capita protein supply vs. GDP per capita 838 embed 0
16 Food Supply 596 Daily protein supply from animal and plant-based foods 823 embed 0
17 Food Supply 596 Daily per capita protein supply 745 embed 1
18 Food Supply 596 Inequality in per capita calorie intake 835 embed 0
19 Food Supply 596 Daily per capita fat supply vs. GDP per capita 841 embed 0
20 Food Supply 596 Daily supply of calories per person 744 embed 0
21 Food Supply 596 Daily per capita supply of calories vs. GDP per capita 842 embed 0
22 Food Supply 596 Minimum daily requirement of calories 5550 embed 0
23 Food Supply 596 Daily per capita fat supply 746 embed 1

Advanced export

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

CSV options: 

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