posts_gdocs_x_images

Data license: CC-BY

2 rows where imageId = 467

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ gdocId imageId
5125 You want to reduce the carbon footprint of your food? Focus on what you eat, not whether your food is local 1eLz7uWtNKJXUoxzM7x8Q1WiHMxOxh3nwoi71wMq8hKY 467 467
6072 Environmental Impacts of Food Production 1WQYUQCE4IJ_crPxJaPQCcD5XsjihUdswKh0XPa4w9SA 467 467

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