charts_x_entities

Data license: CC-BY

6 rows where chartId = 2315

✎ View and edit SQL

This data as json, CSV (advanced)

Link chartId entityId
2315,3823 Sources of air pollution in the UK 2315 Ammonia 3823
2315,36538 Sources of air pollution in the UK 2315 Sulphur dioxide 36538
2315,36539 Sources of air pollution in the UK 2315 Nitrogen oxides 36539
2315,36540 Sources of air pollution in the UK 2315 NMVOC 36540
2315,36541 Sources of air pollution in the UK 2315 PM10 36541
2315,36542 Sources of air pollution in the UK 2315 PM2.5 36542

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