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 |
|---|---|---|---|---|---|---|---|---|---|---|
1901 |
3367 |
119181 |
846 |
2474 |
62 |
2026-08-16T12:16:14.919000Z |
play_count |
119181 |
LOCAL |
1 |
1902 |
2854 |
14469854 |
358057 |
9757 |
12369 |
2026-08-16T12:16:55.495000Z |
play_count |
14469854 |
LOCAL |
1 |
1903 |
533 |
153458305 |
3000615 |
12214 |
39330 |
2026-08-16T12:16:55.495000Z |
play_count |
153458305 |
LOCAL |
1 |
1904 |
3322 |
13173920 |
76080 |
7963 |
1519 |
2026-08-16T12:16:55.495000Z |
play_count |
13173920 |
LOCAL |
1 |
1905 |
2854 |
14471680 |
358087 |
9758 |
12370 |
2026-08-16T12:17:18.484000Z |
play_count |
14471680 |
LOCAL |
1 |
1906 |
3374 |
0 |
1587684 |
20742 |
33476 |
2026-08-16T12:17:19.833000Z |
play_count |
1608426 |
LOCAL |
0 |
1907 |
3375 |
0 |
120 |
2 |
0 |
2026-08-16T12:17:19.833000Z |
play_count |
122 |
LOCAL |
0 |
1908 |
3376 |
0 |
281 |
3 |
10 |
2026-08-16T12:17:19.833000Z |
play_count |
284 |
LOCAL |
0 |
1909 |
3378 |
0 |
561 |
2 |
11 |
2026-08-16T12:17:19.833000Z |
play_count |
563 |
LOCAL |
0 |
1910 |
3379 |
0 |
640 |
8 |
9 |
2026-08-16T12:17:19.833000Z |
play_count |
648 |
LOCAL |
0 |
1911 |
3380 |
0 |
557 |
9 |
15 |
2026-08-16T12:17:19.833000Z |
play_count |
566 |
LOCAL |
0 |
1912 |
3381 |
0 |
32392 |
541 |
1166 |
2026-08-16T12:17:19.833000Z |
play_count |
32933 |
LOCAL |
0 |
1913 |
3382 |
0 |
419 |
7 |
12 |
2026-08-16T12:17:19.833000Z |
play_count |
426 |
LOCAL |
0 |
1914 |
3383 |
0 |
138 |
2 |
2 |
2026-08-16T12:17:19.833000Z |
play_count |
140 |
LOCAL |
0 |
1915 |
3385 |
0 |
54033 |
2006 |
734 |
2026-08-16T12:17:19.833000Z |
play_count |
56039 |
LOCAL |
0 |
1916 |
3386 |
0 |
1151 |
27 |
41 |
2026-08-16T12:17:19.833000Z |
play_count |
1178 |
LOCAL |
0 |
1917 |
3387 |
0 |
601 |
4 |
23 |
2026-08-16T12:17:19.833000Z |
play_count |
605 |
LOCAL |
0 |
1918 |
3397 |
0 |
878 |
17 |
12 |
2026-08-16T12:17:35.793000Z |
play_count |
895 |
LOCAL |
0 |
1919 |
3398 |
0 |
234073 |
4665 |
30 |
2026-08-16T12:17:35.793000Z |
play_count |
238738 |
LOCAL |
0 |
1920 |
3400 |
0 |
789 |
26 |
19 |
2026-08-16T12:17:35.793000Z |
play_count |
815 |
LOCAL |
0 |
1921 |
3401 |
0 |
4376 |
52 |
104 |
2026-08-16T12:17:35.793000Z |
play_count |
4428 |
LOCAL |
0 |
1922 |
3402 |
0 |
304 |
5 |
4 |
2026-08-16T12:17:35.793000Z |
play_count |
309 |
LOCAL |
0 |
1923 |
3403 |
0 |
220 |
8 |
6 |
2026-08-16T12:17:35.793000Z |
play_count |
228 |
LOCAL |
0 |
1924 |
3404 |
0 |
239 |
1 |
8 |
2026-08-16T12:17:35.793000Z |
play_count |
240 |
LOCAL |
0 |
1925 |
3405 |
0 |
153 |
4 |
3 |
2026-08-16T12:17:35.793000Z |
play_count |
157 |
LOCAL |
0 |
1926 |
3406 |
0 |
3867 |
41 |
101 |
2026-08-16T12:17:35.793000Z |
play_count |
3908 |
LOCAL |
0 |
1927 |
3407 |
0 |
329 |
6 |
8 |
2026-08-16T12:17:35.793000Z |
play_count |
335 |
LOCAL |
0 |
1928 |
3408 |
0 |
1326 |
21 |
7 |
2026-08-16T12:17:35.793000Z |
play_count |
1347 |
LOCAL |
0 |
1929 |
3374 |
22611068 |
1587684 |
20742 |
33476 |
2026-08-16T12:17:42.935000Z |
play_count |
22611068 |
LOCAL |
1 |
1930 |
3375 |
3453 |
120 |
2 |
0 |
2026-08-16T12:17:46.204000Z |
play_count |
3453 |
LOCAL |
1 |
1931 |
3376 |
10506 |
281 |
3 |
10 |
2026-08-16T12:17:46.204000Z |
play_count |
10506 |
LOCAL |
1 |
1932 |
3378 |
29550 |
561 |
2 |
11 |
2026-08-16T12:17:46.204000Z |
play_count |
29550 |
LOCAL |
1 |
1933 |
3379 |
13948 |
640 |
8 |
9 |
2026-08-16T12:17:46.204000Z |
play_count |
13948 |
LOCAL |
1 |
1934 |
3380 |
20677 |
557 |
9 |
15 |
2026-08-16T12:17:46.204000Z |
play_count |
20677 |
LOCAL |
1 |
1935 |
3381 |
1692826 |
32392 |
541 |
1166 |
2026-08-16T12:17:46.204000Z |
play_count |
1692826 |
LOCAL |
1 |
1936 |
3382 |
31899 |
419 |
7 |
12 |
2026-08-16T12:17:46.204000Z |
play_count |
31899 |
LOCAL |
1 |
1937 |
3383 |
36944 |
138 |
2 |
2 |
2026-08-16T12:17:46.204000Z |
play_count |
36944 |
LOCAL |
1 |
1938 |
3385 |
1627788 |
54033 |
2006 |
734 |
2026-08-16T12:17:46.204000Z |
play_count |
1627788 |
LOCAL |
1 |
1939 |
3386 |
31676 |
1151 |
27 |
41 |
2026-08-16T12:17:46.204000Z |
play_count |
31676 |
LOCAL |
1 |
1940 |
3387 |
36538 |
601 |
4 |
23 |
2026-08-16T12:17:46.204000Z |
play_count |
36538 |
LOCAL |
1 |
1941 |
3397 |
36340 |
878 |
17 |
12 |
2026-08-16T12:17:46.204000Z |
play_count |
36340 |
LOCAL |
1 |
1942 |
2854 |
14471751 |
358087 |
9758 |
12370 |
2026-08-16T12:17:46.204000Z |
play_count |
14471751 |
LOCAL |
1 |
1943 |
3398 |
17926125 |
234073 |
4665 |
30 |
2026-08-16T12:17:46.204000Z |
play_count |
17926125 |
LOCAL |
1 |
1944 |
3400 |
27595 |
789 |
26 |
19 |
2026-08-16T12:17:46.204000Z |
play_count |
27595 |
LOCAL |
1 |
1945 |
3401 |
140598 |
4376 |
52 |
104 |
2026-08-16T12:17:46.204000Z |
play_count |
140598 |
LOCAL |
1 |
1946 |
3402 |
14979 |
304 |
5 |
4 |
2026-08-16T12:17:46.204000Z |
play_count |
14979 |
LOCAL |
1 |
1947 |
3403 |
13491 |
220 |
8 |
6 |
2026-08-16T12:17:46.204000Z |
play_count |
13491 |
LOCAL |
1 |
1948 |
3404 |
17142 |
239 |
1 |
8 |
2026-08-16T12:17:46.204000Z |
play_count |
17142 |
LOCAL |
1 |
1949 |
3405 |
11029 |
153 |
4 |
3 |
2026-08-16T12:17:46.204000Z |
play_count |
11029 |
LOCAL |
1 |
1950 |
3406 |
373749 |
3867 |
41 |
101 |
2026-08-16T12:17:46.204000Z |
play_count |
373749 |
LOCAL |
1 |
1951 |
3407 |
11840 |
329 |
6 |
8 |
2026-08-16T12:17:46.204000Z |
play_count |
11840 |
LOCAL |
1 |
1952 |
3408 |
75644 |
1326 |
21 |
7 |
2026-08-16T12:17:46.204000Z |
play_count |
75644 |
LOCAL |
1 |
1953 |
3465 |
0 |
58 |
131 |
2 |
2026-08-16T12:18:24.865000Z |
play_count |
189 |
LOCAL |
0 |
1954 |
3466 |
0 |
425 |
856 |
65 |
2026-08-16T12:18:24.865000Z |
play_count |
1281 |
LOCAL |
0 |
1955 |
3362 |
228345 |
1330 |
2160 |
66 |
2026-08-16T12:18:24.865000Z |
play_count |
3490 |
LOCAL |
1 |
1956 |
3468 |
0 |
330 |
29 |
8 |
2026-08-16T12:18:24.865000Z |
play_count |
359 |
LOCAL |
0 |
1957 |
3361 |
162691 |
5228 |
47 |
90 |
2026-08-16T12:18:24.865000Z |
play_count |
5275 |
LOCAL |
1 |
1958 |
3364 |
4823 |
3 |
0 |
2 |
2026-08-16T12:18:24.865000Z |
play_count |
4823 |
LOCAL |
1 |
1959 |
3468 |
73331 |
330 |
29 |
8 |
2026-08-16T12:18:30.953000Z |
play_count |
73331 |
LOCAL |
1 |
1960 |
3465 |
9560 |
58 |
131 |
2 |
2026-08-16T12:18:30.953000Z |
play_count |
9560 |
LOCAL |
1 |
1961 |
3362 |
230391 |
1330 |
2160 |
66 |
2026-08-16T12:18:30.953000Z |
play_count |
230391 |
LOCAL |
1 |
1962 |
3466 |
47046 |
425 |
856 |
65 |
2026-08-16T12:18:30.953000Z |
play_count |
47046 |
LOCAL |
1 |
1963 |
3361 |
162549 |
5228 |
47 |
90 |
2026-08-16T12:18:30.953000Z |
play_count |
162549 |
LOCAL |
1 |
1964 |
3480 |
15328 |
324 |
6 |
0 |
2026-08-16T12:18:38.741000Z |
play_count |
15328 |
LOCAL |
1 |
1965 |
3507 |
0 |
65 |
3 |
6 |
2026-08-16T12:19:45.102000Z |
play_count |
68 |
LOCAL |
0 |
1966 |
3508 |
65889 |
319 |
3057 |
38 |
2026-08-16T12:19:45.102000Z |
play_count |
65889 |
LOCAL |
1 |
1967 |
3509 |
0 |
855 |
4736 |
41 |
2026-08-16T12:19:45.102000Z |
play_count |
5591 |
LOCAL |
0 |
1968 |
3510 |
16134 |
93 |
86 |
4 |
2026-08-16T12:19:45.102000Z |
play_count |
16134 |
LOCAL |
1 |
1969 |
3512 |
0 |
1209 |
12544 |
202 |
2026-08-16T12:19:58.206000Z |
play_count |
13753 |
LOCAL |
0 |
1970 |
3513 |
0 |
2490 |
3458 |
109 |
2026-08-16T12:19:58.206000Z |
play_count |
5948 |
LOCAL |
0 |
1971 |
3514 |
0 |
66 |
200 |
5 |
2026-08-16T12:19:58.206000Z |
play_count |
266 |
LOCAL |
0 |
1972 |
3515 |
0 |
997 |
559 |
140 |
2026-08-16T12:19:58.206000Z |
play_count |
1556 |
LOCAL |
0 |
1973 |
3516 |
0 |
874 |
5669 |
152 |
2026-08-16T12:19:58.206000Z |
play_count |
6543 |
LOCAL |
0 |
1974 |
3517 |
0 |
370 |
2268 |
45 |
2026-08-16T12:19:58.206000Z |
play_count |
2638 |
LOCAL |
0 |
1975 |
3518 |
0 |
2349 |
7447 |
235 |
2026-08-16T12:19:58.206000Z |
play_count |
9796 |
LOCAL |
0 |
1976 |
3519 |
0 |
434 |
12 |
75 |
2026-08-16T12:19:58.206000Z |
play_count |
446 |
LOCAL |
0 |
1977 |
3507 |
24744 |
65 |
3 |
6 |
2026-08-16T12:20:02.907000Z |
play_count |
24744 |
LOCAL |
1 |
1978 |
3509 |
124951 |
855 |
4736 |
41 |
2026-08-16T12:20:02.907000Z |
play_count |
124951 |
LOCAL |
1 |
1979 |
3512 |
148398 |
1209 |
12544 |
202 |
2026-08-16T12:20:02.907000Z |
play_count |
148398 |
LOCAL |
1 |
1980 |
3513 |
327916 |
2490 |
3458 |
109 |
2026-08-16T12:20:02.907000Z |
play_count |
327916 |
LOCAL |
1 |
1981 |
3514 |
10897 |
66 |
200 |
5 |
2026-08-16T12:20:02.907000Z |
play_count |
10897 |
LOCAL |
1 |
1982 |
3516 |
183533 |
874 |
5669 |
152 |
2026-08-16T12:20:02.907000Z |
play_count |
183533 |
LOCAL |
1 |
1983 |
3517 |
28278 |
370 |
2268 |
45 |
2026-08-16T12:20:02.907000Z |
play_count |
28278 |
LOCAL |
1 |
1984 |
3518 |
329638 |
2349 |
7447 |
235 |
2026-08-16T12:20:02.907000Z |
play_count |
329638 |
LOCAL |
1 |
1985 |
3519 |
60692 |
434 |
12 |
75 |
2026-08-16T12:20:02.907000Z |
play_count |
60692 |
LOCAL |
1 |
1986 |
3534 |
0 |
2412 |
1872 |
123 |
2026-08-16T12:21:06.464000Z |
play_count |
4284 |
LOCAL |
0 |
1987 |
3537 |
29679 |
149 |
3 |
26 |
2026-08-16T12:21:10.903000Z |
play_count |
29679 |
LOCAL |
1 |
1988 |
3538 |
0 |
14638 |
1353 |
202 |
2026-08-16T12:21:10.903000Z |
play_count |
15991 |
LOCAL |
0 |
1989 |
3539 |
672854 |
851 |
1039 |
96 |
2026-08-16T12:21:10.903000Z |
play_count |
672854 |
LOCAL |
1 |
1990 |
3510 |
16211 |
93 |
86 |
4 |
2026-08-16T12:21:10.903000Z |
play_count |
16211 |
LOCAL |
1 |
1991 |
3361 |
162549 |
5231 |
47 |
90 |
2026-08-16T12:21:10.903000Z |
play_count |
5278 |
LOCAL |
1 |
1992 |
3362 |
231133 |
1334 |
2168 |
66 |
2026-08-16T12:21:10.903000Z |
play_count |
231133 |
LOCAL |
1 |
1993 |
3534 |
347606 |
2412 |
1872 |
123 |
2026-08-16T12:21:45.435000Z |
play_count |
347606 |
LOCAL |
1 |
1994 |
3508 |
65893 |
319 |
3057 |
0 |
2026-08-16T12:21:51.885000Z |
play_count |
65893 |
LOCAL |
1 |
1995 |
3553 |
31454 |
115 |
720 |
0 |
2026-08-16T12:21:51.885000Z |
play_count |
31454 |
LOCAL |
1 |
1996 |
3555 |
647112 |
11276 |
31 |
0 |
2026-08-16T12:21:51.885000Z |
play_count |
647112 |
LOCAL |
1 |
1997 |
3556 |
215350 |
1575 |
10 |
0 |
2026-08-16T12:21:51.885000Z |
play_count |
215350 |
LOCAL |
1 |
1998 |
3557 |
10806 |
52 |
10 |
0 |
2026-08-16T12:21:51.885000Z |
play_count |
10806 |
LOCAL |
1 |
1999 |
3558 |
392930 |
1717 |
36 |
0 |
2026-08-16T12:21:51.885000Z |
play_count |
392930 |
LOCAL |
1 |
2000 |
3560 |
649350 |
4148 |
8 |
0 |
2026-08-16T12:21:51.885000Z |
play_count |
649350 |
LOCAL |
1 |