posts_gdocs_links

Data license: CC-BY

10 rows where sourceId = "1NYBMqLqqpb6M7HMFU6yiShVVsXUbD55J0omiuPCVy3A"

✎ 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
1863893 How is food insecurity measured? 1NYBMqLqqpb6M7HMFU6yiShVVsXUbD55J0omiuPCVy3A https://www.fao.org/hunger/en/ url span-link is defined by    
1863894 How is food insecurity measured? 1NYBMqLqqpb6M7HMFU6yiShVVsXUbD55J0omiuPCVy3A share-of-population-with-severe-food-insecurity grapher chart      
1863895 How is food insecurity measured? 1NYBMqLqqpb6M7HMFU6yiShVVsXUbD55J0omiuPCVy3A https://ourworldindata.org/food-prices url span-link unaffordable    
1863896 How is food insecurity measured? 1NYBMqLqqpb6M7HMFU6yiShVVsXUbD55J0omiuPCVy3A https://unstats.un.org/sdgs/metadata/files/Metadata-02-01-02.pdf url span-link full list    
1863897 How is food insecurity measured? 1NYBMqLqqpb6M7HMFU6yiShVVsXUbD55J0omiuPCVy3A https://ourworldindata.org/micronutrient-deficiency url span-link micronutrient deficiencies    
1863898 How is food insecurity measured? 1NYBMqLqqpb6M7HMFU6yiShVVsXUbD55J0omiuPCVy3A share-of-population-with-moderate-or-severe-food-insecurity grapher chart      
1863899 How is food insecurity measured? 1NYBMqLqqpb6M7HMFU6yiShVVsXUbD55J0omiuPCVy3A prevalence-of-undernourishment grapher span-link defined as undernourished    
1863900 How is food insecurity measured? 1NYBMqLqqpb6M7HMFU6yiShVVsXUbD55J0omiuPCVy3A severe-food-insecurity-undernourishment grapher chart   ?time=2020  
1863901 How is food insecurity measured? 1NYBMqLqqpb6M7HMFU6yiShVVsXUbD55J0omiuPCVy3A https://unstats.un.org/sdgs/metadata/files/Metadata-02-01-02.pdf url span-link survey of eight questions    
1863902 How is food insecurity measured? 1NYBMqLqqpb6M7HMFU6yiShVVsXUbD55J0omiuPCVy3A https://ourworldindata.org/hunger-and-undernourishment url prominent-link Our page on hunger and undernourishment    

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