room_stats_state

292 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: history_visibility, topic

Link rowid ▼ room_id name canonical_alias join_rules history_visibility encryption avatar guest_access is_federatable topic room_type
1 1 !vahPHWhsPlyBiaHXaN:matrix.jamesst.one     invite invited     can_join 1    
2 2 !RrBJXVCuqleqRhuBDi:matrix.jamesst.one     invite invited     can_join 1    
3 3 !XmPjsojWIDUGfbCOtX:matrix.jamesst.one JS Group   invite shared     can_join 1    
4 4 !tbPxpXHdNUSHVECIwW:matrix.jamesst.one JS   invite shared     can_join 1    
5 5 !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one JBC   invite shared     can_join 1    
6 6 !IqKjJhnnpxKUCjPExL:matrix.jamesst.one Parents   invite shared     can_join 1    
7 7 !nwpxowRufBjawIIUqx:matrix.jamesst.one JBC   invite shared     can_join 1    
8 8 !kbmfiscAXROVNQrvhw:matrix.jamesst.one James & Benjamin Stone, Trish Stone   invite shared     can_join 1    
9 9 !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one JBC   invite shared     can_join 1    
10 10 !rLmxJOIqnIApSVZkgA:matrix.jamesst.one JBC   invite shared     can_join 1    
11 11 !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one J and B   invite shared     can_join 1    
12 12 !UUvAhTKNjAWCZdiukW:matrix.jamesst.one Hello   invite shared     can_join 1    
13 13 !wHLxxSZsbnIQXhTiiU:matrix.jamesst.one MTJ   invite shared     can_join 1    
14 14 !sbaLjvmTgcNwiUXJXQ:matrix.jamesst.one Stones   invite shared   mxc://matrix.jamesst.one/vMccgilVwQfKijmfVDzNOYWW can_join 1    
15 15 !TuuVfHAWQDmtlxZyTc:matrix.jamesst.one Telegram Tips #telegram_TelegramTips:matrix.jamesst.one invite shared   mxc://matrix.jamesst.one/enjsNAHEDfEgZUZvolSzSGPt can_join 1    
16 16 !HenNzFPhosZJtuised:matrix.jamesst.one Telegram Contests #telegram_contest:matrix.jamesst.one invite shared   mxc://matrix.jamesst.one/ukiDnxhQgoBzRCWmWQYDMJSH can_join 1    
17 17 !UJqzdqWCbSZOHNGKko:matrix.jamesst.one BotNews #telegram_BotNews:matrix.jamesst.one invite shared   mxc://matrix.jamesst.one/iwTIIIKQyCPNOhwIQVFROFkK can_join 1    
18 18 !FMIBicfcNbhIoPeYcL:matrix.jamesst.one     invite invited     can_join 1    
19 19 !BlgOiSpdKGmaXVClci:matrix.jamesst.one     invite invited     can_join 1    
20 20 !YuTkIZfXxcPwXTVVSR:matrix.jamesst.one tradsasiasoftware   invite shared   mxc://matrix.jamesst.one/sJTOcXEOfwMaSxgRqJtcqiPx can_join 1   m.space
21 21 !paEYvyghpqtUQhrPNa:matrix.jamesst.one Slackbot   invite shared   mxc://matrix.jamesst.one/ghfrHFahYOyQpnIzwHGkjIay can_join 1    
22 22 !BKJJFinmkAqADXNazP:matrix.jamesst.one Outlook Calendar (bot)   invite shared   mxc://matrix.jamesst.one/sKlvZivwaopPQJexfDIOoXrg can_join 1    
23 23 !KZxzXOwrTpPPiMOFhu:matrix.jamesst.one Slack   invite shared   mxc://matrix.jamesst.one/OiUTGQDttGYiOJssBCXVgmLm can_join 1    
24 24 !ElgDfrMJYslEdyrFht:matrix.jamesst.one James Stone (you)   invite shared     can_join 1    
25 25 !oCiWUELXBrnJJEOfHN:matrix.jamesst.one Koji, joey, dylan   invite shared     can_join 1    
26 26 !IDVzmHGTigaDkLInhb:matrix.jamesst.one naphdlr, ab, Hubert, brian.yu, timtsoi   invite shared     can_join 1    
27 27 !SYcYAciaPLevjjQelT:matrix.jamesst.one naphdlr, ab, Hubert, graceful, brian.yu, lyndon   invite shared     can_join 1    
28 28 !AjmuzElxFNgRRZQNoQ:matrix.jamesst.one wade   invite shared   mxc://matrix.jamesst.one/tQyYIATWJxiTHBukBQXAJMoF can_join 1    
29 29 !nmtFIaWniwOuEEsZPI:matrix.jamesst.one timtsoi   invite shared   mxc://matrix.jamesst.one/iJNEdyflowsdAEzAEkkCsNED can_join 1    
30 30 !KmpLRLsyyaPdUYdMHb:matrix.jamesst.one Yoda.cm   invite shared   mxc://matrix.jamesst.one/xzjJzCPGMpRzNOrurlQulPHk can_join 1    
31 31 !kKtScliyhdpXGYJoyR:matrix.jamesst.one Graham Little, Gokhan Ozman   invite shared     can_join 1    
32 32 !LxWwgtpXTQVjcFMgkb:matrix.jamesst.one Daniel M   invite shared   mxc://matrix.jamesst.one/xyeifUoGrLMfPZCVHwoFDuDV can_join 1    
33 33 !AqEkmqWBtPNnPrufwA:matrix.jamesst.one Luis   invite shared   mxc://matrix.jamesst.one/YtCRgdThGqHOPYhPnFacPAQp can_join 1    
34 34 !EHdkQWRkfptmqktyaP:matrix.jamesst.one Lawz   invite shared   mxc://matrix.jamesst.one/IVoksyKNeIjguYIcPLdQUAfF can_join 1    
35 35 !nJVpZYntXuvRnsxkfR:matrix.jamesst.one Joe, Luis, Lawz   invite shared     can_join 1    
36 36 !hqiiyckjNGemPGuALY:matrix.jamesst.one Jimmy   invite shared   mxc://matrix.jamesst.one/CuBCncqpmscaEZCbOJpMySEU can_join 1    
37 37 !qgdrlnxfxQUvpxZdQB:matrix.jamesst.one Jira Slack App (bot)   invite shared   mxc://matrix.jamesst.one/rYwPlBOcKLMtMhahYThCHgqJ can_join 1    
38 38 !wtqlekpwOtgIKIzUye:matrix.jamesst.one Evren Atesalp   invite shared   mxc://matrix.jamesst.one/abAPGzocvNCuUaTAnmHEGSDo can_join 1    
39 39 !SHlOLhRmKSJrdjtNGQ:matrix.jamesst.one Hubert   invite shared   mxc://matrix.jamesst.one/ctQzOTmjmIjAJtgJWJZZTtei can_join 1    
40 40 !hsifellATWsMazXlZA:matrix.jamesst.one ab, joey, lyndon   invite shared     can_join 1    
41 41 !zmsygXhOAWGjoosiDX:matrix.jamesst.one ab   invite shared   mxc://matrix.jamesst.one/jonWyUjCMXAQTDOvMPzHRPXQ can_join 1    
42 42 !cBhJppwGOsWgjyoOQQ:matrix.jamesst.one dom.cm   invite shared   mxc://matrix.jamesst.one/DuSqmoTyDQVksEHoMvIDHBuF can_join 1    
43 43 !PhFBDVEcLtoQxmvPSL:matrix.jamesst.one #general   invite shared     can_join 1 Company-wide announcements and work-based matters  
44 44 !RhMgvAPjLANRigRiwG:matrix.jamesst.one spain-meeting-2024   invite shared     can_join 1    
45 45 !HPNcDxTDpUhwcvGFdW:matrix.jamesst.one st5-compare   invite shared     can_join 1    
46 46 !BcXnWMtRzAnQcBRJTw:matrix.jamesst.one utc-whiteboard-product-management   invite shared     can_join 1    
47 47 !OmcewBHpqinKaAilnV:matrix.jamesst.one js-notes   invite shared     can_join 1    
48 48 !RppQZemJMBraLoZloF:matrix.jamesst.one istanbul-in-may   invite shared     can_join 1    
49 49 !foAyKLHyzufIEbwwSe:matrix.jamesst.one uwbfx-test-alerts   invite shared     can_join 1    
50 50 !aamIUwRMpqoTVlOgYQ:matrix.jamesst.one uwbfx-uat-alerts   invite shared     can_join 1    
51 51 !CCUfAhwGFDisuRJodI:matrix.jamesst.one mono-repo-poc   invite shared     can_join 1    
52 52 !LFSjGRgyyAkgpjNvAb:matrix.jamesst.one reginfra_techops_ab_jamestone_and_toy   invite shared     can_join 1    
53 53 !qvoVrGJcqwQNByFOEN:matrix.jamesst.one engineering_ws_2026   invite shared     can_join 1    
54 54 !eBeCUKvENXfhbabruT:matrix.jamesst.one utcfiweb-brokerview-dev   invite shared     can_join 1    
55 55 !EPVYpFNKdwGOfQMZAX:matrix.jamesst.one utc-rates-triage   invite shared     can_join 1    
56 56 !PnXREEvNVetwkGeBIs:matrix.jamesst.one archimedes-dev   invite shared     can_join 1    
57 57 !yxbThaYKFwytwfTQvk:matrix.jamesst.one test-envs-discussion   invite shared     can_join 1    
58 58 !LZlkjmrdSOMzgPpPqy:matrix.jamesst.one utc-whiteboard-alerts   invite shared     can_join 1    
59 59 !XZFtQhrqfLCWoxgfSJ:matrix.jamesst.one uwbfx-alerts   invite shared     can_join 1    
60 60 !sgEZZpQpuFtdiFsFMC:matrix.jamesst.one los-tipos   invite shared     can_join 1    
61 61 !ntXkRSKLIKQFraHJeN:matrix.jamesst.one utc-rates-support   invite shared     can_join 1    
62 62 !fPsqjzGHwgYnxalknv:matrix.jamesst.one osm-2025   invite shared     can_join 1    
63 63 !uRnFxrbHPsJQFQCPlN:matrix.jamesst.one dates-holidays-dev   invite shared     can_join 1    
64 64 !bktOHXBDnXeULtnHFU:matrix.jamesst.one whiteboard-test-uat-alerts   invite shared     can_join 1    
65 65 !CYeFMUQdkRwYBPsJnG:matrix.jamesst.one whiteboard-live-alerts   invite shared     can_join 1    
66 66 !WduVSZDYiVatmJEpnC:matrix.jamesst.one uwbfx-ci   invite shared     can_join 1    
67 67 !olJILpOTaMZbhdcmfR:matrix.jamesst.one utc-data-dev   invite shared     can_join 1    
68 68 !FpRlcAsEEExygBcroU:matrix.jamesst.one trad-expense-dev   invite shared     can_join 1    
69 69 !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one swaptrader-dev   invite shared     can_join 1    
70 70 !cvUIlXzvPEzfCASNVJ:matrix.jamesst.one utc-rates-ci   invite shared     can_join 1    
71 71 !jgxuOOeYeaKhiVtsvV:matrix.jamesst.one utc-rates-dev   invite shared     can_join 1    
72 72 !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one utc-whiteboard-dev   invite shared     can_join 1    
73 73 !ldxjkhrGSKwWaPWeSG:matrix.jamesst.one frontend-news   invite shared     can_join 1    
74 74 !fjpoKrgAqQTQibxaFV:matrix.jamesst.one utc-rates-live-alerts   invite shared     can_join 1    
75 75 !cUqOYXLBrRkRNLvBpt:matrix.jamesst.one utc-rates-product   invite shared     can_join 1    
76 76 !AjfUojluHjlirKHHqd:matrix.jamesst.one swaptrader   invite shared     can_join 1    
77 77 !yUNReqWYCGqSXsSlsy:matrix.jamesst.one utc-fi-product   invite shared     can_join 1    
78 78 !yNPxFvVFgRPlbgenmk:matrix.jamesst.one utc-whiteboard   invite shared     can_join 1    
79 79 !vzovkrujIWfWMwFwpA:matrix.jamesst.one utc-rates-alerts   invite shared     can_join 1    
80 80 !suQToHdNQPybSkmmNY:matrix.jamesst.one devops-flexi   invite shared     can_join 1    
81 81 !lTPdEfjbFsCQXebAlR:matrix.jamesst.one utc-rates-git   invite shared     can_join 1    
82 82 !lvdngYYyOuGxmaDcpE:matrix.jamesst.one utc-whiteboard-ci   invite shared     can_join 1    
83 83 !ePKcZONpyuhkyfNOLT:matrix.jamesst.one swaptrader-ci   invite shared     can_join 1    
84 84 !sRPmcdramfDPFjlOkj:matrix.jamesst.one softdevmanagers   invite shared     can_join 1    
85 85 !MlIdLmkJzcdLJKZnjs:matrix.jamesst.one utc-rates-uat-alerts   invite shared     can_join 1    
86 86 !XtCUcaKdYOaHKrbYXT:matrix.jamesst.one utcr-cm24   invite shared     can_join 1    
87 87 !CfUJyBcMuMCEOnOSFP:matrix.jamesst.one     invite shared     can_join 1 Your Telegram cloud storage chat  
88 88 !neIgyUJkyRiaQaXzcw:matrix.jamesst.one     invite shared     can_join 1    
89 89 !XRCQHojzxCcjgbKOLw:matrix.jamesst.one     invite shared     can_join 1    
90 90 !lIbMVjkLhcXAfrAtZB:matrix.jamesst.one     invite shared     can_join 1    
91 91 !RiITgghWaCJrZpdhGY:matrix.jamesst.one     invite shared     can_join 1    
92 92 !IHzRTufcvGfePdToKA:matrix.jamesst.one     invite shared     can_join 1    
93 93 !LoaBXycKruHTVYwHMK:matrix.jamesst.one     invite shared     can_join 1    
94 94 !HWuWNIcNvuPljbAvTv:matrix.jamesst.one     invite shared     can_join 1    
95 95 !LLVqSvDhKCOgKIJcES:matrix.jamesst.one     invite shared     can_join 1    
96 96 !YlcHPAHpjHJWuasoUv:matrix.jamesst.one     invite shared     can_join 1    
97 97 !CcWOicpsftjEucFZEn:matrix.jamesst.one     invite shared     can_join 1    
98 98 !XtdPnFKTQFwzmZwTzj:matrix.jamesst.one     invite shared     can_join 1    
99 99 !WJlPoeKXRzHLhwUIyO:matrix.jamesst.one     invite shared     can_join 1    
100 100 !eEZFSbeyIQnTNNbQpI:matrix.jamesst.one     invite shared     can_join 1    

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE room_stats_state (
    room_id TEXT NOT NULL,
    name TEXT,
    canonical_alias TEXT,
    join_rules TEXT,
    history_visibility TEXT,
    encryption TEXT,
    avatar TEXT,
    guest_access TEXT,
    is_federatable BOOLEAN,
    topic TEXT
, room_type TEXT);
CREATE UNIQUE INDEX room_stats_state_room ON room_stats_state(room_id);