current_state_events

4,586 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, membership

Link rowid ▼ event_id room_id type state_key membership event_stream_ordering
1 1 $JAG47k-qAzqCYSdZiXFC7SM2d3SDkdiQxv1H4VE8q_c !vahPHWhsPlyBiaHXaN:matrix.jamesst.one m.room.create     2 2
2 2 $3hoqCxRfRzsBF15dGCBKp3q-y4G-E5ZO-GUHsgcbAk0 !vahPHWhsPlyBiaHXaN:matrix.jamesst.one m.room.member @james:matrix.jamesst.one join 3 3
3 3 $vV7k_zHy_mpKbpS7VYtlY88D6tX0PbWHitj5qyVlL7s !vahPHWhsPlyBiaHXaN:matrix.jamesst.one m.room.history_visibility     7 7
4 4 $84aYXfHxPPz1Gmc3EvudYv8-IxKPGvs60vHJhaaGI5k !vahPHWhsPlyBiaHXaN:matrix.jamesst.one m.room.guest_access     6 6
5 5 $sIINddDJF9lrgLugC9dwji3e_2UUGMbyd23xF3bQu6A !vahPHWhsPlyBiaHXaN:matrix.jamesst.one m.room.join_rules     5 5
6 6 $BLYdzLl0WsMZ2iAT1RTUgzOIYfkeFxuR1sCnApnViAM !vahPHWhsPlyBiaHXaN:matrix.jamesst.one m.room.power_levels     4 4
7 7 $9mxBManLkFBObtGi9FdwYG7eO_v01tlF-A8la21pipM !vahPHWhsPlyBiaHXaN:matrix.jamesst.one m.room.member @telegrambot:matrix.jamesst.one join 9 9
8 8 $KrdBWEG8G99qye9SRABj4TK9yXBV43mc8lYnQ_SWYJE !RrBJXVCuqleqRhuBDi:matrix.jamesst.one m.room.create     35 35
9 9 $iJUDpOXmkV8s7TFhaHOLD7wFZ94SiixHBiRHwNrAwas !RrBJXVCuqleqRhuBDi:matrix.jamesst.one m.room.member @james:matrix.jamesst.one join 36 36
10 10 $v9FfTve575WIVgkwC1k5eTucFJwxj_mZ5H8aXWreUp8 !RrBJXVCuqleqRhuBDi:matrix.jamesst.one m.room.history_visibility     40 40
11 11 $Is44-KnDM-5RYxpkTfcF99_ol_MSvdO5lixqMYnru3I !RrBJXVCuqleqRhuBDi:matrix.jamesst.one m.room.guest_access     39 39
12 12 $z5ckPBeGaumjSnrdWksb2p7B_Db19NEIpMUzKnjt3Qc !RrBJXVCuqleqRhuBDi:matrix.jamesst.one m.room.join_rules     38 38
13 13 $28ZwPuqX265_k5jtdeZrt8jXf45Bh-HcyFyRUwvSRuk !RrBJXVCuqleqRhuBDi:matrix.jamesst.one m.room.power_levels     37 37
14 14 $LL8p9X-ybSaQqHHZNyO8aqbB4Enpo4wZ_DibVXQOGuU !RrBJXVCuqleqRhuBDi:matrix.jamesst.one m.room.member @signalbot:matrix.jamesst.one join 42 42
15 15 $O11OZuiSE8oLpJ9H74wFKebZ-mPr_VoNxQSmQ6zinTs !XmPjsojWIDUGfbCOtX:matrix.jamesst.one m.room.create     57 57
16 16 $aoh0FF8_ZNC3eDB1CGTqvlvg--r_NF3WANpQ6yaD1SQ !tbPxpXHdNUSHVECIwW:matrix.jamesst.one m.room.create     58 58
17 17 $UM1N9CROrPqHm6VEbHwu2diyk2iPshM3xfmWbiFvR00 !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one m.room.create     59 59
18 18 $W94NYhIeT7gvlvC0IsyOHGnXRsQOna7UUgOAIobgvj4 !IqKjJhnnpxKUCjPExL:matrix.jamesst.one m.room.create     60 60
19 19 $Gh96cJOILwZ11izkgeE4zqC-DDff8U9GgTkX427hY2I !nwpxowRufBjawIIUqx:matrix.jamesst.one m.room.create     61 61
20 20 $jwLT6vhB3Tkw87GykWPCFBQfUyPYS5ryHCE6pSHbprY !kbmfiscAXROVNQrvhw:matrix.jamesst.one m.room.create     62 62
21 21 $wg81eaFDF57ZoWw_QRRXOe0XnJN-xuJ7nlaQDv2N-24 !XmPjsojWIDUGfbCOtX:matrix.jamesst.one m.room.member @telegrambot:matrix.jamesst.one join 63 63
22 22 $OpH23j_RrgQ94R4QcYLgmekjaaFylVF_j41lnLEVNBo !tbPxpXHdNUSHVECIwW:matrix.jamesst.one m.room.member @telegrambot:matrix.jamesst.one join 64 64
23 23 $3pMIcpTLR2hJuSn4KSPbOKNS7hOTO9uuRqIuv2L7rJg !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one m.room.member @telegrambot:matrix.jamesst.one join 65 65
24 24 $F617RSSjs22vCwI99ryYsoUAP7l_xyoa8x_Y8dpUPlk !IqKjJhnnpxKUCjPExL:matrix.jamesst.one m.room.member @telegrambot:matrix.jamesst.one join 66 66
25 25 $uuSk8AGXd4i4FqjxQyomVXlkaxK4Wlsc-tu8sRZlbNQ !nwpxowRufBjawIIUqx:matrix.jamesst.one m.room.member @telegrambot:matrix.jamesst.one join 67 67
26 26 $j2JcCWz_r-dn3OjEBF8Rl6jFmQ5c5m-Td9MNSu5h20Q !kbmfiscAXROVNQrvhw:matrix.jamesst.one m.room.member @telegrambot:matrix.jamesst.one join 68 68
27 27 $U-1kXh6xbhwYlkzFtNBnzhj8YJguGE7o7y2XfbGfY8A !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one m.room.create     69 69
28 28 $OqurQkNWh5GFT1-8igeY1cbkJPdFbr4jQqw_P-bWZnY !rLmxJOIqnIApSVZkgA:matrix.jamesst.one m.room.create     70 70
29 29 $4LPIW-SJ2bierZ38AzaK2ngwFmafN8bik7uEeB9JLno !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one m.room.create     71 71
30 30 $jBQ5rXuyAt2FOIFM4gn8Jr59uHjpcsZh_WNuZfgNbeo !UUvAhTKNjAWCZdiukW:matrix.jamesst.one m.room.create     72 72
31 31 $43Yv5h5lYGBGfuREV37MQI7sUKXZNvxBObO-DPwIstA !wHLxxSZsbnIQXhTiiU:matrix.jamesst.one m.room.create     73 73
32 32 $FcKvBjbXWiCs7bcM-6AfNIh6Z4wW0OL-BUo0OFhlGLU !XmPjsojWIDUGfbCOtX:matrix.jamesst.one m.room.name     80 80
33 33 $YJTENHjaxtkfJBI55_9uReDrrVtxQ3_T3cxXn8ER_VA !XmPjsojWIDUGfbCOtX:matrix.jamesst.one uk.half-shot.bridge net.maunium.telegram://telegram/1962347739   79 79
34 34 $4h62Js9g9PWGruYJQx3rlUMgxxSAX65N00fWq2nuVps !XmPjsojWIDUGfbCOtX:matrix.jamesst.one m.bridge net.maunium.telegram://telegram/1962347739   78 78
35 35 $Jpr48yHjtzabvE-mRGvBAY2WLujaipoisIOdfdebYaw !XmPjsojWIDUGfbCOtX:matrix.jamesst.one m.room.guest_access     77 77
36 36 $WZUHlc76h1siZzGhue4D72MS6SijkVdZX3rvcM1NjGE !XmPjsojWIDUGfbCOtX:matrix.jamesst.one m.room.history_visibility     76 76
37 37 $0TFO9Qk0aRvmD22r1QBXQQgKjgQiKNL2JYyhF6pEQDE !XmPjsojWIDUGfbCOtX:matrix.jamesst.one m.room.join_rules     75 75
38 38 $6PHO6P_uTy1s_mQ0_atjxhstD-S-3tX5QGJHf1FoKtU !XmPjsojWIDUGfbCOtX:matrix.jamesst.one m.room.power_levels     74 74
39 39 $FbEZF9ga6RoVbsKwZ7ProSNapkbKaUOWnPF4ZTmSg_8 !tbPxpXHdNUSHVECIwW:matrix.jamesst.one m.room.name     87 87
40 40 $fQgNk1BufEIhdZO2erwY7qXfNDLEmMmkh3ngvhoHnNk !tbPxpXHdNUSHVECIwW:matrix.jamesst.one uk.half-shot.bridge net.maunium.telegram://telegram/2312397340   86 86
41 41 $2cZwSmyPl2CxFOQQKkGF-J5aTH5URWdZAH2crjLbxkk !tbPxpXHdNUSHVECIwW:matrix.jamesst.one m.bridge net.maunium.telegram://telegram/2312397340   85 85
42 42 $ATdyqlt4pKXXfF5o-FhP0O-WL6wxdMtrtWp1gE95TTY !tbPxpXHdNUSHVECIwW:matrix.jamesst.one m.room.guest_access     84 84
43 43 $VZQLc_Bo1HdUpM2d5nRXiAEWTjiQOjSGn7DU-QSZGgs !tbPxpXHdNUSHVECIwW:matrix.jamesst.one m.room.history_visibility     83 83
44 44 $lYIeCgayBv8Jog11fNVH9gwAiT_pVsmh7rc8K7mW_gk !tbPxpXHdNUSHVECIwW:matrix.jamesst.one m.room.join_rules     82 82
45 45 $tLmZ2tNcxgEU5zs5NdlYeGLCK2PjevDXmML3lVW-nLU !tbPxpXHdNUSHVECIwW:matrix.jamesst.one m.room.power_levels     81 81
46 46 $IJlE7kcDTZ6hV7CsLWs3iPZ8099OU9K97pMO6krlTJA !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one m.room.name     94 94
47 47 $WqPI0wMW2b91_P-4ensnWzyLYpkJlCzl1b8WsY2KThE !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one uk.half-shot.bridge net.maunium.telegram://telegram/599958953   93 93
48 48 $Q9_ZH6iqqI6WVOjwccerrGWUK5iriUcB-MAoVVYT_j8 !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one m.bridge net.maunium.telegram://telegram/599958953   92 92
49 49 $gGLTvOnT8s3UPIkdgmchjXzl0XjUSjcfOPuF5oXIJws !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one m.room.guest_access     91 91
50 50 $peCoP18HYBroajXz_2MWSrHLYMhbVq61mLvWWpjlFA8 !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one m.room.history_visibility     90 90
51 51 $qa5mV17matTk-2vBBCyEXCaWo07Kklme3lsfmQ_Dm6s !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one m.room.join_rules     89 89
52 52 $JdIbFQsuhw7w-wcdAqvTDL8RLv7kCgXB9qsq7RNj_sM !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one m.room.power_levels     88 88
53 53 $d0_QiEETIjfn9N0N6ziJYTui0X3-L9i0kgTGRL4vVFw !IqKjJhnnpxKUCjPExL:matrix.jamesst.one m.room.name     101 101
54 54 $N9cOt_pksASWXhjt9sgWNJ-hr_Olcpbla6hd4xACcV8 !IqKjJhnnpxKUCjPExL:matrix.jamesst.one uk.half-shot.bridge net.maunium.telegram://telegram/343094868   100 100
55 55 $HwdvW_B33NQlq1j23jTHfaQ8vlze_XLtQjk2Fdsl2gQ !IqKjJhnnpxKUCjPExL:matrix.jamesst.one m.bridge net.maunium.telegram://telegram/343094868   99 99
56 56 $-Uf4xzOwUaJqqY-bwA9hluyEGR9F46HDIamyJebDL3E !IqKjJhnnpxKUCjPExL:matrix.jamesst.one m.room.guest_access     98 98
57 57 $mEm3_XZp_3MawkeoL4z1gOOpSPeNt7KbB43uwQ7uTWw !IqKjJhnnpxKUCjPExL:matrix.jamesst.one m.room.history_visibility     97 97
58 58 $KygLwKgpZ2SvuEK6NBta9SAjuHSowBsrh2QVlNLDZoY !IqKjJhnnpxKUCjPExL:matrix.jamesst.one m.room.join_rules     96 96
59 59 $E8aesz2-Vh6KiP388PrO0xZ_H39CVuhytb2rp98i67A !IqKjJhnnpxKUCjPExL:matrix.jamesst.one m.room.power_levels     95 95
60 60 $ZociRhnQFhayDkE27lF1IEsbUKSrerdMaNV0tvPk004 !nwpxowRufBjawIIUqx:matrix.jamesst.one m.room.name     108 108
61 61 $XMDhIJ23hju2kinDqhwCKEtc06bpSmuHZwfvlKtjVVY !nwpxowRufBjawIIUqx:matrix.jamesst.one uk.half-shot.bridge net.maunium.telegram://telegram/748181364   107 107
62 62 $7GfcicK8vCyYtVAKDys06q-2NWf6c8DdeMOCifXkFyE !nwpxowRufBjawIIUqx:matrix.jamesst.one m.bridge net.maunium.telegram://telegram/748181364   106 106
63 63 $UqchKE0RqPUw26AgShbvOr7RgxRm-I8ib3vfj1Kgoic !nwpxowRufBjawIIUqx:matrix.jamesst.one m.room.guest_access     105 105
64 64 $5AJdoOvel7V2C4WyK68pG408QPs2Mb3FGAWjBzh4jZs !nwpxowRufBjawIIUqx:matrix.jamesst.one m.room.history_visibility     104 104
65 65 $WxSSHu9EiOJTq7BCdm6lDBjgslVj7MMjtyZZaoyqVCk !nwpxowRufBjawIIUqx:matrix.jamesst.one m.room.join_rules     103 103
66 66 $a0uiht03gB8G7FtvqIFpDs9gjI1lkVvRnFnxzhETnog !nwpxowRufBjawIIUqx:matrix.jamesst.one m.room.power_levels     102 102
67 67 $qWYFMYxkp8n5wwhpbPBIMVDfb2hgC0ef1Jt475wXkMY !kbmfiscAXROVNQrvhw:matrix.jamesst.one m.room.name     115 115
68 68 $WO9XCQGMAkHJimciNzatEPzxSrowOtYbAot0Ae0ZOAg !kbmfiscAXROVNQrvhw:matrix.jamesst.one uk.half-shot.bridge net.maunium.telegram://telegram/923990709   114 114
69 69 $vlc24IXm_mrGsKQ-cqcypHBlBHuYYnmAdlKKOyO6ics !kbmfiscAXROVNQrvhw:matrix.jamesst.one m.bridge net.maunium.telegram://telegram/923990709   113 113
70 70 $ngp1BXDvlr7i1UKJZNj5awLMnffqBuXpLviUWGcgVyc !kbmfiscAXROVNQrvhw:matrix.jamesst.one m.room.guest_access     112 112
71 71 $xP6pnG5RFl9crGcYNMppfKpCYhGRT4riMD0Df88T-mI !kbmfiscAXROVNQrvhw:matrix.jamesst.one m.room.history_visibility     111 111
72 72 $epTQs9zeieGqX2o65g5qc_2lwjFXlbvsTGyfV7CnB84 !kbmfiscAXROVNQrvhw:matrix.jamesst.one m.room.join_rules     110 110
73 73 $D_VaHH2ufh-TB8K23JJvjGnQ8TIx1Y_JGNKMjakJWQo !kbmfiscAXROVNQrvhw:matrix.jamesst.one m.room.power_levels     109 109
74 74 $8SRjOXJoH4mN8aLa3Sz-rVyDX3KyN33kgY65FFlwPws !sbaLjvmTgcNwiUXJXQ:matrix.jamesst.one m.room.create     116 116
75 75 $5EUD5-MHpCTpf3hNa6WhE3eZ2nhLCpeZ173yMlgBrM8 !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one m.room.member @telegrambot:matrix.jamesst.one join 117 117
76 76 $T60UYkUtMbz6u8Gnw_nPMv8LsaxsW99SHaROOChvIjQ !rLmxJOIqnIApSVZkgA:matrix.jamesst.one m.room.member @telegrambot:matrix.jamesst.one join 118 118
77 77 $cTn-NmkmQzMxMd3_and2MyZ9-hLsQQUDz-BwWQLJK0w !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one m.room.member @telegrambot:matrix.jamesst.one join 119 119
78 78 $OpoUwfvOZNBAO8P7rR83O5R5be9sfPqbbmANl5J3SYM !UUvAhTKNjAWCZdiukW:matrix.jamesst.one m.room.member @telegrambot:matrix.jamesst.one join 120 120
79 79 $blTLJywpRQK2qn7h-GAfexjE_1gmzRUP91RmXFgnlQc !wHLxxSZsbnIQXhTiiU:matrix.jamesst.one m.room.member @telegrambot:matrix.jamesst.one join 121 121
85 85 $wmMQtPbPU7bRRLewe3vx3laZ3-yjezFqSkTExYVH_2M !sbaLjvmTgcNwiUXJXQ:matrix.jamesst.one m.room.member @telegrambot:matrix.jamesst.one join 127 127
87 87 $Yfasx22pVwjtL5UYV_c0aVZn7OBfL2oiKBFZBeOb_8c !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one m.room.name     135 135
88 88 $OsegchVKIOBzJWXdY1VDijVhXWBWbCfNUY7i8znfX7g !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one uk.half-shot.bridge net.maunium.telegram://telegram/492707818   134 134
89 89 $0nFyAXWi54-XXCv6sacVxZFBvXZIe72BnbuN4xX6KMY !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one m.bridge net.maunium.telegram://telegram/492707818   133 133
90 90 $YBOlKqB9OyORcasaxLL9BhmK29LxODus8hRDfkt3cTM !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one m.room.guest_access     132 132
91 91 $XqqlbrA1OVNd4NW3sbetXGBQ8pZz7SKk-vPi-h5xJMI !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one m.room.history_visibility     131 131
92 92 $Gr8aRT5ireYnYphS4zBt5vIhpWLqeQe-SNGHvv0u6hM !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one m.room.join_rules     130 130
93 93 $TdcmRwFrfhrCv6YPhBRoYS96CpaKIbP5pxpUkqSVZmc !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one m.room.power_levels     129 129
94 94 $ffnRdipJX7MXmi5q097JEN3zwGoP2YF7pXElLY-Q65U !rLmxJOIqnIApSVZkgA:matrix.jamesst.one m.room.name     142 142
95 95 $MKNeWNGpVlWXnZpWwc7yOzaZk5ArPTiQPES4tSP6bPY !rLmxJOIqnIApSVZkgA:matrix.jamesst.one uk.half-shot.bridge net.maunium.telegram://telegram/468290337   141 141
96 96 $MWotwXjHdHdopZ-aR3p3r-iY0YXf3t4eQTz6UcBmgGk !rLmxJOIqnIApSVZkgA:matrix.jamesst.one m.bridge net.maunium.telegram://telegram/468290337   140 140
97 97 $ny05XphUy6zsrmIfpAMDEZY_bJR_aVhcOnEJCfNAt8k !rLmxJOIqnIApSVZkgA:matrix.jamesst.one m.room.guest_access     139 139
98 98 $1U_Qe2PQTRfDHwTZxjGF-saDDmrBka3JyylvU_5L_F4 !rLmxJOIqnIApSVZkgA:matrix.jamesst.one m.room.history_visibility     138 138
99 99 $hWjRsIRMrNb1C24-U3cIZ2_OfVJw9Z51YAkgxNtWbhA !rLmxJOIqnIApSVZkgA:matrix.jamesst.one m.room.join_rules     137 137
100 100 $YgKQuMi6AtmIQiblFeHOYwO4EF2BZbaBW6IyfKu7EzQ !rLmxJOIqnIApSVZkgA:matrix.jamesst.one m.room.power_levels     136 136
101 101 $ja8ySEmLPD2kkwBJjBmdeu735wYeqdcqw-tY062H3jI !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one m.room.name     149 149
102 102 $4zwHwKdxzITe6URlr_XrKmTG6rk64JecT6Y2iwlBt8k !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one uk.half-shot.bridge net.maunium.telegram://telegram/592647955   148 148
103 103 $JMidr3aTrdb_ucOZIkR1dT-BVfCfTr8MWF50XGlbWZE !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one m.bridge net.maunium.telegram://telegram/592647955   147 147
104 104 $1Vm-rCgau1Lbur01W_HJjVY5-HtmHnVwbS2NOkXzJvs !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one m.room.guest_access     146 146
105 105 $oJBLQIQBS903j8rUgEkGbJTr6gS5Zm7EXnRoZT0h3bY !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one m.room.history_visibility     145 145
106 106 $iFhH6S1tAfbXqqkBYC8AhEBneL9Gt_9pYfBp91Iq2SE !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one m.room.join_rules     144 144

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE current_state_events( event_id TEXT NOT NULL, room_id TEXT NOT NULL, type TEXT NOT NULL, state_key TEXT NOT NULL, membership TEXT, event_stream_ordering BIGINT REFERENCES events(stream_ordering), UNIQUE (event_id), UNIQUE (room_id, type, state_key) );
CREATE INDEX current_state_events_member_index ON current_state_events (state_key) WHERE type='m.room.member';
CREATE INDEX current_state_events_stream_ordering_idx ON current_state_events (event_stream_ordering) ;
CREATE INDEX current_state_events_members_room_index ON current_state_events (room_id, membership) WHERE type='m.room.member';