user_daily_visits

58 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user_id, device_id, user_agent

Link rowid ▼ user_id device_id timestamp user_agent
1 1 @james:matrix.jamesst.one GCKNIFMVHE 1784851200000 Mozilla/5.0 (X11; Linux x86_64; rv:152.0) Gecko/20100101 Firefox/152.0
2 2 @james:matrix.jamesst.one FQEGQAFPAE 1784851200000 Python-urllib/3.14
3 3 @james:matrix.jamesst.one BLSFYMBGKR 1784851200000 Python-urllib/3.14
4 4 @james:matrix.jamesst.one BLSFYMBGKR 1784937600000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.1 Python/3.13.14
5 5 @james:matrix.jamesst.one BLSFYMBGKR 1785024000000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.1 Python/3.13.14
6 6 @james:matrix.jamesst.one BLSFYMBGKR 1785110400000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.1 Python/3.13.14
7 7 @james:matrix.jamesst.one BLSFYMBGKR 1785196800000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.1 Python/3.13.14
8 8 @james:matrix.jamesst.one BLSFYMBGKR 1785283200000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.1 Python/3.13.14
9 9 @james:matrix.jamesst.one BLSFYMBGKR 1785715200000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.1 Python/3.13.14
10 10 @james:matrix.jamesst.one BLSFYMBGKR 1785801600000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.1 Python/3.13.14
11 11 @james:matrix.jamesst.one BLSFYMBGKR 1785888000000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.1 Python/3.13.14
12 12 @james:matrix.jamesst.one BLSFYMBGKR 1786147200000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.1 Python/3.13.14
13 13 @james:matrix.jamesst.one BLSFYMBGKR 1786233600000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.1 Python/3.13.14
14 14 @james:matrix.jamesst.one BLSFYMBGKR 1786320000000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.1 Python/3.13.14
15 15 @james:matrix.jamesst.one BLSFYMBGKR 1786406400000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.1 Python/3.13.14
16 16 @james:matrix.jamesst.one BLSFYMBGKR 1786492800000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.1 Python/3.13.14
17 17 @james:matrix.jamesst.one BLSFYMBGKR 1786579200000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.3 Python/3.13.14
18 18 @james:matrix.jamesst.one BLSFYMBGKR 1786665600000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.3 Python/3.13.14
19 19 @james:matrix.jamesst.one BLSFYMBGKR 1786752000000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.3 Python/3.13.14
20 20 @james:matrix.jamesst.one BLSFYMBGKR 1786838400000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.3 Python/3.13.14
21 21 @james:matrix.jamesst.one BLSFYMBGKR 1786924800000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.3 Python/3.13.14
22 22 @james:matrix.jamesst.one BLSFYMBGKR 1787011200000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.3 Python/3.13.14
23 23 @james:matrix.jamesst.one BLSFYMBGKR 1787097600000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.3 Python/3.13.14
24 24 @james:matrix.jamesst.one BLSFYMBGKR 1787184000000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.3 Python/3.13.14
25 25 @james:matrix.jamesst.one BLSFYMBGKR 1787270400000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.3 Python/3.13.14
26 26 @james:matrix.jamesst.one BLSFYMBGKR 1787356800000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.3 Python/3.13.14
27 27 @james:matrix.jamesst.one BLSFYMBGKR 1787443200000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.3 Python/3.13.14
28 28 @james:matrix.jamesst.one BLSFYMBGKR 1787529600000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.3 Python/3.13.14
29 29 @james:matrix.jamesst.one BLSFYMBGKR 1787616000000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.3 Python/3.13.14
30 30 @james:matrix.jamesst.one BLSFYMBGKR 1787702400000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.0 aiohttp/3.14.3 Python/3.13.14
31 31 @james:matrix.jamesst.one BLSFYMBGKR 1787788800000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.1 aiohttp/3.14.3 Python/3.13.15
32 32 @james:matrix.jamesst.one FQEGQAFPAE 1787788800000 curl/8.21.0
33 33 @james:matrix.jamesst.one GCKNIFMVHE 1787788800000 curl/8.21.0
34 34 @james:matrix.jamesst.one QFLPWPBVQG 1787788800000 curl/8.21.0
35 35 @james:matrix.jamesst.one SQNYUGEDGX 1787788800000 curl/8.21.0
36 36 @james:matrix.jamesst.one FQEGQAFPAE 1787875200000 matrix-rust-sdk
37 37 @james:matrix.jamesst.one BLSFYMBGKR 1787875200000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.1 aiohttp/3.14.3 Python/3.13.15
38 38 @james:matrix.jamesst.one SZXXSYDHEN 1787875200000 curl/8.21.0
39 39 @tmprecover:matrix.jamesst.one ERGSHGGFTY 1787875200000 Python-urllib/3.14
40 40 @james:matrix.jamesst.one HMCRCRAOHC 1787875200000 Mozilla/5.0 (X11; Linux x86_64; rv:154.0) Gecko/20100101 Firefox/154.0
41 41 @james:matrix.jamesst.one HMCRCRAOHC 1787961600000 Mozilla/5.0 (X11; Linux x86_64; rv:154.0) Gecko/20100101 Firefox/154.0
42 42 @james:matrix.jamesst.one SZXXSYDHEN 1787961600000 matrix-rust-sdk
43 43 @james:matrix.jamesst.one BLSFYMBGKR 1787961600000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.1 aiohttp/3.14.3 Python/3.13.15
44 44 @james:matrix.jamesst.one HMCRCRAOHC 1788048000000 Mozilla/5.0 (X11; Linux x86_64; rv:154.0) Gecko/20100101 Firefox/154.0
45 45 @james:matrix.jamesst.one SZXXSYDHEN 1788048000000 matrix-rust-sdk
46 46 @james:matrix.jamesst.one BLSFYMBGKR 1788048000000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.1 aiohttp/3.14.3 Python/3.13.15
47 47 @james:matrix.jamesst.one SZXXSYDHEN 1788134400000 curl/8.21.0
48 48 @james:matrix.jamesst.one BLSFYMBGKR 1788134400000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.1 aiohttp/3.14.3 Python/3.13.15
49 49 @james:matrix.jamesst.one BLSFYMBGKR 1788220800000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.1 aiohttp/3.14.3 Python/3.13.15
50 50 @james:matrix.jamesst.one SZXXSYDHEN 1788220800000 curl/8.21.0
51 51 @james:matrix.jamesst.one BLSFYMBGKR 1788307200000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.1 aiohttp/3.14.3 Python/3.13.15
52 52 @james:matrix.jamesst.one SZXXSYDHEN 1788307200000 curl/8.21.0
53 53 @james:matrix.jamesst.one SZXXSYDHEN 1788393600000 curl/8.21.0
54 54 @james:matrix.jamesst.one SZXXSYDHEN 1788480000000 curl/8.21.0
55 55 @james:matrix.jamesst.one BLSFYMBGKR 1788480000000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.1 aiohttp/3.14.3 Python/3.13.15
56 56 @james:matrix.jamesst.one SZXXSYDHEN 1788566400000 matrix-rust-sdk
57 57 @james:matrix.jamesst.one BLSFYMBGKR 1788566400000 mautrix-telegram/0.15.3+dev.unknown mautrix-python/0.21.1 aiohttp/3.14.3 Python/3.13.15
58 58 @james:matrix.jamesst.one SZXXSYDHEN 1788652800000 matrix-rust-sdk

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE user_daily_visits ( user_id TEXT NOT NULL, device_id TEXT, timestamp BIGINT NOT NULL , user_agent TEXT);
CREATE INDEX user_daily_visits_uts_idx ON user_daily_visits(user_id, timestamp);
CREATE INDEX user_daily_visits_ts_idx ON user_daily_visits(timestamp);