Skip to main content
Schema: monad.gov Table: dim_validators Type: Base Table

What

Dimension table for Monad validators. Combines validator creation data, address mappings, latest snapshot state, and labels to provide a complete validator profile. Key addresses: auth_address is administrative (withdrawals/commission), consensus_address is for block production.

Columns

Column NameData TypeDescription
VALIDATOR_IDNUMBERUnique sequential numeric identifier for the validator
VALIDATOR_NAMETEXTHuman-readable validator name from labels or seed metadata
AUTH_ADDRESSTEXTValidator’s authority address for withdrawals and receiving commission
CONSENSUS_ADDRESSTEXTBlock producer address derived from secp_pubkey via keccak256. Appears as “miner” in block headers. NULL if validator hasn’t produced blocks yet.
CREATED_ATTIMESTAMP_NTZTimestamp when the validator was created
CREATED_BLOCKNUMBERBlock number when the validator was created
CREATION_TX_HASHTEXTTransaction hash of the ValidatorCreated event
INITIAL_COMMISSION_PCTFLOATInitial commission rate as percentage (0-100)
CURRENT_COMMISSION_PCTFLOATCurrent execution commission rate as percentage
CONSENSUS_COMMISSION_PCTFLOATCurrent consensus commission rate as percentage
FLAGSNUMBERValidator status flags (0 = active, 1 = stake too low)
STATUSTEXTHuman-readable status (active, staketoolow, unknown)
SECP_PUBKEYTEXTSecp256k1 public key used for consensus
BLS_PUBKEYTEXTBLS public key used for consensus
LATEST_SNAPSHOT_DATEDATEDate of the most recent validator snapshot
WEBSITETEXTValidator website URL from external metadata
IMAGETEXTValidator logo/image URL from external metadata
CITYTEXTCity where validator node is located
REGIONTEXTState/province/region where validator node is located
COUNTRYTEXTCountry where validator node is located
TIMEZONETEXTTimezone of validator node location
LATITUDEFLOATGeographic latitude of validator node
LONGITUDEFLOATGeographic longitude of validator node
IP_ADDRESSTEXTIP address of validator node
GOV__DIM_VALIDATORS_IDTEXTUnique identifier for this record
INSERTED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was inserted
MODIFIED_TIMESTAMPTIMESTAMP_NTZTimestamp when the record was last modified