posts_gdocs_x_tags
Data license: CC-BY
6 rows where tagId = 36
This data as json, CSV (advanced)
Link | gdocId | tagId |
---|---|---|
14eHWSP57fDnIsbKVIkpEFf2nFlXP_egrcdIDp881QfM,36 | Food Supply 14eHWSP57fDnIsbKVIkpEFf2nFlXP_egrcdIDp881QfM | Food Supply 36 |
15hEchniGhmgO8mLsSi5mXek2a9na-Mo1VFtrsWcQw1g,36 | Yields vs. land use: how the Green Revolution enabled us to feed a growing population 15hEchniGhmgO8mLsSi5mXek2a9na-Mo1VFtrsWcQw1g | Food Supply 36 |
1EDxb07QobF366YeOEy9HFwoBfK37MmcBxj1yOFTqLxk,36 | How could the war in Ukraine impact global food supplies? 1EDxb07QobF366YeOEy9HFwoBfK37MmcBxj1yOFTqLxk | Food Supply 36 |
1R1kha6T04SWoYaQZaUyaiemKX15_KCsMVRs1xggezD8,36 | How much of the world’s food production is dependent on pollinators? 1R1kha6T04SWoYaQZaUyaiemKX15_KCsMVRs1xggezD8 | Food Supply 36 |
1Y_9whq0Xs8DjSu2sSMENf8KlLVLXVu-HFXdB1582QTM,36 | 1Y_9whq0Xs8DjSu2sSMENf8KlLVLXVu-HFXdB1582QTM | Food Supply 36 |
1qT1GqoufLtV-JR98fNgWSHgAwBArwg0DjyjnSjU0HO8,36 | Do we only have 60 harvests left? 1qT1GqoufLtV-JR98fNgWSHgAwBArwg0DjyjnSjU0HO8 | Food Supply 36 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "posts_gdocs_x_tags" ( "gdocId" VARCHAR(255) NOT NULL , "tagId" INTEGER NOT NULL , PRIMARY KEY ("gdocId", "tagId"), FOREIGN KEY("gdocId") REFERENCES "posts_gdocs" ("id") ON UPDATE RESTRICT ON DELETE CASCADE, FOREIGN KEY("tagId") REFERENCES "tags" ("id") ON UPDATE RESTRICT ON DELETE CASCADE ); CREATE INDEX "FK_posts_gdocs_x_tags_tag_id" ON "posts_gdocs_x_tags" ("tagId");