canton.gov Table: fact_votes Type: Base Table
What
Description
Tracks individual vote casting events (DsoRules_CastVote) in response to vote requests. Captures who voted, what they voted for, and timing of votes.Key Use Cases
- Analyzing voting patterns and participation
- Tracking individual super validator votes
- Understanding vote timing relative to requests
- Monitoring governance engagement
Important Relationships
- Child events to
gov__fact_vote_requests - Links to vote requests via vote_request_cid
- Aggregated in
gov__fact_vote_results
Commonly-used Fields
voter: Party casting the votevote_accept: Boolean indicating accept/reject votevote_request_cid: Reference to the vote requesteffective_at: When vote was cast
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 |
| REQUEST_CID | TEXT | REQUEST_CID column |
| TRACKING_CID | TEXT | TRACKING_CID column |
| SV | TEXT | SV column |
| ACCEPT | BOOLEAN | ACCEPT column |
| OPT_CAST_AT | TIMESTAMP_NTZ | OPT_CAST_AT column |
| REASON | VARIANT | REASON column |
| CONTRACT_ID | TEXT | CONTRACT_ID column |
| VOTE_REQUEST_CID | TEXT | VOTE_REQUEST_CID column |
| FACT_VOTE_ID | TEXT | FACT_VOTE_ID column |
| INSERTED_TIMESTAMP | TIMESTAMP_NTZ | INSERTED_TIMESTAMP column |
| MODIFIED_TIMESTAMP | TIMESTAMP_NTZ | MODIFIED_TIMESTAMP column |