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 |
|---|---|---|---|---|---|---|---|---|---|---|
1301 |
300 |
2190 |
527 |
7 |
0 |
2026-08-12T13:55:25.749000Z |
play_count |
2190 |
LOCAL |
1 |
1302 |
2357 |
2402 |
111 |
3 |
1 |
2026-08-12T13:55:25.749000Z |
play_count |
2402 |
LOCAL |
1 |
1303 |
2358 |
306442 |
2307 |
5 |
31 |
2026-08-12T13:55:25.749000Z |
play_count |
306442 |
LOCAL |
1 |
1304 |
1834 |
18008 |
182 |
53 |
3 |
2026-08-12T13:55:25.749000Z |
play_count |
18008 |
LOCAL |
1 |
1305 |
2360 |
142116 |
5041 |
17 |
64 |
2026-08-12T13:55:25.749000Z |
play_count |
142116 |
LOCAL |
1 |
1306 |
299 |
1554747 |
12035 |
13 |
189 |
2026-08-12T13:55:25.749000Z |
play_count |
1554747 |
LOCAL |
1 |
1307 |
1196 |
1723101 |
13993 |
103 |
206 |
2026-08-12T13:55:25.749000Z |
play_count |
1723101 |
LOCAL |
1 |
1308 |
2363 |
11587010 |
871923 |
2090 |
15379 |
2026-08-12T13:55:25.749000Z |
play_count |
11587010 |
LOCAL |
1 |
1309 |
2364 |
2293298 |
3 |
135 |
6192 |
2026-08-12T13:55:25.749000Z |
play_count |
2293298 |
LOCAL |
1 |
1310 |
2365 |
484397 |
13016 |
114 |
363 |
2026-08-12T13:55:25.749000Z |
play_count |
484397 |
LOCAL |
1 |
1311 |
1074 |
26344159 |
391834 |
1250 |
8610 |
2026-08-12T13:55:25.749000Z |
play_count |
26344159 |
LOCAL |
1 |
1312 |
2367 |
3050629 |
10118 |
278 |
284 |
2026-08-12T13:55:25.749000Z |
play_count |
3050629 |
LOCAL |
1 |
1313 |
1583 |
1964353 |
39314 |
141 |
576 |
2026-08-12T13:55:25.749000Z |
play_count |
1964353 |
LOCAL |
1 |
1314 |
1048 |
7207597 |
122375 |
1816 |
3364 |
2026-08-12T13:55:25.749000Z |
play_count |
7207597 |
LOCAL |
1 |
1315 |
1336 |
1215626 |
10128 |
440 |
300 |
2026-08-12T13:55:25.749000Z |
play_count |
1215626 |
LOCAL |
1 |
1316 |
2031 |
51841 |
864 |
479 |
8 |
2026-08-12T13:55:25.749000Z |
play_count |
51841 |
LOCAL |
1 |
1317 |
2372 |
4013026 |
149274 |
229 |
2129 |
2026-08-12T13:55:25.749000Z |
play_count |
4013026 |
LOCAL |
1 |
1318 |
2373 |
0 |
3 |
0 |
0 |
2026-08-12T13:55:50.921000Z |
play_count |
3 |
LOCAL |
0 |
1319 |
1215 |
9247695 |
47985 |
91 |
566 |
2026-08-12T13:55:50.921000Z |
play_count |
9247695 |
LOCAL |
1 |
1320 |
751 |
34473 |
3 |
51 |
13 |
2026-08-12T13:55:50Z |
play_count |
34473 |
SERVER |
1 |
1321 |
760 |
0 |
3 |
15 |
3 |
2026-08-12T13:55:50Z |
play_count |
18 |
SERVER |
0 |
1322 |
2353 |
2191112 |
84658 |
766 |
2371 |
2026-08-12T13:55:50Z |
play_count |
2191112 |
SERVER |
1 |
1323 |
569 |
11936178 |
249984 |
866 |
2266 |
2026-08-12T13:55:50Z |
play_count |
11936178 |
SERVER |
1 |
1324 |
2215 |
1023812 |
22280 |
61 |
242 |
2026-08-12T13:55:50Z |
play_count |
1023812 |
SERVER |
1 |
1325 |
2367 |
3050714 |
10117 |
278 |
284 |
2026-08-12T13:55:50Z |
play_count |
3050714 |
SERVER |
1 |
1326 |
2383 |
3727687 |
8187 |
53 |
736 |
2026-08-12T13:55:50Z |
play_count |
3727687 |
SERVER |
1 |
1327 |
1081 |
4260327 |
97637 |
1040 |
1600 |
2026-08-12T13:55:50Z |
play_count |
4260327 |
SERVER |
1 |
1328 |
2385 |
4576849 |
124576 |
2240 |
7965 |
2026-08-12T13:55:50Z |
play_count |
4576849 |
SERVER |
1 |
1329 |
2386 |
7073606 |
28461 |
5653 |
2607 |
2026-08-12T13:55:50Z |
play_count |
7073606 |
SERVER |
1 |
1330 |
600 |
7029324 |
70835 |
10203 |
1179 |
2026-08-12T13:55:50Z |
play_count |
7029324 |
SERVER |
1 |
1331 |
2388 |
23237256 |
201621 |
407 |
5255 |
2026-08-12T13:55:50Z |
play_count |
23237256 |
SERVER |
1 |
1332 |
809 |
24770584 |
472339 |
1268 |
8408 |
2026-08-12T13:55:50Z |
play_count |
24770584 |
SERVER |
1 |
1333 |
2390 |
25663690 |
236660 |
452 |
5063 |
2026-08-12T13:55:50Z |
play_count |
25663690 |
SERVER |
1 |
1334 |
2391 |
7251760 |
190018 |
537 |
3509 |
2026-08-12T13:55:50Z |
play_count |
7251760 |
SERVER |
1 |
1335 |
1155 |
2364026 |
32668 |
386 |
673 |
2026-08-12T13:55:50Z |
play_count |
2364026 |
SERVER |
1 |
1336 |
2393 |
4107834 |
30413 |
1085 |
1390 |
2026-08-12T13:55:50Z |
play_count |
4107834 |
SERVER |
1 |
1337 |
2372 |
4013035 |
149274 |
229 |
2129 |
2026-08-12T13:55:50Z |
play_count |
4013035 |
SERVER |
1 |
1338 |
569 |
13687155 |
249984 |
866 |
2266 |
2026-08-12T13:56:05.750000Z |
play_count |
13687155 |
LOCAL |
1 |
1339 |
600 |
9076790 |
70835 |
10203 |
1179 |
2026-08-12T13:56:05.750000Z |
play_count |
9076790 |
LOCAL |
1 |
1340 |
2388 |
23348132 |
201621 |
407 |
5255 |
2026-08-12T13:56:05.750000Z |
play_count |
23348132 |
LOCAL |
1 |
1341 |
809 |
24854055 |
472339 |
1268 |
8408 |
2026-08-12T13:56:05.750000Z |
play_count |
24854055 |
LOCAL |
1 |
1342 |
2391 |
7252213 |
190018 |
537 |
3509 |
2026-08-12T13:56:05.750000Z |
play_count |
7252213 |
LOCAL |
1 |
1343 |
2393 |
5397257 |
30413 |
1085 |
1390 |
2026-08-12T13:56:05.750000Z |
play_count |
5397257 |
LOCAL |
1 |
1344 |
2422 |
841035 |
46616 |
441 |
637 |
2026-08-12T13:56:21.365000Z |
play_count |
841035 |
LOCAL |
1 |
1345 |
1678 |
744119 |
33469 |
237 |
543 |
2026-08-12T13:56:21.365000Z |
play_count |
744119 |
LOCAL |
1 |
1346 |
2425 |
53475486 |
2481311 |
9345 |
42385 |
2026-08-12T13:56:21.365000Z |
play_count |
53475486 |
LOCAL |
1 |
1347 |
1927 |
3807921 |
14242 |
135 |
311 |
2026-08-12T13:56:21.365000Z |
play_count |
3807921 |
LOCAL |
1 |
1348 |
1689 |
1519798 |
18273 |
28 |
181 |
2026-08-12T13:56:21.365000Z |
play_count |
1519798 |
LOCAL |
1 |
1349 |
1325 |
598850 |
11357 |
414 |
0 |
2026-08-12T13:56:21.365000Z |
play_count |
598850 |
LOCAL |
1 |
1350 |
2337 |
363748 |
8580 |
72 |
108 |
2026-08-12T13:56:21.365000Z |
play_count |
363748 |
LOCAL |
1 |
1351 |
1190 |
4319105 |
108836 |
364 |
1142 |
2026-08-12T13:56:21.365000Z |
play_count |
4319105 |
LOCAL |
1 |
1352 |
2424 |
0 |
141 |
12 |
1 |
2026-08-12T13:56:21.365000Z |
play_count |
153 |
LOCAL |
0 |
1353 |
1251 |
3639449 |
42452 |
57 |
771 |
2026-08-12T13:56:21.365000Z |
play_count |
3639449 |
LOCAL |
1 |
1354 |
564 |
11987018 |
49783 |
42 |
570 |
2026-08-12T13:56:21.365000Z |
play_count |
11987018 |
LOCAL |
1 |
1355 |
1232 |
7288807 |
129250 |
77702 |
1351 |
2026-08-12T13:56:21.365000Z |
play_count |
7288807 |
LOCAL |
1 |
1356 |
2341 |
408741 |
13651 |
85 |
306 |
2026-08-12T13:56:21.365000Z |
play_count |
408741 |
LOCAL |
1 |
1357 |
1990 |
2656035 |
8547 |
69 |
148 |
2026-08-12T13:56:21.365000Z |
play_count |
2656035 |
LOCAL |
1 |
1358 |
2438 |
1040172 |
34955 |
166 |
890 |
2026-08-12T13:56:21.365000Z |
play_count |
1040172 |
LOCAL |
1 |
1359 |
1193 |
1132965 |
16696 |
46 |
274 |
2026-08-12T13:56:21.365000Z |
play_count |
1132965 |
LOCAL |
1 |
1360 |
2440 |
2727444 |
31126 |
435 |
949 |
2026-08-12T13:56:21.365000Z |
play_count |
2727444 |
LOCAL |
1 |
1361 |
2079 |
1959084 |
9132 |
17 |
142 |
2026-08-12T13:56:21.365000Z |
play_count |
1959084 |
LOCAL |
1 |
1362 |
2034 |
5848891 |
51340 |
629 |
1052 |
2026-08-12T13:56:21.365000Z |
play_count |
5848891 |
LOCAL |
1 |
1363 |
2443 |
217671 |
1642 |
11 |
48 |
2026-08-12T13:56:21.365000Z |
play_count |
217671 |
LOCAL |
1 |
1364 |
2444 |
115673896 |
4457293 |
14204 |
58171 |
2026-08-12T13:56:21.365000Z |
play_count |
115673896 |
LOCAL |
1 |
1365 |
2445 |
19668793 |
326228 |
1031 |
3596 |
2026-08-12T13:56:21.365000Z |
play_count |
19668793 |
LOCAL |
1 |
1366 |
2469 |
962237 |
7251 |
3326 |
310 |
2026-08-12T13:57:20.120000Z |
play_count |
962237 |
LOCAL |
1 |
1367 |
2470 |
3954767 |
73842 |
431 |
1294 |
2026-08-12T13:57:20.120000Z |
play_count |
3954767 |
LOCAL |
1 |
1368 |
2363 |
14517118 |
871929 |
2090 |
15379 |
2026-08-12T13:57:20.120000Z |
play_count |
14517118 |
LOCAL |
1 |
1369 |
1446 |
106282826 |
485936 |
1358 |
14071 |
2026-08-12T13:57:20.120000Z |
play_count |
106282826 |
LOCAL |
1 |
1370 |
2474 |
579325 |
4905 |
364 |
171 |
2026-08-12T13:57:20.120000Z |
play_count |
579325 |
LOCAL |
1 |
1371 |
2360 |
142141 |
5043 |
17 |
64 |
2026-08-12T13:57:20.120000Z |
play_count |
142141 |
LOCAL |
1 |
1372 |
2476 |
39706851 |
1182310 |
5379 |
22657 |
2026-08-12T13:57:20.120000Z |
play_count |
39706851 |
LOCAL |
1 |
1373 |
1151 |
4493689 |
87971 |
65 |
1022 |
2026-08-12T13:57:20.120000Z |
play_count |
4493689 |
LOCAL |
1 |
1374 |
2478 |
10942033 |
45775 |
111 |
2262 |
2026-08-12T13:57:20.120000Z |
play_count |
10942033 |
LOCAL |
1 |
1375 |
2479 |
16620049 |
400990 |
987 |
3704 |
2026-08-12T13:57:20.120000Z |
play_count |
16620049 |
LOCAL |
1 |
1376 |
2480 |
5747063 |
62004 |
768 |
3684 |
2026-08-12T13:57:20.120000Z |
play_count |
5747063 |
LOCAL |
1 |
1377 |
2481 |
1981182 |
20841 |
1308 |
401 |
2026-08-12T13:57:20.120000Z |
play_count |
1981182 |
LOCAL |
1 |
1378 |
1506 |
13386857 |
42556 |
141 |
595 |
2026-08-12T13:57:20.120000Z |
play_count |
13386857 |
LOCAL |
1 |
1379 |
907 |
72029539 |
163660 |
709 |
6211 |
2026-08-12T13:57:20.120000Z |
play_count |
72029539 |
LOCAL |
1 |
1380 |
755 |
4099 |
19 |
1 |
1 |
2026-08-12T13:57:20.120000Z |
play_count |
4099 |
LOCAL |
1 |
1381 |
670 |
1798023 |
21757 |
3728 |
219 |
2026-08-12T13:57:20.120000Z |
play_count |
1798023 |
LOCAL |
1 |
1382 |
2247 |
18000900 |
335740 |
701 |
4269 |
2026-08-12T13:57:20.120000Z |
play_count |
18000900 |
LOCAL |
1 |
1383 |
712 |
63583232 |
492772 |
777 |
8451 |
2026-08-12T13:57:20.120000Z |
play_count |
63583232 |
LOCAL |
1 |
1384 |
708 |
3646490 |
79842 |
1634 |
1393 |
2026-08-12T13:57:20.120000Z |
play_count |
3646490 |
LOCAL |
1 |
1385 |
2510 |
84546 |
3 |
667 |
5 |
2026-08-12T13:57:35.663000Z |
play_count |
84546 |
LOCAL |
1 |
1386 |
2511 |
292745 |
12547 |
62 |
149 |
2026-08-12T13:57:35.663000Z |
play_count |
292745 |
LOCAL |
1 |
1387 |
2512 |
10256464 |
46579 |
179 |
926 |
2026-08-12T13:57:35.663000Z |
play_count |
10256464 |
LOCAL |
1 |
1388 |
2513 |
11975019 |
257257 |
177 |
3169 |
2026-08-12T13:57:35.663000Z |
play_count |
11975019 |
LOCAL |
1 |
1389 |
553 |
764366 |
11296 |
24 |
169 |
2026-08-12T13:57:35.663000Z |
play_count |
764366 |
LOCAL |
1 |
1390 |
1329 |
3474252 |
73832 |
2732 |
2239 |
2026-08-12T13:57:35.663000Z |
play_count |
3474252 |
LOCAL |
1 |
1391 |
658 |
2266 |
34 |
8 |
0 |
2026-08-12T13:57:35.663000Z |
play_count |
2266 |
LOCAL |
1 |
1392 |
1511 |
2432428 |
37419 |
24 |
344 |
2026-08-12T13:57:35.663000Z |
play_count |
2432428 |
LOCAL |
1 |
1393 |
2518 |
7259680 |
1307815 |
8730 |
7726 |
2026-08-12T13:57:35.663000Z |
play_count |
7259680 |
LOCAL |
1 |
1394 |
2519 |
1280554 |
11938 |
1061 |
378 |
2026-08-12T13:57:35.663000Z |
play_count |
1280554 |
LOCAL |
1 |
1395 |
2500 |
0 |
38 |
6 |
1 |
2026-08-12T13:57:35.663000Z |
play_count |
44 |
LOCAL |
0 |
1396 |
1072 |
1685438 |
14471 |
2674 |
549 |
2026-08-12T13:57:35.663000Z |
play_count |
1685438 |
LOCAL |
1 |
1397 |
666 |
9945591 |
42043 |
160 |
729 |
2026-08-12T13:57:35.663000Z |
play_count |
9945591 |
LOCAL |
1 |
1398 |
2523 |
6936442 |
83071 |
34 |
740 |
2026-08-12T13:57:35.663000Z |
play_count |
6936442 |
LOCAL |
1 |
1399 |
1192 |
970 |
34 |
5 |
1 |
2026-08-12T13:57:35.663000Z |
play_count |
970 |
LOCAL |
1 |
1400 |
1988 |
5962664 |
83641 |
1225 |
1041 |
2026-08-12T13:57:35.663000Z |
play_count |
5962664 |
LOCAL |
1 |