posts_links

Data license: CC-BY

10 rows where sourceId = 25881

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ sourceId target linkType componentType text queryString hash
19719 Untitled Reusable Block 25881 https://ourworldindata.org/global-rise-of-education#how-has-global-literacy-evolved-in-the-last-two-centuries url href     #how-has-global-literacy-evolved-in-the-last-two-centuries
19720 Untitled Reusable Block 25881 https://ourworldindata.org/literacy#in-most-countries-there-are-large-generational-literacy-gaps-favouring-the-young url href     #in-most-countries-there-are-large-generational-literacy-gaps-favouring-the-young
19721 Untitled Reusable Block 25881 literacy-rates-of-the-the-younger-population-15-24-years-versus-literacy-rates-of-the-older-population-65 grapher href      
19722 Untitled Reusable Block 25881 https://ourworldindata.org/primary-and-secondary-education#enrollment-by-sex url href     #enrollment-by-sex
19723 Untitled Reusable Block 25881 number-of-out-of-school-children grapher href   ?country=Sub-Saharan%20Africa  
19724 Untitled Reusable Block 25881 out-of-school-children-of-primary-school-age-by-world-region grapher href   ?stackMode=relative  
19725 Untitled Reusable Block 25881 share-primary-school-age-out-of-school grapher href      
19726 Untitled Reusable Block 25881 https://sdg-tracker.org/quality-education#4.1 url href     #4.1
19727 Untitled Reusable Block 25881 number-of-out-of-school-children grapher src      
19728 Untitled Reusable Block 25881 out-of-school-children-of-primary-school-age-by-world-region grapher src      

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "posts_links" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"sourceId" INTEGER NOT NULL  ,
	"target" VARCHAR(2047) 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" ("id") ON UPDATE CASCADE ON DELETE CASCADE
);