Table: post_stat_history
Schema
| cid | name | type | notnull | default | pk |
|---|---|---|---|---|---|
| 0 | id | INTEGER | 0 | 1 | |
| 1 | post_id | INTEGER | 1 | 0 | |
| 2 | views | INTEGER | 1 | 0 | 0 |
| 3 | likes | INTEGER | 1 | 0 | 0 |
| 4 | comments | INTEGER | 1 | 0 | 0 |
| 5 | reposts | INTEGER | 1 | 0 | 0 |
| 6 | collected_at | TEXT | 1 | CURRENT_TIMESTAMP | 0 |
| 7 | sort_by | TEXT | 1 | '' | 0 |
| 8 | sort_value | INTEGER | 1 | 0 | 0 |
| 9 | source_kind | TEXT | 1 | 'LOCAL' | 0 |
| 10 | views_available | INTEGER | 1 | 0 | 0 |
Data
| id | post_id | views | likes | comments | reposts | collected_at | sort_by | sort_value | source_kind | views_available |
|---|---|---|---|---|---|---|---|---|---|---|
1 |
1 |
54000 |
1150 |
197 |
22 |
2026-08-10T09:46:27.138000Z |
play_count |
54000 |
LOCAL |
1 |
2 |
2 |
4613673 |
18994 |
7102 |
117 |
2026-08-10T09:46:27.138000Z |
play_count |
4613673 |
LOCAL |
1 |
3 |
3 |
65925 |
1591 |
164 |
16 |
2026-08-10T09:46:27.138000Z |
play_count |
65925 |
LOCAL |
1 |
4 |
4 |
35357 |
395 |
429 |
32 |
2026-08-10T09:46:27.138000Z |
play_count |
35357 |
LOCAL |
1 |
5 |
5 |
19034 |
145 |
21 |
6 |
2026-08-10T09:46:27.138000Z |
play_count |
19034 |
LOCAL |
1 |
6 |
6 |
5800 |
136 |
60 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
5800 |
LOCAL |
1 |
7 |
7 |
10363 |
261 |
83 |
13 |
2026-08-10T09:46:27.138000Z |
play_count |
10363 |
LOCAL |
1 |
8 |
8 |
62847 |
683 |
330 |
56 |
2026-08-10T09:46:27.138000Z |
play_count |
62847 |
LOCAL |
1 |
9 |
9 |
14739 |
177 |
22 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
14739 |
LOCAL |
1 |
10 |
10 |
201477 |
1063 |
650 |
142 |
2026-08-10T09:46:27.138000Z |
play_count |
201477 |
LOCAL |
1 |
11 |
11 |
18848 |
311 |
107 |
18 |
2026-08-10T09:46:27.138000Z |
play_count |
18848 |
LOCAL |
1 |
12 |
12 |
7739 |
196 |
105 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
7739 |
LOCAL |
1 |
13 |
13 |
27723 |
515 |
1211 |
25 |
2026-08-10T09:46:27.138000Z |
play_count |
27723 |
LOCAL |
1 |
14 |
14 |
75543 |
816 |
574 |
115 |
2026-08-10T09:46:27.138000Z |
play_count |
75543 |
LOCAL |
1 |
15 |
15 |
11195 |
179 |
76 |
12 |
2026-08-10T09:46:27.138000Z |
play_count |
11195 |
LOCAL |
1 |
16 |
16 |
17618 |
178 |
106 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
17618 |
LOCAL |
1 |
17 |
17 |
26711 |
345 |
1146 |
15 |
2026-08-10T09:46:27.138000Z |
play_count |
26711 |
LOCAL |
1 |
18 |
18 |
36266 |
263 |
78 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
36266 |
LOCAL |
1 |
19 |
19 |
14450 |
270 |
191 |
20 |
2026-08-10T09:46:27.138000Z |
play_count |
14450 |
LOCAL |
1 |
20 |
20 |
55790 |
498 |
175 |
35 |
2026-08-10T09:46:27.138000Z |
play_count |
55790 |
LOCAL |
1 |
21 |
21 |
84486 |
888 |
136 |
58 |
2026-08-10T09:46:27.138000Z |
play_count |
84486 |
LOCAL |
1 |
22 |
22 |
32757 |
480 |
264 |
34 |
2026-08-10T09:46:27.138000Z |
play_count |
32757 |
LOCAL |
1 |
23 |
23 |
229146 |
1003 |
307 |
115 |
2026-08-10T09:46:27.138000Z |
play_count |
229146 |
LOCAL |
1 |
24 |
24 |
168972 |
2289 |
167 |
196 |
2026-08-10T09:46:27.138000Z |
play_count |
168972 |
LOCAL |
1 |
25 |
25 |
421440 |
3555 |
1920 |
371 |
2026-08-10T09:46:27.138000Z |
play_count |
421440 |
LOCAL |
1 |
26 |
26 |
21753 |
327 |
1257 |
12 |
2026-08-10T09:46:27.138000Z |
play_count |
21753 |
LOCAL |
1 |
27 |
27 |
18696 |
233 |
236 |
19 |
2026-08-10T09:46:27.138000Z |
play_count |
18696 |
LOCAL |
1 |
28 |
28 |
47117 |
179 |
96 |
6 |
2026-08-10T09:46:27.138000Z |
play_count |
47117 |
LOCAL |
1 |
29 |
29 |
11193 |
122 |
143 |
6 |
2026-08-10T09:46:27.138000Z |
play_count |
11193 |
LOCAL |
1 |
30 |
30 |
22400 |
439 |
1100 |
17 |
2026-08-10T09:46:27.138000Z |
play_count |
22400 |
LOCAL |
1 |
31 |
31 |
12187 |
106 |
28 |
8 |
2026-08-10T09:46:27.138000Z |
play_count |
12187 |
LOCAL |
1 |
32 |
32 |
125113 |
1163 |
3387 |
122 |
2026-08-10T09:46:27.138000Z |
play_count |
125113 |
LOCAL |
1 |
33 |
33 |
12599 |
154 |
28 |
8 |
2026-08-10T09:46:27.138000Z |
play_count |
12599 |
LOCAL |
1 |
34 |
34 |
11907 |
179 |
36 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
11907 |
LOCAL |
1 |
35 |
35 |
11579 |
175 |
35 |
15 |
2026-08-10T09:46:27.138000Z |
play_count |
11579 |
LOCAL |
1 |
36 |
36 |
638753 |
556 |
388 |
28 |
2026-08-10T09:46:27.138000Z |
play_count |
638753 |
LOCAL |
1 |
37 |
37 |
15052 |
173 |
25 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
15052 |
LOCAL |
1 |
38 |
38 |
45039 |
359 |
383 |
16 |
2026-08-10T09:46:27.138000Z |
play_count |
45039 |
LOCAL |
1 |
39 |
39 |
20215 |
252 |
419 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
20215 |
LOCAL |
1 |
40 |
40 |
30404 |
379 |
1079 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
30404 |
LOCAL |
1 |
41 |
41 |
231824 |
1390 |
2403 |
222 |
2026-08-10T09:46:27.138000Z |
play_count |
231824 |
LOCAL |
1 |
42 |
42 |
9817 |
127 |
52 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
9817 |
LOCAL |
1 |
43 |
43 |
183609 |
695 |
512 |
125 |
2026-08-10T09:46:27.138000Z |
play_count |
183609 |
LOCAL |
1 |
44 |
44 |
131601 |
1350 |
5176 |
162 |
2026-08-10T09:46:27.138000Z |
play_count |
131601 |
LOCAL |
1 |
45 |
45 |
9719 |
154 |
157 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
9719 |
LOCAL |
1 |
46 |
46 |
10585 |
145 |
120 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
10585 |
LOCAL |
1 |
47 |
47 |
19857 |
225 |
30 |
17 |
2026-08-10T09:46:27.138000Z |
play_count |
19857 |
LOCAL |
1 |
48 |
48 |
15303 |
107 |
60 |
8 |
2026-08-10T09:46:27.138000Z |
play_count |
15303 |
LOCAL |
1 |
49 |
49 |
29316 |
416 |
975 |
37 |
2026-08-10T09:46:27.138000Z |
play_count |
29316 |
LOCAL |
1 |
50 |
50 |
50103 |
365 |
661 |
23 |
2026-08-10T09:46:27.138000Z |
play_count |
50103 |
LOCAL |
1 |
51 |
51 |
13032 |
91 |
34 |
8 |
2026-08-10T09:46:27.138000Z |
play_count |
13032 |
LOCAL |
1 |
52 |
52 |
13913 |
144 |
157 |
8 |
2026-08-10T09:46:27.138000Z |
play_count |
13913 |
LOCAL |
1 |
53 |
53 |
14754 |
179 |
52 |
15 |
2026-08-10T09:46:27.138000Z |
play_count |
14754 |
LOCAL |
1 |
54 |
54 |
177139 |
1232 |
2733 |
102 |
2026-08-10T09:46:27.138000Z |
play_count |
177139 |
LOCAL |
1 |
55 |
55 |
21017 |
392 |
290 |
42 |
2026-08-10T09:46:27.138000Z |
play_count |
21017 |
LOCAL |
1 |
56 |
56 |
21332 |
245 |
235 |
28 |
2026-08-10T09:46:27.138000Z |
play_count |
21332 |
LOCAL |
1 |
57 |
57 |
24832 |
142 |
17 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
24832 |
LOCAL |
1 |
58 |
58 |
32535 |
236 |
24 |
5 |
2026-08-10T09:46:27.138000Z |
play_count |
32535 |
LOCAL |
1 |
59 |
59 |
19795 |
234 |
82 |
15 |
2026-08-10T09:46:27.138000Z |
play_count |
19795 |
LOCAL |
1 |
60 |
60 |
108329 |
592 |
398 |
80 |
2026-08-10T09:46:27.138000Z |
play_count |
108329 |
LOCAL |
1 |
61 |
61 |
20361 |
222 |
168 |
18 |
2026-08-10T09:46:27.138000Z |
play_count |
20361 |
LOCAL |
1 |
62 |
62 |
1102419 |
1631 |
527 |
43 |
2026-08-10T09:46:27.138000Z |
play_count |
1102419 |
LOCAL |
1 |
63 |
63 |
11248 |
173 |
53 |
17 |
2026-08-10T09:46:27.138000Z |
play_count |
11248 |
LOCAL |
1 |
64 |
64 |
6997 |
140 |
37 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
6997 |
LOCAL |
1 |
65 |
65 |
23989 |
310 |
587 |
18 |
2026-08-10T09:46:27.138000Z |
play_count |
23989 |
LOCAL |
1 |
66 |
66 |
26294 |
307 |
545 |
23 |
2026-08-10T09:46:27.138000Z |
play_count |
26294 |
LOCAL |
1 |
67 |
67 |
11921 |
167 |
32 |
17 |
2026-08-10T09:46:27.138000Z |
play_count |
11921 |
LOCAL |
1 |
68 |
68 |
32643 |
382 |
524 |
54 |
2026-08-10T09:46:27.138000Z |
play_count |
32643 |
LOCAL |
1 |
69 |
69 |
14617 |
166 |
37 |
8 |
2026-08-10T09:46:27.138000Z |
play_count |
14617 |
LOCAL |
1 |
70 |
70 |
7835 |
151 |
46 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
7835 |
LOCAL |
1 |
71 |
71 |
18942 |
326 |
606 |
30 |
2026-08-10T09:46:27.138000Z |
play_count |
18942 |
LOCAL |
1 |
72 |
72 |
17510 |
216 |
344 |
12 |
2026-08-10T09:46:27.138000Z |
play_count |
17510 |
LOCAL |
1 |
73 |
73 |
24477 |
226 |
140 |
17 |
2026-08-10T09:46:27.138000Z |
play_count |
24477 |
LOCAL |
1 |
74 |
74 |
14554 |
129 |
37 |
13 |
2026-08-10T09:46:27.138000Z |
play_count |
14554 |
LOCAL |
1 |
75 |
75 |
10145 |
216 |
376 |
13 |
2026-08-10T09:46:27.138000Z |
play_count |
10145 |
LOCAL |
1 |
76 |
76 |
8264 |
178 |
326 |
12 |
2026-08-10T09:46:27.138000Z |
play_count |
8264 |
LOCAL |
1 |
77 |
77 |
29109 |
201 |
44 |
13 |
2026-08-10T09:46:27.138000Z |
play_count |
29109 |
LOCAL |
1 |
78 |
78 |
20855 |
269 |
638 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
20855 |
LOCAL |
1 |
79 |
79 |
13688 |
156 |
105 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
13688 |
LOCAL |
1 |
80 |
80 |
31960 |
121 |
114 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
31960 |
LOCAL |
1 |
81 |
81 |
22962 |
139 |
65 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
22962 |
LOCAL |
1 |
82 |
82 |
11103 |
200 |
448 |
15 |
2026-08-10T09:46:27.138000Z |
play_count |
11103 |
LOCAL |
1 |
83 |
83 |
47669 |
423 |
467 |
50 |
2026-08-10T09:46:27.138000Z |
play_count |
47669 |
LOCAL |
1 |
84 |
84 |
10768 |
97 |
24 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
10768 |
LOCAL |
1 |
85 |
85 |
34730 |
322 |
28 |
18 |
2026-08-10T09:46:27.138000Z |
play_count |
34730 |
LOCAL |
1 |
86 |
86 |
18404 |
233 |
325 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
18404 |
LOCAL |
1 |
87 |
87 |
15138 |
165 |
28 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
15138 |
LOCAL |
1 |
88 |
88 |
17260 |
326 |
584 |
17 |
2026-08-10T09:46:27.138000Z |
play_count |
17260 |
LOCAL |
1 |
89 |
89 |
15566 |
242 |
682 |
15 |
2026-08-10T09:46:27.138000Z |
play_count |
15566 |
LOCAL |
1 |
90 |
90 |
11613 |
236 |
363 |
15 |
2026-08-10T09:46:27.138000Z |
play_count |
11613 |
LOCAL |
1 |
91 |
91 |
14512 |
183 |
51 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
14512 |
LOCAL |
1 |
92 |
92 |
18603 |
131 |
56 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
18603 |
LOCAL |
1 |
93 |
93 |
12295 |
148 |
83 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
12295 |
LOCAL |
1 |
94 |
94 |
35909 |
261 |
32 |
40 |
2026-08-10T09:46:27.138000Z |
play_count |
35909 |
LOCAL |
1 |
95 |
95 |
7470 |
124 |
70 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
7470 |
LOCAL |
1 |
96 |
96 |
13835 |
171 |
49 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
13835 |
LOCAL |
1 |
97 |
97 |
8751 |
142 |
56 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
8751 |
LOCAL |
1 |
98 |
98 |
26412 |
301 |
37 |
26 |
2026-08-10T09:46:27.138000Z |
play_count |
26412 |
LOCAL |
1 |
99 |
99 |
26632 |
227 |
40 |
22 |
2026-08-10T09:46:27.138000Z |
play_count |
26632 |
LOCAL |
1 |
100 |
100 |
10517 |
218 |
169 |
16 |
2026-08-10T09:46:27.138000Z |
play_count |
10517 |
LOCAL |
1 |