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

9 rows where chartId = 2562 sorted by postId descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind

id postId ▲ chartId kind through_redirect
3164 The history of the end of poverty has just begun 46309 Child mortality rate 2562 link 0
3029 Child mortality: an everyday tragedy of enormous scale that we can make progress against 44243 Child mortality rate 2562 embed 0
2893 How much economic growth is necessary to reduce global poverty substantially? 41648 Child mortality rate 2562 link 0
1582 Estimates for child mortality over the last two centuries - original child mortality entry 25328 Child mortality rate 2562 embed 0
1438 12 key metrics to understand the state of the world 24902 Child mortality rate 2562 embed 0
1347 How often did parents see their children die? 24620 Child mortality rate 2562 link 0
505 Global Health 8452 Child mortality rate 2562 embed 0
471 Education Spending 7997 Child mortality rate 2562 link 0
305 Fertility Rate 3604 Child mortality rate 2562 link 0

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