posts_gdocs_links

Data license: CC-BY

18 rows where sourceId = "1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: linkType, componentType, text

id ▼ sourceId target linkType componentType text queryString hash
1883206 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk 1y6_r7uCs3gCpshniXdE-nUkWgRxpZL0Tas2zm4ewebI gdoc research-and-writing      
1883207 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk 1XBMGw4j4jdlh4qt4Z2y2F_4cNFm-U5yrWFY2fRvMt3M gdoc research-and-writing      
1883208 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk 1sC5hYCG5Tbnt02QzaxHFeGhliSWbwUuyttXKP8TS9xc gdoc research-and-writing      
1883209 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk 1fdECw4wt6d7_-cIeMcsBfnoUEoeKwF2Z1gj3Y8RCF4g gdoc research-and-writing      
1883210 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk 1SpyofFwtTSpD69fW6rUq-D-zM6DSsW7I7l0_bNC-AMA gdoc research-and-writing      
1883211 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk 19AlSstYCtGglhNNt9mbKGAEf_oZcQTKNjYJ-5BlXSts gdoc research-and-writing      
1883212 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk 1IIijqBdZ9sev_QZ_iAorz3Rh7GI1RiM3fMrdvvaUOLM gdoc research-and-writing      
1883213 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk https://ourworldindata.org/population-growth url research-and-writing Population Growth    
1883214 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk 1wCZsgwS9Tlh8ySeanWnDgoX-fVftlVgzTBW8N8FSQE8 gdoc research-and-writing      
1883215 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk https://ourworldindata.org/ozone-layer url research-and-writing Ozone Layer    
1883216 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk 1BiDjrPb1f51E2t2mmtrIBA8LJHKkuecvSUm-b5ffxP8 gdoc research-and-writing      
1883217 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk 1f9abb7XLK8FCTPYJbn66qIfgGIYppr5spposXWRiN6o gdoc research-and-writing      
1883218 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk 1VfZnfnJWL-t3XTwwvVogsYJTHKp-6GXoFji0UOkNmsc gdoc research-and-writing      
1883219 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk https://ourworldindata.org/coronavirus url research-and-writing Coronavirus Pandemic (COVID-19)    
1883220 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk 1pB2dwxPSw-i1TWhuEJqx6n3jBTwxB9bMJQNyinB6NOg gdoc research-and-writing      
1883221 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk 1ppx0jcy-PKs56l587pllO9_MtETIQTngRudb0VfoVbs gdoc research-and-writing      
1883222 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk 1XrOGw_v7K1af0WVvjBIsQb9C4VesIGrjwEg6IEj-plU gdoc research-and-writing      
1883223 Lucas Rodés-Guirao 1zJl2JnuDfK616MC65-z0f46oZq6wWe0Gigggc87Uvxk https://github.com/lucasrodes/whatstk url span-link whatstk    

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