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