posts_gdocs_links

Data license: CC-BY

7 rows where sourceId = "1zEtvZ_MdbQlh1iczfNH-Eswu7N3bBjVWEV3Xp2VfCGI"

✎ 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
1828542 Is the world making progress in decarbonizing energy? 1zEtvZ_MdbQlh1iczfNH-Eswu7N3bBjVWEV3Xp2VfCGI https://ourworldindata.org/energy-substitution-method url span-link primary energy    
1828543 Is the world making progress in decarbonizing energy? 1zEtvZ_MdbQlh1iczfNH-Eswu7N3bBjVWEV3Xp2VfCGI low-carbon-share-energy grapher chart   ?tab=chart&country=~OWID_WRL  
1828544 Is the world making progress in decarbonizing energy? 1zEtvZ_MdbQlh1iczfNH-Eswu7N3bBjVWEV3Xp2VfCGI energy explorer span-link in absolute terms ?tab=chart&facet=none&country=~OWID_WRL&Total+or+Breakdown=Select+a+source&Select+a+source=Low-carbon&Energy+or+Electricity=Primary+energy&Metric=Annual+consumption  
1828545 Is the world making progress in decarbonizing energy? 1zEtvZ_MdbQlh1iczfNH-Eswu7N3bBjVWEV3Xp2VfCGI energy explorer span-link increased demand for energy ?tab=chart&facet=none&country=~OWID_WRL&Total+or+Breakdown=Total&Select+a+source=Low-carbon&Energy+or+Electricity=Primary+energy&Metric=Annual+consumption  
1828546 Is the world making progress in decarbonizing energy? 1zEtvZ_MdbQlh1iczfNH-Eswu7N3bBjVWEV3Xp2VfCGI energy explorer span-link total amount ?tab=chart&facet=none&country=~OWID_WRL&Total+or+Breakdown=Select+a+source&Select+a+source=Nuclear&Energy+or+Electricity=Primary+energy&Metric=Annual+consumption  
1828547 Is the world making progress in decarbonizing energy? 1zEtvZ_MdbQlh1iczfNH-Eswu7N3bBjVWEV3Xp2VfCGI primary-energy-share-nuclear-renewables grapher chart      
1828548 Is the world making progress in decarbonizing energy? 1zEtvZ_MdbQlh1iczfNH-Eswu7N3bBjVWEV3Xp2VfCGI https://ourworldindata.org/safest-sources-of-energy url span-link much safer and cleaner    

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