posts_gdocs_links
Data license: CC-BY
2 rows where sourceId = "1-8ym_g3-B-YgH-WXhRejwuQ2dTYVYMJVJ6c8RIeWYpE"
This data as json, CSV (advanced)
id ▼ | sourceId | target | linkType | componentType | text | queryString | hash |
---|---|---|---|---|---|---|---|
1867718 | Colonialism meant that for centuries, many territories and people were ruled from elsewhere 1-8ym_g3-B-YgH-WXhRejwuQ2dTYVYMJVJ6c8RIeWYpE | number-of-european-overseas-colonies-by-region | grapher | front-matter | |||
1867719 | Colonialism meant that for centuries, many territories and people were ruled from elsewhere 1-8ym_g3-B-YgH-WXhRejwuQ2dTYVYMJVJ6c8RIeWYpE | https://ourworldindata.org/state-capacity?insight=for-centuries-many-territories-and-people-were-ruled-from-elsewhere#key-insights | url | span-link | Read more → | ?insight=for-centuries-many-territories-and-people-were-ruled-from-elsewhere | #key-insights |
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");