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

10 rows where postId = 27598 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
1818 What do people die from? 27598 Deaths from HIV/AIDS by age 1687 link 0
1819 What do people die from? 27598 Terrorism deaths 1443 link 1
1820 What do people die from? 27598 Causes of death 2060 link 0
1821 What do people die from? 27598 Causes of death in the United States over the 20th century 2007 link 0
1822 What do people die from? 27598 Suicide rate vs. death rate from violence 1872 link 0
1823 What do people die from? 27598 Deaths by risk factor 1588 link 0
1824 What do people die from? 27598 Neonatal mortality rate 714 link 0
1825 What do people die from? 27598 Alcohol consumption per person 1197 link 0
1826 What do people die from? 27598 Deaths by age 1696 link 0
1827 What do people die from? 27598 Share of deaths by cause 2117 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
            );