posts_gdocs_links

Data license: CC-BY

17 rows where sourceId = "1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY"

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ sourceId target linkType componentType text queryString hash
1820661 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY https://ourworldindata.org/micronutrient-deficiency url span-link hidden hunger    
1820662 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY https://icp.worldbank.org url span-link International Comparison Program    
1820663 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY food-prices explorer span-link Food Prices Data Explorer    
1820664 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY share-of-energy-from-cereals-roots-and-tubers-vs-gdp-per-capita grapher span-link look at people’s diets    
1820665 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY https://en.wikipedia.org/wiki/Engel%27s_law url span-link Engel’s Law    
1820666 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY share-of-consumer-expenditure-spent-on-food-vs-gdp-per-capita grapher span-link compare food expenditures    
1820667 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY food-prices explorer span-link could not afford ?country=NGA~BGD~IND~ETH~MEX~USA~BRA~GBR~OWID_WRL&Diet=Calorie+sufficient&Cost+or+Affordability=Affordability&Metric=Number+that+cannot+afford  
1820668 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY https://ourworldindata.org/extreme-poverty url span-link international poverty line    
1820669 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY number-calorie-diet-unaffordable grapher chart   ?country=Sub-Saharan+Africa~North+Africa~North+America~Latin+America+and+the+Caribbean~South+Asia~East+Asia~Southeastern+Asia~Eastern+Europe~Western+Europe~OWID_WRL  
1820670 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY food-prices explorer span-link cannot afford ?country=NGA~BGD~IND~ETH~MEX~USA~BRA~GBR~OWID_WRL&Diet=Healthy+diet&Cost+or+Affordability=Affordability&Metric=Number+that+cannot+afford  
1820671 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY share-healthy-diet-unaffordable grapher chart      
1820672 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY https://ourworldindata.org/food-supply url span-link grow much more    
1820673 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY https://ourworldindata.org/economic-growth url span-link rise in incomes    
1820674 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY https://ourworldindata.org/what-is-economic-growth url span-link recent article    
1820675 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY https://databank.worldbank.org/source/food-prices-for-nutrition url span-link latest food prices release    
1820676 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY http://www.fao.org/3/cb2431en/cb2431en.pdf url span-link Cost and affordability of healthy diets across and within countries. Background paper for The State of Food Security and Nutrition in the World 2020    
1820677 Three billion people cannot afford a healthy diet 1fIe8_MLak-CyZJSe6amBIeF3fMDBjbTSniAP9skWIdY https://ourworldindata.org/from-1-90-to-2-15-a-day-the-updated-international-poverty-line url span-link From $1.90 to $2.15 a day: the updated International Poverty Line    

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