chart_tags
Data license: CC-BY
5 rows where tagId = 355
This data as json, CSV (advanced)
Suggested facets: keyChartLevel, createdAt (date)
Link | chartId | tagId | keyChartLevel | createdAt | updatedAt | isApproved |
---|---|---|---|---|---|---|
408,355 | World regions according to Our World in Data 408 | World Regions 355 | 2 | 2023-10-13 07:59:53 | 1 | |
865,355 | World regions according to the World Health Organization 865 | World Regions 355 | 2 | 2023-10-13 07:59:59 | 1 | |
1290,355 | World regions according to the World Bank 1290 | World Regions 355 | 2 | 2023-10-13 08:00:04 | 1 | |
5318,355 | World regions in the SDG framework of the United Nations 5318 | World Regions 355 | 2 | 2023-10-02 16:33:26 | 1 | |
7784,355 | World regions according to the Maddison Project Database 7784 | World Regions 355 | 0 | 2024-05-02 16:28:06 | 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");