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 |
|---|---|---|---|---|---|---|---|---|---|
3561 |
48284 |
171 |
15 |
1 |
2026-08-16T12:30:25.120000Z |
play_count |
48284 |
LOCAL |
1 |
3562 |
117155 |
638 |
473 |
39 |
2026-08-16T12:30:25.120000Z |
play_count |
117155 |
LOCAL |
1 |
3563 |
335664 |
1066 |
4 |
43 |
2026-08-16T12:30:25.120000Z |
play_count |
335664 |
LOCAL |
1 |
3565 |
109654 |
409 |
9 |
16 |
2026-08-16T12:30:25.120000Z |
play_count |
109654 |
LOCAL |
1 |
3566 |
795194 |
2716 |
17 |
24 |
2026-08-16T12:30:25.120000Z |
play_count |
795194 |
LOCAL |
1 |
3567 |
320486 |
1217 |
16 |
9 |
2026-08-16T12:30:25.120000Z |
play_count |
320486 |
LOCAL |
1 |
3568 |
1573137 |
16125 |
34 |
116 |
2026-08-16T12:30:25.120000Z |
play_count |
1573137 |
LOCAL |
1 |
3569 |
787699 |
7657 |
50 |
61 |
2026-08-16T12:30:25.120000Z |
play_count |
787699 |
LOCAL |
1 |
3570 |
87093 |
289 |
18 |
19 |
2026-08-16T12:30:25.120000Z |
play_count |
87093 |
LOCAL |
1 |
3571 |
529833 |
2316 |
25 |
27 |
2026-08-16T12:30:25.120000Z |
play_count |
529833 |
LOCAL |
1 |
3608 |
224578 |
2311 |
141 |
149 |
2026-08-16T13:09:49.541000Z |
play_count |
224578 |
LOCAL |
1 |
3613 |
81064 |
197 |
1413 |
18 |
2026-08-16T13:09:49.541000Z |
play_count |
81064 |
LOCAL |
1 |
3621 |
19370854 |
293811 |
3061 |
8503 |
2026-08-16T13:09:52.579000Z |
play_count |
19370854 |
LOCAL |
1 |
3627 |
11139254 |
1083196 |
19541 |
14771 |
2026-08-16T13:09:52.579000Z |
play_count |
11139254 |
LOCAL |
1 |
3631 |
1209513 |
72434 |
1234 |
2104 |
2026-08-16T13:09:52.579000Z |
play_count |
1209513 |
LOCAL |
1 |
3636 |
9714311 |
509919 |
4000 |
9803 |
2026-08-16T13:09:52.579000Z |
play_count |
9714311 |
LOCAL |
1 |
3638 |
13420194 |
177339 |
523 |
9371 |
2026-08-16T13:09:52.579000Z |
play_count |
13420194 |
LOCAL |
1 |
3639 |
20892621 |
519081 |
1226 |
12705 |
2026-08-16T13:09:52.579000Z |
play_count |
20892621 |
LOCAL |
1 |
3641 |
17294019 |
53327 |
274 |
1474 |
2026-08-16T13:09:52.579000Z |
play_count |
17294019 |
LOCAL |
1 |
3644 |
9158768 |
52052 |
371 |
2200 |
2026-08-16T13:09:52.579000Z |
play_count |
9158768 |
LOCAL |
1 |
3646 |
82787328 |
386823 |
1843 |
10563 |
2026-08-16T13:10:03.639000Z |
play_count |
82787328 |
LOCAL |
1 |
3647 |
1693480 |
7336 |
279 |
143 |
2026-08-16T13:10:03.639000Z |
play_count |
1693480 |
LOCAL |
1 |
3649 |
120202315 |
1716045 |
2483 |
21829 |
2026-08-16T13:10:03.639000Z |
play_count |
120202315 |
LOCAL |
1 |
3650 |
244458784 |
1472476 |
3785 |
45228 |
2026-08-16T13:10:03.639000Z |
play_count |
244458784 |
LOCAL |
1 |
3654 |
1162728 |
121453 |
2560 |
2267 |
2026-08-16T13:10:03.639000Z |
play_count |
1162728 |
LOCAL |
1 |
3655 |
6993772 |
89591 |
505 |
747 |
2026-08-16T13:10:03.639000Z |
play_count |
6993772 |
LOCAL |
1 |
3656 |
41733773 |
209033 |
3972 |
13537 |
2026-08-16T13:10:03.639000Z |
play_count |
41733773 |
LOCAL |
1 |
3658 |
4995648 |
14273 |
306 |
285 |
2026-08-16T13:10:03.639000Z |
play_count |
4995648 |
LOCAL |
1 |
3659 |
2119325 |
205933 |
1545 |
5088 |
2026-08-16T13:10:03.639000Z |
play_count |
2119325 |
LOCAL |
1 |
3660 |
17838252 |
63144 |
293 |
5395 |
2026-08-16T13:10:03.639000Z |
play_count |
17838252 |
LOCAL |
1 |
3662 |
5219931 |
289998 |
3514 |
5201 |
2026-08-16T13:10:03.639000Z |
play_count |
5219931 |
LOCAL |
1 |
3664 |
97481731 |
1820576 |
8675 |
36762 |
2026-08-16T13:10:03.639000Z |
play_count |
97481731 |
LOCAL |
1 |
3666 |
70820 |
454 |
40 |
4 |
2026-08-16T13:10:11.796000Z |
play_count |
70820 |
LOCAL |
1 |
3667 |
0 |
172 |
11 |
5 |
2026-08-16T13:10:11.796000Z |
play_count |
183 |
LOCAL |
0 |
3668 |
57044 |
289 |
5 |
3 |
2026-08-16T13:10:11.796000Z |
play_count |
57044 |
LOCAL |
1 |
3669 |
0 |
295 |
0 |
2 |
2026-08-16T13:10:11.796000Z |
play_count |
295 |
LOCAL |
0 |
3671 |
83073 |
1351 |
3 |
50 |
2026-08-16T13:10:11.796000Z |
play_count |
83073 |
LOCAL |
1 |
3672 |
0 |
131 |
0 |
1 |
2026-08-16T13:10:11.796000Z |
play_count |
131 |
LOCAL |
0 |
3673 |
0 |
188 |
2 |
2 |
2026-08-16T13:10:11.796000Z |
play_count |
190 |
LOCAL |
0 |
3674 |
0 |
99 |
1 |
0 |
2026-08-16T13:10:11.796000Z |
play_count |
100 |
LOCAL |
0 |
3675 |
0 |
70 |
0 |
1 |
2026-08-16T13:10:11.796000Z |
play_count |
70 |
LOCAL |
0 |
3676 |
220499 |
1461 |
40 |
39 |
2026-08-16T13:10:11.796000Z |
play_count |
220499 |
LOCAL |
1 |
3678 |
0 |
61 |
0 |
1 |
2026-08-16T13:10:11.796000Z |
play_count |
61 |
LOCAL |
0 |
3679 |
0 |
213 |
0 |
4 |
2026-08-16T13:10:13.607000Z |
play_count |
213 |
LOCAL |
0 |
3680 |
220878 |
1836 |
10 |
33 |
2026-08-16T13:10:18.899000Z |
play_count |
220878 |
LOCAL |
1 |
3681 |
0 |
185 |
0 |
4 |
2026-08-16T13:10:13.607000Z |
play_count |
185 |
LOCAL |
0 |
3682 |
0 |
56 |
1 |
1 |
2026-08-16T13:10:13.607000Z |
play_count |
57 |
LOCAL |
0 |
3683 |
213765 |
1361 |
8 |
39 |
2026-08-16T13:10:18.899000Z |
play_count |
213765 |
LOCAL |
1 |
3684 |
0 |
85 |
1 |
1 |
2026-08-16T13:10:13.607000Z |
play_count |
86 |
LOCAL |
0 |
3685 |
0 |
29 |
0 |
1 |
2026-08-16T13:10:13.607000Z |
play_count |
29 |
LOCAL |
0 |
3686 |
485809 |
5272 |
23 |
164 |
2026-08-16T13:10:17.126000Z |
play_count |
485809 |
LOCAL |
1 |
3687 |
0 |
19 |
0 |
0 |
2026-08-16T13:10:13.607000Z |
play_count |
19 |
LOCAL |
0 |
3688 |
0 |
86 |
0 |
0 |
2026-08-16T13:10:13.607000Z |
play_count |
86 |
LOCAL |
0 |
3690 |
155036 |
1434 |
4 |
43 |
2026-08-16T13:10:18.899000Z |
play_count |
155036 |
LOCAL |
1 |
3691 |
0 |
90 |
0 |
2 |
2026-08-16T13:10:13.607000Z |
play_count |
90 |
LOCAL |
0 |
3693 |
632646 |
6416 |
22 |
43 |
2026-08-16T13:10:23.017000Z |
play_count |
632646 |
LOCAL |
1 |
3694 |
422854 |
2490 |
17 |
51 |
2026-08-16T13:10:18.899000Z |
play_count |
422854 |
LOCAL |
1 |
3695 |
103480169 |
2041827 |
2016 |
137 |
2026-08-16T13:10:18.899000Z |
play_count |
103480169 |
LOCAL |
1 |
3703 |
229310 |
1241 |
12 |
31 |
2026-08-16T13:10:18.899000Z |
play_count |
229310 |
LOCAL |
1 |
3704 |
153573 |
877 |
4 |
30 |
2026-08-16T13:10:18.899000Z |
play_count |
153573 |
LOCAL |
1 |
3706 |
152789 |
1154 |
2 |
30 |
2026-08-16T13:10:18.899000Z |
play_count |
152789 |
LOCAL |
1 |
3707 |
142236 |
830 |
7 |
31 |
2026-08-16T13:10:18.899000Z |
play_count |
142236 |
LOCAL |
1 |
3708 |
102885 |
339 |
2 |
12 |
2026-08-16T13:10:18.899000Z |
play_count |
102885 |
LOCAL |
1 |
3709 |
112754 |
732 |
5 |
22 |
2026-08-16T13:10:18.899000Z |
play_count |
112754 |
LOCAL |
1 |
3710 |
93422 |
440 |
2 |
11 |
2026-08-16T13:10:18.899000Z |
play_count |
93422 |
LOCAL |
1 |
3711 |
86265 |
540 |
4 |
19 |
2026-08-16T13:10:18.899000Z |
play_count |
86265 |
LOCAL |
1 |
3712 |
72451 |
249 |
0 |
9 |
2026-08-16T13:10:18.899000Z |
play_count |
72451 |
LOCAL |
1 |
3714 |
71069 |
304 |
2 |
6 |
2026-08-16T13:10:18.899000Z |
play_count |
71069 |
LOCAL |
1 |
3715 |
64116 |
303 |
0 |
8 |
2026-08-16T13:10:18.899000Z |
play_count |
64116 |
LOCAL |
1 |
3732 |
85854 |
457 |
2319 |
27 |
2026-08-16T13:11:13Z |
play_count |
85854 |
LOCAL |
1 |
3734 |
7135 |
10 |
52 |
1 |
2026-08-16T13:12:25.253000Z |
play_count |
7135 |
LOCAL |
1 |
3735 |
0 |
820 |
1803 |
60 |
2026-08-16T13:10:53.699000Z |
play_count |
2623 |
LOCAL |
0 |
3737 |
0 |
186805 |
792 |
4783 |
2026-08-16T13:10:53.699000Z |
play_count |
187597 |
LOCAL |
0 |
3738 |
0 |
41407 |
234 |
2134 |
2026-08-16T13:10:53.699000Z |
play_count |
41641 |
LOCAL |
0 |
3739 |
0 |
1 |
2 |
0 |
2026-08-16T13:10:53.699000Z |
play_count |
3 |
LOCAL |
0 |
3740 |
1125 |
4 |
0 |
1 |
2026-08-16T13:42:44.852000Z |
play_count |
1125 |
LOCAL |
1 |
3794 |
61621 |
532 |
2653 |
33 |
2026-08-16T13:42:42.920000Z |
play_count |
61621 |
LOCAL |
1 |
3799 |
1458 |
11 |
17 |
3 |
2026-08-16T13:42:44.852000Z |
play_count |
1458 |
LOCAL |
1 |
3800 |
0 |
187065 |
3454 |
4451 |
2026-08-16T13:42:44.852000Z |
play_count |
190519 |
LOCAL |
0 |
3801 |
3515 |
42 |
4 |
1 |
2026-08-16T13:42:44.852000Z |
play_count |
3515 |
LOCAL |
1 |
3804 |
0 |
74 |
453 |
3 |
2026-08-16T13:42:44.852000Z |
play_count |
527 |
LOCAL |
0 |
3809 |
433867 |
9142 |
96 |
192 |
2026-08-16T13:42:47.786000Z |
play_count |
433867 |
LOCAL |
1 |
3814 |
4217900 |
29253 |
75 |
941 |
2026-08-16T13:42:47.786000Z |
play_count |
4217900 |
LOCAL |
1 |
3815 |
534906 |
19632 |
132 |
446 |
2026-08-16T13:42:47.786000Z |
play_count |
534906 |
LOCAL |
1 |
3819 |
11665207 |
178491 |
29643 |
2536 |
2026-08-16T13:42:47.786000Z |
play_count |
11665207 |
LOCAL |
1 |
3820 |
154311278 |
27595988 |
80064 |
447690 |
2026-08-16T13:42:47.786000Z |
play_count |
154311278 |
LOCAL |
1 |
3821 |
1508915 |
36568 |
162 |
352 |
2026-08-16T13:42:47.786000Z |
play_count |
1508915 |
LOCAL |
1 |
3822 |
224 |
0 |
0 |
0 |
2026-08-16T13:42:54.989000Z |
play_count |
224 |
LOCAL |
1 |
3823 |
2052937 |
32614 |
112 |
590 |
2026-08-16T13:42:47.786000Z |
play_count |
2052937 |
LOCAL |
1 |
3824 |
2922410 |
6712 |
22 |
428 |
2026-08-16T13:42:47.786000Z |
play_count |
2922410 |
LOCAL |
1 |
3826 |
213 |
1 |
4 |
0 |
2026-08-16T13:42:54.989000Z |
play_count |
213 |
LOCAL |
1 |
3827 |
356 |
2 |
1 |
0 |
2026-08-16T13:42:54.989000Z |
play_count |
356 |
LOCAL |
1 |
3828 |
253 |
2 |
1 |
0 |
2026-08-16T13:42:54.989000Z |
play_count |
253 |
LOCAL |
1 |
3829 |
2309 |
4 |
3 |
0 |
2026-08-16T13:42:54.989000Z |
play_count |
2309 |
LOCAL |
1 |
3830 |
1976 |
3 |
11 |
0 |
2026-08-16T13:42:54.989000Z |
play_count |
1976 |
LOCAL |
1 |
3833 |
294 |
1 |
1 |
0 |
2026-08-16T13:42:54.989000Z |
play_count |
294 |
LOCAL |
1 |
3835 |
314 |
2 |
5 |
0 |
2026-08-16T13:42:54.989000Z |
play_count |
314 |
LOCAL |
1 |
3837 |
385 |
3 |
9 |
0 |
2026-08-16T13:42:57.840000Z |
play_count |
385 |
LOCAL |
1 |
3838 |
401 |
4 |
3 |
0 |
2026-08-16T13:42:54.989000Z |
play_count |
401 |
LOCAL |
1 |
3839 |
287 |
4 |
6 |
1 |
2026-08-16T13:42:54.989000Z |
play_count |
287 |
LOCAL |
1 |