Table: post_stat_latest
Schema
| cid | name | type | notnull | default | pk |
|---|---|---|---|---|---|
| 0 | post_id | INTEGER | 0 | 1 | |
| 1 | views | INTEGER | 1 | 0 | 0 |
| 2 | likes | INTEGER | 1 | 0 | 0 |
| 3 | comments | INTEGER | 1 | 0 | 0 |
| 4 | reposts | INTEGER | 1 | 0 | 0 |
| 5 | collected_at | TEXT | 1 | CURRENT_TIMESTAMP | 0 |
| 6 | sort_by | TEXT | 1 | '' | 0 |
| 7 | sort_value | INTEGER | 1 | 0 | 0 |
| 8 | source_kind | TEXT | 1 | 'LOCAL' | 0 |
| 9 | views_available | INTEGER | 1 | 0 | 0 |
Data
| post_id | views | likes | comments | reposts | collected_at | sort_by | sort_value | source_kind | views_available |
|---|---|---|---|---|---|---|---|---|---|
101 |
11985 |
198 |
40 |
19 |
2026-08-10T09:46:27.138000Z |
play_count |
11985 |
LOCAL |
1 |
102 |
14990 |
218 |
65 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
14990 |
LOCAL |
1 |
103 |
26745 |
259 |
264 |
23 |
2026-08-10T09:46:27.138000Z |
play_count |
26745 |
LOCAL |
1 |
104 |
100800 |
627 |
46 |
37 |
2026-08-10T09:46:27.138000Z |
play_count |
100800 |
LOCAL |
1 |
105 |
57582 |
391 |
80 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
57582 |
LOCAL |
1 |
106 |
227720 |
1569 |
8046 |
110 |
2026-08-10T09:46:27.138000Z |
play_count |
227720 |
LOCAL |
1 |
107 |
11126 |
148 |
34 |
8 |
2026-08-10T09:46:27.138000Z |
play_count |
11126 |
LOCAL |
1 |
108 |
21758 |
271 |
197 |
23 |
2026-08-10T09:46:27.138000Z |
play_count |
21758 |
LOCAL |
1 |
109 |
26976 |
122 |
59 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
26976 |
LOCAL |
1 |
110 |
41423 |
435 |
1259 |
32 |
2026-08-10T09:46:27.138000Z |
play_count |
41423 |
LOCAL |
1 |
111 |
4738 |
173 |
32 |
13 |
2026-08-10T09:46:27.138000Z |
play_count |
4738 |
LOCAL |
1 |
112 |
47897 |
285 |
41 |
22 |
2026-08-10T09:46:27.138000Z |
play_count |
47897 |
LOCAL |
1 |
113 |
13947 |
213 |
68 |
18 |
2026-08-10T09:46:27.138000Z |
play_count |
13947 |
LOCAL |
1 |
114 |
130729 |
1245 |
721 |
120 |
2026-08-10T09:46:27.138000Z |
play_count |
130729 |
LOCAL |
1 |
115 |
38014 |
330 |
428 |
30 |
2026-08-10T09:46:27.138000Z |
play_count |
38014 |
LOCAL |
1 |
116 |
17113 |
135 |
121 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
17113 |
LOCAL |
1 |
117 |
28485 |
132 |
71 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
28485 |
LOCAL |
1 |
118 |
34450 |
337 |
102 |
28 |
2026-08-10T09:46:27.138000Z |
play_count |
34450 |
LOCAL |
1 |
119 |
76792 |
687 |
2353 |
51 |
2026-08-10T09:46:27.138000Z |
play_count |
76792 |
LOCAL |
1 |
120 |
146868 |
1180 |
428 |
165 |
2026-08-10T09:46:27.138000Z |
play_count |
146868 |
LOCAL |
1 |
121 |
8396 |
122 |
122 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
8396 |
LOCAL |
1 |
122 |
30010 |
419 |
1000 |
33 |
2026-08-10T09:46:27.138000Z |
play_count |
30010 |
LOCAL |
1 |
123 |
12673 |
161 |
96 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
12673 |
LOCAL |
1 |
124 |
877550 |
4361 |
5838 |
740 |
2026-08-10T09:46:27.138000Z |
play_count |
877550 |
LOCAL |
1 |
125 |
9565 |
112 |
119 |
12 |
2026-08-10T09:46:27.138000Z |
play_count |
9565 |
LOCAL |
1 |
126 |
14022 |
232 |
44 |
17 |
2026-08-10T09:46:27.138000Z |
play_count |
14022 |
LOCAL |
1 |
127 |
69701 |
558 |
738 |
49 |
2026-08-10T09:46:27.138000Z |
play_count |
69701 |
LOCAL |
1 |
128 |
61036 |
406 |
487 |
55 |
2026-08-10T09:46:27.138000Z |
play_count |
61036 |
LOCAL |
1 |
129 |
32918 |
343 |
192 |
21 |
2026-08-10T09:46:27.138000Z |
play_count |
32918 |
LOCAL |
1 |
130 |
274230 |
996 |
82 |
207 |
2026-08-10T09:46:27.138000Z |
play_count |
274230 |
LOCAL |
1 |
131 |
17034 |
206 |
207 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
17034 |
LOCAL |
1 |
132 |
398820 |
656 |
192 |
48 |
2026-08-10T09:46:27.138000Z |
play_count |
398820 |
LOCAL |
1 |
133 |
157074 |
1166 |
4631 |
119 |
2026-08-10T09:46:27.138000Z |
play_count |
157074 |
LOCAL |
1 |
134 |
6935 |
107 |
26 |
8 |
2026-08-10T09:46:27.138000Z |
play_count |
6935 |
LOCAL |
1 |
135 |
8036 |
164 |
171 |
19 |
2026-08-10T09:46:27.138000Z |
play_count |
8036 |
LOCAL |
1 |
136 |
18972 |
192 |
32 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
18972 |
LOCAL |
1 |
137 |
19217 |
115 |
17 |
5 |
2026-08-10T09:46:27.138000Z |
play_count |
19217 |
LOCAL |
1 |
138 |
14413 |
180 |
66 |
15 |
2026-08-10T09:46:27.138000Z |
play_count |
14413 |
LOCAL |
1 |
139 |
7490 |
164 |
58 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
7490 |
LOCAL |
1 |
140 |
107884 |
942 |
452 |
75 |
2026-08-10T09:46:27.138000Z |
play_count |
107884 |
LOCAL |
1 |
141 |
672293 |
3763 |
5601 |
558 |
2026-08-10T09:46:27.138000Z |
play_count |
672293 |
LOCAL |
1 |
142 |
19866 |
114 |
60 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
19866 |
LOCAL |
1 |
143 |
27396 |
135 |
80 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
27396 |
LOCAL |
1 |
144 |
28107 |
555 |
28 |
24 |
2026-08-10T09:46:27.138000Z |
play_count |
28107 |
LOCAL |
1 |
145 |
148133 |
886 |
752 |
81 |
2026-08-10T09:46:27.138000Z |
play_count |
148133 |
LOCAL |
1 |
146 |
5690 |
123 |
30 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
5690 |
LOCAL |
1 |
147 |
22027 |
403 |
188 |
40 |
2026-08-10T09:46:27.138000Z |
play_count |
22027 |
LOCAL |
1 |
148 |
55201 |
158 |
152 |
12 |
2026-08-10T09:46:27.138000Z |
play_count |
55201 |
LOCAL |
1 |
149 |
6537 |
112 |
41 |
13 |
2026-08-10T09:46:27.138000Z |
play_count |
6537 |
LOCAL |
1 |
150 |
4607 |
152 |
197 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
4607 |
LOCAL |
1 |
151 |
10091 |
180 |
44 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
10091 |
LOCAL |
1 |
152 |
19780 |
229 |
100 |
16 |
2026-08-10T09:46:27.138000Z |
play_count |
19780 |
LOCAL |
1 |
153 |
14557 |
233 |
418 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
14557 |
LOCAL |
1 |
154 |
17626 |
259 |
368 |
16 |
2026-08-10T09:46:27.138000Z |
play_count |
17626 |
LOCAL |
1 |
155 |
12054 |
200 |
202 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
12054 |
LOCAL |
1 |
156 |
8060 |
154 |
131 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
8060 |
LOCAL |
1 |
157 |
32305 |
126 |
82 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
32305 |
LOCAL |
1 |
158 |
8054 |
130 |
40 |
8 |
2026-08-10T09:46:27.138000Z |
play_count |
8054 |
LOCAL |
1 |
159 |
297774 |
1544 |
1633 |
157 |
2026-08-10T09:46:27.138000Z |
play_count |
297774 |
LOCAL |
1 |
160 |
10819 |
184 |
48 |
16 |
2026-08-10T09:46:27.138000Z |
play_count |
10819 |
LOCAL |
1 |
161 |
8876 |
216 |
24 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
8876 |
LOCAL |
1 |
162 |
5724 |
157 |
67 |
8 |
2026-08-10T09:46:27.138000Z |
play_count |
5724 |
LOCAL |
1 |
163 |
12410 |
95 |
112 |
6 |
2026-08-10T09:46:27.138000Z |
play_count |
12410 |
LOCAL |
1 |
164 |
34401 |
316 |
560 |
24 |
2026-08-10T09:46:27.138000Z |
play_count |
34401 |
LOCAL |
1 |
165 |
10457 |
143 |
21 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
10457 |
LOCAL |
1 |
166 |
10959 |
121 |
41 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
10959 |
LOCAL |
1 |
167 |
9053 |
153 |
75 |
8 |
2026-08-10T09:46:27.138000Z |
play_count |
9053 |
LOCAL |
1 |
168 |
57296 |
349 |
150 |
55 |
2026-08-10T09:46:27.138000Z |
play_count |
57296 |
LOCAL |
1 |
169 |
5601 |
120 |
65 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
5601 |
LOCAL |
1 |
170 |
9005 |
163 |
91 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
9005 |
LOCAL |
1 |
171 |
8719 |
158 |
22 |
8 |
2026-08-10T09:46:27.138000Z |
play_count |
8719 |
LOCAL |
1 |
172 |
15159 |
141 |
52 |
6 |
2026-08-10T09:46:27.138000Z |
play_count |
15159 |
LOCAL |
1 |
173 |
11101 |
123 |
54 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
11101 |
LOCAL |
1 |
174 |
24869 |
359 |
122 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
24869 |
LOCAL |
1 |
175 |
8492 |
133 |
88 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
8492 |
LOCAL |
1 |
176 |
30026 |
116 |
110 |
8 |
2026-08-10T09:46:27.138000Z |
play_count |
30026 |
LOCAL |
1 |
177 |
17074 |
124 |
80 |
6 |
2026-08-10T09:46:27.138000Z |
play_count |
17074 |
LOCAL |
1 |
178 |
20519 |
212 |
102 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
20519 |
LOCAL |
1 |
179 |
175049 |
650 |
55 |
22 |
2026-08-10T09:46:27.138000Z |
play_count |
175049 |
LOCAL |
1 |
180 |
9818 |
169 |
130 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
9818 |
LOCAL |
1 |
181 |
8373 |
196 |
81 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
8373 |
LOCAL |
1 |
182 |
244778 |
284 |
68 |
18 |
2026-08-10T09:46:27.138000Z |
play_count |
244778 |
LOCAL |
1 |
183 |
44776 |
275 |
562 |
17 |
2026-08-10T09:46:27.138000Z |
play_count |
44776 |
LOCAL |
1 |
184 |
7506 |
134 |
42 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
7506 |
LOCAL |
1 |
185 |
368700 |
466 |
147 |
12 |
2026-08-10T09:46:27.138000Z |
play_count |
368700 |
LOCAL |
1 |
186 |
25053 |
276 |
435 |
13 |
2026-08-10T09:46:27.138000Z |
play_count |
25053 |
LOCAL |
1 |
187 |
47278 |
172 |
110 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
47278 |
LOCAL |
1 |
188 |
14528 |
195 |
36 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
14528 |
LOCAL |
1 |
189 |
5989 |
114 |
27 |
5 |
2026-08-10T09:46:27.138000Z |
play_count |
5989 |
LOCAL |
1 |
190 |
42854 |
314 |
472 |
16 |
2026-08-10T09:46:27.138000Z |
play_count |
42854 |
LOCAL |
1 |
191 |
12922 |
258 |
46 |
16 |
2026-08-10T09:46:27.138000Z |
play_count |
12922 |
LOCAL |
1 |
192 |
6454 |
166 |
39 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
6454 |
LOCAL |
1 |
193 |
25719 |
225 |
79 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
25719 |
LOCAL |
1 |
194 |
29830 |
373 |
230 |
22 |
2026-08-10T09:46:27.138000Z |
play_count |
29830 |
LOCAL |
1 |
195 |
54577 |
652 |
799 |
45 |
2026-08-10T09:46:27.138000Z |
play_count |
54577 |
LOCAL |
1 |
196 |
20576 |
124 |
34 |
4 |
2026-08-10T09:46:27.138000Z |
play_count |
20576 |
LOCAL |
1 |
197 |
37782 |
132 |
39 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
37782 |
LOCAL |
1 |
198 |
25677 |
135 |
18 |
6 |
2026-08-10T09:46:27.138000Z |
play_count |
25677 |
LOCAL |
1 |
199 |
14782 |
281 |
139 |
5 |
2026-08-10T09:46:27.138000Z |
play_count |
14782 |
LOCAL |
1 |
200 |
6147 |
148 |
88 |
6 |
2026-08-10T09:46:27.138000Z |
play_count |
6147 |
LOCAL |
1 |