posts_gdocs_links

Data license: CC-BY

12 rows where sourceId = "1uEsCtbphuJiGo_Pg8D0rCLnDiy-ApV9gH0aT9ZINpbw"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: target, linkType, componentType, text

id ▼ sourceId target linkType componentType text queryString hash
1878770 Internet 1uEsCtbphuJiGo_Pg8D0rCLnDiy-ApV9gH0aT9ZINpbw https://ourworldindata.org/technological-change url topic-page-intro Technological Change    
1878771 Internet 1uEsCtbphuJiGo_Pg8D0rCLnDiy-ApV9gH0aT9ZINpbw https://ourworldindata.org/global-education url topic-page-intro Global Education    
1878772 Internet 1uEsCtbphuJiGo_Pg8D0rCLnDiy-ApV9gH0aT9ZINpbw https://ourworldindata.org/social-connections-and-loneliness url topic-page-intro Loneliness and Social Connections    
1878773 Internet 1uEsCtbphuJiGo_Pg8D0rCLnDiy-ApV9gH0aT9ZINpbw https://ourworldindata.org/space-exploration-satellites url topic-page-intro Space Exploration and Satellites    
1878774 Internet 1uEsCtbphuJiGo_Pg8D0rCLnDiy-ApV9gH0aT9ZINpbw https://ourworldindata.org/internet-history-just-begun url span-link is still young    
1878775 Internet 1uEsCtbphuJiGo_Pg8D0rCLnDiy-ApV9gH0aT9ZINpbw share-of-individuals-using-the-internet grapher span-link was online    
1878776 Internet 1uEsCtbphuJiGo_Pg8D0rCLnDiy-ApV9gH0aT9ZINpbw personal-remittances-oda grapher span-link remittances    
1878777 Internet 1uEsCtbphuJiGo_Pg8D0rCLnDiy-ApV9gH0aT9ZINpbw https://ourworldindata.org/global-education url span-link learn and educate    
1878778 Internet 1uEsCtbphuJiGo_Pg8D0rCLnDiy-ApV9gH0aT9ZINpbw https://ourworldindata.org/social-connections-and-loneliness url span-link social connections    
1878779 Internet 1uEsCtbphuJiGo_Pg8D0rCLnDiy-ApV9gH0aT9ZINpbw 1lrN8zZo1tKXiCCI2US1CMkIf0tFSx37d3PU_D89u6Xo gdoc research-and-writing      
1878780 Internet 1uEsCtbphuJiGo_Pg8D0rCLnDiy-ApV9gH0aT9ZINpbw 1whkiE8G_Ja1VdRvjyU1L0ptYksxSLnkBajQ5Q_KlNpE gdoc research-and-writing      
1878781 Internet 1uEsCtbphuJiGo_Pg8D0rCLnDiy-ApV9gH0aT9ZINpbw 1oUt6cIxmOGlbZcCbY0846sGXc60AQBO-0LMDJZSUcF8 gdoc research-and-writing      

Advanced export

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

CSV options: 

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