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 |
|---|---|---|---|---|---|---|---|---|---|---|
1601 |
2897 |
0 |
9459 |
79 |
162 |
2026-08-14T06:44:18.744000Z |
play_count |
9538 |
LOCAL |
0 |
1602 |
2898 |
0 |
134 |
0 |
0 |
2026-08-14T06:44:18.744000Z |
play_count |
134 |
LOCAL |
0 |
1603 |
2899 |
0 |
672 |
4 |
14 |
2026-08-14T06:44:18.744000Z |
play_count |
676 |
LOCAL |
0 |
1604 |
2900 |
0 |
671 |
2 |
6 |
2026-08-14T06:44:18.744000Z |
play_count |
673 |
LOCAL |
0 |
1605 |
2901 |
0 |
946 |
7 |
20 |
2026-08-14T06:44:18.744000Z |
play_count |
953 |
LOCAL |
0 |
1606 |
2902 |
0 |
1557 |
10 |
14 |
2026-08-14T06:44:18.744000Z |
play_count |
1567 |
LOCAL |
0 |
1607 |
2903 |
0 |
23581 |
112 |
414 |
2026-08-14T06:44:18.744000Z |
play_count |
23693 |
LOCAL |
0 |
1608 |
2904 |
0 |
6725 |
29 |
133 |
2026-08-14T06:44:18.744000Z |
play_count |
6754 |
LOCAL |
0 |
1609 |
1082 |
52136624 |
1266548 |
6375 |
20701 |
2026-08-14T06:44:42Z |
play_count |
52136624 |
SERVER |
1 |
1610 |
2854 |
14011325 |
349166 |
9513 |
12112 |
2026-08-14T06:44:47.618Z |
0 |
LOCAL |
0 |
|
1611 |
1082 |
52136624 |
1266685 |
6376 |
20702 |
2026-08-14T06:45:53Z |
play_count |
1273061 |
SERVER |
1 |
1612 |
2897 |
0 |
9462 |
79 |
162 |
2026-08-14T06:45:53Z |
play_count |
9541 |
SERVER |
0 |
1613 |
1082 |
52142242 |
1266685 |
6376 |
20702 |
2026-08-14T06:45:55Z |
play_count |
52142242 |
SERVER |
1 |
1614 |
2903 |
1823045 |
23581 |
112 |
414 |
2026-08-14T06:45:55Z |
play_count |
1823045 |
SERVER |
1 |
1615 |
2893 |
1113014 |
14359 |
52 |
170 |
2026-08-14T06:45:55Z |
play_count |
1113014 |
SERVER |
1 |
1616 |
2897 |
387327 |
9462 |
79 |
162 |
2026-08-14T06:45:55Z |
play_count |
387327 |
SERVER |
1 |
1617 |
2904 |
343671 |
6725 |
29 |
133 |
2026-08-14T06:45:55Z |
play_count |
343671 |
SERVER |
1 |
1618 |
2901 |
61343 |
946 |
7 |
20 |
2026-08-14T06:45:55Z |
play_count |
61343 |
SERVER |
1 |
1619 |
2902 |
47396 |
1557 |
10 |
14 |
2026-08-14T06:45:55Z |
play_count |
47396 |
SERVER |
1 |
1620 |
2900 |
38111 |
671 |
2 |
6 |
2026-08-14T06:45:55Z |
play_count |
38111 |
SERVER |
1 |
1621 |
2899 |
34485 |
672 |
4 |
14 |
2026-08-14T06:45:55Z |
play_count |
34485 |
SERVER |
1 |
1622 |
2898 |
20172 |
134 |
0 |
0 |
2026-08-14T06:45:55Z |
play_count |
20172 |
SERVER |
1 |
1623 |
2895 |
9679 |
132 |
1 |
3 |
2026-08-14T06:45:55Z |
play_count |
9679 |
SERVER |
1 |
1624 |
2896 |
7359 |
160 |
0 |
1 |
2026-08-14T06:45:55Z |
play_count |
7359 |
SERVER |
1 |
1625 |
2934 |
84297 |
2994 |
11 |
39 |
2026-08-14T06:46:00.520000Z |
play_count |
84297 |
LOCAL |
1 |
1626 |
2928 |
91694 |
3292 |
22 |
62 |
2026-08-14T06:46:00.520000Z |
play_count |
91694 |
LOCAL |
1 |
1627 |
2936 |
91547 |
2946 |
9 |
28 |
2026-08-14T06:46:00.520000Z |
play_count |
91547 |
LOCAL |
1 |
1628 |
2938 |
100125 |
1753 |
8 |
33 |
2026-08-14T06:46:00.520000Z |
play_count |
100125 |
LOCAL |
1 |
1629 |
2939 |
77854 |
3096 |
12 |
47 |
2026-08-14T06:46:00.520000Z |
play_count |
77854 |
LOCAL |
1 |
1630 |
2940 |
70125 |
1230 |
4 |
18 |
2026-08-14T06:46:00.520000Z |
play_count |
70125 |
LOCAL |
1 |
1631 |
2941 |
68511 |
2089 |
6 |
23 |
2026-08-14T06:46:00.520000Z |
play_count |
68511 |
LOCAL |
1 |
1632 |
2942 |
76125 |
1264 |
10 |
19 |
2026-08-14T06:46:00.520000Z |
play_count |
76125 |
LOCAL |
1 |
1633 |
2943 |
82107 |
1468 |
19 |
17 |
2026-08-14T06:46:00.520000Z |
play_count |
82107 |
LOCAL |
1 |
1634 |
2945 |
73307 |
2272 |
13 |
19 |
2026-08-14T06:46:00.520000Z |
play_count |
73307 |
LOCAL |
1 |
1635 |
2946 |
78217 |
1638 |
4 |
49 |
2026-08-14T06:46:00.520000Z |
play_count |
78217 |
LOCAL |
1 |
1636 |
2947 |
366940 |
7062 |
27 |
116 |
2026-08-14T06:46:00.520000Z |
play_count |
366940 |
LOCAL |
1 |
1637 |
2948 |
0 |
1016 |
5 |
20 |
2026-08-14T06:46:00.520000Z |
play_count |
1021 |
LOCAL |
0 |
1638 |
2949 |
0 |
3069 |
12 |
54 |
2026-08-14T06:46:00.520000Z |
play_count |
3081 |
LOCAL |
0 |
1639 |
2950 |
0 |
1857 |
9 |
33 |
2026-08-14T06:46:00.520000Z |
play_count |
1866 |
LOCAL |
0 |
1640 |
2952 |
0 |
961 |
16 |
19 |
2026-08-14T06:46:00.520000Z |
play_count |
977 |
LOCAL |
0 |
1641 |
2953 |
0 |
1540 |
7 |
26 |
2026-08-14T06:46:00.520000Z |
play_count |
1547 |
LOCAL |
0 |
1642 |
2954 |
0 |
672 |
3 |
13 |
2026-08-14T06:46:00.520000Z |
play_count |
675 |
LOCAL |
0 |
1643 |
2955 |
0 |
1231 |
6 |
19 |
2026-08-14T06:46:00.520000Z |
play_count |
1237 |
LOCAL |
0 |
1644 |
2956 |
0 |
1226 |
12 |
22 |
2026-08-14T06:46:00.520000Z |
play_count |
1238 |
LOCAL |
0 |
1645 |
2957 |
0 |
4254 |
17 |
138 |
2026-08-14T06:46:00.520000Z |
play_count |
4271 |
LOCAL |
0 |
1646 |
2958 |
0 |
896 |
4 |
11 |
2026-08-14T06:46:00.520000Z |
play_count |
900 |
LOCAL |
0 |
1647 |
2959 |
0 |
559 |
3 |
13 |
2026-08-14T06:46:00.520000Z |
play_count |
562 |
LOCAL |
0 |
1648 |
2949 |
219761 |
3069 |
12 |
54 |
2026-08-14T06:46:12Z |
play_count |
219761 |
SERVER |
1 |
1649 |
2957 |
159880 |
4254 |
17 |
138 |
2026-08-14T06:46:12Z |
play_count |
159880 |
SERVER |
1 |
1650 |
2953 |
79398 |
1540 |
7 |
26 |
2026-08-14T06:46:12Z |
play_count |
79398 |
SERVER |
1 |
1651 |
2950 |
60546 |
1857 |
9 |
33 |
2026-08-14T06:46:12Z |
play_count |
60546 |
SERVER |
1 |
1652 |
2948 |
56223 |
1016 |
5 |
20 |
2026-08-14T06:46:12Z |
play_count |
56223 |
SERVER |
1 |
1653 |
2952 |
52572 |
961 |
16 |
19 |
2026-08-14T06:46:12Z |
play_count |
52572 |
SERVER |
1 |
1654 |
2955 |
46974 |
1231 |
6 |
19 |
2026-08-14T06:46:12Z |
play_count |
46974 |
SERVER |
1 |
1655 |
2956 |
46746 |
1226 |
12 |
22 |
2026-08-14T06:46:12Z |
play_count |
46746 |
SERVER |
1 |
1656 |
2954 |
46074 |
672 |
3 |
13 |
2026-08-14T06:46:12Z |
play_count |
46074 |
SERVER |
1 |
1657 |
2959 |
40133 |
559 |
3 |
13 |
2026-08-14T06:46:12Z |
play_count |
40133 |
SERVER |
1 |
1658 |
2958 |
37795 |
896 |
4 |
11 |
2026-08-14T06:46:12Z |
play_count |
37795 |
SERVER |
1 |
1659 |
1082 |
52142242 |
1266798 |
6376 |
20703 |
2026-08-14T06:49:12Z |
play_count |
1273174 |
SERVER |
1 |
1660 |
2903 |
1823045 |
23582 |
112 |
414 |
2026-08-14T06:49:12Z |
play_count |
23694 |
SERVER |
1 |
1661 |
2897 |
387327 |
9466 |
79 |
162 |
2026-08-14T06:49:12Z |
play_count |
9545 |
SERVER |
1 |
1662 |
2899 |
34485 |
673 |
4 |
14 |
2026-08-14T06:49:12Z |
play_count |
677 |
SERVER |
1 |
1663 |
2896 |
7359 |
161 |
0 |
1 |
2026-08-14T06:49:12Z |
play_count |
161 |
SERVER |
1 |
1664 |
2895 |
9679 |
133 |
1 |
3 |
2026-08-14T06:49:12Z |
play_count |
134 |
SERVER |
1 |
1665 |
1082 |
52146619 |
1266799 |
6376 |
20703 |
2026-08-14T06:49:15Z |
play_count |
52146619 |
SERVER |
1 |
1666 |
2903 |
1823321 |
23582 |
112 |
414 |
2026-08-14T06:49:15Z |
play_count |
1823321 |
SERVER |
1 |
1667 |
2893 |
1113018 |
14359 |
52 |
170 |
2026-08-14T06:49:15Z |
play_count |
1113018 |
SERVER |
1 |
1668 |
2897 |
387469 |
9466 |
79 |
162 |
2026-08-14T06:49:15Z |
play_count |
387469 |
SERVER |
1 |
1669 |
2904 |
343708 |
6725 |
29 |
133 |
2026-08-14T06:49:15Z |
play_count |
343708 |
SERVER |
1 |
1670 |
2901 |
61352 |
946 |
7 |
20 |
2026-08-14T06:49:15Z |
play_count |
61352 |
SERVER |
1 |
1671 |
2902 |
47402 |
1557 |
10 |
14 |
2026-08-14T06:49:15Z |
play_count |
47402 |
SERVER |
1 |
1672 |
2900 |
38117 |
671 |
2 |
6 |
2026-08-14T06:49:15Z |
play_count |
38117 |
SERVER |
1 |
1673 |
2899 |
34492 |
673 |
4 |
14 |
2026-08-14T06:49:15Z |
play_count |
34492 |
SERVER |
1 |
1674 |
2898 |
20178 |
134 |
0 |
0 |
2026-08-14T06:49:15Z |
play_count |
20178 |
SERVER |
1 |
1675 |
2895 |
9705 |
133 |
1 |
3 |
2026-08-14T06:49:15Z |
play_count |
9705 |
SERVER |
1 |
1676 |
2896 |
7363 |
161 |
0 |
1 |
2026-08-14T06:49:15Z |
play_count |
7363 |
SERVER |
1 |
1677 |
3014 |
13010 |
74 |
202 |
15 |
2026-08-14T07:02:44.707000Z |
play_count |
13010 |
LOCAL |
1 |
1678 |
291 |
110688 |
1102 |
419 |
20 |
2026-08-14T07:02:44.707000Z |
play_count |
110688 |
LOCAL |
1 |
1679 |
3016 |
789627 |
22640 |
172 |
574 |
2026-08-14T07:02:44.707000Z |
play_count |
789627 |
LOCAL |
1 |
1680 |
1069 |
118149126 |
8081786 |
20500 |
198283 |
2026-08-14T07:02:44.707000Z |
play_count |
118149126 |
LOCAL |
1 |
1681 |
610 |
456400 |
2344 |
36 |
167 |
2026-08-14T07:02:44.707000Z |
play_count |
456400 |
LOCAL |
1 |
1682 |
2561 |
541206 |
5510 |
110 |
126 |
2026-08-14T07:02:44.707000Z |
play_count |
541206 |
LOCAL |
1 |
1683 |
3020 |
2291482 |
60364 |
470 |
1629 |
2026-08-14T07:02:44.707000Z |
play_count |
2291482 |
LOCAL |
1 |
1684 |
3021 |
30388460 |
2203379 |
10268 |
50162 |
2026-08-14T07:02:44.707000Z |
play_count |
30388460 |
LOCAL |
1 |
1685 |
1337 |
10709740 |
114356 |
2009 |
5955 |
2026-08-14T07:02:44.707000Z |
play_count |
10709740 |
LOCAL |
1 |
1686 |
2112 |
2779625 |
98883 |
327 |
1863 |
2026-08-14T07:02:44.707000Z |
play_count |
2779625 |
LOCAL |
1 |
1687 |
3024 |
593393 |
5210 |
68 |
93 |
2026-08-14T07:02:44.707000Z |
play_count |
593393 |
LOCAL |
1 |
1688 |
709 |
8977354 |
213067 |
3256 |
4510 |
2026-08-14T07:02:44.707000Z |
play_count |
8977354 |
LOCAL |
1 |
1689 |
717 |
684452 |
9225 |
200 |
206 |
2026-08-14T07:02:44.707000Z |
play_count |
684452 |
LOCAL |
1 |
1690 |
3027 |
1628102 |
43456 |
230 |
642 |
2026-08-14T07:02:44.707000Z |
play_count |
1628102 |
LOCAL |
1 |
1691 |
2111 |
498358 |
10731 |
253 |
115 |
2026-08-14T07:02:44.707000Z |
play_count |
498358 |
LOCAL |
1 |
1692 |
663 |
26830496 |
533991 |
716 |
20562 |
2026-08-14T07:02:44.707000Z |
play_count |
26830496 |
LOCAL |
1 |
1693 |
2526 |
472141 |
10048 |
282 |
172 |
2026-08-14T07:02:44.707000Z |
play_count |
472141 |
LOCAL |
1 |
1694 |
3031 |
4470149 |
27804 |
324 |
1247 |
2026-08-14T07:02:44.707000Z |
play_count |
4470149 |
LOCAL |
1 |
1695 |
1879 |
22402115 |
161182 |
290 |
2507 |
2026-08-14T07:02:44.707000Z |
play_count |
22402115 |
LOCAL |
1 |
1696 |
2034 |
5887208 |
51770 |
635 |
1063 |
2026-08-14T07:02:44.707000Z |
play_count |
5887208 |
LOCAL |
1 |
1697 |
2299 |
325373 |
6928 |
881 |
90 |
2026-08-14T07:04:55.410000Z |
play_count |
325373 |
LOCAL |
1 |
1698 |
3035 |
462227 |
10152 |
99 |
287 |
2026-08-14T07:04:55.410000Z |
play_count |
462227 |
LOCAL |
1 |
1699 |
3036 |
188123 |
1153 |
28 |
25 |
2026-08-14T07:04:55.410000Z |
play_count |
188123 |
LOCAL |
1 |
1700 |
3037 |
2079975 |
22027 |
179 |
206 |
2026-08-14T07:04:55.410000Z |
play_count |
2079975 |
LOCAL |
1 |