account_data
15 rows
This data as json, CSV (advanced)
Suggested facets: content
| Link | rowid ▼ | user_id | account_data_type | stream_id | content | instance_name |
|---|---|---|---|---|---|---|
| 1 | 1 | @james:matrix.jamesst.one | org.matrix.msc3890.local_notification_settings.GCKNIFMVHE | 3 | {"is_silenced":false} | |
| 2 | 2 | @james:matrix.jamesst.one | io.element.recovery | 691 | {"enabled":true} | |
| 3 | 3 | @james:matrix.jamesst.one | im.vector.analytics | 5 | {"pseudonymousAnalyticsOptIn":false} | |
| 4 | 4 | @james:matrix.jamesst.one | im.vector.web.settings | 678 | {"releaseAnnouncementData":{"room_list_section":true},"MessageComposerInput.insertTrailingColon":true} | |
| 5 | 5 | @james:matrix.jamesst.one | im.vector.setting.breadcrumbs | 711 | {"recent_rooms":["!gPsNzZTrmrAWRIkCTS:matrix.jamesst.one","!iAqRRIpGtMsOQFgNGY:matrix.jamesst.one","!sRPmcdramfDPFjlOkj:matrix.jamesst.one","!YuTkIZfXxcPwXTVVSR:matrix.jamesst.one","!SDKfvPWzsJhxMNhQkd:matrix.jamesst.one","!kmdRsngzhPskLVDewK:matrix.jamesst.one","!AjpMviLfmfMMUkRlkw:matrix.jamesst.one","!wtqlekpwOtgIKIzUye:matrix.jamesst.one","!lTPdEfjbFsCQXebAlR:matrix.jamesst.one","!BlgOiSpdKGmaXVClci:matrix.jamesst.one","!RrBJXVCuqleqRhuBDi:matrix.jamesst.one","!FMIBicfcNbhIoPeYcL:matrix.jamesst.one","!HenNzFPhosZJtuised:matrix.jamesst.one","!sbaLjvmTgcNwiUXJXQ:matrix.jamesst.one","!TuuVfHAWQDmtlxZyTc:matrix.jamesst.one","!vahPHWhsPlyBiaHXaN:matrix.jamesst.one","!rLmxJOIqnIApSVZkgA:matrix.jamesst.one","!KZlTJxlsaqnNdTwXLo:matrix.jamesst.one","!IqKjJhnnpxKUCjPExL:matrix.jamesst.one","!tbPxpXHdNUSHVECIwW:matrix.jamesst.one"]} | |
| 6 | 6 | @james:matrix.jamesst.one | m.direct | 78 | {"@telegrambot:matrix.jamesst.one":["!vahPHWhsPlyBiaHXaN:matrix.jamesst.one"],"@signalbot:matrix.jamesst.one":["!RrBJXVCuqleqRhuBDi:matrix.jamesst.one"],"@telegram_1126947413:matrix.jamesst.one":["!FMIBicfcNbhIoPeYcL:matrix.jamesst.one"],"@slackbot:matrix.jamesst.one":["!BlgOiSpdKGmaXVClci:matrix.jamesst.one"]} | |
| 7 | 7 | @james:matrix.jamesst.one | org.matrix.msc3890.local_notification_settings.HMCRCRAOHC | 666 | {"is_silenced":false} | |
| 8 | 8 | @james:matrix.jamesst.one | m.cross_signing.master | 687 | {"encrypted":{"wq5vHy0Cm9QGFYFSHeC3iSviUsUriUnQ":{"iv":"10ElJKiFiQdYJbLuezeAXA==","ciphertext":"9f045+XeX/Ywyt4ffEykiAcB33FZFStbcU10hghtRaRYJQaXc4/r+KGNZQ==","mac":"bedNZ/yVG8zmFGgFwNDhOR5eXPmZ/agFifAfZKj0+lk="}}} | |
| 9 | 9 | @james:matrix.jamesst.one | m.cross_signing.self_signing | 689 | {"encrypted":{"wq5vHy0Cm9QGFYFSHeC3iSviUsUriUnQ":{"iv":"rc6/aloQuPQ/D2aFQHnwKw==","ciphertext":"huMJQkJHd+d69DeWAYO/qmPl2rwST5u+fuUErOP8kyFP40Z4/u+hOQQX2g==","mac":"NA2YpBt4OwsJW1gS787OLNoKoYOzAymTKHYNsgVyWBA="}}} | |
| 10 | 10 | @james:matrix.jamesst.one | m.cross_signing.user_signing | 688 | {"encrypted":{"wq5vHy0Cm9QGFYFSHeC3iSviUsUriUnQ":{"iv":"UYZdwWCyZqdzb2Kwwb+r+Q==","ciphertext":"QZ09OClFqgmmfywMbaj9792kvLhPZ0j5PCTiDJmiYxX5yIbnzBzOmREOvw==","mac":"nPDLNl49v1MsIjFRN2/5kjfuCaoyOy3EPL27PTkuzgI="}}} | |
| 11 | 11 | @james:matrix.jamesst.one | m.megolm_backup.v1 | 690 | {"encrypted":{"wq5vHy0Cm9QGFYFSHeC3iSviUsUriUnQ":{"iv":"NA8keHUWQEkVs8opSl8ZLA==","ciphertext":"4OX+Cg3jCzFvz3WMfR3ihGTFL574YEFvW0vU27jLepcuFN6PTmQKupWi4w==","mac":"Hg7o5UyNJKIQySKZ4KzvY/sGyQETe2UL00s0k7rxGMU="}}} | |
| 12 | 12 | @james:matrix.jamesst.one | m.secret_storage.default_key | 686 | {"key":"wq5vHy0Cm9QGFYFSHeC3iSviUsUriUnQ"} | |
| 13 | 13 | @james:matrix.jamesst.one | m.key_backup | 683 | {"enabled":true} | |
| 14 | 14 | @james:matrix.jamesst.one | m.org.matrix.custom.backup_disabled | 684 | {"disabled":false} | |
| 15 | 15 | @james:matrix.jamesst.one | m.secret_storage.key.wq5vHy0Cm9QGFYFSHeC3iSviUsUriUnQ | 685 | {"algorithm":"m.secret_storage.v1.aes-hmac-sha2","iv":"xSYY42pP+9hYU2n/8kGyew==","mac":"MNGvDNDFSZtL/fFbvicILHztvFZ4/qRwdBqHCsk0pb4="} |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE account_data( user_id TEXT NOT NULL, account_data_type TEXT NOT NULL, stream_id BIGINT NOT NULL, content TEXT NOT NULL, instance_name TEXT, CONSTRAINT account_data_uniqueness UNIQUE (user_id, account_data_type) ); CREATE INDEX account_data_stream_id on account_data(user_id, stream_id);