posts_gdocs_links

Data license: CC-BY

23 rows where sourceId = "1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: linkType, text

id ▼ sourceId target linkType componentType text queryString hash
1877887 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1LxPdXAyLDz61bVRINQ1MM7oCxxPCvKVYQD8yrWPcr_w gdoc research-and-writing      
1877888 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1h37-KpdZ3qAJ9xSA4OhbmGfmLr3Ydc_z9oHtDTszBuQ gdoc research-and-writing      
1877889 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1srs-VlnCNd1lMZBiuzNRUBsT41wWnGWddFRMiZ0jNaE gdoc research-and-writing      
1877890 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1mDkPiGSy3dHCfnIFc1HAPU2XU3yz9iKWBNWfRUTniCw gdoc research-and-writing      
1877891 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE gdoc research-and-writing      
1877892 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 16tVxsM1-wzwm_wpno-Y-M_IEInOCPJuWZqHfMLywNJc gdoc research-and-writing      
1877893 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo https://ourworldindata.org/biodiversity url research-and-writing Biodiversity    
1877894 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo https://ourworldindata.org/migration url research-and-writing Migration    
1877895 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1GhlZrbyAReOwQhdFG9eTsjLXTS_R8YhEK5WvxnM2O9Y gdoc research-and-writing      
1877896 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1lmIiF_8Vlm2_ysg5UXeRPmQ_M8XbmXqzRs7g2uGwGyc gdoc research-and-writing      
1877897 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1ZGKUXlb0RBlR5QJaEOzNq2rsIG2243r1fYUzg-ApHOs gdoc research-and-writing      
1877898 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1pRAxZhIjvgSDkKHws4lcG3cXIT5fpwFW8ekkucWVG2M gdoc research-and-writing      
1877899 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1RryPcgVJcANE76CPq5peAHTF3ag1WJe5BPujAXEjDkg gdoc research-and-writing      
1877900 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1szX11tRqr-NDnar2J7gZBQWMCFB4JFj5BEw0RkReFkU gdoc research-and-writing      
1877901 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1I3zjWv9OyeTZ4plQzxa4mdTeadqSn1bEbAKr-Vm3Du0 gdoc research-and-writing      
1877902 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 17jHJscbIFyrcDXNb3tUTVZJzLylcKEi0J-qNldo-efY gdoc research-and-writing      
1877903 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1MQ9geOm4jFHY-tOEpdRe9VeahFfr38x2bZipD7rQt5k gdoc research-and-writing      
1877904 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1oe_-FKOkoR8-QWg_6WuxZBZ4sxitO1j8m3g5-m8rXeI gdoc research-and-writing      
1877905 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E gdoc research-and-writing      
1877906 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1iTocsoZaQQ_n-24LmYIT7XrOaPb9B6_3L-bbzQwu43M gdoc research-and-writing      
1877907 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1dx9w3r4Wor4TDGAt4_Oggwuj-SVOzF7eT86CaO5efw8 gdoc research-and-writing      
1877908 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c gdoc research-and-writing      
1877909 Fiona Spooner 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo 1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE gdoc research-and-writing      

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