current_state_delta_stream

5,890 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE current_state_delta_stream ( stream_id BIGINT NOT NULL, room_id TEXT NOT NULL, type TEXT NOT NULL, state_key TEXT NOT NULL, event_id TEXT, prev_event_id TEXT , instance_name TEXT);
CREATE INDEX current_state_delta_stream_idx ON current_state_delta_stream(stream_id);
CREATE INDEX current_state_delta_stream_room_idx ON current_state_delta_stream (room_id, stream_id) ;