charts_x_entities

Data license: CC-BY

2 rows where entityId = 34795

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
951,34795 Global agricultural land use by major crop type 951 Pulses 34795
5075,34795 How much cropland has the world spared due to increases in crop yields? 5075 Pulses 34795

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