posts_gdocs_links

Data license: CC-BY

14 rows where sourceId = "1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: linkType, hash

id ▼ sourceId target linkType componentType text queryString hash
1876961 We’re launching Data Insights 1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4 1v-HjyDcR2jBAekDJrYpzVtlvv1D24lA5Y2vddu26150 gdoc span-link Extreme poverty in China has been almost eliminated — first in urban, then in rural regions    
1876962 We’re launching Data Insights 1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4 https://ourworldindata.org/data-insights/solar-and-wind-gain-an-edge-over-coal-in-a-number-of-countries url span-link Solar and wind gain an edge over coal in a number of countries    
1876963 We’re launching Data Insights 1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4 https://ourworldindata.org/data-insights/differences-in-life-expectancy-across-the-world-are-extremely-large url span-link Differences in life expectancy across the world are extremely large    
1876964 We’re launching Data Insights 1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4 https://ourworldindata.org/data-insights/pacemakers-are-crucial-to-people-with-heart-rhythm-disorders-but-their-adoption-varies-widely url span-link Pacemakers are crucial to people with heart rhythm disorders, but their adoption varies widely    
1876965 We’re launching Data Insights 1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4 https://ourworldindata.org/data-insights url span-link feed page    
1876966 We’re launching Data Insights 1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4 12aB8hv0GererRKBogq6jSbA33NuIbMmA1xZq3mVKFFM gdoc span-link redesign of our homepage    
1876967 We’re launching Data Insights 1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4 https://ourworldindata.org/charts url span-link wide range of data    
1876968 We’re launching Data Insights 1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4 https://ourworldindata.org/#all-topics url span-link more than 100 topics   #all-topics
1876969 We’re launching Data Insights 1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4 https://ourworldindata.org/better-learning url span-link longer written formats    
1876970 We’re launching Data Insights 1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4 https://twitter.com/OurWorldInData url span-link X/Twitter    
1876971 We’re launching Data Insights 1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4 https://www.instagram.com/ourworldindata/ url span-link Instagram    
1876972 We’re launching Data Insights 1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4 https://ourworldindata.org/latest url span-link articles and other longer-form content    
1876973 We’re launching Data Insights 1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4 mailto:[email protected] url span-link [email protected]    
1876974 We’re launching Data Insights 1KcqK-JBFTn54eB4LWL5kyh63TGeWO9qD7tvoxfltMW4 https://ourworldindata.org/feedback url span-link our Feedback form    

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