posts_links

Data license: CC-BY

13 rows where sourceId = 39899

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ sourceId target linkType componentType text queryString hash
8629 Forest area 39899 https://ourworldindata.org/land-use url href      
8630 Forest area 39899 https://ourworldindata.org/admin/posts/preview/36933#note-3 url href     #note-3
8631 Forest area 39899 http://www.fao.org/3/i8661en/i8661en.pdf url href      
8632 Forest area 39899 https://ourworldindata.org/admin/posts/preview/36933#note-4 url href     #note-4
8634 Forest area 39899 share-global-forest grapher src   ?tab=chart&stackMode=absolute&time=2020..latest&country=Africa~Asia~Europe~Oceania~South%20America&region=World  
8635 Forest area 39899 forest-area-as-share-of-land-area grapher src   ?region=World  
8636 Forest area 39899 forest-area-km grapher src      
8637 Forest area 39899 share-global-forest grapher src   ?stackMode=absolute&region=World  
8638 Forest area 39899 number-of-trees grapher src      
8639 Forest area 39899 forest-area-primary-planted grapher src   ?tab=chart&stackMode=absolute&country=~OWID_WRL&region=World  
8640 Forest area 39899 number-of-trees-per-km grapher prominent-link      
8641 Forest area 39899 trees-per-capita grapher prominent-link      
24495 Forest area 39899 https://ourworldindata.org/uploads/2021/02/Long-term-change-in-land-use-610x550.png url src      

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "posts_links" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"sourceId" INTEGER NOT NULL  ,
	"target" VARCHAR(2047) 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" ("id") ON UPDATE CASCADE ON DELETE CASCADE
);