Skip to main content
Schema: cosmos.gov Table: fact_validators Type: View A table that contains labels for and additional information about Cosmos Hub validators

Columns

Column NameData TypeDescription
ADDRESSTEXTAddress unique to an individual wallet, validator, or token.
BLOCKCHAINTEXTIn this table, always Cosmos. Used to join to cross-chain tables.
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 Cosmos address of the user / entity that operates the validator.
DELEGATOR_SHARESNUMBERThe number of tokens staked to the validator.
SELF_DELEGATIONNUMBERThe number of ATOM tokens that the operator currently has staked with their own validator.
NUM_DELEGATORSNUMBERThe number of wallets that stake their ATOM tokens with the validator.
RATENUMBERThe commission rate that the validator is currently charging.
MAX_CHANGE_RATENUMBERThe maximum rate at which a validator can change their commission per day.
MAX_RATENUMBERThe maximum commission rate that the validator can charge
COMMISSION_RATE_LAST_UPDATEDTIMESTAMP_NTZThe date of the last commission change.
STATUSTEXTValidators with a status of BOND_STATUS_BONDED are active and validators with a status of BOND_STATUS_UNBONDED are inactive.
JAILEDBOOLEANFALSE when a validator is not jailed, TRUE when a validator is jailed
RANKNUMBERThe rank of the validator in the validator set. Rank is determined by the number of ATOM tokens staked to the validator
NUM_GOVERNANCE_VOTESNUMBERThe number of governance proposals the validator has voted on during its lifetime.
RAW_METADATAVARIANTAdditional details about the validator or token in json format.
UNIQUE_KEYTEXTThe unique key of the table
FACT_VALIDATORS_IDTEXTThe unique identifier for each row in the table.
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.