posts_gdocs_links

Data license: CC-BY

11 rows where sourceId = "11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: linkType, text

id ▼ sourceId target linkType componentType text queryString hash
1877876 Veronika Samborska 11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k 1NKASbsxax57u5ILzjysEDnlQiUTb7lzZHekOYWs35p4 gdoc research-and-writing      
1877877 Veronika Samborska 11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k 1qW5ok-Jo_asj_7A7WWfHHR_PpXhoUrD3OyssHfyWHtM gdoc research-and-writing      
1877878 Veronika Samborska 11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k 1gqIjXjFp1li7Jb6igdtePWrg5gCtAgmx3n4DKopAWi0 gdoc research-and-writing      
1877879 Veronika Samborska 11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k 1LdL7Zb-1kmgdIe4IrHV40qjPafc_SStDGMdBn6evqhM gdoc research-and-writing      
1877880 Veronika Samborska 11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k 1tS43kJ8ckyvaSEOqBBf0WtUtJ3X7T_Yh8J66HQQZS80 gdoc research-and-writing      
1877881 Veronika Samborska 11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k 1AGZVcZQjeUZ_-XvzkpUH68SU819fjCaS9xGFL8zDjf0 gdoc research-and-writing      
1877882 Veronika Samborska 11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k 1FbKVWqPddBZy0NcHzDG-BSoCsN5tJnok3RXcLo6R9ls gdoc research-and-writing      
1877883 Veronika Samborska 11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k 11t6XP9vKLDHeiDOcfaPOoc4TeQxHRixSjEikAlbGe0A gdoc research-and-writing      
1877884 Veronika Samborska 11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k 1JThdVafiH5m-oocV60ise6Sxe6wOLWp3ijAmJKkUIjM gdoc research-and-writing      
1877885 Veronika Samborska 11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k 1bnRuD7s6HMixQgapcH6GPQFK6ccFlDk0mQ9u7tqXiqs gdoc research-and-writing      
1877886 Veronika Samborska 11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k https://ourworldindata.org/oil-spills url research-and-writing Oil Spills    

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