posts_links

Data license: CC-BY

8 rows where sourceId = 51181

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: linkType, componentType, queryString

id ▼ sourceId target linkType componentType text queryString hash
23309 CO2-GDP decoupling 51181 co2-emissions-vs-gdp grapher href      
23310 CO2-GDP decoupling 51181 co2-emissions-and-gdp grapher prominent-link   ?country=~GBR  
23311 CO2-GDP decoupling 51181 https://ourworldindata.org/energy-offshoring url href      
23312 CO2-GDP decoupling 51181 energy explorer href   ?facet=none&country=USA~GBR~CHN~OWID_WRL~IND~BRA~ZAF&Total+or+Breakdown=Select+a+source&Select+a+source=Low-carbon&Energy+or+Electricity=Primary+energy&Metric=Share+of+total  
23313 CO2-GDP decoupling 51181 co2 explorer href   ?tab=map&facet=none&country=CHN~USA~IND~GBR~OWID_WRL&Gas=CO%E2%82%82&Accounting=Consumption-based&Fuel=Total&Count=Per+country  
23314 CO2-GDP decoupling 51181 https://ourworldindata.org/cheap-renewables-growth url href      
23315 CO2-GDP decoupling 51181 co2-emissions-and-gdp-per-capita grapher src   ?time=1750..2019&country=~GBR  
23316 CO2-GDP decoupling 51181 co2-emissions-and-gdp-long-term grapher prominent-link   ?time=1890..latest\u0026country=~DEU  

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