posts_gdocs_x_images

Data license: CC-BY

3 rows where imageId = 1220

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ gdocId imageId
4418 How does the Living Planet Index vary by region? 1Dfymewkd1ZtUrmLSAc2VVCIejsbe2zLjqe8ioD1RnAw 1220 1220
4611 How does age standardization make health metrics comparable? 1abYtLfS2RLS4Ph2pyHXcuTg61vhxFMeUybfUHtKqMnE 1220 1220
6087 Biodiversity 1LeypWlkEMK1SHJh1jXdfY6AeTYD0EoJ27dM9alGvLVM 1220 1220

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