charts_x_entities

Data license: CC-BY

9 rows where chartId = 857

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
857,274632 Child labor in the United States 857 Both sexes 274632
857,274633 Child labor in the United States 857 Both sexes, rural areas 274633
857,274634 Child labor in the United States 857 Both sexes, urban areas 274634
857,274635 Child labor in the United States 857 Boys 274635
857,274636 Child labor in the United States 857 Boys, rural areas 274636
857,274637 Child labor in the United States 857 Boys, urban areas 274637
857,274638 Child labor in the United States 857 Girls 274638
857,274639 Child labor in the United States 857 Girls, rural areas 274639
857,274640 Child labor in the United States 857 Girls, urban areas 274640

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