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 |
|---|---|---|---|---|---|---|---|---|---|---|
1001 |
1773 |
19157 |
247 |
5 |
4 |
2026-08-12T09:16:22.594000Z |
play_count |
19157 |
LOCAL |
1 |
1002 |
1774 |
219669 |
5566 |
186 |
159 |
2026-08-12T09:16:22.594000Z |
play_count |
219669 |
LOCAL |
1 |
1003 |
1775 |
790025 |
2076 |
30 |
29 |
2026-08-12T09:16:22.594000Z |
play_count |
790025 |
LOCAL |
1 |
1004 |
1776 |
90576 |
1590 |
19 |
20 |
2026-08-12T09:16:22.594000Z |
play_count |
90576 |
LOCAL |
1 |
1005 |
1777 |
0 |
114 |
4 |
0 |
2026-08-12T09:16:22.594000Z |
play_count |
118 |
LOCAL |
0 |
1006 |
1747 |
0 |
44206 |
153 |
499 |
2026-08-12T09:19:17.258000Z |
play_count |
44359 |
LOCAL |
0 |
1007 |
1774 |
219669 |
5566 |
186 |
158 |
2026-08-12T09:19:52Z |
play_count |
5752 |
SERVER |
1 |
1008 |
1807 |
0 |
307 |
8 |
9 |
2026-08-12T09:20:15.437000Z |
play_count |
315 |
LOCAL |
0 |
1009 |
1809 |
0 |
1627 |
13 |
28 |
2026-08-12T09:20:15.437000Z |
play_count |
1640 |
LOCAL |
0 |
1010 |
1727 |
59666 |
1413 |
31 |
30 |
2026-08-12T09:20:15.437000Z |
play_count |
59666 |
LOCAL |
1 |
1011 |
1818 |
69610 |
539 |
1527 |
31 |
2026-08-12T09:20:36.946000Z |
play_count |
69610 |
LOCAL |
1 |
1012 |
1819 |
9364426 |
256353 |
16670 |
5905 |
2026-08-12T09:20:36.946000Z |
play_count |
9364426 |
LOCAL |
1 |
1013 |
1820 |
493724 |
3482 |
118 |
462 |
2026-08-12T09:20:36.946000Z |
play_count |
493724 |
LOCAL |
1 |
1014 |
290 |
48674562 |
1598375 |
1681 |
33326 |
2026-08-12T09:20:58.961000Z |
play_count |
48674562 |
LOCAL |
1 |
1015 |
653 |
177969 |
1377 |
49 |
48 |
2026-08-12T09:20:58.961000Z |
play_count |
177969 |
LOCAL |
1 |
1016 |
1680 |
858679 |
18448 |
277 |
324 |
2026-08-12T09:20:58.961000Z |
play_count |
858679 |
LOCAL |
1 |
1017 |
1830 |
41370037 |
1333387 |
5862 |
22447 |
2026-08-12T09:20:58.961000Z |
play_count |
41370037 |
LOCAL |
1 |
1018 |
1831 |
31044 |
117 |
10 |
1 |
2026-08-12T09:20:58.961000Z |
play_count |
31044 |
LOCAL |
1 |
1019 |
1832 |
5371707 |
16625 |
23 |
326 |
2026-08-12T09:20:58.961000Z |
play_count |
5371707 |
LOCAL |
1 |
1020 |
655 |
3324 |
29 |
2 |
0 |
2026-08-12T09:20:58.961000Z |
play_count |
3324 |
LOCAL |
1 |
1021 |
1834 |
17922 |
181 |
53 |
3 |
2026-08-12T09:20:58.961000Z |
play_count |
17922 |
LOCAL |
1 |
1022 |
528 |
10743371 |
32678 |
65 |
716 |
2026-08-12T09:20:58.961000Z |
play_count |
10743371 |
LOCAL |
1 |
1023 |
308 |
8115117 |
259276 |
225 |
5804 |
2026-08-12T09:20:58.961000Z |
play_count |
8115117 |
LOCAL |
1 |
1024 |
1369 |
1117 |
19 |
10 |
1 |
2026-08-12T09:20:58.961000Z |
play_count |
1117 |
LOCAL |
1 |
1025 |
658 |
2247 |
34 |
8 |
0 |
2026-08-12T09:20:58.961000Z |
play_count |
2247 |
LOCAL |
1 |
1026 |
1327 |
3397866 |
83581 |
61 |
339 |
2026-08-12T09:20:58.961000Z |
play_count |
3397866 |
LOCAL |
1 |
1027 |
1692 |
692879 |
27069 |
65 |
300 |
2026-08-12T09:20:58.961000Z |
play_count |
692879 |
LOCAL |
1 |
1028 |
548 |
6692718 |
71355 |
55 |
625 |
2026-08-12T09:20:58.961000Z |
play_count |
6692718 |
LOCAL |
1 |
1029 |
1366 |
402054 |
22928 |
192 |
338 |
2026-08-12T09:20:58.961000Z |
play_count |
402054 |
LOCAL |
1 |
1030 |
1843 |
2512469 |
35607 |
70 |
707 |
2026-08-12T09:20:58.961000Z |
play_count |
2512469 |
LOCAL |
1 |
1031 |
1844 |
37799796 |
625058 |
2173 |
8562 |
2026-08-12T09:20:58.961000Z |
play_count |
37799796 |
LOCAL |
1 |
1032 |
1845 |
82445921 |
294962 |
641 |
12899 |
2026-08-12T09:20:58.961000Z |
play_count |
82445921 |
LOCAL |
1 |
1033 |
553 |
763733 |
11284 |
24 |
168 |
2026-08-12T09:20:58.961000Z |
play_count |
763733 |
LOCAL |
1 |
1034 |
554 |
6785030 |
183061 |
1019 |
5666 |
2026-08-12T09:21:15.133000Z |
play_count |
6785030 |
LOCAL |
1 |
1035 |
1050 |
1121 |
6 |
0 |
0 |
2026-08-12T09:21:15.133000Z |
play_count |
1121 |
LOCAL |
1 |
1036 |
1869 |
3113751 |
15575 |
64 |
377 |
2026-08-12T09:21:15.133000Z |
play_count |
3113751 |
LOCAL |
1 |
1037 |
564 |
11976329 |
49740 |
42 |
570 |
2026-08-12T09:21:15.133000Z |
play_count |
11976329 |
LOCAL |
1 |
1038 |
717 |
628391 |
8467 |
198 |
185 |
2026-08-12T09:21:15.133000Z |
play_count |
628391 |
LOCAL |
1 |
1039 |
617 |
7004129 |
293302 |
155 |
3659 |
2026-08-12T09:21:15.133000Z |
play_count |
7004129 |
LOCAL |
1 |
1040 |
1195 |
31248975 |
94236 |
217 |
9950 |
2026-08-12T09:21:15.133000Z |
play_count |
31248975 |
LOCAL |
1 |
1041 |
1059 |
3215 |
20 |
0 |
0 |
2026-08-12T09:21:15.133000Z |
play_count |
3215 |
LOCAL |
1 |
1042 |
1875 |
8783368 |
45171 |
268 |
682 |
2026-08-12T09:21:15.133000Z |
play_count |
8783368 |
LOCAL |
1 |
1043 |
1876 |
8229420 |
207208 |
162 |
5358 |
2026-08-12T09:21:15.133000Z |
play_count |
8229420 |
LOCAL |
1 |
1044 |
529 |
0 |
666 |
12 |
18 |
2026-08-12T09:21:15.133000Z |
play_count |
678 |
LOCAL |
0 |
1045 |
1878 |
13595198 |
124733 |
141 |
2636 |
2026-08-12T09:21:15.133000Z |
play_count |
13595198 |
LOCAL |
1 |
1046 |
1879 |
21806396 |
151913 |
265 |
2390 |
2026-08-12T09:21:15.133000Z |
play_count |
21806396 |
LOCAL |
1 |
1047 |
549 |
37034287 |
530819 |
517 |
4258 |
2026-08-12T09:21:15.133000Z |
play_count |
37034287 |
LOCAL |
1 |
1048 |
1196 |
1714916 |
13928 |
103 |
203 |
2026-08-12T09:21:15.133000Z |
play_count |
1714916 |
LOCAL |
1 |
1049 |
1335 |
8275713 |
56932 |
233 |
1295 |
2026-08-12T09:21:15.133000Z |
play_count |
8275713 |
LOCAL |
1 |
1050 |
1583 |
1962337 |
39277 |
141 |
575 |
2026-08-12T09:21:15.133000Z |
play_count |
1962337 |
LOCAL |
1 |
1051 |
661 |
0 |
320 |
13 |
12 |
2026-08-12T09:21:15.133000Z |
play_count |
333 |
LOCAL |
0 |
1052 |
1075 |
59149221 |
741556 |
986 |
36563 |
2026-08-12T09:21:15.133000Z |
play_count |
59149221 |
LOCAL |
1 |
1053 |
525 |
8349271 |
91735 |
2201 |
2263 |
2026-08-12T09:21:15.133000Z |
play_count |
8349271 |
LOCAL |
1 |
1054 |
1887 |
15401153 |
204798 |
4460 |
5258 |
2026-08-12T09:21:15.133000Z |
play_count |
15401153 |
LOCAL |
1 |
1055 |
794 |
324465 |
4903 |
87 |
176 |
2026-08-12T09:21:15.133000Z |
play_count |
324465 |
LOCAL |
1 |
1056 |
1889 |
12805035 |
58423 |
77 |
1201 |
2026-08-12T09:21:15.133000Z |
play_count |
12805035 |
LOCAL |
1 |
1057 |
1890 |
2485435 |
76545 |
1109 |
2243 |
2026-08-12T09:21:15.133000Z |
play_count |
2485435 |
LOCAL |
1 |
1058 |
308 |
8115120 |
259276 |
225 |
5804 |
2026-08-12T09:21:53Z |
play_count |
8115120 |
SERVER |
1 |
1059 |
308 |
8115120 |
259276 |
225 |
5804 |
2026-08-12T09:23:03.220Z |
0 |
LOCAL |
0 |
|
1060 |
1369 |
1117 |
19 |
10 |
1 |
2026-08-12T09:31:24.751Z |
0 |
LOCAL |
0 |
|
1061 |
1369 |
1117 |
19 |
10 |
1 |
2026-08-12T09:31:25.768Z |
0 |
LOCAL |
0 |
|
1062 |
1369 |
1117 |
19 |
10 |
1 |
2026-08-12T09:31:27.055Z |
0 |
LOCAL |
0 |
|
1063 |
519 |
6137477 |
32825 |
30 |
554 |
2026-08-12T13:41:08.179000Z |
play_count |
6137477 |
LOCAL |
1 |
1064 |
1678 |
744033 |
33464 |
237 |
542 |
2026-08-12T13:41:08.179000Z |
play_count |
744033 |
LOCAL |
1 |
1065 |
1188 |
396758 |
874 |
23 |
86 |
2026-08-12T13:41:08.179000Z |
play_count |
396758 |
LOCAL |
1 |
1066 |
1069 |
116225952 |
7977842 |
20237 |
196063 |
2026-08-12T13:41:08.179000Z |
play_count |
116225952 |
LOCAL |
1 |
1067 |
1926 |
6198201 |
26658 |
660 |
297 |
2026-08-12T13:41:08.179000Z |
play_count |
6198201 |
LOCAL |
1 |
1068 |
1927 |
3807732 |
14242 |
135 |
311 |
2026-08-12T13:41:08.179000Z |
play_count |
3807732 |
LOCAL |
1 |
1069 |
1325 |
598813 |
11356 |
414 |
0 |
2026-08-12T13:41:08.179000Z |
play_count |
598813 |
LOCAL |
1 |
1070 |
1929 |
3191 |
25 |
5 |
1 |
2026-08-12T13:41:08.179000Z |
play_count |
3191 |
LOCAL |
1 |
1071 |
304 |
47129489 |
550724 |
504 |
13202 |
2026-08-12T13:41:08.179000Z |
play_count |
47129489 |
LOCAL |
1 |
1072 |
1931 |
2889562 |
8382 |
50 |
204 |
2026-08-12T13:41:08.179000Z |
play_count |
2889562 |
LOCAL |
1 |
1073 |
1932 |
1798342 |
35997 |
1792 |
707 |
2026-08-12T13:41:08.179000Z |
play_count |
1798342 |
LOCAL |
1 |
1074 |
1583 |
1964235 |
39310 |
141 |
576 |
2026-08-12T13:41:08.179000Z |
play_count |
1964235 |
LOCAL |
1 |
1075 |
1887 |
15433880 |
205522 |
4470 |
5276 |
2026-08-12T13:41:08.179000Z |
play_count |
15433880 |
LOCAL |
1 |
1076 |
617 |
7030482 |
294551 |
155 |
3672 |
2026-08-12T13:41:08.179000Z |
play_count |
7030482 |
LOCAL |
1 |
1077 |
1372 |
7197671 |
75862 |
604 |
2017 |
2026-08-12T13:41:08.179000Z |
play_count |
7197671 |
LOCAL |
1 |
1078 |
1879 |
21875286 |
152790 |
265 |
2403 |
2026-08-12T13:41:08.179000Z |
play_count |
21875286 |
LOCAL |
1 |
1079 |
1195 |
32164817 |
97167 |
221 |
10230 |
2026-08-12T13:41:08.179000Z |
play_count |
32164817 |
LOCAL |
1 |
1080 |
611 |
2963 |
57 |
73 |
8 |
2026-08-12T13:41:08.179000Z |
play_count |
2963 |
LOCAL |
1 |
1081 |
1940 |
6012 |
31 |
0 |
1 |
2026-08-12T13:41:08.179000Z |
play_count |
6012 |
LOCAL |
1 |
1082 |
1689 |
1519193 |
18267 |
28 |
181 |
2026-08-12T13:41:08.179000Z |
play_count |
1519193 |
LOCAL |
1 |
1083 |
519 |
6279053 |
32825 |
30 |
554 |
2026-08-12T13:41:28Z |
play_count |
6279053 |
SERVER |
1 |
1084 |
1926 |
7046424 |
26658 |
660 |
297 |
2026-08-12T13:41:28Z |
play_count |
7046424 |
SERVER |
1 |
1085 |
1927 |
3807994 |
14242 |
135 |
311 |
2026-08-12T13:41:28Z |
play_count |
3807994 |
SERVER |
1 |
1086 |
1325 |
832503 |
11356 |
414 |
0 |
2026-08-12T13:41:28Z |
play_count |
832503 |
SERVER |
1 |
1087 |
1929 |
3531 |
25 |
5 |
1 |
2026-08-12T13:41:28Z |
play_count |
3531 |
SERVER |
1 |
1088 |
1887 |
15660940 |
205522 |
4470 |
5276 |
2026-08-12T13:41:28Z |
play_count |
15660940 |
SERVER |
1 |
1089 |
617 |
7094902 |
294551 |
155 |
3672 |
2026-08-12T13:41:28Z |
play_count |
7094902 |
SERVER |
1 |
1090 |
1195 |
32249960 |
97167 |
221 |
10230 |
2026-08-12T13:41:28Z |
play_count |
32249960 |
SERVER |
1 |
1091 |
611 |
3392 |
57 |
73 |
8 |
2026-08-12T13:41:28Z |
play_count |
3392 |
SERVER |
1 |
1092 |
1940 |
6248 |
31 |
0 |
1 |
2026-08-12T13:41:28Z |
play_count |
6248 |
SERVER |
1 |
1093 |
1972 |
2165639 |
97743 |
1041 |
994 |
2026-08-12T13:41:53.233000Z |
play_count |
2165639 |
LOCAL |
1 |
1094 |
1973 |
8000595 |
470809 |
1941 |
5536 |
2026-08-12T13:41:53.233000Z |
play_count |
8000595 |
LOCAL |
1 |
1095 |
1974 |
12292 |
219 |
122 |
5 |
2026-08-12T13:41:53.233000Z |
play_count |
12292 |
LOCAL |
1 |
1096 |
1975 |
18758407 |
183009 |
5055 |
2234 |
2026-08-12T13:41:53.233000Z |
play_count |
18758407 |
LOCAL |
1 |
1097 |
1976 |
4028057 |
106936 |
335 |
1233 |
2026-08-12T13:41:53.233000Z |
play_count |
4028057 |
LOCAL |
1 |
1098 |
1339 |
1330630 |
32841 |
254 |
323 |
2026-08-12T13:41:53.233000Z |
play_count |
1330630 |
LOCAL |
1 |
1099 |
1876 |
8305283 |
209707 |
164 |
5409 |
2026-08-12T13:41:53.233000Z |
play_count |
8305283 |
LOCAL |
1 |
1100 |
1232 |
7288473 |
129249 |
77697 |
1351 |
2026-08-12T13:41:53.233000Z |
play_count |
7288473 |
LOCAL |
1 |