attribute_value as proposal,

row_number() over(partition by proposal order by date) as day,

tx_id

from osmosis.core.fact_msg_attributes

where msg_type = 'proposal_vote' and attribute_key = 'proposal_id'