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

12 rows where postId = 8265 sorted by postId descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: chartId, kind, through_redirect

id postId ▲ chartId kind through_redirect
479 Trust 8265 Interpersonal trust in Europe 304 link 1
480 Trust 8265 Trust in government, OECD average 305 embed 0
481 Trust 8265 Share of people agreeing with the statement "most people can be trusted" 295 embed 0
482 Trust 8265 Interpersonal trust in the United States 293 embed 1
483 Trust 8265 Interpersonal trust in Europe 304 embed 1
484 Trust 8265 Trust in government in the United States 296 embed 0
485 Trust 8265 Trust in others vs. trust in police, Europe 308 embed 0
486 Trust 8265 Share of people who trust science 5606 embed 0
487 Trust 8265 Share of people who trust others in their neighborhood 5607 embed 0
488 Trust 8265 Interpersonal trust vs. income inequality 306 embed 0
489 Trust 8265 Share of people who trust their national government 3508 embed 0
490 Trust 8265 Share of people who trust journalists in their country 5605 embed 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
            );