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

​
What

​
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
EPOCHNUMBEREPOCH column
VOTE_PUBKEYTEXTVOTE_PUBKEY column
NODE_PUBKEYTEXTNODE_PUBKEY column
AUTHORIZED_VOTERTEXTAUTHORIZED_VOTER column
AUTHORIZED_WITHDRAWERTEXTAUTHORIZED_WITHDRAWER column
COMMISSIONNUMBERCOMMISSION column
EPOCH_CREDITSARRAYEPOCH_CREDITS column
LAST_EPOCH_ACTIVENUMBERLAST_EPOCH_ACTIVE column
LAST_TIMESTAMP_SLOTNUMBERLAST_TIMESTAMP_SLOT column
LAST_TIMESTAMPTIMESTAMP_TZLAST_TIMESTAMP column
PRIOR_VOTERSARRAYPRIOR_VOTERS column
ROOT_SLOTNUMBERROOT_SLOT column
VOTESARRAYVOTES column
ACCOUNT_SOLFLOATACCOUNT_SOL column
OWNERTEXTOWNER column
RENT_EPOCHNUMBERRENT_EPOCH column
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.