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 |
|---|---|---|---|---|---|---|---|---|---|---|
1101 |
1980 |
49745235 |
1871304 |
8304 |
49122 |
2026-08-12T13:41:53.233000Z |
play_count |
49745235 |
LOCAL |
1 |
1102 |
528 |
10767635 |
32953 |
65 |
719 |
2026-08-12T13:41:53.233000Z |
play_count |
10767635 |
LOCAL |
1 |
1103 |
1692 |
701573 |
27400 |
65 |
304 |
2026-08-12T13:41:53.233000Z |
play_count |
701573 |
LOCAL |
1 |
1104 |
717 |
631862 |
8509 |
198 |
187 |
2026-08-12T13:41:53.233000Z |
play_count |
631862 |
LOCAL |
1 |
1105 |
1984 |
61816 |
831 |
214 |
20 |
2026-08-12T13:41:53.233000Z |
play_count |
61816 |
LOCAL |
1 |
1106 |
1075 |
59264560 |
743666 |
989 |
36660 |
2026-08-12T13:41:53.233000Z |
play_count |
59264560 |
LOCAL |
1 |
1107 |
1196 |
1722691 |
13989 |
103 |
206 |
2026-08-12T13:41:53.233000Z |
play_count |
1722691 |
LOCAL |
1 |
1108 |
1072 |
1685180 |
14468 |
2674 |
549 |
2026-08-12T13:41:53.233000Z |
play_count |
1685180 |
LOCAL |
1 |
1109 |
1988 |
5961536 |
83628 |
1225 |
1041 |
2026-08-12T13:41:53.233000Z |
play_count |
5961536 |
LOCAL |
1 |
1110 |
1251 |
3639222 |
42448 |
57 |
770 |
2026-08-12T13:41:53.233000Z |
play_count |
3639222 |
LOCAL |
1 |
1111 |
1990 |
2655648 |
8546 |
69 |
148 |
2026-08-12T13:41:53.233000Z |
play_count |
2655648 |
LOCAL |
1 |
1112 |
564 |
11986386 |
49778 |
42 |
570 |
2026-08-12T13:41:53.233000Z |
play_count |
11986386 |
LOCAL |
1 |
1113 |
1678 |
744033 |
33464 |
237 |
542 |
2026-08-12T13:42:44.858Z |
0 |
LOCAL |
0 |
|
1114 |
1972 |
2166141 |
97743 |
1041 |
994 |
2026-08-12T13:43:02Z |
play_count |
2166141 |
SERVER |
1 |
1115 |
1973 |
8000715 |
470809 |
1941 |
5536 |
2026-08-12T13:43:02Z |
play_count |
8000715 |
SERVER |
1 |
1116 |
1339 |
1394105 |
32841 |
254 |
323 |
2026-08-12T13:43:02Z |
play_count |
1394105 |
SERVER |
1 |
1117 |
1232 |
7521665 |
129249 |
77697 |
1351 |
2026-08-12T13:43:02Z |
play_count |
7521665 |
SERVER |
1 |
1118 |
1196 |
1725081 |
13989 |
103 |
206 |
2026-08-12T13:43:02Z |
play_count |
1725081 |
SERVER |
1 |
1119 |
291 |
96038 |
1014 |
397 |
17 |
2026-08-12T13:43:09.851000Z |
play_count |
96038 |
LOCAL |
1 |
1120 |
2019 |
19843596 |
376005 |
66 |
3835 |
2026-08-12T13:43:09.851000Z |
play_count |
19843596 |
LOCAL |
1 |
1121 |
2020 |
26551 |
127 |
38 |
2 |
2026-08-12T13:43:09.851000Z |
play_count |
26551 |
LOCAL |
1 |
1122 |
300 |
2190 |
527 |
7 |
0 |
2026-08-12T13:43:09.851000Z |
play_count |
2190 |
LOCAL |
1 |
1123 |
2023 |
1649213 |
33843 |
37 |
461 |
2026-08-12T13:43:09.851000Z |
play_count |
1649213 |
LOCAL |
1 |
1124 |
2024 |
1083226 |
23289 |
12 |
289 |
2026-08-12T13:43:09.851000Z |
play_count |
1083226 |
LOCAL |
1 |
1125 |
2025 |
1458 |
123 |
15 |
5 |
2026-08-12T13:43:09.851000Z |
play_count |
1458 |
LOCAL |
1 |
1126 |
2021 |
0 |
178 |
2 |
3 |
2026-08-12T13:43:09.851000Z |
play_count |
180 |
LOCAL |
0 |
1127 |
610 |
454382 |
2336 |
35 |
166 |
2026-08-12T13:43:09.851000Z |
play_count |
454382 |
LOCAL |
1 |
1128 |
1834 |
18005 |
182 |
53 |
3 |
2026-08-12T13:43:09.851000Z |
play_count |
18005 |
LOCAL |
1 |
1129 |
2029 |
96883193 |
2229821 |
2970 |
42760 |
2026-08-12T13:43:09.851000Z |
play_count |
96883193 |
LOCAL |
1 |
1130 |
2030 |
10871116 |
174977 |
989 |
1458 |
2026-08-12T13:43:09.851000Z |
play_count |
10871116 |
LOCAL |
1 |
1131 |
2031 |
51795 |
862 |
477 |
8 |
2026-08-12T13:43:09.851000Z |
play_count |
51795 |
LOCAL |
1 |
1132 |
2032 |
740514 |
30729 |
43 |
2944 |
2026-08-12T13:43:09.851000Z |
play_count |
740514 |
LOCAL |
1 |
1133 |
299 |
1554707 |
12033 |
13 |
189 |
2026-08-12T13:43:09.851000Z |
play_count |
1554707 |
LOCAL |
1 |
1134 |
2034 |
5848625 |
51337 |
629 |
1052 |
2026-08-12T13:43:09.851000Z |
play_count |
5848625 |
LOCAL |
1 |
1135 |
2035 |
1061789 |
9326 |
361 |
274 |
2026-08-12T13:43:09.851000Z |
play_count |
1061789 |
LOCAL |
1 |
1136 |
765 |
10471 |
100 |
0 |
0 |
2026-08-12T13:43:09.851000Z |
play_count |
10471 |
LOCAL |
1 |
1137 |
572 |
47710 |
708 |
17 |
0 |
2026-08-12T13:43:09.851000Z |
play_count |
47710 |
LOCAL |
1 |
1138 |
305 |
63374470 |
492365 |
2320 |
7039 |
2026-08-12T13:43:09.851000Z |
play_count |
63374470 |
LOCAL |
1 |
1139 |
291 |
117444 |
1014 |
397 |
17 |
2026-08-12T13:43:24Z |
play_count |
117444 |
SERVER |
1 |
1140 |
300 |
138444 |
527 |
7 |
0 |
2026-08-12T13:43:24Z |
play_count |
138444 |
SERVER |
1 |
1141 |
610 |
455797 |
2336 |
35 |
166 |
2026-08-12T13:43:24Z |
play_count |
455797 |
SERVER |
1 |
1142 |
2029 |
96920335 |
2229821 |
2970 |
42760 |
2026-08-12T13:43:24Z |
play_count |
96920335 |
SERVER |
1 |
1143 |
572 |
87154 |
708 |
17 |
0 |
2026-08-12T13:43:24Z |
play_count |
87154 |
SERVER |
1 |
1144 |
765 |
16412 |
100 |
0 |
0 |
2026-08-12T13:43:24Z |
play_count |
16412 |
SERVER |
1 |
1145 |
305 |
63911309 |
492365 |
2320 |
7039 |
2026-08-12T13:43:24Z |
play_count |
63911309 |
SERVER |
1 |
1146 |
2066 |
144756 |
1926 |
45 |
18 |
2026-08-12T13:47:19.401000Z |
play_count |
144756 |
LOCAL |
1 |
1147 |
561 |
32278377 |
360107 |
1517 |
4466 |
2026-08-12T13:47:19.401000Z |
play_count |
32278377 |
LOCAL |
1 |
1148 |
1044 |
13893442 |
70064 |
132 |
5058 |
2026-08-12T13:47:19.401000Z |
play_count |
13893442 |
LOCAL |
1 |
1149 |
1367 |
2071485 |
30009 |
752 |
856 |
2026-08-12T13:47:19.401000Z |
play_count |
2071485 |
LOCAL |
1 |
1150 |
2070 |
171292553 |
3749876 |
31541 |
112036 |
2026-08-12T13:47:19.401000Z |
play_count |
171292553 |
LOCAL |
1 |
1151 |
1507 |
20262442 |
165015 |
864 |
2799 |
2026-08-12T13:47:19.401000Z |
play_count |
20262442 |
LOCAL |
1 |
1152 |
2072 |
319184 |
805 |
7 |
0 |
2026-08-12T13:47:19.401000Z |
play_count |
319184 |
LOCAL |
1 |
1153 |
2073 |
35396 |
87 |
3 |
1 |
2026-08-12T13:47:19.401000Z |
play_count |
35396 |
LOCAL |
1 |
1154 |
1845 |
82767990 |
296318 |
645 |
12951 |
2026-08-12T13:47:19.401000Z |
play_count |
82767990 |
LOCAL |
1 |
1155 |
2075 |
32190020 |
50499 |
246 |
1139 |
2026-08-12T13:47:19.401000Z |
play_count |
32190020 |
LOCAL |
1 |
1156 |
1844 |
38131953 |
631601 |
2188 |
8656 |
2026-08-12T13:47:19.401000Z |
play_count |
38131953 |
LOCAL |
1 |
1157 |
1246 |
5776089 |
3 |
3058 |
3660 |
2026-08-12T13:47:19.401000Z |
play_count |
5776089 |
LOCAL |
1 |
1158 |
563 |
4285422 |
15290 |
184 |
92 |
2026-08-12T13:47:19.401000Z |
play_count |
4285422 |
LOCAL |
1 |
1159 |
2079 |
1958845 |
9130 |
17 |
142 |
2026-08-12T13:47:19.401000Z |
play_count |
1958845 |
LOCAL |
1 |
1160 |
2080 |
6948225 |
425133 |
1449 |
11854 |
2026-08-12T13:47:19.401000Z |
play_count |
6948225 |
LOCAL |
1 |
1161 |
2081 |
146347 |
840 |
6 |
0 |
2026-08-12T13:47:19.401000Z |
play_count |
146347 |
LOCAL |
1 |
1162 |
711 |
1630878 |
60908 |
891 |
1252 |
2026-08-12T13:47:19.401000Z |
play_count |
1630878 |
LOCAL |
1 |
1163 |
2083 |
189 |
3 |
1 |
0 |
2026-08-12T13:47:19.401000Z |
play_count |
189 |
LOCAL |
1 |
1164 |
1254 |
128593444 |
2642792 |
4933 |
38464 |
2026-08-12T13:47:19.401000Z |
play_count |
128593444 |
LOCAL |
1 |
1165 |
1368 |
1989 |
3 |
0 |
2 |
2026-08-12T13:47:19.401000Z |
play_count |
1989 |
LOCAL |
1 |
1166 |
2106 |
241879640 |
661273 |
1382 |
20262 |
2026-08-12T13:47:37.115000Z |
play_count |
241879640 |
LOCAL |
1 |
1167 |
290 |
48690974 |
1599133 |
1682 |
33345 |
2026-08-12T13:47:37.115000Z |
play_count |
48690974 |
LOCAL |
1 |
1168 |
306 |
1861287 |
12444 |
141 |
277 |
2026-08-12T13:47:37.115000Z |
play_count |
1861287 |
LOCAL |
1 |
1169 |
1926 |
6198347 |
26659 |
660 |
297 |
2026-08-12T13:47:37.115000Z |
play_count |
6198347 |
LOCAL |
1 |
1170 |
1498 |
3238655 |
45192 |
456 |
1038 |
2026-08-12T13:47:37.115000Z |
play_count |
3238655 |
LOCAL |
1 |
1171 |
2111 |
482709 |
10549 |
252 |
111 |
2026-08-12T13:47:37.115000Z |
play_count |
482709 |
LOCAL |
1 |
1172 |
2112 |
2667716 |
94762 |
321 |
1778 |
2026-08-12T13:47:37.115000Z |
play_count |
2667716 |
LOCAL |
1 |
1173 |
298 |
441260279 |
6601477 |
15644 |
87886 |
2026-08-12T13:47:37.115000Z |
play_count |
441260279 |
LOCAL |
1 |
1174 |
1832 |
5377156 |
16679 |
23 |
327 |
2026-08-12T13:47:37.115000Z |
play_count |
5377156 |
LOCAL |
1 |
1175 |
2115 |
2238 |
26 |
8 |
0 |
2026-08-12T13:47:37.115000Z |
play_count |
2238 |
LOCAL |
1 |
1176 |
599 |
3824818 |
40910 |
373 |
707 |
2026-08-12T13:47:37.115000Z |
play_count |
3824818 |
LOCAL |
1 |
1177 |
763 |
17069994 |
3 |
630 |
5350 |
2026-08-12T13:47:37.115000Z |
play_count |
17069994 |
LOCAL |
1 |
1178 |
2118 |
7208988 |
3 |
625 |
6932 |
2026-08-12T13:47:37.115000Z |
play_count |
7208988 |
LOCAL |
1 |
1179 |
533 |
147841441 |
2850141 |
11677 |
37407 |
2026-08-12T13:47:37.115000Z |
play_count |
147841441 |
LOCAL |
1 |
1180 |
1372 |
7197903 |
75865 |
604 |
2017 |
2026-08-12T13:47:37.115000Z |
play_count |
7197903 |
LOCAL |
1 |
1181 |
1585 |
2375261 |
20008 |
87 |
586 |
2026-08-12T13:47:37.115000Z |
play_count |
2375261 |
LOCAL |
1 |
1182 |
1879 |
21877415 |
152820 |
265 |
2404 |
2026-08-12T13:47:37.115000Z |
play_count |
21877415 |
LOCAL |
1 |
1183 |
532 |
2463640 |
44174 |
2036 |
781 |
2026-08-12T13:47:37.115000Z |
play_count |
2463640 |
LOCAL |
1 |
1184 |
292 |
565385 |
13708 |
24 |
199 |
2026-08-12T13:47:37.115000Z |
play_count |
565385 |
LOCAL |
1 |
1185 |
2125 |
7214151 |
309890 |
494 |
7451 |
2026-08-12T13:47:37.115000Z |
play_count |
7214151 |
LOCAL |
1 |
1186 |
1940 |
6013 |
31 |
0 |
1 |
2026-08-12T13:47:37.115000Z |
play_count |
6013 |
LOCAL |
1 |
1187 |
1195 |
32185268 |
97244 |
221 |
10236 |
2026-08-12T13:47:37.115000Z |
play_count |
32185268 |
LOCAL |
1 |
1188 |
1887 |
15434945 |
205539 |
4471 |
5277 |
2026-08-12T13:48:01.295000Z |
play_count |
15434945 |
LOCAL |
1 |
1189 |
1980 |
49745434 |
1871309 |
8304 |
49122 |
2026-08-12T13:48:01.295000Z |
play_count |
49745434 |
LOCAL |
1 |
1190 |
609 |
163919548 |
3193407 |
54210 |
59664 |
2026-08-12T13:48:01.295000Z |
play_count |
163919548 |
LOCAL |
1 |
1191 |
2153 |
3324 |
29 |
2 |
2 |
2026-08-12T13:48:01.295000Z |
play_count |
3324 |
LOCAL |
1 |
1192 |
617 |
7031411 |
294593 |
155 |
3672 |
2026-08-12T13:48:01.295000Z |
play_count |
7031411 |
LOCAL |
1 |
1193 |
1843 |
2515227 |
35666 |
70 |
708 |
2026-08-12T13:48:01.295000Z |
play_count |
2515227 |
LOCAL |
1 |
1194 |
528 |
10768287 |
32961 |
65 |
719 |
2026-08-12T13:48:01.295000Z |
play_count |
10768287 |
LOCAL |
1 |
1195 |
1337 |
10668695 |
113735 |
1989 |
5936 |
2026-08-12T13:48:01.295000Z |
play_count |
10668695 |
LOCAL |
1 |
1196 |
2030 |
10871321 |
174981 |
989 |
1458 |
2026-08-12T13:48:01.295000Z |
play_count |
10871321 |
LOCAL |
1 |
1197 |
709 |
8877872 |
210878 |
3217 |
4452 |
2026-08-12T13:48:01.295000Z |
play_count |
8877872 |
LOCAL |
1 |
1198 |
2160 |
0 |
1 |
0 |
0 |
2026-08-12T13:48:01.295000Z |
play_count |
1 |
LOCAL |
0 |
1199 |
2161 |
10495754 |
151477 |
1641 |
8489 |
2026-08-12T13:48:01.295000Z |
play_count |
10495754 |
LOCAL |
1 |
1200 |
1082 |
45338810 |
1103837 |
5755 |
18025 |
2026-08-12T13:48:01.295000Z |
play_count |
45338810 |
LOCAL |
1 |