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 |
|---|---|---|---|---|---|---|---|---|---|
1009 |
50458 |
332 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
50458 |
LOCAL |
1 |
1010 |
37306 |
154 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
37306 |
LOCAL |
1 |
1011 |
33187 |
242 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
33187 |
LOCAL |
1 |
1012 |
93247 |
472 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
93247 |
LOCAL |
1 |
1013 |
32002 |
116 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
32002 |
LOCAL |
1 |
1014 |
472072 |
825 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
472072 |
LOCAL |
1 |
1015 |
604021 |
671 |
0 |
0 |
2026-08-11T15:00:29.608000Z |
play_count |
604021 |
LOCAL |
1 |
1044 |
13893442 |
70064 |
132 |
5058 |
2026-08-12T13:47:19.401000Z |
play_count |
13893442 |
LOCAL |
1 |
1045 |
84243 |
355 |
9 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
84243 |
LOCAL |
1 |
1046 |
0 |
301 |
1 |
3 |
2026-08-11T15:10:27.241000Z |
play_count |
302 |
LOCAL |
0 |
1048 |
8291448 |
140508 |
2078 |
3885 |
2026-08-16T13:09:52.579000Z |
play_count |
8291448 |
LOCAL |
1 |
1049 |
0 |
3 |
4 |
1 |
2026-08-12T13:50:09.821000Z |
play_count |
7 |
LOCAL |
0 |
1050 |
1121 |
6 |
0 |
0 |
2026-08-12T09:21:15.133000Z |
play_count |
1121 |
LOCAL |
1 |
1051 |
0 |
1 |
0 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
1 |
LOCAL |
0 |
1053 |
1502252 |
35027 |
421 |
677 |
2026-08-11T15:10:27.241000Z |
play_count |
1502252 |
LOCAL |
1 |
1054 |
3213 |
30 |
12 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
3213 |
LOCAL |
1 |
1057 |
79905 |
586 |
186 |
32 |
2026-08-11T15:10:27.241000Z |
play_count |
79905 |
LOCAL |
1 |
1058 |
498866 |
11870 |
159 |
210 |
2026-08-11T15:10:27.241000Z |
play_count |
498866 |
LOCAL |
1 |
1059 |
3215 |
20 |
0 |
0 |
2026-08-12T09:21:15.133000Z |
play_count |
3215 |
LOCAL |
1 |
1060 |
1580 |
3 |
0 |
1 |
2026-08-12T01:48:23.204000Z |
play_count |
1580 |
LOCAL |
1 |
1061 |
89042 |
954 |
182 |
22 |
2026-08-11T15:10:27.241000Z |
play_count |
89042 |
LOCAL |
1 |
1063 |
2196 |
9 |
9 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
2196 |
LOCAL |
1 |
1065 |
7520 |
73 |
73 |
2 |
2026-08-11T15:10:27.241000Z |
play_count |
7520 |
LOCAL |
1 |
1066 |
2795 |
12 |
5 |
2 |
2026-08-11T15:10:27.241000Z |
play_count |
2795 |
LOCAL |
1 |
1067 |
7022150 |
100328 |
3338 |
2653 |
2026-08-12T01:49:50.692000Z |
play_count |
7022150 |
LOCAL |
1 |
1069 |
120747573 |
8223945 |
20880 |
201291 |
2026-08-16T13:42:47.786000Z |
play_count |
120747573 |
LOCAL |
1 |
1070 |
276628 |
3791 |
46 |
75 |
2026-08-11T15:10:27.241000Z |
play_count |
276628 |
LOCAL |
1 |
1071 |
14019027 |
89915 |
91 |
1234 |
2026-08-11T15:10:27.241000Z |
play_count |
14019027 |
LOCAL |
1 |
1072 |
1695476 |
14568 |
2687 |
547 |
2026-08-12T22:29:54.255000Z |
play_count |
1695476 |
LOCAL |
1 |
1073 |
25113 |
40 |
0 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
25113 |
LOCAL |
1 |
1074 |
26344547 |
391839 |
1250 |
8610 |
2026-08-12T14:01:02.727000Z |
play_count |
26344547 |
LOCAL |
1 |
1075 |
59507140 |
748619 |
1007 |
36895 |
2026-08-12T22:29:54.255000Z |
play_count |
59507140 |
LOCAL |
1 |
1076 |
15412828 |
297401 |
2156 |
7689 |
2026-08-11T15:10:27.241000Z |
play_count |
15412828 |
LOCAL |
1 |
1077 |
290235295 |
1445142 |
2134 |
35027 |
2026-08-11T15:10:27.241000Z |
play_count |
290235295 |
LOCAL |
1 |
1078 |
212359727 |
7030534 |
6873 |
133833 |
2026-08-12T13:48:01.295000Z |
play_count |
212359727 |
LOCAL |
1 |
1080 |
17760969 |
589029 |
3126 |
31205 |
2026-08-12T23:05:25.596000Z |
play_count |
17760969 |
LOCAL |
1 |
1081 |
4325207 |
98876 |
1051 |
1636 |
2026-08-14T06:42:43.868000Z |
play_count |
4325207 |
LOCAL |
1 |
1082 |
52171811 |
1267409 |
6376 |
20710 |
2026-08-14T07:05:20.852Z |
play_count |
52171811 |
LOCAL |
1 |
1083 |
85546907 |
5282575 |
14935 |
148941 |
2026-08-15T04:40:07.790000Z |
play_count |
85546907 |
LOCAL |
1 |
1085 |
159570208 |
4105660 |
16993 |
100649 |
2026-08-16T13:10:18.899000Z |
play_count |
159570208 |
LOCAL |
1 |
1086 |
13662 |
625 |
136 |
67 |
2026-08-12T23:05:25.596000Z |
play_count |
13662 |
LOCAL |
1 |
1087 |
3497 |
18 |
0 |
0 |
2026-08-11T15:10:27.241000Z |
play_count |
3497 |
LOCAL |
1 |
1088 |
24677544 |
424676 |
985 |
4846 |
2026-08-14T06:42:43.868000Z |
play_count |
24677544 |
LOCAL |
1 |
1133 |
843782 |
3384 |
154 |
74 |
2026-08-14T06:17:57.597000Z |
play_count |
843782 |
LOCAL |
1 |
1134 |
0 |
3 |
0 |
0 |
2026-08-11T21:44:53.988000Z |
play_count |
3 |
LOCAL |
0 |
1136 |
0 |
4 |
0 |
0 |
2026-08-11T21:44:53.988000Z |
play_count |
4 |
LOCAL |
0 |
1137 |
125334943 |
825778 |
0 |
48803 |
2026-08-11T21:44:53.988000Z |
play_count |
125334943 |
LOCAL |
1 |
1138 |
2579482 |
145843 |
4408 |
1250 |
2026-08-12T14:01:02.727000Z |
play_count |
2579482 |
LOCAL |
1 |
1140 |
0 |
84 |
0 |
0 |
2026-08-11T21:44:53.988000Z |
play_count |
84 |
LOCAL |
0 |
1141 |
4859678 |
26327 |
179 |
1644 |
2026-08-12T23:05:25.596000Z |
play_count |
4859678 |
LOCAL |
1 |
1142 |
4197099 |
28572 |
0 |
455 |
2026-08-11T21:44:53.988000Z |
play_count |
4197099 |
LOCAL |
1 |
1143 |
1162799 |
25248 |
0 |
598 |
2026-08-11T21:44:53.988000Z |
play_count |
1162799 |
LOCAL |
1 |
1144 |
0 |
24 |
0 |
1 |
2026-08-11T21:44:53.988000Z |
play_count |
24 |
LOCAL |
0 |
1145 |
12065674 |
52059 |
276 |
2198 |
2026-08-12T13:50:24.003Z |
play_count |
12065674 |
LOCAL |
1 |
1146 |
420 |
2 |
0 |
0 |
2026-08-11T21:44:53.988000Z |
play_count |
420 |
LOCAL |
1 |
1147 |
10289 |
85 |
7 |
2 |
2026-08-12T01:40:36.226000Z |
play_count |
10289 |
LOCAL |
1 |
1148 |
0 |
251 |
0 |
4 |
2026-08-11T21:44:53.988000Z |
play_count |
251 |
LOCAL |
0 |
1149 |
0 |
3 |
0 |
7 |
2026-08-11T21:44:53.988000Z |
play_count |
3 |
LOCAL |
0 |
1150 |
376473 |
11053 |
0 |
317 |
2026-08-11T21:44:53.988000Z |
play_count |
376473 |
LOCAL |
1 |
1151 |
4493689 |
87971 |
65 |
1022 |
2026-08-12T13:57:20.120000Z |
play_count |
4493689 |
LOCAL |
1 |
1152 |
0 |
51 |
0 |
0 |
2026-08-11T21:44:53.988000Z |
play_count |
51 |
LOCAL |
0 |
1153 |
159421433 |
391991 |
1594 |
28476 |
2026-08-16T12:02:10.758000Z |
play_count |
159421433 |
LOCAL |
1 |
1154 |
2201346 |
13219 |
65 |
1044 |
2026-08-12T01:40:36.226000Z |
play_count |
2201346 |
LOCAL |
1 |
1155 |
2416008 |
33592 |
403 |
688 |
2026-08-14T12:56:45.999000Z |
play_count |
2416008 |
LOCAL |
1 |
1156 |
7984950 |
106212 |
0 |
2289 |
2026-08-11T21:44:53.988000Z |
play_count |
7984950 |
LOCAL |
1 |
1188 |
397247 |
879 |
23 |
86 |
2026-08-12T23:05:03.584000Z |
play_count |
397247 |
LOCAL |
1 |
1190 |
4326275 |
108992 |
364 |
1142 |
2026-08-13T11:28:58.131000Z |
play_count |
4326275 |
LOCAL |
1 |
1192 |
970 |
34 |
5 |
1 |
2026-08-12T13:57:35.663000Z |
play_count |
970 |
LOCAL |
1 |
1193 |
1156054 |
17014 |
47 |
279 |
2026-08-12T22:29:54.255000Z |
play_count |
1156054 |
LOCAL |
1 |
1194 |
0 |
14 |
1 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
15 |
LOCAL |
0 |
1195 |
47049021 |
144452 |
322 |
14322 |
2026-08-16T12:03:28.838000Z |
play_count |
47049021 |
LOCAL |
1 |
1196 |
1797117 |
14632 |
104 |
214 |
2026-08-15T04:40:07.790000Z |
play_count |
1797117 |
LOCAL |
1 |
1197 |
9573218 |
66504 |
314 |
1535 |
2026-08-12T01:40:36.226000Z |
play_count |
9573218 |
LOCAL |
1 |
1199 |
3138514 |
7732 |
27 |
289 |
2026-08-12T01:40:36.226000Z |
play_count |
3138514 |
LOCAL |
1 |
1200 |
6972777 |
10841 |
66 |
263 |
2026-08-12T01:49:50.692000Z |
play_count |
6972777 |
LOCAL |
1 |
1203 |
23771 |
91 |
141 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
23771 |
LOCAL |
1 |
1204 |
10017607 |
37311 |
58 |
740 |
2026-08-12T23:05:25.596000Z |
play_count |
10017607 |
LOCAL |
1 |
1205 |
2584100 |
26533 |
3091 |
906 |
2026-08-12T23:05:03.584000Z |
play_count |
2584100 |
LOCAL |
1 |
1206 |
2134320 |
322569 |
3128 |
1180 |
2026-08-12T23:05:25.596000Z |
play_count |
2134320 |
LOCAL |
1 |
1208 |
10225197 |
58882 |
419 |
2060 |
2026-08-12T01:40:36.226000Z |
play_count |
10225197 |
LOCAL |
1 |
1210 |
50853 |
8659 |
927 |
17 |
2026-08-12T01:40:36.226000Z |
play_count |
50853 |
LOCAL |
1 |
1211 |
71038917 |
726394 |
1171 |
8313 |
2026-08-12T01:40:36.226000Z |
play_count |
71038917 |
LOCAL |
1 |
1213 |
6110136 |
49643 |
188 |
1179 |
2026-08-15T04:38:11.840000Z |
play_count |
6110136 |
LOCAL |
1 |
1215 |
9247695 |
47985 |
91 |
566 |
2026-08-12T13:55:50.921000Z |
play_count |
9247695 |
LOCAL |
1 |
1218 |
27356565 |
378800 |
1172 |
7991 |
2026-08-12T01:40:36.226000Z |
play_count |
27356565 |
LOCAL |
1 |
1219 |
0 |
71 |
9 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
80 |
LOCAL |
0 |
1220 |
1993 |
3 |
14 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
1993 |
LOCAL |
1 |
1222 |
0 |
3 |
0 |
1 |
2026-08-12T01:40:36.226000Z |
play_count |
3 |
LOCAL |
0 |
1225 |
6316 |
573 |
23 |
17 |
2026-08-12T01:40:36.226000Z |
play_count |
6316 |
LOCAL |
1 |
1226 |
2560 |
97 |
8 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
2560 |
LOCAL |
1 |
1228 |
6056438 |
19315 |
33 |
339 |
2026-08-12T01:40:36.226000Z |
play_count |
6056438 |
LOCAL |
1 |
1229 |
1171755 |
45475 |
707 |
1677 |
2026-08-15T04:41:59.380000Z |
play_count |
1171755 |
LOCAL |
1 |
1232 |
7367954 |
130438 |
79187 |
1369 |
2026-08-15T04:40:07.790000Z |
play_count |
7367954 |
LOCAL |
1 |
1233 |
9866571 |
54341 |
122 |
1114 |
2026-08-12T01:40:36.226000Z |
play_count |
9866571 |
LOCAL |
1 |
1234 |
116719516 |
5424006 |
23762 |
71681 |
2026-08-12T01:40:36.226000Z |
play_count |
116719516 |
LOCAL |
1 |
1235 |
11395271 |
328353 |
341 |
9728 |
2026-08-16T13:10:03.639000Z |
play_count |
11395271 |
LOCAL |
1 |
1236 |
5386611 |
22212 |
46 |
523 |
2026-08-12T01:40:36.226000Z |
play_count |
5386611 |
LOCAL |
1 |
1238 |
18267924 |
1196342 |
2900 |
33548 |
2026-08-12T01:40:36.226000Z |
play_count |
18267924 |
LOCAL |
1 |
1243 |
4288101 |
3 |
158 |
778 |
2026-08-12T13:57:35.663000Z |
play_count |
4288101 |
LOCAL |
1 |
1246 |
5776089 |
3 |
3058 |
3660 |
2026-08-12T13:47:19.401000Z |
play_count |
5776089 |
LOCAL |
1 |