posts_gdocs_links

Data license: CC-BY

7 rows where sourceId = "1zDB6zUS4fw6s3rXHz5Su6rR50Ey_hB75CYDIkj8kO_w"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: linkType, componentType, text, queryString

id ▼ sourceId target linkType componentType text queryString hash
1879848 Migration 1zDB6zUS4fw6s3rXHz5Su6rR50Ey_hB75CYDIkj8kO_w https://ourworldindata.org/world-population-growth url topic-page-intro World Population Growth    
1879849 Migration 1zDB6zUS4fw6s3rXHz5Su6rR50Ey_hB75CYDIkj8kO_w https://ourworldindata.org/poverty url topic-page-intro Poverty    
1879850 Migration 1zDB6zUS4fw6s3rXHz5Su6rR50Ey_hB75CYDIkj8kO_w https://ourworldindata.org/income-inequality url topic-page-intro Income inequality    
1879851 Migration 1zDB6zUS4fw6s3rXHz5Su6rR50Ey_hB75CYDIkj8kO_w https://ourworldindata.org/economic-growth url span-link source of income    
1879852 Migration 1zDB6zUS4fw6s3rXHz5Su6rR50Ey_hB75CYDIkj8kO_w migration explorer chart   ?facet=none&Metric=Number+of+international+immigrants&Period=Total&Sub-metric=Total&country=USA~DEU~FRA~GBR~SYR~TUR~YEM~IND~CAN&hideControls=false  
1879853 Migration 1zDB6zUS4fw6s3rXHz5Su6rR50Ey_hB75CYDIkj8kO_w 17jHJscbIFyrcDXNb3tUTVZJzLylcKEi0J-qNldo-efY gdoc prominent-link      
1879854 Migration 1zDB6zUS4fw6s3rXHz5Su6rR50Ey_hB75CYDIkj8kO_w migration-flows explorer chart   ?facet=none&Select+a+country=Afghanistan&Outflow+or+Inflow=Emigrants%3A+Where+people+born+in+the+selected+country+moved+to&country=USA~GBR~FRA~MEX~IND~CHN~DEU~AUS~BRA~ZAF&hideControls=false  

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