chart_tags
Data license: CC-BY
6 rows where tagId = 61
This data as json, CSV (advanced)
Suggested facets: createdAt, createdAt (date), updatedAt (date)
| Link | chartId | tagId | keyChartLevel | createdAt | updatedAt | isApproved |
|---|---|---|---|---|---|---|
| 3960,61 | Share of food lost in post-harvest processes 3960 | Food Waste 61 | 2 | 2023-02-23 14:49:57 | 2023-09-15 15:36:12 | 1 |
| 3961,61 | Share of food lost in post-harvest processes by region 3961 | Food Waste 61 | 2 | 2023-02-15 09:50:00 | 2023-09-15 15:36:12 | 1 |
| 3988,61 | Share of calories in each food group that are lost or wasted 3988 | Food Waste 61 | 2 | 2023-02-09 10:09:04 | 2023-09-15 15:36:12 | 1 |
| 3989,61 | Share of global food loss and waste by region 3989 | Food Waste 61 | 2 | 2023-02-09 10:09:04 | 2023-09-15 15:36:12 | 1 |
| 5207,61 | Food waste per capita 5207 | Food Waste 61 | 2 | 2023-02-23 14:47:01 | 2023-09-15 15:36:12 | 1 |
| 6608,61 | Food loss index 6608 | Food Waste 61 | 2 | 2023-05-02 16:17: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");