18F/openFEC

-- vsum is as amended and has fewer columns
-- this takes the name from sum_and_det_sum_report to vsum
select vs.cmte_id as indv_org_id,
    vs.rpt_tp,
    vs.cvg_start_dt,
    vs.cvg_end_dt,
    vs.rpt_yr,
    vs.receipt_dt,
    vs.rpt_yr + mod(vs.rpt_yr, 2::numeric) as election_cycle,
    vs.ttl_contb as ttl_indt_contb,
    vs.indt_exp_per as ttl_indt_exp,
    'F5' as form_tp,
    vs.file_num,
    vs.orig_sub_id as sub_id,
       'Y' AS most_recent_filing_flag
from  disclosure.v_sum_and_det_sum_report vs
where  (vs.rpt_tp::text <> all (array['24'::character varying, '48'::character varying]::text[]));