posts_gdocs_links

Data license: CC-BY

11 rows where sourceId = "1NFcPl-lQzwEA6j8rApy1eLG_qBt6P1EW2sB9xrG-9pI"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: target, linkType, componentType, queryString

id ▼ sourceId target linkType componentType text queryString hash
1879705 Crop Yields 1NFcPl-lQzwEA6j8rApy1eLG_qBt6P1EW2sB9xrG-9pI https://ourworldindata.org/land-use url topic-page-intro Land use    
1879706 Crop Yields 1NFcPl-lQzwEA6j8rApy1eLG_qBt6P1EW2sB9xrG-9pI https://ourworldindata.org/biodiversity url topic-page-intro Biodiversity    
1879707 Crop Yields 1NFcPl-lQzwEA6j8rApy1eLG_qBt6P1EW2sB9xrG-9pI https://ourworldindata.org/fertilizers url topic-page-intro Fertilizers    
1879708 Crop Yields 1NFcPl-lQzwEA6j8rApy1eLG_qBt6P1EW2sB9xrG-9pI https://ourworldindata.org/land-use url span-link land we use for agriculture    
1879709 Crop Yields 1NFcPl-lQzwEA6j8rApy1eLG_qBt6P1EW2sB9xrG-9pI https://ourworldindata.org/poverty url span-link global poverty    
1879710 Crop Yields 1NFcPl-lQzwEA6j8rApy1eLG_qBt6P1EW2sB9xrG-9pI crop-yields explorer chart   ?facet=none&country=IND~USA~ITA~GBR~NGA~LKA~BRA~PER~AGO&Crop=Wheat&Metric=Actual+yield&hideControls=false  
1879711 Crop Yields 1NFcPl-lQzwEA6j8rApy1eLG_qBt6P1EW2sB9xrG-9pI https://ourworldindata.org/africa-yields-problem url research-and-writing Increasing agricultural productivity across Sub-Saharan Africa is one of the most important problems this century    
1879712 Crop Yields 1NFcPl-lQzwEA6j8rApy1eLG_qBt6P1EW2sB9xrG-9pI https://ourworldindata.org/soil-lifespans url research-and-writing Do we only have 60 harvests left?    
1879713 Crop Yields 1NFcPl-lQzwEA6j8rApy1eLG_qBt6P1EW2sB9xrG-9pI https://ourworldindata.org/yields-habitat-loss url research-and-writing To protect the world’s wildlife we must improve crop yields – especially across Africa    
1879714 Crop Yields 1NFcPl-lQzwEA6j8rApy1eLG_qBt6P1EW2sB9xrG-9pI https://ourworldindata.org/peak-agriculture-land url research-and-writing After millennia of agricultural expansion, the world has passed ‘peak agricultural land’    
1879715 Crop Yields 1NFcPl-lQzwEA6j8rApy1eLG_qBt6P1EW2sB9xrG-9pI https://ourworldindata.org/yields-vs-land-use-how-has-the-world-produced-enough-food-for-a-growing-population url research-and-writing Yields vs. Land Use: How the Green Revolution enabled us to feed a growing population    

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