posts_gdocs_links

Data license: CC-BY

9 rows where sourceId = "1wWZvocIi48BhfxKGvxUTIEET5p2vsqcMhYBSn3htMCo"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: componentType

id ▼ sourceId target linkType componentType text queryString hash
1879738 Farm Size and Productivity 1wWZvocIi48BhfxKGvxUTIEET5p2vsqcMhYBSn3htMCo https://ourworldindata.org/land-use url topic-page-intro Land use    
1879739 Farm Size and Productivity 1wWZvocIi48BhfxKGvxUTIEET5p2vsqcMhYBSn3htMCo https://ourworldindata.org/employment-in-agriculture url topic-page-intro Employment in Agriculture    
1879740 Farm Size and Productivity 1wWZvocIi48BhfxKGvxUTIEET5p2vsqcMhYBSn3htMCo https://ourworldindata.org/fertilizers url topic-page-intro Fertilizers    
1879741 Farm Size and Productivity 1wWZvocIi48BhfxKGvxUTIEET5p2vsqcMhYBSn3htMCo https://ourworldindata.org/smallholder-food-production url research-and-writing Smallholders produce one-third of the world’s food, less than half of what many headlines claim    
1879742 Farm Size and Productivity 1wWZvocIi48BhfxKGvxUTIEET5p2vsqcMhYBSn3htMCo https://ourworldindata.org/from-1-90-to-2-15-a-day-the-updated-international-poverty-line url research-and-writing Do we only have 60 harvests left?    
1879743 Farm Size and Productivity 1wWZvocIi48BhfxKGvxUTIEET5p2vsqcMhYBSn3htMCo https://ourworldindata.org/yields-habitat-loss url research-and-writing To protect the world’s wildlife we must improve crop yields – especially across Africa    
1879744 Farm Size and Productivity 1wWZvocIi48BhfxKGvxUTIEET5p2vsqcMhYBSn3htMCo https://ourworldindata.org/peak-agriculture-land url research-and-writing After millennia of agricultural expansion, the world has passed ‘peak agricultural land’    
1879745 Farm Size and Productivity 1wWZvocIi48BhfxKGvxUTIEET5p2vsqcMhYBSn3htMCo 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    
1879746 Farm Size and Productivity 1wWZvocIi48BhfxKGvxUTIEET5p2vsqcMhYBSn3htMCo https://www.sciencedirect.com/science/article/pii/S0305750X15002703 url span-link he number, size, and distribution of farms, smallholder farms, and family farms worldwide    

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