device_lists_stream

14 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: user_id

Link rowid ▼ stream_id user_id device_id instance_name
4 4 8 @james:matrix.jamesst.one Oi5QZOyyZJVbV9FPusyh+NPMTx6k2mXS9NJrIdsU5Zw master
5 5 9 @james:matrix.jamesst.one c2IY8LelH/ymXkKQyvY/3lrg6j8m3AFJ8R3Hp/uam4M master
7 7 11 @james:matrix.jamesst.one BLSFYMBGKR master
10 10 15 @james:matrix.jamesst.one FQEGQAFPAE master
13 13 18 @tmprecover:matrix.jamesst.one ERGSHGGFTY master
16 16 21 @james:matrix.jamesst.one GFIKGSCTSI master
17 17 22 @james:matrix.jamesst.one MXTGLFTEKF master
19 19 25 @james:matrix.jamesst.one GCKNIFMVHE master
20 20 27 @james:matrix.jamesst.one oOEYiqAZIau+3IABvdDpCR0EsripJsloRjQlM1dZhMQ master
21 21 28 @james:matrix.jamesst.one SXUa7oVbKuTMpVGAGVpvD5hmSVcXyZfj3+u73V0V8jg master
22 22 29 @james:matrix.jamesst.one HMCRCRAOHC master
23 23 30 @james:matrix.jamesst.one QFLPWPBVQG master
24 24 31 @james:matrix.jamesst.one SQNYUGEDGX master
25 25 32 @james:matrix.jamesst.one SZXXSYDHEN master

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE device_lists_stream ( stream_id BIGINT NOT NULL, user_id TEXT NOT NULL, device_id TEXT NOT NULL , instance_name TEXT);
CREATE INDEX device_lists_stream_id ON device_lists_stream(stream_id, user_id);
CREATE INDEX device_lists_stream_user_id ON device_lists_stream (user_id, device_id);