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 |
|---|---|---|---|---|---|---|---|---|---|
664 |
22776283 |
390035 |
0 |
3809 |
2026-08-11T14:10:25.067000Z |
play_count |
22776283 |
LOCAL |
1 |
665 |
85004 |
817 |
0 |
15 |
2026-08-11T14:10:40Z |
play_count |
85004 |
SERVER |
1 |
666 |
10010198 |
43124 |
161 |
754 |
2026-08-16T13:42:47.786000Z |
play_count |
10010198 |
LOCAL |
1 |
667 |
40213720 |
1228128 |
0 |
61436 |
2026-08-11T14:10:25.067000Z |
play_count |
40213720 |
LOCAL |
1 |
668 |
2173566 |
25366 |
0 |
291 |
2026-08-11T14:10:40Z |
play_count |
2173566 |
SERVER |
1 |
670 |
1798023 |
21757 |
3728 |
219 |
2026-08-12T13:57:20.120000Z |
play_count |
1798023 |
LOCAL |
1 |
671 |
16379848 |
130399 |
195 |
4767 |
2026-08-11T15:10:27.241000Z |
play_count |
16379848 |
LOCAL |
1 |
672 |
8141071 |
37482 |
2313 |
0 |
2026-08-15T04:39:41.904000Z |
play_count |
8141071 |
LOCAL |
1 |
673 |
8656676 |
108645 |
0 |
2202 |
2026-08-11T14:10:25.067000Z |
play_count |
8656676 |
LOCAL |
1 |
687 |
0 |
3 |
0 |
0 |
2026-08-11T14:10:40.629000Z |
play_count |
0 |
LOCAL |
0 |
690 |
0 |
39 |
0 |
1 |
2026-08-11T14:10:40.629000Z |
play_count |
0 |
LOCAL |
0 |
697 |
951222 |
7463 |
121 |
84 |
2026-08-12T22:29:54.255000Z |
play_count |
951222 |
LOCAL |
1 |
698 |
7470676 |
142680 |
0 |
1779 |
2026-08-11T14:10:40.629000Z |
play_count |
7470676 |
LOCAL |
1 |
699 |
571998 |
21185 |
0 |
389 |
2026-08-11T14:10:40.629000Z |
play_count |
571998 |
LOCAL |
1 |
701 |
206325 |
1158 |
0 |
45 |
2026-08-11T14:10:40.629000Z |
play_count |
206325 |
LOCAL |
1 |
702 |
12076618 |
18507 |
0 |
593 |
2026-08-11T14:10:40.629000Z |
play_count |
12076618 |
LOCAL |
1 |
704 |
1017796 |
15605 |
339 |
233 |
2026-08-12T01:48:23.204000Z |
play_count |
1017796 |
LOCAL |
1 |
705 |
10145950 |
780447 |
0 |
13695 |
2026-08-11T14:10:40.629000Z |
play_count |
10145950 |
LOCAL |
1 |
706 |
43672338 |
555875 |
0 |
8841 |
2026-08-11T14:10:40.629000Z |
play_count |
43672338 |
LOCAL |
1 |
708 |
3646490 |
79842 |
1634 |
1393 |
2026-08-12T13:57:20.120000Z |
play_count |
3646490 |
LOCAL |
1 |
709 |
8977354 |
213067 |
3256 |
4510 |
2026-08-14T07:02:44.707000Z |
play_count |
8977354 |
LOCAL |
1 |
710 |
9620628 |
114174 |
282 |
1342 |
2026-08-12T01:48:06.401000Z |
play_count |
9620628 |
LOCAL |
1 |
711 |
1640232 |
61263 |
899 |
1256 |
2026-08-12T23:05:25.596000Z |
play_count |
1640232 |
LOCAL |
1 |
712 |
68601104 |
543960 |
856 |
9347 |
2026-08-16T13:49:41.254000Z |
play_count |
68601104 |
LOCAL |
1 |
714 |
2402004 |
29184 |
151 |
586 |
2026-08-15T04:39:58.933000Z |
play_count |
2402004 |
LOCAL |
1 |
715 |
1292 |
28 |
0 |
0 |
2026-08-11T14:10:40.629000Z |
play_count |
1292 |
LOCAL |
1 |
716 |
24280959 |
192457 |
3631 |
5158 |
2026-08-12T01:40:36.226000Z |
play_count |
24280959 |
LOCAL |
1 |
717 |
692561 |
9322 |
203 |
210 |
2026-08-14T12:56:45.999000Z |
play_count |
692561 |
LOCAL |
1 |
718 |
5011435 |
27808 |
197 |
883 |
2026-08-12T01:56:57.451Z |
play_count |
5011435 |
LOCAL |
1 |
751 |
34473 |
3 |
51 |
13 |
2026-08-12T13:55:50Z |
play_count |
34473 |
SERVER |
1 |
752 |
18538 |
3 |
42 |
9 |
2026-08-14T06:17:57.597000Z |
play_count |
18538 |
LOCAL |
1 |
753 |
18858582 |
299013 |
0 |
4494 |
2026-08-11T14:19:00.838000Z |
play_count |
18858582 |
LOCAL |
1 |
754 |
16284 |
129 |
0 |
1 |
2026-08-11T14:19:00.838000Z |
play_count |
16284 |
LOCAL |
1 |
755 |
4099 |
19 |
1 |
1 |
2026-08-12T13:57:20.120000Z |
play_count |
4099 |
LOCAL |
1 |
756 |
17670 |
3 |
0 |
5 |
2026-08-11T14:19:00.838000Z |
play_count |
17670 |
LOCAL |
1 |
757 |
582343 |
802 |
0 |
0 |
2026-08-11T15:00:41Z |
play_count |
582343 |
SERVER |
1 |
758 |
0 |
1933 |
0 |
43 |
2026-08-11T14:19:00.838000Z |
play_count |
0 |
LOCAL |
0 |
760 |
0 |
3 |
15 |
3 |
2026-08-12T13:55:50Z |
play_count |
18 |
SERVER |
0 |
761 |
561921 |
27607 |
0 |
253 |
2026-08-11T14:19:00.838000Z |
play_count |
561921 |
LOCAL |
1 |
762 |
23642287 |
96538 |
0 |
4870 |
2026-08-11T14:19:00.838000Z |
play_count |
23642287 |
LOCAL |
1 |
763 |
17069994 |
3 |
630 |
5350 |
2026-08-12T13:47:37.115000Z |
play_count |
17069994 |
LOCAL |
1 |
764 |
1897 |
7 |
0 |
0 |
2026-08-11T14:19:00.838000Z |
play_count |
1897 |
LOCAL |
1 |
765 |
16412 |
100 |
0 |
0 |
2026-08-12T13:43:24Z |
play_count |
16412 |
SERVER |
1 |
766 |
78885236 |
412616 |
656 |
12931 |
2026-08-14T06:42:43.868000Z |
play_count |
78885236 |
LOCAL |
1 |
767 |
100569645 |
1672710 |
0 |
19863 |
2026-08-11T14:19:00.838000Z |
play_count |
100569645 |
LOCAL |
1 |
768 |
14698080 |
74504 |
0 |
1425 |
2026-08-11T14:19:00.838000Z |
play_count |
14698080 |
LOCAL |
1 |
769 |
5703 |
40 |
2 |
1 |
2026-08-12T03:15:08.142000Z |
play_count |
5703 |
LOCAL |
1 |
770 |
3656849 |
38010 |
0 |
1726 |
2026-08-11T14:19:00.838000Z |
play_count |
3656849 |
LOCAL |
1 |
771 |
2397399 |
15279 |
0 |
645 |
2026-08-11T14:19:00.838000Z |
play_count |
2397399 |
LOCAL |
1 |
792 |
11018 |
3 |
0 |
2 |
2026-08-11T14:20:22.348000Z |
play_count |
11018 |
LOCAL |
1 |
793 |
2680 |
23 |
0 |
0 |
2026-08-11T14:20:22.348000Z |
play_count |
2680 |
LOCAL |
1 |
794 |
324465 |
4903 |
87 |
176 |
2026-08-12T09:21:15.133000Z |
play_count |
324465 |
LOCAL |
1 |
796 |
17775594 |
1087187 |
0 |
25332 |
2026-08-11T14:20:22.348000Z |
play_count |
17775594 |
LOCAL |
1 |
797 |
11308 |
102 |
0 |
2 |
2026-08-11T14:20:22.348000Z |
play_count |
11308 |
LOCAL |
1 |
798 |
3867 |
54 |
0 |
0 |
2026-08-11T14:20:22.348000Z |
play_count |
3867 |
LOCAL |
1 |
799 |
8132 |
3 |
0 |
2 |
2026-08-11T14:20:22.348000Z |
play_count |
8132 |
LOCAL |
1 |
800 |
1517 |
21 |
43 |
6 |
2026-08-12T01:48:23.204000Z |
play_count |
1517 |
LOCAL |
1 |
802 |
0 |
91 |
0 |
5 |
2026-08-11T21:44:53.988000Z |
play_count |
91 |
LOCAL |
0 |
803 |
29648149 |
1754041 |
0 |
37958 |
2026-08-11T14:20:22.348000Z |
play_count |
29648149 |
LOCAL |
1 |
804 |
612103 |
10336 |
0 |
205 |
2026-08-11T14:20:22.348000Z |
play_count |
612103 |
LOCAL |
1 |
805 |
1973137 |
97198 |
124 |
4503 |
2026-08-12T13:55:25.749000Z |
play_count |
1973137 |
LOCAL |
1 |
806 |
2966383 |
38657 |
1489 |
1046 |
2026-08-12T01:40:36.226000Z |
play_count |
2966383 |
LOCAL |
1 |
808 |
3597276 |
109237 |
0 |
2590 |
2026-08-11T14:20:22.348000Z |
play_count |
3597276 |
LOCAL |
1 |
809 |
24854055 |
472339 |
1268 |
8408 |
2026-08-12T13:56:05.750000Z |
play_count |
24854055 |
LOCAL |
1 |
811 |
259743795 |
11715766 |
20748 |
240159 |
2026-08-12T01:40:36.226000Z |
play_count |
259743795 |
LOCAL |
1 |
886 |
1966450 |
14235 |
182 |
327 |
2026-08-16T13:49:41.254000Z |
play_count |
1966450 |
LOCAL |
1 |
887 |
121842 |
1754 |
0 |
17 |
2026-08-11T14:52:35.100000Z |
play_count |
121842 |
LOCAL |
1 |
889 |
0 |
117 |
0 |
2 |
2026-08-11T14:52:35.100000Z |
play_count |
0 |
LOCAL |
0 |
890 |
919555 |
7600 |
24 |
208 |
2026-08-16T13:10:03.639000Z |
play_count |
919555 |
LOCAL |
1 |
891 |
2192 |
3 |
0 |
2 |
2026-08-11T14:52:35.100000Z |
play_count |
2192 |
LOCAL |
1 |
893 |
2847 |
13 |
0 |
0 |
2026-08-11T14:52:35.100000Z |
play_count |
2847 |
LOCAL |
1 |
894 |
15173060 |
57979 |
210 |
1114 |
2026-08-15T04:38:11.840000Z |
play_count |
15173060 |
LOCAL |
1 |
895 |
14843739 |
15589 |
0 |
238 |
2026-08-11T14:52:35.100000Z |
play_count |
14843739 |
LOCAL |
1 |
897 |
2832032 |
23037 |
1230 |
396 |
2026-08-15T04:41:59.380000Z |
play_count |
2832032 |
LOCAL |
1 |
898 |
1177272 |
163634 |
412 |
4880 |
2026-08-11T15:10:27.241000Z |
play_count |
1177272 |
LOCAL |
1 |
899 |
333768732 |
2068906 |
22197 |
42555 |
2026-08-12T23:05:25.596000Z |
play_count |
333768732 |
LOCAL |
1 |
900 |
0 |
6 |
0 |
0 |
2026-08-11T14:52:35.100000Z |
play_count |
0 |
LOCAL |
0 |
901 |
175713 |
1733 |
0 |
77 |
2026-08-11T14:52:35.100000Z |
play_count |
175713 |
LOCAL |
1 |
902 |
0 |
216 |
0 |
5 |
2026-08-11T14:52:35.100000Z |
play_count |
0 |
LOCAL |
0 |
903 |
13183887 |
54426 |
215 |
1292 |
2026-08-11T15:10:27.241000Z |
play_count |
13183887 |
LOCAL |
1 |
904 |
0 |
17 |
0 |
0 |
2026-08-11T14:52:35.100000Z |
play_count |
0 |
LOCAL |
0 |
905 |
12428486 |
33796 |
0 |
410 |
2026-08-11T14:52:35.100000Z |
play_count |
12428486 |
LOCAL |
1 |
907 |
74642500 |
172200 |
734 |
6480 |
2026-08-16T13:09:52.579000Z |
play_count |
74642500 |
LOCAL |
1 |
908 |
26318 |
233 |
0 |
2 |
2026-08-11T14:52:35.100000Z |
play_count |
26318 |
LOCAL |
1 |
909 |
2046212 |
24905 |
184 |
990 |
2026-08-12T13:49:45.855000Z |
play_count |
2046212 |
LOCAL |
1 |
910 |
1036766 |
14670 |
19826 |
245 |
2026-08-12T23:05:25.596000Z |
play_count |
1036766 |
LOCAL |
1 |
956 |
368920 |
390 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
368920 |
LOCAL |
1 |
959 |
11137 |
74 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
11137 |
LOCAL |
1 |
962 |
15448 |
76 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
15448 |
LOCAL |
1 |
966 |
31439 |
231 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
31439 |
LOCAL |
1 |
972 |
296871 |
553 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
296871 |
LOCAL |
1 |
975 |
49963 |
180 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
49963 |
LOCAL |
1 |
999 |
323684 |
1171 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
323684 |
LOCAL |
1 |
1002 |
564691 |
351 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
564691 |
LOCAL |
1 |
1003 |
77287 |
281 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
77287 |
LOCAL |
1 |
1004 |
26946 |
112 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
26946 |
LOCAL |
1 |
1005 |
27170 |
106 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
27170 |
LOCAL |
1 |
1006 |
1655395 |
2260 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
1655395 |
LOCAL |
1 |
1007 |
365795 |
1855 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
365795 |
LOCAL |
1 |
1008 |
34302 |
131 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
34302 |
LOCAL |
1 |