post_tags
Data license: CC-BY
6 rows where tag_id = 1796
This data as json, CSV (advanced)
Suggested facets: createdAt (date)
Link | post_id | tag_id | createdAt | updatedAt |
---|---|---|---|---|
27025,1796 | Food production is responsible for one-quarter of the world’s greenhouse gas emissions 27025 | Environmental Impacts of Food Production 1796 | 2023-09-01 15:56:11 | |
27234,1796 | 27234 | Environmental Impacts of Food Production 1796 | 2023-09-01 11:26:52 | |
29601,1796 | Environmental Impacts of Food Production 29601 | Environmental Impacts of Food Production 1796 | 2023-02-09 10:09:04 | |
30777,1796 | Food waste is responsible for 6% of global greenhouse gas emissions 30777 | Environmental Impacts of Food Production 1796 | 2023-09-01 15:59:19 | |
43392,1796 | Emissions from food alone could use up all of our budget for 1.5°C or 2°C – but we have a range of opportunities to avoid this 43392 | Environmental Impacts of Food Production 1796 | 2023-09-01 15:47:07 | |
51073,1796 | What share of people say they are vegetarian, vegan, or flexitarian? 51073 | Environmental Impacts of Food Production 1796 | 2023-07-31 11:38:39 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "post_tags" ( "post_id" INTEGER NOT NULL , "tag_id" INTEGER NOT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , PRIMARY KEY ("post_id", "tag_id"), FOREIGN KEY("post_id") REFERENCES "posts" ("id") ON UPDATE RESTRICT ON DELETE CASCADE, FOREIGN KEY("tag_id") REFERENCES "tags" ("id") ON UPDATE RESTRICT ON DELETE CASCADE ); CREATE INDEX "FK_post_tags_tag_id" ON "post_tags" ("tag_id");