posts_gdocs_links

Data license: CC-BY

11 rows where sourceId = "1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: linkType, componentType, text

id ▼ sourceId target linkType componentType text queryString hash
1825574 Homicides 1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE https://ourworldindata.org/causes-of-death url topic-page-intro Causes of Death    
1825575 Homicides 1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE https://ourworldindata.org/war-and-peace url topic-page-intro War and Peace    
1825576 Homicides 1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE https://ourworldindata.org/terrorism url topic-page-intro Terrorism    
1825577 Homicides 1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE https://ourworldindata.org/suicide url topic-page-intro Suicides    
1825578 Homicides 1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE gdoc research-and-writing      
1825579 Homicides 1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE 1UdKf375jChVw4SpFrhNaRJH0Ve7VDXtjFz_CP7mon54 gdoc research-and-writing      
1825580 Homicides 1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE 18v00Z9ep-vvKP3VXIfWKd25BdrcReSX3qClOBt3d5zM gdoc research-and-writing      
1825581 Homicides 1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE 1Raish4hOXi6PwlhyFsTRFnOCZWLr7roteYW-0qBawZo gdoc research-and-writing      
1825582 Homicides 1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE homicide-rate-unodc grapher all-charts      
1825583 Homicides 1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE distribution-of-homicide-rates grapher all-charts      
1825584 Homicides 1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE homicide-rates-across-western-europe grapher all-charts      

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