chart_tags
Data license: CC-BY
4 rows where chartId = 2260
This data as json, CSV (advanced)
Suggested facets: keyChartLevel, createdAt (date)
| Link | chartId | tagId | keyChartLevel | createdAt | updatedAt | isApproved |
|---|---|---|---|---|---|---|
| 2260,18 | Number of one-year-olds who have received different vaccinations 2260 | Vaccination 18 | 3 | 2024-04-19 11:48:40 | 1 | |
| 2260,30 | Number of one-year-olds who have received different vaccinations 2260 | Tuberculosis 30 | 2 | 2024-04-19 11:48:40 | 1 | |
| 2260,1807 | Number of one-year-olds who have received different vaccinations 2260 | Pandemics 1807 | 2 | 2024-04-19 11:48:40 | 1 | |
| 2260,1815 | Number of one-year-olds who have received different vaccinations 2260 | Global Health 1815 | 2 | 2024-04-19 11:48:40 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "chart_tags" (
"chartId" INTEGER NOT NULL ,
"tagId" INTEGER NOT NULL ,
"keyChartLevel" TINYINT NOT NULL DEFAULT '0' ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL ,
"isApproved" TINYINT NOT NULL DEFAULT '0' ,
PRIMARY KEY ("chartId", "tagId"),
FOREIGN KEY("chartId") REFERENCES "charts" ("id") ON UPDATE RESTRICT ON DELETE CASCADE,
FOREIGN KEY("tagId") REFERENCES "tags" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE INDEX "FK_chart_tags_tagId" ON "chart_tags" ("tagId");