posts_gdocs_links

Data license: CC-BY

13 rows where sourceId = "1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: linkType, text, queryString, hash

id ▼ sourceId target linkType componentType text queryString hash
1850110 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk http://www.gapminder.org/ignorance/ url span-link The Gapminder Ignorance Project    
1850111 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk https://www.ipsos.com/en/global-perceptions-development-progress-perils-perceptions-research url span-link detailed survey    
1850112 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk https://ourworldindata.org/poverty?insight=global-extreme-poverty-declined-substantially-over-the-last-generation#key-insights-on-poverty url span-link Poverty ?insight=global-extreme-poverty-declined-substantially-over-the-last-generation #key-insights-on-poverty
1850113 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk distribution-of-population-between-different-poverty-thresholds-up-to-30-dollars grapher span-link here ?stackMode=relative&country=~OWID_WRL  
1850114 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk gdp-per-capita-maddison grapher span-link some generations ago ?time=1800..latest&country=SWE~USA~GBR~FRA~DEU~AUS  
1850115 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk child-mortality-around-the-world grapher span-link halved ?country=OWID_WRL+Less%20developed%20regions+Least%20developed%20countries+More%20developed%20regions  
1850116 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk https://www.facebook.com/OurWorldinData/ url span-link share our work    
1850117 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk http://ec.europa.eu/commfrontoffice/publicopinion/index.cfm url span-link here    
1850118 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk https://www.west-info.eu/files/Perils_of_perception_Topline1.pdf url span-link here    
1850119 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk https://www.tandfonline.com/doi/abs/10.1080/00139157.1993.9929122 url span-link here    
1850120 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk gdp-per-capita-penn-world-table grapher span-link This chart ?tab=chart&country=AUS~CHN~FRA~DEU~IDN~THA  
1850121 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk https://www.gapminder.org/factfulness-book/ url span-link Factfulness    
1850122 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk https://www.maxroser.com/about/ url span-link get in contact    

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