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 |
|---|---|---|---|---|---|---|---|---|---|---|
201 |
201 |
721908 |
1925 |
480 |
78 |
2026-08-10T09:46:27.138000Z |
play_count |
721908 |
LOCAL |
1 |
202 |
202 |
9971 |
165 |
43 |
7 |
2026-08-10T09:46:27.138000Z |
play_count |
9971 |
LOCAL |
1 |
203 |
203 |
20670 |
179 |
69 |
6 |
2026-08-10T09:46:27.138000Z |
play_count |
20670 |
LOCAL |
1 |
204 |
204 |
8154 |
154 |
38 |
6 |
2026-08-10T09:46:27.138000Z |
play_count |
8154 |
LOCAL |
1 |
205 |
205 |
16688 |
136 |
24 |
5 |
2026-08-10T09:46:27.138000Z |
play_count |
16688 |
LOCAL |
1 |
206 |
206 |
5017 |
158 |
44 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
5017 |
LOCAL |
1 |
207 |
207 |
20443 |
206 |
76 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
20443 |
LOCAL |
1 |
208 |
208 |
10443 |
118 |
33 |
4 |
2026-08-10T09:46:27.138000Z |
play_count |
10443 |
LOCAL |
1 |
209 |
209 |
7600 |
191 |
136 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
7600 |
LOCAL |
1 |
210 |
210 |
9210 |
203 |
185 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
9210 |
LOCAL |
1 |
211 |
211 |
5211 |
166 |
100 |
6 |
2026-08-10T09:46:27.138000Z |
play_count |
5211 |
LOCAL |
1 |
212 |
212 |
6025 |
216 |
30 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
6025 |
LOCAL |
1 |
213 |
213 |
17648 |
364 |
589 |
20 |
2026-08-10T09:46:27.138000Z |
play_count |
17648 |
LOCAL |
1 |
214 |
214 |
5246 |
146 |
53 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
5246 |
LOCAL |
1 |
215 |
215 |
24953 |
297 |
387 |
14 |
2026-08-10T09:46:27.138000Z |
play_count |
24953 |
LOCAL |
1 |
216 |
216 |
8669 |
162 |
88 |
12 |
2026-08-10T09:46:27.138000Z |
play_count |
8669 |
LOCAL |
1 |
217 |
217 |
32293 |
371 |
613 |
12 |
2026-08-10T09:46:27.138000Z |
play_count |
32293 |
LOCAL |
1 |
218 |
218 |
5661 |
172 |
33 |
11 |
2026-08-10T09:46:27.138000Z |
play_count |
5661 |
LOCAL |
1 |
219 |
219 |
5655 |
152 |
42 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
5655 |
LOCAL |
1 |
220 |
220 |
8231 |
162 |
67 |
9 |
2026-08-10T09:46:27.138000Z |
play_count |
8231 |
LOCAL |
1 |
221 |
221 |
10827 |
94 |
34 |
3 |
2026-08-10T09:46:27.138000Z |
play_count |
10827 |
LOCAL |
1 |
222 |
222 |
63520 |
864 |
113 |
19 |
2026-08-10T09:46:27.138000Z |
play_count |
63520 |
LOCAL |
1 |
223 |
223 |
70657 |
913 |
353 |
62 |
2026-08-10T09:46:27.138000Z |
play_count |
70657 |
LOCAL |
1 |
224 |
224 |
13257 |
223 |
148 |
10 |
2026-08-10T09:46:27.138000Z |
play_count |
13257 |
LOCAL |
1 |
225 |
225 |
12070 |
202 |
116 |
5 |
2026-08-10T09:46:27.138000Z |
play_count |
12070 |
LOCAL |
1 |
226 |
226 |
11317 |
87 |
39 |
5 |
2026-08-10T09:46:27.138000Z |
play_count |
11317 |
LOCAL |
1 |
227 |
227 |
20864 |
140 |
34 |
2 |
2026-08-10T09:46:27.138000Z |
play_count |
20864 |
LOCAL |
1 |
228 |
228 |
176562 |
645 |
142 |
34 |
2026-08-10T09:46:27.138000Z |
play_count |
176562 |
LOCAL |
1 |
229 |
18 |
36276 |
263 |
80 |
10 |
2026-08-10T09:47:35.587000Z |
play_count |
36276 |
LOCAL |
1 |
230 |
32 |
125126 |
1163 |
3387 |
122 |
2026-08-10T09:47:35.587000Z |
play_count |
125126 |
LOCAL |
1 |
231 |
25 |
421458 |
3555 |
1920 |
371 |
2026-08-10T09:47:35.587000Z |
play_count |
421458 |
LOCAL |
1 |
232 |
232 |
74665 |
1344 |
5524 |
36 |
2026-08-10T09:47:35.587000Z |
play_count |
74665 |
LOCAL |
1 |
233 |
233 |
34764 |
309 |
205 |
16 |
2026-08-10T09:47:35.587000Z |
play_count |
34764 |
LOCAL |
1 |
234 |
234 |
1733083 |
30403 |
248 |
418 |
2026-08-10T09:47:35.587000Z |
play_count |
1733083 |
LOCAL |
1 |
235 |
235 |
176071 |
1010 |
1343 |
167 |
2026-08-10T09:47:35.587000Z |
play_count |
176071 |
LOCAL |
1 |
236 |
236 |
3576244 |
49815 |
291 |
565 |
2026-08-10T09:47:35.587000Z |
play_count |
3576244 |
LOCAL |
1 |
237 |
237 |
0 |
46666 |
464 |
758 |
2026-08-10T09:48:25.544000Z |
play_count |
46666 |
LOCAL |
0 |
238 |
238 |
0 |
887 |
494 |
51 |
2026-08-10T09:48:30.348000Z |
play_count |
887 |
LOCAL |
0 |
239 |
2 |
4613676 |
18994 |
7102 |
117 |
2026-08-10T09:49:09.190000Z |
play_count |
4613676 |
LOCAL |
1 |
240 |
4 |
36040 |
403 |
437 |
32 |
2026-08-10T09:49:09.190000Z |
play_count |
36040 |
LOCAL |
1 |
241 |
3 |
65926 |
1591 |
164 |
16 |
2026-08-10T09:49:09.992000Z |
play_count |
65926 |
LOCAL |
1 |
242 |
5 |
19075 |
145 |
21 |
6 |
2026-08-10T09:49:09.992000Z |
play_count |
19075 |
LOCAL |
1 |
243 |
6 |
5804 |
136 |
60 |
9 |
2026-08-10T09:49:09.992000Z |
play_count |
5804 |
LOCAL |
1 |
244 |
7 |
10373 |
261 |
83 |
13 |
2026-08-10T09:49:09.992000Z |
play_count |
10373 |
LOCAL |
1 |
245 |
8 |
62967 |
685 |
332 |
56 |
2026-08-10T09:49:09.992000Z |
play_count |
62967 |
LOCAL |
1 |
246 |
9 |
14750 |
177 |
22 |
7 |
2026-08-10T09:49:09.992000Z |
play_count |
14750 |
LOCAL |
1 |
247 |
10 |
201540 |
1063 |
650 |
142 |
2026-08-10T09:49:12.133000Z |
play_count |
201540 |
LOCAL |
1 |
248 |
12 |
7740 |
196 |
105 |
14 |
2026-08-10T09:49:27.728000Z |
play_count |
7740 |
LOCAL |
1 |
249 |
15 |
11197 |
179 |
76 |
12 |
2026-08-10T09:49:27.728000Z |
play_count |
11197 |
LOCAL |
1 |
250 |
11 |
18850 |
311 |
107 |
18 |
2026-08-10T09:49:28.586000Z |
play_count |
18850 |
LOCAL |
1 |
251 |
13 |
27738 |
515 |
1213 |
25 |
2026-08-10T09:49:28.586000Z |
play_count |
27738 |
LOCAL |
1 |
252 |
14 |
75551 |
816 |
574 |
115 |
2026-08-10T09:49:28.586000Z |
play_count |
75551 |
LOCAL |
1 |
253 |
16 |
17619 |
178 |
106 |
10 |
2026-08-10T09:49:28.586000Z |
play_count |
17619 |
LOCAL |
1 |
254 |
17 |
26714 |
345 |
1146 |
15 |
2026-08-10T09:49:28.586000Z |
play_count |
26714 |
LOCAL |
1 |
255 |
1 |
54001 |
1150 |
197 |
22 |
2026-08-10T10:50:18.631000Z |
play_count |
54001 |
LOCAL |
1 |
256 |
4 |
38028 |
422 |
466 |
32 |
2026-08-10T10:51:43.821000Z |
play_count |
38028 |
LOCAL |
1 |
257 |
9 |
14776 |
177 |
22 |
7 |
2026-08-10T10:51:43.821000Z |
play_count |
14776 |
LOCAL |
1 |
258 |
10 |
201698 |
1064 |
652 |
141 |
2026-08-10T10:51:43.821000Z |
play_count |
201698 |
LOCAL |
1 |
259 |
1 |
54003 |
1150 |
197 |
22 |
2026-08-10T10:51:44.829000Z |
play_count |
54003 |
LOCAL |
1 |
260 |
2 |
4613687 |
18994 |
7102 |
117 |
2026-08-10T10:51:44.829000Z |
play_count |
4613687 |
LOCAL |
1 |
261 |
3 |
65936 |
1592 |
164 |
16 |
2026-08-10T10:51:44.829000Z |
play_count |
65936 |
LOCAL |
1 |
262 |
5 |
19169 |
146 |
21 |
6 |
2026-08-10T10:51:44.829000Z |
play_count |
19169 |
LOCAL |
1 |
263 |
6 |
5816 |
136 |
60 |
9 |
2026-08-10T10:51:44.829000Z |
play_count |
5816 |
LOCAL |
1 |
264 |
7 |
10406 |
261 |
83 |
13 |
2026-08-10T10:51:44.829000Z |
play_count |
10406 |
LOCAL |
1 |
265 |
8 |
63297 |
687 |
332 |
56 |
2026-08-10T10:51:44.829000Z |
play_count |
63297 |
LOCAL |
1 |
266 |
2 |
4613673 |
18994 |
7102 |
117 |
2026-08-10T10:54:57.199000Z |
play_count |
4613673 |
LOCAL |
1 |
267 |
2 |
4613687 |
18994 |
7102 |
117 |
2026-08-10T11:00:28.771000Z |
play_count |
4613687 |
LOCAL |
1 |
268 |
1 |
54001 |
1150 |
197 |
22 |
2026-08-10T15:06:07.456000Z |
play_count |
54001 |
LOCAL |
1 |
269 |
2 |
4613676 |
18994 |
7102 |
117 |
2026-08-10T15:06:07.456000Z |
play_count |
4613676 |
LOCAL |
1 |
270 |
3 |
65926 |
1591 |
164 |
16 |
2026-08-10T15:06:07.456000Z |
play_count |
65926 |
LOCAL |
1 |
271 |
4 |
36040 |
403 |
437 |
32 |
2026-08-10T15:06:07.456000Z |
play_count |
36040 |
LOCAL |
1 |
272 |
5 |
19075 |
145 |
21 |
6 |
2026-08-10T15:06:07.456000Z |
play_count |
19075 |
LOCAL |
1 |
273 |
6 |
5804 |
136 |
60 |
9 |
2026-08-10T15:06:07.456000Z |
play_count |
5804 |
LOCAL |
1 |
274 |
7 |
10373 |
261 |
83 |
13 |
2026-08-10T15:06:07.456000Z |
play_count |
10373 |
LOCAL |
1 |
275 |
8 |
62967 |
685 |
332 |
56 |
2026-08-10T15:06:07.456000Z |
play_count |
62967 |
LOCAL |
1 |
276 |
9 |
14750 |
177 |
22 |
7 |
2026-08-10T15:06:07.456000Z |
play_count |
14750 |
LOCAL |
1 |
277 |
10 |
201540 |
1063 |
650 |
142 |
2026-08-10T15:06:07.456000Z |
play_count |
201540 |
LOCAL |
1 |
278 |
280 |
0 |
72 |
0 |
0 |
2026-08-10T15:06:36.305000Z |
play_count |
72 |
LOCAL |
0 |
279 |
281 |
0 |
3 |
11 |
0 |
2026-08-10T15:06:36.305000Z |
play_count |
3 |
LOCAL |
0 |
280 |
282 |
0 |
621 |
3090 |
47 |
2026-08-10T15:06:44.075000Z |
play_count |
621 |
LOCAL |
0 |
281 |
283 |
0 |
2651 |
7999 |
452 |
2026-08-10T15:06:44.075000Z |
play_count |
2651 |
LOCAL |
0 |
282 |
284 |
0 |
5440 |
10996 |
1189 |
2026-08-10T15:06:48.547000Z |
play_count |
5440 |
LOCAL |
0 |
283 |
232 |
74665 |
1596 |
6508 |
41 |
2026-08-10T15:06:48.547000Z |
play_count |
1596 |
LOCAL |
1 |
284 |
286 |
0 |
1844 |
1516 |
251 |
2026-08-10T15:06:48.547000Z |
play_count |
1844 |
LOCAL |
0 |
285 |
287 |
0 |
9951 |
1352 |
1391 |
2026-08-10T15:06:48.547000Z |
play_count |
9951 |
LOCAL |
0 |
286 |
288 |
0 |
64 |
8 |
4 |
2026-08-10T15:06:48.547000Z |
play_count |
64 |
LOCAL |
0 |
287 |
289 |
0 |
926 |
1522 |
97 |
2026-08-10T15:06:48.547000Z |
play_count |
926 |
LOCAL |
0 |
288 |
290 |
48507170 |
1590070 |
1672 |
33164 |
2026-08-10T15:06:50.897000Z |
play_count |
48507170 |
LOCAL |
1 |
289 |
291 |
69601 |
818 |
335 |
15 |
2026-08-10T15:06:50.897000Z |
play_count |
69601 |
LOCAL |
1 |
290 |
292 |
550560 |
13375 |
23 |
197 |
2026-08-10T15:06:50.897000Z |
play_count |
550560 |
LOCAL |
1 |
291 |
293 |
12250 |
83 |
3 |
4 |
2026-08-10T15:06:50.897000Z |
play_count |
12250 |
LOCAL |
1 |
292 |
294 |
2445593 |
26147 |
511 |
274 |
2026-08-10T15:06:50.897000Z |
play_count |
2445593 |
LOCAL |
1 |
293 |
295 |
0 |
3 |
0 |
0 |
2026-08-10T15:06:50.897000Z |
play_count |
3 |
LOCAL |
0 |
294 |
296 |
32981978 |
393780 |
360 |
5665 |
2026-08-10T15:06:50.897000Z |
play_count |
32981978 |
LOCAL |
1 |
295 |
297 |
2293 |
3 |
2 |
0 |
2026-08-10T15:06:50.897000Z |
play_count |
2293 |
LOCAL |
1 |
296 |
298 |
440656283 |
6592320 |
15616 |
87734 |
2026-08-10T15:06:50.897000Z |
play_count |
440656283 |
LOCAL |
1 |
297 |
299 |
1535485 |
11818 |
10 |
187 |
2026-08-10T15:06:50.897000Z |
play_count |
1535485 |
LOCAL |
1 |
298 |
300 |
2000 |
288 |
4 |
0 |
2026-08-10T15:06:50.897000Z |
play_count |
2000 |
LOCAL |
1 |
299 |
301 |
916090 |
29906 |
468 |
1084 |
2026-08-10T15:06:50.897000Z |
play_count |
916090 |
LOCAL |
1 |
300 |
302 |
305265008 |
5699089 |
62839 |
101858 |
2026-08-10T15:06:50.897000Z |
play_count |
305265008 |
LOCAL |
1 |