Conference Proposals

select conference_name, proposal.id, coalesce(proposal.level, 'NA') as level, proposal.deliberationStatus as deliberation_status, proposal.deliberationStatus as status, proposal.confirmationStatus as confirmation_status, proposal.publicationStatus as publication_status, coalesce(unnest(proposal.categories), 'NA') as category, unnest(proposal.tags)::VARCHAR as tag, split_part(coalesce(unnest(proposal.formats), 'NA'), ' — (', 1) as format, coalesce(unnest(proposal.languages), 'NA') as language, unnest(proposal.speakers).name as speaker_id, coalesce(unnest(proposal.speakers).company, 'NA') as speaker_company, coalesce(unnest(proposal.speakers).location, 'NA') as speaker_location, proposal.review.average as review_average, from _proposals