posts_gdocs_links

Data license: CC-BY

19 rows where sourceId = "1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: target, linkType, componentType, text

id ▼ sourceId target linkType componentType text queryString hash
1879574 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg https://ourworldindata.org/technological-change url topic-page-intro Technological Progress    
1879575 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg https://ourworldindata.org/internet url topic-page-intro Internet    
1879576 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg https://ourworldindata.org/global-education url topic-page-intro Global Education    
1879577 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg https://ourworldindata.org/artificial-intelligence url topic-page-intro Artificial Intelligence    
1879578 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg https://ourworldindata.org/vaccination url span-link vaccines    
1879579 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg https://ourworldindata.org/child-mortality url span-link beyond childhood    
1879580 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg https://ourworldindata.org/life-expectancy url span-link longer lives    
1879581 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg https://ourworldindata.org/clean-water-sanitation url span-link water, and sanitation    
1879582 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg https://ourworldindata.org/energy url span-link energy technologies    
1879583 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg https://ourworldindata.org/crop-yields url span-link crop yields    
1879584 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg https://ourworldindata.org/artificial-intelligence url span-link artificial intelligence    
1879585 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg https://ourworldindata.org/nuclear-weapons url span-link nuclear weapons    
1879586 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg 1Vuyi9thca39s45htjDn6QSIgygZVcWuPca1y2pyVReU gdoc research-and-writing      
1879587 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg 1oh0rTB9nZPq00zIJVaHzGC87AiJcjsV8DmYI3eDXFr8 gdoc research-and-writing      
1879588 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg 1yH7P70MBCWsNIx-WQPmZnVqXL4Mrpxrp6J1Jpa6qBko gdoc research-and-writing      
1879589 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg 1WGJaY95A4hVjybBPzHOA80iGygKUKcgx0kSs-G_b7aA gdoc research-and-writing      
1879590 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg 15hEchniGhmgO8mLsSi5mXek2a9na-Mo1VFtrsWcQw1g gdoc research-and-writing      
1879591 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg 1e0HDWjfdRTrbLlAdUMPGtkqmLJJFw9ookSmgBU6JMPI gdoc research-and-writing      
1879592 Research and Development 1zcGqgmvg4pEdiPqHMj8eY89PtKHcUlLO3dgL8moT6Bg 1KeagpzX2OMBS63fnyFRXMbU7QpBIgykKRZBTMdeHFAo 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");