posts_gdocs_links

Data license: CC-BY

19 rows where sourceId = "1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8"

✎ 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
1853061 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 coal-production-by-country grapher span-link earliest adopters of coal ?tab=map&year=1900  
1853062 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 https://ourworldindata.org/what-is-the-safest-form-of-energy url span-link health and environmental impacts in both the long and short-term    
1853063 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 https://ourworldindata.org/co2-and-other-greenhouse-gas-emissions url span-link carbon dioxide (CO    
1853064 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 https://ourworldindata.org/co2-and-other-greenhouse-gas-emissions url span-link 2    
1853065 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 https://ourworldindata.org/co2-and-other-greenhouse-gas-emissions url span-link ) emissions    
1853066 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 annual-co-emissions-per-country grapher span-link UK CO ?tab=chart&country=GBR  
1853067 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 annual-co-emissions-per-country grapher span-link 2 ?tab=chart&country=GBR  
1853068 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 annual-co-emissions-per-country grapher span-link emissions have fallen ?tab=chart&country=GBR  
1853069 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 https://www.carbonbrief.org/analysis-uk-carbon-emissions-in-2017-fell-to-levels-last-seen-in-1890 url span-link was the largest driver    
1853070 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 coal-output-uk-tonnes grapher chart      
1853071 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 coal-uk-opencast-deep-mine grapher chart      
1853072 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 share-of-the-workforce-employed-in-the-coal-industry-united-kingdom grapher span-link 1-in-20 of the total UK workforce    
1853073 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 employment-in-the-coal-industry-in-the-united-kingdom grapher chart      
1853074 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 coal-by-end-user-uk grapher chart      
1853075 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 long-term-energy-transitions grapher span-link supplied more than 95 percent of demand ?country=England%20%26%20Wales  
1853076 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 https://ourworldindata.org/renewable-energy url span-link renewables    
1853077 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 https://www.carbonbrief.org/countdown-to-2025-tracking-the-uk-coal-phase-out url span-link completely phase out coal    
1853078 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 energy-consumption-by-source-and-region grapher chart   ?country=~GBR  
1853079 The death of UK coal in five charts 1mzzobPMjzHbWyNgpH6KEZG85naVj5ILVWFSF7FLfSK8 coal-output-uk-tonnes grapher span-link first chart presented in this article    

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