post_links

This table is generated from the HTML content of the posts table and extracts different kinds of linked content. The kinds of links currently used are: internal_link, external_link and image.

Data license: CC-BY

9 rows where postId = 3026 sorted by postId descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: kind

id postId ▲ link kind
1096 Forests and Deforestation 3026 https://ourworldindata.org/deforestation#forest-transitions-why-do-we-lose-then-regain-forests internal-prominent-link
1097 Forests and Deforestation 3026 ourworldindata.org/deforestation#the-world-has-lost-one-third-of-its-forests-but-an-end-of-deforestation-is-possible external-prominent-link
1098 Forests and Deforestation 3026 ourworldindata.org/deforestation#global-deforestation-peaked-in-the-1980s-can-we-bring-it-to-an-end external-prominent-link
1099 Forests and Deforestation 3026 ourworldindata.org/deforestation#not-all-forest-loss-is-equal-what-is-the-difference-between-deforestation-and-forest-degradation external-prominent-link
1100 Forests and Deforestation 3026 ourworldindata.org/drivers-of-deforestation#cutting-down-forests-what-are-the-drivers-of-deforestation external-prominent-link
1101 Forests and Deforestation 3026 ourworldindata.org/deforestation#do-rich-countries-export-deforestation-to-other-countries external-prominent-link
1102 Forests and Deforestation 3026 ourworldindata.org/deforestation#carbon-emissions-from-deforestation-are-they-driven-by-domestic-demand-or-international-trade external-prominent-link
1103 Forests and Deforestation 3026 ourworldindata.org/soy external-prominent-link
1104 Forests and Deforestation 3026 ourworldindata.org/palm-oil external-prominent-link

Advanced export

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

CSV options: 

CREATE TABLE post_links (
                `id` integer NOT NULL PRIMARY KEY,
                `postId` integer NOT NULL,
                `link` TEXT,
                `kind` TEXT,
                CONSTRAINT `FK_post_links_postId` FOREIGN KEY (`postId`) REFERENCES `posts` (`id`) ON DELETE CASCADE
            );