Table: post_stat_latest
Schema
| cid | name | type | notnull | default | pk |
|---|---|---|---|---|---|
| 0 | post_id | INTEGER | 0 | 1 | |
| 1 | views | INTEGER | 1 | 0 | 0 |
| 2 | likes | INTEGER | 1 | 0 | 0 |
| 3 | comments | INTEGER | 1 | 0 | 0 |
| 4 | reposts | INTEGER | 1 | 0 | 0 |
| 5 | collected_at | TEXT | 1 | CURRENT_TIMESTAMP | 0 |
| 6 | sort_by | TEXT | 1 | '' | 0 |
| 7 | sort_value | INTEGER | 1 | 0 | 0 |
| 8 | source_kind | TEXT | 1 | 'LOCAL' | 0 |
| 9 | views_available | INTEGER | 1 | 0 | 0 |
Data
| post_id | views | likes | comments | reposts | collected_at | sort_by | sort_value | source_kind | views_available |
|---|---|---|---|---|---|---|---|---|---|
1764 |
66106 |
675 |
5 |
2 |
2026-08-12T09:16:08.059000Z |
play_count |
66106 |
LOCAL |
1 |
1772 |
40652 |
298 |
4 |
3 |
2026-08-12T09:16:22.594000Z |
play_count |
40652 |
LOCAL |
1 |
1773 |
19157 |
247 |
5 |
4 |
2026-08-12T09:16:22.594000Z |
play_count |
19157 |
LOCAL |
1 |
1774 |
219669 |
5566 |
186 |
158 |
2026-08-12T09:19:52Z |
play_count |
5752 |
SERVER |
1 |
1775 |
790025 |
2076 |
30 |
29 |
2026-08-12T09:16:22.594000Z |
play_count |
790025 |
LOCAL |
1 |
1776 |
90576 |
1590 |
19 |
20 |
2026-08-12T09:16:22.594000Z |
play_count |
90576 |
LOCAL |
1 |
1777 |
0 |
114 |
4 |
0 |
2026-08-12T09:16:22.594000Z |
play_count |
118 |
LOCAL |
0 |
1807 |
0 |
307 |
8 |
9 |
2026-08-12T09:20:15.437000Z |
play_count |
315 |
LOCAL |
0 |
1809 |
0 |
1627 |
13 |
28 |
2026-08-12T09:20:15.437000Z |
play_count |
1640 |
LOCAL |
0 |
1818 |
69610 |
539 |
1527 |
31 |
2026-08-12T09:20:36.946000Z |
play_count |
69610 |
LOCAL |
1 |
1819 |
9364426 |
256353 |
16670 |
5905 |
2026-08-12T09:20:36.946000Z |
play_count |
9364426 |
LOCAL |
1 |
1820 |
552583 |
3987 |
128 |
529 |
2026-08-16T13:09:49.541000Z |
play_count |
552583 |
LOCAL |
1 |
1830 |
42057735 |
1356988 |
5928 |
22791 |
2026-08-12T13:48:49.406000Z |
play_count |
42057735 |
LOCAL |
1 |
1831 |
31044 |
117 |
10 |
1 |
2026-08-12T09:20:58.961000Z |
play_count |
31044 |
LOCAL |
1 |
1832 |
5535299 |
17137 |
23 |
329 |
2026-08-14T06:17:57.597000Z |
play_count |
5535299 |
LOCAL |
1 |
1834 |
18008 |
182 |
53 |
3 |
2026-08-12T13:55:25.749000Z |
play_count |
18008 |
LOCAL |
1 |
1843 |
2557779 |
36765 |
74 |
733 |
2026-08-16T13:49:41.254000Z |
play_count |
2557779 |
LOCAL |
1 |
1844 |
38131953 |
631601 |
2188 |
8656 |
2026-08-12T13:47:19.401000Z |
play_count |
38131953 |
LOCAL |
1 |
1845 |
85228230 |
307392 |
665 |
13277 |
2026-08-14T06:17:57.597000Z |
play_count |
85228230 |
LOCAL |
1 |
1869 |
3534735 |
24266 |
121 |
592 |
2026-08-16T13:10:03.639000Z |
play_count |
3534735 |
LOCAL |
1 |
1875 |
8783368 |
45171 |
268 |
682 |
2026-08-12T09:21:15.133000Z |
play_count |
8783368 |
LOCAL |
1 |
1876 |
8805255 |
227949 |
203 |
5758 |
2026-08-15T04:39:41.904000Z |
play_count |
8805255 |
LOCAL |
1 |
1878 |
13834719 |
129674 |
150 |
2747 |
2026-08-16T13:42:47.786000Z |
play_count |
13834719 |
LOCAL |
1 |
1879 |
22904847 |
169445 |
299 |
2616 |
2026-08-16T13:49:39.588000Z |
play_count |
22904847 |
LOCAL |
1 |
1887 |
15909665 |
216156 |
4783 |
5540 |
2026-08-16T13:49:41.254000Z |
play_count |
15909665 |
LOCAL |
1 |
1889 |
12805035 |
58423 |
77 |
1201 |
2026-08-12T09:21:15.133000Z |
play_count |
12805035 |
LOCAL |
1 |
1890 |
2485435 |
76545 |
1109 |
2243 |
2026-08-12T09:21:15.133000Z |
play_count |
2485435 |
LOCAL |
1 |
1926 |
7078441 |
27004 |
663 |
303 |
2026-08-14T06:17:57.597000Z |
play_count |
7078441 |
LOCAL |
1 |
1927 |
3815505 |
14278 |
135 |
312 |
2026-08-12T23:05:03.584000Z |
play_count |
3815505 |
LOCAL |
1 |
1929 |
3193 |
25 |
5 |
1 |
2026-08-12T13:48:49.406000Z |
play_count |
3193 |
LOCAL |
1 |
1931 |
2891189 |
8396 |
50 |
204 |
2026-08-12T13:50:09.821000Z |
play_count |
2891189 |
LOCAL |
1 |
1932 |
1859628 |
36653 |
1893 |
735 |
2026-08-16T12:03:28.838000Z |
play_count |
1859628 |
LOCAL |
1 |
1940 |
6013 |
31 |
0 |
1 |
2026-08-12T13:47:37.115000Z |
play_count |
6013 |
LOCAL |
1 |
1972 |
2165785 |
97755 |
1041 |
994 |
2026-08-12T13:50:09.821000Z |
play_count |
2165785 |
LOCAL |
1 |
1973 |
8000882 |
470823 |
1941 |
5536 |
2026-08-12T13:50:09.821000Z |
play_count |
8000882 |
LOCAL |
1 |
1974 |
12292 |
219 |
122 |
5 |
2026-08-12T13:41:53.233000Z |
play_count |
12292 |
LOCAL |
1 |
1975 |
18758833 |
183011 |
5055 |
2234 |
2026-08-12T13:50:09.821000Z |
play_count |
18758833 |
LOCAL |
1 |
1976 |
4028164 |
106936 |
335 |
1233 |
2026-08-12T13:49:45.855000Z |
play_count |
4028164 |
LOCAL |
1 |
1980 |
49928188 |
1878007 |
8333 |
49286 |
2026-08-16T13:09:52.579000Z |
play_count |
49928188 |
LOCAL |
1 |
1984 |
61816 |
831 |
214 |
20 |
2026-08-12T13:41:53.233000Z |
play_count |
61816 |
LOCAL |
1 |
1988 |
5962664 |
83641 |
1225 |
1041 |
2026-08-12T13:57:35.663000Z |
play_count |
5962664 |
LOCAL |
1 |
1990 |
2656035 |
8547 |
69 |
148 |
2026-08-12T13:56:21.365000Z |
play_count |
2656035 |
LOCAL |
1 |
2019 |
19843596 |
376005 |
66 |
3835 |
2026-08-12T13:43:09.851000Z |
play_count |
19843596 |
LOCAL |
1 |
2020 |
26551 |
127 |
38 |
2 |
2026-08-12T13:43:09.851000Z |
play_count |
26551 |
LOCAL |
1 |
2021 |
0 |
178 |
2 |
3 |
2026-08-12T13:43:09.851000Z |
play_count |
180 |
LOCAL |
0 |
2023 |
1649213 |
33843 |
37 |
461 |
2026-08-12T13:43:09.851000Z |
play_count |
1649213 |
LOCAL |
1 |
2024 |
1083226 |
23289 |
12 |
289 |
2026-08-12T13:43:09.851000Z |
play_count |
1083226 |
LOCAL |
1 |
2025 |
1466 |
126 |
15 |
5 |
2026-08-12T13:48:49.406000Z |
play_count |
1466 |
LOCAL |
1 |
2029 |
96889954 |
2230010 |
2970 |
42762 |
2026-08-12T13:49:45.855000Z |
play_count |
96889954 |
LOCAL |
1 |
2030 |
10871321 |
174981 |
989 |
1458 |
2026-08-12T13:48:01.295000Z |
play_count |
10871321 |
LOCAL |
1 |
2031 |
51841 |
864 |
479 |
8 |
2026-08-12T13:55:25.749000Z |
play_count |
51841 |
LOCAL |
1 |
2032 |
740982 |
30752 |
43 |
2944 |
2026-08-12T13:48:01.295000Z |
play_count |
740982 |
LOCAL |
1 |
2034 |
5887208 |
51770 |
635 |
1063 |
2026-08-14T07:02:44.707000Z |
play_count |
5887208 |
LOCAL |
1 |
2035 |
1061789 |
9326 |
361 |
274 |
2026-08-12T13:43:09.851000Z |
play_count |
1061789 |
LOCAL |
1 |
2066 |
144756 |
1926 |
45 |
18 |
2026-08-12T13:47:19.401000Z |
play_count |
144756 |
LOCAL |
1 |
2070 |
171292553 |
3749876 |
31541 |
112036 |
2026-08-12T13:47:19.401000Z |
play_count |
171292553 |
LOCAL |
1 |
2072 |
319184 |
805 |
7 |
0 |
2026-08-12T13:47:19.401000Z |
play_count |
319184 |
LOCAL |
1 |
2073 |
35396 |
87 |
3 |
1 |
2026-08-12T13:47:19.401000Z |
play_count |
35396 |
LOCAL |
1 |
2075 |
32590848 |
52623 |
256 |
1155 |
2026-08-15T04:41:59.380000Z |
play_count |
32590848 |
LOCAL |
1 |
2079 |
1959084 |
9132 |
17 |
142 |
2026-08-12T13:56:21.365000Z |
play_count |
1959084 |
LOCAL |
1 |
2080 |
7068740 |
430912 |
1469 |
12038 |
2026-08-14T06:42:43.868000Z |
play_count |
7068740 |
LOCAL |
1 |
2081 |
146347 |
840 |
6 |
0 |
2026-08-12T13:47:19.401000Z |
play_count |
146347 |
LOCAL |
1 |
2083 |
189 |
3 |
1 |
0 |
2026-08-12T13:47:19.401000Z |
play_count |
189 |
LOCAL |
1 |
2106 |
241879640 |
661273 |
1382 |
20262 |
2026-08-12T13:47:37.115000Z |
play_count |
241879640 |
LOCAL |
1 |
2111 |
498358 |
10731 |
253 |
115 |
2026-08-14T07:02:44.707000Z |
play_count |
498358 |
LOCAL |
1 |
2112 |
2927530 |
103953 |
348 |
1992 |
2026-08-16T12:02:10.758000Z |
play_count |
2927530 |
LOCAL |
1 |
2115 |
2238 |
26 |
8 |
0 |
2026-08-12T13:47:37.115000Z |
play_count |
2238 |
LOCAL |
1 |
2118 |
7208988 |
3 |
625 |
6932 |
2026-08-12T13:47:37.115000Z |
play_count |
7208988 |
LOCAL |
1 |
2125 |
7214151 |
309890 |
494 |
7451 |
2026-08-12T13:47:37.115000Z |
play_count |
7214151 |
LOCAL |
1 |
2153 |
3324 |
29 |
2 |
2 |
2026-08-12T13:48:01.295000Z |
play_count |
3324 |
LOCAL |
1 |
2160 |
0 |
1 |
0 |
0 |
2026-08-12T13:48:01.295000Z |
play_count |
1 |
LOCAL |
0 |
2161 |
10859977 |
157047 |
1720 |
8782 |
2026-08-16T12:02:10.758000Z |
play_count |
10859977 |
LOCAL |
1 |
2166 |
247669526 |
2333755 |
2730 |
46219 |
2026-08-12T13:48:01.295000Z |
play_count |
247669526 |
LOCAL |
1 |
2168 |
0 |
0 |
0 |
0 |
2026-08-12T13:48:01.295000Z |
play_count |
0 |
LOCAL |
0 |
2172 |
16280911 |
505281 |
723 |
30409 |
2026-08-15T04:41:59.380000Z |
play_count |
16280911 |
LOCAL |
1 |
2200 |
63650162 |
838469 |
4426 |
9964 |
2026-08-12T13:48:49.406000Z |
play_count |
63650162 |
LOCAL |
1 |
2202 |
22748 |
436 |
61 |
9 |
2026-08-12T13:48:49.406000Z |
play_count |
22748 |
LOCAL |
1 |
2205 |
15343788 |
37494 |
17 |
683 |
2026-08-12T13:48:49.406000Z |
play_count |
15343788 |
LOCAL |
1 |
2207 |
9098762 |
11287 |
69 |
324 |
2026-08-12T13:48:49.406000Z |
play_count |
9098762 |
LOCAL |
1 |
2211 |
2343 |
61 |
6 |
2 |
2026-08-12T13:48:49.406000Z |
play_count |
2343 |
LOCAL |
1 |
2215 |
1023812 |
22280 |
61 |
242 |
2026-08-12T13:55:50Z |
play_count |
1023812 |
SERVER |
1 |
2217 |
22086915 |
271467 |
146 |
3808 |
2026-08-12T13:48:49.406000Z |
play_count |
22086915 |
LOCAL |
1 |
2220 |
18050226 |
483262 |
1833 |
6750 |
2026-08-12T23:05:03.584000Z |
play_count |
18050226 |
LOCAL |
1 |
2247 |
18000900 |
335740 |
701 |
4269 |
2026-08-12T13:57:20.120000Z |
play_count |
18000900 |
LOCAL |
1 |
2249 |
0 |
5 |
0 |
0 |
2026-08-12T13:49:45.855000Z |
play_count |
5 |
LOCAL |
0 |
2252 |
4374922 |
113148 |
181 |
1447 |
2026-08-12T13:49:45.855000Z |
play_count |
4374922 |
LOCAL |
1 |
2255 |
10579398 |
91402 |
647 |
1854 |
2026-08-14T12:56:45.999000Z |
play_count |
10579398 |
LOCAL |
1 |
2256 |
257261 |
6209 |
79 |
161 |
2026-08-12T13:49:45.855000Z |
play_count |
257261 |
LOCAL |
1 |
2258 |
2512786 |
55976 |
1338 |
1443 |
2026-08-12T13:49:45.855000Z |
play_count |
2512786 |
LOCAL |
1 |
2259 |
17187452 |
51033 |
224 |
1367 |
2026-08-12T13:49:45.855000Z |
play_count |
17187452 |
LOCAL |
1 |
2260 |
392015 |
6894 |
124 |
245 |
2026-08-12T13:49:45.855000Z |
play_count |
392015 |
LOCAL |
1 |
2262 |
941487 |
20842 |
81 |
683 |
2026-08-12T13:49:45.855000Z |
play_count |
941487 |
LOCAL |
1 |
2263 |
50082674 |
3 |
8426 |
25440 |
2026-08-12T13:49:45.855000Z |
play_count |
50082674 |
LOCAL |
1 |
2265 |
7175816 |
12084 |
73 |
458 |
2026-08-12T13:49:45.855000Z |
play_count |
7175816 |
LOCAL |
1 |
2266 |
2845226 |
19113 |
96 |
332 |
2026-08-12T13:49:45.855000Z |
play_count |
2845226 |
LOCAL |
1 |
2267 |
0 |
4 |
0 |
0 |
2026-08-12T13:49:45.855000Z |
play_count |
4 |
LOCAL |
0 |
2291 |
510503 |
33385 |
778 |
216 |
2026-08-12T13:50:09.821000Z |
play_count |
510503 |
LOCAL |
1 |
2295 |
4254346 |
37648 |
205 |
289 |
2026-08-12T13:50:09.821000Z |
play_count |
4254346 |
LOCAL |
1 |
2299 |
325373 |
6928 |
881 |
90 |
2026-08-14T07:04:55.410000Z |
play_count |
325373 |
LOCAL |
1 |
2300 |
131224 |
6888 |
85 |
66 |
2026-08-12T13:50:09.821000Z |
play_count |
131224 |
LOCAL |
1 |