posts_links

Data license: CC-BY

19 rows where sourceId = 34363

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: linkType, componentType, queryString

id ▼ sourceId target linkType componentType text queryString hash
8237 CO2 emissions by fuel 34363 https://github.com/owid/co2-data url href      
8238 CO2 emissions by fuel 34363 http://doi.org/10.1016/j.enpol.2011.09.049 url href      
8239 CO2 emissions by fuel 34363 http://doi.org/10.1016/j.rser.2011.02.014 url href      
8240 CO2 emissions by fuel 34363 http://www.worldbank.org/en/programs/gasflaringreduction url href      
8241 CO2 emissions by fuel 34363 CO2-by-source grapher src      
8242 CO2 emissions by fuel 34363 co2-emissions-by-fuel-line grapher src      
8243 CO2 emissions by fuel 34363 per-capita-co2-fuel grapher src      
8244 CO2 emissions by fuel 34363 per-capita-co2-by-fuel grapher src   ?time=2019&country=~CHN~USA~OWID_WRL~IND~GBR~BRA~AUS~SWE~FRA~DEU~ZAF  
8245 CO2 emissions by fuel 34363 annual-co2-coal grapher src   ?tab=chart  
8246 CO2 emissions by fuel 34363 per-capita-co2-coal grapher src      
8247 CO2 emissions by fuel 34363 annual-co2-oil grapher src   ?tab=chart  
8248 CO2 emissions by fuel 34363 per-capita-co2-oil grapher src      
8249 CO2 emissions by fuel 34363 annual-co2-gas grapher src   ?tab=chart  
8250 CO2 emissions by fuel 34363 per-capita-co2-gas grapher src      
8251 CO2 emissions by fuel 34363 annual-co2-cement grapher src   ?tab=chart  
8252 CO2 emissions by fuel 34363 per-capita-co2-cement grapher src      
8253 CO2 emissions by fuel 34363 annual-co2-flaring grapher src   ?tab=chart  
8254 CO2 emissions by fuel 34363 per-capita-co2-flaring grapher src      
8255 CO2 emissions by fuel 34363 ourworldindata.org/energy url prominent-link      

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