charts_x_entities

Data license: CC-BY

2 rows where entityId = 212319

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
5023,212319 Global allocation of crops to end uses by farm size 5023 20 to 50 ha 212319
5024,212319 Global crop production by farm size 5024 20 to 50 ha 212319

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