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 |
|---|---|---|---|---|---|---|---|---|---|
1248 |
1692 |
56 |
4 |
0 |
2026-08-12T01:40:36.226000Z |
play_count |
1692 |
LOCAL |
1 |
1249 |
993706 |
14674 |
3718 |
254 |
2026-08-12T01:40:36.226000Z |
play_count |
993706 |
LOCAL |
1 |
1251 |
3810501 |
46167 |
66 |
840 |
2026-08-14T12:56:45.999000Z |
play_count |
3810501 |
LOCAL |
1 |
1252 |
84932946 |
6823530 |
129980 |
157197 |
2026-08-12T01:40:36.226000Z |
play_count |
84932946 |
LOCAL |
1 |
1254 |
128593444 |
2642792 |
4933 |
38464 |
2026-08-12T13:47:19.401000Z |
play_count |
128593444 |
LOCAL |
1 |
1255 |
24341235 |
316026 |
1800 |
4889 |
2026-08-15T04:41:59.380000Z |
play_count |
24341235 |
LOCAL |
1 |
1256 |
775362649 |
7935241 |
18105 |
742443 |
2026-08-16T13:09:52.579000Z |
play_count |
775362649 |
LOCAL |
1 |
1325 |
598850 |
11357 |
414 |
0 |
2026-08-12T13:56:21.365000Z |
play_count |
598850 |
LOCAL |
1 |
1327 |
3397866 |
83581 |
61 |
339 |
2026-08-12T09:20:58.961000Z |
play_count |
3397866 |
LOCAL |
1 |
1328 |
54471534 |
338693 |
781 |
20382 |
2026-08-12T01:56:49.305000Z |
play_count |
54471534 |
LOCAL |
1 |
1329 |
3474252 |
73832 |
2732 |
2239 |
2026-08-12T13:57:35.663000Z |
play_count |
3474252 |
LOCAL |
1 |
1330 |
31378 |
120 |
2 |
3 |
2026-08-12T01:48:06.401000Z |
play_count |
31378 |
LOCAL |
1 |
1332 |
178738531 |
1448847 |
11557 |
37414 |
2026-08-12T01:48:06.401000Z |
play_count |
178738531 |
LOCAL |
1 |
1333 |
9644 |
44 |
92 |
0 |
2026-08-12T01:48:06.401000Z |
play_count |
9644 |
LOCAL |
1 |
1334 |
24940 |
312 |
13 |
5 |
2026-08-12T01:49:50Z |
play_count |
24940 |
SERVER |
1 |
1335 |
8326622 |
57194 |
233 |
1299 |
2026-08-12T23:05:25.596000Z |
play_count |
8326622 |
LOCAL |
1 |
1336 |
1245510 |
10389 |
444 |
310 |
2026-08-16T13:42:47.786000Z |
play_count |
1245510 |
LOCAL |
1 |
1337 |
10729578 |
114708 |
2019 |
5971 |
2026-08-15T04:38:11.840000Z |
play_count |
10729578 |
LOCAL |
1 |
1339 |
1330721 |
32844 |
254 |
323 |
2026-08-12T13:50:09.821000Z |
play_count |
1330721 |
LOCAL |
1 |
1341 |
30914 |
302 |
23 |
9 |
2026-08-14T12:56:45.999000Z |
play_count |
30914 |
LOCAL |
1 |
1342 |
32214081 |
182451 |
1509 |
6966 |
2026-08-12T23:05:03.584000Z |
play_count |
32214081 |
LOCAL |
1 |
1366 |
495607 |
28211 |
249 |
406 |
2026-08-13T11:28:58.131000Z |
play_count |
495607 |
LOCAL |
1 |
1367 |
2071485 |
30009 |
752 |
856 |
2026-08-12T13:47:19.401000Z |
play_count |
2071485 |
LOCAL |
1 |
1368 |
1989 |
3 |
0 |
2 |
2026-08-12T13:47:19.401000Z |
play_count |
1989 |
LOCAL |
1 |
1369 |
1123 |
19 |
10 |
1 |
2026-08-12T13:48:49.406000Z |
play_count |
1123 |
LOCAL |
1 |
1372 |
7330817 |
77517 |
626 |
2049 |
2026-08-16T13:10:03.639000Z |
play_count |
7330817 |
LOCAL |
1 |
1375 |
775257 |
13534 |
110 |
255 |
2026-08-12T01:48:23.204000Z |
play_count |
775257 |
LOCAL |
1 |
1376 |
691405 |
19401 |
470 |
562 |
2026-08-15T04:39:41.904000Z |
play_count |
691405 |
LOCAL |
1 |
1380 |
2927379 |
79107 |
150 |
3255 |
2026-08-12T01:48:43Z |
play_count |
2927379 |
SERVER |
1 |
1382 |
1197598 |
17846 |
542 |
547 |
2026-08-12T01:48:23.204000Z |
play_count |
1197598 |
LOCAL |
1 |
1383 |
91173218 |
6164004 |
17047 |
115571 |
2026-08-16T13:42:47.786000Z |
play_count |
91173218 |
LOCAL |
1 |
1386 |
0 |
4 |
1 |
0 |
2026-08-12T01:48:43.832000Z |
play_count |
5 |
LOCAL |
0 |
1405 |
109990 |
2205 |
196 |
15 |
2026-08-12T01:49:19.419Z |
play_count |
109990 |
LOCAL |
1 |
1408 |
8926 |
82 |
2 |
3 |
2026-08-12T13:49:45.855000Z |
play_count |
8926 |
LOCAL |
1 |
1413 |
4737 |
52 |
3 |
1 |
2026-08-12T01:48:43.832000Z |
play_count |
4737 |
LOCAL |
1 |
1414 |
1510877 |
51995 |
300 |
1147 |
2026-08-12T13:48:01.295000Z |
play_count |
1510877 |
LOCAL |
1 |
1417 |
5623 |
51 |
5 |
1 |
2026-08-12T03:15:08.142000Z |
play_count |
5623 |
LOCAL |
1 |
1418 |
437075 |
4897 |
66 |
105 |
2026-08-12T01:48:43.832000Z |
play_count |
437075 |
LOCAL |
1 |
1419 |
10756 |
475 |
51 |
4 |
2026-08-12T01:48:43.832000Z |
play_count |
10756 |
LOCAL |
1 |
1420 |
4024 |
47 |
6 |
1 |
2026-08-12T13:48:01.295000Z |
play_count |
4024 |
LOCAL |
1 |
1421 |
149805770 |
633032 |
2435 |
30837 |
2026-08-15T04:41:59.380000Z |
play_count |
149805770 |
LOCAL |
1 |
1422 |
2833 |
67 |
2 |
1 |
2026-08-12T01:48:43.832000Z |
play_count |
2833 |
LOCAL |
1 |
1444 |
653142 |
9641 |
456 |
247 |
2026-08-12T01:49:50.692000Z |
play_count |
653142 |
LOCAL |
1 |
1446 |
106282826 |
485936 |
1358 |
14071 |
2026-08-12T13:57:20.120000Z |
play_count |
106282826 |
LOCAL |
1 |
1447 |
107689894 |
931085 |
2968 |
36137 |
2026-08-12T01:49:50.692000Z |
play_count |
107689894 |
LOCAL |
1 |
1448 |
118070 |
6815 |
101 |
35 |
2026-08-12T09:14:18.405000Z |
play_count |
118070 |
LOCAL |
1 |
1451 |
23670 |
359 |
23 |
8 |
2026-08-12T01:49:50.692000Z |
play_count |
23670 |
LOCAL |
1 |
1452 |
58634743 |
764983 |
1653 |
19062 |
2026-08-12T01:50:52.122Z |
play_count |
58634743 |
LOCAL |
1 |
1454 |
1312279 |
23827 |
224 |
355 |
2026-08-14T06:17:57.597000Z |
play_count |
1312279 |
LOCAL |
1 |
1455 |
6350896 |
42276 |
78 |
2058 |
2026-08-12T01:49:50.692000Z |
play_count |
6350896 |
LOCAL |
1 |
1456 |
36721002 |
158544 |
546 |
1736 |
2026-08-16T12:02:10.758000Z |
play_count |
36721002 |
LOCAL |
1 |
1457 |
3183412 |
16648 |
133 |
544 |
2026-08-16T13:49:41.254000Z |
play_count |
3183412 |
LOCAL |
1 |
1463 |
1202004 |
32881 |
508 |
543 |
2026-08-12T01:49:50.692000Z |
play_count |
1202004 |
LOCAL |
1 |
1498 |
3442923 |
47759 |
465 |
1107 |
2026-08-16T13:42:47.786000Z |
play_count |
3442923 |
LOCAL |
1 |
1502 |
34704751 |
2391005 |
8057 |
30598 |
2026-08-12T13:54:35.323000Z |
play_count |
34704751 |
LOCAL |
1 |
1504 |
2831192 |
3 |
571 |
1351 |
2026-08-12T01:56:49.305000Z |
play_count |
2831192 |
LOCAL |
1 |
1505 |
9384490 |
135882 |
319 |
2067 |
2026-08-12T01:56:49.305000Z |
play_count |
9384490 |
LOCAL |
1 |
1506 |
13386857 |
42556 |
141 |
595 |
2026-08-12T13:57:20.120000Z |
play_count |
13386857 |
LOCAL |
1 |
1507 |
20293631 |
165455 |
868 |
2806 |
2026-08-14T06:17:57.597000Z |
play_count |
20293631 |
LOCAL |
1 |
1509 |
2855 |
37 |
0 |
1 |
2026-08-12T01:56:49.305000Z |
play_count |
2855 |
LOCAL |
1 |
1511 |
2432428 |
37419 |
24 |
344 |
2026-08-12T13:57:35.663000Z |
play_count |
2432428 |
LOCAL |
1 |
1514 |
70014487 |
3176966 |
9740 |
48960 |
2026-08-12T01:56:49.305000Z |
play_count |
70014487 |
LOCAL |
1 |
1516 |
873 |
13 |
4 |
0 |
2026-08-12T23:05:25.596000Z |
play_count |
873 |
LOCAL |
1 |
1547 |
1278 |
16 |
16 |
0 |
2026-08-12T03:15:03.730000Z |
play_count |
1278 |
LOCAL |
1 |
1548 |
656 |
7 |
1 |
0 |
2026-08-12T03:15:03.730000Z |
play_count |
656 |
LOCAL |
1 |
1549 |
0 |
42 |
1 |
0 |
2026-08-12T03:15:03.730000Z |
play_count |
43 |
LOCAL |
0 |
1550 |
0 |
29 |
9 |
0 |
2026-08-12T03:15:03.730000Z |
play_count |
38 |
LOCAL |
0 |
1551 |
0 |
10 |
1 |
0 |
2026-08-12T03:15:03.730000Z |
play_count |
11 |
LOCAL |
0 |
1552 |
0 |
13 |
16 |
1 |
2026-08-12T03:15:03.730000Z |
play_count |
29 |
LOCAL |
0 |
1570 |
555763 |
14040 |
40 |
135 |
2026-08-12T03:15:08.142000Z |
play_count |
555763 |
LOCAL |
1 |
1572 |
4856591 |
78852 |
135 |
632 |
2026-08-12T03:15:08.142000Z |
play_count |
4856591 |
LOCAL |
1 |
1573 |
2750708 |
60041 |
316 |
2463 |
2026-08-12T13:50:09.821000Z |
play_count |
2750708 |
LOCAL |
1 |
1580 |
4267518 |
21434 |
55 |
439 |
2026-08-16T13:49:41.254000Z |
play_count |
4267518 |
LOCAL |
1 |
1582 |
3008508 |
74217 |
162 |
1238 |
2026-08-12T14:01:02.727000Z |
play_count |
3008508 |
LOCAL |
1 |
1583 |
2009657 |
40121 |
144 |
595 |
2026-08-16T13:49:41.254000Z |
play_count |
2009657 |
LOCAL |
1 |
1584 |
8690745 |
155140 |
581 |
3620 |
2026-08-16T13:42:47.786000Z |
play_count |
8690745 |
LOCAL |
1 |
1585 |
2455876 |
20874 |
96 |
592 |
2026-08-16T12:03:28.838000Z |
play_count |
2455876 |
LOCAL |
1 |
1612 |
612965 |
2076 |
92 |
374 |
2026-08-12T09:15:15.640000Z |
play_count |
612965 |
LOCAL |
1 |
1613 |
887564 |
23271 |
1140 |
367 |
2026-08-12T03:20:27.675000Z |
play_count |
887564 |
LOCAL |
1 |
1615 |
6401459 |
180933 |
2687 |
2955 |
2026-08-12T03:19:27.971000Z |
play_count |
6401459 |
LOCAL |
1 |
1616 |
6096 |
22 |
18 |
9 |
2026-08-12T03:19:27.971000Z |
play_count |
6096 |
LOCAL |
1 |
1678 |
744119 |
33469 |
237 |
543 |
2026-08-12T13:56:21.365000Z |
play_count |
744119 |
LOCAL |
1 |
1680 |
1016922 |
18895 |
286 |
337 |
2026-08-14T12:56:45.999000Z |
play_count |
1016922 |
LOCAL |
1 |
1683 |
14690035 |
474935 |
1132 |
3546 |
2026-08-12T09:14:18.405000Z |
play_count |
14690035 |
LOCAL |
1 |
1688 |
8348 |
38 |
124 |
4 |
2026-08-12T09:14:18.405000Z |
play_count |
8348 |
LOCAL |
1 |
1689 |
1519798 |
18273 |
28 |
181 |
2026-08-12T13:56:21.365000Z |
play_count |
1519798 |
LOCAL |
1 |
1692 |
722158 |
28211 |
68 |
318 |
2026-08-12T23:05:03.584000Z |
play_count |
722158 |
LOCAL |
1 |
1693 |
3773 |
259 |
10 |
9 |
2026-08-12T13:48:49.406000Z |
play_count |
3773 |
LOCAL |
1 |
1724 |
120908 |
954 |
161 |
148 |
2026-08-12T09:15:15.640000Z |
play_count |
120908 |
LOCAL |
1 |
1727 |
59666 |
1413 |
31 |
30 |
2026-08-12T09:20:15.437000Z |
play_count |
59666 |
LOCAL |
1 |
1729 |
41880 |
664 |
14 |
10 |
2026-08-12T09:15:42.513000Z |
play_count |
41880 |
LOCAL |
1 |
1733 |
23283 |
327 |
3 |
2 |
2026-08-12T09:15:45.565000Z |
play_count |
23283 |
LOCAL |
1 |
1734 |
0 |
142 |
6 |
0 |
2026-08-12T09:15:45.565000Z |
play_count |
148 |
LOCAL |
0 |
1739 |
22440 |
332 |
4 |
4 |
2026-08-12T09:15:47.016000Z |
play_count |
22440 |
LOCAL |
1 |
1741 |
31952 |
426 |
8 |
9 |
2026-08-12T09:15:47.016000Z |
play_count |
31952 |
LOCAL |
1 |
1747 |
0 |
44206 |
153 |
499 |
2026-08-12T09:19:17.258000Z |
play_count |
44359 |
LOCAL |
0 |
1756 |
0 |
113 |
3 |
0 |
2026-08-12T09:16:06.430000Z |
play_count |
116 |
LOCAL |
0 |
1760 |
18809 |
312 |
14 |
4 |
2026-08-12T09:16:11.575000Z |
play_count |
18809 |
LOCAL |
1 |
1762 |
94789 |
1471 |
14 |
37 |
2026-08-12T09:16:08.059000Z |
play_count |
94789 |
LOCAL |
1 |
1763 |
58141 |
1086 |
36 |
37 |
2026-08-12T09:16:08.059000Z |
play_count |
58141 |
LOCAL |
1 |