post_tags
Data license: CC-BY
6 rows where tag_id = 106
This data as json, CSV (advanced)
Suggested facets: createdAt, createdAt (date)
Link | post_id | tag_id | createdAt | updatedAt |
---|---|---|---|---|
10994,106 | Air pollution: does it get worse before it gets better? 10994 | Air Pollution 106 | 2023-02-09 10:09:04 | |
11036,106 | 11036 | Air Pollution 106 | 2023-02-09 10:09:04 | |
11093,106 | 11093 | Air Pollution 106 | 2023-02-09 10:09:04 | |
12028,106 | What the history of London’s air pollution can tell us about the future of today’s growing megacities 12028 | Air Pollution 106 | 2023-02-09 10:09:04 | |
43909,106 | Energy poverty and indoor air pollution: a problem as old as humanity that we can end within our lifetime 43909 | Air Pollution 106 | 2023-10-10 09:39:52 | |
46275,106 | Data Review: How many people die from air pollution? 46275 | Air Pollution 106 | 2023-07-06 11:41:34 |
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");