proposal_title,

proposal_id,

vote_timestamp :: date AS date,

trim(vote_option :: STRING, '[""]') as vote_option,

CASE WHEN trim(vote_option :: STRING, '[""]') = 1 THEN

'For'

WHEN trim(vote_option :: STRING, '[""]') = 2 THEN

'Against'

ELSE

'Abstain'

END AS vote

FROM "ETHEREUM"."CORE"."EZ_SNAPSHOT"

WHERE voter = '0x62a43123FE71f9764f26554b3F5017627996816a'

AND space_id = 'opcollective.eth'