SELECT

block_timestamp,

tx_id,

voter,

proposal_id,

vote_option

FROM osmosis.core.fact_governance_votes

WHERE tx_succeeded = TRUE

),

prop_type AS (

SELECT

proposal_id,

proposal_type,

proposal_title,

proposal_description

FROM osmosis.core.fact_governance_submit_proposal

WHERE tx_succeeded = TRUE

SELECT

block_timestamp,

tx_id,

voter,

v.proposal_id,

proposal_type,

vote_option,

description AS vote,

CASE WHEN v.proposal_id = 362 THEN

'Osmosis Grants Program (OGP) Renewal'

ELSE proposal_title

END AS proposal_title,

proposal_description

FROM votes v

LEFT OUTER JOIN prop_type t

ON v.proposal_id = t.proposal_id

LEFT OUTER JOIN osmosis.core.dim_vote_options d