posts_gdocs_links

Data license: CC-BY

12 rows where sourceId = "16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: target, linkType, componentType, text, queryString, hash

id ▼ sourceId target linkType componentType text queryString hash
1849636 Hygiene and Handwashing 16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E https://ourworldindata.org/extreme-poverty url span-link poorest in the world    
1849637 Hygiene and Handwashing 16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E https://www.healthdata.org/research-analysis/gbd url span-link Global Burden of Disease    
1849638 Hygiene and Handwashing 16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E annual-number-of-deaths-by-cause grapher span-link number of homicides    
1849639 Hygiene and Handwashing 16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E number-of-deaths-by-risk-factor grapher chart      
1849640 Hygiene and Handwashing 16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E death-rates-no-handwashing grapher span-link largely limited to low- and lower-middle-income countries ?tab=chart  
1849641 Hygiene and Handwashing 16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E death-rates-no-handwashing grapher chart   ?tab=map  
1849642 Hygiene and Handwashing 16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E https://ourworldindata.org/sdgs/clean-water-sanitation#target-6-2-end-open-defecation-and-provide-access-to-sanitation-and-hygiene url span-link SDG Target 6.2   #target-6-2-end-open-defecation-and-provide-access-to-sanitation-and-hygiene
1849643 Hygiene and Handwashing 16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E share-of-the-population-with-access-to-handwashing-facilities grapher span-link basic handwashing facilities    
1849644 Hygiene and Handwashing 16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E share-of-the-population-with-access-to-handwashing-facilities grapher chart      
1849645 Hygiene and Handwashing 16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E proportion-of-population-with-basic-handwashing-facilities-on-premises grapher chart   ?tab=map  
1849646 Hygiene and Handwashing 16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E proportion-of-population-with-basic-handwashing-facilities-on-premises grapher chart   ?tab=chart&country=~OWID_WRL  
1849647 Hygiene and Handwashing 16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E number-without-basic-handwashing grapher chart      

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