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 |
|---|---|---|---|---|---|---|---|---|---|---|
901 |
1452 |
58634743 |
764983 |
1653 |
19062 |
2026-08-12T01:50:52.122Z |
0 |
LOCAL |
0 |
|
902 |
291 |
93332 |
991 |
387 |
17 |
2026-08-12T01:56:49.305000Z |
play_count |
93332 |
LOCAL |
1 |
903 |
1498 |
3215540 |
44886 |
430 |
1026 |
2026-08-12T01:56:49.305000Z |
play_count |
3215540 |
LOCAL |
1 |
904 |
1069 |
115801907 |
7956126 |
20197 |
195568 |
2026-08-12T01:56:49.305000Z |
play_count |
115801907 |
LOCAL |
1 |
905 |
1192 |
513 |
25 |
4 |
1 |
2026-08-12T01:56:49.305000Z |
play_count |
513 |
LOCAL |
1 |
906 |
553 |
762649 |
11262 |
24 |
168 |
2026-08-12T01:56:49.305000Z |
play_count |
762649 |
LOCAL |
1 |
907 |
1502 |
34670034 |
2388864 |
8050 |
30571 |
2026-08-12T01:56:49.305000Z |
play_count |
34670034 |
LOCAL |
1 |
908 |
1328 |
54471534 |
338693 |
781 |
20382 |
2026-08-12T01:56:49.305000Z |
play_count |
54471534 |
LOCAL |
1 |
909 |
1504 |
2831192 |
3 |
571 |
1351 |
2026-08-12T01:56:49.305000Z |
play_count |
2831192 |
LOCAL |
1 |
910 |
1505 |
9384490 |
135882 |
319 |
2067 |
2026-08-12T01:56:49.305000Z |
play_count |
9384490 |
LOCAL |
1 |
911 |
1506 |
12521054 |
42379 |
141 |
592 |
2026-08-12T01:56:49.305000Z |
play_count |
12521054 |
LOCAL |
1 |
912 |
1507 |
19630758 |
164888 |
864 |
2795 |
2026-08-12T01:56:49.305000Z |
play_count |
19630758 |
LOCAL |
1 |
913 |
549 |
36528322 |
522569 |
509 |
4180 |
2026-08-12T01:56:49.305000Z |
play_count |
36528322 |
LOCAL |
1 |
914 |
1509 |
2855 |
37 |
0 |
1 |
2026-08-12T01:56:49.305000Z |
play_count |
2855 |
LOCAL |
1 |
915 |
554 |
6777749 |
182791 |
1018 |
5655 |
2026-08-12T01:56:49.305000Z |
play_count |
6777749 |
LOCAL |
1 |
916 |
1511 |
2414352 |
36893 |
24 |
338 |
2026-08-12T01:56:49.305000Z |
play_count |
2414352 |
LOCAL |
1 |
917 |
1196 |
1706176 |
13850 |
103 |
201 |
2026-08-12T01:56:49.305000Z |
play_count |
1706176 |
LOCAL |
1 |
918 |
538 |
1405591 |
28143 |
20571 |
229 |
2026-08-12T01:56:49.305000Z |
play_count |
1405591 |
LOCAL |
1 |
919 |
1514 |
70014487 |
3176966 |
9740 |
48960 |
2026-08-12T01:56:49.305000Z |
play_count |
70014487 |
LOCAL |
1 |
920 |
564 |
11963161 |
49624 |
42 |
570 |
2026-08-12T01:56:49.305000Z |
play_count |
11963161 |
LOCAL |
1 |
921 |
1516 |
859 |
13 |
2 |
0 |
2026-08-12T01:56:49.305000Z |
play_count |
859 |
LOCAL |
1 |
922 |
1075 |
59032335 |
739047 |
984 |
36454 |
2026-08-12T01:56:49.305000Z |
play_count |
59032335 |
LOCAL |
1 |
923 |
718 |
5011435 |
27808 |
197 |
883 |
2026-08-12T01:56:57.451Z |
0 |
LOCAL |
0 |
|
924 |
1339 |
1387863 |
32688 |
254 |
322 |
2026-08-12T01:58:08Z |
play_count |
1387863 |
SERVER |
1 |
925 |
1339 |
1387863 |
32688 |
254 |
322 |
2026-08-12T01:58:11.794Z |
0 |
LOCAL |
0 |
|
926 |
1339 |
1387863 |
32699 |
254 |
322 |
2026-08-12T03:14:06.273000Z |
play_count |
32953 |
LOCAL |
1 |
927 |
1339 |
1388349 |
32699 |
254 |
322 |
2026-08-12T03:14:52Z |
play_count |
1388349 |
SERVER |
1 |
928 |
1550 |
0 |
29 |
9 |
0 |
2026-08-12T03:15:03.730000Z |
play_count |
38 |
LOCAL |
0 |
929 |
1547 |
1278 |
16 |
16 |
0 |
2026-08-12T03:15:03.730000Z |
play_count |
1278 |
LOCAL |
1 |
930 |
1551 |
0 |
10 |
1 |
0 |
2026-08-12T03:15:03.730000Z |
play_count |
11 |
LOCAL |
0 |
931 |
1552 |
0 |
13 |
16 |
1 |
2026-08-12T03:15:03.730000Z |
play_count |
29 |
LOCAL |
0 |
932 |
1548 |
656 |
7 |
1 |
0 |
2026-08-12T03:15:03.730000Z |
play_count |
656 |
LOCAL |
1 |
933 |
1549 |
0 |
42 |
1 |
0 |
2026-08-12T03:15:03.730000Z |
play_count |
43 |
LOCAL |
0 |
934 |
559 |
23029 |
1998 |
76 |
10 |
2026-08-12T03:15:08.142000Z |
play_count |
23029 |
LOCAL |
1 |
935 |
886 |
1929668 |
13776 |
180 |
316 |
2026-08-12T03:15:08.142000Z |
play_count |
1929668 |
LOCAL |
1 |
936 |
1570 |
555763 |
14040 |
40 |
135 |
2026-08-12T03:15:08.142000Z |
play_count |
555763 |
LOCAL |
1 |
937 |
534 |
23495 |
598 |
2 |
2 |
2026-08-12T03:15:08.142000Z |
play_count |
23495 |
LOCAL |
1 |
938 |
1572 |
4856591 |
78852 |
135 |
632 |
2026-08-12T03:15:08.142000Z |
play_count |
4856591 |
LOCAL |
1 |
939 |
1573 |
2744422 |
59923 |
316 |
2461 |
2026-08-12T03:15:08.142000Z |
play_count |
2744422 |
LOCAL |
1 |
940 |
658 |
2227 |
34 |
8 |
0 |
2026-08-12T03:15:08.142000Z |
play_count |
2227 |
LOCAL |
1 |
941 |
1417 |
5623 |
51 |
5 |
1 |
2026-08-12T03:15:08.142000Z |
play_count |
5623 |
LOCAL |
1 |
942 |
605 |
4211957 |
16846 |
219 |
995 |
2026-08-12T03:15:08.142000Z |
play_count |
4211957 |
LOCAL |
1 |
943 |
560 |
935383 |
11070 |
2302 |
103 |
2026-08-12T03:15:08.142000Z |
play_count |
935383 |
LOCAL |
1 |
944 |
301 |
925414 |
30251 |
479 |
1097 |
2026-08-12T03:15:08.142000Z |
play_count |
925414 |
LOCAL |
1 |
945 |
1408 |
8819 |
79 |
2 |
3 |
2026-08-12T03:15:08.142000Z |
play_count |
8819 |
LOCAL |
1 |
946 |
1580 |
3426472 |
16396 |
41 |
306 |
2026-08-12T03:15:08.142000Z |
play_count |
3426472 |
LOCAL |
1 |
947 |
1582 |
3004565 |
74071 |
161 |
1236 |
2026-08-12T03:15:08.142000Z |
play_count |
3004565 |
LOCAL |
1 |
948 |
1583 |
1960658 |
39251 |
140 |
575 |
2026-08-12T03:15:08.142000Z |
play_count |
1960658 |
LOCAL |
1 |
949 |
1584 |
7639704 |
141724 |
526 |
3249 |
2026-08-12T03:15:08.142000Z |
play_count |
7639704 |
LOCAL |
1 |
950 |
1585 |
2364157 |
19919 |
87 |
586 |
2026-08-12T03:15:08.142000Z |
play_count |
2364157 |
LOCAL |
1 |
951 |
769 |
5703 |
40 |
2 |
1 |
2026-08-12T03:15:08.142000Z |
play_count |
5703 |
LOCAL |
1 |
952 |
568 |
12233 |
116 |
11 |
1 |
2026-08-12T03:15:08.142000Z |
play_count |
12233 |
LOCAL |
1 |
953 |
560 |
968482 |
11070 |
2302 |
103 |
2026-08-12T03:15:21.645Z |
0 |
LOCAL |
0 |
|
954 |
1612 |
0 |
2076 |
92 |
374 |
2026-08-12T03:19:23.023000Z |
play_count |
2168 |
LOCAL |
0 |
955 |
1613 |
0 |
23271 |
1140 |
367 |
2026-08-12T03:19:23.023000Z |
play_count |
24411 |
LOCAL |
0 |
956 |
313 |
602143 |
6349 |
8060 |
1201 |
2026-08-12T03:19:27.971000Z |
play_count |
602143 |
LOCAL |
1 |
957 |
1615 |
6401459 |
180933 |
2687 |
2955 |
2026-08-12T03:19:27.971000Z |
play_count |
6401459 |
LOCAL |
1 |
958 |
1616 |
6096 |
22 |
18 |
9 |
2026-08-12T03:19:27.971000Z |
play_count |
6096 |
LOCAL |
1 |
959 |
1612 |
612926 |
2076 |
92 |
374 |
2026-08-12T03:20:27.675000Z |
play_count |
612926 |
LOCAL |
1 |
960 |
1613 |
887564 |
23271 |
1140 |
367 |
2026-08-12T03:20:27.675000Z |
play_count |
887564 |
LOCAL |
1 |
961 |
560 |
968482 |
11070 |
2302 |
103 |
2026-08-12T03:45:26.866Z |
0 |
LOCAL |
0 |
|
962 |
290 |
48674216 |
1598365 |
1681 |
33326 |
2026-08-12T09:14:18.405000Z |
play_count |
48674216 |
LOCAL |
1 |
963 |
653 |
177957 |
1377 |
49 |
48 |
2026-08-12T09:14:18.405000Z |
play_count |
177957 |
LOCAL |
1 |
964 |
1498 |
3228019 |
45046 |
452 |
1034 |
2026-08-12T09:14:18.405000Z |
play_count |
3228019 |
LOCAL |
1 |
965 |
553 |
763719 |
11284 |
24 |
168 |
2026-08-12T09:14:18.405000Z |
play_count |
763719 |
LOCAL |
1 |
966 |
1678 |
742866 |
33417 |
237 |
542 |
2026-08-12T09:14:18.405000Z |
play_count |
742866 |
LOCAL |
1 |
967 |
561 |
25687851 |
359473 |
1517 |
4459 |
2026-08-12T09:14:18.405000Z |
play_count |
25687851 |
LOCAL |
1 |
968 |
1680 |
858547 |
18447 |
277 |
324 |
2026-08-12T09:14:18.405000Z |
play_count |
858547 |
LOCAL |
1 |
969 |
1325 |
597964 |
11344 |
414 |
0 |
2026-08-12T09:14:18.405000Z |
play_count |
597964 |
LOCAL |
1 |
970 |
548 |
6692433 |
71353 |
55 |
625 |
2026-08-12T09:14:18.405000Z |
play_count |
6692433 |
LOCAL |
1 |
971 |
1683 |
14690035 |
474935 |
1132 |
3546 |
2026-08-12T09:14:18.405000Z |
play_count |
14690035 |
LOCAL |
1 |
972 |
1327 |
3397726 |
83581 |
61 |
339 |
2026-08-12T09:14:18.405000Z |
play_count |
3397726 |
LOCAL |
1 |
973 |
1448 |
118070 |
6815 |
101 |
35 |
2026-08-12T09:14:18.405000Z |
play_count |
118070 |
LOCAL |
1 |
974 |
306 |
1860459 |
12435 |
141 |
277 |
2026-08-12T09:14:18.405000Z |
play_count |
1860459 |
LOCAL |
1 |
975 |
1368 |
1982 |
3 |
0 |
2 |
2026-08-12T09:14:18.405000Z |
play_count |
1982 |
LOCAL |
1 |
976 |
1688 |
8348 |
38 |
124 |
4 |
2026-08-12T09:14:18.405000Z |
play_count |
8348 |
LOCAL |
1 |
977 |
1689 |
1510747 |
18189 |
28 |
180 |
2026-08-12T09:14:18.405000Z |
play_count |
1510747 |
LOCAL |
1 |
978 |
292 |
563708 |
13678 |
24 |
199 |
2026-08-12T09:14:18.405000Z |
play_count |
563708 |
LOCAL |
1 |
979 |
309 |
1697 |
491 |
13 |
0 |
2026-08-12T09:14:18.405000Z |
play_count |
1697 |
LOCAL |
1 |
980 |
1692 |
692682 |
27064 |
65 |
299 |
2026-08-12T09:14:18.405000Z |
play_count |
692682 |
LOCAL |
1 |
981 |
1693 |
3762 |
256 |
10 |
9 |
2026-08-12T09:14:18.405000Z |
play_count |
3762 |
LOCAL |
1 |
982 |
300 |
2180 |
525 |
7 |
0 |
2026-08-12T09:14:18.405000Z |
play_count |
2180 |
LOCAL |
1 |
983 |
1372 |
7189635 |
75769 |
604 |
2010 |
2026-08-12T09:14:18.405000Z |
play_count |
7189635 |
LOCAL |
1 |
984 |
599 |
3818762 |
40806 |
371 |
707 |
2026-08-12T09:14:18.405000Z |
play_count |
3818762 |
LOCAL |
1 |
985 |
605 |
4215470 |
16886 |
219 |
997 |
2026-08-12T09:14:18Z |
play_count |
4215470 |
SERVER |
1 |
986 |
301 |
1038472 |
30287 |
479 |
1099 |
2026-08-12T09:14:59Z |
play_count |
1038472 |
SERVER |
1 |
987 |
1612 |
612965 |
2076 |
92 |
374 |
2026-08-12T09:15:15.640000Z |
play_count |
612965 |
LOCAL |
1 |
988 |
1724 |
120908 |
954 |
161 |
148 |
2026-08-12T09:15:15.640000Z |
play_count |
120908 |
LOCAL |
1 |
989 |
1727 |
59619 |
1412 |
31 |
30 |
2026-08-12T09:15:41.633000Z |
play_count |
59619 |
LOCAL |
1 |
990 |
1729 |
41880 |
664 |
14 |
10 |
2026-08-12T09:15:42.513000Z |
play_count |
41880 |
LOCAL |
1 |
991 |
1733 |
23283 |
327 |
3 |
2 |
2026-08-12T09:15:45.565000Z |
play_count |
23283 |
LOCAL |
1 |
992 |
1734 |
0 |
142 |
6 |
0 |
2026-08-12T09:15:45.565000Z |
play_count |
148 |
LOCAL |
0 |
993 |
1739 |
22440 |
332 |
4 |
4 |
2026-08-12T09:15:47.016000Z |
play_count |
22440 |
LOCAL |
1 |
994 |
1741 |
31952 |
426 |
8 |
9 |
2026-08-12T09:15:47.016000Z |
play_count |
31952 |
LOCAL |
1 |
995 |
1756 |
0 |
113 |
3 |
0 |
2026-08-12T09:16:06.430000Z |
play_count |
116 |
LOCAL |
0 |
996 |
1762 |
94789 |
1471 |
14 |
37 |
2026-08-12T09:16:08.059000Z |
play_count |
94789 |
LOCAL |
1 |
997 |
1763 |
58141 |
1086 |
36 |
37 |
2026-08-12T09:16:08.059000Z |
play_count |
58141 |
LOCAL |
1 |
998 |
1764 |
66106 |
675 |
5 |
2 |
2026-08-12T09:16:08.059000Z |
play_count |
66106 |
LOCAL |
1 |
999 |
1760 |
18809 |
312 |
14 |
4 |
2026-08-12T09:16:11.575000Z |
play_count |
18809 |
LOCAL |
1 |
1000 |
1772 |
40652 |
298 |
4 |
3 |
2026-08-12T09:16:22.594000Z |
play_count |
40652 |
LOCAL |
1 |