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 |
|---|---|---|---|---|---|---|---|---|---|---|
1201 |
1335 |
8295357 |
57011 |
233 |
1295 |
2026-08-12T13:48:01.295000Z |
play_count |
8295357 |
LOCAL |
1 |
1202 |
1876 |
8307165 |
209771 |
164 |
5410 |
2026-08-12T13:48:01.295000Z |
play_count |
8307165 |
LOCAL |
1 |
1203 |
2032 |
740982 |
30752 |
43 |
2944 |
2026-08-12T13:48:01.295000Z |
play_count |
740982 |
LOCAL |
1 |
1204 |
2166 |
247669526 |
2333755 |
2730 |
46219 |
2026-08-12T13:48:01.295000Z |
play_count |
247669526 |
LOCAL |
1 |
1205 |
1456 |
36356867 |
156865 |
535 |
1711 |
2026-08-12T13:48:01.295000Z |
play_count |
36356867 |
LOCAL |
1 |
1206 |
2168 |
0 |
0 |
0 |
0 |
2026-08-12T13:48:01.295000Z |
play_count |
0 |
LOCAL |
0 |
1207 |
1420 |
4024 |
47 |
6 |
1 |
2026-08-12T13:48:01.295000Z |
play_count |
4024 |
LOCAL |
1 |
1208 |
1078 |
212359727 |
7030534 |
6873 |
133833 |
2026-08-12T13:48:01.295000Z |
play_count |
212359727 |
LOCAL |
1 |
1209 |
1414 |
1510877 |
51995 |
300 |
1147 |
2026-08-12T13:48:01.295000Z |
play_count |
1510877 |
LOCAL |
1 |
1210 |
2172 |
15274394 |
470198 |
658 |
28451 |
2026-08-12T13:48:01.295000Z |
play_count |
15274394 |
LOCAL |
1 |
1211 |
897 |
1251159 |
21939 |
1163 |
379 |
2026-08-12T13:48:01.295000Z |
play_count |
1251159 |
LOCAL |
1 |
1212 |
519 |
6138487 |
32830 |
30 |
554 |
2026-08-12T13:48:49.406000Z |
play_count |
6138487 |
LOCAL |
1 |
1213 |
2200 |
63650162 |
838469 |
4426 |
9964 |
2026-08-12T13:48:49.406000Z |
play_count |
63650162 |
LOCAL |
1 |
1214 |
543 |
26151160 |
269759 |
608 |
8889 |
2026-08-12T13:48:49.406000Z |
play_count |
26151160 |
LOCAL |
1 |
1215 |
2202 |
22748 |
436 |
61 |
9 |
2026-08-12T13:48:49.406000Z |
play_count |
22748 |
LOCAL |
1 |
1216 |
545 |
37935603 |
249040 |
872 |
6346 |
2026-08-12T13:48:49.406000Z |
play_count |
37935603 |
LOCAL |
1 |
1217 |
1830 |
42057735 |
1356988 |
5928 |
22791 |
2026-08-12T13:48:49.406000Z |
play_count |
42057735 |
LOCAL |
1 |
1218 |
2205 |
15343788 |
37494 |
17 |
683 |
2026-08-12T13:48:49.406000Z |
play_count |
15343788 |
LOCAL |
1 |
1219 |
559 |
23560 |
2007 |
76 |
11 |
2026-08-12T13:48:49.406000Z |
play_count |
23560 |
LOCAL |
1 |
1220 |
2207 |
9098762 |
11287 |
69 |
324 |
2026-08-12T13:48:49.406000Z |
play_count |
9098762 |
LOCAL |
1 |
1221 |
2025 |
1466 |
126 |
15 |
5 |
2026-08-12T13:48:49.406000Z |
play_count |
1466 |
LOCAL |
1 |
1222 |
1369 |
1123 |
19 |
10 |
1 |
2026-08-12T13:48:49.406000Z |
play_count |
1123 |
LOCAL |
1 |
1223 |
540 |
1997789 |
4048 |
25 |
200 |
2026-08-12T13:48:49.406000Z |
play_count |
1997789 |
LOCAL |
1 |
1224 |
2211 |
2343 |
61 |
6 |
2 |
2026-08-12T13:48:49.406000Z |
play_count |
2343 |
LOCAL |
1 |
1225 |
1929 |
3193 |
25 |
5 |
1 |
2026-08-12T13:48:49.406000Z |
play_count |
3193 |
LOCAL |
1 |
1226 |
605 |
4218828 |
16927 |
219 |
996 |
2026-08-12T13:48:49.406000Z |
play_count |
4218828 |
LOCAL |
1 |
1227 |
1229 |
1161812 |
45266 |
705 |
1665 |
2026-08-12T13:48:49.406000Z |
play_count |
1161812 |
LOCAL |
1 |
1228 |
2215 |
1023778 |
22278 |
61 |
242 |
2026-08-12T13:48:49.406000Z |
play_count |
1023778 |
LOCAL |
1 |
1229 |
565 |
141827 |
729 |
107 |
13 |
2026-08-12T13:48:49.406000Z |
play_count |
141827 |
LOCAL |
1 |
1230 |
2217 |
22086915 |
271467 |
146 |
3808 |
2026-08-12T13:48:49.406000Z |
play_count |
22086915 |
LOCAL |
1 |
1231 |
655 |
3327 |
29 |
2 |
0 |
2026-08-12T13:48:49.406000Z |
play_count |
3327 |
LOCAL |
1 |
1232 |
1693 |
3773 |
259 |
10 |
9 |
2026-08-12T13:48:49.406000Z |
play_count |
3773 |
LOCAL |
1 |
1233 |
2220 |
18043276 |
483084 |
1833 |
6747 |
2026-08-12T13:48:49.406000Z |
play_count |
18043276 |
LOCAL |
1 |
1234 |
523 |
1308674 |
23270 |
23 |
332 |
2026-08-12T13:48:49.406000Z |
play_count |
1308674 |
LOCAL |
1 |
1235 |
1085 |
139750050 |
3574045 |
14914 |
87964 |
2026-08-12T13:49:45.855000Z |
play_count |
139750050 |
LOCAL |
1 |
1236 |
1976 |
4028164 |
106936 |
335 |
1233 |
2026-08-12T13:49:45.855000Z |
play_count |
4028164 |
LOCAL |
1 |
1237 |
2247 |
18000550 |
335735 |
701 |
4269 |
2026-08-12T13:49:45.855000Z |
play_count |
18000550 |
LOCAL |
1 |
1238 |
1408 |
8926 |
82 |
2 |
3 |
2026-08-12T13:49:45.855000Z |
play_count |
8926 |
LOCAL |
1 |
1239 |
890 |
843839 |
6721 |
22 |
190 |
2026-08-12T13:49:45.855000Z |
play_count |
843839 |
LOCAL |
1 |
1240 |
1080 |
17681772 |
586546 |
3111 |
31090 |
2026-08-12T13:49:45.855000Z |
play_count |
17681772 |
LOCAL |
1 |
1241 |
2252 |
4374922 |
113148 |
181 |
1447 |
2026-08-12T13:49:45.855000Z |
play_count |
4374922 |
LOCAL |
1 |
1242 |
2029 |
96889954 |
2230010 |
2970 |
42762 |
2026-08-12T13:49:45.855000Z |
play_count |
96889954 |
LOCAL |
1 |
1243 |
2249 |
0 |
5 |
0 |
0 |
2026-08-12T13:49:45.855000Z |
play_count |
5 |
LOCAL |
0 |
1244 |
2255 |
10313036 |
89819 |
637 |
1820 |
2026-08-12T13:49:45.855000Z |
play_count |
10313036 |
LOCAL |
1 |
1245 |
2256 |
257261 |
6209 |
79 |
161 |
2026-08-12T13:49:45.855000Z |
play_count |
257261 |
LOCAL |
1 |
1246 |
525 |
8354710 |
91804 |
2202 |
2265 |
2026-08-12T13:49:45.855000Z |
play_count |
8354710 |
LOCAL |
1 |
1247 |
2258 |
2512786 |
55976 |
1338 |
1443 |
2026-08-12T13:49:45.855000Z |
play_count |
2512786 |
LOCAL |
1 |
1248 |
2259 |
17187452 |
51033 |
224 |
1367 |
2026-08-12T13:49:45.855000Z |
play_count |
17187452 |
LOCAL |
1 |
1249 |
2260 |
392015 |
6894 |
124 |
245 |
2026-08-12T13:49:45.855000Z |
play_count |
392015 |
LOCAL |
1 |
1250 |
909 |
2046212 |
24905 |
184 |
990 |
2026-08-12T13:49:45.855000Z |
play_count |
2046212 |
LOCAL |
1 |
1251 |
2262 |
941487 |
20842 |
81 |
683 |
2026-08-12T13:49:45.855000Z |
play_count |
941487 |
LOCAL |
1 |
1252 |
2263 |
50082674 |
3 |
8426 |
25440 |
2026-08-12T13:49:45.855000Z |
play_count |
50082674 |
LOCAL |
1 |
1253 |
1145 |
12065674 |
52059 |
276 |
2198 |
2026-08-12T13:49:45.855000Z |
play_count |
12065674 |
LOCAL |
1 |
1254 |
2265 |
7175816 |
12084 |
73 |
458 |
2026-08-12T13:49:45.855000Z |
play_count |
7175816 |
LOCAL |
1 |
1255 |
2266 |
2845226 |
19113 |
96 |
332 |
2026-08-12T13:49:45.855000Z |
play_count |
2845226 |
LOCAL |
1 |
1256 |
2267 |
0 |
4 |
0 |
0 |
2026-08-12T13:49:45.855000Z |
play_count |
4 |
LOCAL |
0 |
1257 |
2291 |
510503 |
33385 |
778 |
216 |
2026-08-12T13:50:09.821000Z |
play_count |
510503 |
LOCAL |
1 |
1258 |
1972 |
2165785 |
97755 |
1041 |
994 |
2026-08-12T13:50:09.821000Z |
play_count |
2165785 |
LOCAL |
1 |
1259 |
1973 |
8000882 |
470823 |
1941 |
5536 |
2026-08-12T13:50:09.821000Z |
play_count |
8000882 |
LOCAL |
1 |
1260 |
1573 |
2750708 |
60041 |
316 |
2463 |
2026-08-12T13:50:09.821000Z |
play_count |
2750708 |
LOCAL |
1 |
1261 |
2295 |
4254346 |
37648 |
205 |
289 |
2026-08-12T13:50:09.821000Z |
play_count |
4254346 |
LOCAL |
1 |
1262 |
291 |
96088 |
1014 |
397 |
17 |
2026-08-12T13:50:09.821000Z |
play_count |
96088 |
LOCAL |
1 |
1263 |
1215 |
9247442 |
47983 |
91 |
566 |
2026-08-12T13:50:09.821000Z |
play_count |
9247442 |
LOCAL |
1 |
1264 |
1931 |
2891189 |
8396 |
50 |
204 |
2026-08-12T13:50:09.821000Z |
play_count |
2891189 |
LOCAL |
1 |
1265 |
2299 |
262081 |
6884 |
877 |
90 |
2026-08-12T13:50:09.821000Z |
play_count |
262081 |
LOCAL |
1 |
1266 |
2300 |
131224 |
6888 |
85 |
66 |
2026-08-12T13:50:09.821000Z |
play_count |
131224 |
LOCAL |
1 |
1267 |
1049 |
0 |
3 |
4 |
1 |
2026-08-12T13:50:09.821000Z |
play_count |
7 |
LOCAL |
0 |
1268 |
2302 |
4042086 |
53126 |
1154 |
539 |
2026-08-12T13:50:09.821000Z |
play_count |
4042086 |
LOCAL |
1 |
1269 |
2303 |
7237686 |
113493 |
1799 |
2079 |
2026-08-12T13:50:09.821000Z |
play_count |
7237686 |
LOCAL |
1 |
1270 |
2304 |
34726490 |
294093 |
344 |
4675 |
2026-08-12T13:50:09.821000Z |
play_count |
34726490 |
LOCAL |
1 |
1271 |
2305 |
12516840 |
152593 |
1624 |
5036 |
2026-08-12T13:50:09.821000Z |
play_count |
12516840 |
LOCAL |
1 |
1272 |
604 |
2189384 |
27915 |
2474 |
776 |
2026-08-12T13:50:09.821000Z |
play_count |
2189384 |
LOCAL |
1 |
1273 |
1339 |
1330721 |
32844 |
254 |
323 |
2026-08-12T13:50:09.821000Z |
play_count |
1330721 |
LOCAL |
1 |
1274 |
2308 |
404132 |
7202 |
2498 |
35 |
2026-08-12T13:50:09.821000Z |
play_count |
404132 |
LOCAL |
1 |
1275 |
2309 |
7054153 |
33973 |
82 |
740 |
2026-08-12T13:50:09.821000Z |
play_count |
7054153 |
LOCAL |
1 |
1276 |
1975 |
18758833 |
183011 |
5055 |
2234 |
2026-08-12T13:50:09.821000Z |
play_count |
18758833 |
LOCAL |
1 |
1277 |
2311 |
200600633 |
1220488 |
1986 |
24128 |
2026-08-12T13:50:09.821000Z |
play_count |
200600633 |
LOCAL |
1 |
1278 |
1145 |
12065674 |
52059 |
276 |
2198 |
2026-08-12T13:50:24.003Z |
0 |
LOCAL |
0 |
|
1279 |
2334 |
1444441 |
21626 |
108 |
360 |
2026-08-12T13:54:35.323000Z |
play_count |
1444441 |
LOCAL |
1 |
1280 |
1502 |
34704751 |
2391005 |
8057 |
30598 |
2026-08-12T13:54:35.323000Z |
play_count |
34704751 |
LOCAL |
1 |
1281 |
2336 |
15300 |
132 |
13 |
1 |
2026-08-12T13:54:35.323000Z |
play_count |
15300 |
LOCAL |
1 |
1282 |
2337 |
363690 |
8579 |
72 |
108 |
2026-08-12T13:54:35.323000Z |
play_count |
363690 |
LOCAL |
1 |
1283 |
2338 |
931024 |
9455 |
55 |
203 |
2026-08-12T13:54:35.323000Z |
play_count |
931024 |
LOCAL |
1 |
1284 |
2339 |
100886 |
185 |
481 |
17 |
2026-08-12T13:54:35.323000Z |
play_count |
100886 |
LOCAL |
1 |
1285 |
2340 |
2494236 |
29412 |
85 |
410 |
2026-08-12T13:54:35.323000Z |
play_count |
2494236 |
LOCAL |
1 |
1286 |
2341 |
408729 |
13651 |
85 |
306 |
2026-08-12T13:54:35.323000Z |
play_count |
408729 |
LOCAL |
1 |
1287 |
1329 |
3474104 |
73829 |
2732 |
2239 |
2026-08-12T13:54:35.323000Z |
play_count |
3474104 |
LOCAL |
1 |
1288 |
2343 |
3514198 |
81258 |
252 |
773 |
2026-08-12T13:54:35.323000Z |
play_count |
3514198 |
LOCAL |
1 |
1289 |
2344 |
433573 |
16323 |
227 |
363 |
2026-08-12T13:54:35.323000Z |
play_count |
433573 |
LOCAL |
1 |
1290 |
2345 |
494321 |
11690 |
958 |
146 |
2026-08-12T13:54:35.323000Z |
play_count |
494321 |
LOCAL |
1 |
1291 |
2346 |
12667770 |
316334 |
2423 |
4719 |
2026-08-12T13:54:35.323000Z |
play_count |
12667770 |
LOCAL |
1 |
1292 |
602 |
7599106 |
152236 |
887 |
2501 |
2026-08-12T13:54:35.323000Z |
play_count |
7599106 |
LOCAL |
1 |
1293 |
2348 |
978010 |
17352 |
360 |
308 |
2026-08-12T13:54:35.323000Z |
play_count |
978010 |
LOCAL |
1 |
1294 |
2349 |
1083151 |
6954 |
41 |
137 |
2026-08-12T13:54:35.323000Z |
play_count |
1083151 |
LOCAL |
1 |
1295 |
2350 |
440419 |
4113 |
28 |
84 |
2026-08-12T13:54:35.323000Z |
play_count |
440419 |
LOCAL |
1 |
1296 |
534 |
23759 |
602 |
2 |
2 |
2026-08-12T13:55:25.749000Z |
play_count |
23759 |
LOCAL |
1 |
1297 |
2352 |
44509895 |
248722 |
318 |
8581 |
2026-08-12T13:55:25.749000Z |
play_count |
44509895 |
LOCAL |
1 |
1298 |
2353 |
2191091 |
84658 |
766 |
2371 |
2026-08-12T13:55:25.749000Z |
play_count |
2191091 |
LOCAL |
1 |
1299 |
805 |
1973137 |
97198 |
124 |
4503 |
2026-08-12T13:55:25.749000Z |
play_count |
1973137 |
LOCAL |
1 |
1300 |
2355 |
1111331 |
31758 |
555 |
291 |
2026-08-12T13:55:25.749000Z |
play_count |
1111331 |
LOCAL |
1 |