Skip to main content
Schema: stellar.core Table: fact_accounts Type: Base Table The accounts table stores detailed information for a given account, including current account status, preconditions for transaction authorization, security settings and account balance. The balance reported in the accounts table reflects the account’s XLM balance only. All other asset balances are reported in the ‘trust_lines’ table. Any changes to the account, whether it is an account settings change, balance increase/decrease or sponsorship change will result in an increase to the account sequence_number and last_modified_ledger. The sequence_number is incremented with each operation applied to an account so that order is preserved during account mutation. Learn more about Stellar accounts: https://developers.stellar.org/docs/learn/fundamentals/stellar-data-structures/accounts

​
Columns

Column NameData TypeDescription
ACCOUNT_IDTEXTThe address of the account. The address is the account’s public key encoded in base32. All account addresses start with a ‘G’.
BALANCEFLOATThe number of units of XLM held by the account.
BUYING_LIABILITIESFLOATThe sum of all buy offers owned by this account for XLM only.
SELLING_LIABILITIESFLOATThe sum of all sell offers owned by this account for XLM only.
SEQUENCE_NUMBERNUMBERThe account’s current sequence number. The sequence number controls operations applied to an account. Operations must submit a unique sequence number that is incremented by 1 in order to apply the operation to the account so that account changes will not collide within a ledger.
NUM_SUBENTRIESNUMBERThe total number of ledger entries connected to this account. Ledger entries include: trustlines, offers, signers, and data entries. (Claimable balances are counted under sponsoring entries, not subentries). Any newly created trustline, offer, signer or data entry will increase the number of subentries by 1. Accounts may have up to 1,000 subentries.
INFLATION_DESTINATIONTEXTDeprecated: The account address to receive an inflation payment when they are disbursed on the network.
FLAGSNUMBERDenotes the enabling and disabling of certain asset issuer privileges.
HOME_DOMAINTEXTThe domain that hosts this account’s stellar.toml file.
MASTER_WEIGHTNUMBERThe weight of the master key, which is the private key for this account. If a master key is ‘0’, the account is locked and cannot be used.
THRESHOLD_LOWNUMBERThe sum of the weight of all signatures that sign a transaction for the low threshold operation. The weight must exceed the set threshold for the operation to succeed.
THRESHOLD_MEDIUMNUMBERThe sum of the weight of all signatures that sign a transaction for the medium threshold operation. The weight must exceed the set threshold for the operation to succeed.
THRESHOLD_HIGHNUMBERThe sum of the weight of all signatures that sign a transaction for the high threshold operation. The weight must exceed the set threshold for the operation to succeed.
LAST_MODIFIED_LEDGERNUMBERThe ledger sequence number when the ledger entry was last modified. Deletions do not count as a modification and will report the prior modification sequence number.
LEDGER_ENTRY_CHANGENUMBERCode that describes the ledger entry change type that was applied to the ledger entry.
DELETEDBOOLEANIndicates whether the ledger entry (account, claimable balance, trust line, offer, liquidity pool) has been deleted or not. Once an entry is deleted, it cannot be recovered.
SPONSORTEXTThe account address of the sponsor who is paying the reserves for this ledger entry.
NUM_SPONSOREDNUMBERThe number of reserves sponsored for this account (meaning another account is paying for the minimum balance). Sponsored entries do not incur any reserve requirement on the account that owns the entry.
NUM_SPONSORINGNUMBERThe number of reserves sponsored by this account. Entries sponsored by this account incur a reserve requirement.
SEQUENCE_LEDGERNUMBERThe unsigned 32-bit ledger number of the sequence number’s age.
SEQUENCE_TIMETIMESTAMP_NTZThe UNIX timestamp of the sequence number’s age.
CLOSED_ATTIMESTAMP_NTZTimestamp when the ledger was closed and committed to the network. Ledgers are expected to close ~every 5 seconds.
BLOCK_TIMESTAMPTIMESTAMP_NTZA clone of closed_at for join convenience.
LEDGER_SEQUENCENUMBERThe sequence number of the ledger.
FACT_ACCOUNTS_IDTEXTUnique primary key for the dimension table, used as the main identifier for each record.
INSERTED_TIMESTAMPTIMESTAMP_NTZTimestamp when this record was inserted.
MODIFIED_TIMESTAMPTIMESTAMP_NTZTimestamp when this record was last modified.