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 |
|---|---|---|---|---|---|---|---|---|---|
2712 |
19972460 |
70945 |
274 |
4083 |
2026-08-12T23:05:03.584000Z |
play_count |
19972460 |
LOCAL |
1 |
2715 |
3818 |
12 |
3 |
1 |
2026-08-12T23:05:03.584000Z |
play_count |
3818 |
LOCAL |
1 |
2742 |
127595 |
1732 |
21 |
41 |
2026-08-12T23:05:25.596000Z |
play_count |
127595 |
LOCAL |
1 |
2744 |
15095730 |
166140 |
1499 |
2362 |
2026-08-12T23:05:25.596000Z |
play_count |
15095730 |
LOCAL |
1 |
2751 |
0 |
382 |
31 |
1 |
2026-08-12T23:05:25.596000Z |
play_count |
413 |
LOCAL |
0 |
2757 |
3872658 |
143333 |
15 |
1805 |
2026-08-12T23:05:25.596000Z |
play_count |
3872658 |
LOCAL |
1 |
2762 |
40402 |
454 |
266 |
11 |
2026-08-12T23:05:25.596000Z |
play_count |
40402 |
LOCAL |
1 |
2763 |
347604 |
3913 |
82 |
495 |
2026-08-12T23:05:25.596000Z |
play_count |
347604 |
LOCAL |
1 |
2764 |
37105357 |
446114 |
1637 |
9512 |
2026-08-16T12:03:28.838000Z |
play_count |
37105357 |
LOCAL |
1 |
2790 |
0 |
17 |
5 |
6 |
2026-08-12T23:23:13.715000Z |
play_count |
22 |
LOCAL |
0 |
2791 |
0 |
434 |
2511 |
63 |
2026-08-12T23:23:13.715000Z |
play_count |
2945 |
LOCAL |
0 |
2792 |
0 |
3324 |
103 |
61 |
2026-08-12T23:23:13.715000Z |
play_count |
3427 |
LOCAL |
0 |
2797 |
2648594 |
16195 |
2211 |
921 |
2026-08-13T11:28:58.131000Z |
play_count |
2648594 |
LOCAL |
1 |
2799 |
52649164 |
796285 |
1128 |
21260 |
2026-08-16T12:03:28.838000Z |
play_count |
52649164 |
LOCAL |
1 |
2803 |
1300909 |
12751 |
245 |
240 |
2026-08-13T11:28:58.131000Z |
play_count |
1300909 |
LOCAL |
1 |
2805 |
101404353 |
4990982 |
30253 |
87868 |
2026-08-13T11:28:58.131000Z |
play_count |
101404353 |
LOCAL |
1 |
2806 |
4009 |
27 |
27 |
7 |
2026-08-13T11:28:58.131000Z |
play_count |
4009 |
LOCAL |
1 |
2807 |
3475757 |
74528 |
145 |
2794 |
2026-08-13T11:28:58.131000Z |
play_count |
3475757 |
LOCAL |
1 |
2808 |
445024 |
4441 |
75 |
109 |
2026-08-14T06:17:57.597000Z |
play_count |
445024 |
LOCAL |
1 |
2821 |
449956 |
3767 |
67 |
426 |
2026-08-15T04:39:58.933000Z |
play_count |
449956 |
LOCAL |
1 |
2823 |
5662404 |
251531 |
396 |
4303 |
2026-08-14T06:17:57.597000Z |
play_count |
5662404 |
LOCAL |
1 |
2828 |
67868815 |
3439964 |
8878 |
49911 |
2026-08-14T06:17:57.597000Z |
play_count |
67868815 |
LOCAL |
1 |
2854 |
14471751 |
358087 |
9758 |
12370 |
2026-08-16T12:17:46.204000Z |
play_count |
14471751 |
LOCAL |
1 |
2858 |
243525 |
7031 |
39 |
242 |
2026-08-14T06:42:43.868000Z |
play_count |
243525 |
LOCAL |
1 |
2865 |
110387755 |
3349950 |
17529 |
51919 |
2026-08-15T04:41:59.380000Z |
play_count |
110387755 |
LOCAL |
1 |
2871 |
4973546 |
271035 |
12427 |
5100 |
2026-08-16T12:02:10.758000Z |
play_count |
4973546 |
LOCAL |
1 |
2893 |
1113035 |
14359 |
52 |
170 |
2026-08-14T07:05:21.478000Z |
play_count |
1113035 |
LOCAL |
1 |
2895 |
9860 |
136 |
1 |
3 |
2026-08-14T07:05:21.478000Z |
play_count |
9860 |
LOCAL |
1 |
2896 |
7410 |
163 |
0 |
1 |
2026-08-14T07:05:21.478000Z |
play_count |
7410 |
LOCAL |
1 |
2897 |
388258 |
9493 |
79 |
162 |
2026-08-14T07:05:21.478000Z |
play_count |
388258 |
LOCAL |
1 |
2898 |
20227 |
135 |
0 |
0 |
2026-08-14T07:05:21.478000Z |
play_count |
20227 |
LOCAL |
1 |
2899 |
34545 |
676 |
4 |
14 |
2026-08-14T07:05:21.478000Z |
play_count |
34545 |
LOCAL |
1 |
2900 |
38148 |
674 |
2 |
6 |
2026-08-14T07:05:21.478000Z |
play_count |
38148 |
LOCAL |
1 |
2901 |
61393 |
947 |
7 |
20 |
2026-08-14T07:05:21.478000Z |
play_count |
61393 |
LOCAL |
1 |
2902 |
47440 |
1557 |
10 |
14 |
2026-08-14T07:05:21.478000Z |
play_count |
47440 |
LOCAL |
1 |
2903 |
1824706 |
23596 |
112 |
414 |
2026-08-14T07:05:21.478000Z |
play_count |
1824706 |
LOCAL |
1 |
2904 |
343865 |
6734 |
29 |
133 |
2026-08-14T07:05:21.478000Z |
play_count |
343865 |
LOCAL |
1 |
2928 |
91694 |
3292 |
22 |
62 |
2026-08-14T06:46:00.520000Z |
play_count |
91694 |
LOCAL |
1 |
2934 |
84297 |
2994 |
11 |
39 |
2026-08-14T06:46:00.520000Z |
play_count |
84297 |
LOCAL |
1 |
2936 |
91547 |
2946 |
9 |
28 |
2026-08-14T06:46:00.520000Z |
play_count |
91547 |
LOCAL |
1 |
2938 |
100125 |
1753 |
8 |
33 |
2026-08-14T06:46:00.520000Z |
play_count |
100125 |
LOCAL |
1 |
2939 |
77854 |
3096 |
12 |
47 |
2026-08-14T06:46:00.520000Z |
play_count |
77854 |
LOCAL |
1 |
2940 |
70125 |
1230 |
4 |
18 |
2026-08-14T06:46:00.520000Z |
play_count |
70125 |
LOCAL |
1 |
2941 |
68511 |
2089 |
6 |
23 |
2026-08-14T06:46:00.520000Z |
play_count |
68511 |
LOCAL |
1 |
2942 |
76125 |
1264 |
10 |
19 |
2026-08-14T06:46:00.520000Z |
play_count |
76125 |
LOCAL |
1 |
2943 |
82107 |
1468 |
19 |
17 |
2026-08-14T06:46:00.520000Z |
play_count |
82107 |
LOCAL |
1 |
2945 |
73307 |
2272 |
13 |
19 |
2026-08-14T06:46:00.520000Z |
play_count |
73307 |
LOCAL |
1 |
2946 |
78217 |
1638 |
4 |
49 |
2026-08-14T06:46:00.520000Z |
play_count |
78217 |
LOCAL |
1 |
2947 |
366940 |
7062 |
27 |
116 |
2026-08-14T06:46:00.520000Z |
play_count |
366940 |
LOCAL |
1 |
2948 |
56223 |
1016 |
5 |
20 |
2026-08-14T06:46:12Z |
play_count |
56223 |
SERVER |
1 |
2949 |
219761 |
3069 |
12 |
54 |
2026-08-14T06:46:12Z |
play_count |
219761 |
SERVER |
1 |
2950 |
60546 |
1857 |
9 |
33 |
2026-08-14T06:46:12Z |
play_count |
60546 |
SERVER |
1 |
2952 |
52572 |
961 |
16 |
19 |
2026-08-14T06:46:12Z |
play_count |
52572 |
SERVER |
1 |
2953 |
79398 |
1540 |
7 |
26 |
2026-08-14T06:46:12Z |
play_count |
79398 |
SERVER |
1 |
2954 |
46074 |
672 |
3 |
13 |
2026-08-14T06:46:12Z |
play_count |
46074 |
SERVER |
1 |
2955 |
46974 |
1231 |
6 |
19 |
2026-08-14T06:46:12Z |
play_count |
46974 |
SERVER |
1 |
2956 |
46746 |
1226 |
12 |
22 |
2026-08-14T06:46:12Z |
play_count |
46746 |
SERVER |
1 |
2957 |
159880 |
4254 |
17 |
138 |
2026-08-14T06:46:12Z |
play_count |
159880 |
SERVER |
1 |
2958 |
37795 |
896 |
4 |
11 |
2026-08-14T06:46:12Z |
play_count |
37795 |
SERVER |
1 |
2959 |
40133 |
559 |
3 |
13 |
2026-08-14T06:46:12Z |
play_count |
40133 |
SERVER |
1 |
3014 |
13010 |
74 |
202 |
15 |
2026-08-14T07:02:44.707000Z |
play_count |
13010 |
LOCAL |
1 |
3016 |
832781 |
23814 |
169 |
603 |
2026-08-16T13:49:39.588000Z |
play_count |
832781 |
LOCAL |
1 |
3020 |
2291482 |
60364 |
470 |
1629 |
2026-08-14T07:02:44.707000Z |
play_count |
2291482 |
LOCAL |
1 |
3021 |
33612286 |
2458618 |
10926 |
58047 |
2026-08-16T12:03:28.838000Z |
play_count |
33612286 |
LOCAL |
1 |
3024 |
593393 |
5210 |
68 |
93 |
2026-08-14T07:02:44.707000Z |
play_count |
593393 |
LOCAL |
1 |
3027 |
1697161 |
45118 |
237 |
666 |
2026-08-15T04:40:07.790000Z |
play_count |
1697161 |
LOCAL |
1 |
3031 |
10793593 |
71531 |
858 |
3162 |
2026-08-16T13:49:41.254000Z |
play_count |
10793593 |
LOCAL |
1 |
3035 |
462227 |
10152 |
99 |
287 |
2026-08-14T07:04:55.410000Z |
play_count |
462227 |
LOCAL |
1 |
3036 |
188123 |
1153 |
28 |
25 |
2026-08-14T07:04:55.410000Z |
play_count |
188123 |
LOCAL |
1 |
3037 |
2079975 |
22027 |
179 |
206 |
2026-08-14T07:04:55.410000Z |
play_count |
2079975 |
LOCAL |
1 |
3038 |
415850 |
7091 |
3776 |
89 |
2026-08-16T13:09:52.579000Z |
play_count |
415850 |
LOCAL |
1 |
3039 |
5766848 |
112148 |
265 |
836 |
2026-08-14T07:04:55.410000Z |
play_count |
5766848 |
LOCAL |
1 |
3040 |
741520 |
8049 |
458 |
169 |
2026-08-14T07:04:55.410000Z |
play_count |
741520 |
LOCAL |
1 |
3041 |
5076240 |
13369 |
424 |
299 |
2026-08-14T07:04:55.410000Z |
play_count |
5076240 |
LOCAL |
1 |
3042 |
5320345 |
27091 |
35 |
495 |
2026-08-14T07:04:55.410000Z |
play_count |
5320345 |
LOCAL |
1 |
3044 |
2892916 |
25125 |
19254 |
296 |
2026-08-14T07:04:55.410000Z |
play_count |
2892916 |
LOCAL |
1 |
3045 |
2014117 |
15839 |
2011 |
115 |
2026-08-14T07:04:55.410000Z |
play_count |
2014117 |
LOCAL |
1 |
3047 |
3252993 |
65157 |
343 |
2414 |
2026-08-16T12:02:10.758000Z |
play_count |
3252993 |
LOCAL |
1 |
3048 |
787607 |
5159 |
69 |
140 |
2026-08-14T07:04:55.410000Z |
play_count |
787607 |
LOCAL |
1 |
3049 |
494 |
6 |
15 |
1 |
2026-08-14T07:04:55.410000Z |
play_count |
494 |
LOCAL |
1 |
3052 |
21289702 |
205433 |
3145 |
7862 |
2026-08-14T07:04:55.410000Z |
play_count |
21289702 |
LOCAL |
1 |
3054 |
2549716 |
192374 |
1446 |
1955 |
2026-08-14T07:04:55.410000Z |
play_count |
2549716 |
LOCAL |
1 |
3103 |
26825 |
207 |
16 |
7 |
2026-08-14T07:46:10.873000Z |
play_count |
26825 |
LOCAL |
1 |
3104 |
18220 |
3 |
1 |
1 |
2026-08-14T07:46:10.873000Z |
play_count |
18220 |
LOCAL |
1 |
3105 |
723559 |
3792 |
145 |
29 |
2026-08-14T07:46:10.873000Z |
play_count |
723559 |
LOCAL |
1 |
3108 |
305881 |
4378 |
102 |
94 |
2026-08-14T07:46:10.873000Z |
play_count |
305881 |
LOCAL |
1 |
3109 |
6630 |
24 |
53 |
8 |
2026-08-14T07:46:10.873000Z |
play_count |
6630 |
LOCAL |
1 |
3111 |
551180 |
5978 |
190 |
171 |
2026-08-14T07:46:10.873000Z |
play_count |
551180 |
LOCAL |
1 |
3114 |
11448278 |
239400 |
302 |
3236 |
2026-08-14T07:46:10.873000Z |
play_count |
11448278 |
LOCAL |
1 |
3116 |
4010263 |
18963 |
55 |
637 |
2026-08-14T07:46:10.873000Z |
play_count |
4010263 |
LOCAL |
1 |
3117 |
34182044 |
426123 |
1469 |
3884 |
2026-08-14T07:46:10.873000Z |
play_count |
34182044 |
LOCAL |
1 |
3120 |
116773 |
1454 |
130 |
58 |
2026-08-14T07:46:10.873000Z |
play_count |
116773 |
LOCAL |
1 |
3121 |
18935936 |
546767 |
1468 |
8010 |
2026-08-14T07:46:10.873000Z |
play_count |
18935936 |
LOCAL |
1 |
3122 |
1249984 |
29254 |
140 |
396 |
2026-08-14T07:46:10.873000Z |
play_count |
1249984 |
LOCAL |
1 |
3144 |
1262145 |
25753 |
80 |
461 |
2026-08-14T12:56:45.999000Z |
play_count |
1262145 |
LOCAL |
1 |
3145 |
10674589 |
450199 |
1436 |
4038 |
2026-08-16T13:42:47.786000Z |
play_count |
10674589 |
LOCAL |
1 |
3147 |
749154341 |
22450022 |
82042 |
682909 |
2026-08-14T12:56:45.999000Z |
play_count |
749154341 |
LOCAL |
1 |
3151 |
16330923 |
260146 |
694 |
10231 |
2026-08-14T12:56:45.999000Z |
play_count |
16330923 |
LOCAL |
1 |
3161 |
93070055 |
11823683 |
40390 |
265724 |
2026-08-16T13:09:52.579000Z |
play_count |
93070055 |
LOCAL |
1 |
3163 |
539792 |
12347 |
49 |
182 |
2026-08-14T12:56:45.999000Z |
play_count |
539792 |
LOCAL |
1 |