post_tags

Relationship table to link posts and tags

Data license: CC-BY

678 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ post_id tag_id createdAt updatedAt
0 0 418 163 2023-02-09 10:09:04  
1 1 418 1640 2023-02-09 10:09:04  
2 2 573 313 2023-10-12 17:11:31  
3 3 573 1640 2023-10-12 17:11:31  
4 4 586 92 2023-02-09 10:09:04  
5 5 586 1640 2023-02-09 10:09:04  
6 6 596 36 2023-02-09 10:09:04  
7 7 596 1640 2023-02-09 10:09:04  
8 8 671 302 2023-02-09 10:09:04  
9 9 671 1640 2023-02-09 10:09:04  
10 10 691 255 2023-02-09 10:09:04  
11 11 691 1640 2023-02-09 10:09:04  
12 12 710 1640 2023-10-12 16:51:08  
13 13 1258 40 2023-02-09 10:09:04  
14 14 1258 1640 2023-02-09 10:09:04  
15 15 1308 1 2023-02-09 10:09:04  
16 16 1308 1640 2023-02-09 10:09:04  
17 17 1314 2 2023-02-09 10:09:04  
18 18 1314 1640 2023-02-09 10:09:04  
19 19 1441 5 2023-10-12 09:53:44  
20 20 1441 1640 2023-10-12 09:53:44  
21 21 1455 18 2023-02-09 10:09:04  
22 22 1455 1501 2023-02-09 10:09:04  
23 23 1455 1640 2023-02-09 10:09:04  
24 24 1476 111 2023-02-09 10:09:04  
25 25 1476 1640 2023-02-09 10:09:04  
26 26 1507 1640 2023-02-09 10:09:04  
27 27 1567 159 2023-02-09 10:09:04  
28 28 1567 1640 2023-02-09 10:09:04  
29 29 1588 199 2023-02-09 10:09:04  
30 30 1588 1640 2023-02-09 10:09:04  
31 31 1670 7 2023-02-09 10:09:04  
32 32 1670 1501 2023-02-09 10:09:04  
33 33 1670 1640 2023-02-09 10:09:04  
34 34 1683 16 2023-02-09 10:09:04  
35 35 1683 1501 2023-02-09 10:09:04  
36 36 1683 1640 2023-02-09 10:09:04  
37 37 1701 1640 2023-10-13 08:51:52  
38 38 2092 279 2023-02-09 10:09:04  
39 39 2092 1512 2023-02-09 10:09:04  
40 40 2092 1640 2023-02-09 10:09:04  
41 41 2231 110 2023-02-09 10:09:04  
42 42 2231 1640 2023-02-09 10:09:04  
43 43 2246 1640 2023-10-12 09:17:22  
44 44 2246 1822 2023-10-12 09:17:22  
45 45 2275 300 2023-02-09 10:09:04  
46 46 2275 1640 2023-02-09 10:09:04  
47 47 2289 295 2023-02-09 10:09:04  
48 48 2289 1640 2023-02-09 10:09:04  
49 49 2400 301 2023-02-09 10:09:04  
50 50 2400 1640 2023-02-09 10:09:04  
51 51 2422 294 2023-02-09 10:09:04  
52 52 2422 1640 2023-02-09 10:09:04  
53 53 2447 1640 2023-10-12 09:15:57  
54 54 2455 1640 2023-02-09 10:09:04  
55 55 2523 244 2023-02-09 10:09:04  
56 56 2523 1510 2023-02-09 10:09:04  
57 57 2523 1640 2023-02-09 10:09:04  
58 58 2589 246 2023-10-12 08:36:07  
59 59 2589 279 2023-10-12 08:36:07  
60 60 2589 1512 2023-10-12 08:36:07  
61 61 2594 239 2023-02-09 10:09:04  
62 62 2594 1640 2023-02-09 10:09:04  
63 63 2605 240 2023-02-09 10:09:04  
64 64 2605 1640 2023-02-09 10:09:04  
65 65 2610 1510 2023-10-12 10:17:58  
66 66 2610 1640 2023-10-12 10:17:58  
67 67 2610 1826 2023-10-12 10:17:58  
68 68 2615 1640 2023-10-12 10:15:34  
69 69 2615 1826 2023-10-12 10:15:34  
70 70 2629 242 2023-02-09 10:09:04  
71 71 2629 1510 2023-02-09 10:09:04  
72 72 2629 1640 2023-02-09 10:09:04  
73 73 2643 243 2023-02-09 10:09:04  
74 74 2643 1510 2023-02-09 10:09:04  
75 75 2643 1640 2023-02-09 10:09:04  
76 76 2681 37 2023-02-09 10:09:04  
77 77 2681 1640 2023-02-09 10:09:04  
78 78 2687 1578 2023-10-12 10:08:26  
79 79 2687 1640 2023-10-12 10:08:26  
80 80 2689 44 2023-02-09 10:09:04  
81 81 2689 1640 2023-02-09 10:09:04  
82 82 2697 39 2023-02-09 10:09:04  
83 83 2697 1640 2023-02-09 10:09:04  
84 84 2756 38 2023-02-09 10:09:04  
85 85 2756 1640 2023-02-09 10:09:04  
86 86 2771 1640 2023-02-09 10:09:04  
87 87 2809 1640 2023-02-09 10:09:04  
88 88 2809 1792 2023-02-09 10:09:04  
89 89 2850 43 2023-02-09 10:09:04  
90 90 2850 1640 2023-02-09 10:09:04  
91 91 2983 15 2023-02-09 10:09:04  
92 92 2983 1501 2023-02-09 10:09:04  
93 93 2983 1640 2023-02-09 10:09:04  
94 94 3000 14 2023-02-09 10:09:04  
95 95 3000 1501 2023-02-09 10:09:04  
96 96 3000 1640 2023-02-09 10:09:04  
97 97 3016 90 2023-02-09 10:09:04  
98 98 3016 1640 2023-02-09 10:09:04  
99 99 3026 88 2023-02-09 10:09:04  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE post_tags(post_id INTEGER, tag_id INTEGER, createdAt TIMESTAMP, updatedAt TIMESTAMP);;