posts_gdocs_links
Data license: CC-BY
6 rows where sourceId = "1wJrR7L_g5slr8k9TZyzPbr5_w0yUd-55ua_rezY8uz0"
This data as json, CSV (advanced)
Suggested facets: componentType, text
id ▼ | sourceId | target | linkType | componentType | text | queryString | hash |
---|---|---|---|---|---|---|---|
1877836 | Joe Hasell 1wJrR7L_g5slr8k9TZyzPbr5_w0yUd-55ua_rezY8uz0 | 1UjJLoGF5VMfn8U4C3ZSJQrPhc_jFRkeEhrhz5Ksfq7M | gdoc | pill-row | Poverty | ||
1877837 | Joe Hasell 1wJrR7L_g5slr8k9TZyzPbr5_w0yUd-55ua_rezY8uz0 | 1yzOrFd6uWvrAl2oFB3S67oOSbhgL1ffPHxjAqS7i-4w | gdoc | pill-row | Economic inequality | ||
1877838 | Joe Hasell 1wJrR7L_g5slr8k9TZyzPbr5_w0yUd-55ua_rezY8uz0 | 1gVSV2gqzPSTMI80gmHEgbaKeWalj6daqe519RtZaJ7I | gdoc | pill-row | Economic Growth | ||
1877839 | Joe Hasell 1wJrR7L_g5slr8k9TZyzPbr5_w0yUd-55ua_rezY8uz0 | 1M2S6EP-CAZL1Oi4szQ5k0BiuPUdaUDbAXTCjnwsQK3o | gdoc | research-and-writing | |||
1877840 | Joe Hasell 1wJrR7L_g5slr8k9TZyzPbr5_w0yUd-55ua_rezY8uz0 | 1w6ymndlipKyB8QEQsvpMvB3qC9Fn1QiLAUV_nnjGWtc | gdoc | research-and-writing | |||
1877841 | Joe Hasell 1wJrR7L_g5slr8k9TZyzPbr5_w0yUd-55ua_rezY8uz0 | 17-2C6H3kPd7w9DxWT2RG2QuLP0Pzxvm4H2RVsWFWUzM | gdoc | research-and-writing |
Advanced export
JSON shape: default, array, newline-delimited, object
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");