chart_tags
Data license: CC-BY
7 rows where tagId = 1809
This data as json, CSV (advanced)
Suggested facets: keyChartLevel, isApproved, createdAt (date)
Link | chartId | tagId | keyChartLevel | createdAt | updatedAt | isApproved |
---|---|---|---|---|---|---|
451,1809 | Higher labor productivity and price levels in richer and poorer countries 451 | Alzheimer's & Dementia 1809 | 0 | 2023-09-29 14:23:18 | 0 | |
1718,1809 | Deaths from dementia-related diseases, by age 1718 | Alzheimer's & Dementia 1809 | 0 | 2023-10-02 12:35:53 | 0 | |
1719,1809 | Death rate from Alzheimer's 1719 | Alzheimer's & Dementia 1809 | 0 | 2023-10-11 14:12:39 | 1 | |
6093,1809 | Deaths from Alzheimer's 6093 | Alzheimer's & Dementia 1809 | 2 | 2023-09-25 08:43:08 | 1 | |
6104,1809 | Death rate from Alzheimer's 6104 | Alzheimer's & Dementia 1809 | 0 | 2023-10-11 14:13:08 | 1 | |
6172,1809 | Deaths from Alzheimer's 6172 | Alzheimer's & Dementia 1809 | 2 | 2023-09-22 12:51:10 | 1 | |
6173,1809 | Death rate from Alzheimer's 6173 | Alzheimer's & Dementia 1809 | 0 | 2023-10-02 13:24:43 | 0 |
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");