posts_gdocs_links

Data license: CC-BY

18 rows where sourceId = "1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: linkType, componentType, text, hash

id ▼ sourceId target linkType componentType text queryString hash
1870748 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU https://ourworldindata.org/indoor-air-pollution url prominent-link Indoor Air Pollution    
1870749 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU https://ourworldindata.org/outdoor-air-pollution url prominent-link Outdoor Air Pollution    
1870750 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU https://ourworldindata.org/energy url prominent-link Energy    
1870751 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU #all-charts url span-link See all interactive charts on Air Pollution ↓   #all-charts
1870752 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU https://ourworldindata.org/air-pollution-does-it-get-worse-before-it-gets-better url span-link Air pollution: does it get worse before it gets better?    
1870753 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU https://ourworldindata.org/data-review-air-pollution-deaths url span-link Data Review: How many people die from air pollution?    
1870754 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU https://ourworldindata.org/energy-poverty-air-pollution url span-link Energy poverty and indoor air pollution: a problem as old as humanity that we can end within our lifetime    
1870755 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU https://ourworldindata.org/no-clean-cooking-fuels url span-link How many people do not have access to clean fuels for cooking?    
1870756 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU https://ourworldindata.org/safest-sources-of-energy url span-link What are the safest and cleanest sources of energy?    
1870757 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU https://ourworldindata.org/london-air-pollution url span-link What the history of London’s air pollution can tell us about the future of today’s growing megacities    
1870758 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU https://ourworldindata.org/coal-phase-out url span-link When will countries phase out coal power?    
1870759 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU number-of-deaths-by-risk-factor grapher chart      
1870760 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU share-deaths-air-pollution grapher chart      
1870761 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU disease-burden-by-risk-factor grapher chart      
1870762 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU air-pollution-deaths-country grapher span-link here    
1870763 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU death-rates-total-air-pollution grapher chart      
1870764 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU death-rates-from-air-pollution grapher chart      
1870765 Air Pollution 1IxPaKLVC-rm0doT1JYDB2uFGR2TKNQ7Bq3d6riHCBuU https://www.thelancet.com/journals/lancet/article/PIIS0140-6736(20)30752-2/fulltext url span-link Global burden of 87 risk factors in 204 countries and territories, 1990–2019: a systematic analysis for the Global Burden of Disease Study 2019    

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