chart_tags
Data license: CC-BY
6 rows where tagId = 1564
This data as json, CSV (advanced)
Suggested facets: createdAt, createdAt (date), updatedAt (date)
| Link | chartId | tagId | keyChartLevel | createdAt | updatedAt | isApproved |
|---|---|---|---|---|---|---|
| 1373,1564 | Share of women using contraceptives 1373 | Contraception & Abortion 1564 | 2 | 2023-02-09 10:09:04 | 2023-09-15 15:36:12 | 1 |
| 1374,1564 | Contraceptive prevalence: modern methods vs. any methods 1374 | Contraception & Abortion 1564 | 2 | 2023-02-09 10:09:04 | 2023-09-15 15:36:12 | 1 |
| 2809,1564 | Women who make their own informed decisions regarding sexual relations, contraceptive use and reproductive health care 2809 | Contraception & Abortion 1564 | 2 | 2024-07-30 12:52:01 | 1 | |
| 2857,1564 | MDG5.B: Share of married women using contraceptives 2857 | Contraception & Abortion 1564 | 2 | 2023-02-09 10:09:04 | 2023-09-15 15:36:12 | 1 |
| 3256,1564 | Fertility rate vs. unmet need for contraception 3256 | Contraception & Abortion 1564 | 2 | 2023-02-09 10:09:04 | 2023-09-15 15:36:12 | 1 |
| 3257,1564 | Fertility rate vs. contraceptive prevalence 3257 | Contraception & Abortion 1564 | 2 | 2023-02-09 10:09:04 | 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");