posts_links

Data license: CC-BY

9 rows where sourceId = 26939

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: linkType, componentType, queryString, hash

id ▼ sourceId target linkType componentType text queryString hash
6539 Pneumonia 26939 #burden-of-pneumonia url href     #burden-of-pneumonia
6540 Pneumonia 26939 #pneumonia-mortality-rates-by-age url href     #pneumonia-mortality-rates-by-age
6541 Pneumonia 26939 #where-do-children-die-from-pneumonia url href     #where-do-children-die-from-pneumonia
6542 Pneumonia 26939 #what-are-the-biggest-risks-for-developing-pneumonia url href     #what-are-the-biggest-risks-for-developing-pneumonia
6543 Pneumonia 26939 #how-can-we-reduce-the-number-of-people-dying-from-pneumonia url href     #how-can-we-reduce-the-number-of-people-dying-from-pneumonia
6544 Pneumonia 26939 #pneumococcal-vaccines url href     #pneumococcal-vaccines
6545 Pneumonia 26939 pneumonia-death-rates-70 grapher src      
6546 Pneumonia 26939 https://ourworldindata.org/outdoor-air-pollution url href      
6547 Pneumonia 26939 deaths-from-pneumonia-in-people-aged-70-and-older-by-risk-factor grapher src   ?time=latest  

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