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 |
|---|---|---|---|---|---|---|---|---|---|
2302 |
4042086 |
53126 |
1154 |
539 |
2026-08-12T13:50:09.821000Z |
play_count |
4042086 |
LOCAL |
1 |
2303 |
7237686 |
113493 |
1799 |
2079 |
2026-08-12T13:50:09.821000Z |
play_count |
7237686 |
LOCAL |
1 |
2304 |
34726490 |
294093 |
344 |
4675 |
2026-08-12T13:50:09.821000Z |
play_count |
34726490 |
LOCAL |
1 |
2305 |
12516840 |
152593 |
1624 |
5036 |
2026-08-12T13:50:09.821000Z |
play_count |
12516840 |
LOCAL |
1 |
2308 |
430537 |
7531 |
2702 |
36 |
2026-08-16T13:09:52.579000Z |
play_count |
430537 |
LOCAL |
1 |
2309 |
7054153 |
33973 |
82 |
740 |
2026-08-12T13:50:09.821000Z |
play_count |
7054153 |
LOCAL |
1 |
2311 |
200600633 |
1220488 |
1986 |
24128 |
2026-08-12T13:50:09.821000Z |
play_count |
200600633 |
LOCAL |
1 |
2334 |
1444441 |
21626 |
108 |
360 |
2026-08-12T13:54:35.323000Z |
play_count |
1444441 |
LOCAL |
1 |
2336 |
15300 |
132 |
13 |
1 |
2026-08-12T13:54:35.323000Z |
play_count |
15300 |
LOCAL |
1 |
2337 |
363748 |
8580 |
72 |
108 |
2026-08-12T13:56:21.365000Z |
play_count |
363748 |
LOCAL |
1 |
2338 |
931024 |
9455 |
55 |
203 |
2026-08-12T13:54:35.323000Z |
play_count |
931024 |
LOCAL |
1 |
2339 |
100886 |
185 |
481 |
17 |
2026-08-12T13:54:35.323000Z |
play_count |
100886 |
LOCAL |
1 |
2340 |
2494236 |
29412 |
85 |
410 |
2026-08-12T13:54:35.323000Z |
play_count |
2494236 |
LOCAL |
1 |
2341 |
408741 |
13651 |
85 |
306 |
2026-08-12T13:56:21.365000Z |
play_count |
408741 |
LOCAL |
1 |
2343 |
3514198 |
81258 |
252 |
773 |
2026-08-12T13:54:35.323000Z |
play_count |
3514198 |
LOCAL |
1 |
2344 |
433573 |
16323 |
227 |
363 |
2026-08-12T13:54:35.323000Z |
play_count |
433573 |
LOCAL |
1 |
2345 |
494321 |
11690 |
958 |
146 |
2026-08-12T13:54:35.323000Z |
play_count |
494321 |
LOCAL |
1 |
2346 |
12667770 |
316334 |
2423 |
4719 |
2026-08-12T13:54:35.323000Z |
play_count |
12667770 |
LOCAL |
1 |
2348 |
978010 |
17352 |
360 |
308 |
2026-08-12T13:54:35.323000Z |
play_count |
978010 |
LOCAL |
1 |
2349 |
1083151 |
6954 |
41 |
137 |
2026-08-12T13:54:35.323000Z |
play_count |
1083151 |
LOCAL |
1 |
2350 |
440419 |
4113 |
28 |
84 |
2026-08-12T13:54:35.323000Z |
play_count |
440419 |
LOCAL |
1 |
2352 |
46571025 |
260440 |
325 |
9009 |
2026-08-14T07:46:10.873000Z |
play_count |
46571025 |
LOCAL |
1 |
2353 |
2191112 |
84658 |
766 |
2371 |
2026-08-12T13:55:50Z |
play_count |
2191112 |
SERVER |
1 |
2355 |
1111331 |
31758 |
555 |
291 |
2026-08-12T13:55:25.749000Z |
play_count |
1111331 |
LOCAL |
1 |
2357 |
2402 |
111 |
3 |
1 |
2026-08-12T13:55:25.749000Z |
play_count |
2402 |
LOCAL |
1 |
2358 |
306442 |
2307 |
5 |
31 |
2026-08-12T13:55:25.749000Z |
play_count |
306442 |
LOCAL |
1 |
2360 |
142141 |
5043 |
17 |
64 |
2026-08-12T13:57:20.120000Z |
play_count |
142141 |
LOCAL |
1 |
2363 |
14694184 |
883800 |
2104 |
15610 |
2026-08-14T06:17:57.597000Z |
play_count |
14694184 |
LOCAL |
1 |
2364 |
2293298 |
3 |
135 |
6192 |
2026-08-12T13:55:25.749000Z |
play_count |
2293298 |
LOCAL |
1 |
2365 |
512253 |
13794 |
118 |
387 |
2026-08-14T07:46:10.873000Z |
play_count |
512253 |
LOCAL |
1 |
2367 |
3194921 |
10879 |
298 |
299 |
2026-08-16T12:03:28.838000Z |
play_count |
3194921 |
LOCAL |
1 |
2372 |
4039769 |
150429 |
234 |
2141 |
2026-08-14T07:46:10.873000Z |
play_count |
4039769 |
LOCAL |
1 |
2373 |
0 |
3 |
0 |
0 |
2026-08-12T13:55:50.921000Z |
play_count |
3 |
LOCAL |
0 |
2383 |
3727687 |
8187 |
53 |
736 |
2026-08-12T13:55:50Z |
play_count |
3727687 |
SERVER |
1 |
2385 |
4576849 |
124576 |
2240 |
7965 |
2026-08-12T13:55:50Z |
play_count |
4576849 |
SERVER |
1 |
2386 |
7090507 |
28551 |
5668 |
2614 |
2026-08-12T23:05:25.596000Z |
play_count |
7090507 |
LOCAL |
1 |
2388 |
23348132 |
201621 |
407 |
5255 |
2026-08-12T13:56:05.750000Z |
play_count |
23348132 |
LOCAL |
1 |
2390 |
25663690 |
236660 |
452 |
5063 |
2026-08-12T13:55:50Z |
play_count |
25663690 |
SERVER |
1 |
2391 |
7251876 |
190018 |
537 |
3509 |
2026-08-12T13:57:35Z |
play_count |
7251876 |
SERVER |
1 |
2393 |
5397257 |
30413 |
1085 |
1390 |
2026-08-12T13:56:05.750000Z |
play_count |
5397257 |
LOCAL |
1 |
2422 |
841035 |
46616 |
441 |
637 |
2026-08-12T13:56:21.365000Z |
play_count |
841035 |
LOCAL |
1 |
2424 |
0 |
141 |
12 |
1 |
2026-08-12T13:56:21.365000Z |
play_count |
153 |
LOCAL |
0 |
2425 |
53478248 |
2481402 |
9344 |
42385 |
2026-08-12T14:01:02.727000Z |
play_count |
53478248 |
LOCAL |
1 |
2438 |
1040172 |
34955 |
166 |
890 |
2026-08-12T13:56:21.365000Z |
play_count |
1040172 |
LOCAL |
1 |
2440 |
2727444 |
31126 |
435 |
949 |
2026-08-12T13:56:21.365000Z |
play_count |
2727444 |
LOCAL |
1 |
2443 |
252625 |
2144 |
14 |
59 |
2026-08-13T11:28:58.131000Z |
play_count |
252625 |
LOCAL |
1 |
2444 |
115673896 |
4457293 |
14204 |
58171 |
2026-08-12T13:56:21.365000Z |
play_count |
115673896 |
LOCAL |
1 |
2445 |
19668793 |
326228 |
1031 |
3596 |
2026-08-12T13:56:21.365000Z |
play_count |
19668793 |
LOCAL |
1 |
2469 |
962237 |
7251 |
3326 |
310 |
2026-08-12T13:57:20.120000Z |
play_count |
962237 |
LOCAL |
1 |
2470 |
3954767 |
73842 |
431 |
1294 |
2026-08-12T13:57:20.120000Z |
play_count |
3954767 |
LOCAL |
1 |
2474 |
579993 |
4909 |
364 |
171 |
2026-08-12T23:05:25.596000Z |
play_count |
579993 |
LOCAL |
1 |
2476 |
39706851 |
1182310 |
5379 |
22657 |
2026-08-12T13:57:20.120000Z |
play_count |
39706851 |
LOCAL |
1 |
2478 |
10942033 |
45775 |
111 |
2262 |
2026-08-12T13:57:20.120000Z |
play_count |
10942033 |
LOCAL |
1 |
2479 |
16620049 |
400990 |
987 |
3704 |
2026-08-12T13:57:20.120000Z |
play_count |
16620049 |
LOCAL |
1 |
2480 |
5747063 |
62004 |
768 |
3684 |
2026-08-12T13:57:20.120000Z |
play_count |
5747063 |
LOCAL |
1 |
2481 |
1981182 |
20841 |
1308 |
401 |
2026-08-12T13:57:20.120000Z |
play_count |
1981182 |
LOCAL |
1 |
2500 |
0 |
38 |
6 |
1 |
2026-08-12T13:57:35.663000Z |
play_count |
44 |
LOCAL |
0 |
2510 |
84546 |
3 |
667 |
5 |
2026-08-12T13:57:35.663000Z |
play_count |
84546 |
LOCAL |
1 |
2511 |
292745 |
12547 |
62 |
149 |
2026-08-12T13:57:35.663000Z |
play_count |
292745 |
LOCAL |
1 |
2512 |
10256464 |
46579 |
179 |
926 |
2026-08-12T13:57:35.663000Z |
play_count |
10256464 |
LOCAL |
1 |
2513 |
11975019 |
257257 |
177 |
3169 |
2026-08-12T13:57:35.663000Z |
play_count |
11975019 |
LOCAL |
1 |
2518 |
7259680 |
1307815 |
8730 |
7726 |
2026-08-12T13:57:35.663000Z |
play_count |
7259680 |
LOCAL |
1 |
2519 |
1289003 |
12031 |
1063 |
378 |
2026-08-13T11:28:58.131000Z |
play_count |
1289003 |
LOCAL |
1 |
2523 |
6936442 |
83071 |
34 |
740 |
2026-08-12T13:57:35.663000Z |
play_count |
6936442 |
LOCAL |
1 |
2526 |
472141 |
10048 |
282 |
172 |
2026-08-14T07:02:44.707000Z |
play_count |
472141 |
LOCAL |
1 |
2530 |
4393230 |
12391 |
1 |
453 |
2026-08-12T22:30:13.695000Z |
play_count |
4393230 |
LOCAL |
1 |
2531 |
29574168 |
189625 |
573 |
6987 |
2026-08-12T13:57:35.663000Z |
play_count |
29574168 |
LOCAL |
1 |
2559 |
22464492 |
1240811 |
1541 |
34508 |
2026-08-12T14:22:44Z |
play_count |
22464492 |
SERVER |
1 |
2560 |
10307188 |
16218 |
13 |
228 |
2026-08-12T14:01:02.727000Z |
play_count |
10307188 |
LOCAL |
1 |
2561 |
541206 |
5510 |
110 |
126 |
2026-08-14T07:02:44.707000Z |
play_count |
541206 |
LOCAL |
1 |
2563 |
14464549 |
370265 |
763 |
5083 |
2026-08-12T14:01:02.727000Z |
play_count |
14464549 |
LOCAL |
1 |
2565 |
653219 |
9716 |
130 |
121 |
2026-08-12T14:01:02.727000Z |
play_count |
653219 |
LOCAL |
1 |
2567 |
4610049 |
5123 |
14 |
101 |
2026-08-12T14:01:02.727000Z |
play_count |
4610049 |
LOCAL |
1 |
2568 |
2159413 |
31241 |
194 |
627 |
2026-08-12T14:01:02.727000Z |
play_count |
2159413 |
LOCAL |
1 |
2569 |
5283538 |
17909 |
10 |
195 |
2026-08-12T14:01:02.727000Z |
play_count |
5283538 |
LOCAL |
1 |
2571 |
2704335 |
166630 |
2971 |
3083 |
2026-08-12T14:01:02.727000Z |
play_count |
2704335 |
LOCAL |
1 |
2573 |
23024 |
292 |
22 |
0 |
2026-08-12T14:01:02.727000Z |
play_count |
23024 |
LOCAL |
1 |
2574 |
4438160 |
70275 |
364 |
1293 |
2026-08-12T14:01:02.727000Z |
play_count |
4438160 |
LOCAL |
1 |
2575 |
46855391 |
555730 |
813 |
13151 |
2026-08-15T04:41:59.380000Z |
play_count |
46855391 |
LOCAL |
1 |
2577 |
20200 |
40 |
13 |
2 |
2026-08-12T14:01:02.727000Z |
play_count |
20200 |
LOCAL |
1 |
2581 |
17777 |
246 |
4 |
8 |
2026-08-12T14:24:10.919Z |
play_count |
17777 |
SERVER |
1 |
2583 |
18403 |
213 |
1 |
4 |
2026-08-12T14:22:44Z |
play_count |
18403 |
SERVER |
1 |
2584 |
4184 |
92 |
1 |
3 |
2026-08-12T14:22:44Z |
play_count |
4184 |
SERVER |
1 |
2585 |
5837 |
76 |
1 |
2 |
2026-08-12T14:22:44Z |
play_count |
5837 |
SERVER |
1 |
2586 |
52511 |
1012 |
7 |
28 |
2026-08-12T14:22:44Z |
play_count |
52511 |
SERVER |
1 |
2587 |
10420 |
145 |
1 |
1 |
2026-08-12T14:22:44Z |
play_count |
10420 |
SERVER |
1 |
2595 |
27185 |
785 |
4 |
12 |
2026-08-12T15:27:51.425000Z |
play_count |
27185 |
LOCAL |
1 |
2636 |
249100662 |
14727416 |
70131 |
324736 |
2026-08-12T22:30:13.695000Z |
play_count |
249100662 |
LOCAL |
1 |
2638 |
247066 |
7934 |
213 |
102 |
2026-08-12T22:30:13.695000Z |
play_count |
247066 |
LOCAL |
1 |
2640 |
4875979 |
47536 |
359 |
694 |
2026-08-12T22:29:54.255000Z |
play_count |
4875979 |
LOCAL |
1 |
2641 |
1309179 |
73042 |
596 |
996 |
2026-08-12T22:29:54.255000Z |
play_count |
1309179 |
LOCAL |
1 |
2642 |
101387824 |
7132888 |
27592 |
206368 |
2026-08-12T22:30:13.695000Z |
play_count |
101387824 |
LOCAL |
1 |
2650 |
247998620 |
10259983 |
11161 |
169099 |
2026-08-16T13:09:52.579000Z |
play_count |
247998620 |
LOCAL |
1 |
2652 |
19150612 |
46019 |
208 |
1580 |
2026-08-16T12:03:28.838000Z |
play_count |
19150612 |
LOCAL |
1 |
2654 |
1488630 |
116985 |
285 |
2878 |
2026-08-12T22:29:54.255000Z |
play_count |
1488630 |
LOCAL |
1 |
2696 |
2225086 |
8845 |
166 |
336 |
2026-08-12T23:05:03.584000Z |
play_count |
2225086 |
LOCAL |
1 |
2706 |
3970 |
31 |
35 |
5 |
2026-08-12T23:05:03.584000Z |
play_count |
3970 |
LOCAL |
1 |
2707 |
18526860 |
897967 |
1322 |
13106 |
2026-08-12T23:05:03.584000Z |
play_count |
18526860 |
LOCAL |
1 |
2709 |
3500 |
134 |
118 |
0 |
2026-08-12T23:05:03.584000Z |
play_count |
3500 |
LOCAL |
1 |
2711 |
15274223 |
205897 |
237 |
1976 |
2026-08-12T23:05:03.584000Z |
play_count |
15274223 |
LOCAL |
1 |