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 |
|---|---|---|---|---|---|---|---|---|---|---|
1801 |
1980 |
49858785 |
1875419 |
8324 |
49220 |
2026-08-15T04:39:41.904000Z |
play_count |
49858785 |
LOCAL |
1 |
1802 |
2821 |
441910 |
3767 |
67 |
426 |
2026-08-15T04:39:41.904000Z |
play_count |
441910 |
LOCAL |
1 |
1803 |
302 |
309316737 |
5781694 |
64076 |
103534 |
2026-08-15T04:39:41.904000Z |
play_count |
309316737 |
LOCAL |
1 |
1804 |
1876 |
8805255 |
227949 |
203 |
5758 |
2026-08-15T04:39:41.904000Z |
play_count |
8805255 |
LOCAL |
1 |
1805 |
3269 |
1434939 |
49912 |
150 |
1054 |
2026-08-15T04:39:41.904000Z |
play_count |
1434939 |
LOCAL |
1 |
1806 |
672 |
8141071 |
37482 |
2313 |
0 |
2026-08-15T04:39:41.904000Z |
play_count |
8141071 |
LOCAL |
1 |
1807 |
3271 |
12981 |
51 |
75 |
12 |
2026-08-15T04:39:41.904000Z |
play_count |
12981 |
LOCAL |
1 |
1808 |
3255 |
898292 |
18912 |
67 |
301 |
2026-08-15T04:39:58.933000Z |
play_count |
898292 |
LOCAL |
1 |
1809 |
1085 |
151859140 |
3903688 |
16226 |
96216 |
2026-08-15T04:39:58.933000Z |
play_count |
151859140 |
LOCAL |
1 |
1810 |
610 |
458441 |
2347 |
36 |
167 |
2026-08-15T04:39:58.933000Z |
play_count |
458441 |
LOCAL |
1 |
1811 |
714 |
2402004 |
29184 |
151 |
586 |
2026-08-15T04:39:58.933000Z |
play_count |
2402004 |
LOCAL |
1 |
1812 |
3262 |
12768 |
128 |
23 |
4 |
2026-08-15T04:39:58.933000Z |
play_count |
12768 |
LOCAL |
1 |
1813 |
3264 |
21953403 |
308063 |
859 |
4804 |
2026-08-15T04:39:58.933000Z |
play_count |
21953403 |
LOCAL |
1 |
1814 |
2821 |
449956 |
3767 |
67 |
426 |
2026-08-15T04:39:58.933000Z |
play_count |
449956 |
LOCAL |
1 |
1815 |
3271 |
19339 |
51 |
75 |
12 |
2026-08-15T04:39:58.933000Z |
play_count |
19339 |
LOCAL |
1 |
1816 |
3280 |
2138683 |
41303 |
214 |
1164 |
2026-08-15T04:40:07.790000Z |
play_count |
2138683 |
LOCAL |
1 |
1817 |
1232 |
7367954 |
130438 |
79187 |
1369 |
2026-08-15T04:40:07.790000Z |
play_count |
7367954 |
LOCAL |
1 |
1818 |
3282 |
10089 |
71 |
119 |
8 |
2026-08-15T04:40:07.790000Z |
play_count |
10089 |
LOCAL |
1 |
1819 |
3283 |
95245 |
549 |
505 |
18 |
2026-08-15T04:40:07.790000Z |
play_count |
95245 |
LOCAL |
1 |
1820 |
3284 |
1431782 |
72425 |
741 |
1310 |
2026-08-15T04:40:07.790000Z |
play_count |
1431782 |
LOCAL |
1 |
1821 |
3285 |
97255289 |
5804381 |
9838 |
3753 |
2026-08-15T04:40:07.790000Z |
play_count |
97255289 |
LOCAL |
1 |
1822 |
2112 |
2842920 |
101136 |
332 |
1923 |
2026-08-15T04:40:07.790000Z |
play_count |
2842920 |
LOCAL |
1 |
1823 |
1196 |
1797117 |
14632 |
104 |
214 |
2026-08-15T04:40:07.790000Z |
play_count |
1797117 |
LOCAL |
1 |
1824 |
3288 |
54213485 |
2744492 |
8381 |
66382 |
2026-08-15T04:40:07.790000Z |
play_count |
54213485 |
LOCAL |
1 |
1825 |
3289 |
22679320 |
159883 |
629 |
1715 |
2026-08-15T04:40:07.790000Z |
play_count |
22679320 |
LOCAL |
1 |
1826 |
3290 |
395867 |
1302 |
221 |
32 |
2026-08-15T04:40:07.790000Z |
play_count |
395867 |
LOCAL |
1 |
1827 |
3291 |
10101078 |
379305 |
1835 |
4586 |
2026-08-15T04:40:07.790000Z |
play_count |
10101078 |
LOCAL |
1 |
1828 |
3292 |
50346703 |
1615546 |
4458 |
31217 |
2026-08-15T04:40:07.790000Z |
play_count |
50346703 |
LOCAL |
1 |
1829 |
1083 |
85546907 |
5282575 |
14935 |
148941 |
2026-08-15T04:40:07.790000Z |
play_count |
85546907 |
LOCAL |
1 |
1830 |
3294 |
484267 |
28289 |
838 |
438 |
2026-08-15T04:40:07.790000Z |
play_count |
484267 |
LOCAL |
1 |
1831 |
602 |
7667453 |
155152 |
924 |
2555 |
2026-08-15T04:40:07.790000Z |
play_count |
7667453 |
LOCAL |
1 |
1832 |
3027 |
1697161 |
45118 |
237 |
666 |
2026-08-15T04:40:07.790000Z |
play_count |
1697161 |
LOCAL |
1 |
1833 |
3297 |
180585439 |
4285827 |
5760 |
84606 |
2026-08-15T04:40:07.790000Z |
play_count |
180585439 |
LOCAL |
1 |
1834 |
307 |
1906520 |
31399 |
141 |
488 |
2026-08-15T04:40:07.790000Z |
play_count |
1906520 |
LOCAL |
1 |
1835 |
3299 |
7349209 |
141982 |
749 |
3120 |
2026-08-15T04:40:07.790000Z |
play_count |
7349209 |
LOCAL |
1 |
1836 |
2799 |
52470904 |
793141 |
1123 |
21228 |
2026-08-15T04:41:45.036Z |
0 |
LOCAL |
0 |
|
1837 |
3301 |
101163 |
1663 |
3721 |
129 |
2026-08-15T04:41:59.380000Z |
play_count |
101163 |
LOCAL |
1 |
1838 |
290 |
48851758 |
1606845 |
1694 |
33485 |
2026-08-15T04:41:59.380000Z |
play_count |
48851758 |
LOCAL |
1 |
1839 |
3304 |
10003487 |
58568 |
297 |
970 |
2026-08-15T04:41:59.380000Z |
play_count |
10003487 |
LOCAL |
1 |
1840 |
2075 |
32590848 |
52623 |
256 |
1155 |
2026-08-15T04:41:59.380000Z |
play_count |
32590848 |
LOCAL |
1 |
1841 |
3306 |
4249364 |
125344 |
266 |
1513 |
2026-08-15T04:41:59.380000Z |
play_count |
4249364 |
LOCAL |
1 |
1842 |
2575 |
46855391 |
555730 |
813 |
13151 |
2026-08-15T04:41:59.380000Z |
play_count |
46855391 |
LOCAL |
1 |
1843 |
3308 |
40234 |
460 |
13 |
45 |
2026-08-15T04:41:59.380000Z |
play_count |
40234 |
LOCAL |
1 |
1844 |
3309 |
141221249 |
5862337 |
25861 |
146321 |
2026-08-15T04:41:59.380000Z |
play_count |
141221249 |
LOCAL |
1 |
1845 |
654 |
310623 |
1529 |
89 |
28 |
2026-08-15T04:41:59.380000Z |
play_count |
310623 |
LOCAL |
1 |
1846 |
2172 |
16280911 |
505281 |
723 |
30409 |
2026-08-15T04:41:59.380000Z |
play_count |
16280911 |
LOCAL |
1 |
1847 |
3312 |
173700858 |
582091 |
3696 |
13040 |
2026-08-15T04:41:59.380000Z |
play_count |
173700858 |
LOCAL |
1 |
1848 |
1421 |
149805770 |
633032 |
2435 |
30837 |
2026-08-15T04:41:59.380000Z |
play_count |
149805770 |
LOCAL |
1 |
1849 |
2865 |
110387755 |
3349950 |
17529 |
51919 |
2026-08-15T04:41:59.380000Z |
play_count |
110387755 |
LOCAL |
1 |
1850 |
1383 |
94392466 |
6055670 |
16820 |
113395 |
2026-08-15T04:41:59.380000Z |
play_count |
94392466 |
LOCAL |
1 |
1851 |
3316 |
320299926 |
8210932 |
64111 |
257563 |
2026-08-15T04:41:59.380000Z |
play_count |
320299926 |
LOCAL |
1 |
1852 |
897 |
2832032 |
23037 |
1230 |
396 |
2026-08-15T04:41:59.380000Z |
play_count |
2832032 |
LOCAL |
1 |
1853 |
1229 |
1171755 |
45475 |
707 |
1677 |
2026-08-15T04:41:59.380000Z |
play_count |
1171755 |
LOCAL |
1 |
1854 |
303 |
811118 |
14539 |
192 |
338 |
2026-08-15T04:41:59.380000Z |
play_count |
811118 |
LOCAL |
1 |
1855 |
1255 |
24341235 |
316026 |
1800 |
4889 |
2026-08-15T04:41:59.380000Z |
play_count |
24341235 |
LOCAL |
1 |
1856 |
533 |
152367015 |
3000615 |
12214 |
39330 |
2026-08-16T12:02:10.758000Z |
play_count |
152367015 |
LOCAL |
1 |
1857 |
3322 |
10320580 |
76080 |
7963 |
1519 |
2026-08-16T12:02:10.758000Z |
play_count |
10320580 |
LOCAL |
1 |
1858 |
1153 |
159421433 |
391991 |
1594 |
28476 |
2026-08-16T12:02:10.758000Z |
play_count |
159421433 |
LOCAL |
1 |
1859 |
531 |
19847239 |
424667 |
3939 |
13955 |
2026-08-16T12:02:10.758000Z |
play_count |
19847239 |
LOCAL |
1 |
1860 |
2854 |
9362527 |
358057 |
9757 |
12369 |
2026-08-16T12:02:10.758000Z |
play_count |
9362527 |
LOCAL |
1 |
1861 |
3047 |
3252993 |
65157 |
343 |
2414 |
2026-08-16T12:02:10.758000Z |
play_count |
3252993 |
LOCAL |
1 |
1862 |
3327 |
86053109 |
1915742 |
9794 |
40750 |
2026-08-16T12:02:10.758000Z |
play_count |
86053109 |
LOCAL |
1 |
1863 |
3031 |
10780129 |
71436 |
858 |
3155 |
2026-08-16T12:02:10.758000Z |
play_count |
10780129 |
LOCAL |
1 |
1864 |
1887 |
15908646 |
216139 |
4783 |
5540 |
2026-08-16T12:02:10.758000Z |
play_count |
15908646 |
LOCAL |
1 |
1865 |
1456 |
36721002 |
158544 |
546 |
1736 |
2026-08-16T12:02:10.758000Z |
play_count |
36721002 |
LOCAL |
1 |
1866 |
3331 |
430753 |
16883 |
51 |
391 |
2026-08-16T12:02:10.758000Z |
play_count |
430753 |
LOCAL |
1 |
1867 |
3332 |
385503695 |
3009680 |
9928 |
58104 |
2026-08-16T12:02:10.758000Z |
play_count |
385503695 |
LOCAL |
1 |
1868 |
532 |
2615992 |
46019 |
2133 |
828 |
2026-08-16T12:02:10.758000Z |
play_count |
2615992 |
LOCAL |
1 |
1869 |
3334 |
16584132 |
1213662 |
2373 |
66388 |
2026-08-16T12:02:10.758000Z |
play_count |
16584132 |
LOCAL |
1 |
1870 |
2871 |
4973546 |
271035 |
12427 |
5100 |
2026-08-16T12:02:10.758000Z |
play_count |
4973546 |
LOCAL |
1 |
1871 |
1069 |
120671859 |
8220210 |
20868 |
201210 |
2026-08-16T12:02:10.758000Z |
play_count |
120671859 |
LOCAL |
1 |
1872 |
1580 |
4265447 |
21425 |
55 |
439 |
2026-08-16T12:02:10.758000Z |
play_count |
4265447 |
LOCAL |
1 |
1873 |
2161 |
10859977 |
157047 |
1720 |
8782 |
2026-08-16T12:02:10.758000Z |
play_count |
10859977 |
LOCAL |
1 |
1874 |
2112 |
2927530 |
103953 |
348 |
1992 |
2026-08-16T12:02:10.758000Z |
play_count |
2927530 |
LOCAL |
1 |
1875 |
540 |
2152613 |
4418 |
25 |
223 |
2026-08-16T12:02:10.758000Z |
play_count |
2152613 |
LOCAL |
1 |
1876 |
600 |
7302508 |
73870 |
10695 |
1247 |
2026-08-16T12:03:28.838000Z |
play_count |
7302508 |
LOCAL |
1 |
1877 |
2367 |
3194921 |
10879 |
298 |
299 |
2026-08-16T12:03:28.838000Z |
play_count |
3194921 |
LOCAL |
1 |
1878 |
2799 |
52649164 |
796285 |
1128 |
21260 |
2026-08-16T12:03:28.838000Z |
play_count |
52649164 |
LOCAL |
1 |
1879 |
3254 |
59480848 |
1941808 |
3395 |
64105 |
2026-08-16T12:03:28.838000Z |
play_count |
59480848 |
LOCAL |
1 |
1880 |
1195 |
47049021 |
144452 |
322 |
14322 |
2026-08-16T12:03:28.838000Z |
play_count |
47049021 |
LOCAL |
1 |
1881 |
2652 |
19150612 |
46019 |
208 |
1580 |
2026-08-16T12:03:28.838000Z |
play_count |
19150612 |
LOCAL |
1 |
1882 |
290 |
48915194 |
1609428 |
1697 |
33526 |
2026-08-16T12:03:28.838000Z |
play_count |
48915194 |
LOCAL |
1 |
1883 |
1932 |
1859628 |
36653 |
1893 |
735 |
2026-08-16T12:03:28.838000Z |
play_count |
1859628 |
LOCAL |
1 |
1884 |
3021 |
33612286 |
2458618 |
10926 |
58047 |
2026-08-16T12:03:28.838000Z |
play_count |
33612286 |
LOCAL |
1 |
1885 |
3280 |
2167597 |
41994 |
214 |
1187 |
2026-08-16T12:03:28.838000Z |
play_count |
2167597 |
LOCAL |
1 |
1886 |
3351 |
2174735 |
12879 |
250 |
3428 |
2026-08-16T12:03:28.838000Z |
play_count |
2174735 |
LOCAL |
1 |
1887 |
617 |
7371818 |
312854 |
171 |
3971 |
2026-08-16T12:03:28.838000Z |
play_count |
7371818 |
LOCAL |
1 |
1888 |
2764 |
37105357 |
446114 |
1637 |
9512 |
2026-08-16T12:03:28.838000Z |
play_count |
37105357 |
LOCAL |
1 |
1889 |
1585 |
2455876 |
20874 |
96 |
592 |
2026-08-16T12:03:28.838000Z |
play_count |
2455876 |
LOCAL |
1 |
1890 |
3355 |
462094407 |
4787945 |
9348 |
153098 |
2026-08-16T12:03:28.838000Z |
play_count |
462094407 |
LOCAL |
1 |
1891 |
3356 |
66805 |
680 |
3338 |
72 |
2026-08-16T12:13:32.005000Z |
play_count |
66805 |
LOCAL |
1 |
1892 |
3357 |
473763 |
5022 |
10520 |
637 |
2026-08-16T12:13:32.005000Z |
play_count |
473763 |
LOCAL |
1 |
1893 |
3358 |
511043 |
4620 |
4088 |
787 |
2026-08-16T12:13:32.005000Z |
play_count |
511043 |
LOCAL |
1 |
1894 |
3359 |
46403 |
248 |
1327 |
43 |
2026-08-16T12:13:32.005000Z |
play_count |
46403 |
LOCAL |
1 |
1895 |
3360 |
90984 |
297 |
1 |
41 |
2026-08-16T12:13:32.005000Z |
play_count |
90984 |
LOCAL |
1 |
1896 |
3361 |
162691 |
5222 |
47 |
90 |
2026-08-16T12:13:32.005000Z |
play_count |
162691 |
LOCAL |
1 |
1897 |
3362 |
228345 |
1313 |
2135 |
64 |
2026-08-16T12:13:32.005000Z |
play_count |
228345 |
LOCAL |
1 |
1898 |
3363 |
671 |
8 |
11 |
4 |
2026-08-16T12:13:32.005000Z |
play_count |
671 |
LOCAL |
1 |
1899 |
3364 |
4788 |
3 |
0 |
2 |
2026-08-16T12:13:32.005000Z |
play_count |
4788 |
LOCAL |
1 |
1900 |
3357 |
473764 |
5022 |
10520 |
637 |
2026-08-16T12:16:14.919000Z |
play_count |
473764 |
LOCAL |
1 |