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 |
|---|---|---|---|---|---|---|---|---|---|---|
301 |
303 |
770822 |
13648 |
179 |
319 |
2026-08-10T15:06:50.897000Z |
play_count |
770822 |
LOCAL |
1 |
302 |
304 |
47121445 |
550683 |
504 |
13210 |
2026-08-10T15:06:50.897000Z |
play_count |
47121445 |
LOCAL |
1 |
303 |
305 |
49983830 |
363132 |
1797 |
5206 |
2026-08-10T15:06:50.897000Z |
play_count |
49983830 |
LOCAL |
1 |
304 |
306 |
1846045 |
12116 |
140 |
271 |
2026-08-10T15:06:50.897000Z |
play_count |
1846045 |
LOCAL |
1 |
305 |
307 |
1881157 |
31090 |
139 |
482 |
2026-08-10T15:06:50.897000Z |
play_count |
1881157 |
LOCAL |
1 |
306 |
308 |
8109545 |
259059 |
225 |
5798 |
2026-08-10T15:06:50.897000Z |
play_count |
8109545 |
LOCAL |
1 |
307 |
309 |
1626 |
468 |
11 |
0 |
2026-08-10T15:06:50.897000Z |
play_count |
1626 |
LOCAL |
1 |
308 |
282 |
102944 |
621 |
3090 |
47 |
2026-08-10T15:06:58.254000Z |
play_count |
102944 |
LOCAL |
1 |
309 |
313 |
600680 |
6326 |
8038 |
1200 |
2026-08-10T15:09:38.779000Z |
play_count |
600680 |
LOCAL |
1 |
310 |
314 |
13237 |
58 |
72 |
7 |
2026-08-10T15:09:38.779000Z |
play_count |
13237 |
LOCAL |
1 |
311 |
315 |
25993 |
257 |
468 |
10 |
2026-08-10T15:09:38.779000Z |
play_count |
25993 |
LOCAL |
1 |
312 |
316 |
22626 |
283 |
778 |
14 |
2026-08-10T15:09:38.779000Z |
play_count |
22626 |
LOCAL |
1 |
313 |
317 |
436738 |
4760 |
2867 |
670 |
2026-08-10T15:09:40.488000Z |
play_count |
436738 |
LOCAL |
1 |
314 |
286 |
193367 |
1844 |
1516 |
251 |
2026-08-10T15:09:40.488000Z |
play_count |
193367 |
LOCAL |
1 |
315 |
319 |
13670 |
121 |
123 |
9 |
2026-08-10T15:09:40.488000Z |
play_count |
13670 |
LOCAL |
1 |
316 |
320 |
16385 |
138 |
136 |
10 |
2026-08-10T15:09:40.488000Z |
play_count |
16385 |
LOCAL |
1 |
317 |
321 |
6250 |
44 |
46 |
1 |
2026-08-10T15:09:40.488000Z |
play_count |
6250 |
LOCAL |
1 |
318 |
322 |
7185 |
66 |
194 |
2 |
2026-08-10T15:09:40.488000Z |
play_count |
7185 |
LOCAL |
1 |
319 |
323 |
0 |
868 |
18 |
64 |
2026-08-11T09:45:33.256000Z |
play_count |
868 |
LOCAL |
0 |
320 |
324 |
0 |
12579 |
552 |
1034 |
2026-08-11T09:45:33.256000Z |
play_count |
12579 |
LOCAL |
0 |
321 |
325 |
0 |
542 |
2035 |
37 |
2026-08-11T09:45:33.256000Z |
play_count |
542 |
LOCAL |
0 |
322 |
330 |
0 |
320 |
15 |
10 |
2026-08-11T09:45:36.661000Z |
play_count |
320 |
LOCAL |
0 |
323 |
331 |
0 |
319 |
11 |
9 |
2026-08-11T09:45:36.661000Z |
play_count |
319 |
LOCAL |
0 |
324 |
332 |
0 |
161 |
9 |
2 |
2026-08-11T09:45:36.661000Z |
play_count |
161 |
LOCAL |
0 |
325 |
333 |
5548 |
161 |
7 |
8 |
2026-08-11T09:45:36.661000Z |
play_count |
5548 |
LOCAL |
1 |
326 |
334 |
0 |
640 |
19 |
32 |
2026-08-11T09:45:36.661000Z |
play_count |
640 |
LOCAL |
0 |
327 |
335 |
0 |
1330 |
67 |
49 |
2026-08-11T09:45:36.661000Z |
play_count |
1330 |
LOCAL |
0 |
328 |
336 |
0 |
5281 |
152 |
441 |
2026-08-11T09:45:36.661000Z |
play_count |
5281 |
LOCAL |
0 |
329 |
337 |
0 |
770 |
29 |
30 |
2026-08-11T09:45:36.661000Z |
play_count |
770 |
LOCAL |
0 |
330 |
338 |
0 |
652 |
22 |
24 |
2026-08-11T09:45:36.661000Z |
play_count |
652 |
LOCAL |
0 |
331 |
339 |
0 |
525 |
18 |
25 |
2026-08-11T09:45:36.661000Z |
play_count |
525 |
LOCAL |
0 |
332 |
340 |
0 |
2104 |
62 |
79 |
2026-08-11T09:45:36.661000Z |
play_count |
2104 |
LOCAL |
0 |
333 |
353 |
0 |
2333 |
40 |
130 |
2026-08-11T09:45:43.954000Z |
play_count |
2333 |
LOCAL |
0 |
334 |
354 |
0 |
2242 |
83 |
175 |
2026-08-11T09:45:43.954000Z |
play_count |
2242 |
LOCAL |
0 |
335 |
355 |
0 |
2660 |
148 |
232 |
2026-08-11T09:45:43.954000Z |
play_count |
2660 |
LOCAL |
0 |
336 |
356 |
28900 |
2712 |
61 |
145 |
2026-08-11T09:45:43.954000Z |
play_count |
28900 |
LOCAL |
1 |
337 |
357 |
0 |
711 |
28 |
29 |
2026-08-11T09:45:43.954000Z |
play_count |
711 |
LOCAL |
0 |
338 |
358 |
0 |
1039 |
65 |
57 |
2026-08-11T09:45:43.954000Z |
play_count |
1039 |
LOCAL |
0 |
339 |
359 |
7153 |
70 |
0 |
1 |
2026-08-11T09:45:43.954000Z |
play_count |
7153 |
LOCAL |
1 |
340 |
360 |
0 |
192 |
5 |
0 |
2026-08-11T09:45:43.954000Z |
play_count |
192 |
LOCAL |
0 |
341 |
361 |
0 |
382 |
7 |
7 |
2026-08-11T09:45:43.954000Z |
play_count |
382 |
LOCAL |
0 |
342 |
362 |
8133 |
63 |
0 |
2 |
2026-08-11T09:45:43.954000Z |
play_count |
8133 |
LOCAL |
1 |
343 |
363 |
0 |
195 |
7 |
2 |
2026-08-11T09:45:43.954000Z |
play_count |
195 |
LOCAL |
0 |
344 |
364 |
0 |
122 |
0 |
1 |
2026-08-11T09:45:43.954000Z |
play_count |
122 |
LOCAL |
0 |
345 |
377 |
0 |
138 |
2 |
1 |
2026-08-11T09:45:51.718000Z |
play_count |
138 |
LOCAL |
0 |
346 |
378 |
0 |
396 |
6 |
5 |
2026-08-11T09:45:51.718000Z |
play_count |
396 |
LOCAL |
0 |
347 |
379 |
0 |
1990 |
35 |
80 |
2026-08-11T09:45:51.718000Z |
play_count |
1990 |
LOCAL |
0 |
348 |
380 |
0 |
6683 |
204 |
311 |
2026-08-11T09:45:51.718000Z |
play_count |
6683 |
LOCAL |
0 |
349 |
381 |
0 |
954 |
14 |
118 |
2026-08-11T09:45:51.718000Z |
play_count |
954 |
LOCAL |
0 |
350 |
382 |
17904 |
649 |
83 |
34 |
2026-08-11T09:45:51.718000Z |
play_count |
17904 |
LOCAL |
1 |
351 |
383 |
0 |
2570 |
62 |
108 |
2026-08-11T09:45:51.718000Z |
play_count |
2570 |
LOCAL |
0 |
352 |
384 |
0 |
982 |
19 |
56 |
2026-08-11T09:45:51.718000Z |
play_count |
982 |
LOCAL |
0 |
353 |
385 |
0 |
747 |
12 |
24 |
2026-08-11T09:45:51.718000Z |
play_count |
747 |
LOCAL |
0 |
354 |
386 |
0 |
547 |
12 |
15 |
2026-08-11T09:45:51.718000Z |
play_count |
547 |
LOCAL |
0 |
355 |
387 |
0 |
987 |
15 |
50 |
2026-08-11T09:45:51.718000Z |
play_count |
987 |
LOCAL |
0 |
356 |
388 |
0 |
10457 |
224 |
795 |
2026-08-11T09:45:51.718000Z |
play_count |
10457 |
LOCAL |
0 |
357 |
336 |
0 |
5283 |
152 |
441 |
2026-08-11T09:46:48Z |
play_count |
5283 |
SERVER |
0 |
358 |
340 |
0 |
2106 |
62 |
79 |
2026-08-11T09:46:48Z |
play_count |
2106 |
SERVER |
0 |
359 |
335 |
0 |
1332 |
67 |
49 |
2026-08-11T09:46:48Z |
play_count |
1332 |
SERVER |
0 |
360 |
323 |
0 |
870 |
18 |
65 |
2026-08-11T09:46:48Z |
play_count |
870 |
SERVER |
0 |
361 |
334 |
0 |
641 |
19 |
32 |
2026-08-11T09:46:48Z |
play_count |
641 |
SERVER |
0 |
362 |
330 |
0 |
322 |
15 |
10 |
2026-08-11T09:46:48Z |
play_count |
322 |
SERVER |
0 |
363 |
333 |
5554 |
161 |
7 |
8 |
2026-08-11T09:46:51Z |
play_count |
5554 |
SERVER |
1 |
364 |
356 |
28900 |
2713 |
61 |
145 |
2026-08-11T09:46:56Z |
play_count |
2713 |
SERVER |
1 |
365 |
355 |
0 |
2662 |
148 |
232 |
2026-08-11T09:46:56Z |
play_count |
2662 |
SERVER |
0 |
366 |
356 |
28900 |
2712 |
61 |
145 |
2026-08-11T09:49:49Z |
play_count |
28900 |
SERVER |
1 |
367 |
333 |
5548 |
161 |
7 |
8 |
2026-08-11T09:49:49Z |
play_count |
5548 |
SERVER |
1 |
368 |
336 |
0 |
5281 |
152 |
441 |
2026-08-11T09:49:49Z |
play_count |
5281 |
SERVER |
0 |
369 |
355 |
0 |
2660 |
148 |
232 |
2026-08-11T09:49:49Z |
play_count |
2660 |
SERVER |
0 |
370 |
340 |
0 |
2104 |
62 |
79 |
2026-08-11T09:49:49Z |
play_count |
2104 |
SERVER |
0 |
371 |
335 |
0 |
1330 |
67 |
49 |
2026-08-11T09:49:49Z |
play_count |
1330 |
SERVER |
0 |
372 |
323 |
0 |
868 |
18 |
64 |
2026-08-11T09:49:49Z |
play_count |
868 |
SERVER |
0 |
373 |
334 |
0 |
640 |
19 |
32 |
2026-08-11T09:49:49Z |
play_count |
640 |
SERVER |
0 |
374 |
330 |
0 |
320 |
15 |
10 |
2026-08-11T09:49:49Z |
play_count |
320 |
SERVER |
0 |
375 |
356 |
28900 |
2713 |
61 |
145 |
2026-08-11T09:49:53Z |
play_count |
28900 |
SERVER |
1 |
376 |
333 |
5554 |
161 |
7 |
8 |
2026-08-11T09:49:53Z |
play_count |
5554 |
SERVER |
1 |
377 |
336 |
0 |
5283 |
152 |
441 |
2026-08-11T09:49:53Z |
play_count |
5283 |
SERVER |
0 |
378 |
355 |
0 |
2662 |
148 |
232 |
2026-08-11T09:49:53Z |
play_count |
2662 |
SERVER |
0 |
379 |
340 |
0 |
2106 |
62 |
79 |
2026-08-11T09:49:53Z |
play_count |
2106 |
SERVER |
0 |
380 |
335 |
0 |
1332 |
67 |
49 |
2026-08-11T09:49:53Z |
play_count |
1332 |
SERVER |
0 |
381 |
323 |
0 |
870 |
18 |
65 |
2026-08-11T09:49:53Z |
play_count |
870 |
SERVER |
0 |
382 |
334 |
0 |
641 |
19 |
32 |
2026-08-11T09:49:53Z |
play_count |
641 |
SERVER |
0 |
383 |
330 |
0 |
322 |
15 |
10 |
2026-08-11T09:49:53Z |
play_count |
322 |
SERVER |
0 |
384 |
356 |
28900 |
2712 |
61 |
145 |
2026-08-11T12:15:39Z |
play_count |
28900 |
SERVER |
1 |
385 |
333 |
5548 |
161 |
7 |
8 |
2026-08-11T12:15:39Z |
play_count |
5548 |
SERVER |
1 |
386 |
336 |
0 |
5281 |
152 |
441 |
2026-08-11T12:15:39Z |
play_count |
5281 |
SERVER |
0 |
387 |
355 |
0 |
2660 |
148 |
232 |
2026-08-11T12:15:39Z |
play_count |
2660 |
SERVER |
0 |
388 |
340 |
0 |
2104 |
62 |
79 |
2026-08-11T12:15:39Z |
play_count |
2104 |
SERVER |
0 |
389 |
335 |
0 |
1330 |
67 |
49 |
2026-08-11T12:15:39Z |
play_count |
1330 |
SERVER |
0 |
390 |
323 |
0 |
868 |
18 |
64 |
2026-08-11T12:15:39Z |
play_count |
868 |
SERVER |
0 |
391 |
334 |
0 |
640 |
19 |
32 |
2026-08-11T12:15:39Z |
play_count |
640 |
SERVER |
0 |
392 |
330 |
0 |
320 |
15 |
10 |
2026-08-11T12:15:39Z |
play_count |
320 |
SERVER |
0 |
393 |
356 |
28900 |
2713 |
61 |
145 |
2026-08-11T12:19:02Z |
play_count |
28900 |
SERVER |
1 |
394 |
333 |
5554 |
161 |
7 |
8 |
2026-08-11T12:19:02Z |
play_count |
5554 |
SERVER |
1 |
395 |
336 |
0 |
5283 |
152 |
441 |
2026-08-11T12:19:02Z |
play_count |
5283 |
SERVER |
0 |
396 |
355 |
0 |
2662 |
148 |
232 |
2026-08-11T12:19:02Z |
play_count |
2662 |
SERVER |
0 |
397 |
340 |
0 |
2106 |
62 |
79 |
2026-08-11T12:19:02Z |
play_count |
2106 |
SERVER |
0 |
398 |
335 |
0 |
1332 |
67 |
49 |
2026-08-11T12:19:02Z |
play_count |
1332 |
SERVER |
0 |
399 |
323 |
0 |
870 |
18 |
65 |
2026-08-11T12:19:02Z |
play_count |
870 |
SERVER |
0 |
400 |
334 |
0 |
641 |
19 |
32 |
2026-08-11T12:19:02Z |
play_count |
641 |
SERVER |
0 |