users
634 rows
This data as json, CSV (advanced)
Suggested facets: password_hash, admin, appservice_id, deactivated
| Link | rowid ▼ | name | password_hash | creation_ts | admin | upgrade_ts | is_guest | appservice_id | consent_version | consent_server_notice_sent | user_type | deactivated | shadow_banned | consent_ts | approved | locked | suspended |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | @telegrambot:matrix.jamesst.one | 1784870992 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 2 | 2 | @gmessagesbot:matrix.jamesst.one | 1784871000 | 0 | 0 | gmessages | 0 | 0 | 1 | 0 | 0 | ||||||
| 3 | 3 | @messengerbot:matrix.jamesst.one | 1784871000 | 0 | 0 | messenger | 0 | 0 | 1 | 0 | 0 | ||||||
| 4 | 4 | @slackbot:matrix.jamesst.one | 1784871000 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 5 | 5 | @signalbot:matrix.jamesst.one | 1784871000 | 0 | 0 | signal | 0 | 0 | 1 | 0 | 0 | ||||||
| 6 | 6 | @whatsappbot:matrix.jamesst.one | 1784871000 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | |||||||
| 7 | 7 | @james:matrix.jamesst.one | $2b$12$9qAkzjNLbeG8CYaotWX87Oea8qQiAhspClehg.fGcWmYV.CrdsagG | 1784894365 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | ||||||
| 8 | 8 | @telegram_1041016903:matrix.jamesst.one | 1784896365 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 9 | 9 | @telegram_6193339016:matrix.jamesst.one | 1784896365 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 10 | 10 | @telegram_1130788997:matrix.jamesst.one | 1784896365 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 11 | 11 | @telegram_1126947413:matrix.jamesst.one | 1784896366 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 12 | 12 | @telegram_8606696926:matrix.jamesst.one | 1784896367 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 13 | 13 | @telegram_1122421532:matrix.jamesst.one | 1784896367 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 14 | 14 | @telegram_836113426:matrix.jamesst.one | 1784896367 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 15 | 15 | @telegram_1387366216:matrix.jamesst.one | 1784896367 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 16 | 16 | @telegram_27789308:matrix.jamesst.one | 1784896702 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 17 | 17 | @telegram_108815787:matrix.jamesst.one | 1784896702 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 18 | 18 | @telegram_207034457:matrix.jamesst.one | 1784896703 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 19 | 19 | @telegram_219161728:matrix.jamesst.one | 1784896704 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 20 | 20 | @telegram_226296142:matrix.jamesst.one | 1784896704 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 21 | 21 | @telegram_423685857:matrix.jamesst.one | 1784896704 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 22 | 22 | @telegram_632011217:matrix.jamesst.one | 1784896705 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 23 | 23 | @telegram_930646043:matrix.jamesst.one | 1784896705 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 24 | 24 | @telegram_1078232703:matrix.jamesst.one | 1784896705 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 25 | 25 | @telegram_1166657052:matrix.jamesst.one | 1784896705 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 26 | 26 | @telegram_1528352840:matrix.jamesst.one | 1784896706 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 27 | 27 | @telegram_1629558298:matrix.jamesst.one | 1784896706 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 28 | 28 | @telegram_1779778499:matrix.jamesst.one | 1784896706 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 29 | 29 | @telegram_1975840514:matrix.jamesst.one | 1784896706 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 30 | 30 | @telegram_2004365762:matrix.jamesst.one | 1784896706 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 31 | 31 | @telegram_2088636365:matrix.jamesst.one | 1784896706 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 32 | 32 | @telegram_5430882753:matrix.jamesst.one | 1784896707 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 33 | 33 | @telegram_5721525852:matrix.jamesst.one | 1784896707 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 34 | 34 | @telegram_5976377397:matrix.jamesst.one | 1784896707 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 35 | 35 | @telegram_6165847276:matrix.jamesst.one | 1784896707 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 36 | 36 | @telegram_6543058547:matrix.jamesst.one | 1784896707 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 37 | 37 | @telegram_6613555668:matrix.jamesst.one | 1784896707 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 38 | 38 | @telegram_6635143557:matrix.jamesst.one | 1784896709 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 39 | 39 | @telegram_6705581331:matrix.jamesst.one | 1784896709 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 40 | 40 | @telegram_6718896527:matrix.jamesst.one | 1784896709 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 41 | 41 | @telegram_6906796834:matrix.jamesst.one | 1784896709 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 42 | 42 | @telegram_6955455707:matrix.jamesst.one | 1784896709 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 43 | 43 | @telegram_6988613307:matrix.jamesst.one | 1784896710 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 44 | 44 | @telegram_7312768331:matrix.jamesst.one | 1784896711 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 45 | 45 | @telegram_7411105576:matrix.jamesst.one | 1784896711 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 46 | 46 | @telegram_7451499664:matrix.jamesst.one | 1784896711 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 47 | 47 | @telegram_7582832597:matrix.jamesst.one | 1784896711 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 48 | 48 | @telegram_7673194652:matrix.jamesst.one | 1784896711 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 49 | 49 | @telegram_7687326643:matrix.jamesst.one | 1784896712 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 50 | 50 | @telegram_7710392778:matrix.jamesst.one | 1784896712 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 51 | 51 | @telegram_7727835414:matrix.jamesst.one | 1784896712 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 52 | 52 | @telegram_7775385788:matrix.jamesst.one | 1784896712 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 53 | 53 | @telegram_7808848518:matrix.jamesst.one | 1784896712 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 54 | 54 | @telegram_7962508633:matrix.jamesst.one | 1784896713 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 55 | 55 | @telegram_8017088146:matrix.jamesst.one | 1784896713 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 56 | 56 | @telegram_8069975634:matrix.jamesst.one | 1784896713 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 57 | 57 | @telegram_8093947620:matrix.jamesst.one | 1784896713 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 58 | 58 | @telegram_8240827059:matrix.jamesst.one | 1784896713 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 59 | 59 | @telegram_8248291747:matrix.jamesst.one | 1784896713 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 60 | 60 | @telegram_8294032301:matrix.jamesst.one | 1784896713 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 61 | 61 | @telegram_8392104260:matrix.jamesst.one | 1784896714 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 62 | 62 | @telegram_8412421176:matrix.jamesst.one | 1784896714 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 63 | 63 | @telegram_8465481152:matrix.jamesst.one | 1784896714 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 64 | 64 | @telegram_8564856193:matrix.jamesst.one | 1784896714 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 65 | 65 | @telegram_8707340117:matrix.jamesst.one | 1784896714 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 66 | 66 | @telegram_8785949451:matrix.jamesst.one | 1784896714 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 67 | 67 | @telegram_1224624669:matrix.jamesst.one | 1784897886 | 0 | 0 | telegram | 0 | 0 | 1 | 0 | 0 | ||||||
| 68 | 68 | @slack_t0qh48pl4-u072zlzmnmc:matrix.jamesst.one | 1784897908 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 69 | 69 | @slack_t0qh48pl4-u0qp0kp99:matrix.jamesst.one | 1784897914 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 70 | 70 | @slack_t0qh48pl4-u0913prk5cn:matrix.jamesst.one | 1784897915 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 71 | 71 | @slack_t0qh48pl4-u0qj48vtr:matrix.jamesst.one | 1784897915 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 72 | 72 | @slack_t0qh48pl4-u0608b22pja:matrix.jamesst.one | 1784897915 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 73 | 73 | @slack_t0qh48pl4-u1ad08sp4:matrix.jamesst.one | 1784897915 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 74 | 74 | @slack_t0qh48pl4-u0qk730nn:matrix.jamesst.one | 1784897915 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 75 | 75 | @slack_t0qh48pl4-u0a68v69v3r:matrix.jamesst.one | 1784897915 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 76 | 76 | @slack_t0qh48pl4-uslackbot:matrix.jamesst.one | 1784897915 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 77 | 77 | @slack_t0qh48pl4-uslack:matrix.jamesst.one | 1784897915 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 78 | 78 | @slack_t0qh48pl4-u0qnzutjn:matrix.jamesst.one | 1784897915 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 79 | 79 | @slack_t0qh48pl4-ule84aeba:matrix.jamesst.one | 1784897915 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 80 | 80 | @slack_t0qh48pl4-u0qnrl7qq:matrix.jamesst.one | 1784897915 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 81 | 81 | @slack_t0qh48pl4-u3hhys7c6:matrix.jamesst.one | 1784897915 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 82 | 82 | @slack_t0qh48pl4-u01mt9hl6nb:matrix.jamesst.one | 1784897915 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 83 | 83 | @slack_t0qh48pl4-uk3qmm4bz:matrix.jamesst.one | 1784897916 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 84 | 84 | @slack_t0qh48pl4-uedrhj7gt:matrix.jamesst.one | 1784897916 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 85 | 85 | @slack_t0qh48pl4-u0qh48pn0:matrix.jamesst.one | 1784897916 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 86 | 86 | @slack_t0qh48pl4-u3gelhgql:matrix.jamesst.one | 1784897916 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 87 | 87 | @slack_t0qh48pl4-u0qnts7ge:matrix.jamesst.one | 1784897916 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 88 | 88 | @slack_t0qh48pl4-u02rf50p8tt:matrix.jamesst.one | 1784897917 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 89 | 89 | @slack_t0qh48pl4-upj758cjz:matrix.jamesst.one | 1784897917 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 90 | 90 | @slack_t0qh48pl4-u0qp3q866:matrix.jamesst.one | 1784897917 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 91 | 91 | @slack_t0qh48pl4-u0qp4b6mr:matrix.jamesst.one | 1784897917 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 92 | 92 | @slack_t0qh48pl4-u02d6mfty76:matrix.jamesst.one | 1784897917 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 93 | 93 | @slack_t0qh48pl4-ukp54fz0u:matrix.jamesst.one | 1784897917 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 94 | 94 | @slack_t0qh48pl4-u1z24gru3:matrix.jamesst.one | 1784897917 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 95 | 95 | @slack_t0qh48pl4-u3p7e6ucb:matrix.jamesst.one | 1784897918 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 96 | 96 | @slack_t0qh48pl4-u0118lgkg0l:matrix.jamesst.one | 1784897918 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 97 | 97 | @slack_t0qh48pl4-u3pdpf07p:matrix.jamesst.one | 1784897918 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 98 | 98 | @slack_t0qh48pl4-u3gaaa8rz:matrix.jamesst.one | 1784897918 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 99 | 99 | @slack_t0qh48pl4-uk3qfnct1:matrix.jamesst.one | 1784897918 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 | ||||||
| 100 | 100 | @slack_t0qh48pl4-uk2rre5h6:matrix.jamesst.one | 1784897918 | 0 | 0 | slack | 0 | 0 | 1 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE users( name TEXT, password_hash TEXT, creation_ts BIGINT, admin SMALLINT DEFAULT 0 NOT NULL, upgrade_ts BIGINT, is_guest SMALLINT DEFAULT 0 NOT NULL, appservice_id TEXT, consent_version TEXT, consent_server_notice_sent TEXT, user_type TEXT DEFAULT NULL, deactivated SMALLINT DEFAULT 0 NOT NULL, shadow_banned BOOLEAN, consent_ts bigint, approved BOOLEAN, locked BOOLEAN DEFAULT FALSE NOT NULL, suspended BOOLEAN DEFAULT FALSE NOT NULL, UNIQUE(name) ); CREATE INDEX users_creation_ts ON users (creation_ts);