osmosis.gov Table: fact_governance_submit_proposal Type: View
Records of all proposal submissions on Osmosis, dating back to the Genesis block.
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. |
| PROPOSER | TEXT | The address of the validator that submitted the proposal. |
| PROPOSAL_ID | NUMBER | Numeric ID that corresponds to the proposal. |
| PROPOSAL_TYPE | TEXT | The type of proposal that was submitted. |
| PROPOSAL_TITLE | TEXT | The title of the governance proposal that was submitted on-chain. |
| PROPOSAL_DESCRIPTION | TEXT | The description or body of the governance proposal. |
| FACT_GOVERNANCE_SUBMIT_PROPOSAL_ID | TEXT | |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ |