osmosis.gov Table: fact_governance_proposal_deposits Type: View
Records of all proposal deposits that have occurred on Osmosis, dating back to the genesis block. At
least 500 OSMO must be deposited for a proposal to be voted on.
Columns
| Column Name | Data Type | Description |
|---|---|---|
| BLOCK_ID | NUMBER | The block height the block was recorded at. |
| BLOCK_TIMESTAMP | TIMESTAMP_NTZ | The date and time at which the block began. |
| TX_ID | TEXT | A unique key that identifies a transaction. Called “TxHash” on block explorers. |
| TX_SUCCEEDED | BOOLEAN | Transaction status is “TRUE” if the transaction was successful, “FALSE” if the transaction failed. |
| DEPOSITOR | TEXT | The wallet address of the individual who deposited funds into the proposal. At least 500 OSMO must be deposited into a proposal after it is submitted for it to go to vote. |
| PROPOSAL_ID | NUMBER | Numeric ID that corresponds to the proposal. |
| AMOUNT | FLOAT | The amount that was used in the transaction message. |
| CURRENCY | TEXT | The currency that was used in the transaction message. |
| DECIMAL | NUMBER | Divide the amount by POW(10, decimal) to get the amount used in the transaction. This value can be NULL, as decimals are hand curated from an outside source and not found on-chain. |
| FACT_GOVERNANCE_PROPOSAL_DEPOSITS_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |