posts_gdocs_links
Data license: CC-BY
4 rows where sourceId = "1deXXGAxSScn_ho5U5m8OUj3MyOzEWGMiG8FPxlgMZ08"
This data as json, CSV (advanced)
Suggested facets: target
id ▼ | sourceId | target | linkType | componentType | text | queryString | hash |
---|---|---|---|---|---|---|---|
1859445 | How do the carbon footprints of foods compare? Our article as a video. 1deXXGAxSScn_ho5U5m8OUj3MyOzEWGMiG8FPxlgMZ08 | http://vox.com | url | span-link | Vox | ||
1859446 | How do the carbon footprints of foods compare? Our article as a video. 1deXXGAxSScn_ho5U5m8OUj3MyOzEWGMiG8FPxlgMZ08 | https://science.sciencemag.org/content/360/6392/987 | url | span-link | the paper by Poore and Nemecek | ||
1859447 | How do the carbon footprints of foods compare? Our article as a video. 1deXXGAxSScn_ho5U5m8OUj3MyOzEWGMiG8FPxlgMZ08 | https://ourworldindata.org/food-choice-vs-eating-local | url | span-link | original article | ||
1859448 | How do the carbon footprints of foods compare? Our article as a video. 1deXXGAxSScn_ho5U5m8OUj3MyOzEWGMiG8FPxlgMZ08 | https://science.sciencemag.org/content/360/6392/987 | url | span-link | Reducing food’s environmental impacts through producers and consumers |
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");