Table: post_stat_history
Schema
| cid | name | type | notnull | default | pk |
|---|---|---|---|---|---|
| 0 | id | INTEGER | 0 | 1 | |
| 1 | post_id | INTEGER | 1 | 0 | |
| 2 | views | INTEGER | 1 | 0 | 0 |
| 3 | likes | INTEGER | 1 | 0 | 0 |
| 4 | comments | INTEGER | 1 | 0 | 0 |
| 5 | reposts | INTEGER | 1 | 0 | 0 |
| 6 | collected_at | TEXT | 1 | CURRENT_TIMESTAMP | 0 |
| 7 | sort_by | TEXT | 1 | '' | 0 |
| 8 | sort_value | INTEGER | 1 | 0 | 0 |
| 9 | source_kind | TEXT | 1 | 'LOCAL' | 0 |
| 10 | views_available | INTEGER | 1 | 0 | 0 |
Data
| id | post_id | views | likes | comments | reposts | collected_at | sort_by | sort_value | source_kind | views_available |
|---|---|---|---|---|---|---|---|---|---|---|
601 |
769 |
7958 |
31 |
0 |
0 |
2026-08-11T14:19:00.838000Z |
play_count |
7958 |
LOCAL |
1 |
602 |
770 |
3656849 |
38010 |
0 |
1726 |
2026-08-11T14:19:00.838000Z |
play_count |
3656849 |
LOCAL |
1 |
603 |
771 |
2397399 |
15279 |
0 |
645 |
2026-08-11T14:19:00.838000Z |
play_count |
2397399 |
LOCAL |
1 |
604 |
792 |
11018 |
3 |
0 |
2 |
2026-08-11T14:20:22.348000Z |
play_count |
11018 |
LOCAL |
1 |
605 |
793 |
2680 |
23 |
0 |
0 |
2026-08-11T14:20:22.348000Z |
play_count |
2680 |
LOCAL |
1 |
606 |
794 |
322938 |
4866 |
0 |
174 |
2026-08-11T14:20:22.348000Z |
play_count |
322938 |
LOCAL |
1 |
607 |
572 |
46038 |
674 |
0 |
0 |
2026-08-11T14:20:22.348000Z |
play_count |
46038 |
LOCAL |
1 |
608 |
796 |
17775594 |
1087187 |
0 |
25332 |
2026-08-11T14:20:22.348000Z |
play_count |
17775594 |
LOCAL |
1 |
609 |
797 |
11308 |
102 |
0 |
2 |
2026-08-11T14:20:22.348000Z |
play_count |
11308 |
LOCAL |
1 |
610 |
798 |
3867 |
54 |
0 |
0 |
2026-08-11T14:20:22.348000Z |
play_count |
3867 |
LOCAL |
1 |
611 |
799 |
8132 |
3 |
0 |
2 |
2026-08-11T14:20:22.348000Z |
play_count |
8132 |
LOCAL |
1 |
612 |
800 |
1511 |
21 |
0 |
6 |
2026-08-11T14:20:22.348000Z |
play_count |
1511 |
LOCAL |
1 |
613 |
611 |
2805 |
56 |
0 |
8 |
2026-08-11T14:20:22.348000Z |
play_count |
2805 |
LOCAL |
1 |
614 |
802 |
0 |
2 |
0 |
0 |
2026-08-11T14:20:22.348000Z |
play_count |
0 |
LOCAL |
0 |
615 |
803 |
29648149 |
1754041 |
0 |
37958 |
2026-08-11T14:20:22.348000Z |
play_count |
29648149 |
LOCAL |
1 |
616 |
804 |
612103 |
10336 |
0 |
205 |
2026-08-11T14:20:22.348000Z |
play_count |
612103 |
LOCAL |
1 |
617 |
805 |
1972062 |
97144 |
0 |
4503 |
2026-08-11T14:20:22.348000Z |
play_count |
1972062 |
LOCAL |
1 |
618 |
806 |
2965743 |
38649 |
0 |
1046 |
2026-08-11T14:20:22.348000Z |
play_count |
2965743 |
LOCAL |
1 |
619 |
662 |
460442 |
4673 |
0 |
225 |
2026-08-11T14:20:22.348000Z |
play_count |
460442 |
LOCAL |
1 |
620 |
808 |
3597276 |
109237 |
0 |
2590 |
2026-08-11T14:20:22.348000Z |
play_count |
3597276 |
LOCAL |
1 |
621 |
809 |
16084100 |
279571 |
0 |
4966 |
2026-08-11T14:20:22.348000Z |
play_count |
16084100 |
LOCAL |
1 |
622 |
615 |
795 |
31 |
0 |
6 |
2026-08-11T14:20:22.348000Z |
play_count |
795 |
LOCAL |
1 |
623 |
811 |
259645115 |
11712491 |
0 |
240085 |
2026-08-11T14:20:22.348000Z |
play_count |
259645115 |
LOCAL |
1 |
624 |
609 |
163570075 |
3187899 |
0 |
59523 |
2026-08-11T14:20:22.348000Z |
play_count |
163570075 |
LOCAL |
1 |
625 |
662 |
460363 |
4670 |
0 |
225 |
2026-08-11T14:21:35Z |
play_count |
460363 |
SERVER |
1 |
626 |
662 |
460442 |
4673 |
0 |
225 |
2026-08-11T14:51:41.138000Z |
play_count |
460442 |
LOCAL |
1 |
627 |
886 |
1926531 |
13738 |
0 |
314 |
2026-08-11T14:52:35.100000Z |
play_count |
1926531 |
LOCAL |
1 |
628 |
887 |
121842 |
1754 |
0 |
17 |
2026-08-11T14:52:35.100000Z |
play_count |
121842 |
LOCAL |
1 |
629 |
564 |
11929408 |
49414 |
0 |
571 |
2026-08-11T14:52:35.100000Z |
play_count |
11929408 |
LOCAL |
1 |
630 |
890 |
835541 |
6643 |
0 |
189 |
2026-08-11T14:52:35.100000Z |
play_count |
835541 |
LOCAL |
1 |
631 |
891 |
2192 |
3 |
0 |
2 |
2026-08-11T14:52:35.100000Z |
play_count |
2192 |
LOCAL |
1 |
632 |
610 |
452466 |
2329 |
0 |
166 |
2026-08-11T14:52:35.100000Z |
play_count |
452466 |
LOCAL |
1 |
633 |
893 |
2847 |
13 |
0 |
0 |
2026-08-11T14:52:35.100000Z |
play_count |
2847 |
LOCAL |
1 |
634 |
894 |
14878234 |
56079 |
0 |
1074 |
2026-08-11T14:52:35.100000Z |
play_count |
14878234 |
LOCAL |
1 |
635 |
895 |
14843739 |
15589 |
0 |
238 |
2026-08-11T14:52:35.100000Z |
play_count |
14843739 |
LOCAL |
1 |
636 |
889 |
0 |
117 |
0 |
2 |
2026-08-11T14:52:35.100000Z |
play_count |
0 |
LOCAL |
0 |
637 |
897 |
1206737 |
21455 |
0 |
365 |
2026-08-11T14:52:35.100000Z |
play_count |
1206737 |
LOCAL |
1 |
638 |
898 |
1177271 |
163634 |
0 |
4880 |
2026-08-11T14:52:35.100000Z |
play_count |
1177271 |
LOCAL |
1 |
639 |
899 |
332556141 |
2059724 |
0 |
42388 |
2026-08-11T14:52:35.100000Z |
play_count |
332556141 |
LOCAL |
1 |
640 |
900 |
0 |
6 |
0 |
0 |
2026-08-11T14:52:35.100000Z |
play_count |
0 |
LOCAL |
0 |
641 |
901 |
175713 |
1733 |
0 |
77 |
2026-08-11T14:52:35.100000Z |
play_count |
175713 |
LOCAL |
1 |
642 |
902 |
0 |
216 |
0 |
5 |
2026-08-11T14:52:35.100000Z |
play_count |
0 |
LOCAL |
0 |
643 |
903 |
13183577 |
54425 |
0 |
1292 |
2026-08-11T14:52:35.100000Z |
play_count |
13183577 |
LOCAL |
1 |
644 |
904 |
0 |
17 |
0 |
0 |
2026-08-11T14:52:35.100000Z |
play_count |
0 |
LOCAL |
0 |
645 |
905 |
12428486 |
33796 |
0 |
410 |
2026-08-11T14:52:35.100000Z |
play_count |
12428486 |
LOCAL |
1 |
646 |
616 |
4075637 |
61354 |
0 |
1600 |
2026-08-11T14:52:35.100000Z |
play_count |
4075637 |
LOCAL |
1 |
647 |
907 |
71547100 |
161727 |
0 |
6156 |
2026-08-11T14:52:35.100000Z |
play_count |
71547100 |
LOCAL |
1 |
648 |
908 |
26318 |
233 |
0 |
2 |
2026-08-11T14:52:35.100000Z |
play_count |
26318 |
LOCAL |
1 |
649 |
909 |
1959406 |
23451 |
0 |
923 |
2026-08-11T14:52:35.100000Z |
play_count |
1959406 |
LOCAL |
1 |
650 |
910 |
1018325 |
14383 |
0 |
242 |
2026-08-11T14:52:35.100000Z |
play_count |
1018325 |
LOCAL |
1 |
651 |
765 |
14110 |
83 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
14110 |
LOCAL |
1 |
652 |
572 |
79089 |
676 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
79089 |
LOCAL |
1 |
653 |
956 |
368920 |
390 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
368920 |
LOCAL |
1 |
654 |
959 |
11137 |
74 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
11137 |
LOCAL |
1 |
655 |
757 |
583298 |
803 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
583298 |
LOCAL |
1 |
656 |
962 |
15448 |
76 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
15448 |
LOCAL |
1 |
657 |
975 |
49963 |
180 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
49963 |
LOCAL |
1 |
658 |
999 |
323684 |
1171 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
323684 |
LOCAL |
1 |
659 |
966 |
31439 |
231 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
31439 |
LOCAL |
1 |
660 |
972 |
296871 |
553 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
296871 |
LOCAL |
1 |
661 |
1002 |
564691 |
351 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
564691 |
LOCAL |
1 |
662 |
1003 |
77287 |
281 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
77287 |
LOCAL |
1 |
663 |
1004 |
26946 |
112 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
26946 |
LOCAL |
1 |
664 |
1005 |
27170 |
106 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
27170 |
LOCAL |
1 |
665 |
1006 |
1655395 |
2260 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
1655395 |
LOCAL |
1 |
666 |
1007 |
365795 |
1855 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
365795 |
LOCAL |
1 |
667 |
1008 |
34302 |
131 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
34302 |
LOCAL |
1 |
668 |
1009 |
50458 |
332 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
50458 |
LOCAL |
1 |
669 |
1010 |
37306 |
154 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
37306 |
LOCAL |
1 |
670 |
1011 |
33187 |
242 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
33187 |
LOCAL |
1 |
671 |
1012 |
93247 |
472 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
93247 |
LOCAL |
1 |
672 |
1013 |
32002 |
116 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
32002 |
LOCAL |
1 |
673 |
1014 |
472072 |
825 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
472072 |
LOCAL |
1 |
674 |
1015 |
604021 |
671 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
604021 |
LOCAL |
1 |
675 |
757 |
582343 |
802 |
0 |
0 |
2026-08-11T15:00:41Z |
play_count |
582343 |
SERVER |
1 |
676 |
572 |
46038 |
674 |
0 |
0 |
2026-08-11T15:00:41Z |
play_count |
46038 |
SERVER |
1 |
677 |
765 |
13827 |
81 |
0 |
0 |
2026-08-11T15:00:41Z |
play_count |
13827 |
SERVER |
1 |
678 |
697 |
940412 |
7407 |
120 |
84 |
2026-08-11T15:10:27.241000Z |
play_count |
940412 |
LOCAL |
1 |
679 |
1044 |
13284268 |
66682 |
122 |
4789 |
2026-08-11T15:10:27.241000Z |
play_count |
13284268 |
LOCAL |
1 |
680 |
1045 |
84243 |
355 |
9 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
84243 |
LOCAL |
1 |
681 |
1046 |
0 |
301 |
1 |
3 |
2026-08-11T15:10:27.241000Z |
play_count |
302 |
LOCAL |
0 |
682 |
1048 |
6976002 |
117990 |
1755 |
3207 |
2026-08-11T15:10:27.241000Z |
play_count |
6976002 |
LOCAL |
1 |
683 |
1049 |
0 |
3 |
3 |
1 |
2026-08-11T15:10:27.241000Z |
play_count |
6 |
LOCAL |
0 |
684 |
1050 |
1106 |
6 |
0 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
1106 |
LOCAL |
1 |
685 |
1051 |
0 |
1 |
0 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
1 |
LOCAL |
0 |
686 |
1053 |
1502252 |
35027 |
421 |
677 |
2026-08-11T15:10:27.241000Z |
play_count |
1502252 |
LOCAL |
1 |
687 |
1054 |
3213 |
30 |
12 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
3213 |
LOCAL |
1 |
688 |
809 |
16754900 |
291364 |
690 |
5213 |
2026-08-11T15:10:27.241000Z |
play_count |
16754900 |
LOCAL |
1 |
689 |
898 |
1177272 |
163634 |
412 |
4880 |
2026-08-11T15:10:27.241000Z |
play_count |
1177272 |
LOCAL |
1 |
690 |
1057 |
79905 |
586 |
186 |
32 |
2026-08-11T15:10:27.241000Z |
play_count |
79905 |
LOCAL |
1 |
691 |
1058 |
498866 |
11870 |
159 |
210 |
2026-08-11T15:10:27.241000Z |
play_count |
498866 |
LOCAL |
1 |
692 |
1059 |
3026 |
19 |
0 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
3026 |
LOCAL |
1 |
693 |
1060 |
830 |
1 |
0 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
830 |
LOCAL |
1 |
694 |
1061 |
89042 |
954 |
182 |
22 |
2026-08-11T15:10:27.241000Z |
play_count |
89042 |
LOCAL |
1 |
695 |
903 |
13183887 |
54426 |
215 |
1292 |
2026-08-11T15:10:27.241000Z |
play_count |
13183887 |
LOCAL |
1 |
696 |
1063 |
2196 |
9 |
9 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
2196 |
LOCAL |
1 |
697 |
806 |
2965838 |
38651 |
1489 |
1046 |
2026-08-11T15:10:27.241000Z |
play_count |
2965838 |
LOCAL |
1 |
698 |
1065 |
7520 |
73 |
73 |
2 |
2026-08-11T15:10:27.241000Z |
play_count |
7520 |
LOCAL |
1 |
699 |
1066 |
2795 |
12 |
5 |
2 |
2026-08-11T15:10:27.241000Z |
play_count |
2795 |
LOCAL |
1 |
700 |
1067 |
6964771 |
99522 |
3304 |
2635 |
2026-08-11T15:10:27.241000Z |
play_count |
6964771 |
LOCAL |
1 |