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 |
|---|---|---|---|---|---|---|---|---|---|---|
1401 |
2526 |
455838 |
9612 |
260 |
162 |
2026-08-12T13:57:35.663000Z |
play_count |
455838 |
LOCAL |
1 |
1402 |
1243 |
4288101 |
3 |
158 |
778 |
2026-08-12T13:57:35.663000Z |
play_count |
4288101 |
LOCAL |
1 |
1403 |
1869 |
3143984 |
16076 |
70 |
386 |
2026-08-12T13:57:35.663000Z |
play_count |
3143984 |
LOCAL |
1 |
1404 |
305 |
63430672 |
492806 |
2321 |
7041 |
2026-08-12T13:57:35.663000Z |
play_count |
63430672 |
LOCAL |
1 |
1405 |
2530 |
4078918 |
10758 |
1 |
415 |
2026-08-12T13:57:35.663000Z |
play_count |
4078918 |
LOCAL |
1 |
1406 |
2531 |
29574168 |
189625 |
573 |
6987 |
2026-08-12T13:57:35.663000Z |
play_count |
29574168 |
LOCAL |
1 |
1407 |
538 |
1408027 |
28189 |
20606 |
230 |
2026-08-12T13:57:35.663000Z |
play_count |
1408027 |
LOCAL |
1 |
1408 |
2391 |
7251876 |
190018 |
537 |
3509 |
2026-08-12T13:57:35Z |
play_count |
7251876 |
SERVER |
1 |
1409 |
659 |
4931268 |
14189 |
59 |
536 |
2026-08-12T14:01:02.727000Z |
play_count |
4931268 |
LOCAL |
1 |
1410 |
2559 |
22463705 |
1240776 |
1541 |
34510 |
2026-08-12T14:01:02.727000Z |
play_count |
22463705 |
LOCAL |
1 |
1411 |
2560 |
10307188 |
16218 |
13 |
228 |
2026-08-12T14:01:02.727000Z |
play_count |
10307188 |
LOCAL |
1 |
1412 |
2561 |
539016 |
5467 |
109 |
124 |
2026-08-12T14:01:02.727000Z |
play_count |
539016 |
LOCAL |
1 |
1413 |
1582 |
3008508 |
74217 |
162 |
1238 |
2026-08-12T14:01:02.727000Z |
play_count |
3008508 |
LOCAL |
1 |
1414 |
2563 |
14464549 |
370265 |
763 |
5083 |
2026-08-12T14:01:02.727000Z |
play_count |
14464549 |
LOCAL |
1 |
1415 |
2425 |
53478248 |
2481402 |
9344 |
42385 |
2026-08-12T14:01:02.727000Z |
play_count |
53478248 |
LOCAL |
1 |
1416 |
2565 |
653219 |
9716 |
130 |
121 |
2026-08-12T14:01:02.727000Z |
play_count |
653219 |
LOCAL |
1 |
1417 |
1335 |
8296260 |
57016 |
233 |
1295 |
2026-08-12T14:01:02.727000Z |
play_count |
8296260 |
LOCAL |
1 |
1418 |
2567 |
4610049 |
5123 |
14 |
101 |
2026-08-12T14:01:02.727000Z |
play_count |
4610049 |
LOCAL |
1 |
1419 |
2568 |
2159413 |
31241 |
194 |
627 |
2026-08-12T14:01:02.727000Z |
play_count |
2159413 |
LOCAL |
1 |
1420 |
2569 |
5283538 |
17909 |
10 |
195 |
2026-08-12T14:01:02.727000Z |
play_count |
5283538 |
LOCAL |
1 |
1421 |
303 |
790986 |
14140 |
187 |
323 |
2026-08-12T14:01:02.727000Z |
play_count |
790986 |
LOCAL |
1 |
1422 |
2571 |
2704335 |
166630 |
2971 |
3083 |
2026-08-12T14:01:02.727000Z |
play_count |
2704335 |
LOCAL |
1 |
1423 |
1074 |
26344547 |
391839 |
1250 |
8610 |
2026-08-12T14:01:02.727000Z |
play_count |
26344547 |
LOCAL |
1 |
1424 |
2573 |
23024 |
292 |
22 |
0 |
2026-08-12T14:01:02.727000Z |
play_count |
23024 |
LOCAL |
1 |
1425 |
2574 |
4438160 |
70275 |
364 |
1293 |
2026-08-12T14:01:02.727000Z |
play_count |
4438160 |
LOCAL |
1 |
1426 |
2575 |
46808197 |
555426 |
813 |
13151 |
2026-08-12T14:01:02.727000Z |
play_count |
46808197 |
LOCAL |
1 |
1427 |
1138 |
2579482 |
145843 |
4408 |
1250 |
2026-08-12T14:01:02.727000Z |
play_count |
2579482 |
LOCAL |
1 |
1428 |
2577 |
20200 |
40 |
13 |
2 |
2026-08-12T14:01:02.727000Z |
play_count |
20200 |
LOCAL |
1 |
1429 |
2559 |
22463705 |
1240810 |
1541 |
34508 |
2026-08-12T14:17:04.296000Z |
play_count |
1242351 |
LOCAL |
1 |
1430 |
2559 |
22463705 |
1240811 |
1541 |
34508 |
2026-08-12T14:17:36.934000Z |
play_count |
1242352 |
LOCAL |
1 |
1431 |
2559 |
22464269 |
1240811 |
1541 |
34508 |
2026-08-12T14:17:37Z |
play_count |
22464269 |
SERVER |
1 |
1432 |
2584 |
4095 |
92 |
1 |
3 |
2026-08-12T14:20:41.197000Z |
play_count |
4095 |
LOCAL |
1 |
1433 |
2585 |
5650 |
76 |
1 |
2 |
2026-08-12T14:20:41.197000Z |
play_count |
5650 |
LOCAL |
1 |
1434 |
2586 |
52422 |
1012 |
7 |
28 |
2026-08-12T14:20:41.197000Z |
play_count |
52422 |
LOCAL |
1 |
1435 |
2581 |
17771 |
246 |
4 |
8 |
2026-08-12T14:20:41.197000Z |
play_count |
17771 |
LOCAL |
1 |
1436 |
2583 |
18401 |
213 |
1 |
4 |
2026-08-12T14:20:41.197000Z |
play_count |
18401 |
LOCAL |
1 |
1437 |
2595 |
27078 |
783 |
4 |
11 |
2026-08-12T14:20:41.197000Z |
play_count |
27078 |
LOCAL |
1 |
1438 |
2587 |
10410 |
145 |
1 |
1 |
2026-08-12T14:20:41.197000Z |
play_count |
10410 |
LOCAL |
1 |
1439 |
2559 |
22464395 |
1240811 |
1541 |
34508 |
2026-08-12T14:20:42Z |
play_count |
22464395 |
SERVER |
1 |
1440 |
2584 |
4095 |
92 |
1 |
0 |
2026-08-12T14:22:40.652000Z |
play_count |
93 |
LOCAL |
1 |
1441 |
2585 |
5650 |
76 |
1 |
0 |
2026-08-12T14:22:40.652000Z |
play_count |
77 |
LOCAL |
1 |
1442 |
2586 |
52422 |
1012 |
7 |
0 |
2026-08-12T14:22:40.652000Z |
play_count |
1019 |
LOCAL |
1 |
1443 |
2587 |
10410 |
145 |
1 |
0 |
2026-08-12T14:22:40.652000Z |
play_count |
146 |
LOCAL |
1 |
1444 |
2581 |
17771 |
246 |
4 |
0 |
2026-08-12T14:22:40.652000Z |
play_count |
250 |
LOCAL |
1 |
1445 |
2583 |
18401 |
213 |
1 |
0 |
2026-08-12T14:22:40.652000Z |
play_count |
214 |
LOCAL |
1 |
1446 |
2559 |
22464492 |
1240811 |
1541 |
34508 |
2026-08-12T14:22:44Z |
play_count |
22464492 |
SERVER |
1 |
1447 |
2586 |
52511 |
1012 |
7 |
28 |
2026-08-12T14:22:44Z |
play_count |
52511 |
SERVER |
1 |
1448 |
2583 |
18403 |
213 |
1 |
4 |
2026-08-12T14:22:44Z |
play_count |
18403 |
SERVER |
1 |
1449 |
2581 |
17777 |
246 |
4 |
8 |
2026-08-12T14:22:44Z |
play_count |
17777 |
SERVER |
1 |
1450 |
2587 |
10420 |
145 |
1 |
1 |
2026-08-12T14:22:44Z |
play_count |
10420 |
SERVER |
1 |
1451 |
2585 |
5837 |
76 |
1 |
2 |
2026-08-12T14:22:44Z |
play_count |
5837 |
SERVER |
1 |
1452 |
2584 |
4184 |
92 |
1 |
3 |
2026-08-12T14:22:44Z |
play_count |
4184 |
SERVER |
1 |
1453 |
2595 |
27087 |
783 |
4 |
11 |
2026-08-12T14:24:00Z |
play_count |
27087 |
SERVER |
1 |
1454 |
2581 |
17777 |
246 |
4 |
8 |
2026-08-12T14:24:10.919Z |
0 |
LOCAL |
0 |
|
1455 |
2595 |
27185 |
785 |
4 |
12 |
2026-08-12T15:27:51.425000Z |
play_count |
27185 |
LOCAL |
1 |
1456 |
697 |
951222 |
7463 |
121 |
84 |
2026-08-12T22:29:54.255000Z |
play_count |
951222 |
LOCAL |
1 |
1457 |
2636 |
247394413 |
14727416 |
70131 |
324736 |
2026-08-12T22:29:54.255000Z |
play_count |
247394413 |
LOCAL |
1 |
1458 |
306 |
1862721 |
12469 |
141 |
277 |
2026-08-12T22:29:54.255000Z |
play_count |
1862721 |
LOCAL |
1 |
1459 |
2638 |
211986 |
7934 |
213 |
102 |
2026-08-12T22:29:54.255000Z |
play_count |
211986 |
LOCAL |
1 |
1460 |
1366 |
466093 |
26606 |
241 |
382 |
2026-08-12T22:29:54.255000Z |
play_count |
466093 |
LOCAL |
1 |
1461 |
2640 |
4875979 |
47536 |
359 |
694 |
2026-08-12T22:29:54.255000Z |
play_count |
4875979 |
LOCAL |
1 |
1462 |
2641 |
1309179 |
73042 |
596 |
996 |
2026-08-12T22:29:54.255000Z |
play_count |
1309179 |
LOCAL |
1 |
1463 |
2642 |
98820538 |
7132888 |
27592 |
206368 |
2026-08-12T22:29:54.255000Z |
play_count |
98820538 |
LOCAL |
1 |
1464 |
1072 |
1695476 |
14568 |
2687 |
547 |
2026-08-12T22:29:54.255000Z |
play_count |
1695476 |
LOCAL |
1 |
1465 |
1085 |
142114461 |
3643202 |
15176 |
89789 |
2026-08-12T22:29:54.255000Z |
play_count |
142114461 |
LOCAL |
1 |
1466 |
1383 |
87089583 |
5920747 |
16436 |
110239 |
2026-08-12T22:29:54.255000Z |
play_count |
87089583 |
LOCAL |
1 |
1467 |
533 |
148425940 |
2869063 |
11733 |
37626 |
2026-08-12T22:29:54.255000Z |
play_count |
148425940 |
LOCAL |
1 |
1468 |
1376 |
687135 |
19284 |
460 |
560 |
2026-08-12T22:29:54.255000Z |
play_count |
687135 |
LOCAL |
1 |
1469 |
1193 |
1156054 |
17014 |
47 |
279 |
2026-08-12T22:29:54.255000Z |
play_count |
1156054 |
LOCAL |
1 |
1470 |
1075 |
59507140 |
748619 |
1007 |
36895 |
2026-08-12T22:29:54.255000Z |
play_count |
59507140 |
LOCAL |
1 |
1471 |
2650 |
227750816 |
9543075 |
10431 |
156722 |
2026-08-12T22:29:54.255000Z |
play_count |
227750816 |
LOCAL |
1 |
1472 |
532 |
2476543 |
44378 |
2047 |
781 |
2026-08-12T22:29:54.255000Z |
play_count |
2476543 |
LOCAL |
1 |
1473 |
2652 |
19064172 |
44581 |
198 |
1551 |
2026-08-12T22:29:54.255000Z |
play_count |
19064172 |
LOCAL |
1 |
1474 |
2530 |
4221001 |
12391 |
1 |
453 |
2026-08-12T22:29:54.255000Z |
play_count |
4221001 |
LOCAL |
1 |
1475 |
2654 |
1488630 |
116985 |
285 |
2878 |
2026-08-12T22:29:54.255000Z |
play_count |
1488630 |
LOCAL |
1 |
1476 |
2636 |
249100662 |
14727416 |
70131 |
324736 |
2026-08-12T22:30:13.695000Z |
play_count |
249100662 |
LOCAL |
1 |
1477 |
2638 |
247066 |
7934 |
213 |
102 |
2026-08-12T22:30:13.695000Z |
play_count |
247066 |
LOCAL |
1 |
1478 |
1366 |
469796 |
26606 |
241 |
382 |
2026-08-12T22:30:13.695000Z |
play_count |
469796 |
LOCAL |
1 |
1479 |
2642 |
101387824 |
7132888 |
27592 |
206368 |
2026-08-12T22:30:13.695000Z |
play_count |
101387824 |
LOCAL |
1 |
1480 |
1085 |
142116781 |
3643202 |
15176 |
89789 |
2026-08-12T22:30:13.695000Z |
play_count |
142116781 |
LOCAL |
1 |
1481 |
1383 |
92128933 |
5920747 |
16436 |
110239 |
2026-08-12T22:30:13.695000Z |
play_count |
92128933 |
LOCAL |
1 |
1482 |
533 |
149517196 |
2869063 |
11733 |
37626 |
2026-08-12T22:30:13.695000Z |
play_count |
149517196 |
LOCAL |
1 |
1483 |
532 |
7366257 |
44378 |
2047 |
781 |
2026-08-12T22:30:13.695000Z |
play_count |
7366257 |
LOCAL |
1 |
1484 |
2530 |
4393230 |
12391 |
1 |
453 |
2026-08-12T22:30:13.695000Z |
play_count |
4393230 |
LOCAL |
1 |
1485 |
1188 |
397247 |
879 |
23 |
86 |
2026-08-12T23:05:03.584000Z |
play_count |
397247 |
LOCAL |
1 |
1486 |
519 |
6233383 |
33577 |
33 |
560 |
2026-08-12T23:05:03.584000Z |
play_count |
6233383 |
LOCAL |
1 |
1487 |
1342 |
32214081 |
182451 |
1509 |
6966 |
2026-08-12T23:05:03.584000Z |
play_count |
32214081 |
LOCAL |
1 |
1488 |
2696 |
2225086 |
8845 |
166 |
336 |
2026-08-12T23:05:03.584000Z |
play_count |
2225086 |
LOCAL |
1 |
1489 |
534 |
23955 |
607 |
2 |
2 |
2026-08-12T23:05:03.584000Z |
play_count |
23955 |
LOCAL |
1 |
1490 |
545 |
38004910 |
249612 |
873 |
6358 |
2026-08-12T23:05:03.584000Z |
play_count |
38004910 |
LOCAL |
1 |
1491 |
1927 |
3815505 |
14278 |
135 |
312 |
2026-08-12T23:05:03.584000Z |
play_count |
3815505 |
LOCAL |
1 |
1492 |
291 |
98680 |
1029 |
398 |
17 |
2026-08-12T23:05:03.584000Z |
play_count |
98680 |
LOCAL |
1 |
1493 |
540 |
2011337 |
4091 |
25 |
204 |
2026-08-12T23:05:03.584000Z |
play_count |
2011337 |
LOCAL |
1 |
1494 |
307 |
1893471 |
31244 |
140 |
488 |
2026-08-12T23:05:03.584000Z |
play_count |
1893471 |
LOCAL |
1 |
1495 |
1195 |
33399722 |
101056 |
225 |
10580 |
2026-08-12T23:05:03.584000Z |
play_count |
33399722 |
LOCAL |
1 |
1496 |
655 |
3336 |
29 |
2 |
0 |
2026-08-12T23:05:03.584000Z |
play_count |
3336 |
LOCAL |
1 |
1497 |
1692 |
722158 |
28211 |
68 |
318 |
2026-08-12T23:05:03.584000Z |
play_count |
722158 |
LOCAL |
1 |
1498 |
2706 |
3970 |
31 |
35 |
5 |
2026-08-12T23:05:03.584000Z |
play_count |
3970 |
LOCAL |
1 |
1499 |
2707 |
18526860 |
897967 |
1322 |
13106 |
2026-08-12T23:05:03.584000Z |
play_count |
18526860 |
LOCAL |
1 |
1500 |
1069 |
116714101 |
8004475 |
20286 |
196584 |
2026-08-12T23:05:03.584000Z |
play_count |
116714101 |
LOCAL |
1 |