posts_gdocs_x_images
Data license: CC-BY
5 rows where gdocId = "1RfICP88c5Hm9mQ8SdXIQ8QLBzx0BXd2U2A7MQIVWz0Q"
This data as json, CSV (advanced)
id ▼ | gdocId | imageId |
---|---|---|
1422 | Not all forest loss is equal: what is the difference between deforestation and forest degradation? 1RfICP88c5Hm9mQ8SdXIQ8QLBzx0BXd2U2A7MQIVWz0Q | 517 517 |
1423 | Not all forest loss is equal: what is the difference between deforestation and forest degradation? 1RfICP88c5Hm9mQ8SdXIQ8QLBzx0BXd2U2A7MQIVWz0Q | 495 495 |
1424 | Not all forest loss is equal: what is the difference between deforestation and forest degradation? 1RfICP88c5Hm9mQ8SdXIQ8QLBzx0BXd2U2A7MQIVWz0Q | 496 496 |
1425 | Not all forest loss is equal: what is the difference between deforestation and forest degradation? 1RfICP88c5Hm9mQ8SdXIQ8QLBzx0BXd2U2A7MQIVWz0Q | 493 493 |
1426 | Not all forest loss is equal: what is the difference between deforestation and forest degradation? 1RfICP88c5Hm9mQ8SdXIQ8QLBzx0BXd2U2A7MQIVWz0Q | 491 491 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "posts_gdocs_x_images" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "gdocId" VARCHAR(255) NOT NULL , "imageId" INTEGER NOT NULL, FOREIGN KEY("gdocId") REFERENCES "posts_gdocs" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION, FOREIGN KEY("imageId") REFERENCES "images" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION ); CREATE INDEX "gdocId" ON "posts_gdocs_x_images" ("gdocId"); CREATE INDEX "imageId" ON "posts_gdocs_x_images" ("imageId");