posts_gdocs_links

Data license: CC-BY

6 rows where sourceId = "1TB59aGXgPRW37lAjvFGrSSDBoH38URvk6XfbCHHVqMY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: linkType, componentType, text

id ▼ sourceId target linkType componentType text queryString hash
1821744 Airline hijackings were once common but are very rare today 1TB59aGXgPRW37lAjvFGrSSDBoH38URvk6XfbCHHVqMY https://en.wikipedia.org/wiki/List_of_aircraft_hijackings url span-link dating    
1821745 Airline hijackings were once common but are very rare today 1TB59aGXgPRW37lAjvFGrSSDBoH38URvk6XfbCHHVqMY airliner-hijackings-and-fatalities-from-them grapher chart      
1821746 Airline hijackings were once common but are very rare today 1TB59aGXgPRW37lAjvFGrSSDBoH38URvk6XfbCHHVqMY https://aviation-safety.net/ url span-link Aviation Safety Network    
1821747 Airline hijackings were once common but are very rare today 1TB59aGXgPRW37lAjvFGrSSDBoH38URvk6XfbCHHVqMY https://www.vox.com/2016/3/29/11326472/hijacking-airplanes-egyptair url span-link particularly in the United States    
1821748 Airline hijackings were once common but are very rare today 1TB59aGXgPRW37lAjvFGrSSDBoH38URvk6XfbCHHVqMY aviation-fatalities-per-million-passengers grapher span-link there were only    
1821749 Airline hijackings were once common but are very rare today 1TB59aGXgPRW37lAjvFGrSSDBoH38URvk6XfbCHHVqMY global-fatalities-from-aviation-accidents-and-hijackings grapher chart      

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