Table: post_stat_latest
Schema
| cid | name | type | notnull | default | pk |
|---|---|---|---|---|---|
| 0 | post_id | INTEGER | 0 | 1 | |
| 1 | views | INTEGER | 1 | 0 | 0 |
| 2 | likes | INTEGER | 1 | 0 | 0 |
| 3 | comments | INTEGER | 1 | 0 | 0 |
| 4 | reposts | INTEGER | 1 | 0 | 0 |
| 5 | collected_at | TEXT | 1 | CURRENT_TIMESTAMP | 0 |
| 6 | sort_by | TEXT | 1 | '' | 0 |
| 7 | sort_value | INTEGER | 1 | 0 | 0 |
| 8 | source_kind | TEXT | 1 | 'LOCAL' | 0 |
| 9 | views_available | INTEGER | 1 | 0 | 0 |
Data
| post_id | views | likes | comments | reposts | collected_at | sort_by | sort_value | source_kind | views_available |
|---|---|---|---|---|---|---|---|---|---|
3840 |
301 |
2 |
4 |
0 |
2026-08-16T13:42:54.989000Z |
play_count |
301 |
LOCAL |
1 |
3842 |
212 |
1 |
5 |
0 |
2026-08-16T13:42:57.840000Z |
play_count |
212 |
LOCAL |
1 |
3843 |
209 |
2 |
3 |
0 |
2026-08-16T13:42:57.840000Z |
play_count |
209 |
LOCAL |
1 |
3844 |
211 |
3 |
5 |
1 |
2026-08-16T13:42:57.840000Z |
play_count |
211 |
LOCAL |
1 |
3845 |
227 |
2 |
1 |
0 |
2026-08-16T13:42:57.840000Z |
play_count |
227 |
LOCAL |
1 |
3846 |
211 |
2 |
3 |
1 |
2026-08-16T13:42:57.840000Z |
play_count |
211 |
LOCAL |
1 |
3847 |
265 |
3 |
4 |
1 |
2026-08-16T13:42:57.840000Z |
play_count |
265 |
LOCAL |
1 |
3848 |
252 |
2 |
7 |
1 |
2026-08-16T13:42:57.840000Z |
play_count |
252 |
LOCAL |
1 |
3849 |
183 |
2 |
3 |
0 |
2026-08-16T13:42:57.840000Z |
play_count |
183 |
LOCAL |
1 |
3850 |
275 |
4 |
5 |
1 |
2026-08-16T13:42:57.840000Z |
play_count |
275 |
LOCAL |
1 |
3851 |
0 |
2 |
1 |
0 |
2026-08-16T13:42:57.840000Z |
play_count |
3 |
LOCAL |
0 |
3852 |
351 |
3 |
3 |
1 |
2026-08-16T13:42:57.840000Z |
play_count |
351 |
LOCAL |
1 |
3853 |
1449 |
5 |
7 |
1 |
2026-08-16T13:42:57.840000Z |
play_count |
1449 |
LOCAL |
1 |
3854 |
521191 |
1108 |
2302 |
77 |
2026-08-16T13:42:57.840000Z |
play_count |
521191 |
LOCAL |
1 |
3877 |
175486290 |
3524183 |
2895 |
47969 |
2026-08-16T13:49:39.588000Z |
play_count |
175486290 |
LOCAL |
1 |
3878 |
28841436 |
1566216 |
1349 |
32420 |
2026-08-16T13:49:39.588000Z |
play_count |
28841436 |
LOCAL |
1 |
3891 |
10679592 |
697590 |
3736 |
16411 |
2026-08-16T13:49:41.254000Z |
play_count |
10679592 |
LOCAL |
1 |
3893 |
5815603 |
874230 |
2206 |
23126 |
2026-08-16T13:49:41.254000Z |
play_count |
5815603 |
LOCAL |
1 |
3895 |
16945916 |
3 |
105 |
726 |
2026-08-16T13:49:41.254000Z |
play_count |
16945916 |
LOCAL |
1 |
3897 |
0 |
19 |
34 |
9 |
2026-08-16T13:49:50.012000Z |
play_count |
53 |
LOCAL |
0 |
3898 |
0 |
12 |
21 |
6 |
2026-08-16T13:49:50.012000Z |
play_count |
33 |
LOCAL |
0 |
3899 |
0 |
16 |
26 |
6 |
2026-08-16T13:49:50.012000Z |
play_count |
42 |
LOCAL |
0 |
3900 |
0 |
14 |
29 |
6 |
2026-08-16T13:49:50.012000Z |
play_count |
43 |
LOCAL |
0 |
3901 |
0 |
12 |
20 |
7 |
2026-08-16T13:49:50.012000Z |
play_count |
32 |
LOCAL |
0 |
3903 |
0 |
13 |
23 |
6 |
2026-08-16T13:49:50.012000Z |
play_count |
36 |
LOCAL |
0 |
3904 |
0 |
14 |
27 |
8 |
2026-08-16T13:49:50.012000Z |
play_count |
41 |
LOCAL |
0 |
3905 |
0 |
14 |
31 |
6 |
2026-08-16T13:49:50.012000Z |
play_count |
45 |
LOCAL |
0 |
3906 |
0 |
14 |
26 |
5 |
2026-08-16T13:49:50.012000Z |
play_count |
40 |
LOCAL |
0 |
3907 |
0 |
11 |
20 |
7 |
2026-08-16T13:49:50.012000Z |
play_count |
31 |
LOCAL |
0 |
3908 |
0 |
16 |
34 |
6 |
2026-08-16T13:49:50.012000Z |
play_count |
50 |
LOCAL |
0 |
3910 |
0 |
17 |
54 |
5 |
2026-08-16T13:49:50.012000Z |
play_count |
71 |
LOCAL |
0 |