posts_gdocs_x_images

Data license: CC-BY

4 rows where gdocId = "14ZnX7uW1aOuJAM7CPFmxwdq8fniYwBqDfbp4mlS0ZZA"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ gdocId imageId
3308 The world’s energy problem 14ZnX7uW1aOuJAM7CPFmxwdq8fniYwBqDfbp4mlS0ZZA 418 418
3309 The world’s energy problem 14ZnX7uW1aOuJAM7CPFmxwdq8fniYwBqDfbp4mlS0ZZA 419 419
3310 The world’s energy problem 14ZnX7uW1aOuJAM7CPFmxwdq8fniYwBqDfbp4mlS0ZZA 420 420
3311 The world’s energy problem 14ZnX7uW1aOuJAM7CPFmxwdq8fniYwBqDfbp4mlS0ZZA 119 119

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