Skip to main content
Schema: solana.gov Table: fact_vote_accounts Type: Base Table

​
Description

This table tracks vote accounts on the Solana blockchain, capturing vote account creation, updates, and operational status. Vote accounts are essential components of Solana’s consensus mechanism, representing the voting power of validators and enabling stake-weighted voting on network decisions.

​
Key Use Cases

  • Track vote account creation and lifecycle management
  • Analyze vote account performance and voting participation
  • Monitor vote account balance changes and stake distribution
  • Study validator voting patterns and network consensus
  • Support staking analytics and validator performance analysis

​
Important Relationships

  • Links to gov.fact_validators through vote_pubkey for validator-vote account mapping
  • Connects to gov.fact_stake_accounts for stake distribution analysis
  • References core.fact_blocks and core.fact_transactions for blockchain context
  • Provides vote account context for gov.fact_rewards_voting

​
Commonly-used Fields

  • block_timestamp: Timestamp when the vote account event occurred
  • tx_id: Unique transaction identifier for the vote account event
  • vote_pubkey: Address of the vote account
  • node_pubkey: Address of the validator node associated with the vote account
  • authorized_voter: Address authorized to vote on behalf of the vote account
  • authorized_withdrawer: Address authorized to withdraw from the vote account
  • commission: Commission rate for the vote account
  • vote_balance: Current voting balance of the account
  • vote_credits: Vote credits earned by the account

​
Columns

Column NameData TypeDescription
EPOCHNUMBER
VOTE_PUBKEYTEXT
NODE_PUBKEYTEXT
AUTHORIZED_VOTERTEXT
AUTHORIZED_WITHDRAWERTEXT
COMMISSIONNUMBER
EPOCH_CREDITSARRAY
LAST_EPOCH_ACTIVENUMBER
LAST_TIMESTAMP_SLOTNUMBER
LAST_TIMESTAMPTIMESTAMP_TZ
PRIOR_VOTERSARRAY
ROOT_SLOTNUMBER
VOTESARRAY
ACCOUNT_SOLFLOAT
OWNERTEXT
RENT_EPOCHNUMBER
FACT_VOTE_ACCOUNTS_IDTEXTA unique, stable identifier for each record in this table. The primary key (PK) ensures that every row is uniquely identifiable and supports efficient joins, lookups, and data integrity across models. The PK may be a natural key (such as a blockchain transaction hash) or a surrogate key generated from one or more fields, depending on the table’s structure and requirements.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe timestamp when this transaction record was first inserted into the analytics database. Used for data freshness tracking and incremental model logic. Format: YYYY-MM-DD HH:MI:SS. Not derived from the blockchain, but from the ETL process.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe timestamp when this transaction record was last updated in the analytics database. Used for tracking updates and supporting incremental model logic. Format: YYYY-MM-DD HH:MI:SS. Not derived from the blockchain, but from the ETL process.