charts_x_entities

Data license: CC-BY

2 rows where entityId = 212321

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
5023,212321 Global allocation of crops to end uses by farm size 5023 100 to 200 ha 212321
5024,212321 Global crop production by farm size 5024 100 to 200 ha 212321

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