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

8 rows where postId = 56798 sorted by postId descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: link, kind

id postId ▲ link kind
16590 How is food insecurity measured? 56798 http://ourworldindata.org/food-prices internal-link
16591 How is food insecurity measured? 56798 https://ourworldindata.org/micronutrient-deficiency internal-link
16592 How is food insecurity measured? 56798 https://ourworldindata.org/grapher/prevalence-of-undernourishment internal-link
16593 How is food insecurity measured? 56798 https://www.fao.org/hunger/en/ external-link
16594 How is food insecurity measured? 56798 https://unstats.un.org/sdgs/metadata/files/Metadata-02-01-02.pdf external-link
16595 How is food insecurity measured? 56798 https://unstats.un.org/sdgs/metadata/files/Metadata-02-01-02.pdf external-link
16596 How is food insecurity measured? 56798 https://ourworldindata.org/hunger-and-undernourishment internal-prominent-link
16597 How is food insecurity measured? 56798 https://owid.cloud/app/uploads/2023/04/Food-Insecurity-Scale.png image

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