home / chat

threads

120 rows

✎ View and edit SQL

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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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);
Powered by Datasette · Queries took 27.78ms