charts_x_entities

Data license: CC-BY

3 rows where entityId = 94892

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
3897,94892 Global food miles by transport method 3897 Air 94892
3898,94892 Share of global food miles by transport method 3898 Air 94892
5484,94892 Greenhouse emissions per unit of food transported 5484 Air 94892

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "charts_x_entities" (
	"chartId" INTEGER NOT NULL  ,
	"entityId" INTEGER NOT NULL  ,
	PRIMARY KEY ("chartId", "entityId"),
	FOREIGN KEY("chartId") REFERENCES "charts" ("id") ON UPDATE CASCADE ON DELETE CASCADE,
	FOREIGN KEY("entityId") REFERENCES "entities" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "entityId" ON "charts_x_entities" ("entityId");