canton.gov Table: fact_vote_results Type: Base Table
What
Description
Tracks DSO governance vote results/outcomes through DsoRules_CloseVoteRequest events. Shows final outcomes including acceptance/rejection, vote counts, accepted/rejected SVs, and abstentions. Uses LATERAL FLATTEN to parse votes array.Key Use Cases
- Analyzing governance decision outcomes
- Understanding vote tallies and participation
- Tracking which SVs voted for/against proposals
- Monitoring abstention and offboarded voter patterns
- Analyzing proposal success/failure rates
Important Relationships
- Final step after
gov__fact_vote_requestsandgov__fact_votes - Aggregates individual votes into final result
- Includes embedded original request details
Commonly-used Fields
outcome: Result tag (typically ‘VRO_Accepted’ or ‘VRO_Rejected’)accept_votes: Count of accept votesreject_votes: Count of reject votesaccepted_svs: Array of SV parties who voted to acceptrejected_svs: Array of SV parties who voted to rejectabstaining_svs: Array of SVs who abstainedtotal_votes_cast: Total number of votescompleted_at: When voting concludedrequester: Original proposal requesteraction: Original proposal actionreason_body: Original proposal reason
Columns
| Column Name | Data Type | Description |
|---|---|---|
| UPDATE_ID | TEXT | UPDATE_ID column |
| MIGRATION_ID | NUMBER | MIGRATION_ID column |
| RECORD_TIME | TIMESTAMP_NTZ | RECORD_TIME column |
| EFFECTIVE_AT | TIMESTAMP_NTZ | EFFECTIVE_AT column |
| EVENT_ID | TEXT | EVENT_ID column |
| EVENT_INDEX | NUMBER | EVENT_INDEX column |
| CHOICE | TEXT | CHOICE column |
| ACTING_PARTIES | VARIANT | ACTING_PARTIES column |
| REQUEST_CID | TEXT | REQUEST_CID column |
| AMULET_RULES_CID | TEXT | AMULET_RULES_CID column |
| CLOSING_SV | TEXT | CLOSING_SV column |
| OUTCOME | TEXT | OUTCOME column |
| OUTCOME_EFFECTIVE_AT | TIMESTAMP_NTZ | OUTCOME_EFFECTIVE_AT column |
| COMPLETED_AT | TIMESTAMP_NTZ | COMPLETED_AT column |
| ACCEPTED_SVS | ARRAY | ACCEPTED_SVS column |
| REJECTED_SVS | ARRAY | REJECTED_SVS column |
| ABSTAINING_SVS | VARIANT | ABSTAINING_SVS column |
| OFFBOARDED_VOTERS | VARIANT | OFFBOARDED_VOTERS column |
| TRACKING_CID | TEXT | TRACKING_CID column |
| REQUESTER | TEXT | REQUESTER column |
| TARGET_EFFECTIVE_AT | TIMESTAMP_NTZ | TARGET_EFFECTIVE_AT column |
| VOTE_BEFORE | TIMESTAMP_NTZ | VOTE_BEFORE column |
| ACTION | TEXT | ACTION column |
| DSO_ACTION | TEXT | DSO_ACTION column |
| AMULET_RULES_ACTION | TEXT | AMULET_RULES_ACTION column |
| DSO_ACTION_VALUE | VARIANT | DSO_ACTION_VALUE column |
| AMULET_RULES_VALUE | VARIANT | AMULET_RULES_VALUE column |
| REASON_BODY | TEXT | REASON_BODY column |
| REASON_URL | TEXT | REASON_URL column |
| TOTAL_VOTES_CAST | NUMBER | TOTAL_VOTES_CAST column |
| ABSTAINING_COUNT | NUMBER | ABSTAINING_COUNT column |
| OFFBOARDED_COUNT | NUMBER | OFFBOARDED_COUNT column |
| ACCEPT_VOTES | NUMBER | ACCEPT_VOTES column |
| REJECT_VOTES | NUMBER | REJECT_VOTES column |
| CONTRACT_ID | TEXT | CONTRACT_ID column |
| FACT_VOTE_RESULT_ID | TEXT | FACT_VOTE_RESULT_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |
| EVENT_JSON | VARIANT | EVENT_JSON column |