chart_tags
Data license: CC-BY
5 rows where tagId = 38
This data as json, CSV (advanced)
Suggested facets: createdAt, createdAt (date), updatedAt (date)
Link | chartId | tagId | keyChartLevel | createdAt | updatedAt | isApproved |
---|---|---|---|---|---|---|
409,38 | Birth and death rates in China and how they were affected by the Great Leap Forward famine 409 | Famines 38 | 2 | 2023-02-09 10:09:04 | 2023-09-15 15:36:12 | 1 |
1748,38 | Deaths from protein-energy malnutrition, by age 1748 | Famines 38 | 2 | 2023-08-15 10:53:57 | 2023-09-15 15:36:12 | 1 |
2256,38 | Global Hunger Index in 2017 vs. population growth 1992-2015 2256 | Famines 38 | 2 | 2023-02-09 10:09:04 | 2023-09-15 15:36:12 | 1 |
2257,38 | Change in Global Hunger Index vs. Population growth 2257 | Famines 38 | 2 | 2023-06-19 10:29:57 | 2023-09-15 15:36:12 | 1 |
2258,38 | Change in Global Hunger Index vs. Global Hunger Index in 1992 2258 | Famines 38 | 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");