posts_gdocs_x_images

Data license: CC-BY

2 rows where gdocId = "1U0NQ2ZJ96xgggtQ9HrydGENjHdYUrR5aNd1H0TilTq4"

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ gdocId imageId
4858 Richer countries often use much of their crops for animal feed and biofuels 1U0NQ2ZJ96xgggtQ9HrydGENjHdYUrR5aNd1H0TilTq4 1395 1395
4859 Richer countries often use much of their crops for animal feed and biofuels 1U0NQ2ZJ96xgggtQ9HrydGENjHdYUrR5aNd1H0TilTq4 1396 1396

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