posts_gdocs_links

Data license: CC-BY

24 rows where sourceId = "1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI"

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ sourceId target linkType componentType text queryString hash
1879287 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI #all-charts url span-link See all interactive charts on land use ↓   #all-charts
1879288 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI https://ourworldindata.org/agricultural-production url prominent-link Agricultural Production    
1879289 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI https://ourworldindata.org/crop-yields url prominent-link Crop Yields    
1879290 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI https://ourworldindata.org/peak-agriculture-land url span-link After millennia of agricultural expansion, the world has passed ‘peak agricultural land’    
1879291 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI https://ourworldindata.org/global-land-for-agriculture url span-link Half of the world’s habitable land is used for agriculture    
1879292 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI https://ourworldindata.org/yields-vs-land-use-how-has-the-world-produced-enough-food-for-a-growing-population url span-link Yields vs. land use: how the Green Revolution enabled us to feed a growing population    
1879293 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI land-use-over-the-long-term grapher chart      
1879294 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI total-agricultural-area-over-the-long-term grapher chart      
1879295 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI cropland-use-over-the-long-term grapher chart      
1879296 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI grazing-land-use-over-the-long-term grapher chart      
1879297 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI share-of-land-area-used-for-agriculture grapher chart      
1879298 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI share-of-land-area-used-for-arable-agriculture grapher chart      
1879299 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI share-of-land-area-used-for-permanent-meadows-and-pastures-1961-2014 grapher chart      
1879300 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI cropland-per-person-over-the-long-term grapher chart      
1879301 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI population-and-demography explorer span-link more than doubled ?facet=none&country=~OWID_WRL&Metric=Population&Sex=Both+sexes&Age+group=Total&Projection+Scenario=None  
1879302 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI arable-land-use-per-person grapher chart      
1879303 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI total-agricultural-land-use-per-person grapher chart      
1879304 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI agricultural-area-per-capita grapher chart      
1879305 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI global-agricultural-land-use-by-major-crop-type grapher chart      
1879306 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI land-use-protein-poore grapher chart   ?country=Beef+%28dairy+herd%29~Beef+%28beef+herd%29~Cheese~Fish+%28farmed%29~Eggs~Grains~Groundnuts~Milk~Lamb+%26+Mutton~Nuts~Peas~Pig+Meat~Other+Pulses~Poultry+Meat~Tofu+%28soybeans%29~Wheat+%26+Rye~Maize~Oatmeal  
1879307 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI https://web.archive.org/web/20240104050441/https://fenixservices.fao.org/faostat/static/documents/QI/QI_e.pdf url span-link here    
1879308 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI arable-land-pin grapher chart      
1879309 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI http://onlinelibrary.wiley.com/doi/10.1111/j.1728-4457.2013.00561.x/abstract url span-link here    
1879310 Land Use 1NnQYCqC014s3RZjkmzx5e1PR9yGAx_9RgsGf4JsXhvI https://openknowledge.fao.org/server/api/core/bitstreams/28cfd24e-81a9-4ebc-b2b5-4095fe5b1dab/content/cc8166en.html#figure_03_tab url span-link here   #figure_03_tab

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