room_account_data

61 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user_id

Link rowid ▼ user_id room_id stream_id content instance_name
1 1 @james:matrix.jamesst.one !vahPHWhsPlyBiaHXaN:matrix.jamesst.one 38 {"event_id":"$XxaFKreWa2C_2E50R-gC-dMe3_LLXXTRVDjHw2V7As0"}  
2 2 @james:matrix.jamesst.one !RrBJXVCuqleqRhuBDi:matrix.jamesst.one 65 {"event_id":"$Pc_zOcN7-0OJUXnwovgbg7LzhBsD1lBVWstt_X_PU6Y"}  
3 3 @james:matrix.jamesst.one !TuuVfHAWQDmtlxZyTc:matrix.jamesst.one 759 {"event_id":"$2oVObDLnFzK3WsHgv4gP4NNmKA-CGdpnci2jHNf25as"}  
4 4 @james:matrix.jamesst.one !FMIBicfcNbhIoPeYcL:matrix.jamesst.one 900 {"event_id":"$SpiX7pnO9rU_FnugJ2fIbGJW9myRD-8tMmWrVu7MU-g"}  
5 5 @james:matrix.jamesst.one !BlgOiSpdKGmaXVClci:matrix.jamesst.one 84 {"event_id":"$hjRI1YIBU-641EneGddOXamSCIQvXQf7_qhi62MW_2Y"}  
6 6 @james:matrix.jamesst.one !HenNzFPhosZJtuised:matrix.jamesst.one 758 {"event_id":"$IJHIsAyaCNPe9sDTARPKQ-_VWbEuDZvacDpVVomdAnU"}  
7 7 @james:matrix.jamesst.one !UJqzdqWCbSZOHNGKko:matrix.jamesst.one 511 {"event_id":"$RR8grHDolg0XkcPQm63Vc97OWdj2jRkoy6WEGcY2icI"}  
8 8 @james:matrix.jamesst.one !XtdPnFKTQFwzmZwTzj:matrix.jamesst.one 91 {"event_id":"$abrdEKuzKT_k34vzgXBoXIXCb4OHeghkyw7poy-UPUY"}  
9 9 @james:matrix.jamesst.one !hJDQZfJXOAcRLJuxKD:matrix.jamesst.one 92 {"event_id":"$-JJ0HtT9qsWPPdIwlkDBFSbBF_liCfleheMe8LaDGqQ"}  
10 10 @james:matrix.jamesst.one !ImYuSmZJXIxFmOMiZw:matrix.jamesst.one 93 {"event_id":"$9FVRrLl0gJRVmbcayCC0b16nD11NG7zlTAMcDJzSrwk"}  
11 11 @james:matrix.jamesst.one !bJmcHKRjaGiLggeYwY:matrix.jamesst.one 94 {"event_id":"$wTGktgeT4RAjk0xh67HePw9cXETGcfEKIqWHp7Gm0Ww"}  
12 12 @james:matrix.jamesst.one !NrCBfpIqUHogWCDcMp:matrix.jamesst.one 95 {"event_id":"$b4RGDMwANXapNvFZLwpt_tGs90Wnf_Ct1N34trYzWQQ"}  
13 13 @james:matrix.jamesst.one !sakYZvgbBpabncCUiX:matrix.jamesst.one 96 {"event_id":"$-A-5mYMBGa0HPxfksY04nbzpzSQErXgSM-ay6Ozv3Hk"}  
14 14 @james:matrix.jamesst.one !CqfWyLZphyISDieDLs:matrix.jamesst.one 97 {"event_id":"$sZYq1ODh0ZPkT22jEHgGOlXTOVrE43TSYEEMU4oS71o"}  
15 15 @james:matrix.jamesst.one !CfUJyBcMuMCEOnOSFP:matrix.jamesst.one 633 {"event_id":"$KNdEpd5tcMEWjNNo9GBC8yLwW8q0fwrFe9xhZ0SHmzk"}  
16 16 @james:matrix.jamesst.one !XmPjsojWIDUGfbCOtX:matrix.jamesst.one 99 {"event_id":"$PgIUbJyd-jQYHrJMBIr3Dzb-fUZRHLf40MnK3lK1yRE"}  
17 17 @james:matrix.jamesst.one !tbPxpXHdNUSHVECIwW:matrix.jamesst.one 100 {"event_id":"$568diyfIT2iALf0pv6zutF0yRxwn8muN99GBgafYuUw"}  
18 18 @james:matrix.jamesst.one !KZlTJxlsaqnNdTwXLo:matrix.jamesst.one 101 {"event_id":"$R4PYRLIStcrEl-Vjl1uvrH9G9hSmp5wRXOxO_dDAKxA"}  
19 19 @james:matrix.jamesst.one !kbmfiscAXROVNQrvhw:matrix.jamesst.one 102 {"event_id":"$3EmgpgtbzNEuuX-8mEOR7W5ZlUNlOrrp3QLKm_2WnAM"}  
20 20 @james:matrix.jamesst.one !wHLxxSZsbnIQXhTiiU:matrix.jamesst.one 103 {"event_id":"$KQJ9TaHksW8iutc8_XcldbHhyLtGXoRGGCtTHZtiEQA"}  
21 21 @james:matrix.jamesst.one !rLmxJOIqnIApSVZkgA:matrix.jamesst.one 104 {"event_id":"$GkvavS6iv8wgT72LSS8wQHRgJvWVcuvHkJAVbY8Wb0c"}  
22 22 @james:matrix.jamesst.one !LnVQNdQqhHjkLwaLFJ:matrix.jamesst.one 105 {"event_id":"$2MTL8BYkR8Myx7EA54KtiaALTYHEbhjSiHEJwMdRnyI"}  
23 23 @james:matrix.jamesst.one !UUvAhTKNjAWCZdiukW:matrix.jamesst.one 106 {"event_id":"$-YGkkfQnGVrPdY-dXoo6fZTG41CZT6ddYmU2tnkLCL8"}  
24 24 @james:matrix.jamesst.one !eeKKhsdGMzhEYYSXDS:matrix.jamesst.one 107 {"event_id":"$8gKqeTCPhIsvucftm7baaijQYT-EdtZUH3Yomt8tpWI"}  
25 25 @james:matrix.jamesst.one !nwpxowRufBjawIIUqx:matrix.jamesst.one 108 {"event_id":"$3iHY-Z7kzyMhG2mBI2IyNNwTsdQWGgryI43q2ZUjZqM"}  
26 26 @james:matrix.jamesst.one !jFzqKfdTChZyTOYePb:matrix.jamesst.one 109 {"event_id":"$dTEiNni-dIN7Bit194lqnBFQrv_Ae2H0IY6uS0CVmcU"}  
27 27 @james:matrix.jamesst.one !YTFbLuqrXFRjMxUKQg:matrix.jamesst.one 110 {"event_id":"$Y0pX2WOt--Bqe7tgIMiFWLmCOi0VI8pnoyBikdqIKw8"}  
28 28 @james:matrix.jamesst.one !CcWOicpsftjEucFZEn:matrix.jamesst.one 218 {"event_id":"$fNdUJylGAPoXs5yO2J-fjUiw5kWFkqEc0yVi0VTqtSI"}  
29 29 @telegram_8977292871:matrix.jamesst.one !CcWOicpsftjEucFZEn:matrix.jamesst.one 205 {"event_id":"$RYpzWb2vUEDBFKrZPNjvVMLNDl1TS1ez6pwu6fzkA4M"}  
30 30 @telegram_1126947413:matrix.jamesst.one !FMIBicfcNbhIoPeYcL:matrix.jamesst.one 897 {"event_id":"$ECY8zVBcFcBLKilYRxLaeIIJzK7GCqOuyPsPfSK_hPk"}  
31 31 @james:matrix.jamesst.one !IqKjJhnnpxKUCjPExL:matrix.jamesst.one 903 {"event_id":"$6AiTay_Ize5iQlwpn5L7cVnYC3NNoL-MTpJPCNKGEy0"}  
32 32 @james:matrix.jamesst.one !neIgyUJkyRiaQaXzcw:matrix.jamesst.one 771 {"event_id":"$AXwywNxaPAAtR8IPUjYmiwB8Ie7LiR5cNnSJNYHc7wQ"}  
33 33 @james:matrix.jamesst.one !lGYWaUWLiRISjCPSPB:matrix.jamesst.one 757 {"event_id":"$Hr0p-T0qRDS9R3xgwq8Jxtm18N6kynsCETjwNA0BxTk"}  
34 34 @telegram_8811074613:matrix.jamesst.one !lGYWaUWLiRISjCPSPB:matrix.jamesst.one 756 {"event_id":"$s5jCFttS2iJZLg3G5Qbpawwe-kXtpfGRBk_3lsF6Vss"}  
35 35 @telegram_1122421532:matrix.jamesst.one !neIgyUJkyRiaQaXzcw:matrix.jamesst.one 509 {"event_id":"$e8Dnp0RF2dJyGxK808mdpZSvdx7v9aPt2XEfnUcPwF4"}  
36 36 @james:matrix.jamesst.one !RiITgghWaCJrZpdhGY:matrix.jamesst.one 865 {"event_id":"$GJLEYzHW1XUABobCjthrRf0u2H5lhjy3AhQEAeoXpwk"}  
37 37 @telegram_1387366216:matrix.jamesst.one !RiITgghWaCJrZpdhGY:matrix.jamesst.one 822 {"event_id":"$9hia1fbWDGZyYEa1p5SaZMe-JfL-jcbHqJmsPu2UFSU"}  
38 38 @james:matrix.jamesst.one !XRCQHojzxCcjgbKOLw:matrix.jamesst.one 717 {"event_id":"$nZu--u73PG5NMZyL0Vpr0gSvUyJM4VuRP-VSFKEbdpo"}  
39 39 @telegram_8606696926:matrix.jamesst.one !XRCQHojzxCcjgbKOLw:matrix.jamesst.one 702 {"event_id":"$yqFmABW_84zWnF3Kn7ykzk_D7MO-MbQzvRq_wFmTPsI"}  
40 40 @james:matrix.jamesst.one !eEZFSbeyIQnTNNbQpI:matrix.jamesst.one 831 {"event_id":"$FJKeS8RqirYBzzbSk_KbXcVFbyrPiPVT5bOjfrpj5Yo"}  
41 41 @telegram_8958700705:matrix.jamesst.one !eEZFSbeyIQnTNNbQpI:matrix.jamesst.one 830 {"event_id":"$k9xn4uoPkJrPfuW9Zvw7eYvlcRp-oclCVOKt4KTkF_w"}  
42 42 @james:matrix.jamesst.one !IHzRTufcvGfePdToKA:matrix.jamesst.one 272 {"event_id":"$iTmQJq-A24DnJCG0XfDRg9M7usTvsEvbVFi2YmBHPlo"}  
43 43 @james:matrix.jamesst.one !lIbMVjkLhcXAfrAtZB:matrix.jamesst.one 501 {"event_id":"$OXKrilI49PKoeFRnxZAEcZ7bmufgiMSLMA30llM45JQ"}  
44 44 @telegram_207034457:matrix.jamesst.one !lIbMVjkLhcXAfrAtZB:matrix.jamesst.one 502 {"event_id":"$OXKrilI49PKoeFRnxZAEcZ7bmufgiMSLMA30llM45JQ"}  
45 45 @james:matrix.jamesst.one !zHfMwFOVNIvEOFILFk:matrix.jamesst.one 508 {"event_id":"$Pm7que-zcgNphLfuO0PVCFw_bvWerFtqXbXV0vGsDkw"}  
46 46 @james:matrix.jamesst.one !PjqdhZmlfPDdghVIcF:matrix.jamesst.one 619 {"event_id":"$QCV8SQpjMIK7Tg0KTKwdcrMaqXFSuGbTvjZqhxI5hxQ"}  
47 47 @telegram_93372553:matrix.jamesst.one !PjqdhZmlfPDdghVIcF:matrix.jamesst.one 618 {"event_id":"$0VvCIG90KY9AWgjmmWDV1Nq6CyA6elYSqN83xJBRLi8"}  
48 48 @james:matrix.jamesst.one !vtjmvorImZVyQlotkU:matrix.jamesst.one 835 {"event_id":"$lOavZ0lH2BMJz529nFxPTITa14nEVCbGWQhG70YcqMQ"}  
49 49 @telegram_8960618118:matrix.jamesst.one !vtjmvorImZVyQlotkU:matrix.jamesst.one 551 {"event_id":"$nnLWN-mBX4VVORrmSGUVERncio2EgEOsv-nBEXoBNuY"}  
50 50 @james:matrix.jamesst.one !wFHnvCTVCABWTmQAPr:matrix.jamesst.one 557 {"event_id":"$BHqwRBpYDQhJjdYol-fECGZhqgW1bR7b2pThhE0LMtA"}  
51 51 @james:matrix.jamesst.one !cvUIlXzvPEzfCASNVJ:matrix.jamesst.one 646 {"event_id":"$vD9hQxg185lGtvnp11bmcgzp3elW31b_f3BuQGbAE1Q"}  
52 52 @james:matrix.jamesst.one !NaElixBrfGQcgnJqep:matrix.jamesst.one 836 {"event_id":"$FKA3GSJ-iYbANXSiLD_Xy6exJjLXnSpJJ7RAUF3zQqo"}  
53 53 @telegram_8927334353:matrix.jamesst.one !NaElixBrfGQcgnJqep:matrix.jamesst.one 738 {"event_id":"$p730Ve7prRLJTuFUQWTT3rrs6z-tqfTwzbK1HRkJrzg"}  
54 54 @james:matrix.jamesst.one !RClwlNcFwZTMVtYGoP:matrix.jamesst.one 647 {"event_id":"$hcLNQ_5g7TqdJcM-G8eFWxVVWYO7GR0dARkwSY_OOHY"}  
55 55 @james:matrix.jamesst.one !XRVvMhEVmKAIwnmNnb:matrix.jamesst.one 659 {"event_id":"$dRr9-xr_bgEZ0UQZ8FDMly4_fv53MQxAB3Xu-SpTzB0"}  
56 56 @james:matrix.jamesst.one !vzovkrujIWfWMwFwpA:matrix.jamesst.one 681 {"event_id":"$Ip0aPmR-OoclQzNsNhYbfgMWGMt_KXYFzDpEU64BGd8"}  
57 57 @james:matrix.jamesst.one !sRPmcdramfDPFjlOkj:matrix.jamesst.one 694 {"event_id":"$Ac9nkLxpbks1dOYFFWkgfQUxC4huPt5Nvnp7vnWqjo8"}  
58 58 @james:matrix.jamesst.one !iAqRRIpGtMsOQFgNGY:matrix.jamesst.one 700 {"event_id":"$nMEFaC_TJJDa-GZZTwCDpUq68JyGQI1p9OTfko-7Ufo"}  
59 59 @james:matrix.jamesst.one !gPsNzZTrmrAWRIkCTS:matrix.jamesst.one 712 {"event_id":"$KwKDjKoWLWBLSRYuBJaNjc3l5iqXKu8rayY6MwM4sEc"}  
60 60 @james:matrix.jamesst.one !cguwnZmgchwVGBBQsA:matrix.jamesst.one 762 {"event_id":"$lKo24K_UQecQfEGU_pNiYDR7YzfXzbywhxoYt5zgAD4"}  
61 61 @james:matrix.jamesst.one !lTPdEfjbFsCQXebAlR:matrix.jamesst.one 898 {"event_id":"$wvACf9RqQRV4n50-NIbY5ZiEGHZ1x71nAWOtDvc6WPA"}  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE room_account_data( user_id TEXT NOT NULL, room_id TEXT NOT NULL, account_data_type TEXT NOT NULL, stream_id BIGINT NOT NULL, content TEXT NOT NULL, instance_name TEXT, CONSTRAINT room_account_data_uniqueness UNIQUE (user_id, room_id, account_data_type) );
CREATE INDEX room_account_data_stream_id on room_account_data(user_id, stream_id);
CREATE INDEX room_account_data_room_id ON room_account_data (room_id) ;