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 |
|---|---|---|---|---|---|---|---|---|---|---|
701 |
671 |
16379848 |
130399 |
195 |
4767 |
2026-08-11T15:10:27.241000Z |
play_count |
16379848 |
LOCAL |
1 |
702 |
1069 |
115137349 |
7921795 |
20110 |
194902 |
2026-08-11T15:10:27.241000Z |
play_count |
115137349 |
LOCAL |
1 |
703 |
1070 |
276628 |
3791 |
46 |
75 |
2026-08-11T15:10:27.241000Z |
play_count |
276628 |
LOCAL |
1 |
704 |
1071 |
14019027 |
89915 |
91 |
1234 |
2026-08-11T15:10:27.241000Z |
play_count |
14019027 |
LOCAL |
1 |
705 |
1072 |
1663596 |
14210 |
2644 |
542 |
2026-08-11T15:10:27.241000Z |
play_count |
1663596 |
LOCAL |
1 |
706 |
1073 |
25113 |
40 |
0 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
25113 |
LOCAL |
1 |
707 |
1074 |
26278204 |
390597 |
1239 |
8588 |
2026-08-11T15:10:27.241000Z |
play_count |
26278204 |
LOCAL |
1 |
708 |
1075 |
58777740 |
734037 |
975 |
36242 |
2026-08-11T15:10:27.241000Z |
play_count |
58777740 |
LOCAL |
1 |
709 |
1076 |
15412828 |
297401 |
2156 |
7689 |
2026-08-11T15:10:27.241000Z |
play_count |
15412828 |
LOCAL |
1 |
710 |
1077 |
290235295 |
1445142 |
2134 |
35027 |
2026-08-11T15:10:27.241000Z |
play_count |
290235295 |
LOCAL |
1 |
711 |
1078 |
211646646 |
6998624 |
6825 |
132898 |
2026-08-11T15:10:27.241000Z |
play_count |
211646646 |
LOCAL |
1 |
712 |
617 |
6910959 |
288408 |
151 |
3575 |
2026-08-11T15:10:27.241000Z |
play_count |
6910959 |
LOCAL |
1 |
713 |
1080 |
17458231 |
580373 |
3077 |
30734 |
2026-08-11T15:10:27.241000Z |
play_count |
17458231 |
LOCAL |
1 |
714 |
1081 |
4224652 |
96984 |
1031 |
1583 |
2026-08-11T15:10:27.241000Z |
play_count |
4224652 |
LOCAL |
1 |
715 |
1082 |
40527134 |
982254 |
5230 |
16071 |
2026-08-11T15:10:27.241000Z |
play_count |
40527134 |
LOCAL |
1 |
716 |
1083 |
81108670 |
4957299 |
14171 |
138125 |
2026-08-11T15:10:27.241000Z |
play_count |
81108670 |
LOCAL |
1 |
717 |
657 |
0 |
41 |
1 |
3 |
2026-08-11T15:10:27.241000Z |
play_count |
42 |
LOCAL |
0 |
718 |
1085 |
135091344 |
3431814 |
14345 |
84391 |
2026-08-11T15:10:27.241000Z |
play_count |
135091344 |
LOCAL |
1 |
719 |
1086 |
13551 |
622 |
136 |
67 |
2026-08-11T15:10:27.241000Z |
play_count |
13551 |
LOCAL |
1 |
720 |
1087 |
3497 |
18 |
0 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
3497 |
LOCAL |
1 |
721 |
1088 |
21438017 |
421830 |
949 |
4810 |
2026-08-11T15:10:27.241000Z |
play_count |
21438017 |
LOCAL |
1 |
722 |
1133 |
787696 |
3191 |
0 |
67 |
2026-08-11T21:44:53.988000Z |
play_count |
787696 |
LOCAL |
1 |
723 |
1134 |
0 |
3 |
0 |
0 |
2026-08-11T21:44:53.988000Z |
play_count |
3 |
LOCAL |
0 |
724 |
802 |
0 |
91 |
0 |
5 |
2026-08-11T21:44:53.988000Z |
play_count |
91 |
LOCAL |
0 |
725 |
1136 |
0 |
4 |
0 |
0 |
2026-08-11T21:44:53.988000Z |
play_count |
4 |
LOCAL |
0 |
726 |
1137 |
125334943 |
825778 |
0 |
48803 |
2026-08-11T21:44:53.988000Z |
play_count |
125334943 |
LOCAL |
1 |
727 |
1138 |
2564807 |
145043 |
0 |
1234 |
2026-08-11T21:44:53.988000Z |
play_count |
2564807 |
LOCAL |
1 |
728 |
1140 |
0 |
84 |
0 |
0 |
2026-08-11T21:44:53.988000Z |
play_count |
84 |
LOCAL |
0 |
729 |
1141 |
4802133 |
25981 |
0 |
1626 |
2026-08-11T21:44:53.988000Z |
play_count |
4802133 |
LOCAL |
1 |
730 |
1142 |
4197099 |
28572 |
0 |
455 |
2026-08-11T21:44:53.988000Z |
play_count |
4197099 |
LOCAL |
1 |
731 |
1143 |
1162799 |
25248 |
0 |
598 |
2026-08-11T21:44:53.988000Z |
play_count |
1162799 |
LOCAL |
1 |
732 |
1144 |
0 |
24 |
0 |
1 |
2026-08-11T21:44:53.988000Z |
play_count |
24 |
LOCAL |
0 |
733 |
1145 |
11982181 |
51767 |
0 |
2186 |
2026-08-11T21:44:53.988000Z |
play_count |
11982181 |
LOCAL |
1 |
734 |
1146 |
420 |
2 |
0 |
0 |
2026-08-11T21:44:53.988000Z |
play_count |
420 |
LOCAL |
1 |
735 |
1147 |
10180 |
83 |
0 |
2 |
2026-08-11T21:44:53.988000Z |
play_count |
10180 |
LOCAL |
1 |
736 |
1148 |
0 |
251 |
0 |
4 |
2026-08-11T21:44:53.988000Z |
play_count |
251 |
LOCAL |
0 |
737 |
1149 |
0 |
3 |
0 |
7 |
2026-08-11T21:44:53.988000Z |
play_count |
3 |
LOCAL |
0 |
738 |
1150 |
376473 |
11053 |
0 |
317 |
2026-08-11T21:44:53.988000Z |
play_count |
376473 |
LOCAL |
1 |
739 |
1151 |
4456164 |
87354 |
0 |
1009 |
2026-08-11T21:44:53.988000Z |
play_count |
4456164 |
LOCAL |
1 |
740 |
1152 |
0 |
51 |
0 |
0 |
2026-08-11T21:44:53.988000Z |
play_count |
51 |
LOCAL |
0 |
741 |
1153 |
148767714 |
363696 |
0 |
26238 |
2026-08-11T21:44:53.988000Z |
play_count |
148767714 |
LOCAL |
1 |
742 |
1154 |
2121123 |
12609 |
0 |
1005 |
2026-08-11T21:44:53.988000Z |
play_count |
2121123 |
LOCAL |
1 |
743 |
1155 |
2341635 |
32277 |
0 |
656 |
2026-08-11T21:44:53.988000Z |
play_count |
2341635 |
LOCAL |
1 |
744 |
1156 |
7984950 |
106212 |
0 |
2289 |
2026-08-11T21:44:53.988000Z |
play_count |
7984950 |
LOCAL |
1 |
745 |
1133 |
787696 |
3191 |
0 |
67 |
2026-08-11T21:46:59.361Z |
0 |
LOCAL |
0 |
|
746 |
1133 |
796943 |
3231 |
151 |
68 |
2026-08-11T21:47:54Z |
play_count |
796943 |
SERVER |
1 |
747 |
1044 |
13284268 |
66682 |
122 |
4789 |
2026-08-11T23:17:16.054Z |
0 |
LOCAL |
0 |
|
748 |
1188 |
395382 |
865 |
23 |
86 |
2026-08-12T01:40:36.226000Z |
play_count |
395382 |
LOCAL |
1 |
749 |
553 |
780724 |
11261 |
24 |
168 |
2026-08-12T01:40:36.226000Z |
play_count |
780724 |
LOCAL |
1 |
750 |
1190 |
6981448 |
108770 |
363 |
1141 |
2026-08-12T01:40:36.226000Z |
play_count |
6981448 |
LOCAL |
1 |
751 |
1069 |
115787285 |
7955216 |
20196 |
195552 |
2026-08-12T01:40:36.226000Z |
play_count |
115787285 |
LOCAL |
1 |
752 |
1192 |
465 |
22 |
3 |
1 |
2026-08-12T01:40:36.226000Z |
play_count |
465 |
LOCAL |
1 |
753 |
1193 |
1100160 |
16192 |
39 |
270 |
2026-08-12T01:40:36.226000Z |
play_count |
1100160 |
LOCAL |
1 |
754 |
1195 |
29903138 |
89385 |
203 |
9479 |
2026-08-12T01:40:36.226000Z |
play_count |
29903138 |
LOCAL |
1 |
755 |
1196 |
1708183 |
13848 |
103 |
201 |
2026-08-12T01:40:36.226000Z |
play_count |
1708183 |
LOCAL |
1 |
756 |
1197 |
9573218 |
66504 |
314 |
1535 |
2026-08-12T01:40:36.226000Z |
play_count |
9573218 |
LOCAL |
1 |
757 |
1147 |
10289 |
85 |
7 |
2 |
2026-08-12T01:40:36.226000Z |
play_count |
10289 |
LOCAL |
1 |
758 |
1199 |
3138514 |
7732 |
27 |
289 |
2026-08-12T01:40:36.226000Z |
play_count |
3138514 |
LOCAL |
1 |
759 |
1200 |
6972406 |
10840 |
66 |
263 |
2026-08-12T01:40:36.226000Z |
play_count |
6972406 |
LOCAL |
1 |
760 |
811 |
259743795 |
11715766 |
20748 |
240159 |
2026-08-12T01:40:36.226000Z |
play_count |
259743795 |
LOCAL |
1 |
761 |
763 |
15301819 |
3 |
549 |
4785 |
2026-08-12T01:40:36.226000Z |
play_count |
15301819 |
LOCAL |
1 |
762 |
1203 |
23771 |
91 |
141 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
23771 |
LOCAL |
1 |
763 |
1204 |
9986963 |
37186 |
58 |
733 |
2026-08-12T01:40:36.226000Z |
play_count |
9986963 |
LOCAL |
1 |
764 |
1205 |
2560592 |
26288 |
3074 |
900 |
2026-08-12T01:40:36.226000Z |
play_count |
2560592 |
LOCAL |
1 |
765 |
1206 |
21880941 |
322013 |
3125 |
1173 |
2026-08-12T01:40:36.226000Z |
play_count |
21880941 |
LOCAL |
1 |
766 |
530 |
125775300 |
651562 |
1923 |
19155 |
2026-08-12T01:40:36.226000Z |
play_count |
125775300 |
LOCAL |
1 |
767 |
1208 |
10225197 |
58882 |
419 |
2060 |
2026-08-12T01:40:36.226000Z |
play_count |
10225197 |
LOCAL |
1 |
768 |
540 |
1979622 |
4009 |
25 |
197 |
2026-08-12T01:40:36.226000Z |
play_count |
1979622 |
LOCAL |
1 |
769 |
1210 |
50853 |
8659 |
927 |
17 |
2026-08-12T01:40:36.226000Z |
play_count |
50853 |
LOCAL |
1 |
770 |
1211 |
71038917 |
726394 |
1171 |
8313 |
2026-08-12T01:40:36.226000Z |
play_count |
71038917 |
LOCAL |
1 |
771 |
299 |
1551745 |
12009 |
11 |
189 |
2026-08-12T01:40:36.226000Z |
play_count |
1551745 |
LOCAL |
1 |
772 |
1213 |
4658251 |
25234 |
68 |
574 |
2026-08-12T01:40:36.226000Z |
play_count |
4658251 |
LOCAL |
1 |
773 |
306 |
1859595 |
12421 |
140 |
277 |
2026-08-12T01:40:36.226000Z |
play_count |
1859595 |
LOCAL |
1 |
774 |
1215 |
9227839 |
47775 |
91 |
562 |
2026-08-12T01:40:36.226000Z |
play_count |
9227839 |
LOCAL |
1 |
775 |
300 |
2144 |
481 |
7 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
2144 |
LOCAL |
1 |
776 |
309 |
1685 |
481 |
13 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
1685 |
LOCAL |
1 |
777 |
1218 |
27356565 |
378800 |
1172 |
7991 |
2026-08-12T01:40:36.226000Z |
play_count |
27356565 |
LOCAL |
1 |
778 |
1219 |
0 |
71 |
9 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
80 |
LOCAL |
0 |
779 |
1220 |
1993 |
3 |
14 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
1993 |
LOCAL |
1 |
780 |
533 |
147215393 |
2829492 |
11573 |
37180 |
2026-08-12T01:40:36.226000Z |
play_count |
147215393 |
LOCAL |
1 |
781 |
1222 |
0 |
3 |
0 |
1 |
2026-08-12T01:40:36.226000Z |
play_count |
3 |
LOCAL |
0 |
782 |
530 |
125775300 |
651562 |
1923 |
19155 |
2026-08-12T01:40:43.078Z |
0 |
LOCAL |
0 |
|
783 |
524 |
117558107 |
1734243 |
5765 |
19753 |
2026-08-12T01:40:36.226000Z |
play_count |
117558107 |
LOCAL |
1 |
784 |
1225 |
6316 |
573 |
23 |
17 |
2026-08-12T01:40:36.226000Z |
play_count |
6316 |
LOCAL |
1 |
785 |
1226 |
2560 |
97 |
8 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
2560 |
LOCAL |
1 |
786 |
1085 |
137300967 |
3500158 |
14650 |
86247 |
2026-08-12T01:40:36.226000Z |
play_count |
137300967 |
LOCAL |
1 |
787 |
1228 |
6056438 |
19315 |
33 |
339 |
2026-08-12T01:40:36.226000Z |
play_count |
6056438 |
LOCAL |
1 |
788 |
1229 |
1160467 |
45233 |
704 |
1664 |
2026-08-12T01:40:36.226000Z |
play_count |
1160467 |
LOCAL |
1 |
789 |
572 |
47019 |
699 |
17 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
47019 |
LOCAL |
1 |
790 |
716 |
24280959 |
192457 |
3631 |
5158 |
2026-08-12T01:40:36.226000Z |
play_count |
24280959 |
LOCAL |
1 |
791 |
1232 |
7274548 |
129068 |
77449 |
1350 |
2026-08-12T01:40:36.226000Z |
play_count |
7274548 |
LOCAL |
1 |
792 |
1233 |
9866571 |
54341 |
122 |
1114 |
2026-08-12T01:40:36.226000Z |
play_count |
9866571 |
LOCAL |
1 |
793 |
1234 |
116719516 |
5424006 |
23762 |
71681 |
2026-08-12T01:40:36.226000Z |
play_count |
116719516 |
LOCAL |
1 |
794 |
1235 |
11107807 |
318305 |
325 |
9317 |
2026-08-12T01:40:36.226000Z |
play_count |
11107807 |
LOCAL |
1 |
795 |
1236 |
5386611 |
22212 |
46 |
523 |
2026-08-12T01:40:36.226000Z |
play_count |
5386611 |
LOCAL |
1 |
796 |
1086 |
13591 |
623 |
136 |
67 |
2026-08-12T01:40:36.226000Z |
play_count |
13591 |
LOCAL |
1 |
797 |
1238 |
18267924 |
1196342 |
2900 |
33548 |
2026-08-12T01:40:36.226000Z |
play_count |
18267924 |
LOCAL |
1 |
798 |
551 |
1438 |
42 |
5 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
1438 |
LOCAL |
1 |
799 |
806 |
2966383 |
38657 |
1489 |
1046 |
2026-08-12T01:40:36.226000Z |
play_count |
2966383 |
LOCAL |
1 |
800 |
766 |
73838712 |
385044 |
630 |
12305 |
2026-08-12T01:40:36.226000Z |
play_count |
73838712 |
LOCAL |
1 |