charts_x_entities

Data license: CC-BY

11 rows where chartId = 5024

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
5024,212314 Global crop production by farm size 5024 0 to 1 ha 212314
5024,212315 Global crop production by farm size 5024 1 to 2 ha 212315
5024,212316 Global crop production by farm size 5024 2 to 5 ha 212316
5024,212317 Global crop production by farm size 5024 5 to 10 ha 212317
5024,212318 Global crop production by farm size 5024 10 to 20 ha 212318
5024,212319 Global crop production by farm size 5024 20 to 50 ha 212319
5024,212320 Global crop production by farm size 5024 50 to 100 ha 212320
5024,212321 Global crop production by farm size 5024 100 to 200 ha 212321
5024,212322 Global crop production by farm size 5024 200 to 500 ha 212322
5024,212323 Global crop production by farm size 5024 500 to 1000 ha 212323
5024,212324 Global crop production by farm size 5024 > 1000 ha 212324

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