posts_gdocs_links

Data license: CC-BY

26 rows where sourceId = "1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c"

✎ 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
1849771 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c share-using-safely-managed-sanitation grapher span-link do not use safe sanitation facilities ?tab=chart&time=earliest..latest&country=~OWID_WRL  
1849772 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c improved-sanitation-facilities-vs-gdp-per-capita grapher span-link poorest in the world    
1849773 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c https://ourworldindata.org/polio url span-link polio    
1849774 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c prevalence-of-stunting-vs-improved-sanitation-facilities grapher span-link childhood stunting    
1849775 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c number-of-deaths-by-risk-factor grapher chart      
1849776 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c share-deaths-unsafe-sanitation grapher chart   ?country=OWID_WRL~Low+Income+%28WB%29~High+Income+%28WB%29~Middle+Income+%28WB%29~Lower+Middle+Income+%28WB%29  
1849777 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c death-rates-sanitation grapher chart      
1849778 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c death-rates-from-unsafe-sanitation-vs-gdp-per-capita grapher span-link plot death rates from unsafe sanitation versus income    
1849779 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c 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
1849780 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c https://ourworldindata.org/sanitation#definitions url span-link safely managed sanitation   #definitions
1849781 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c share-using-safely-managed-sanitation grapher chart   ?tab=chart&time=earliest..latest&country=~OWID_WRL  
1849782 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c share-of-the-population-with-access-to-sanitation-facilities grapher chart      
1849783 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c share-using-safely-managed-sanitation grapher chart      
1849784 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c safe-sanitation-without grapher chart      
1849785 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c share-without-improved-sanitation grapher chart      
1849786 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c number-without-access-to-improved-sanitation grapher chart      
1849787 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c people-practicing-open-defecation-of-population grapher chart      
1849788 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c open-defecation-in-rural-areas-vs-urban-areas grapher chart      
1849789 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c improved-sanitation-facilities-vs-gdp-per-capita grapher chart      
1849790 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c share-of-children-younger-than-5-who-suffer-from-stunting grapher span-link chronic malnutrition    
1849791 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c https://ourworldindata.org/hunger-and-undernourishment/ url span-link hunger and undernourishment    
1849792 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c prevalence-of-stunting-vs-improved-sanitation-facilities grapher chart      
1849793 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c https://www.who.int/news-room/fact-sheets/detail/sanitation url span-link here    
1849794 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c http://washdev.iwaponline.com/content/7/1/1 url span-link online    
1849795 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c https://web.archive.org/web/20240114060147/https://www.who.int/publications/i/item/WHO-NMH-NHD-14.3 url span-link online    
1849796 Sanitation 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c https://databank.worldbank.org/metadataglossary/world-development-indicators/series/SH.STA.ACSN url span-link online    

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