posts_gdocs_links
Data license: CC-BY
6 rows where sourceId = "12aB8hv0GererRKBogq6jSbA33NuIbMmA1xZq3mVKFFM"
This data as json, CSV (advanced)
Suggested facets: target, linkType
id ▼ | sourceId | target | linkType | componentType | text | queryString | hash |
---|---|---|---|---|---|---|---|
1861482 | We’ve redesigned our homepage 12aB8hv0GererRKBogq6jSbA33NuIbMmA1xZq3mVKFFM | https://ourworldindata.org/problems-and-progress | url | span-link | mission | ||
1861483 | We’ve redesigned our homepage 12aB8hv0GererRKBogq6jSbA33NuIbMmA1xZq3mVKFFM | https://ourworldindata.org/ | url | span-link | homepage | ||
1861484 | We’ve redesigned our homepage 12aB8hv0GererRKBogq6jSbA33NuIbMmA1xZq3mVKFFM | 1a9XbHjQ8EANEONkWsOrzRhLX_8L0-RAkTzlujYAPN-0 | gdoc | span-link | Our World in Data | ||
1861485 | We’ve redesigned our homepage 12aB8hv0GererRKBogq6jSbA33NuIbMmA1xZq3mVKFFM | 1a9XbHjQ8EANEONkWsOrzRhLX_8L0-RAkTzlujYAPN-0 | gdoc | span-link | “Grapher” | ||
1861486 | We’ve redesigned our homepage 12aB8hv0GererRKBogq6jSbA33NuIbMmA1xZq3mVKFFM | https://ourworldindata.org/problems-and-progress | url | span-link | our mission | ||
1861487 | We’ve redesigned our homepage 12aB8hv0GererRKBogq6jSbA33NuIbMmA1xZq3mVKFFM | https://ourworldindata.org/feedback | url | span-link | Feedback form |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "posts_gdocs_links" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "sourceId" VARCHAR(255) NULL , "target" TEXT NOT NULL , "linkType" TEXT NULL , "componentType" VARCHAR(255) NOT NULL , "text" VARCHAR(255) NOT NULL , "queryString" VARCHAR(2047) NOT NULL , "hash" VARCHAR(2047) NOT NULL, FOREIGN KEY("sourceId") REFERENCES "posts_gdocs" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION ); CREATE INDEX "sourceId" ON "posts_gdocs_links" ("sourceId");