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 |
|---|---|---|---|---|---|---|---|---|---|---|
1701 |
3038 |
361394 |
5493 |
2956 |
58 |
2026-08-14T07:04:55.410000Z |
play_count |
361394 |
LOCAL |
1 |
1702 |
3039 |
5766848 |
112148 |
265 |
836 |
2026-08-14T07:04:55.410000Z |
play_count |
5766848 |
LOCAL |
1 |
1703 |
3040 |
741520 |
8049 |
458 |
169 |
2026-08-14T07:04:55.410000Z |
play_count |
741520 |
LOCAL |
1 |
1704 |
3041 |
5076240 |
13369 |
424 |
299 |
2026-08-14T07:04:55.410000Z |
play_count |
5076240 |
LOCAL |
1 |
1705 |
3042 |
5320345 |
27091 |
35 |
495 |
2026-08-14T07:04:55.410000Z |
play_count |
5320345 |
LOCAL |
1 |
1706 |
605 |
4244653 |
17209 |
219 |
1005 |
2026-08-14T07:04:55.410000Z |
play_count |
4244653 |
LOCAL |
1 |
1707 |
3044 |
2892916 |
25125 |
19254 |
296 |
2026-08-14T07:04:55.410000Z |
play_count |
2892916 |
LOCAL |
1 |
1708 |
3045 |
2014117 |
15839 |
2011 |
115 |
2026-08-14T07:04:55.410000Z |
play_count |
2014117 |
LOCAL |
1 |
1709 |
2308 |
1077308 |
7350 |
2594 |
36 |
2026-08-14T07:04:55.410000Z |
play_count |
1077308 |
LOCAL |
1 |
1710 |
3047 |
3221049 |
64377 |
340 |
2376 |
2026-08-14T07:04:55.410000Z |
play_count |
3221049 |
LOCAL |
1 |
1711 |
3048 |
787607 |
5159 |
69 |
140 |
2026-08-14T07:04:55.410000Z |
play_count |
787607 |
LOCAL |
1 |
1712 |
3049 |
494 |
6 |
15 |
1 |
2026-08-14T07:04:55.410000Z |
play_count |
494 |
LOCAL |
1 |
1713 |
604 |
2506348 |
28663 |
2571 |
797 |
2026-08-14T07:04:55.410000Z |
play_count |
2506348 |
LOCAL |
1 |
1714 |
3052 |
21289702 |
205433 |
3145 |
7862 |
2026-08-14T07:04:55.410000Z |
play_count |
21289702 |
LOCAL |
1 |
1715 |
672 |
8118180 |
37337 |
2305 |
0 |
2026-08-14T07:04:55.410000Z |
play_count |
8118180 |
LOCAL |
1 |
1716 |
3054 |
2549716 |
192374 |
1446 |
1955 |
2026-08-14T07:04:55.410000Z |
play_count |
2549716 |
LOCAL |
1 |
1717 |
2865 |
107660668 |
3260336 |
17175 |
50284 |
2026-08-14T07:05:04.550Z |
0 |
LOCAL |
0 |
|
1718 |
2893 |
1113035 |
14359 |
52 |
170 |
2026-08-14T07:05:21.478000Z |
play_count |
1113035 |
LOCAL |
1 |
1719 |
1082 |
52171811 |
1267409 |
6376 |
20710 |
2026-08-14T07:05:21.478000Z |
play_count |
52171811 |
LOCAL |
1 |
1720 |
2895 |
9860 |
136 |
1 |
3 |
2026-08-14T07:05:21.478000Z |
play_count |
9860 |
LOCAL |
1 |
1721 |
1082 |
52171811 |
1267409 |
6376 |
20710 |
2026-08-14T07:05:20.852Z |
0 |
LOCAL |
0 |
|
1722 |
2896 |
7410 |
163 |
0 |
1 |
2026-08-14T07:05:21.478000Z |
play_count |
7410 |
LOCAL |
1 |
1723 |
2897 |
388258 |
9493 |
79 |
162 |
2026-08-14T07:05:21.478000Z |
play_count |
388258 |
LOCAL |
1 |
1724 |
2898 |
20227 |
135 |
0 |
0 |
2026-08-14T07:05:21.478000Z |
play_count |
20227 |
LOCAL |
1 |
1725 |
2899 |
34545 |
676 |
4 |
14 |
2026-08-14T07:05:21.478000Z |
play_count |
34545 |
LOCAL |
1 |
1726 |
2900 |
38148 |
674 |
2 |
6 |
2026-08-14T07:05:21.478000Z |
play_count |
38148 |
LOCAL |
1 |
1727 |
2901 |
61393 |
947 |
7 |
20 |
2026-08-14T07:05:21.478000Z |
play_count |
61393 |
LOCAL |
1 |
1728 |
2902 |
47440 |
1557 |
10 |
14 |
2026-08-14T07:05:21.478000Z |
play_count |
47440 |
LOCAL |
1 |
1729 |
2903 |
1824706 |
23596 |
112 |
414 |
2026-08-14T07:05:21.478000Z |
play_count |
1824706 |
LOCAL |
1 |
1730 |
2904 |
343865 |
6734 |
29 |
133 |
2026-08-14T07:05:21.478000Z |
play_count |
343865 |
LOCAL |
1 |
1731 |
3038 |
361394 |
5493 |
2956 |
58 |
2026-08-14T07:11:56.216Z |
0 |
LOCAL |
0 |
|
1732 |
3103 |
26825 |
207 |
16 |
7 |
2026-08-14T07:46:10.873000Z |
play_count |
26825 |
LOCAL |
1 |
1733 |
3104 |
18220 |
3 |
1 |
1 |
2026-08-14T07:46:10.873000Z |
play_count |
18220 |
LOCAL |
1 |
1734 |
3105 |
723559 |
3792 |
145 |
29 |
2026-08-14T07:46:10.873000Z |
play_count |
723559 |
LOCAL |
1 |
1735 |
2352 |
46571025 |
260440 |
325 |
9009 |
2026-08-14T07:46:10.873000Z |
play_count |
46571025 |
LOCAL |
1 |
1736 |
2372 |
4039769 |
150429 |
234 |
2141 |
2026-08-14T07:46:10.873000Z |
play_count |
4039769 |
LOCAL |
1 |
1737 |
3108 |
305881 |
4378 |
102 |
94 |
2026-08-14T07:46:10.873000Z |
play_count |
305881 |
LOCAL |
1 |
1738 |
3109 |
6630 |
24 |
53 |
8 |
2026-08-14T07:46:10.873000Z |
play_count |
6630 |
LOCAL |
1 |
1739 |
1887 |
15882202 |
210349 |
4697 |
5394 |
2026-08-14T07:46:10.873000Z |
play_count |
15882202 |
LOCAL |
1 |
1740 |
3111 |
551180 |
5978 |
190 |
171 |
2026-08-14T07:46:10.873000Z |
play_count |
551180 |
LOCAL |
1 |
1741 |
2650 |
236472036 |
9844043 |
10726 |
162311 |
2026-08-14T07:46:10.873000Z |
play_count |
236472036 |
LOCAL |
1 |
1742 |
2365 |
512253 |
13794 |
118 |
387 |
2026-08-14T07:46:10.873000Z |
play_count |
512253 |
LOCAL |
1 |
1743 |
3114 |
11448278 |
239400 |
302 |
3236 |
2026-08-14T07:46:10.873000Z |
play_count |
11448278 |
LOCAL |
1 |
1744 |
549 |
40472835 |
590105 |
569 |
4753 |
2026-08-14T07:46:10.873000Z |
play_count |
40472835 |
LOCAL |
1 |
1745 |
3116 |
4010263 |
18963 |
55 |
637 |
2026-08-14T07:46:10.873000Z |
play_count |
4010263 |
LOCAL |
1 |
1746 |
3117 |
34182044 |
426123 |
1469 |
3884 |
2026-08-14T07:46:10.873000Z |
play_count |
34182044 |
LOCAL |
1 |
1747 |
602 |
7645639 |
154171 |
911 |
2537 |
2026-08-14T07:46:10.873000Z |
play_count |
7645639 |
LOCAL |
1 |
1748 |
1083 |
85737039 |
5214200 |
14757 |
146663 |
2026-08-14T07:46:10.873000Z |
play_count |
85737039 |
LOCAL |
1 |
1749 |
3120 |
116773 |
1454 |
130 |
58 |
2026-08-14T07:46:10.873000Z |
play_count |
116773 |
LOCAL |
1 |
1750 |
3121 |
18935936 |
546767 |
1468 |
8010 |
2026-08-14T07:46:10.873000Z |
play_count |
18935936 |
LOCAL |
1 |
1751 |
3122 |
1249984 |
29254 |
140 |
396 |
2026-08-14T07:46:10.873000Z |
play_count |
1249984 |
LOCAL |
1 |
1752 |
2650 |
236472036 |
9844043 |
10726 |
162311 |
2026-08-14T07:48:16.472Z |
0 |
LOCAL |
0 |
|
1753 |
3144 |
1262145 |
25753 |
80 |
461 |
2026-08-14T12:56:45.999000Z |
play_count |
1262145 |
LOCAL |
1 |
1754 |
3145 |
10590632 |
446826 |
1425 |
3992 |
2026-08-14T12:56:45.999000Z |
play_count |
10590632 |
LOCAL |
1 |
1755 |
1680 |
1016922 |
18895 |
286 |
337 |
2026-08-14T12:56:45.999000Z |
play_count |
1016922 |
LOCAL |
1 |
1756 |
3147 |
749154341 |
22450022 |
82042 |
682909 |
2026-08-14T12:56:45.999000Z |
play_count |
749154341 |
LOCAL |
1 |
1757 |
1155 |
2416008 |
33592 |
403 |
688 |
2026-08-14T12:56:45.999000Z |
play_count |
2416008 |
LOCAL |
1 |
1758 |
1879 |
22457684 |
162044 |
291 |
2518 |
2026-08-14T12:56:45.999000Z |
play_count |
22457684 |
LOCAL |
1 |
1759 |
1585 |
2749079 |
20463 |
87 |
592 |
2026-08-14T12:56:45.999000Z |
play_count |
2749079 |
LOCAL |
1 |
1760 |
3151 |
16330923 |
260146 |
694 |
10231 |
2026-08-14T12:56:45.999000Z |
play_count |
16330923 |
LOCAL |
1 |
1761 |
2255 |
10579398 |
91402 |
647 |
1854 |
2026-08-14T12:56:45.999000Z |
play_count |
10579398 |
LOCAL |
1 |
1762 |
1421 |
149263837 |
630856 |
2419 |
30715 |
2026-08-14T12:56:45.999000Z |
play_count |
149263837 |
LOCAL |
1 |
1763 |
1083 |
86076212 |
5236231 |
14820 |
147339 |
2026-08-14T12:56:45.999000Z |
play_count |
86076212 |
LOCAL |
1 |
1764 |
1383 |
93746151 |
6015634 |
16714 |
112476 |
2026-08-14T12:56:45.999000Z |
play_count |
93746151 |
LOCAL |
1 |
1765 |
307 |
1902361 |
31348 |
141 |
485 |
2026-08-14T12:56:45.999000Z |
play_count |
1902361 |
LOCAL |
1 |
1766 |
717 |
692561 |
9322 |
203 |
210 |
2026-08-14T12:56:45.999000Z |
play_count |
692561 |
LOCAL |
1 |
1767 |
1341 |
30914 |
302 |
23 |
9 |
2026-08-14T12:56:45.999000Z |
play_count |
30914 |
LOCAL |
1 |
1768 |
1251 |
3810501 |
46167 |
66 |
840 |
2026-08-14T12:56:45.999000Z |
play_count |
3810501 |
LOCAL |
1 |
1769 |
532 |
7461671 |
45128 |
2084 |
808 |
2026-08-14T12:56:45.999000Z |
play_count |
7461671 |
LOCAL |
1 |
1770 |
3161 |
95027022 |
11799006 |
40303 |
265027 |
2026-08-14T12:56:45.999000Z |
play_count |
95027022 |
LOCAL |
1 |
1771 |
1843 |
2542286 |
36349 |
72 |
719 |
2026-08-14T12:56:45.999000Z |
play_count |
2542286 |
LOCAL |
1 |
1772 |
3163 |
539792 |
12347 |
49 |
182 |
2026-08-14T12:56:45.999000Z |
play_count |
539792 |
LOCAL |
1 |
1773 |
531 |
19743351 |
421354 |
3897 |
13835 |
2026-08-15T04:38:11.840000Z |
play_count |
19743351 |
LOCAL |
1 |
1774 |
1213 |
6110136 |
49643 |
188 |
1179 |
2026-08-15T04:38:11.840000Z |
play_count |
6110136 |
LOCAL |
1 |
1775 |
3226 |
18561628 |
94769 |
1231 |
2799 |
2026-08-15T04:38:11.840000Z |
play_count |
18561628 |
LOCAL |
1 |
1776 |
290 |
48851684 |
1606842 |
1694 |
33485 |
2026-08-15T04:38:11.840000Z |
play_count |
48851684 |
LOCAL |
1 |
1777 |
3228 |
15431450 |
71719 |
153 |
2769 |
2026-08-15T04:38:11.840000Z |
play_count |
15431450 |
LOCAL |
1 |
1778 |
1456 |
36609998 |
158086 |
545 |
1726 |
2026-08-15T04:38:11.840000Z |
play_count |
36609998 |
LOCAL |
1 |
1779 |
2871 |
4731736 |
257571 |
12069 |
4814 |
2026-08-15T04:38:11.840000Z |
play_count |
4731736 |
LOCAL |
1 |
1780 |
2764 |
35866078 |
429119 |
1567 |
9304 |
2026-08-15T04:38:11.840000Z |
play_count |
35866078 |
LOCAL |
1 |
1781 |
3232 |
18327572 |
154550 |
305 |
3571 |
2026-08-15T04:38:11.840000Z |
play_count |
18327572 |
LOCAL |
1 |
1782 |
1337 |
10729578 |
114708 |
2019 |
5971 |
2026-08-15T04:38:11.840000Z |
play_count |
10729578 |
LOCAL |
1 |
1783 |
894 |
15173060 |
57979 |
210 |
1114 |
2026-08-15T04:38:11.840000Z |
play_count |
15173060 |
LOCAL |
1 |
1784 |
3031 |
7768653 |
51890 |
610 |
2289 |
2026-08-15T04:38:11.840000Z |
play_count |
7768653 |
LOCAL |
1 |
1785 |
3236 |
139570494 |
2149925 |
6581 |
51347 |
2026-08-15T04:38:11.840000Z |
play_count |
139570494 |
LOCAL |
1 |
1786 |
3237 |
36909122 |
357509 |
1159 |
11215 |
2026-08-15T04:38:11.840000Z |
play_count |
36909122 |
LOCAL |
1 |
1787 |
2161 |
10744269 |
155408 |
1695 |
8693 |
2026-08-15T04:38:11.840000Z |
play_count |
10744269 |
LOCAL |
1 |
1788 |
610 |
457026 |
2347 |
36 |
167 |
2026-08-15T04:38:11.840000Z |
play_count |
457026 |
LOCAL |
1 |
1789 |
3252 |
1824172 |
5297 |
123 |
511 |
2026-08-15T04:39:41.904000Z |
play_count |
1824172 |
LOCAL |
1 |
1790 |
3253 |
31548268 |
287728 |
1514 |
5318 |
2026-08-15T04:39:41.904000Z |
play_count |
31548268 |
LOCAL |
1 |
1791 |
3254 |
46270670 |
1448392 |
2812 |
46302 |
2026-08-15T04:39:41.904000Z |
play_count |
46270670 |
LOCAL |
1 |
1792 |
3255 |
681502 |
18912 |
67 |
301 |
2026-08-15T04:39:41.904000Z |
play_count |
681502 |
LOCAL |
1 |
1793 |
3237 |
36909180 |
357510 |
1159 |
11215 |
2026-08-15T04:39:41.904000Z |
play_count |
36909180 |
LOCAL |
1 |
1794 |
3257 |
1955331 |
81900 |
903 |
2042 |
2026-08-15T04:39:41.904000Z |
play_count |
1955331 |
LOCAL |
1 |
1795 |
3021 |
31713967 |
2304468 |
10554 |
53292 |
2026-08-15T04:39:41.904000Z |
play_count |
31713967 |
LOCAL |
1 |
1796 |
1085 |
151048122 |
3903688 |
16226 |
96216 |
2026-08-15T04:39:41.904000Z |
play_count |
151048122 |
LOCAL |
1 |
1797 |
714 |
2401970 |
29184 |
151 |
586 |
2026-08-15T04:39:41.904000Z |
play_count |
2401970 |
LOCAL |
1 |
1798 |
3262 |
8657 |
128 |
23 |
4 |
2026-08-15T04:39:41.904000Z |
play_count |
8657 |
LOCAL |
1 |
1799 |
1376 |
691405 |
19401 |
470 |
562 |
2026-08-15T04:39:41.904000Z |
play_count |
691405 |
LOCAL |
1 |
1800 |
3264 |
20761475 |
308063 |
859 |
4804 |
2026-08-15T04:39:41.904000Z |
play_count |
20761475 |
LOCAL |
1 |