posts_links
Data license: CC-BY
6 rows where sourceId = 573
This data as json, CSV (advanced)
Suggested facets: queryString, hash
id ▼ | sourceId | target | linkType | componentType | text | queryString | hash |
---|---|---|---|---|---|---|---|
9281 | Books 573 | https://ourworldindata.org/economic-growth | url | href | |||
9282 | Books 573 | https://ourworldindata.org/literacy | url | href | |||
9283 | Books 573 | https://ourworldindata.org/global-education | url | href | |||
9284 | Books 573 | https://www.jstor.org/stable/40263962?seq=1#metadata_info_tab_contents | url | href | ?seq=1 | #metadata_info_tab_contents | |
9285 | Books 573 | https://ourworldindata.org/land-use | url | href | |||
9286 | Books 573 | https://ourworldindata.org/technological-progress | url | href |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );