posts_gdocs_links

Data license: CC-BY

10 rows where sourceId = "1SxNS26IRJ9f2VFAtt71eq_7fTBqgsOwR9VLa4h_rEnY"

✎ 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
1875767 Forest area 1SxNS26IRJ9f2VFAtt71eq_7fTBqgsOwR9VLa4h_rEnY https://ourworldindata.org/land-use url span-link used for farming    
1875768 Forest area 1SxNS26IRJ9f2VFAtt71eq_7fTBqgsOwR9VLa4h_rEnY share-global-forest grapher chart   ?tab=chart&stackMode=absolute&time=2020..latest&country=Africa~Asia~Europe~Oceania~South%20America&region=World  
1875769 Forest area 1SxNS26IRJ9f2VFAtt71eq_7fTBqgsOwR9VLa4h_rEnY forest-area-as-share-of-land-area grapher chart   ?region=World  
1875770 Forest area 1SxNS26IRJ9f2VFAtt71eq_7fTBqgsOwR9VLa4h_rEnY forest-area-km grapher chart      
1875771 Forest area 1SxNS26IRJ9f2VFAtt71eq_7fTBqgsOwR9VLa4h_rEnY share-global-forest grapher chart   ?stackMode=absolute&region=World  
1875772 Forest area 1SxNS26IRJ9f2VFAtt71eq_7fTBqgsOwR9VLa4h_rEnY number-of-trees grapher chart      
1875773 Forest area 1SxNS26IRJ9f2VFAtt71eq_7fTBqgsOwR9VLa4h_rEnY number-of-trees-per-km grapher prominent-link Number of trees per square kilometer (km²)    
1875774 Forest area 1SxNS26IRJ9f2VFAtt71eq_7fTBqgsOwR9VLa4h_rEnY trees-per-capita grapher prominent-link Number of trees per capita    
1875775 Forest area 1SxNS26IRJ9f2VFAtt71eq_7fTBqgsOwR9VLa4h_rEnY http://www.fao.org/3/i8661en/i8661en.pdf url span-link defined by    
1875776 Forest area 1SxNS26IRJ9f2VFAtt71eq_7fTBqgsOwR9VLa4h_rEnY forest-area-primary-planted grapher chart      

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