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 |
|---|---|---|---|---|---|---|---|---|---|---|
501 |
602 |
7564529 |
150872 |
875 |
2479 |
2026-08-11T13:12:51.151000Z |
play_count |
7564529 |
LOCAL |
1 |
502 |
603 |
1745816 |
8830 |
127 |
185 |
2026-08-11T13:12:51.151000Z |
play_count |
1745816 |
LOCAL |
1 |
503 |
604 |
2409667 |
27553 |
2424 |
768 |
2026-08-11T13:12:51.151000Z |
play_count |
2409667 |
LOCAL |
1 |
504 |
605 |
4201789 |
16744 |
218 |
991 |
2026-08-11T13:12:51.151000Z |
play_count |
4201789 |
LOCAL |
1 |
505 |
606 |
29805218 |
55736 |
473 |
1490 |
2026-08-11T13:12:51.151000Z |
play_count |
29805218 |
LOCAL |
1 |
506 |
607 |
6080804 |
160328 |
293 |
3282 |
2026-08-11T13:12:51.151000Z |
play_count |
6080804 |
LOCAL |
1 |
507 |
608 |
705185 |
15231 |
5384 |
312 |
2026-08-11T13:12:51.151000Z |
play_count |
705185 |
LOCAL |
1 |
508 |
609 |
168481378 |
3187622 |
54115 |
59512 |
2026-08-11T13:12:51.151000Z |
play_count |
168481378 |
LOCAL |
1 |
509 |
610 |
453667 |
2328 |
35 |
166 |
2026-08-11T13:12:51.151000Z |
play_count |
453667 |
LOCAL |
1 |
510 |
611 |
3200 |
56 |
73 |
8 |
2026-08-11T13:12:51.151000Z |
play_count |
3200 |
LOCAL |
1 |
511 |
612 |
0 |
10 |
1 |
0 |
2026-08-11T13:12:51.151000Z |
play_count |
0 |
LOCAL |
0 |
512 |
613 |
1281218 |
17065 |
83 |
220 |
2026-08-11T13:12:51.151000Z |
play_count |
1281218 |
LOCAL |
1 |
513 |
614 |
1779987 |
15155 |
175 |
424 |
2026-08-11T13:12:51.151000Z |
play_count |
1779987 |
LOCAL |
1 |
514 |
615 |
1453 |
31 |
67 |
6 |
2026-08-11T13:12:51.151000Z |
play_count |
1453 |
LOCAL |
1 |
515 |
616 |
7437311 |
61337 |
1965 |
1600 |
2026-08-11T13:12:51.151000Z |
play_count |
7437311 |
LOCAL |
1 |
516 |
617 |
6957854 |
287580 |
150 |
3559 |
2026-08-11T13:12:51.151000Z |
play_count |
6957854 |
LOCAL |
1 |
517 |
618 |
34384812 |
513214 |
774 |
7145 |
2026-08-11T13:12:51.151000Z |
play_count |
34384812 |
LOCAL |
1 |
518 |
559 |
307419 |
1964 |
72 |
9 |
2026-08-11T13:13:10Z |
play_count |
307419 |
SERVER |
1 |
519 |
577 |
159701 |
546 |
13 |
6 |
2026-08-11T13:13:10Z |
play_count |
159701 |
SERVER |
1 |
520 |
567 |
18481 |
114 |
5 |
0 |
2026-08-11T13:13:10Z |
play_count |
18481 |
SERVER |
1 |
521 |
568 |
15550 |
110 |
10 |
1 |
2026-08-11T13:13:10Z |
play_count |
15550 |
SERVER |
1 |
522 |
560 |
941055 |
10769 |
2200 |
101 |
2026-08-11T13:13:10Z |
play_count |
941055 |
SERVER |
1 |
523 |
578 |
210688 |
2623 |
1466 |
23 |
2026-08-11T13:13:10Z |
play_count |
210688 |
SERVER |
1 |
524 |
561 |
32130286 |
357136 |
1517 |
4444 |
2026-08-11T13:13:10Z |
play_count |
32130286 |
SERVER |
1 |
525 |
562 |
1912644 |
12814 |
29 |
171 |
2026-08-11T13:13:10Z |
play_count |
1912644 |
SERVER |
1 |
526 |
563 |
4020192 |
13966 |
174 |
83 |
2026-08-11T13:13:10Z |
play_count |
4020192 |
SERVER |
1 |
527 |
569 |
13654498 |
249399 |
865 |
2257 |
2026-08-11T13:13:10Z |
play_count |
13654498 |
SERVER |
1 |
528 |
572 |
78017 |
674 |
12 |
0 |
2026-08-11T13:13:10Z |
play_count |
78017 |
SERVER |
1 |
529 |
301 |
1033742 |
30110 |
474 |
1093 |
2026-08-11T13:13:10Z |
play_count |
1033742 |
SERVER |
1 |
530 |
305 |
57861473 |
434875 |
2093 |
6183 |
2026-08-11T13:13:10Z |
play_count |
57861473 |
SERVER |
1 |
531 |
575 |
167575 |
3023 |
336 |
40 |
2026-08-11T13:13:10Z |
play_count |
167575 |
SERVER |
1 |
532 |
653 |
175538 |
1356 |
0 |
48 |
2026-08-11T14:10:25.067000Z |
play_count |
175538 |
LOCAL |
1 |
533 |
654 |
285183 |
1406 |
0 |
24 |
2026-08-11T14:10:25.067000Z |
play_count |
285183 |
LOCAL |
1 |
534 |
655 |
3289 |
26 |
0 |
0 |
2026-08-11T14:10:25.067000Z |
play_count |
3289 |
LOCAL |
1 |
535 |
656 |
946376 |
17129 |
0 |
250 |
2026-08-11T14:10:25.067000Z |
play_count |
946376 |
LOCAL |
1 |
536 |
658 |
2084 |
29 |
0 |
0 |
2026-08-11T14:10:25.067000Z |
play_count |
2084 |
LOCAL |
1 |
537 |
659 |
4763611 |
13668 |
0 |
516 |
2026-08-11T14:10:25.067000Z |
play_count |
4763611 |
LOCAL |
1 |
538 |
660 |
2425 |
39 |
0 |
1 |
2026-08-11T14:10:25.067000Z |
play_count |
2425 |
LOCAL |
1 |
539 |
661 |
0 |
312 |
0 |
12 |
2026-08-11T14:10:25.067000Z |
play_count |
0 |
LOCAL |
0 |
540 |
662 |
460363 |
4670 |
0 |
225 |
2026-08-11T14:10:25.067000Z |
play_count |
460363 |
LOCAL |
1 |
541 |
663 |
23890295 |
470754 |
0 |
18065 |
2026-08-11T14:10:25.067000Z |
play_count |
23890295 |
LOCAL |
1 |
542 |
664 |
22776283 |
390035 |
0 |
3809 |
2026-08-11T14:10:25.067000Z |
play_count |
22776283 |
LOCAL |
1 |
543 |
665 |
64973 |
817 |
0 |
15 |
2026-08-11T14:10:25.067000Z |
play_count |
64973 |
LOCAL |
1 |
544 |
666 |
9913977 |
41429 |
0 |
722 |
2026-08-11T14:10:25.067000Z |
play_count |
9913977 |
LOCAL |
1 |
545 |
667 |
40213720 |
1228128 |
0 |
61436 |
2026-08-11T14:10:25.067000Z |
play_count |
40213720 |
LOCAL |
1 |
546 |
668 |
1924182 |
25366 |
0 |
291 |
2026-08-11T14:10:25.067000Z |
play_count |
1924182 |
LOCAL |
1 |
547 |
657 |
0 |
41 |
0 |
3 |
2026-08-11T14:10:25.067000Z |
play_count |
0 |
LOCAL |
0 |
548 |
670 |
221888 |
8642 |
0 |
81 |
2026-08-11T14:10:25.067000Z |
play_count |
221888 |
LOCAL |
1 |
549 |
671 |
12716615 |
100305 |
0 |
3611 |
2026-08-11T14:10:25.067000Z |
play_count |
12716615 |
LOCAL |
1 |
550 |
672 |
8053168 |
36909 |
0 |
0 |
2026-08-11T14:10:25.067000Z |
play_count |
8053168 |
LOCAL |
1 |
551 |
673 |
8656676 |
108645 |
0 |
2202 |
2026-08-11T14:10:25.067000Z |
play_count |
8656676 |
LOCAL |
1 |
552 |
291 |
89208 |
962 |
0 |
16 |
2026-08-11T14:10:40.629000Z |
play_count |
89208 |
LOCAL |
1 |
553 |
697 |
940106 |
7405 |
0 |
84 |
2026-08-11T14:10:40.629000Z |
play_count |
940106 |
LOCAL |
1 |
554 |
698 |
7470676 |
142680 |
0 |
1779 |
2026-08-11T14:10:40.629000Z |
play_count |
7470676 |
LOCAL |
1 |
555 |
699 |
571998 |
21185 |
0 |
389 |
2026-08-11T14:10:40.629000Z |
play_count |
571998 |
LOCAL |
1 |
556 |
541 |
6189 |
3 |
0 |
2 |
2026-08-11T14:10:40.629000Z |
play_count |
6189 |
LOCAL |
1 |
557 |
701 |
206325 |
1158 |
0 |
45 |
2026-08-11T14:10:40.629000Z |
play_count |
206325 |
LOCAL |
1 |
558 |
702 |
12076618 |
18507 |
0 |
593 |
2026-08-11T14:10:40.629000Z |
play_count |
12076618 |
LOCAL |
1 |
559 |
687 |
0 |
3 |
0 |
0 |
2026-08-11T14:10:40.629000Z |
play_count |
0 |
LOCAL |
0 |
560 |
704 |
949103 |
14648 |
0 |
208 |
2026-08-11T14:10:40.629000Z |
play_count |
949103 |
LOCAL |
1 |
561 |
705 |
10145950 |
780447 |
0 |
13695 |
2026-08-11T14:10:40.629000Z |
play_count |
10145950 |
LOCAL |
1 |
562 |
706 |
43672338 |
555875 |
0 |
8841 |
2026-08-11T14:10:40.629000Z |
play_count |
43672338 |
LOCAL |
1 |
563 |
690 |
0 |
39 |
0 |
1 |
2026-08-11T14:10:40.629000Z |
play_count |
0 |
LOCAL |
0 |
564 |
708 |
3613834 |
79025 |
0 |
1378 |
2026-08-11T14:10:40.629000Z |
play_count |
3613834 |
LOCAL |
1 |
565 |
709 |
8828025 |
209769 |
0 |
4421 |
2026-08-11T14:10:40.629000Z |
play_count |
8828025 |
LOCAL |
1 |
566 |
710 |
8347977 |
113761 |
0 |
1336 |
2026-08-11T14:10:40.629000Z |
play_count |
8347977 |
LOCAL |
1 |
567 |
711 |
1609963 |
60235 |
0 |
1239 |
2026-08-11T14:10:40.629000Z |
play_count |
1609963 |
LOCAL |
1 |
568 |
712 |
62450154 |
482711 |
0 |
8272 |
2026-08-11T14:10:40.629000Z |
play_count |
62450154 |
LOCAL |
1 |
569 |
607 |
6082527 |
160390 |
0 |
3285 |
2026-08-11T14:10:40.629000Z |
play_count |
6082527 |
LOCAL |
1 |
570 |
714 |
2370382 |
28608 |
0 |
566 |
2026-08-11T14:10:40.629000Z |
play_count |
2370382 |
LOCAL |
1 |
571 |
715 |
1292 |
28 |
0 |
0 |
2026-08-11T14:10:40.629000Z |
play_count |
1292 |
LOCAL |
1 |
572 |
716 |
24256272 |
192242 |
0 |
5156 |
2026-08-11T14:10:40.629000Z |
play_count |
24256272 |
LOCAL |
1 |
573 |
717 |
619364 |
8341 |
0 |
183 |
2026-08-11T14:10:40.629000Z |
play_count |
619364 |
LOCAL |
1 |
574 |
718 |
4885887 |
26839 |
0 |
856 |
2026-08-11T14:10:40.629000Z |
play_count |
4885887 |
LOCAL |
1 |
575 |
653 |
190653 |
1356 |
0 |
48 |
2026-08-11T14:10:40Z |
play_count |
190653 |
SERVER |
1 |
576 |
655 |
3552 |
26 |
0 |
0 |
2026-08-11T14:10:40Z |
play_count |
3552 |
SERVER |
1 |
577 |
660 |
3012 |
39 |
0 |
1 |
2026-08-11T14:10:40Z |
play_count |
3012 |
SERVER |
1 |
578 |
658 |
2370 |
29 |
0 |
0 |
2026-08-11T14:10:40Z |
play_count |
2370 |
SERVER |
1 |
579 |
656 |
2552765 |
17129 |
0 |
250 |
2026-08-11T14:10:40Z |
play_count |
2552765 |
SERVER |
1 |
580 |
663 |
24032118 |
470754 |
0 |
18065 |
2026-08-11T14:10:40Z |
play_count |
24032118 |
SERVER |
1 |
581 |
670 |
754569 |
8642 |
0 |
81 |
2026-08-11T14:10:40Z |
play_count |
754569 |
SERVER |
1 |
582 |
665 |
85004 |
817 |
0 |
15 |
2026-08-11T14:10:40Z |
play_count |
85004 |
SERVER |
1 |
583 |
668 |
2173566 |
25366 |
0 |
291 |
2026-08-11T14:10:40Z |
play_count |
2173566 |
SERVER |
1 |
584 |
751 |
33746 |
3 |
0 |
13 |
2026-08-11T14:19:00.838000Z |
play_count |
33746 |
LOCAL |
1 |
585 |
752 |
16757 |
3 |
0 |
9 |
2026-08-11T14:19:00.838000Z |
play_count |
16757 |
LOCAL |
1 |
586 |
753 |
18858582 |
299013 |
0 |
4494 |
2026-08-11T14:19:00.838000Z |
play_count |
18858582 |
LOCAL |
1 |
587 |
754 |
16284 |
129 |
0 |
1 |
2026-08-11T14:19:00.838000Z |
play_count |
16284 |
LOCAL |
1 |
588 |
755 |
3794 |
19 |
0 |
1 |
2026-08-11T14:19:00.838000Z |
play_count |
3794 |
LOCAL |
1 |
589 |
756 |
17670 |
3 |
0 |
5 |
2026-08-11T14:19:00.838000Z |
play_count |
17670 |
LOCAL |
1 |
590 |
757 |
582343 |
802 |
0 |
0 |
2026-08-11T14:19:00.838000Z |
play_count |
582343 |
LOCAL |
1 |
591 |
758 |
0 |
1933 |
0 |
43 |
2026-08-11T14:19:00.838000Z |
play_count |
0 |
LOCAL |
0 |
592 |
760 |
0 |
3 |
0 |
2 |
2026-08-11T14:19:00.838000Z |
play_count |
0 |
LOCAL |
0 |
593 |
761 |
561921 |
27607 |
0 |
253 |
2026-08-11T14:19:00.838000Z |
play_count |
561921 |
LOCAL |
1 |
594 |
762 |
23642287 |
96538 |
0 |
4870 |
2026-08-11T14:19:00.838000Z |
play_count |
23642287 |
LOCAL |
1 |
595 |
763 |
13018905 |
3 |
0 |
4025 |
2026-08-11T14:19:00.838000Z |
play_count |
13018905 |
LOCAL |
1 |
596 |
764 |
1897 |
7 |
0 |
0 |
2026-08-11T14:19:00.838000Z |
play_count |
1897 |
LOCAL |
1 |
597 |
765 |
13827 |
81 |
0 |
0 |
2026-08-11T14:19:00.838000Z |
play_count |
13827 |
LOCAL |
1 |
598 |
766 |
73424132 |
378007 |
0 |
12152 |
2026-08-11T14:19:00.838000Z |
play_count |
73424132 |
LOCAL |
1 |
599 |
767 |
100569645 |
1672710 |
0 |
19863 |
2026-08-11T14:19:00.838000Z |
play_count |
100569645 |
LOCAL |
1 |
600 |
768 |
14698080 |
74504 |
0 |
1425 |
2026-08-11T14:19:00.838000Z |
play_count |
14698080 |
LOCAL |
1 |