posts_gdocs_links

Data license: CC-BY

12 rows where sourceId = "19JMZ5eAiHlnY5Kb_AXu6e286aWELPXizQO7e5qdWgGQ"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: target, text

id ▼ sourceId target linkType componentType text queryString hash
1826218 Food waste is responsible for 6% of global greenhouse gas emissions 19JMZ5eAiHlnY5Kb_AXu6e286aWELPXizQO7e5qdWgGQ https://ourworldindata.org/food-ghg-emissions url span-link accounts for    
1826219 Food waste is responsible for 6% of global greenhouse gas emissions 19JMZ5eAiHlnY5Kb_AXu6e286aWELPXizQO7e5qdWgGQ https://ourworldindata.org/co2-and-other-greenhouse-gas-emissions url span-link greenhouse gas emissions    
1826220 Food waste is responsible for 6% of global greenhouse gas emissions 19JMZ5eAiHlnY5Kb_AXu6e286aWELPXizQO7e5qdWgGQ https://ourworldindata.org/land-use url span-link land    
1826221 Food waste is responsible for 6% of global greenhouse gas emissions 19JMZ5eAiHlnY5Kb_AXu6e286aWELPXizQO7e5qdWgGQ https://ourworldindata.org/water-use-stress url span-link water    
1826222 Food waste is responsible for 6% of global greenhouse gas emissions 19JMZ5eAiHlnY5Kb_AXu6e286aWELPXizQO7e5qdWgGQ https://ourworldindata.org/energy url span-link energy    
1826223 Food waste is responsible for 6% of global greenhouse gas emissions 19JMZ5eAiHlnY5Kb_AXu6e286aWELPXizQO7e5qdWgGQ https://ourworldindata.org/fertilizers url span-link fertilizer    
1826224 Food waste is responsible for 6% of global greenhouse gas emissions 19JMZ5eAiHlnY5Kb_AXu6e286aWELPXizQO7e5qdWgGQ https://science.sciencemag.org/content/360/6392/987 url span-link Reducing food’s environmental impacts through producers and consumers    
1826225 Food waste is responsible for 6% of global greenhouse gas emissions 19JMZ5eAiHlnY5Kb_AXu6e286aWELPXizQO7e5qdWgGQ https://wrr-food.wri.org/ url span-link Creating a Sustainable Food Future—A Menu of Solutions to Feed Nearly 10 Billion People by 2050    
1826226 Food waste is responsible for 6% of global greenhouse gas emissions 19JMZ5eAiHlnY5Kb_AXu6e286aWELPXizQO7e5qdWgGQ https://science.sciencemag.org/content/360/6392/987 url span-link Reducing food’s environmental impacts through producers and consumers    
1826227 Food waste is responsible for 6% of global greenhouse gas emissions 19JMZ5eAiHlnY5Kb_AXu6e286aWELPXizQO7e5qdWgGQ https://www.climatewatchdata.org/ghg-emissions url span-link CAIT Climate Data Explorer    
1826228 Food waste is responsible for 6% of global greenhouse gas emissions 19JMZ5eAiHlnY5Kb_AXu6e286aWELPXizQO7e5qdWgGQ https://www.wri.org/blog/2020/02/greenhouse-gas-emissions-by-country-sector url span-link here    
1826229 Food waste is responsible for 6% of global greenhouse gas emissions 19JMZ5eAiHlnY5Kb_AXu6e286aWELPXizQO7e5qdWgGQ https://www.climatewatchdata.org/ghg-emissions url span-link CAIT Climate Data Explorer    

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