posts_gdocs_x_images

Data license: CC-BY

10 rows where gdocId = "1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ gdocId imageId
3446 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk 20 20
3447 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk 15 15
3448 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk 16 16
3449 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk 18 18
3450 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk 14 14
3451 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk 524 524
3452 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk 21 21
3453 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk 17 17
3454 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk 19 19
3455 Optimism and Pessimism 1Lo3CtGGESA3iQVrlhlQZbtG15ecUNt1Qfk2X3iBlwIk 13 13

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