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 |
|---|---|---|---|---|---|---|---|---|---|---|
401 |
330 |
0 |
322 |
15 |
10 |
2026-08-11T12:19:02Z |
play_count |
322 |
SERVER |
0 |
402 |
356 |
28900 |
2712 |
61 |
145 |
2026-08-11T12:19:12Z |
play_count |
28900 |
SERVER |
1 |
403 |
333 |
5548 |
161 |
7 |
8 |
2026-08-11T12:19:12Z |
play_count |
5548 |
SERVER |
1 |
404 |
336 |
0 |
5281 |
152 |
441 |
2026-08-11T12:19:12Z |
play_count |
5281 |
SERVER |
0 |
405 |
355 |
0 |
2660 |
148 |
232 |
2026-08-11T12:19:12Z |
play_count |
2660 |
SERVER |
0 |
406 |
340 |
0 |
2104 |
62 |
79 |
2026-08-11T12:19:12Z |
play_count |
2104 |
SERVER |
0 |
407 |
335 |
0 |
1330 |
67 |
49 |
2026-08-11T12:19:12Z |
play_count |
1330 |
SERVER |
0 |
408 |
323 |
0 |
868 |
18 |
64 |
2026-08-11T12:19:12Z |
play_count |
868 |
SERVER |
0 |
409 |
334 |
0 |
640 |
19 |
32 |
2026-08-11T12:19:12Z |
play_count |
640 |
SERVER |
0 |
410 |
330 |
0 |
320 |
15 |
10 |
2026-08-11T12:19:12Z |
play_count |
320 |
SERVER |
0 |
411 |
356 |
28900 |
2713 |
61 |
145 |
2026-08-11T12:19:16Z |
play_count |
28900 |
SERVER |
1 |
412 |
333 |
5554 |
161 |
7 |
8 |
2026-08-11T12:19:16Z |
play_count |
5554 |
SERVER |
1 |
413 |
336 |
0 |
5283 |
152 |
441 |
2026-08-11T12:19:16Z |
play_count |
5283 |
SERVER |
0 |
414 |
355 |
0 |
2662 |
148 |
232 |
2026-08-11T12:19:16Z |
play_count |
2662 |
SERVER |
0 |
415 |
340 |
0 |
2106 |
62 |
79 |
2026-08-11T12:19:16Z |
play_count |
2106 |
SERVER |
0 |
416 |
335 |
0 |
1332 |
67 |
49 |
2026-08-11T12:19:16Z |
play_count |
1332 |
SERVER |
0 |
417 |
323 |
0 |
870 |
18 |
65 |
2026-08-11T12:19:16Z |
play_count |
870 |
SERVER |
0 |
418 |
334 |
0 |
641 |
19 |
32 |
2026-08-11T12:19:16Z |
play_count |
641 |
SERVER |
0 |
419 |
330 |
0 |
322 |
15 |
10 |
2026-08-11T12:19:16Z |
play_count |
322 |
SERVER |
0 |
420 |
484 |
0 |
3032 |
406 |
163 |
2026-08-11T12:20:08.988000Z |
play_count |
3032 |
LOCAL |
0 |
421 |
485 |
0 |
34386 |
212 |
463 |
2026-08-11T12:20:08.988000Z |
play_count |
34386 |
LOCAL |
0 |
422 |
486 |
0 |
19487 |
37 |
237 |
2026-08-11T12:20:08.988000Z |
play_count |
19487 |
LOCAL |
0 |
423 |
487 |
0 |
461 |
3 |
9 |
2026-08-11T12:20:08.988000Z |
play_count |
461 |
LOCAL |
0 |
424 |
488 |
0 |
721 |
2 |
4 |
2026-08-11T12:20:08.988000Z |
play_count |
721 |
LOCAL |
0 |
425 |
489 |
0 |
1747 |
11 |
17 |
2026-08-11T12:20:08.988000Z |
play_count |
1747 |
LOCAL |
0 |
426 |
378 |
0 |
398 |
6 |
5 |
2026-08-11T12:23:00.046000Z |
play_count |
398 |
LOCAL |
0 |
427 |
379 |
0 |
2010 |
35 |
81 |
2026-08-11T12:23:00.046000Z |
play_count |
2010 |
LOCAL |
0 |
428 |
380 |
0 |
6708 |
205 |
313 |
2026-08-11T12:23:00.046000Z |
play_count |
6708 |
LOCAL |
0 |
429 |
381 |
0 |
955 |
14 |
118 |
2026-08-11T12:23:00.046000Z |
play_count |
955 |
LOCAL |
0 |
430 |
382 |
17904 |
650 |
83 |
34 |
2026-08-11T12:23:00.046000Z |
play_count |
650 |
LOCAL |
1 |
431 |
383 |
0 |
2585 |
63 |
108 |
2026-08-11T12:23:00.046000Z |
play_count |
2585 |
LOCAL |
0 |
432 |
384 |
0 |
986 |
19 |
56 |
2026-08-11T12:23:00.046000Z |
play_count |
986 |
LOCAL |
0 |
433 |
385 |
0 |
749 |
12 |
24 |
2026-08-11T12:23:00.046000Z |
play_count |
749 |
LOCAL |
0 |
434 |
386 |
0 |
550 |
12 |
15 |
2026-08-11T12:23:00.046000Z |
play_count |
550 |
LOCAL |
0 |
435 |
387 |
0 |
991 |
15 |
50 |
2026-08-11T12:23:00.046000Z |
play_count |
991 |
LOCAL |
0 |
436 |
388 |
0 |
10469 |
224 |
795 |
2026-08-11T12:23:00.046000Z |
play_count |
10469 |
LOCAL |
0 |
437 |
382 |
17923 |
650 |
83 |
34 |
2026-08-11T12:23:06Z |
play_count |
17923 |
SERVER |
1 |
438 |
519 |
5856191 |
30845 |
27 |
521 |
2026-08-11T13:00:59.916000Z |
play_count |
5856191 |
LOCAL |
1 |
439 |
290 |
48609515 |
1595042 |
1676 |
33253 |
2026-08-11T13:00:59.916000Z |
play_count |
48609515 |
LOCAL |
1 |
440 |
521 |
15766975 |
253379 |
828 |
1650 |
2026-08-11T13:00:59.916000Z |
play_count |
15766975 |
LOCAL |
1 |
441 |
522 |
0 |
1454 |
93 |
54 |
2026-08-11T13:00:59.916000Z |
play_count |
1454 |
LOCAL |
0 |
442 |
523 |
1304214 |
23202 |
23 |
330 |
2026-08-11T13:00:59.916000Z |
play_count |
1304214 |
LOCAL |
1 |
443 |
524 |
116922324 |
1722569 |
5730 |
19601 |
2026-08-11T13:00:59.916000Z |
play_count |
116922324 |
LOCAL |
1 |
444 |
525 |
8318108 |
91416 |
2193 |
2250 |
2026-08-11T13:00:59.916000Z |
play_count |
8318108 |
LOCAL |
1 |
445 |
526 |
5867016 |
144993 |
1855 |
3088 |
2026-08-11T13:00:59.916000Z |
play_count |
5867016 |
LOCAL |
1 |
446 |
299 |
1547214 |
11947 |
11 |
188 |
2026-08-11T13:00:59.916000Z |
play_count |
1547214 |
LOCAL |
1 |
447 |
528 |
10603231 |
31136 |
59 |
677 |
2026-08-11T13:00:59.916000Z |
play_count |
10603231 |
LOCAL |
1 |
448 |
529 |
0 |
663 |
12 |
18 |
2026-08-11T13:00:59.916000Z |
play_count |
663 |
LOCAL |
0 |
449 |
530 |
125368599 |
647782 |
1893 |
19063 |
2026-08-11T13:00:59.916000Z |
play_count |
125368599 |
LOCAL |
1 |
450 |
531 |
19442324 |
412152 |
3690 |
13491 |
2026-08-11T13:00:59.916000Z |
play_count |
19442324 |
LOCAL |
1 |
451 |
532 |
2425209 |
43675 |
2008 |
763 |
2026-08-11T13:00:59.916000Z |
play_count |
2425209 |
LOCAL |
1 |
452 |
533 |
146553287 |
2807345 |
11522 |
36925 |
2026-08-11T13:00:59.916000Z |
play_count |
146553287 |
LOCAL |
1 |
453 |
534 |
22573 |
563 |
2 |
1 |
2026-08-11T13:00:59.916000Z |
play_count |
22573 |
LOCAL |
1 |
454 |
306 |
1856836 |
12371 |
140 |
275 |
2026-08-11T13:00:59.916000Z |
play_count |
1856836 |
LOCAL |
1 |
455 |
307 |
1886158 |
31152 |
140 |
484 |
2026-08-11T13:00:59.916000Z |
play_count |
1886158 |
LOCAL |
1 |
456 |
537 |
0 |
1539 |
60 |
44 |
2026-08-11T13:00:59.916000Z |
play_count |
1539 |
LOCAL |
0 |
457 |
538 |
1400928 |
28080 |
20514 |
228 |
2026-08-11T13:00:59.916000Z |
play_count |
1400928 |
LOCAL |
1 |
458 |
293 |
16341 |
84 |
3 |
4 |
2026-08-11T13:11:06.980000Z |
play_count |
16341 |
LOCAL |
1 |
459 |
540 |
1959294 |
3971 |
25 |
190 |
2026-08-11T13:11:06.980000Z |
play_count |
1959294 |
LOCAL |
1 |
460 |
541 |
14702 |
3 |
128 |
2 |
2026-08-11T13:11:06.980000Z |
play_count |
14702 |
LOCAL |
1 |
461 |
292 |
557845 |
13552 |
24 |
200 |
2026-08-11T13:11:06.980000Z |
play_count |
557845 |
LOCAL |
1 |
462 |
543 |
25405760 |
260180 |
590 |
8524 |
2026-08-11T13:11:06.980000Z |
play_count |
25405760 |
LOCAL |
1 |
463 |
544 |
76679 |
3488 |
25 |
96 |
2026-08-11T13:11:06.980000Z |
play_count |
76679 |
LOCAL |
1 |
464 |
545 |
37728762 |
247108 |
869 |
6301 |
2026-08-11T13:11:06.980000Z |
play_count |
37728762 |
LOCAL |
1 |
465 |
546 |
0 |
71 |
1 |
3 |
2026-08-11T13:11:06.980000Z |
play_count |
0 |
LOCAL |
0 |
466 |
547 |
0 |
8 |
0 |
0 |
2026-08-11T13:11:06.980000Z |
play_count |
0 |
LOCAL |
0 |
467 |
548 |
7472383 |
71091 |
55 |
623 |
2026-08-11T13:11:06.980000Z |
play_count |
7472383 |
LOCAL |
1 |
468 |
549 |
34872087 |
492075 |
486 |
3884 |
2026-08-11T13:11:06.980000Z |
play_count |
34872087 |
LOCAL |
1 |
469 |
550 |
16460286 |
120164 |
475 |
2464 |
2026-08-11T13:11:06.980000Z |
play_count |
16460286 |
LOCAL |
1 |
470 |
551 |
4014 |
40 |
5 |
0 |
2026-08-11T13:11:06.980000Z |
play_count |
4014 |
LOCAL |
1 |
471 |
552 |
0 |
43 |
0 |
1 |
2026-08-11T13:11:06.980000Z |
play_count |
0 |
LOCAL |
0 |
472 |
553 |
776316 |
11136 |
24 |
167 |
2026-08-11T13:11:06.980000Z |
play_count |
776316 |
LOCAL |
1 |
473 |
554 |
6754527 |
182100 |
1014 |
5634 |
2026-08-11T13:11:06.980000Z |
play_count |
6754527 |
LOCAL |
1 |
474 |
555 |
24108 |
343 |
135 |
7 |
2026-08-11T13:11:06.980000Z |
play_count |
24108 |
LOCAL |
1 |
475 |
556 |
5991 |
66 |
16 |
0 |
2026-08-11T13:11:06.980000Z |
play_count |
5991 |
LOCAL |
1 |
476 |
557 |
514185 |
10212 |
468 |
241 |
2026-08-11T13:11:06.980000Z |
play_count |
514185 |
LOCAL |
1 |
477 |
558 |
6890 |
67 |
1 |
1 |
2026-08-11T13:11:06.980000Z |
play_count |
6890 |
LOCAL |
1 |
478 |
559 |
22271 |
1964 |
72 |
9 |
2026-08-11T13:12:28.808000Z |
play_count |
22271 |
LOCAL |
1 |
479 |
560 |
908385 |
10769 |
2200 |
101 |
2026-08-11T13:12:28.808000Z |
play_count |
908385 |
LOCAL |
1 |
480 |
561 |
25593030 |
357136 |
1517 |
4444 |
2026-08-11T13:12:28.808000Z |
play_count |
25593030 |
LOCAL |
1 |
481 |
562 |
1720306 |
12814 |
29 |
171 |
2026-08-11T13:12:28.808000Z |
play_count |
1720306 |
LOCAL |
1 |
482 |
563 |
1181610 |
13966 |
174 |
83 |
2026-08-11T13:12:28.808000Z |
play_count |
1181610 |
LOCAL |
1 |
483 |
564 |
11924382 |
49385 |
42 |
570 |
2026-08-11T13:12:28.808000Z |
play_count |
11924382 |
LOCAL |
1 |
484 |
565 |
138816 |
711 |
107 |
12 |
2026-08-11T13:12:28.808000Z |
play_count |
138816 |
LOCAL |
1 |
485 |
566 |
0 |
3 |
1 |
0 |
2026-08-11T13:12:28.808000Z |
play_count |
0 |
LOCAL |
0 |
486 |
567 |
5703 |
114 |
5 |
0 |
2026-08-11T13:12:28.808000Z |
play_count |
5703 |
LOCAL |
1 |
487 |
568 |
11507 |
110 |
10 |
1 |
2026-08-11T13:12:28.808000Z |
play_count |
11507 |
LOCAL |
1 |
488 |
569 |
11912153 |
249399 |
865 |
2257 |
2026-08-11T13:12:28.808000Z |
play_count |
11912153 |
LOCAL |
1 |
489 |
570 |
2447639 |
18151 |
45 |
805 |
2026-08-11T13:12:28.808000Z |
play_count |
2447639 |
LOCAL |
1 |
490 |
571 |
3772998 |
8471 |
8 |
119 |
2026-08-11T13:12:28.808000Z |
play_count |
3772998 |
LOCAL |
1 |
491 |
572 |
45936 |
674 |
12 |
0 |
2026-08-11T13:12:28.808000Z |
play_count |
45936 |
LOCAL |
1 |
492 |
301 |
921856 |
30110 |
474 |
1093 |
2026-08-11T13:12:28.808000Z |
play_count |
921856 |
LOCAL |
1 |
493 |
305 |
57414056 |
434875 |
2093 |
6183 |
2026-08-11T13:12:28.808000Z |
play_count |
57414056 |
LOCAL |
1 |
494 |
575 |
146113 |
3023 |
336 |
40 |
2026-08-11T13:12:28.808000Z |
play_count |
146113 |
LOCAL |
1 |
495 |
576 |
165790 |
1358 |
85 |
11 |
2026-08-11T13:12:28.808000Z |
play_count |
165790 |
LOCAL |
1 |
496 |
577 |
17761 |
546 |
13 |
6 |
2026-08-11T13:12:28.808000Z |
play_count |
17761 |
LOCAL |
1 |
497 |
578 |
161752 |
2623 |
1466 |
23 |
2026-08-11T13:12:28.808000Z |
play_count |
161752 |
LOCAL |
1 |
498 |
599 |
3796806 |
40463 |
370 |
702 |
2026-08-11T13:12:51.151000Z |
play_count |
3796806 |
LOCAL |
1 |
499 |
600 |
9014623 |
70140 |
10029 |
1170 |
2026-08-11T13:12:51.151000Z |
play_count |
9014623 |
LOCAL |
1 |
500 |
601 |
660136 |
10986 |
73 |
252 |
2026-08-11T13:12:51.151000Z |
play_count |
660136 |
LOCAL |
1 |