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 |
|---|---|---|---|---|---|---|---|---|---|
378 |
0 |
398 |
6 |
5 |
2026-08-11T12:23:00.046000Z |
play_count |
398 |
LOCAL |
0 |
379 |
0 |
2010 |
35 |
81 |
2026-08-11T12:23:00.046000Z |
play_count |
2010 |
LOCAL |
0 |
380 |
0 |
6708 |
205 |
313 |
2026-08-11T12:23:00.046000Z |
play_count |
6708 |
LOCAL |
0 |
381 |
0 |
955 |
14 |
118 |
2026-08-11T12:23:00.046000Z |
play_count |
955 |
LOCAL |
0 |
382 |
17923 |
650 |
83 |
34 |
2026-08-11T12:23:06Z |
play_count |
17923 |
SERVER |
1 |
383 |
0 |
2585 |
63 |
108 |
2026-08-11T12:23:00.046000Z |
play_count |
2585 |
LOCAL |
0 |
384 |
0 |
986 |
19 |
56 |
2026-08-11T12:23:00.046000Z |
play_count |
986 |
LOCAL |
0 |
385 |
0 |
749 |
12 |
24 |
2026-08-11T12:23:00.046000Z |
play_count |
749 |
LOCAL |
0 |
386 |
0 |
550 |
12 |
15 |
2026-08-11T12:23:00.046000Z |
play_count |
550 |
LOCAL |
0 |
387 |
0 |
991 |
15 |
50 |
2026-08-11T12:23:00.046000Z |
play_count |
991 |
LOCAL |
0 |
388 |
0 |
10469 |
224 |
795 |
2026-08-11T12:23:00.046000Z |
play_count |
10469 |
LOCAL |
0 |
484 |
0 |
3032 |
406 |
163 |
2026-08-11T12:20:08.988000Z |
play_count |
3032 |
LOCAL |
0 |
485 |
0 |
34386 |
212 |
463 |
2026-08-11T12:20:08.988000Z |
play_count |
34386 |
LOCAL |
0 |
486 |
0 |
19487 |
37 |
237 |
2026-08-11T12:20:08.988000Z |
play_count |
19487 |
LOCAL |
0 |
487 |
0 |
461 |
3 |
9 |
2026-08-11T12:20:08.988000Z |
play_count |
461 |
LOCAL |
0 |
488 |
0 |
721 |
2 |
4 |
2026-08-11T12:20:08.988000Z |
play_count |
721 |
LOCAL |
0 |
489 |
0 |
1747 |
11 |
17 |
2026-08-11T12:20:08.988000Z |
play_count |
1747 |
LOCAL |
0 |
519 |
6298304 |
34030 |
34 |
564 |
2026-08-13T11:28:58.131000Z |
play_count |
6298304 |
LOCAL |
1 |
521 |
15766975 |
253379 |
828 |
1650 |
2026-08-11T13:00:59.916000Z |
play_count |
15766975 |
LOCAL |
1 |
522 |
0 |
1454 |
93 |
54 |
2026-08-11T13:00:59.916000Z |
play_count |
1454 |
LOCAL |
0 |
523 |
1310383 |
23300 |
23 |
332 |
2026-08-12T23:05:25.596000Z |
play_count |
1310383 |
LOCAL |
1 |
524 |
120155807 |
1780851 |
5898 |
20410 |
2026-08-14T06:17:57.597000Z |
play_count |
120155807 |
LOCAL |
1 |
525 |
8393395 |
92284 |
2212 |
2284 |
2026-08-14T06:17:57.597000Z |
play_count |
8393395 |
LOCAL |
1 |
526 |
5867016 |
144993 |
1855 |
3088 |
2026-08-11T13:00:59.916000Z |
play_count |
5867016 |
LOCAL |
1 |
528 |
10768287 |
32961 |
65 |
719 |
2026-08-12T13:48:01.295000Z |
play_count |
10768287 |
LOCAL |
1 |
529 |
0 |
666 |
12 |
18 |
2026-08-12T09:21:15.133000Z |
play_count |
678 |
LOCAL |
0 |
530 |
125775300 |
651562 |
1923 |
19155 |
2026-08-12T01:40:43.078Z |
play_count |
125775300 |
LOCAL |
1 |
531 |
19847239 |
424667 |
3939 |
13955 |
2026-08-16T12:02:10.758000Z |
play_count |
19847239 |
LOCAL |
1 |
532 |
2615992 |
46019 |
2133 |
828 |
2026-08-16T12:02:10.758000Z |
play_count |
2615992 |
LOCAL |
1 |
533 |
153458305 |
3000615 |
12214 |
39330 |
2026-08-16T12:16:55.495000Z |
play_count |
153458305 |
LOCAL |
1 |
534 |
23955 |
607 |
2 |
2 |
2026-08-12T23:05:03.584000Z |
play_count |
23955 |
LOCAL |
1 |
537 |
0 |
1539 |
60 |
44 |
2026-08-11T13:00:59.916000Z |
play_count |
1539 |
LOCAL |
0 |
538 |
1457962 |
29016 |
21084 |
241 |
2026-08-16T13:49:41.254000Z |
play_count |
1457962 |
LOCAL |
1 |
540 |
2152613 |
4418 |
25 |
223 |
2026-08-16T12:02:10.758000Z |
play_count |
2152613 |
LOCAL |
1 |
541 |
6189 |
3 |
0 |
2 |
2026-08-11T14:10:40.629000Z |
play_count |
6189 |
LOCAL |
1 |
543 |
26151160 |
269759 |
608 |
8889 |
2026-08-12T13:48:49.406000Z |
play_count |
26151160 |
LOCAL |
1 |
544 |
76679 |
3488 |
25 |
96 |
2026-08-11T13:11:06.980000Z |
play_count |
76679 |
LOCAL |
1 |
545 |
38004910 |
249612 |
873 |
6358 |
2026-08-12T23:05:03.584000Z |
play_count |
38004910 |
LOCAL |
1 |
546 |
0 |
71 |
1 |
3 |
2026-08-11T13:11:06.980000Z |
play_count |
0 |
LOCAL |
0 |
547 |
0 |
8 |
0 |
0 |
2026-08-11T13:11:06.980000Z |
play_count |
0 |
LOCAL |
0 |
548 |
6692718 |
71355 |
55 |
625 |
2026-08-12T09:20:58.961000Z |
play_count |
6692718 |
LOCAL |
1 |
549 |
40472835 |
590105 |
569 |
4753 |
2026-08-14T07:46:10.873000Z |
play_count |
40472835 |
LOCAL |
1 |
550 |
16460286 |
120164 |
475 |
2464 |
2026-08-11T13:11:06.980000Z |
play_count |
16460286 |
LOCAL |
1 |
551 |
1438 |
42 |
5 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
1438 |
LOCAL |
1 |
552 |
0 |
43 |
0 |
1 |
2026-08-11T13:11:06.980000Z |
play_count |
0 |
LOCAL |
0 |
553 |
764366 |
11296 |
24 |
169 |
2026-08-12T13:57:35.663000Z |
play_count |
764366 |
LOCAL |
1 |
554 |
6785030 |
183061 |
1019 |
5666 |
2026-08-12T09:21:15.133000Z |
play_count |
6785030 |
LOCAL |
1 |
555 |
24108 |
343 |
135 |
7 |
2026-08-11T13:11:06.980000Z |
play_count |
24108 |
LOCAL |
1 |
556 |
6052 |
66 |
16 |
0 |
2026-08-12T01:48:43.832000Z |
play_count |
6052 |
LOCAL |
1 |
557 |
514185 |
10212 |
468 |
241 |
2026-08-11T13:11:06.980000Z |
play_count |
514185 |
LOCAL |
1 |
558 |
6890 |
67 |
1 |
1 |
2026-08-11T13:11:06.980000Z |
play_count |
6890 |
LOCAL |
1 |
559 |
23560 |
2007 |
76 |
11 |
2026-08-12T13:48:49.406000Z |
play_count |
23560 |
LOCAL |
1 |
560 |
968482 |
11070 |
2302 |
103 |
2026-08-12T03:45:26.866Z |
play_count |
935383 |
LOCAL |
1 |
561 |
32278377 |
360107 |
1517 |
4466 |
2026-08-12T13:47:19.401000Z |
play_count |
32278377 |
LOCAL |
1 |
562 |
1912644 |
12814 |
29 |
171 |
2026-08-11T13:13:10Z |
play_count |
1912644 |
SERVER |
1 |
563 |
4285422 |
15290 |
184 |
92 |
2026-08-12T13:47:19.401000Z |
play_count |
4285422 |
LOCAL |
1 |
564 |
11987018 |
49783 |
42 |
570 |
2026-08-12T13:56:21.365000Z |
play_count |
11987018 |
LOCAL |
1 |
565 |
141827 |
729 |
107 |
13 |
2026-08-12T13:48:49.406000Z |
play_count |
141827 |
LOCAL |
1 |
566 |
0 |
3 |
1 |
0 |
2026-08-11T13:12:28.808000Z |
play_count |
0 |
LOCAL |
0 |
567 |
18481 |
114 |
5 |
0 |
2026-08-11T13:13:10Z |
play_count |
18481 |
SERVER |
1 |
568 |
12233 |
116 |
11 |
1 |
2026-08-12T03:15:08.142000Z |
play_count |
12233 |
LOCAL |
1 |
569 |
13687155 |
249984 |
866 |
2266 |
2026-08-12T13:56:05.750000Z |
play_count |
13687155 |
LOCAL |
1 |
570 |
2447639 |
18151 |
45 |
805 |
2026-08-11T13:12:28.808000Z |
play_count |
2447639 |
LOCAL |
1 |
571 |
3772998 |
8471 |
8 |
119 |
2026-08-11T13:12:28.808000Z |
play_count |
3772998 |
LOCAL |
1 |
572 |
87154 |
708 |
17 |
0 |
2026-08-12T13:43:24Z |
play_count |
87154 |
SERVER |
1 |
575 |
167575 |
3023 |
336 |
40 |
2026-08-11T13:13:10Z |
play_count |
167575 |
SERVER |
1 |
576 |
165790 |
1358 |
85 |
11 |
2026-08-11T13:12:28.808000Z |
play_count |
165790 |
LOCAL |
1 |
577 |
159701 |
546 |
13 |
6 |
2026-08-11T13:13:10Z |
play_count |
159701 |
SERVER |
1 |
578 |
210688 |
2623 |
1466 |
23 |
2026-08-11T13:13:10Z |
play_count |
210688 |
SERVER |
1 |
599 |
3824818 |
40910 |
373 |
707 |
2026-08-12T13:47:37.115000Z |
play_count |
3824818 |
LOCAL |
1 |
600 |
7302508 |
73870 |
10695 |
1247 |
2026-08-16T12:03:28.838000Z |
play_count |
7302508 |
LOCAL |
1 |
601 |
660136 |
10986 |
73 |
252 |
2026-08-11T13:12:51.151000Z |
play_count |
660136 |
LOCAL |
1 |
602 |
7667453 |
155152 |
924 |
2555 |
2026-08-15T04:40:07.790000Z |
play_count |
7667453 |
LOCAL |
1 |
603 |
1745816 |
8830 |
127 |
185 |
2026-08-11T13:12:51.151000Z |
play_count |
1745816 |
LOCAL |
1 |
604 |
2321203 |
29728 |
2687 |
822 |
2026-08-16T13:49:41.254000Z |
play_count |
2321203 |
LOCAL |
1 |
605 |
4244653 |
17209 |
219 |
1005 |
2026-08-14T07:04:55.410000Z |
play_count |
4244653 |
LOCAL |
1 |
606 |
29805218 |
55736 |
473 |
1490 |
2026-08-11T13:12:51.151000Z |
play_count |
29805218 |
LOCAL |
1 |
607 |
6082527 |
160390 |
0 |
3285 |
2026-08-11T14:10:40.629000Z |
play_count |
6082527 |
LOCAL |
1 |
608 |
705185 |
15231 |
5384 |
312 |
2026-08-11T13:12:51.151000Z |
play_count |
705185 |
LOCAL |
1 |
609 |
163919548 |
3193407 |
54210 |
59664 |
2026-08-12T13:48:01.295000Z |
play_count |
163919548 |
LOCAL |
1 |
610 |
458441 |
2347 |
36 |
167 |
2026-08-15T04:39:58.933000Z |
play_count |
458441 |
LOCAL |
1 |
611 |
3392 |
57 |
73 |
8 |
2026-08-12T13:41:28Z |
play_count |
3392 |
SERVER |
1 |
612 |
0 |
10 |
1 |
0 |
2026-08-11T13:12:51.151000Z |
play_count |
0 |
LOCAL |
0 |
613 |
1281218 |
17065 |
83 |
220 |
2026-08-11T13:12:51.151000Z |
play_count |
1281218 |
LOCAL |
1 |
614 |
1779987 |
15155 |
175 |
424 |
2026-08-11T13:12:51.151000Z |
play_count |
1779987 |
LOCAL |
1 |
615 |
795 |
31 |
0 |
6 |
2026-08-11T14:20:22.348000Z |
play_count |
795 |
LOCAL |
1 |
616 |
4075637 |
61354 |
0 |
1600 |
2026-08-11T14:52:35.100000Z |
play_count |
4075637 |
LOCAL |
1 |
617 |
7371818 |
312854 |
171 |
3971 |
2026-08-16T12:03:28.838000Z |
play_count |
7371818 |
LOCAL |
1 |
618 |
34396583 |
513299 |
774 |
7144 |
2026-08-12T01:48:43.832000Z |
play_count |
34396583 |
LOCAL |
1 |
653 |
177969 |
1377 |
49 |
48 |
2026-08-12T09:20:58.961000Z |
play_count |
177969 |
LOCAL |
1 |
654 |
310623 |
1529 |
89 |
28 |
2026-08-15T04:41:59.380000Z |
play_count |
310623 |
LOCAL |
1 |
655 |
3336 |
29 |
2 |
0 |
2026-08-12T23:05:03.584000Z |
play_count |
3336 |
LOCAL |
1 |
656 |
983016 |
19071 |
245 |
267 |
2026-08-16T13:42:47.786000Z |
play_count |
983016 |
LOCAL |
1 |
657 |
0 |
41 |
1 |
3 |
2026-08-11T15:10:27.241000Z |
play_count |
42 |
LOCAL |
0 |
658 |
2266 |
34 |
8 |
0 |
2026-08-12T13:57:35.663000Z |
play_count |
2266 |
LOCAL |
1 |
659 |
4931268 |
14189 |
59 |
536 |
2026-08-12T14:01:02.727000Z |
play_count |
4931268 |
LOCAL |
1 |
660 |
3012 |
39 |
0 |
1 |
2026-08-11T14:10:40Z |
play_count |
3012 |
SERVER |
1 |
661 |
0 |
320 |
13 |
12 |
2026-08-12T09:21:15.133000Z |
play_count |
333 |
LOCAL |
0 |
662 |
460442 |
4673 |
0 |
225 |
2026-08-11T14:51:41.138000Z |
play_count |
460442 |
LOCAL |
1 |
663 |
26830496 |
533991 |
716 |
20562 |
2026-08-14T07:02:44.707000Z |
play_count |
26830496 |
LOCAL |
1 |