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 |
|---|---|---|---|---|---|---|---|---|---|
3226 |
18561628 |
94769 |
1231 |
2799 |
2026-08-15T04:38:11.840000Z |
play_count |
18561628 |
LOCAL |
1 |
3228 |
15431450 |
71719 |
153 |
2769 |
2026-08-15T04:38:11.840000Z |
play_count |
15431450 |
LOCAL |
1 |
3232 |
18327572 |
154550 |
305 |
3571 |
2026-08-15T04:38:11.840000Z |
play_count |
18327572 |
LOCAL |
1 |
3236 |
139570494 |
2149925 |
6581 |
51347 |
2026-08-15T04:38:11.840000Z |
play_count |
139570494 |
LOCAL |
1 |
3237 |
37020117 |
359864 |
1173 |
11277 |
2026-08-16T13:09:52.579000Z |
play_count |
37020117 |
LOCAL |
1 |
3252 |
1824172 |
5297 |
123 |
511 |
2026-08-15T04:39:41.904000Z |
play_count |
1824172 |
LOCAL |
1 |
3253 |
31548268 |
287728 |
1514 |
5318 |
2026-08-15T04:39:41.904000Z |
play_count |
31548268 |
LOCAL |
1 |
3254 |
59480848 |
1941808 |
3395 |
64105 |
2026-08-16T12:03:28.838000Z |
play_count |
59480848 |
LOCAL |
1 |
3255 |
898292 |
18912 |
67 |
301 |
2026-08-15T04:39:58.933000Z |
play_count |
898292 |
LOCAL |
1 |
3257 |
1955331 |
81900 |
903 |
2042 |
2026-08-15T04:39:41.904000Z |
play_count |
1955331 |
LOCAL |
1 |
3262 |
12768 |
128 |
23 |
4 |
2026-08-15T04:39:58.933000Z |
play_count |
12768 |
LOCAL |
1 |
3264 |
21953403 |
308063 |
859 |
4804 |
2026-08-15T04:39:58.933000Z |
play_count |
21953403 |
LOCAL |
1 |
3269 |
1434939 |
49912 |
150 |
1054 |
2026-08-15T04:39:41.904000Z |
play_count |
1434939 |
LOCAL |
1 |
3271 |
19339 |
51 |
75 |
12 |
2026-08-15T04:39:58.933000Z |
play_count |
19339 |
LOCAL |
1 |
3280 |
2167597 |
41994 |
214 |
1187 |
2026-08-16T12:03:28.838000Z |
play_count |
2167597 |
LOCAL |
1 |
3282 |
10089 |
71 |
119 |
8 |
2026-08-15T04:40:07.790000Z |
play_count |
10089 |
LOCAL |
1 |
3283 |
95245 |
549 |
505 |
18 |
2026-08-15T04:40:07.790000Z |
play_count |
95245 |
LOCAL |
1 |
3284 |
1481423 |
74649 |
771 |
1345 |
2026-08-16T13:10:03.639000Z |
play_count |
1481423 |
LOCAL |
1 |
3285 |
97255289 |
5804381 |
9838 |
3753 |
2026-08-15T04:40:07.790000Z |
play_count |
97255289 |
LOCAL |
1 |
3288 |
54213485 |
2744492 |
8381 |
66382 |
2026-08-15T04:40:07.790000Z |
play_count |
54213485 |
LOCAL |
1 |
3289 |
22774119 |
160713 |
631 |
1730 |
2026-08-16T13:42:47.786000Z |
play_count |
22774119 |
LOCAL |
1 |
3290 |
395867 |
1302 |
221 |
32 |
2026-08-15T04:40:07.790000Z |
play_count |
395867 |
LOCAL |
1 |
3291 |
10101078 |
379305 |
1835 |
4586 |
2026-08-15T04:40:07.790000Z |
play_count |
10101078 |
LOCAL |
1 |
3292 |
50499987 |
1619943 |
4478 |
31300 |
2026-08-16T13:09:52.579000Z |
play_count |
50499987 |
LOCAL |
1 |
3294 |
484267 |
28289 |
838 |
438 |
2026-08-15T04:40:07.790000Z |
play_count |
484267 |
LOCAL |
1 |
3297 |
180585439 |
4285827 |
5760 |
84606 |
2026-08-15T04:40:07.790000Z |
play_count |
180585439 |
LOCAL |
1 |
3299 |
7349209 |
141982 |
749 |
3120 |
2026-08-15T04:40:07.790000Z |
play_count |
7349209 |
LOCAL |
1 |
3301 |
101163 |
1663 |
3721 |
129 |
2026-08-15T04:41:59.380000Z |
play_count |
101163 |
LOCAL |
1 |
3304 |
10003487 |
58568 |
297 |
970 |
2026-08-15T04:41:59.380000Z |
play_count |
10003487 |
LOCAL |
1 |
3306 |
4249364 |
125344 |
266 |
1513 |
2026-08-15T04:41:59.380000Z |
play_count |
4249364 |
LOCAL |
1 |
3308 |
40234 |
460 |
13 |
45 |
2026-08-15T04:41:59.380000Z |
play_count |
40234 |
LOCAL |
1 |
3309 |
141221249 |
5862337 |
25861 |
146321 |
2026-08-15T04:41:59.380000Z |
play_count |
141221249 |
LOCAL |
1 |
3312 |
173951320 |
583734 |
3715 |
13068 |
2026-08-16T13:49:41.254000Z |
play_count |
173951320 |
LOCAL |
1 |
3316 |
320299926 |
8210932 |
64111 |
257563 |
2026-08-15T04:41:59.380000Z |
play_count |
320299926 |
LOCAL |
1 |
3322 |
13173920 |
76080 |
7963 |
1519 |
2026-08-16T12:16:55.495000Z |
play_count |
13173920 |
LOCAL |
1 |
3327 |
86053109 |
1915742 |
9794 |
40750 |
2026-08-16T12:02:10.758000Z |
play_count |
86053109 |
LOCAL |
1 |
3331 |
430753 |
16883 |
51 |
391 |
2026-08-16T12:02:10.758000Z |
play_count |
430753 |
LOCAL |
1 |
3332 |
385503695 |
3009680 |
9928 |
58104 |
2026-08-16T12:02:10.758000Z |
play_count |
385503695 |
LOCAL |
1 |
3334 |
16642494 |
1219418 |
2391 |
66572 |
2026-08-16T13:42:47.786000Z |
play_count |
16642494 |
LOCAL |
1 |
3351 |
2174735 |
12879 |
250 |
3428 |
2026-08-16T12:03:28.838000Z |
play_count |
2174735 |
LOCAL |
1 |
3355 |
462094407 |
4787945 |
9348 |
153098 |
2026-08-16T12:03:28.838000Z |
play_count |
462094407 |
LOCAL |
1 |
3356 |
67038 |
680 |
3338 |
72 |
2026-08-16T13:49:33.824000Z |
play_count |
67038 |
LOCAL |
1 |
3357 |
473872 |
5022 |
10520 |
637 |
2026-08-16T13:49:33.824000Z |
play_count |
473872 |
LOCAL |
1 |
3358 |
511043 |
4620 |
4088 |
787 |
2026-08-16T12:13:32.005000Z |
play_count |
511043 |
LOCAL |
1 |
3359 |
46403 |
248 |
1327 |
43 |
2026-08-16T12:13:32.005000Z |
play_count |
46403 |
LOCAL |
1 |
3360 |
90984 |
297 |
1 |
41 |
2026-08-16T12:13:32.005000Z |
play_count |
90984 |
LOCAL |
1 |
3361 |
162549 |
5231 |
47 |
90 |
2026-08-16T12:21:10.903000Z |
play_count |
5278 |
LOCAL |
1 |
3362 |
231133 |
1334 |
2168 |
66 |
2026-08-16T12:21:10.903000Z |
play_count |
231133 |
LOCAL |
1 |
3363 |
671 |
8 |
11 |
4 |
2026-08-16T12:13:32.005000Z |
play_count |
671 |
LOCAL |
1 |
3364 |
4823 |
3 |
0 |
2 |
2026-08-16T12:18:24.865000Z |
play_count |
4823 |
LOCAL |
1 |
3367 |
119181 |
846 |
2474 |
62 |
2026-08-16T12:16:14.919000Z |
play_count |
119181 |
LOCAL |
1 |
3374 |
22611068 |
1587684 |
20742 |
33476 |
2026-08-16T12:17:42.935000Z |
play_count |
22611068 |
LOCAL |
1 |
3375 |
3453 |
120 |
2 |
0 |
2026-08-16T12:17:46.204000Z |
play_count |
3453 |
LOCAL |
1 |
3376 |
10506 |
281 |
3 |
10 |
2026-08-16T12:17:46.204000Z |
play_count |
10506 |
LOCAL |
1 |
3378 |
29550 |
561 |
2 |
11 |
2026-08-16T12:17:46.204000Z |
play_count |
29550 |
LOCAL |
1 |
3379 |
13948 |
640 |
8 |
9 |
2026-08-16T12:17:46.204000Z |
play_count |
13948 |
LOCAL |
1 |
3380 |
20677 |
557 |
9 |
15 |
2026-08-16T12:17:46.204000Z |
play_count |
20677 |
LOCAL |
1 |
3381 |
1692826 |
32392 |
541 |
1166 |
2026-08-16T12:17:46.204000Z |
play_count |
1692826 |
LOCAL |
1 |
3382 |
31899 |
419 |
7 |
12 |
2026-08-16T12:17:46.204000Z |
play_count |
31899 |
LOCAL |
1 |
3383 |
36944 |
138 |
2 |
2 |
2026-08-16T12:17:46.204000Z |
play_count |
36944 |
LOCAL |
1 |
3385 |
1627788 |
54033 |
2006 |
734 |
2026-08-16T12:17:46.204000Z |
play_count |
1627788 |
LOCAL |
1 |
3386 |
31676 |
1151 |
27 |
41 |
2026-08-16T12:17:46.204000Z |
play_count |
31676 |
LOCAL |
1 |
3387 |
36538 |
601 |
4 |
23 |
2026-08-16T12:17:46.204000Z |
play_count |
36538 |
LOCAL |
1 |
3397 |
36340 |
878 |
17 |
12 |
2026-08-16T12:17:46.204000Z |
play_count |
36340 |
LOCAL |
1 |
3398 |
17926125 |
234073 |
4665 |
30 |
2026-08-16T12:17:46.204000Z |
play_count |
17926125 |
LOCAL |
1 |
3400 |
27595 |
789 |
26 |
19 |
2026-08-16T12:17:46.204000Z |
play_count |
27595 |
LOCAL |
1 |
3401 |
140598 |
4376 |
52 |
104 |
2026-08-16T12:17:46.204000Z |
play_count |
140598 |
LOCAL |
1 |
3402 |
14979 |
304 |
5 |
4 |
2026-08-16T12:17:46.204000Z |
play_count |
14979 |
LOCAL |
1 |
3403 |
13491 |
220 |
8 |
6 |
2026-08-16T12:17:46.204000Z |
play_count |
13491 |
LOCAL |
1 |
3404 |
17142 |
239 |
1 |
8 |
2026-08-16T12:17:46.204000Z |
play_count |
17142 |
LOCAL |
1 |
3405 |
11029 |
153 |
4 |
3 |
2026-08-16T12:17:46.204000Z |
play_count |
11029 |
LOCAL |
1 |
3406 |
373749 |
3867 |
41 |
101 |
2026-08-16T12:17:46.204000Z |
play_count |
373749 |
LOCAL |
1 |
3407 |
11840 |
329 |
6 |
8 |
2026-08-16T12:17:46.204000Z |
play_count |
11840 |
LOCAL |
1 |
3408 |
75644 |
1326 |
21 |
7 |
2026-08-16T12:17:46.204000Z |
play_count |
75644 |
LOCAL |
1 |
3465 |
9560 |
58 |
131 |
2 |
2026-08-16T12:18:30.953000Z |
play_count |
9560 |
LOCAL |
1 |
3466 |
47046 |
425 |
856 |
65 |
2026-08-16T12:18:30.953000Z |
play_count |
47046 |
LOCAL |
1 |
3468 |
73520 |
331 |
29 |
8 |
2026-08-16T13:42:44.852000Z |
play_count |
73520 |
LOCAL |
1 |
3480 |
15328 |
324 |
6 |
0 |
2026-08-16T12:18:38.741000Z |
play_count |
15328 |
LOCAL |
1 |
3507 |
24744 |
65 |
3 |
6 |
2026-08-16T12:20:02.907000Z |
play_count |
24744 |
LOCAL |
1 |
3508 |
65934 |
319 |
3060 |
38 |
2026-08-16T13:42:42.920000Z |
play_count |
65934 |
LOCAL |
1 |
3509 |
124951 |
855 |
4736 |
41 |
2026-08-16T12:20:02.907000Z |
play_count |
124951 |
LOCAL |
1 |
3510 |
18236 |
101 |
96 |
6 |
2026-08-16T13:09:49.541000Z |
play_count |
18236 |
LOCAL |
1 |
3512 |
148479 |
1212 |
12560 |
202 |
2026-08-16T13:09:49.541000Z |
play_count |
148479 |
LOCAL |
1 |
3513 |
327916 |
2490 |
3458 |
109 |
2026-08-16T12:20:02.907000Z |
play_count |
327916 |
LOCAL |
1 |
3514 |
11009 |
66 |
204 |
5 |
2026-08-16T13:09:49.541000Z |
play_count |
11009 |
LOCAL |
1 |
3515 |
0 |
997 |
559 |
140 |
2026-08-16T12:19:58.206000Z |
play_count |
1556 |
LOCAL |
0 |
3516 |
183533 |
874 |
5669 |
152 |
2026-08-16T12:20:02.907000Z |
play_count |
183533 |
LOCAL |
1 |
3517 |
28278 |
370 |
2268 |
45 |
2026-08-16T12:20:02.907000Z |
play_count |
28278 |
LOCAL |
1 |
3518 |
329638 |
2349 |
7447 |
235 |
2026-08-16T12:20:02.907000Z |
play_count |
329638 |
LOCAL |
1 |
3519 |
60692 |
434 |
12 |
75 |
2026-08-16T12:20:02.907000Z |
play_count |
60692 |
LOCAL |
1 |
3534 |
347606 |
2412 |
1872 |
123 |
2026-08-16T12:21:45.435000Z |
play_count |
347606 |
LOCAL |
1 |
3537 |
29679 |
149 |
3 |
26 |
2026-08-16T12:21:10.903000Z |
play_count |
29679 |
LOCAL |
1 |
3538 |
0 |
14638 |
1353 |
202 |
2026-08-16T12:21:10.903000Z |
play_count |
15991 |
LOCAL |
0 |
3539 |
672854 |
851 |
1039 |
96 |
2026-08-16T12:21:10.903000Z |
play_count |
672854 |
LOCAL |
1 |
3553 |
31454 |
115 |
720 |
9 |
2026-08-16T12:30:25.120000Z |
play_count |
31454 |
LOCAL |
1 |
3555 |
647112 |
11276 |
31 |
97 |
2026-08-16T12:30:25.120000Z |
play_count |
647112 |
LOCAL |
1 |
3556 |
215350 |
1575 |
10 |
17 |
2026-08-16T12:30:25.120000Z |
play_count |
215350 |
LOCAL |
1 |
3557 |
10806 |
52 |
10 |
0 |
2026-08-16T12:21:51.885000Z |
play_count |
10806 |
LOCAL |
1 |
3558 |
392930 |
1717 |
36 |
20 |
2026-08-16T12:30:25.120000Z |
play_count |
392930 |
LOCAL |
1 |
3560 |
649350 |
4148 |
8 |
33 |
2026-08-16T12:30:25.120000Z |
play_count |
649350 |
LOCAL |
1 |