posts_gdocs_links

Data license: CC-BY

4 rows where sourceId = "1iT9jZ214V4zn6CUPapia3gahWWzvAYYHSoOf4v40mhk"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: target, linkType, componentType, queryString

id ▼ sourceId target linkType componentType text queryString hash
1884339 The global number of children not attending school has declined by nearly 40% since 2000 1iT9jZ214V4zn6CUPapia3gahWWzvAYYHSoOf4v40mhk children-and-youth-out-of-school grapher front-matter      
1884340 The global number of children not attending school has declined by nearly 40% since 2000 1iT9jZ214V4zn6CUPapia3gahWWzvAYYHSoOf4v40mhk population-and-demography explorer span-link has grown during this time ?facet=none&Metric=Population&Sex=Both+sexes&Age+group=Under+15+years&Projection+Scenario=None&country=~OWID_WRL  
1884341 The global number of children not attending school has declined by nearly 40% since 2000 1iT9jZ214V4zn6CUPapia3gahWWzvAYYHSoOf4v40mhk girls-and-boys-who-are-out-of-school grapher span-link this gap has nearly closed    
1884342 The global number of children not attending school has declined by nearly 40% since 2000 1iT9jZ214V4zn6CUPapia3gahWWzvAYYHSoOf4v40mhk children-and-youth-out-of-school grapher span-link Explore the number of children out of school in other countries    

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