posts_gdocs_links

Data license: CC-BY

9 rows where sourceId = "1wyS9z-8SsNcezqd91TWO4U_Dn1dQOzAczukfjkF7taA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: componentType

id ▼ sourceId target linkType componentType text queryString hash
1879593 Lead Pollution 1wyS9z-8SsNcezqd91TWO4U_Dn1dQOzAczukfjkF7taA https://ourworldindata.org/air-pollution url topic-page-intro Air Pollution    
1879594 Lead Pollution 1wyS9z-8SsNcezqd91TWO4U_Dn1dQOzAczukfjkF7taA https://ourworldindata.org/energy url topic-page-intro Energy    
1879595 Lead Pollution 1wyS9z-8SsNcezqd91TWO4U_Dn1dQOzAczukfjkF7taA https://ourworldindata.org/ozone-layer url topic-page-intro Ozone Layer    
1879596 Lead Pollution 1wyS9z-8SsNcezqd91TWO4U_Dn1dQOzAczukfjkF7taA https://ourworldindata.org/reducing-lead-poisoning url research-and-writing Around one-in-three children globally suffer from lead poisoning. What can we do to reduce this?    
1879597 Lead Pollution 1wyS9z-8SsNcezqd91TWO4U_Dn1dQOzAczukfjkF7taA https://ourworldindata.org/leaded-gasoline-phase-out url research-and-writing How the world eliminated lead from gasoline    
1879598 Lead Pollution 1wyS9z-8SsNcezqd91TWO4U_Dn1dQOzAczukfjkF7taA https://ourworldindata.org/decline-lead-poisoning url research-and-writing Many countries have achieved an impressive reduction in lead poisoning    
1879599 Lead Pollution 1wyS9z-8SsNcezqd91TWO4U_Dn1dQOzAczukfjkF7taA https://ourworldindata.org/lead-paint url research-and-writing Many countries have eliminated lead from paint. How do we achieve the same everywhere?    
1879600 Lead Pollution 1wyS9z-8SsNcezqd91TWO4U_Dn1dQOzAczukfjkF7taA https://leadelimination.org/ url span-link Lead Exposure Elimination Project    
1879601 Lead Pollution 1wyS9z-8SsNcezqd91TWO4U_Dn1dQOzAczukfjkF7taA http://ghdx.healthdata.org/gbd-results-tool url span-link Global Burden of Disease    

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