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 |
|---|---|---|---|---|---|---|---|---|---|---|
801 |
531 |
19493258 |
413786 |
3709 |
13561 |
2026-08-12T01:40:36.226000Z |
play_count |
19493258 |
LOCAL |
1 |
802 |
1243 |
4287027 |
3 |
158 |
778 |
2026-08-12T01:40:36.226000Z |
play_count |
4287027 |
LOCAL |
1 |
803 |
1141 |
4824055 |
26117 |
178 |
1632 |
2026-08-12T01:40:36.226000Z |
play_count |
4824055 |
LOCAL |
1 |
804 |
1194 |
0 |
14 |
1 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
15 |
LOCAL |
0 |
805 |
1246 |
3324473 |
3 |
1764 |
1954 |
2026-08-12T01:40:36.226000Z |
play_count |
3324473 |
LOCAL |
1 |
806 |
1154 |
2201346 |
13219 |
65 |
1044 |
2026-08-12T01:40:36.226000Z |
play_count |
2201346 |
LOCAL |
1 |
807 |
1248 |
1692 |
56 |
4 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
1692 |
LOCAL |
1 |
808 |
1249 |
993706 |
14674 |
3718 |
254 |
2026-08-12T01:40:36.226000Z |
play_count |
993706 |
LOCAL |
1 |
809 |
1155 |
2352898 |
32474 |
383 |
665 |
2026-08-12T01:40:36.226000Z |
play_count |
2352898 |
LOCAL |
1 |
810 |
1251 |
3633935 |
42319 |
54 |
768 |
2026-08-12T01:40:36.226000Z |
play_count |
3633935 |
LOCAL |
1 |
811 |
1252 |
84932946 |
6823530 |
129980 |
157197 |
2026-08-12T01:40:36.226000Z |
play_count |
84932946 |
LOCAL |
1 |
812 |
909 |
2005565 |
24242 |
179 |
962 |
2026-08-12T01:40:36.226000Z |
play_count |
2005565 |
LOCAL |
1 |
813 |
1254 |
128175621 |
2633220 |
4925 |
38333 |
2026-08-12T01:40:36.226000Z |
play_count |
128175621 |
LOCAL |
1 |
814 |
1255 |
23992270 |
304713 |
1760 |
4709 |
2026-08-12T01:40:36.226000Z |
play_count |
23992270 |
LOCAL |
1 |
815 |
1256 |
751317834 |
7735121 |
17264 |
723068 |
2026-08-12T01:40:36.226000Z |
play_count |
751317834 |
LOCAL |
1 |
816 |
292 |
561912 |
13643 |
24 |
199 |
2026-08-12T01:48:06.401000Z |
play_count |
561912 |
LOCAL |
1 |
817 |
1325 |
830287 |
11314 |
414 |
0 |
2026-08-12T01:48:06.401000Z |
play_count |
830287 |
LOCAL |
1 |
818 |
548 |
7508698 |
71267 |
55 |
625 |
2026-08-12T01:48:06.401000Z |
play_count |
7508698 |
LOCAL |
1 |
819 |
1327 |
9241048 |
83414 |
61 |
335 |
2026-08-12T01:48:06.401000Z |
play_count |
9241048 |
LOCAL |
1 |
820 |
1328 |
54468295 |
338658 |
781 |
20380 |
2026-08-12T01:48:06.401000Z |
play_count |
54468295 |
LOCAL |
1 |
821 |
1329 |
3450624 |
73359 |
2716 |
2218 |
2026-08-12T01:48:06.401000Z |
play_count |
3450624 |
LOCAL |
1 |
822 |
1330 |
31378 |
120 |
2 |
3 |
2026-08-12T01:48:06.401000Z |
play_count |
31378 |
LOCAL |
1 |
823 |
711 |
1621601 |
60590 |
889 |
1249 |
2026-08-12T01:48:06.401000Z |
play_count |
1621601 |
LOCAL |
1 |
824 |
1332 |
178738531 |
1448847 |
11557 |
37414 |
2026-08-12T01:48:06.401000Z |
play_count |
178738531 |
LOCAL |
1 |
825 |
1333 |
9644 |
44 |
92 |
0 |
2026-08-12T01:48:06.401000Z |
play_count |
9644 |
LOCAL |
1 |
826 |
1334 |
29031 |
312 |
13 |
5 |
2026-08-12T01:48:06.401000Z |
play_count |
29031 |
LOCAL |
1 |
827 |
1335 |
8255863 |
56824 |
233 |
1292 |
2026-08-12T01:48:06.401000Z |
play_count |
8255863 |
LOCAL |
1 |
828 |
1336 |
1214697 |
10101 |
439 |
298 |
2026-08-12T01:48:06.401000Z |
play_count |
1214697 |
LOCAL |
1 |
829 |
1337 |
11407493 |
113617 |
1987 |
5932 |
2026-08-12T01:48:06.401000Z |
play_count |
11407493 |
LOCAL |
1 |
830 |
794 |
325174 |
4889 |
87 |
175 |
2026-08-12T01:48:06.401000Z |
play_count |
325174 |
LOCAL |
1 |
831 |
1339 |
1387820 |
32687 |
254 |
322 |
2026-08-12T01:48:06.401000Z |
play_count |
1387820 |
LOCAL |
1 |
832 |
710 |
9620628 |
114174 |
282 |
1342 |
2026-08-12T01:48:06.401000Z |
play_count |
9620628 |
LOCAL |
1 |
833 |
1341 |
30798 |
301 |
21 |
9 |
2026-08-12T01:48:06.401000Z |
play_count |
30798 |
LOCAL |
1 |
834 |
1342 |
32213587 |
182459 |
1509 |
6970 |
2026-08-12T01:48:06.401000Z |
play_count |
32213587 |
LOCAL |
1 |
835 |
610 |
454513 |
2334 |
35 |
166 |
2026-08-12T01:48:06.401000Z |
play_count |
454513 |
LOCAL |
1 |
836 |
655 |
3312 |
29 |
2 |
0 |
2026-08-12T01:48:23.204000Z |
play_count |
3312 |
LOCAL |
1 |
837 |
528 |
10703795 |
32237 |
65 |
708 |
2026-08-12T01:48:23.204000Z |
play_count |
10703795 |
LOCAL |
1 |
838 |
1366 |
358141 |
20222 |
167 |
302 |
2026-08-12T01:48:23.204000Z |
play_count |
358141 |
LOCAL |
1 |
839 |
1367 |
2056616 |
29765 |
745 |
843 |
2026-08-12T01:48:23.204000Z |
play_count |
2056616 |
LOCAL |
1 |
840 |
1368 |
1963 |
3 |
0 |
2 |
2026-08-12T01:48:23.204000Z |
play_count |
1963 |
LOCAL |
1 |
841 |
1369 |
1099 |
19 |
10 |
1 |
2026-08-12T01:48:23.204000Z |
play_count |
1099 |
LOCAL |
1 |
842 |
1060 |
1580 |
3 |
0 |
1 |
2026-08-12T01:48:23.204000Z |
play_count |
1580 |
LOCAL |
1 |
843 |
800 |
1517 |
21 |
43 |
6 |
2026-08-12T01:48:23.204000Z |
play_count |
1517 |
LOCAL |
1 |
844 |
1372 |
7179708 |
75634 |
602 |
2008 |
2026-08-12T01:48:23.204000Z |
play_count |
7179708 |
LOCAL |
1 |
845 |
602 |
7587876 |
151790 |
885 |
2491 |
2026-08-12T01:48:23.204000Z |
play_count |
7587876 |
LOCAL |
1 |
846 |
1048 |
7088586 |
120212 |
1784 |
3288 |
2026-08-12T01:48:23.204000Z |
play_count |
7088586 |
LOCAL |
1 |
847 |
1375 |
775257 |
13534 |
110 |
255 |
2026-08-12T01:48:23.204000Z |
play_count |
775257 |
LOCAL |
1 |
848 |
1376 |
685089 |
19245 |
460 |
559 |
2026-08-12T01:48:23.204000Z |
play_count |
685089 |
LOCAL |
1 |
849 |
1050 |
1120 |
6 |
0 |
0 |
2026-08-12T01:48:23.204000Z |
play_count |
1120 |
LOCAL |
1 |
850 |
704 |
1017796 |
15605 |
339 |
233 |
2026-08-12T01:48:23.204000Z |
play_count |
1017796 |
LOCAL |
1 |
851 |
708 |
3632237 |
79506 |
1628 |
1385 |
2026-08-12T01:48:23.204000Z |
play_count |
3632237 |
LOCAL |
1 |
852 |
1380 |
2927325 |
79102 |
150 |
3255 |
2026-08-12T01:48:23.204000Z |
play_count |
2927325 |
LOCAL |
1 |
853 |
304 |
47127376 |
550708 |
504 |
13203 |
2026-08-12T01:48:23.204000Z |
play_count |
47127376 |
LOCAL |
1 |
854 |
1382 |
1197598 |
17846 |
542 |
547 |
2026-08-12T01:48:23.204000Z |
play_count |
1197598 |
LOCAL |
1 |
855 |
1383 |
86292277 |
5873160 |
16327 |
109137 |
2026-08-12T01:48:23.204000Z |
play_count |
86292277 |
LOCAL |
1 |
856 |
1405 |
109990 |
2205 |
196 |
15 |
2026-08-12T01:48:43.832000Z |
play_count |
109990 |
LOCAL |
1 |
857 |
658 |
2511 |
34 |
8 |
0 |
2026-08-12T01:48:43.832000Z |
play_count |
2511 |
LOCAL |
1 |
858 |
299 |
1551772 |
12010 |
11 |
189 |
2026-08-12T01:48:43.832000Z |
play_count |
1551772 |
LOCAL |
1 |
859 |
1408 |
20284 |
79 |
2 |
3 |
2026-08-12T01:48:43.832000Z |
play_count |
20284 |
LOCAL |
1 |
860 |
618 |
34396583 |
513299 |
774 |
7144 |
2026-08-12T01:48:43.832000Z |
play_count |
34396583 |
LOCAL |
1 |
861 |
1386 |
0 |
4 |
1 |
0 |
2026-08-12T01:48:43.832000Z |
play_count |
5 |
LOCAL |
0 |
862 |
670 |
1429812 |
17866 |
3078 |
174 |
2026-08-12T01:48:43.832000Z |
play_count |
1429812 |
LOCAL |
1 |
863 |
556 |
6052 |
66 |
16 |
0 |
2026-08-12T01:48:43.832000Z |
play_count |
6052 |
LOCAL |
1 |
864 |
1413 |
4737 |
52 |
3 |
1 |
2026-08-12T01:48:43.832000Z |
play_count |
4737 |
LOCAL |
1 |
865 |
1414 |
1500802 |
51671 |
298 |
1140 |
2026-08-12T01:48:43.832000Z |
play_count |
1500802 |
LOCAL |
1 |
866 |
1074 |
26305739 |
391112 |
1246 |
8598 |
2026-08-12T01:48:43.832000Z |
play_count |
26305739 |
LOCAL |
1 |
867 |
1405 |
109990 |
2205 |
196 |
15 |
2026-08-12T01:48:44.386Z |
0 |
LOCAL |
0 |
|
868 |
1417 |
7331 |
49 |
4 |
1 |
2026-08-12T01:48:43.832000Z |
play_count |
7331 |
LOCAL |
1 |
869 |
1418 |
437075 |
4897 |
66 |
105 |
2026-08-12T01:48:43.832000Z |
play_count |
437075 |
LOCAL |
1 |
870 |
1419 |
10756 |
475 |
51 |
4 |
2026-08-12T01:48:43.832000Z |
play_count |
10756 |
LOCAL |
1 |
871 |
1420 |
5674 |
46 |
6 |
1 |
2026-08-12T01:48:43.832000Z |
play_count |
5674 |
LOCAL |
1 |
872 |
1421 |
146899682 |
620932 |
2400 |
30129 |
2026-08-12T01:48:43.832000Z |
play_count |
146899682 |
LOCAL |
1 |
873 |
1422 |
2833 |
67 |
2 |
1 |
2026-08-12T01:48:43.832000Z |
play_count |
2833 |
LOCAL |
1 |
874 |
1367 |
2056630 |
29765 |
745 |
843 |
2026-08-12T01:48:43Z |
play_count |
2056630 |
SERVER |
1 |
875 |
602 |
7587885 |
151790 |
885 |
2491 |
2026-08-12T01:48:43Z |
play_count |
7587885 |
SERVER |
1 |
876 |
1380 |
2927379 |
79107 |
150 |
3255 |
2026-08-12T01:48:43Z |
play_count |
2927379 |
SERVER |
1 |
877 |
1405 |
109990 |
2205 |
196 |
15 |
2026-08-12T01:49:19.419Z |
0 |
LOCAL |
0 |
|
878 |
1444 |
653142 |
9641 |
456 |
247 |
2026-08-12T01:49:50.692000Z |
play_count |
653142 |
LOCAL |
1 |
879 |
656 |
949346 |
17201 |
208 |
252 |
2026-08-12T01:49:50.692000Z |
play_count |
949346 |
LOCAL |
1 |
880 |
1446 |
106009961 |
484561 |
1355 |
14038 |
2026-08-12T01:49:50.692000Z |
play_count |
106009961 |
LOCAL |
1 |
881 |
1447 |
107689894 |
931085 |
2968 |
36137 |
2026-08-12T01:49:50.692000Z |
play_count |
107689894 |
LOCAL |
1 |
882 |
1448 |
116657 |
6772 |
100 |
34 |
2026-08-12T01:49:50.692000Z |
play_count |
116657 |
LOCAL |
1 |
883 |
294 |
2461216 |
26347 |
518 |
277 |
2026-08-12T01:49:50.692000Z |
play_count |
2461216 |
LOCAL |
1 |
884 |
1451 |
23670 |
359 |
23 |
8 |
2026-08-12T01:49:50.692000Z |
play_count |
23670 |
LOCAL |
1 |
885 |
1452 |
58634743 |
764983 |
1653 |
19062 |
2026-08-12T01:49:50.692000Z |
play_count |
58634743 |
LOCAL |
1 |
886 |
1454 |
1277839 |
23010 |
222 |
340 |
2026-08-12T01:49:50.692000Z |
play_count |
1277839 |
LOCAL |
1 |
887 |
1455 |
6350896 |
42276 |
78 |
2058 |
2026-08-12T01:49:50.692000Z |
play_count |
6350896 |
LOCAL |
1 |
888 |
1456 |
36319630 |
156658 |
535 |
1710 |
2026-08-12T01:49:50.692000Z |
play_count |
36319630 |
LOCAL |
1 |
889 |
1457 |
2962520 |
15085 |
123 |
489 |
2026-08-12T01:49:50.692000Z |
play_count |
2962520 |
LOCAL |
1 |
890 |
1072 |
1675001 |
14367 |
2655 |
546 |
2026-08-12T01:49:50.692000Z |
play_count |
1675001 |
LOCAL |
1 |
891 |
714 |
2373450 |
28683 |
149 |
568 |
2026-08-12T01:49:50.692000Z |
play_count |
2373450 |
LOCAL |
1 |
892 |
718 |
5011435 |
27808 |
197 |
883 |
2026-08-12T01:49:50.692000Z |
play_count |
5011435 |
LOCAL |
1 |
893 |
1067 |
7022150 |
100328 |
3338 |
2653 |
2026-08-12T01:49:50.692000Z |
play_count |
7022150 |
LOCAL |
1 |
894 |
1200 |
6972777 |
10841 |
66 |
263 |
2026-08-12T01:49:50.692000Z |
play_count |
6972777 |
LOCAL |
1 |
895 |
1463 |
1202004 |
32881 |
508 |
543 |
2026-08-12T01:49:50.692000Z |
play_count |
1202004 |
LOCAL |
1 |
896 |
1325 |
596616 |
11314 |
414 |
0 |
2026-08-12T01:49:50Z |
play_count |
596616 |
SERVER |
1 |
897 |
1334 |
24940 |
312 |
13 |
5 |
2026-08-12T01:49:50Z |
play_count |
24940 |
SERVER |
1 |
898 |
1335 |
8255921 |
56824 |
233 |
1292 |
2026-08-12T01:49:50Z |
play_count |
8255921 |
SERVER |
1 |
899 |
1339 |
1324355 |
32687 |
254 |
322 |
2026-08-12T01:49:50Z |
play_count |
1324355 |
SERVER |
1 |
900 |
1337 |
10658284 |
113618 |
1987 |
5932 |
2026-08-12T01:49:50Z |
play_count |
10658284 |
SERVER |
1 |