posts_gdocs_x_tags
Data license: CC-BY
6 rows where tagId = 1792
This data as json, CSV (advanced)
Link | gdocId | tagId |
---|---|---|
15V5Fjl02ReEmdXgb8D9m78x96fV_TzJgfyku2UBddBQ,1792 | In less than a decade, Peru has become the world's second-largest blueberry producer 15V5Fjl02ReEmdXgb8D9m78x96fV_TzJgfyku2UBddBQ | Crop Yields 1792 |
1Gy4UgmD_jVEAIhCN4PX0fdx4eP-GMyq29ZhVQiFSsnA,1792 | To protect the world’s wildlife we must improve crop yields — especially across Africa 1Gy4UgmD_jVEAIhCN4PX0fdx4eP-GMyq29ZhVQiFSsnA | Crop Yields 1792 |
1IGZ0zLEg1fBcvQOnIIYHsW9NXyEMKXTDo00sfD-Ql2k,1792 | 1IGZ0zLEg1fBcvQOnIIYHsW9NXyEMKXTDo00sfD-Ql2k | Crop Yields 1792 |
1NFcPl-lQzwEA6j8rApy1eLG_qBt6P1EW2sB9xrG-9pI,1792 | Crop Yields 1NFcPl-lQzwEA6j8rApy1eLG_qBt6P1EW2sB9xrG-9pI | Crop Yields 1792 |
1ip6yYXW9VBBuUMDTHMGl-8vXWAT77wABRsqdfuG3dO4,1792 | Why is improving agricultural productivity crucial to ending global hunger and protecting the world’s wildlife? 1ip6yYXW9VBBuUMDTHMGl-8vXWAT77wABRsqdfuG3dO4 | Crop Yields 1792 |
1tmQEoC8ASNXm68XxkjKsD-I1j2V-RyEQabtF7yp6CZo,1792 | 1tmQEoC8ASNXm68XxkjKsD-I1j2V-RyEQabtF7yp6CZo | Crop Yields 1792 |
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");