mastodon_accountmastodon_domain_blockmastodon_followermastodon_followingmastodon_list_accountmastodon_my_accountmastodon_my_followermastodon_my_followingmastodon_my_listmastodon_my_tootmastodon_notificationmastodon_peermastodon_ratemastodon_relationshipmastodon_rulemastodon_search_accountmastodon_search_hashtagmastodon_search_tootmastodon_servermastodon_toot_directmastodon_toot_favouritemastodon_toot_federatedmastodon_toot_homemastodon_toot_listmastodon_toot_localmastodon_weekly_activity
Table: mastodon_list_account
Represents an account of a list of yours.
The mastodon_list_account
table can be used to query information about any account, and you must specify the list_id in the where or join clause using the list_id
column.
Examples
List members of a Mastodon list
select url, username, display_namefrom mastodon_list_accountwhere list_id = '42994';
List details for members of all my Mastodon lists
select l.title, a.display_name, a.server, a.followers_count, a.following_countfrom mastodon_my_list l join mastodon_list_account a on l.id = a.list_id;
Count how many of the accounts I follow are assigned (and not assigned) to lists
with list_account as ( select a.id, l.title as list from mastodon_my_list l join mastodon_list_account a on l.id = a.list_id),list_account_follows as ( select list from mastodon_my_following left join list_account using (id))select 'Follows listed' as label, count(*)from list_account_followswhere list is not nullunionselect 'Follows unlisted' as label, count(*)from list_account_followswhere list is null;
.inspect mastodon_list_account
Represents an account of a list of yours.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
acct | text | username@server for the account. |
created_at | timestamp with time zone | Timestamp when the account was created. |
display_name | text | Display name for the account. |
followers_count | bigint | Number of followers for the account. |
following_count | bigint | Number of accounts this account follows. |
id | text | ID of the account. |
instance_qualified_account_url | text | Account URL prefixed with my instance. |
list_id | text | List ID for account. |
note | text | Description of the account. |
server | text | Server for the account. |
statuses_count | bigint | Toots from this account. |
url | text | URL for the account. |
username | text | Username for the account. |