Skip to main content
Schema: crosschain.cosmos Table: fact_validators Type: View

What

Contains validator metadata for Axelar and Cosmos.

Columns

Column NameData TypeDescription
BLOCKCHAINTEXTThe name of the blockchain
ADDRESSTEXTAddress unique to an individual wallet, validator, or token.
CREATORTEXTName of the label creator - for now, this will always be “Flipside.”
LABEL_TYPETEXTA broad category that describes what a label is representing.
LABEL_SUBTYPETEXTAdds more detail to the label type.
LABELTEXTThe label or name of the address.
PROJECT_NAMETEXTThe name of the project the label belongs to.
ACCOUNT_ADDRESSTEXTThe osmosis address of the user / entity that operates the validator.
DELEGATOR_SHARESNUMBERThe number of tokens staked to the validator.
JAILEDBOOLEANFALSE when a validator is not jailed, TRUE when a validator is jailed
MAX_CHANGE_RATEFLOATThe maximum rate at which a validator can change their commission per day.
MAX_RATEFLOATThe maximum commission rate that the validator can charge
MIN_SELF_DELEGATIONNUMBERThe minimum number of OSMO tokens that the operator must be staking with their own validator
RANKNUMBERThe rank of the validator in the validator set. Rank is determined by the number of OSMO tokens staked to the validator
MISSED_BLOCKSTEXTThe number of blocks the validator has been down for during it’s lifetime.
RAW_METADATAVARIANTAdditional details about the validator or token in json format.
INSERTED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was inserted into the table.
MODIFIED_TIMESTAMPTIMESTAMP_NTZThe utc timestamp at which the row was last modified.
FACT_VALIDATORS_IDTEXTThe unique identifier for each row in the table.