chart_tags
Data license: CC-BY
7 rows where tagId = 1558
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
| Link | chartId | tagId | keyChartLevel | createdAt | updatedAt | isApproved |
|---|---|---|---|---|---|---|
| 97,1558 | Reported cases of measles 97 | Measles 1558 | 2 | 2023-07-21 10:44:47 | 2023-09-15 15:36:12 | 1 |
| 299,1558 | Share of one-year-olds vaccinated against measles 299 | Measles 1558 | 2 | 2023-07-21 10:34:09 | 2023-09-15 15:36:12 | 1 |
| 1601,1558 | Reported cases and deaths of measles 1601 | Measles 1558 | 2 | 2023-07-21 10:51:53 | 2023-09-15 15:36:12 | 1 |
| 1664,1558 | Rate of cases and deaths from measles in the United States 1664 | Measles 1558 | 2 | 2023-07-21 10:51:57 | 2023-09-15 15:36:12 | 1 |
| 3887,1558 | Share of children fully vaccinated against measles 3887 | Measles 1558 | 2 | 2023-07-21 10:34:04 | 2023-09-15 15:36:12 | 1 |
| 4311,1558 | Deaths due to measles 4311 | Measles 1558 | 2 | 2023-07-21 10:52:01 | 2023-09-15 15:36:12 | 1 |
| 4568,1558 | Number of one-year-olds who are not vaccinated against measles 4568 | Measles 1558 | 2 | 2023-07-21 10:52:00 | 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");