Accounts

The Accounts table is a non-transactional table and contains a list of all accounts and related information resulting from the activity of accounts on the blockchain.

Columns

Name	Description
id	blockchain internal identifier
name	account name
owner	owner authorities
active	active authorities
posting	posting authorities
memo_key	memo public key
json_metadata	account metatada (updated with active key)
posting_json_metadata	account metatada (updated with posting key)
proxy	account to which governance votes are proxied
last_owner_update	last time of owner authorities change
last_account_update	last time the account data have been updated
created	account creation time
mined	set to true if the account has been created through mining
recovery_account	recovery account
last_account_recovery	the last time the account has been recovered
post_count	total number of posts and comments published
voting_manabar_current_mana	current upvote mana
voting_manabar_last_update_time	last time the upvote mana has been updated
downvote_manabar_current_mana	current downvote mana
downvote_manabar_last_update_time	last time the downvote mana has been updated
voting_power	current voting power (integer value - must be divided by 100)
last_vote_time	last time account voted
balance	HIVE balance
balance_symbol	"HIVE"
savings_balance	HIVE savings balance
savings_balance_symbol	"HIVE'"
hbd_balance	HBD balance
hbd_balance_symbol	"HBD"
hbd_seconds	used to compute interest value
hbd_seconds_last_update	used to compute interest value
hbd_last_interest_payment	the last time interest has been paid
savings_hbd_balance	HBD saving balance
savings_hbd_balance_symbol	"HBD"
savings_hbd_seconds	used to compute interest value
savings_hbd_seconds_last_update	used to compute interest value
savings_hbd_last_interest_payment	the last time interest has been paid on savings
savings_withdraw_requests	number of pending savings withdrawal requests
reward_hbd_balance	claimable reward HBD balance
reward_hbd_balance_symbol	"HBD"
reward_hive_balance	claimable reward HIVE balance
reward_hive_balance_symbol	"HIVE"
reward_vesting_balance	claimable reward VESTS balance (HP)
reward_vesting_balance_symbol	"VESTS"
reward_vesting_hive	claimable reward VESTS balance converted into HIVE
reward_vesting_hive_symbol	"HIVE"
vesting_shares	amount of Hive Power
vesting_shares_symbol	VESTS
delegated_vesting_shares	amount of Hive Power delegated
delegated_vesting_shares_symbol	VESTS
received_vesting_shares	amount of Hive Power delegation received
received_vesting_shares_symbol	VESTS
vesting_withdraw_rate	amount HP to powered down by week
vesting_withdraw_rate_symbol	VESTS
next_vesting_withdrawal	next powerdown time
withdrawn	total amount powered down (in VESTS)
to_withdraw	current amount to power down (VESTS)
withdraw_routes	number of active withdrawal routes
curation_rewards	total curation reward (HP equivalent)
posting_rewards	total author reward (HP equivalent)
proxied_vsf_votes	use to compute the amount of HP proxied
witnesses_voted_for	an array of witnesses the account is voting for
last_post	last post or comment time
last_root_post	last post time
pending_claimed_accounts	number of account creation ticked collected
vesting_balance	amount of Hive Power delayed for voting
vesting_balance_symbol	VESTS
reputation	a big integer number that represents the reputation acquired over time.
reputation_ui	a human-readable value of the reputation
witness_votes	number of witnesses votes for
post_voting_power	Effective HP that are used for curation (vesting_shares - delegated_vesting_shares + received_vesting_shares)
post_voting_power_symbol	VESTS
pending_transfers	Pending transfers for escrow operations
governance_vote_expiration_ts	date and time that the account governance votes for witnesses and proposals will expire
delayed_votes	a JSON array of objects with the following properties: date and time that the additional HP recently powered up will be taken into account for governance value of the additional HP that will be taken into account for governance after the delay
open_recurrent_transfers	Number of recurring transfers scheduled for execution

Notes:

This table is not updated in real-time when an operation involving an account requires its state to be updated. Therefore, there may be a slight difference in the information provided by the blockchain API.

Read this post by @themarkymark to learn what hbd_secondsand hbd_seconds_last_update are and how they are used to compute interests.