posts_links

Data license: CC-BY

29 rows where sourceId = 44738

✎ 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
14487 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 https://ourworldindata.org/crop-yields url href      
14488 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 https://ourworldindata.org/biodiversity url href      
14489 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 https://ourworldindata.org/threats-to-wildlife url href      
14490 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 https://ourworldindata.org/habitat-loss#wilderness-to-farm-how-humans-have-transformed-the-global-landscape url href     #wilderness-to-farm-how-humans-have-transformed-the-global-landscape
14491 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 https://www.mdpi.com/2073-445X/9/5/129/htm url href      
14492 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 https://ourworldindata.org/habitat-loss#the-world-has-lost-one-third-of-its-forests-but-an-end-of-deforestation-is-possible url href     #the-world-has-lost-one-third-of-its-forests-but-an-end-of-deforestation-is-possible
14493 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 https://www.nature.com/articles/s41893-020-00656-5 url href      
14494 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 historical-and-projected-population-by-region grapher href      
14495 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 https://esa.un.org/unpd/wpp/Download/Standard/Population/.%7B/ref url href      
14496 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 https://ourworldindata.org/environmental-impacts-of-food url href      
14497 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 change-of-cereal-yield-vs-land-used grapher href   ?stackMode=relative&minPopulationFilter=1000000&time=earliest..latest&country=Africa~Asia  
14498 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 habitat-loss explorer href   ?tab=map&Projected+change+by+2050=Species+habitat+loss&Species+Group=All+vertebrates&Scenario=Business-as-usual&country=OWID_WRL~Sub-Saharan+Africa~South+and+East+Asia~Europe~North+America~Latin+America~North+Africa~Oceania  
14499 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 habitat-loss-25-species grapher href      
14500 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 https://ourworldindata.org/mammals#quaternary-megafauna-extinctions url href     #quaternary-megafauna-extinctions
14501 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 eat-lancet-diet-comparison grapher href   ?country=USA~GBR~EAT-Lancet~IND~KEN  
14502 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 projected-cropland-by-2050 grapher href   ?country=~OWID_WRL  
14503 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 habitat-loss explorer src   ?facet=none&Projected+change+by+2050=Cropland+area&Species+Group=All+vertebrates&Scenario=Business-as-usual&country=USA~CHN~IND~RUS~BRA~FRA~IDN&hideControls=true  
14504 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 habitat-loss explorer src   ?tab=chart&facet=none&Projected+change+by+2050=Species+habitat+loss&Species+Group=All+vertebrates&Scenario=Business-as-usual&country=OWID_WRL~Sub-Saharan+Africa~South+and+East+Asia~Europe~North+America~Latin+America~North+Africa~Oceania&hideControls=true  
14505 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 habitat-loss explorer src   ?facet=none&Projected+change+by+2050=Species+habitat+loss&Species+Group=All+vertebrates&Scenario=Business-as-usual&country=OWID_WRL~Sub-Saharan+Africa~South+and+East+Asia~Europe~North+America~Latin+America~North+Africa~Oceania&hideControls=true  
14506 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 projected-habitat-loss-extent-bau grapher src   ?tab=chart&country=~OWID_WRL  
14508 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 habitat-loss explorer src   ?facet=none&Projected+change+by+2050=Cropland+area&Species+Group=All+vertebrates&Scenario=Business-as-usual&country=OWID_WRL~Sub-Saharan+Africa~South+and+East+Asia~Europe~North+America~Latin+America~North+Africa~Oceania&hideControls=true  
14509 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 habitat-loss explorer src   ?facet=none&Projected+change+by+2050=Cropland+area&Species+Group=All+vertebrates&Scenario=Halve+food+waste&country=OWID_WRL~Sub-Saharan+Africa~South+and+East+Asia~Europe~North+America~Latin+America~North+Africa~Oceania&hideControls=true  
14510 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 habitat-loss explorer src   ?facet=none&Projected+change+by+2050=Cropland+area&Species+Group=All+vertebrates&Scenario=Close+yield+gaps&country=OWID_WRL~Sub-Saharan+Africa~South+and+East+Asia~Europe~North+America~Latin+America~North+Africa~Oceania&hideControls=true  
14511 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 habitat-loss explorer src   ?facet=none&Projected+change+by+2050=Cropland+area&Species+Group=All+vertebrates&Scenario=Adoption+of+healthy+diets&country=OWID_WRL~Sub-Saharan+Africa~South+and+East+Asia~Europe~North+America~Latin+America~North+Africa~Oceania&hideControls=true  
14512 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 habitat-loss explorer src   ?facet=none&Projected+change+by+2050=Cropland+area&Species+Group=All+vertebrates&Scenario=Optimise+trade&country=OWID_WRL~Sub-Saharan+Africa~South+and+East+Asia~Europe~North+America~Latin+America~North+Africa~Oceania&hideControls=true  
14513 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 habitat-loss explorer src   ?facet=none&Projected+change+by+2050=Cropland+area&Species+Group=All+vertebrates&Scenario=Combined+interventions&country=OWID_WRL~Sub-Saharan+Africa~South+and+East+Asia~Europe~North+America~Latin+America~North+Africa~Oceania&hideControls=true  
14515 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 ourworldindata.org/explorers/habitat-loss url prominent-link      
24886 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 https://ourworldindata.org/uploads/2021/09/Cropland-change-scenarios.png url src      
24887 To protect the world’s wildlife we must improve crop yields – especially across Africa 44738 https://ourworldindata.org/uploads/2021/09/Habitat-loss-scenarios.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
);