threads
120 rows
This data as json, CSV (advanced)
Suggested facets: room_id
| Link | rowid ▼ | room_id | thread_id | latest_event_id | topological_ordering | stream_ordering |
|---|---|---|---|---|---|---|
| 1 | 1 | !fjpoKrgAqQTQibxaFV:matrix.jamesst.one | $Bl1x-oAYcx8LaK5rkhjv6XejdF9UuWZg5tpeIWOuX3g | $aAaY6KG35l3s_G7Z5uxIUF4gF8vEc6nW7LlRa_ELMgc | 40 | 3777 |
| 2 | 2 | !yNPxFvVFgRPlbgenmk:matrix.jamesst.one | $w0xF3MS7s0OkNiYAbOHBPLjSoCrbj8hN0wcZq-RIQm0 | $-muqNVJdeXL3S6cK1Zo9QOHMQvCTyQxqFheMaQ912K0 | 91 | 3826 |
| 3 | 3 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $b0yI6op313Pp6z3RK1ZWvzY-kjMFeQNJeJNF6qs1L20 | $xJMB6LCuOM7M8X_fk06QhbsaCYgz9t6xbMcCD9HsTqg | 44 | 4133 |
| 4 | 4 | !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one | $kGl5SuCv4EJjoNcuvHmujw94EDcytrl66E83kljOhog | $ieJ7fmQRVpbPEW9hb-_rX3nKD8mUfZg5UgTASrGfhdg | 46 | 4156 |
| 5 | 5 | !yNPxFvVFgRPlbgenmk:matrix.jamesst.one | $Q42Pd8_XGnT0cB9Z5iTDmdik-0U0qK2cnx9YBwdjryQ | $FvrXilhK-CyzNDWCxzsR2H2a3oONwsYnzda3g3WEzSg | 160 | 4592 |
| 6 | 6 | !yNPxFvVFgRPlbgenmk:matrix.jamesst.one | $tayQWinneufzywQELtAJkX2Hfyv9LMxzAeNd_es-qAY | $BD4gNoP6mxtYYRi5IT_DmTKdu6syUKB0psCOhML9OTo | 117 | 4186 |
| 7 | 7 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $qJtjmCI5jnrEamKVSfmiKX9LSbdihFbxIycg5egKCLQ | $jNx9c9uaPL8zzdAoTZTQoCtXA0N5KCAPuHZjWR3Ig0k | 58 | 4354 |
| 8 | 8 | !yNPxFvVFgRPlbgenmk:matrix.jamesst.one | $M_yeqjI31MlVEGZIu6TBllknvMqvXrQeQwhg8aRKpXo | $RIABFyzpCtYtmZq5BKEtAx6eNkpOr3H6bUrRmesyPNU | 152 | 4486 |
| 9 | 9 | !zmsygXhOAWGjoosiDX:matrix.jamesst.one | $fFKdZLtEYqUYa_1qJ0I_9WCnZEa0N_3iR34VpfUYLuc | $9dwE0v29-sGR4iFrRGd-BTgQce2929Kaa0G1zYlng7s | 106 | 4494 |
| 10 | 10 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $BF_K4W0elBwRpV8i4VvpZg09dXYPfF4Cw3Jea4lSEfc | $sUbUv-r_idy3iheTChODNi6nllcbD1czDZdH84gsZ0U | 128 | 4581 |
| 11 | 11 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $7_uOXIcVBEqbntRSdsrOdkCIN0ww0Stomlwu5HpK5G8 | $iThv9Z6_TuHisVj4YcD0NFH8JjCrRZc_5YniKnI5EiA | 155 | 4784 |
| 12 | 12 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $tkMhGRi3EaCcNRSbU90SIOgeApqzgYClTFJFbmigy18 | $4DJkmgvb838LaR8l3tliNKs0WxgHZshY8k5is6fd8Ao | 186 | 4852 |
| 13 | 13 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $Du-Lh_KdQyRsB66h6fxKPH-iznIi27HEnGWNEb1JPhU | $TknzSOmDCL8FWk9-cOY7zh1wYZ9Z92fw_gU98IN5t0Y | 212 | 4883 |
| 14 | 14 | !lvdngYYyOuGxmaDcpE:matrix.jamesst.one | $U_UHtLZuOMa6DBnS0YZMSfEflVatz6Vj0IejNg9VPlo | $w4aWKhBBzfGLB5BNx_41hFkLyPgHCP6nLHPSHIs1NyI | 75 | 4923 |
| 15 | 15 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $gTJT98kpR68H24xjsC8M-qmyMI4JhyL-oXilHSgAO8I | $1OcQXzJoI7bl0BsPsnV1LcCIJ84-C6QYx9Z9K_jjt20 | 52 | 5243 |
| 16 | 16 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $Bd0eGDBCTCzUnPme8dhm8AxZjPniXDcQxquU8mSf79o | $ng88LqWal2dF-3sVJPmOKByx6R3wVFb3Aelz3Mbr9j8 | 65 | 5273 |
| 17 | 17 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $gyhmdhiNB7m5-6_MEkW6PecRPiirl3ZjoMYgMSzWSTA | $QVesGa3Csx55vaPvGxnxCDwUvn4u5y38JJE98yDHOe8 | 62 | 5262 |
| 18 | 18 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $0Iv8O5YUFWXNv5-N6xv2OC_UFnv8LgOzos4GfMF7uNM | $kVeZ-Xj3O4uKxFW8Fb9AYj9JPkJN8glQOSWulogI_Bs | 76 | 5355 |
| 19 | 19 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $4XShJmGTM9ZvcxI68E7Yu1OfANtB2KN7g__5fg_IZRM | $X0b3jD08LmHjA7eKBHPhumIb3_HSJf5ch7_9WRGBtCo | 259 | 5470 |
| 20 | 20 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $3nGWFgyHxzzOTsud83B1WUNik4PiJBfFYYMzt27OmD0 | $IaSAaUIU2mTI9CQ05cFo_KYLhhAF_0UcLfTFEDun9WY | 269 | 5489 |
| 21 | 21 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $XIv3h7_oJi-hXfJdXP9D5PG0gy-kB2WHCgp1zZ_jQXE | $nlEc-IW_dfKyImqW4SNisVQSmXT6OeGm4UG6pJME17w | 279 | 5941 |
| 22 | 22 | !wwEzedPYJkRwVjJzjc:matrix.jamesst.one | $C2BXXJTLmu8j4-tBIhBBMEaZog570-sshj9g0s786vA | $IBuV1vI4VDEMDeqrp3lbK_8WrKBdOUdm-s-uqWLah0o | 31 | 5551 |
| 23 | 23 | !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one | $gMMLBLS5bh1BLIe9rapQfsLu7vV4oBancAGVXXLguCM | $BdXxrGhWaJ0nHsATScQZnKqhhlGWYTYPrH1j_YRdlRY | 174 | 5995 |
| 24 | 24 | !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one | $hYOaqtUqCfoG_hRhhsfcWwYF8ciMHPddPsvXmjXeiFA | $7xUqznl7v3dFQ00u2os-AuNrVtRzQpiRd1uSxb2TF6w | 176 | 5999 |
| 25 | 25 | !ElMzGskWQnGJveipvE:matrix.jamesst.one | $pZzKVinU2ffYuNma_popTlfa9a5fYkyFdBlJnjBWo1I | $1anBpJGzHXivJiUm5aVDSJtiNh_Sz_ujkOWWQV7VvcE | 112 | 6012 |
| 26 | 26 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $QRIDTcdhFb-5en3H6RHiHhWrVmw-Dgy3rcxoowdebGI | $3toUepmrCpPIqecnMmOnr8WzokbxZ7rXh7BuGGEryX4 | 409 | 9019 |
| 27 | 27 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $2LjBg-6Lc0zjmkFwJK293LFLgQ0SaQ9OytOeMFJVI2g | $jRdYcoffPzNBRbpdQVEQoa405yMb6T8WgBCOGeWYkj0 | 148 | 6180 |
| 28 | 28 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $318SrST6s28Ibd4feRY30YD1ntAR9_LjylbhWVFZJnk | $PxF1fCbRt4VDLAwSoyfLL_dwcrbaa3lg31q_P7zjn1g | 161 | 6301 |
| 29 | 29 | !cUqOYXLBrRkRNLvBpt:matrix.jamesst.one | $2QpxM-9YqtINlJ00vS8Gd7HtFw8wbGBnEaa5Q1yTano | $jJ46ZoZIALWjqhdL2n4bxBKHFPDhVokFe8mWI3jGvyU | 120 | 6566 |
| 30 | 30 | !cUqOYXLBrRkRNLvBpt:matrix.jamesst.one | $gVzRB4uwQRaHaD6ssNJaobzMH_YUJX8ryxprMO8Ntj4 | $QBwMU0leVyF03NKSDhUFu3t2BqdqyjuG4PLetn0yGM0 | 121 | 6567 |
| 31 | 31 | !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one | $0zqyhRz9cM7V42OkW_O_K1A5z8GB2LSRzyiPXvMFx-I | $_Ufzc3RIrVVTzxZcKg7ZqI-L22KMQek_f4LEpMsN0tQ | 308 | 6738 |
| 32 | 32 | !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one | $5SBmshsxqaa14ySfeUHR_sqpAsF6KQRngTG-se4ZWjI | $_UHjXRAD-Qg4x92KamGiHI9qZv9dSouUqqHFSZeZXWg | 358 | 7252 |
| 33 | 33 | !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one | $09oiO0KKrtHpSPY_q4Bi3VK-Z5TZCzyv5xrf87hvZWs | $wkX7cGjJuO_eXrGNmjMsGocneHNFw_i0Wh1OKctIu2g | 367 | 7323 |
| 34 | 34 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $zWliWl0QsYWb7B91X8cWSAZf0JC5RUNQUwtsNiYd5QE | $I9wNuVH60EeTkuo_l2qbsywjF-eHXmE-NbBE4su02vk | 361 | 7880 |
| 35 | 35 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $FJbu8LihurXDMH651XI3zG4xwpc13Gt0XZoQRjcMSN8 | $X1XzxN_ydF97HICv1BHzIvcThC-4Fh1htm0o_I0nu9M | 348 | 7857 |
| 36 | 36 | !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one | $coMGwjxtbGKfFA8TcyL7DJoALEQ7ld0eOVVAVhlKAMs | $VtCF5QsvoHs1ankxpEfWxGYh6FVvM7fH1Y3Nl5UAlIg | 407 | 7920 |
| 37 | 37 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $06_MyBe33aYrtNUWOZQa1L5P7CO296wAndx3lPxelts | $OTavQdJFVR6nhbY5q2A9weDj1g9lkl1qpBU-EYDEs1Q | 193 | 7924 |
| 38 | 38 | !yNPxFvVFgRPlbgenmk:matrix.jamesst.one | $-uXR9c8vLT9n3SHleySsxUpVYExdE02PSj3ZA_6IjHE | $_HpQnj0fAAaDvDc89EhqFGrDiLb1XYDnjzkb0cfcwNQ | 311 | 8050 |
| 39 | 39 | !yNPxFvVFgRPlbgenmk:matrix.jamesst.one | $VFDgTqUpWZO0BV9lU1YIXz6h7jwGLR-ykfGgdSqdA1o | $Q37esdvriSIDsQXN0YCXStfHtDpCGChtJa-eBPer2ak | 313 | 8052 |
| 40 | 40 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $p4HKLopX8kQt5rDxpUgQk3TAhgLoOg7951GK5S5VgmY | $dOMPFQ0S5L9vfmiJeT5s2XwdfIltq62T58EPbqYRa9M | 388 | 8485 |
| 41 | 41 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $7-C_rRSmSK8SpYJTxrNCejMH4SE25cabS45i_t0bA7g | $uEKpKx-75-Wcw1MEdNuYRzvpITH46N6iWgvodtYlS-o | 371 | 8293 |
| 42 | 42 | !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one | $ab4Qkj0Bsd6SHzMI84gfMzYr_omVnb98n3Ue4Rs-ZxE | $iB-kZvuZt9isESfiniF6yJgikXQdpaseBVpULnFBNuQ | 467 | 8907 |
| 43 | 43 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $25K6ryzkFXg08nEYV2tZX1FZMhxrQQ0qXZMs0Lra58s | $AqWD8ovZECw90UhpxtgB1xtfHKXS-00rY8PowJqfPhg | 414 | 9053 |
| 44 | 44 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $PTFY8UOtNllxOWfdTp-MwrMdSt_kDLeJt2Fg7gQtqgg | $WlKm4z2LYW-yNw0U97OBjVmXaLJS6GSIcvAnKVWxNx4 | 396 | 8760 |
| 45 | 45 | !AqEkmqWBtPNnPrufwA:matrix.jamesst.one | $6oHjurYJOBOChiDGNmfwkPR1Sy_CTdshozEVz77K8JA | $TTI98HtRVg_Wor6FZHZP5kPxe9FuxyKWPWa5T9WLmuU | 74 | 8736 |
| 46 | 46 | !cUqOYXLBrRkRNLvBpt:matrix.jamesst.one | $N81ZEnfQEFaqJXs60RDuCZIQmxA36fH9e4Zv38NLaQI | $jilAUGJqnhl7ir58d8o1nz3-a-3mq2v_d9mvy7QXu7Q | 192 | 8807 |
| 47 | 47 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $r6RilVgsSNg4eRvTSKd3AvjLfRvYbK0xX_P0a74LMBM | $T4K6upPUUYAkXVYLNeFsCPTLflaa72gVCJw0uKxJ5x8 | 444 | 9314 |
| 48 | 48 | !yNPxFvVFgRPlbgenmk:matrix.jamesst.one | $Kqy4libWzv2rpljjYU3X6fIAtHyNL37R3nD35DQVs1A | $Qyv9emnH4-ijhhcP03Yw_bwVxM4WhsIS7D5n8RORoq0 | 381 | 8993 |
| 49 | 49 | !yNPxFvVFgRPlbgenmk:matrix.jamesst.one | $nTv99_3JXYpRs_Rww8w6AxKzdgu6ibKVw--RDxWmMaA | $dyE5rtzo8FeHkkNqv9bCv3T8Mq1JqzUsPiRtcd51ZMs | 386 | 8999 |
| 50 | 50 | !yNPxFvVFgRPlbgenmk:matrix.jamesst.one | $yYwQBGFbPVRcuLRWFKeh489KNK8y0spS11YHmuZd3X0 | $_Sv5ViNJLn5TNRHANYMvHyFzr9kyUoSkjWW0Ivad4cs | 394 | 9017 |
| 51 | 51 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $xh5XUY9mjmRpWf3eq6XrvAx8RZLcXGcJnZkE34RFuD4 | $xWFl8rJDJiEqkKH16eqqgeNBOkgC6M0ZSnn_RdyVlc8 | 411 | 9034 |
| 52 | 52 | !hqiiyckjNGemPGuALY:matrix.jamesst.one | $E8LzOeMQPEGHYHyQI5W0vR09FEsNdCSuvAVITgE2dXw | $6l-TMRXvB9ODofdBmTnp9YUTOKT_uKXBvoVn2zzX9Wg | 31 | 9185 |
| 53 | 53 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $6Olg7nAW_Ndi9fYy-mdg3tN1JKP7t8eRYjQ4JWSZY9A | $kOFocqzWsDmk73MNjFDoiBuVSjQ7Mv1JQfUlCColBc8 | 475 | 9627 |
| 54 | 54 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $UUaExLoND4g5FXxXoc6JPrRLKLAGQyv0prxYPry6_CQ | $y6O4EFoxfA7p4PMQa15RN5pnG7KjvgRQAFP9k47ZW7I | 453 | 9424 |
| 55 | 55 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $1LWbQNLfN0TAo8ofgdOHsvukZ0NteX_N27lqoJXEldk | $tUxTPSSfunJK714uqPSvLQN1kqgrititRtuMegWtj6k | 238 | 9418 |
| 56 | 56 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $PMGb-8ltD7pBTzV39yrhEOPMvrgpcLkKuRQB2fA0TkA | $H63E0jy-c0eb-IKxNoqTFE9-QbywVy2cK83uEeflDpM | 478 | 9715 |
| 57 | 57 | !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one | $opnxEjM1VlY-ICXtgTyUfXDyNIU6lgZm1z_JgL_kbTU | $PsW92qA15_nYCMibxGo1y5Z6BsCOcUfYUnP6IrIO1q4 | 515 | 9617 |
| 58 | 58 | !fjpoKrgAqQTQibxaFV:matrix.jamesst.one | $JyrJ-MliOgYRbl3criut9iYyxyl8w6Z3a5BMUxJJY5g | $3pCm05KoFZLroNTce5rwrVRo2JI_G0qVIrsGqdJAC20 | 79 | 9647 |
| 59 | 59 | !jgxuOOeYeaKhiVtsvV:matrix.jamesst.one | $tlPWBLfAtEVRA4qQSZuTzZeypDdBCDf72OgKiqs5G1A | $difpwvN4Y66pEnwGWyANNLDpc-0StF7ZThTdLM9sHEI | 190 | 9978 |
| 60 | 60 | !jgxuOOeYeaKhiVtsvV:matrix.jamesst.one | $3lknlpORH9y9JXjNf72vRMlhc9MRgI746Eve10cO04E | $DY83wjQQ4ByOMAnOndc5mO0SadC1mD-VgvGic5W47Wo | 197 | 10129 |
| 61 | 61 | !cUqOYXLBrRkRNLvBpt:matrix.jamesst.one | $hBsswN3eoBoZwaVEgUnouctJmP62y47_swEgG4QVLkE | $s3HcYtxMTxWKBDd3hFw-bcwIaJRPbihaCOggeMuEt2A | 226 | 10138 |
| 62 | 62 | !cUqOYXLBrRkRNLvBpt:matrix.jamesst.one | $WFz-6bIiDzc7a5jQC7-1km-qpZJvKWeOaPo0UtvUglY | $FS-HcyW9Vji91PaZIciGac5YnHq01vjTtMloKDqaAJQ | 228 | 10140 |
| 63 | 63 | !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one | $NtL8x9ON_bWb_nwmz3lzJeSabF_n3SI3S44z3eOn7Ck | $NAbHx_pTQrbS2IICmcJ4Ywwpbu0VRsOdmeqtV7vMRzg | 570 | 10177 |
| 64 | 64 | !jgxuOOeYeaKhiVtsvV:matrix.jamesst.one | $QXNLuBn3p2rc3hMxiW0vzwUgnoiMtBbDOYyOdVN9SJU | $3VY5AymBUXKGh2eeS0GXjaQiTEipZIhHpc1stJuvQss | 229 | 10414 |
| 65 | 65 | !yRfWTDBHJjpXRhVNev:matrix.jamesst.one | $B8KJrJjPZ8b6OkuI_6EOvkGs-muzX9QWCfYKkfOU6_4 | $U_6HqO0a8wqOkjFpgUCLzM-pCcpn47f_ksuwdJDyKoU | 32 | 10225 |
| 66 | 66 | !yRfWTDBHJjpXRhVNev:matrix.jamesst.one | $d-4N0_iasnDZwyOvMPLQK_ExG2_amX5B5VhKymt5iXg | $EmTQ1syABrBVf1QXnjgfuvvUzne0AkEosJ8Ho01M0Gs | 36 | 10229 |
| 67 | 67 | !yRfWTDBHJjpXRhVNev:matrix.jamesst.one | $MEzD5s9K1dbCyd4XUg8d8f2dm8Fa2pqW2VcIXhHjd-k | $jPIN8Cif9aREGWR2-2h9OplNvjZ8RfbpHWXHFmf3HrI | 61 | 10331 |
| 68 | 68 | !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one | $DCxTnsEtse0FroOw5V8PLD0N6t3UN-h314ufRc_31uE | $HnO_q-ODr8r4eAksD0DTCNDT-DgBZm2-PJwOlIFZek4 | 638 | 10523 |
| 69 | 69 | !jgxuOOeYeaKhiVtsvV:matrix.jamesst.one | $7owgeVLxa5LLVnYhtL9lC4d3uKsVnJiGm-lQGp-pqaA | $Ukjy4quTrkg-MBooQF90krrGvz27i6cZQajVnr5mGkk | 234 | 10533 |
| 70 | 70 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $pmCcGmAUwkAEImYQSBipu5D696RCmn347irHRnj0BUQ | $C582-JLdEkEJMVc65IloQlqaTPgwPz9WOd6ulPrRUdw | 512 | 10647 |
| 71 | 71 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $zEqeaBIqSob1CfAsoKsajxHA6jPeowCc85v1EL9j_GM | $I6g2vqassADIvz0KafvL9rgs6VDf8IAtwFWqLo5shR4 | 531 | 11994 |
| 72 | 72 | !AqEkmqWBtPNnPrufwA:matrix.jamesst.one | $xfssPcIMFtSu1Xc43YeVeKs7ChRfv4mbQPg4CA4j_kQ | $9WbiW7g0sJOtlDTs-_et94DrM1PRhOv-6H0teHN48Qc | 108 | 10683 |
| 73 | 73 | !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one | $MYiYQEz5XcrIz2DyIBd90yl0Q_OwbAsgZzwqoqtWg7M | $QQfcwfl80Q1-Jib6gMTUB2gGrCM2G2I740qzBi7_SmY | 708 | 10974 |
| 74 | 74 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $yErZj1WgaFiDpO40TVYRotP4XnGvZcHsqXlkpNVOMQw | $V2uJ5dkgV8Ke3q-K50kcvliRo76I8z754hqHxyLmNAk | 296 | 11144 |
| 75 | 75 | !yNPxFvVFgRPlbgenmk:matrix.jamesst.one | $7B2SgXMYUz99svL2bZEzJ37Q4fS0ZEP29n71MpB7W3k | $KAykE9SfwN33vUWDr2u4nHRq01qU_DhklmgdsCgibVI | 419 | 11288 |
| 76 | 76 | !cUqOYXLBrRkRNLvBpt:matrix.jamesst.one | $coPjt5xeEFcikWxcvpE13ntFgJgjR7Se58UsGj8O5rU | $EwvKIwDnp6UcnR3QbKfUQD2LNcTg_R6Lhau1z4fMz7w | 263 | 11292 |
| 77 | 77 | !cUqOYXLBrRkRNLvBpt:matrix.jamesst.one | $xOvLpuoQG7jH79R2DhFJlDbVsYG8_46StUgZ_SHh9Us | $SXtCkoksMCvRDtmpM6EbROhUtcXV5VPMYG7AGXmVxUY | 264 | 11293 |
| 78 | 78 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $OS3kY6mEYU8_LyR8Q838c4RN-sxN9HnE1RgoGUxyf1U | $tEKjEzHNoNRo3scjElKjYv0bKC-dydJNam1zl0dm8Uw | 299 | 11318 |
| 79 | 79 | !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one | $TvovepperpX0RMD0wPydDxLxL8kMIRAaO0djC0agmss | $N8Wq5aFLx2LKM6TeRRCcXxjsBqZ3iO31UlJHdUqwzus | 740 | 11479 |
| 80 | 80 | !yNPxFvVFgRPlbgenmk:matrix.jamesst.one | $IYywlPp167qCmlP1EcGznVqkgO8IrKZrdhS9tc45dRw | $V4xn1Vcn5clIgwsgh8y8lK4Bv13O_0EUOTDdxbXcSG8 | 426 | 11592 |
| 81 | 81 | !cUqOYXLBrRkRNLvBpt:matrix.jamesst.one | $xxfyIYaiNUs9vvjIXmsufS5pTf480fOTkqlF3wJc-Bg | $TrEqbNjFm-6N6dEBlLXva-66IxgZ4bOIC3PNUZRt_-Q | 282 | 11738 |
| 82 | 82 | !cUqOYXLBrRkRNLvBpt:matrix.jamesst.one | $OKWWfGrr9yp8T_UeIxukFNHq_HT5PWdjkbsPJFy-kdE | $VgKukwSrIuxqJot1clm3tZcd-MNIZFqX6BZuJ7ggo_c | 303 | 11784 |
| 83 | 83 | !cUqOYXLBrRkRNLvBpt:matrix.jamesst.one | $NAM66ktDMYjpucZcnH9m43Bg_u8fFkenGDtzCP46iYw | $pcCXD5ZuFY0dcTB-43LkkwDpCgM3g2sIsGYB8ug1YAk | 305 | 11786 |
| 84 | 84 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $8B7g0R9SVW-ZXbX11zkBja0at3ZwUyOVk1p9i2bqU-w | $9NuxS38KdXUgbYZrnXVeKX1eZJ-25xY67ZxwhLxUjQE | 529 | 11828 |
| 85 | 85 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $81sF3Sb1a9vh3ytuoUIoPvvlLD8evJos--wf-Invm_4 | $xhwtNdVpcQrT5-mH5oS5bISUx3D6o3_c5EKWMKPhX-s | 365 | 11879 |
| 86 | 86 | !cUqOYXLBrRkRNLvBpt:matrix.jamesst.one | $yoNTgAZVCBGhjJ97mzhJE_Shj02BVm2DbMRI9d2wt40 | $bVDQPTjYwZNWRGMFRIjDC7z-pB-EBKxaT3oqpOEZUVs | 329 | 12626 |
| 87 | 87 | !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one | $_LqIgXmQq_inzHP900eflqqXOL3CqEgJE11_y2TBYrc | $1IlK8YkU1rLulnHVNOb4Eoc0GGWOiSgVzgYmgmZZoLo | 778 | 11932 |
| 88 | 88 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $URZI1TuDXB-rpjDThdnn07dCIROIk-EvNcSf_J7mEP8 | $owRi9U2q3r2VJy2VZOhED9tLI9g2wGYptrQpnGtQfoI | 369 | 12123 |
| 89 | 89 | !yNPxFvVFgRPlbgenmk:matrix.jamesst.one | $4Y67O-oL6RJLEV5pWebwrykXftLrvHmZz_RskHD6tWU | $UjBebvdzkyD9mKTjFcL7t_ckzUfGPgvda5_AYNj8mdk | 469 | 12271 |
| 90 | 90 | !yNPxFvVFgRPlbgenmk:matrix.jamesst.one | $PfZJN3gL6EzkwTQ0ygvUpVb3E_VCB_mZxelbLjQZHn4 | $XAhu9TNXlcyLLyNZPzOsLcER1PvHwsrxQ3-vvccGgT0 | 477 | 12283 |
| 91 | 91 | !yNPxFvVFgRPlbgenmk:matrix.jamesst.one | $wFqinPX4r8oTLoj4d2vl_ZA80I7zu9_6rkRKJVuyC7M | $cryVgo3sZD3eRTLdpYkDVIQaKU9sza8j1-1SdhWunIE | 548 | 12671 |
| 92 | 92 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $TnT6_l8q3Kk225jhyAe2XisSgIAtxxiOh4SF8dbtoqk | $Jsi4IWFFPGYXSzVjNY7GU_ozxzLO1cHBxJ_oH_VEe10 | 403 | 12756 |
| 93 | 93 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $FaXkJVYH2Vw94swk_4JC-nWK0TAdW_f6tqbIeq3qGvc | $IGOsYdEMQIb3HjIWBXiLB0M_Rb1Crv7si_Y2TdQhJjY | 407 | 12809 |
| 94 | 94 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $eax5ES-0ucqyxu_b7293OBq40L4eqVpuyzAU4LGrK1I | $rwaer4m2OrzKzmGWB557xau9jviBSdGrWWEz7sjC3n8 | 450 | 15769 |
| 95 | 95 | !jgxuOOeYeaKhiVtsvV:matrix.jamesst.one | $SbxlrEpfg2QxujPIB2G_KIXxcO36Bsp4byJEzeAZlEY | $kWMskY3uHKD8UeL3KVI8WqGe3gDuxnwhk932vpX9la4 | 349 | 14032 |
| 96 | 96 | !AqEkmqWBtPNnPrufwA:matrix.jamesst.one | $_s3S6ffMEM-ej1grFNAoh2i0TUH7_8X_Z28MoR3s_zM | $2Pe16rQKtmEkg_kG80YYOgN7kn85YnylB1KqOuB9AE4 | 173 | 14093 |
| 97 | 97 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $KwKDjKoWLWBLSRYuBJaNjc3l5iqXKu8rayY6MwM4sEc | $q5LEhsOgEnSJ-LvFTzkrFZnFThtNiOTJ4fEMVbsMRAg | 457 | 17159 |
| 98 | 98 | !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one | $JXUSK9z_DIHUyOuVXwAOx2GB4YvE4Wo0Wuxo8jDrYCQ | $7pMMwdRZTzb8A67UMn72l8We10lZ9sKVRX5FkBX_NWM | 466 | 17287 |
| 99 | 99 | !olJILpOTaMZbhdcmfR:matrix.jamesst.one | $tg-bcrc_2HHQj2yRKDeVo_bKo1ygI9NzEQSTOaBelBM | $CnQfsCMGjXmBqdeGmOP787q9MT2MooGspJ7R6hhI8Ds | 619 | 17324 |
| 100 | 100 | !yUNReqWYCGqSXsSlsy:matrix.jamesst.one | $uclnPvnQhsRLIPBjvXMMfaaMQ6ELh3i78T4_Pi2kIA0 | $Fr0qCAuQXDWwy_ooH4obW5QvHDL5Lfu-P0Zlk8jgU44 | 55 | 17378 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE threads (
room_id TEXT NOT NULL,
-- The event ID of the root event in the thread.
thread_id TEXT NOT NULL,
-- The latest event ID and corresponding topo / stream ordering.
latest_event_id TEXT NOT NULL,
topological_ordering BIGINT NOT NULL,
stream_ordering BIGINT NOT NULL,
CONSTRAINT threads_uniqueness UNIQUE (room_id, thread_id)
);
CREATE INDEX threads_ordering_idx ON threads(room_id, topological_ordering, stream_ordering);