state_events
5,877 rows
This data as json, CSV (advanced)
Suggested facets: type
| Link | rowid ▼ | event_id | room_id | type | state_key | prev_state |
|---|---|---|---|---|---|---|
| 1 | 1 | $JAG47k-qAzqCYSdZiXFC7SM2d3SDkdiQxv1H4VE8q_c | !vahPHWhsPlyBiaHXaN:matrix.jamesst.one | m.room.create | ||
| 2 | 2 | $3hoqCxRfRzsBF15dGCBKp3q-y4G-E5ZO-GUHsgcbAk0 | !vahPHWhsPlyBiaHXaN:matrix.jamesst.one | m.room.member | @james:matrix.jamesst.one | |
| 3 | 3 | $BLYdzLl0WsMZ2iAT1RTUgzOIYfkeFxuR1sCnApnViAM | !vahPHWhsPlyBiaHXaN:matrix.jamesst.one | m.room.power_levels | ||
| 4 | 4 | $sIINddDJF9lrgLugC9dwji3e_2UUGMbyd23xF3bQu6A | !vahPHWhsPlyBiaHXaN:matrix.jamesst.one | m.room.join_rules | ||
| 5 | 5 | $84aYXfHxPPz1Gmc3EvudYv8-IxKPGvs60vHJhaaGI5k | !vahPHWhsPlyBiaHXaN:matrix.jamesst.one | m.room.guest_access | ||
| 6 | 6 | $vV7k_zHy_mpKbpS7VYtlY88D6tX0PbWHitj5qyVlL7s | !vahPHWhsPlyBiaHXaN:matrix.jamesst.one | m.room.history_visibility | ||
| 7 | 7 | $sPTWdHHV6DOUiYt8I5A7aYF_eiNlo7Ae3UPXHEtqcuo | !vahPHWhsPlyBiaHXaN:matrix.jamesst.one | m.room.member | @telegrambot:matrix.jamesst.one | |
| 8 | 8 | $9mxBManLkFBObtGi9FdwYG7eO_v01tlF-A8la21pipM | !vahPHWhsPlyBiaHXaN:matrix.jamesst.one | m.room.member | @telegrambot:matrix.jamesst.one | |
| 9 | 9 | $KrdBWEG8G99qye9SRABj4TK9yXBV43mc8lYnQ_SWYJE | !RrBJXVCuqleqRhuBDi:matrix.jamesst.one | m.room.create | ||
| 10 | 10 | $iJUDpOXmkV8s7TFhaHOLD7wFZ94SiixHBiRHwNrAwas | !RrBJXVCuqleqRhuBDi:matrix.jamesst.one | m.room.member | @james:matrix.jamesst.one | |
| 11 | 11 | $28ZwPuqX265_k5jtdeZrt8jXf45Bh-HcyFyRUwvSRuk | !RrBJXVCuqleqRhuBDi:matrix.jamesst.one | m.room.power_levels | ||
| 12 | 12 | $z5ckPBeGaumjSnrdWksb2p7B_Db19NEIpMUzKnjt3Qc | !RrBJXVCuqleqRhuBDi:matrix.jamesst.one | m.room.join_rules | ||
| 13 | 13 | $Is44-KnDM-5RYxpkTfcF99_ol_MSvdO5lixqMYnru3I | !RrBJXVCuqleqRhuBDi:matrix.jamesst.one | m.room.guest_access | ||
| 14 | 14 | $v9FfTve575WIVgkwC1k5eTucFJwxj_mZ5H8aXWreUp8 | !RrBJXVCuqleqRhuBDi:matrix.jamesst.one | m.room.history_visibility | ||
| 15 | 15 | $06ErXW4A-mPAz4AXDlbNlsW5gnbETzvkd_mgPvTprok | !RrBJXVCuqleqRhuBDi:matrix.jamesst.one | m.room.member | @signalbot:matrix.jamesst.one | |
| 16 | 16 | $LL8p9X-ybSaQqHHZNyO8aqbB4Enpo4wZ_DibVXQOGuU | !RrBJXVCuqleqRhuBDi:matrix.jamesst.one | m.room.member | @signalbot:matrix.jamesst.one | |
| 17 | 17 | $O11OZuiSE8oLpJ9H74wFKebZ-mPr_VoNxQSmQ6zinTs | !XmPjsojWIDUGfbCOtX:matrix.jamesst.one | m.room.create | ||
| 18 | 18 | $aoh0FF8_ZNC3eDB1CGTqvlvg--r_NF3WANpQ6yaD1SQ | !tbPxpXHdNUSHVECIwW:matrix.jamesst.one | m.room.create | ||
| 19 | 19 | $UM1N9CROrPqHm6VEbHwu2diyk2iPshM3xfmWbiFvR00 | !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one | m.room.create | ||
| 20 | 20 | $W94NYhIeT7gvlvC0IsyOHGnXRsQOna7UUgOAIobgvj4 | !IqKjJhnnpxKUCjPExL:matrix.jamesst.one | m.room.create | ||
| 21 | 21 | $Gh96cJOILwZ11izkgeE4zqC-DDff8U9GgTkX427hY2I | !nwpxowRufBjawIIUqx:matrix.jamesst.one | m.room.create | ||
| 22 | 22 | $jwLT6vhB3Tkw87GykWPCFBQfUyPYS5ryHCE6pSHbprY | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | m.room.create | ||
| 23 | 23 | $wg81eaFDF57ZoWw_QRRXOe0XnJN-xuJ7nlaQDv2N-24 | !XmPjsojWIDUGfbCOtX:matrix.jamesst.one | m.room.member | @telegrambot:matrix.jamesst.one | |
| 24 | 24 | $OpH23j_RrgQ94R4QcYLgmekjaaFylVF_j41lnLEVNBo | !tbPxpXHdNUSHVECIwW:matrix.jamesst.one | m.room.member | @telegrambot:matrix.jamesst.one | |
| 25 | 25 | $3pMIcpTLR2hJuSn4KSPbOKNS7hOTO9uuRqIuv2L7rJg | !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one | m.room.member | @telegrambot:matrix.jamesst.one | |
| 26 | 26 | $F617RSSjs22vCwI99ryYsoUAP7l_xyoa8x_Y8dpUPlk | !IqKjJhnnpxKUCjPExL:matrix.jamesst.one | m.room.member | @telegrambot:matrix.jamesst.one | |
| 27 | 27 | $uuSk8AGXd4i4FqjxQyomVXlkaxK4Wlsc-tu8sRZlbNQ | !nwpxowRufBjawIIUqx:matrix.jamesst.one | m.room.member | @telegrambot:matrix.jamesst.one | |
| 28 | 28 | $j2JcCWz_r-dn3OjEBF8Rl6jFmQ5c5m-Td9MNSu5h20Q | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | m.room.member | @telegrambot:matrix.jamesst.one | |
| 29 | 29 | $U-1kXh6xbhwYlkzFtNBnzhj8YJguGE7o7y2XfbGfY8A | !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one | m.room.create | ||
| 30 | 30 | $OqurQkNWh5GFT1-8igeY1cbkJPdFbr4jQqw_P-bWZnY | !rLmxJOIqnIApSVZkgA:matrix.jamesst.one | m.room.create | ||
| 31 | 31 | $4LPIW-SJ2bierZ38AzaK2ngwFmafN8bik7uEeB9JLno | !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one | m.room.create | ||
| 32 | 32 | $jBQ5rXuyAt2FOIFM4gn8Jr59uHjpcsZh_WNuZfgNbeo | !UUvAhTKNjAWCZdiukW:matrix.jamesst.one | m.room.create | ||
| 33 | 33 | $43Yv5h5lYGBGfuREV37MQI7sUKXZNvxBObO-DPwIstA | !wHLxxSZsbnIQXhTiiU:matrix.jamesst.one | m.room.create | ||
| 34 | 34 | $6PHO6P_uTy1s_mQ0_atjxhstD-S-3tX5QGJHf1FoKtU | !XmPjsojWIDUGfbCOtX:matrix.jamesst.one | m.room.power_levels | ||
| 35 | 35 | $0TFO9Qk0aRvmD22r1QBXQQgKjgQiKNL2JYyhF6pEQDE | !XmPjsojWIDUGfbCOtX:matrix.jamesst.one | m.room.join_rules | ||
| 36 | 36 | $WZUHlc76h1siZzGhue4D72MS6SijkVdZX3rvcM1NjGE | !XmPjsojWIDUGfbCOtX:matrix.jamesst.one | m.room.history_visibility | ||
| 37 | 37 | $Jpr48yHjtzabvE-mRGvBAY2WLujaipoisIOdfdebYaw | !XmPjsojWIDUGfbCOtX:matrix.jamesst.one | m.room.guest_access | ||
| 38 | 38 | $4h62Js9g9PWGruYJQx3rlUMgxxSAX65N00fWq2nuVps | !XmPjsojWIDUGfbCOtX:matrix.jamesst.one | m.bridge | net.maunium.telegram://telegram/1962347739 | |
| 39 | 39 | $YJTENHjaxtkfJBI55_9uReDrrVtxQ3_T3cxXn8ER_VA | !XmPjsojWIDUGfbCOtX:matrix.jamesst.one | uk.half-shot.bridge | net.maunium.telegram://telegram/1962347739 | |
| 40 | 40 | $FcKvBjbXWiCs7bcM-6AfNIh6Z4wW0OL-BUo0OFhlGLU | !XmPjsojWIDUGfbCOtX:matrix.jamesst.one | m.room.name | ||
| 41 | 41 | $tLmZ2tNcxgEU5zs5NdlYeGLCK2PjevDXmML3lVW-nLU | !tbPxpXHdNUSHVECIwW:matrix.jamesst.one | m.room.power_levels | ||
| 42 | 42 | $lYIeCgayBv8Jog11fNVH9gwAiT_pVsmh7rc8K7mW_gk | !tbPxpXHdNUSHVECIwW:matrix.jamesst.one | m.room.join_rules | ||
| 43 | 43 | $VZQLc_Bo1HdUpM2d5nRXiAEWTjiQOjSGn7DU-QSZGgs | !tbPxpXHdNUSHVECIwW:matrix.jamesst.one | m.room.history_visibility | ||
| 44 | 44 | $ATdyqlt4pKXXfF5o-FhP0O-WL6wxdMtrtWp1gE95TTY | !tbPxpXHdNUSHVECIwW:matrix.jamesst.one | m.room.guest_access | ||
| 45 | 45 | $2cZwSmyPl2CxFOQQKkGF-J5aTH5URWdZAH2crjLbxkk | !tbPxpXHdNUSHVECIwW:matrix.jamesst.one | m.bridge | net.maunium.telegram://telegram/2312397340 | |
| 46 | 46 | $fQgNk1BufEIhdZO2erwY7qXfNDLEmMmkh3ngvhoHnNk | !tbPxpXHdNUSHVECIwW:matrix.jamesst.one | uk.half-shot.bridge | net.maunium.telegram://telegram/2312397340 | |
| 47 | 47 | $FbEZF9ga6RoVbsKwZ7ProSNapkbKaUOWnPF4ZTmSg_8 | !tbPxpXHdNUSHVECIwW:matrix.jamesst.one | m.room.name | ||
| 48 | 48 | $JdIbFQsuhw7w-wcdAqvTDL8RLv7kCgXB9qsq7RNj_sM | !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one | m.room.power_levels | ||
| 49 | 49 | $qa5mV17matTk-2vBBCyEXCaWo07Kklme3lsfmQ_Dm6s | !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one | m.room.join_rules | ||
| 50 | 50 | $peCoP18HYBroajXz_2MWSrHLYMhbVq61mLvWWpjlFA8 | !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one | m.room.history_visibility | ||
| 51 | 51 | $gGLTvOnT8s3UPIkdgmchjXzl0XjUSjcfOPuF5oXIJws | !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one | m.room.guest_access | ||
| 52 | 52 | $Q9_ZH6iqqI6WVOjwccerrGWUK5iriUcB-MAoVVYT_j8 | !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one | m.bridge | net.maunium.telegram://telegram/599958953 | |
| 53 | 53 | $WqPI0wMW2b91_P-4ensnWzyLYpkJlCzl1b8WsY2KThE | !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one | uk.half-shot.bridge | net.maunium.telegram://telegram/599958953 | |
| 54 | 54 | $IJlE7kcDTZ6hV7CsLWs3iPZ8099OU9K97pMO6krlTJA | !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one | m.room.name | ||
| 55 | 55 | $E8aesz2-Vh6KiP388PrO0xZ_H39CVuhytb2rp98i67A | !IqKjJhnnpxKUCjPExL:matrix.jamesst.one | m.room.power_levels | ||
| 56 | 56 | $KygLwKgpZ2SvuEK6NBta9SAjuHSowBsrh2QVlNLDZoY | !IqKjJhnnpxKUCjPExL:matrix.jamesst.one | m.room.join_rules | ||
| 57 | 57 | $mEm3_XZp_3MawkeoL4z1gOOpSPeNt7KbB43uwQ7uTWw | !IqKjJhnnpxKUCjPExL:matrix.jamesst.one | m.room.history_visibility | ||
| 58 | 58 | $-Uf4xzOwUaJqqY-bwA9hluyEGR9F46HDIamyJebDL3E | !IqKjJhnnpxKUCjPExL:matrix.jamesst.one | m.room.guest_access | ||
| 59 | 59 | $HwdvW_B33NQlq1j23jTHfaQ8vlze_XLtQjk2Fdsl2gQ | !IqKjJhnnpxKUCjPExL:matrix.jamesst.one | m.bridge | net.maunium.telegram://telegram/343094868 | |
| 60 | 60 | $N9cOt_pksASWXhjt9sgWNJ-hr_Olcpbla6hd4xACcV8 | !IqKjJhnnpxKUCjPExL:matrix.jamesst.one | uk.half-shot.bridge | net.maunium.telegram://telegram/343094868 | |
| 61 | 61 | $d0_QiEETIjfn9N0N6ziJYTui0X3-L9i0kgTGRL4vVFw | !IqKjJhnnpxKUCjPExL:matrix.jamesst.one | m.room.name | ||
| 62 | 62 | $a0uiht03gB8G7FtvqIFpDs9gjI1lkVvRnFnxzhETnog | !nwpxowRufBjawIIUqx:matrix.jamesst.one | m.room.power_levels | ||
| 63 | 63 | $WxSSHu9EiOJTq7BCdm6lDBjgslVj7MMjtyZZaoyqVCk | !nwpxowRufBjawIIUqx:matrix.jamesst.one | m.room.join_rules | ||
| 64 | 64 | $5AJdoOvel7V2C4WyK68pG408QPs2Mb3FGAWjBzh4jZs | !nwpxowRufBjawIIUqx:matrix.jamesst.one | m.room.history_visibility | ||
| 65 | 65 | $UqchKE0RqPUw26AgShbvOr7RgxRm-I8ib3vfj1Kgoic | !nwpxowRufBjawIIUqx:matrix.jamesst.one | m.room.guest_access | ||
| 66 | 66 | $7GfcicK8vCyYtVAKDys06q-2NWf6c8DdeMOCifXkFyE | !nwpxowRufBjawIIUqx:matrix.jamesst.one | m.bridge | net.maunium.telegram://telegram/748181364 | |
| 67 | 67 | $XMDhIJ23hju2kinDqhwCKEtc06bpSmuHZwfvlKtjVVY | !nwpxowRufBjawIIUqx:matrix.jamesst.one | uk.half-shot.bridge | net.maunium.telegram://telegram/748181364 | |
| 68 | 68 | $ZociRhnQFhayDkE27lF1IEsbUKSrerdMaNV0tvPk004 | !nwpxowRufBjawIIUqx:matrix.jamesst.one | m.room.name | ||
| 69 | 69 | $D_VaHH2ufh-TB8K23JJvjGnQ8TIx1Y_JGNKMjakJWQo | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | m.room.power_levels | ||
| 70 | 70 | $epTQs9zeieGqX2o65g5qc_2lwjFXlbvsTGyfV7CnB84 | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | m.room.join_rules | ||
| 71 | 71 | $xP6pnG5RFl9crGcYNMppfKpCYhGRT4riMD0Df88T-mI | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | m.room.history_visibility | ||
| 72 | 72 | $ngp1BXDvlr7i1UKJZNj5awLMnffqBuXpLviUWGcgVyc | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | m.room.guest_access | ||
| 73 | 73 | $vlc24IXm_mrGsKQ-cqcypHBlBHuYYnmAdlKKOyO6ics | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | m.bridge | net.maunium.telegram://telegram/923990709 | |
| 74 | 74 | $WO9XCQGMAkHJimciNzatEPzxSrowOtYbAot0Ae0ZOAg | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | uk.half-shot.bridge | net.maunium.telegram://telegram/923990709 | |
| 75 | 75 | $qWYFMYxkp8n5wwhpbPBIMVDfb2hgC0ef1Jt475wXkMY | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | m.room.name | ||
| 76 | 76 | $8SRjOXJoH4mN8aLa3Sz-rVyDX3KyN33kgY65FFlwPws | !sbaLjvmTgcNwiUXJXQ:matrix.jamesst.one | m.room.create | ||
| 77 | 77 | $5EUD5-MHpCTpf3hNa6WhE3eZ2nhLCpeZ173yMlgBrM8 | !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one | m.room.member | @telegrambot:matrix.jamesst.one | |
| 78 | 78 | $T60UYkUtMbz6u8Gnw_nPMv8LsaxsW99SHaROOChvIjQ | !rLmxJOIqnIApSVZkgA:matrix.jamesst.one | m.room.member | @telegrambot:matrix.jamesst.one | |
| 79 | 79 | $cTn-NmkmQzMxMd3_and2MyZ9-hLsQQUDz-BwWQLJK0w | !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one | m.room.member | @telegrambot:matrix.jamesst.one | |
| 80 | 80 | $OpoUwfvOZNBAO8P7rR83O5R5be9sfPqbbmANl5J3SYM | !UUvAhTKNjAWCZdiukW:matrix.jamesst.one | m.room.member | @telegrambot:matrix.jamesst.one | |
| 81 | 81 | $blTLJywpRQK2qn7h-GAfexjE_1gmzRUP91RmXFgnlQc | !wHLxxSZsbnIQXhTiiU:matrix.jamesst.one | m.room.member | @telegrambot:matrix.jamesst.one | |
| 82 | 82 | $6k3SPHJybJ2LGtVwMUk5XwG8vcTnDVNMKh_fqrq6K9s | !XmPjsojWIDUGfbCOtX:matrix.jamesst.one | m.room.member | @james:matrix.jamesst.one | |
| 83 | 83 | $3UjDTEUdOXuyG5w-dsYzfv0-sUx8vYv6GKhirVTfdE4 | !tbPxpXHdNUSHVECIwW:matrix.jamesst.one | m.room.member | @james:matrix.jamesst.one | |
| 84 | 84 | $J7QUoFxtwlWMIMF502Hd7t45AKHnOvz8Ww84Niorj5U | !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one | m.room.member | @james:matrix.jamesst.one | |
| 85 | 85 | $BkhLIeCEO6yEpcLiKum2lnZW1Xmv658y78QusfFYP_M | !IqKjJhnnpxKUCjPExL:matrix.jamesst.one | m.room.member | @james:matrix.jamesst.one | |
| 86 | 86 | $Y4LsUs6YB-glNmtJRDbhDypkMO7gft4R90cTfpoYcu8 | !nwpxowRufBjawIIUqx:matrix.jamesst.one | m.room.member | @james:matrix.jamesst.one | |
| 87 | 87 | $wmMQtPbPU7bRRLewe3vx3laZ3-yjezFqSkTExYVH_2M | !sbaLjvmTgcNwiUXJXQ:matrix.jamesst.one | m.room.member | @telegrambot:matrix.jamesst.one | |
| 88 | 88 | $pUsLQWf1jRhLnzYqK-4L40LtfysOPaCFeCnmhPd06Zc | !kbmfiscAXROVNQrvhw:matrix.jamesst.one | m.room.member | @james:matrix.jamesst.one | |
| 89 | 89 | $TdcmRwFrfhrCv6YPhBRoYS96CpaKIbP5pxpUkqSVZmc | !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one | m.room.power_levels | ||
| 90 | 90 | $Gr8aRT5ireYnYphS4zBt5vIhpWLqeQe-SNGHvv0u6hM | !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one | m.room.join_rules | ||
| 91 | 91 | $XqqlbrA1OVNd4NW3sbetXGBQ8pZz7SKk-vPi-h5xJMI | !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one | m.room.history_visibility | ||
| 92 | 92 | $YBOlKqB9OyORcasaxLL9BhmK29LxODus8hRDfkt3cTM | !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one | m.room.guest_access | ||
| 93 | 93 | $0nFyAXWi54-XXCv6sacVxZFBvXZIe72BnbuN4xX6KMY | !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one | m.bridge | net.maunium.telegram://telegram/492707818 | |
| 94 | 94 | $OsegchVKIOBzJWXdY1VDijVhXWBWbCfNUY7i8znfX7g | !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one | uk.half-shot.bridge | net.maunium.telegram://telegram/492707818 | |
| 95 | 95 | $Yfasx22pVwjtL5UYV_c0aVZn7OBfL2oiKBFZBeOb_8c | !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one | m.room.name | ||
| 96 | 96 | $YgKQuMi6AtmIQiblFeHOYwO4EF2BZbaBW6IyfKu7EzQ | !rLmxJOIqnIApSVZkgA:matrix.jamesst.one | m.room.power_levels | ||
| 97 | 97 | $hWjRsIRMrNb1C24-U3cIZ2_OfVJw9Z51YAkgxNtWbhA | !rLmxJOIqnIApSVZkgA:matrix.jamesst.one | m.room.join_rules | ||
| 98 | 98 | $1U_Qe2PQTRfDHwTZxjGF-saDDmrBka3JyylvU_5L_F4 | !rLmxJOIqnIApSVZkgA:matrix.jamesst.one | m.room.history_visibility | ||
| 99 | 99 | $ny05XphUy6zsrmIfpAMDEZY_bJR_aVhcOnEJCfNAt8k | !rLmxJOIqnIApSVZkgA:matrix.jamesst.one | m.room.guest_access | ||
| 100 | 100 | $MWotwXjHdHdopZ-aR3p3r-iY0YXf3t4eQTz6UcBmgGk | !rLmxJOIqnIApSVZkgA:matrix.jamesst.one | m.bridge | net.maunium.telegram://telegram/468290337 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE state_events( event_id TEXT NOT NULL, room_id TEXT NOT NULL, type TEXT NOT NULL, state_key TEXT NOT NULL, prev_state TEXT, UNIQUE (event_id) );