posts_gdocs_links

Data license: CC-BY

12 rows where sourceId = "1wCZsgwS9Tlh8ySeanWnDgoX-fVftlVgzTBW8N8FSQE8"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: target, linkType, componentType, text, queryString, hash

id ▼ sourceId target linkType componentType text queryString hash
1862530 Five key findings from the 2022 UN Population Prospects 1wCZsgwS9Tlh8ySeanWnDgoX-fVftlVgzTBW8N8FSQE8 https://population.un.org/wpp/ url span-link World Population Prospects    
1862531 Five key findings from the 2022 UN Population Prospects 1wCZsgwS9Tlh8ySeanWnDgoX-fVftlVgzTBW8N8FSQE8 population-and-demography explorer span-link Population and Demography Data Explorer    
1862532 Five key findings from the 2022 UN Population Prospects 1wCZsgwS9Tlh8ySeanWnDgoX-fVftlVgzTBW8N8FSQE8 https://ourworldindata.org/world-population-growth#how-long-did-it-take-for-the-world-population-to-increase-by-one-billion url span-link every 12 years   #how-long-did-it-take-for-the-world-population-to-increase-by-one-billion
1862533 Five key findings from the 2022 UN Population Prospects 1wCZsgwS9Tlh8ySeanWnDgoX-fVftlVgzTBW8N8FSQE8 population-and-demography explorer chart   ?time=earliest..2099&facet=none&Metric=Population+growth+rate&Sex=Both+sexes&Age+group=Total&Projection+Scenario=None&country=~OWID_WRL&hideControls=true  
1862534 Five key findings from the 2022 UN Population Prospects 1wCZsgwS9Tlh8ySeanWnDgoX-fVftlVgzTBW8N8FSQE8 excess-deaths-cumulative-who grapher span-link estimated ?country=~OWID_WRL  
1862535 Five key findings from the 2022 UN Population Prospects 1wCZsgwS9Tlh8ySeanWnDgoX-fVftlVgzTBW8N8FSQE8 population-and-demography explorer chart   ?time=earliest..latest&facet=none&Metric=Deaths&Sex=Both+sexes&Age+group=Total&Projection+Scenario=None&country=~OWID_WRL&hideControls=true  
1862536 Five key findings from the 2022 UN Population Prospects 1wCZsgwS9Tlh8ySeanWnDgoX-fVftlVgzTBW8N8FSQE8 population-and-demography explorer chart   ?time=earliest..latest&facet=none&Metric=Population&Sex=Both+sexes&Age+group=Total&Projection+Scenario=Medium&country=~OWID_WRL&hideControls=true  
1862537 Five key findings from the 2022 UN Population Prospects 1wCZsgwS9Tlh8ySeanWnDgoX-fVftlVgzTBW8N8FSQE8 https://ourworldindata.org/fertility-rate url span-link fertility rate    
1862538 Five key findings from the 2022 UN Population Prospects 1wCZsgwS9Tlh8ySeanWnDgoX-fVftlVgzTBW8N8FSQE8 population-and-demography explorer chart   ?facet=none&Metric=Fertility+rate&Sex=Both+sexes&Age+group=Total&Projection+Scenario=Medium&country=High-income+countries~OWID_WRL&hideControls=true  
1862539 Five key findings from the 2022 UN Population Prospects 1wCZsgwS9Tlh8ySeanWnDgoX-fVftlVgzTBW8N8FSQE8 population-and-demography explorer span-link its fertility rate ?time=earliest..2099&facet=none&Metric=Fertility+rate&Sex=Both+sexes&Age+group=Total&Projection+Scenario=Medium&country=CHN~IND  
1862540 Five key findings from the 2022 UN Population Prospects 1wCZsgwS9Tlh8ySeanWnDgoX-fVftlVgzTBW8N8FSQE8 population-and-demography explorer chart   ?time=earliest..latest&facet=none&Metric=Population&Sex=Both+sexes&Age+group=Total&Projection+Scenario=Medium&country=CHN~IND&hideControls=true  
1862541 Five key findings from the 2022 UN Population Prospects 1wCZsgwS9Tlh8ySeanWnDgoX-fVftlVgzTBW8N8FSQE8 population-and-demography explorer prominent-link Population & Demography Data Explorer    

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