posts_gdocs_x_images

Data license: CC-BY

3 rows where gdocId = "1UW7qSVy794pjItLLQZpWqResQJh0bc3D2gz2OZ7yGyU"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ gdocId imageId
1480 How much plastic waste ends up in the ocean? 1UW7qSVy794pjItLLQZpWqResQJh0bc3D2gz2OZ7yGyU 532 532
1481 How much plastic waste ends up in the ocean? 1UW7qSVy794pjItLLQZpWqResQJh0bc3D2gz2OZ7yGyU 531 531
1482 How much plastic waste ends up in the ocean? 1UW7qSVy794pjItLLQZpWqResQJh0bc3D2gz2OZ7yGyU 530 530

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");