charts_x_entities

Data license: CC-BY

6 rows where entityId = 472

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
776,472 Share of land covered by forest 776 Western Asia 472
1797,472 Industry jobs as a share of total employment 1797 Western Asia 472
2298,472 Female labor force by age 2298 Western Asia 472
2768,472 Forest area 2768 Western Asia 472
3938,472 Share of women married or in a union 3938 Western Asia 472
4601,472 Share of global forest area 4601 Western Asia 472

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