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 |
|---|---|---|---|---|---|---|---|---|---|---|
1501 |
2709 |
3500 |
134 |
118 |
0 |
2026-08-12T23:05:03.584000Z |
play_count |
3500 |
LOCAL |
1 |
1502 |
2220 |
18050226 |
483262 |
1833 |
6750 |
2026-08-12T23:05:03.584000Z |
play_count |
18050226 |
LOCAL |
1 |
1503 |
2711 |
15274223 |
205897 |
237 |
1976 |
2026-08-12T23:05:03.584000Z |
play_count |
15274223 |
LOCAL |
1 |
1504 |
2712 |
19972460 |
70945 |
274 |
4083 |
2026-08-12T23:05:03.584000Z |
play_count |
19972460 |
LOCAL |
1 |
1505 |
2112 |
2677852 |
95135 |
322 |
1790 |
2026-08-12T23:05:03.584000Z |
play_count |
2677852 |
LOCAL |
1 |
1506 |
1372 |
7216044 |
76120 |
606 |
2022 |
2026-08-12T23:05:03.584000Z |
play_count |
7216044 |
LOCAL |
1 |
1507 |
2715 |
3818 |
12 |
3 |
1 |
2026-08-12T23:05:03.584000Z |
play_count |
3818 |
LOCAL |
1 |
1508 |
1205 |
2584100 |
26533 |
3091 |
906 |
2026-08-12T23:05:03.584000Z |
play_count |
2584100 |
LOCAL |
1 |
1509 |
1585 |
2381413 |
20076 |
87 |
590 |
2026-08-12T23:05:25.596000Z |
play_count |
2381413 |
LOCAL |
1 |
1510 |
2742 |
127595 |
1732 |
21 |
41 |
2026-08-12T23:05:25.596000Z |
play_count |
127595 |
LOCAL |
1 |
1511 |
1080 |
17760969 |
589029 |
3126 |
31205 |
2026-08-12T23:05:25.596000Z |
play_count |
17760969 |
LOCAL |
1 |
1512 |
2744 |
15095730 |
166140 |
1499 |
2362 |
2026-08-12T23:05:25.596000Z |
play_count |
15095730 |
LOCAL |
1 |
1513 |
617 |
7082385 |
297251 |
159 |
3710 |
2026-08-12T23:05:25.596000Z |
play_count |
7082385 |
LOCAL |
1 |
1514 |
1141 |
4859678 |
26327 |
179 |
1644 |
2026-08-12T23:05:25.596000Z |
play_count |
4859678 |
LOCAL |
1 |
1515 |
1086 |
13662 |
625 |
136 |
67 |
2026-08-12T23:05:25.596000Z |
play_count |
13662 |
LOCAL |
1 |
1516 |
717 |
641100 |
8648 |
199 |
195 |
2026-08-12T23:05:25.596000Z |
play_count |
641100 |
LOCAL |
1 |
1517 |
2386 |
7090507 |
28551 |
5668 |
2614 |
2026-08-12T23:05:25.596000Z |
play_count |
7090507 |
LOCAL |
1 |
1518 |
2474 |
579993 |
4909 |
364 |
171 |
2026-08-12T23:05:25.596000Z |
play_count |
579993 |
LOCAL |
1 |
1519 |
2751 |
0 |
382 |
31 |
1 |
2026-08-12T23:05:25.596000Z |
play_count |
413 |
LOCAL |
0 |
1520 |
899 |
333768732 |
2068906 |
22197 |
42555 |
2026-08-12T23:05:25.596000Z |
play_count |
333768732 |
LOCAL |
1 |
1521 |
1335 |
8326622 |
57194 |
233 |
1299 |
2026-08-12T23:05:25.596000Z |
play_count |
8326622 |
LOCAL |
1 |
1522 |
1204 |
10017607 |
37311 |
58 |
740 |
2026-08-12T23:05:25.596000Z |
play_count |
10017607 |
LOCAL |
1 |
1523 |
523 |
1310383 |
23300 |
23 |
332 |
2026-08-12T23:05:25.596000Z |
play_count |
1310383 |
LOCAL |
1 |
1524 |
1516 |
873 |
13 |
4 |
0 |
2026-08-12T23:05:25.596000Z |
play_count |
873 |
LOCAL |
1 |
1525 |
2757 |
3872658 |
143333 |
15 |
1805 |
2026-08-12T23:05:25.596000Z |
play_count |
3872658 |
LOCAL |
1 |
1526 |
910 |
1036766 |
14670 |
19826 |
245 |
2026-08-12T23:05:25.596000Z |
play_count |
1036766 |
LOCAL |
1 |
1527 |
303 |
794264 |
14204 |
189 |
326 |
2026-08-12T23:05:25.596000Z |
play_count |
794264 |
LOCAL |
1 |
1528 |
1206 |
2134320 |
322569 |
3128 |
1180 |
2026-08-12T23:05:25.596000Z |
play_count |
2134320 |
LOCAL |
1 |
1529 |
711 |
1640232 |
61263 |
899 |
1256 |
2026-08-12T23:05:25.596000Z |
play_count |
1640232 |
LOCAL |
1 |
1530 |
2762 |
40402 |
454 |
266 |
11 |
2026-08-12T23:05:25.596000Z |
play_count |
40402 |
LOCAL |
1 |
1531 |
2763 |
347604 |
3913 |
82 |
495 |
2026-08-12T23:05:25.596000Z |
play_count |
347604 |
LOCAL |
1 |
1532 |
2764 |
34058495 |
401472 |
1473 |
8921 |
2026-08-12T23:05:25.596000Z |
play_count |
34058495 |
LOCAL |
1 |
1533 |
1195 |
33399722 |
101056 |
225 |
10580 |
2026-08-12T23:13:05.074Z |
0 |
LOCAL |
0 |
|
1534 |
2790 |
0 |
17 |
5 |
6 |
2026-08-12T23:23:13.715000Z |
play_count |
22 |
LOCAL |
0 |
1535 |
2791 |
0 |
434 |
2511 |
63 |
2026-08-12T23:23:13.715000Z |
play_count |
2945 |
LOCAL |
0 |
1536 |
2792 |
0 |
3324 |
103 |
61 |
2026-08-12T23:23:13.715000Z |
play_count |
3427 |
LOCAL |
0 |
1537 |
519 |
6298304 |
34030 |
34 |
564 |
2026-08-13T11:28:58.131000Z |
play_count |
6298304 |
LOCAL |
1 |
1538 |
2519 |
1289003 |
12031 |
1063 |
378 |
2026-08-13T11:28:58.131000Z |
play_count |
1289003 |
LOCAL |
1 |
1539 |
290 |
48753382 |
1602189 |
1686 |
33397 |
2026-08-13T11:28:58.131000Z |
play_count |
48753382 |
LOCAL |
1 |
1540 |
1190 |
4326275 |
108992 |
364 |
1142 |
2026-08-13T11:28:58.131000Z |
play_count |
4326275 |
LOCAL |
1 |
1541 |
2797 |
2648594 |
16195 |
2211 |
921 |
2026-08-13T11:28:58.131000Z |
play_count |
2648594 |
LOCAL |
1 |
1542 |
1069 |
117189080 |
8030830 |
20356 |
197191 |
2026-08-13T11:28:58.131000Z |
play_count |
117189080 |
LOCAL |
1 |
1543 |
2799 |
52210679 |
789655 |
1104 |
21242 |
2026-08-13T11:28:58.131000Z |
play_count |
52210679 |
LOCAL |
1 |
1544 |
672 |
8097445 |
37184 |
2300 |
0 |
2026-08-13T11:28:58.131000Z |
play_count |
8097445 |
LOCAL |
1 |
1545 |
1926 |
6217289 |
26865 |
662 |
299 |
2026-08-13T11:28:58.131000Z |
play_count |
6217289 |
LOCAL |
1 |
1546 |
1832 |
5404547 |
16946 |
23 |
327 |
2026-08-13T11:28:58.131000Z |
play_count |
5404547 |
LOCAL |
1 |
1547 |
2803 |
1300909 |
12751 |
245 |
240 |
2026-08-13T11:28:58.131000Z |
play_count |
1300909 |
LOCAL |
1 |
1548 |
2112 |
2707189 |
96193 |
322 |
1812 |
2026-08-13T11:28:58.131000Z |
play_count |
2707189 |
LOCAL |
1 |
1549 |
2805 |
101404353 |
4990982 |
30253 |
87868 |
2026-08-13T11:28:58.131000Z |
play_count |
101404353 |
LOCAL |
1 |
1550 |
2806 |
4009 |
27 |
27 |
7 |
2026-08-13T11:28:58.131000Z |
play_count |
4009 |
LOCAL |
1 |
1551 |
2807 |
3475757 |
74528 |
145 |
2794 |
2026-08-13T11:28:58.131000Z |
play_count |
3475757 |
LOCAL |
1 |
1552 |
2808 |
443422 |
4410 |
75 |
109 |
2026-08-13T11:28:58.131000Z |
play_count |
443422 |
LOCAL |
1 |
1553 |
1337 |
10690443 |
114036 |
2005 |
5945 |
2026-08-13T11:28:58.131000Z |
play_count |
10690443 |
LOCAL |
1 |
1554 |
524 |
119584228 |
1769428 |
5860 |
20261 |
2026-08-13T11:28:58.131000Z |
play_count |
119584228 |
LOCAL |
1 |
1555 |
1366 |
495607 |
28211 |
249 |
406 |
2026-08-13T11:28:58.131000Z |
play_count |
495607 |
LOCAL |
1 |
1556 |
2443 |
252625 |
2144 |
14 |
59 |
2026-08-13T11:28:58.131000Z |
play_count |
252625 |
LOCAL |
1 |
1557 |
2363 |
14694184 |
883800 |
2104 |
15610 |
2026-08-14T06:17:57.597000Z |
play_count |
14694184 |
LOCAL |
1 |
1558 |
306 |
1867573 |
12535 |
142 |
278 |
2026-08-14T06:17:57.597000Z |
play_count |
1867573 |
LOCAL |
1 |
1559 |
290 |
48804207 |
1604586 |
1687 |
33447 |
2026-08-14T06:17:57.597000Z |
play_count |
48804207 |
LOCAL |
1 |
1560 |
1832 |
5535299 |
17137 |
23 |
329 |
2026-08-14T06:17:57.597000Z |
play_count |
5535299 |
LOCAL |
1 |
1561 |
1195 |
37809114 |
114561 |
280 |
11830 |
2026-08-14T06:17:57.597000Z |
play_count |
37809114 |
LOCAL |
1 |
1562 |
752 |
18538 |
3 |
42 |
9 |
2026-08-14T06:17:57.597000Z |
play_count |
18538 |
LOCAL |
1 |
1563 |
1926 |
7078441 |
27004 |
663 |
303 |
2026-08-14T06:17:57.597000Z |
play_count |
7078441 |
LOCAL |
1 |
1564 |
2367 |
3145214 |
10587 |
293 |
289 |
2026-08-14T06:17:57.597000Z |
play_count |
3145214 |
LOCAL |
1 |
1565 |
2821 |
446322 |
3725 |
67 |
419 |
2026-08-14T06:17:57.597000Z |
play_count |
446322 |
LOCAL |
1 |
1566 |
1133 |
843782 |
3384 |
154 |
74 |
2026-08-14T06:17:57.597000Z |
play_count |
843782 |
LOCAL |
1 |
1567 |
2823 |
5662404 |
251531 |
396 |
4303 |
2026-08-14T06:17:57.597000Z |
play_count |
5662404 |
LOCAL |
1 |
1568 |
1845 |
85228230 |
307392 |
665 |
13277 |
2026-08-14T06:17:57.597000Z |
play_count |
85228230 |
LOCAL |
1 |
1569 |
2808 |
445024 |
4441 |
75 |
109 |
2026-08-14T06:17:57.597000Z |
play_count |
445024 |
LOCAL |
1 |
1570 |
1507 |
20293631 |
165455 |
868 |
2806 |
2026-08-14T06:17:57.597000Z |
play_count |
20293631 |
LOCAL |
1 |
1571 |
307 |
1900687 |
31331 |
141 |
486 |
2026-08-14T06:17:57.597000Z |
play_count |
1900687 |
LOCAL |
1 |
1572 |
2828 |
67868815 |
3439964 |
8878 |
49911 |
2026-08-14T06:17:57.597000Z |
play_count |
67868815 |
LOCAL |
1 |
1573 |
1454 |
1312279 |
23827 |
224 |
355 |
2026-08-14T06:17:57.597000Z |
play_count |
1312279 |
LOCAL |
1 |
1574 |
525 |
8393395 |
92284 |
2212 |
2284 |
2026-08-14T06:17:57.597000Z |
play_count |
8393395 |
LOCAL |
1 |
1575 |
1372 |
7257656 |
76677 |
613 |
2032 |
2026-08-14T06:17:57.597000Z |
play_count |
7257656 |
LOCAL |
1 |
1576 |
524 |
120155807 |
1780851 |
5898 |
20410 |
2026-08-14T06:17:57.597000Z |
play_count |
120155807 |
LOCAL |
1 |
1577 |
540 |
2053560 |
4204 |
25 |
211 |
2026-08-14T06:42:43.868000Z |
play_count |
2053560 |
LOCAL |
1 |
1578 |
2854 |
14011325 |
349166 |
9513 |
12112 |
2026-08-14T06:42:43.868000Z |
play_count |
14011325 |
LOCAL |
1 |
1579 |
1081 |
4325207 |
98876 |
1051 |
1636 |
2026-08-14T06:42:43.868000Z |
play_count |
4325207 |
LOCAL |
1 |
1580 |
304 |
47136198 |
550770 |
504 |
13199 |
2026-08-14T06:42:43.868000Z |
play_count |
47136198 |
LOCAL |
1 |
1581 |
1085 |
147094494 |
3794999 |
15762 |
93531 |
2026-08-14T06:42:43.868000Z |
play_count |
147094494 |
LOCAL |
1 |
1582 |
2858 |
243525 |
7031 |
39 |
242 |
2026-08-14T06:42:43.868000Z |
play_count |
243525 |
LOCAL |
1 |
1583 |
1341 |
30900 |
302 |
23 |
9 |
2026-08-14T06:42:43.868000Z |
play_count |
30900 |
LOCAL |
1 |
1584 |
1980 |
49826386 |
1874216 |
8320 |
49192 |
2026-08-14T06:42:43.868000Z |
play_count |
49826386 |
LOCAL |
1 |
1585 |
1082 |
52136624 |
1266548 |
6375 |
20701 |
2026-08-14T06:42:43.868000Z |
play_count |
52136624 |
LOCAL |
1 |
1586 |
1088 |
24677544 |
424676 |
985 |
4846 |
2026-08-14T06:42:43.868000Z |
play_count |
24677544 |
LOCAL |
1 |
1587 |
533 |
151209585 |
2926092 |
11953 |
38367 |
2026-08-14T06:42:43.868000Z |
play_count |
151209585 |
LOCAL |
1 |
1588 |
2080 |
7068740 |
430912 |
1469 |
12038 |
2026-08-14T06:42:43.868000Z |
play_count |
7068740 |
LOCAL |
1 |
1589 |
2865 |
107634751 |
3259476 |
17170 |
50270 |
2026-08-14T06:42:43.868000Z |
play_count |
107634751 |
LOCAL |
1 |
1590 |
1376 |
689515 |
19355 |
468 |
561 |
2026-08-14T06:42:43.868000Z |
play_count |
689515 |
LOCAL |
1 |
1591 |
1196 |
1776960 |
14431 |
103 |
209 |
2026-08-14T06:42:43.868000Z |
play_count |
1776960 |
LOCAL |
1 |
1592 |
766 |
78885236 |
412616 |
656 |
12931 |
2026-08-14T06:42:43.868000Z |
play_count |
78885236 |
LOCAL |
1 |
1593 |
1155 |
2409002 |
33478 |
403 |
686 |
2026-08-14T06:42:43.868000Z |
play_count |
2409002 |
LOCAL |
1 |
1594 |
2764 |
35990595 |
418898 |
1529 |
9167 |
2026-08-14T06:42:43.868000Z |
play_count |
35990595 |
LOCAL |
1 |
1595 |
2871 |
4577906 |
249097 |
11813 |
4645 |
2026-08-14T06:42:43.868000Z |
play_count |
4577906 |
LOCAL |
1 |
1596 |
532 |
7442616 |
44974 |
2078 |
803 |
2026-08-14T06:42:43.868000Z |
play_count |
7442616 |
LOCAL |
1 |
1597 |
2893 |
0 |
14359 |
52 |
170 |
2026-08-14T06:44:18.744000Z |
play_count |
14411 |
LOCAL |
0 |
1598 |
1082 |
52136624 |
1266632 |
6375 |
20702 |
2026-08-14T06:44:18.744000Z |
play_count |
1273007 |
LOCAL |
1 |
1599 |
2895 |
0 |
132 |
1 |
3 |
2026-08-14T06:44:18.744000Z |
play_count |
133 |
LOCAL |
0 |
1600 |
2896 |
0 |
160 |
0 |
1 |
2026-08-14T06:44:18.744000Z |
play_count |
160 |
LOCAL |
0 |