charts_x_entities

Data license: CC-BY

7 rows where chartId = 2039

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
2039,4 Smallpox death rate 2039 Belgium 4
2039,5 Smallpox death rate 2039 Netherlands 5
2039,10 Smallpox death rate 2039 Sweden 10
2039,24 Smallpox death rate 2039 Austria 24
2039,358 Smallpox death rate 2039 Scotland 358
2039,16818 Smallpox death rate 2039 England 16818
2039,35275 Smallpox death rate 2039 Prussia 35275

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