chart_tags
Data license: CC-BY
7 rows where tagId = 1804
This data as json, CSV (advanced)
Suggested facets: keyChartLevel, isApproved, createdAt (date), updatedAt (date)
| Link | chartId | tagId | keyChartLevel | createdAt | updatedAt | isApproved |
|---|---|---|---|---|---|---|
| 6002,1804 | Annual mortality rate from seasonal influenza in the over-75's 6002 | Influenza 1804 | 0 | 2023-10-02 13:18:02 | 0 | |
| 6003,1804 | Flu vaccination coverage in the over-65's 6003 | Influenza 1804 | 2 | 2023-04-03 08:50:55 | 2023-09-15 15:36:12 | 1 |
| 6010,1804 | Respiratory death rate from seasonal influenza, age 65+ 6010 | Influenza 1804 | 2 | 2023-07-14 12:25:46 | 2023-09-15 15:36:12 | 1 |
| 6488,1804 | Availability of flu vaccines 6488 | Influenza 1804 | 2 | 2023-05-04 10:01:26 | 2023-09-15 15:36:12 | 1 |
| 6489,1804 | National policy on flu vaccination for older people 6489 | Influenza 1804 | 2 | 2023-05-04 09:54:02 | 2023-09-15 15:36:12 | 1 |
| 6492,1804 | Flu vaccination coverage in older people 6492 | Influenza 1804 | 2 | 2023-05-04 10:01:34 | 2023-09-15 15:36:12 | 1 |
| 7081,1804 | H5N1 influenza: monthly reported cases 7081 | Influenza 1804 | 2 | 2023-08-18 08:51:33 | 2023-09-15 15:36:12 | 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");