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 |
|---|---|---|---|---|---|---|---|---|---|
201 |
721908 |
1925 |
480 |
78 |
2026-08-10T09:46:27.138000Z |
play_count |
721908 |
LOCAL |
1 |
202 |
9971 |
165 |
43 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
9971 |
LOCAL |
1 |
203 |
20670 |
179 |
69 |
6 |
2026-08-10T09:46:27.138000Z |
play_count |
20670 |
LOCAL |
1 |
204 |
8154 |
154 |
38 |
6 |
2026-08-10T09:46:27.138000Z |
play_count |
8154 |
LOCAL |
1 |
205 |
16688 |
136 |
24 |
5 |
2026-08-10T09:46:27.138000Z |
play_count |
16688 |
LOCAL |
1 |
206 |
5017 |
158 |
44 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
5017 |
LOCAL |
1 |
207 |
20443 |
206 |
76 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
20443 |
LOCAL |
1 |
208 |
10443 |
118 |
33 |
4 |
2026-08-10T09:46:27.138000Z |
play_count |
10443 |
LOCAL |
1 |
209 |
7600 |
191 |
136 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
7600 |
LOCAL |
1 |
210 |
9210 |
203 |
185 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
9210 |
LOCAL |
1 |
211 |
5211 |
166 |
100 |
6 |
2026-08-10T09:46:27.138000Z |
play_count |
5211 |
LOCAL |
1 |
212 |
6025 |
216 |
30 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
6025 |
LOCAL |
1 |
213 |
17648 |
364 |
589 |
20 |
2026-08-10T09:46:27.138000Z |
play_count |
17648 |
LOCAL |
1 |
214 |
5246 |
146 |
53 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
5246 |
LOCAL |
1 |
215 |
24953 |
297 |
387 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
24953 |
LOCAL |
1 |
216 |
8669 |
162 |
88 |
12 |
2026-08-10T09:46:27.138000Z |
play_count |
8669 |
LOCAL |
1 |
217 |
32293 |
371 |
613 |
12 |
2026-08-10T09:46:27.138000Z |
play_count |
32293 |
LOCAL |
1 |
218 |
5661 |
172 |
33 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
5661 |
LOCAL |
1 |
219 |
5655 |
152 |
42 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
5655 |
LOCAL |
1 |
220 |
8231 |
162 |
67 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
8231 |
LOCAL |
1 |
221 |
10827 |
94 |
34 |
3 |
2026-08-10T09:46:27.138000Z |
play_count |
10827 |
LOCAL |
1 |
222 |
63520 |
864 |
113 |
19 |
2026-08-10T09:46:27.138000Z |
play_count |
63520 |
LOCAL |
1 |
223 |
70657 |
913 |
353 |
62 |
2026-08-10T09:46:27.138000Z |
play_count |
70657 |
LOCAL |
1 |
224 |
13257 |
223 |
148 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
13257 |
LOCAL |
1 |
225 |
12070 |
202 |
116 |
5 |
2026-08-10T09:46:27.138000Z |
play_count |
12070 |
LOCAL |
1 |
226 |
11317 |
87 |
39 |
5 |
2026-08-10T09:46:27.138000Z |
play_count |
11317 |
LOCAL |
1 |
227 |
20864 |
140 |
34 |
2 |
2026-08-10T09:46:27.138000Z |
play_count |
20864 |
LOCAL |
1 |
228 |
176562 |
645 |
142 |
34 |
2026-08-10T09:46:27.138000Z |
play_count |
176562 |
LOCAL |
1 |
232 |
74665 |
1596 |
6508 |
41 |
2026-08-10T15:06:48.547000Z |
play_count |
1596 |
LOCAL |
1 |
233 |
34764 |
309 |
205 |
16 |
2026-08-10T09:47:35.587000Z |
play_count |
34764 |
LOCAL |
1 |
234 |
1733083 |
30403 |
248 |
418 |
2026-08-10T09:47:35.587000Z |
play_count |
1733083 |
LOCAL |
1 |
235 |
176071 |
1010 |
1343 |
167 |
2026-08-10T09:47:35.587000Z |
play_count |
176071 |
LOCAL |
1 |
236 |
3576244 |
49815 |
291 |
565 |
2026-08-10T09:47:35.587000Z |
play_count |
3576244 |
LOCAL |
1 |
237 |
0 |
46666 |
464 |
758 |
2026-08-10T09:48:25.544000Z |
play_count |
46666 |
LOCAL |
0 |
238 |
0 |
887 |
494 |
51 |
2026-08-10T09:48:30.348000Z |
play_count |
887 |
LOCAL |
0 |
280 |
0 |
72 |
0 |
0 |
2026-08-10T15:06:36.305000Z |
play_count |
72 |
LOCAL |
0 |
281 |
0 |
3 |
11 |
0 |
2026-08-10T15:06:36.305000Z |
play_count |
3 |
LOCAL |
0 |
282 |
102944 |
621 |
3090 |
47 |
2026-08-10T15:06:58.254000Z |
play_count |
102944 |
LOCAL |
1 |
283 |
0 |
2651 |
7999 |
452 |
2026-08-10T15:06:44.075000Z |
play_count |
2651 |
LOCAL |
0 |
284 |
0 |
5440 |
10996 |
1189 |
2026-08-10T15:06:48.547000Z |
play_count |
5440 |
LOCAL |
0 |
286 |
193367 |
1844 |
1516 |
251 |
2026-08-10T15:09:40.488000Z |
play_count |
193367 |
LOCAL |
1 |
287 |
0 |
9951 |
1352 |
1391 |
2026-08-10T15:06:48.547000Z |
play_count |
9951 |
LOCAL |
0 |
288 |
0 |
64 |
8 |
4 |
2026-08-10T15:06:48.547000Z |
play_count |
64 |
LOCAL |
0 |
289 |
0 |
926 |
1522 |
97 |
2026-08-10T15:06:48.547000Z |
play_count |
926 |
LOCAL |
0 |
290 |
48915194 |
1609428 |
1697 |
33526 |
2026-08-16T12:03:28.838000Z |
play_count |
48915194 |
LOCAL |
1 |
291 |
110688 |
1102 |
419 |
20 |
2026-08-14T07:02:44.707000Z |
play_count |
110688 |
LOCAL |
1 |
292 |
633193 |
15047 |
25 |
221 |
2026-08-16T13:42:47.786000Z |
play_count |
633193 |
LOCAL |
1 |
293 |
16341 |
84 |
3 |
4 |
2026-08-11T13:11:06.980000Z |
play_count |
16341 |
LOCAL |
1 |
294 |
2510308 |
26967 |
530 |
284 |
2026-08-16T13:49:41.254000Z |
play_count |
2510308 |
LOCAL |
1 |
295 |
0 |
3 |
0 |
0 |
2026-08-10T15:06:50.897000Z |
play_count |
3 |
LOCAL |
0 |
296 |
32981978 |
393780 |
360 |
5665 |
2026-08-10T15:06:50.897000Z |
play_count |
32981978 |
LOCAL |
1 |
297 |
2293 |
3 |
2 |
0 |
2026-08-10T15:06:50.897000Z |
play_count |
2293 |
LOCAL |
1 |
298 |
441260279 |
6601477 |
15644 |
87886 |
2026-08-12T13:47:37.115000Z |
play_count |
441260279 |
LOCAL |
1 |
299 |
1554747 |
12035 |
13 |
189 |
2026-08-12T13:55:25.749000Z |
play_count |
1554747 |
LOCAL |
1 |
300 |
2190 |
527 |
7 |
0 |
2026-08-12T13:55:25.749000Z |
play_count |
2190 |
LOCAL |
1 |
301 |
1038472 |
30287 |
479 |
1099 |
2026-08-12T09:14:59Z |
play_count |
1038472 |
SERVER |
1 |
302 |
309316737 |
5781694 |
64076 |
103534 |
2026-08-15T04:39:41.904000Z |
play_count |
309316737 |
LOCAL |
1 |
303 |
811118 |
14539 |
192 |
338 |
2026-08-15T04:41:59.380000Z |
play_count |
811118 |
LOCAL |
1 |
304 |
47143537 |
550797 |
503 |
13189 |
2026-08-16T13:09:52.579000Z |
play_count |
47143537 |
LOCAL |
1 |
305 |
63430672 |
492806 |
2321 |
7041 |
2026-08-12T13:57:35.663000Z |
play_count |
63430672 |
LOCAL |
1 |
306 |
1875724 |
12642 |
144 |
281 |
2026-08-16T13:10:03.639000Z |
play_count |
1875724 |
LOCAL |
1 |
307 |
1906520 |
31399 |
141 |
488 |
2026-08-15T04:40:07.790000Z |
play_count |
1906520 |
LOCAL |
1 |
308 |
8141936 |
260411 |
225 |
5836 |
2026-08-16T13:49:41.254000Z |
play_count |
8141936 |
LOCAL |
1 |
309 |
1697 |
491 |
13 |
0 |
2026-08-12T09:14:18.405000Z |
play_count |
1697 |
LOCAL |
1 |
313 |
602143 |
6349 |
8060 |
1201 |
2026-08-12T03:19:27.971000Z |
play_count |
602143 |
LOCAL |
1 |
314 |
13237 |
58 |
72 |
7 |
2026-08-10T15:09:38.779000Z |
play_count |
13237 |
LOCAL |
1 |
315 |
25993 |
257 |
468 |
10 |
2026-08-10T15:09:38.779000Z |
play_count |
25993 |
LOCAL |
1 |
316 |
22626 |
283 |
778 |
14 |
2026-08-10T15:09:38.779000Z |
play_count |
22626 |
LOCAL |
1 |
317 |
436738 |
4760 |
2867 |
670 |
2026-08-10T15:09:40.488000Z |
play_count |
436738 |
LOCAL |
1 |
319 |
13670 |
121 |
123 |
9 |
2026-08-10T15:09:40.488000Z |
play_count |
13670 |
LOCAL |
1 |
320 |
16385 |
138 |
136 |
10 |
2026-08-10T15:09:40.488000Z |
play_count |
16385 |
LOCAL |
1 |
321 |
6250 |
44 |
46 |
1 |
2026-08-10T15:09:40.488000Z |
play_count |
6250 |
LOCAL |
1 |
322 |
7185 |
66 |
194 |
2 |
2026-08-10T15:09:40.488000Z |
play_count |
7185 |
LOCAL |
1 |
323 |
0 |
870 |
18 |
65 |
2026-08-11T12:19:16Z |
play_count |
870 |
SERVER |
0 |
324 |
0 |
12579 |
552 |
1034 |
2026-08-11T09:45:33.256000Z |
play_count |
12579 |
LOCAL |
0 |
325 |
0 |
542 |
2035 |
37 |
2026-08-11T09:45:33.256000Z |
play_count |
542 |
LOCAL |
0 |
330 |
0 |
322 |
15 |
10 |
2026-08-11T12:19:16Z |
play_count |
322 |
SERVER |
0 |
331 |
0 |
319 |
11 |
9 |
2026-08-11T09:45:36.661000Z |
play_count |
319 |
LOCAL |
0 |
332 |
0 |
161 |
9 |
2 |
2026-08-11T09:45:36.661000Z |
play_count |
161 |
LOCAL |
0 |
333 |
5554 |
161 |
7 |
8 |
2026-08-11T12:19:16Z |
play_count |
5554 |
SERVER |
1 |
334 |
0 |
641 |
19 |
32 |
2026-08-11T12:19:16Z |
play_count |
641 |
SERVER |
0 |
335 |
0 |
1332 |
67 |
49 |
2026-08-11T12:19:16Z |
play_count |
1332 |
SERVER |
0 |
336 |
0 |
5283 |
152 |
441 |
2026-08-11T12:19:16Z |
play_count |
5283 |
SERVER |
0 |
337 |
0 |
770 |
29 |
30 |
2026-08-11T09:45:36.661000Z |
play_count |
770 |
LOCAL |
0 |
338 |
0 |
652 |
22 |
24 |
2026-08-11T09:45:36.661000Z |
play_count |
652 |
LOCAL |
0 |
339 |
0 |
525 |
18 |
25 |
2026-08-11T09:45:36.661000Z |
play_count |
525 |
LOCAL |
0 |
340 |
0 |
2106 |
62 |
79 |
2026-08-11T12:19:16Z |
play_count |
2106 |
SERVER |
0 |
353 |
0 |
2333 |
40 |
130 |
2026-08-11T09:45:43.954000Z |
play_count |
2333 |
LOCAL |
0 |
354 |
0 |
2242 |
83 |
175 |
2026-08-11T09:45:43.954000Z |
play_count |
2242 |
LOCAL |
0 |
355 |
0 |
2662 |
148 |
232 |
2026-08-11T12:19:16Z |
play_count |
2662 |
SERVER |
0 |
356 |
28900 |
2713 |
61 |
145 |
2026-08-11T12:19:16Z |
play_count |
28900 |
SERVER |
1 |
357 |
0 |
711 |
28 |
29 |
2026-08-11T09:45:43.954000Z |
play_count |
711 |
LOCAL |
0 |
358 |
0 |
1039 |
65 |
57 |
2026-08-11T09:45:43.954000Z |
play_count |
1039 |
LOCAL |
0 |
359 |
7153 |
70 |
0 |
1 |
2026-08-11T09:45:43.954000Z |
play_count |
7153 |
LOCAL |
1 |
360 |
0 |
192 |
5 |
0 |
2026-08-11T09:45:43.954000Z |
play_count |
192 |
LOCAL |
0 |
361 |
0 |
382 |
7 |
7 |
2026-08-11T09:45:43.954000Z |
play_count |
382 |
LOCAL |
0 |
362 |
8133 |
63 |
0 |
2 |
2026-08-11T09:45:43.954000Z |
play_count |
8133 |
LOCAL |
1 |
363 |
0 |
195 |
7 |
2 |
2026-08-11T09:45:43.954000Z |
play_count |
195 |
LOCAL |
0 |
364 |
0 |
122 |
0 |
1 |
2026-08-11T09:45:43.954000Z |
play_count |
122 |
LOCAL |
0 |
377 |
0 |
138 |
2 |
1 |
2026-08-11T09:45:51.718000Z |
play_count |
138 |
LOCAL |
0 |