posts_gdocs_x_images

Data license: CC-BY

2 rows where gdocId = "1osrh8h4zehCwQV07KQrtqPg8BG3obcKUb2tBABs1PbY"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ gdocId imageId
5836 Winters have warmed faster than summers in the United States 1osrh8h4zehCwQV07KQrtqPg8BG3obcKUb2tBABs1PbY 1443 1443
5837 Winters have warmed faster than summers in the United States 1osrh8h4zehCwQV07KQrtqPg8BG3obcKUb2tBABs1PbY 1442 1442

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