total distinct FILING_ID values

total_distinct_filing_ids.sql

SELECT COUNT(DISTINCT "FILING_ID")
FROM (
    SELECT "FILING_ID"
    FROM "CVR2_CAMPAIGN_DISCLOSURE_CD"
    UNION
    SELECT "FILING_ID"
    FROM "CVR2_LOBBY_DISCLOSURE_CD"
    UNION
    SELECT "FILING_ID"
    FROM "CVR2_REGISTRATION_CD"
    UNION
    SELECT "FILING_ID"
    FROM "CVR2_SO_CD"
    UNION
    SELECT "FILING_ID"
    FROM "CVR3_VERIFICATION_INFO_CD"
    UNION
    SELECT "FILING_ID"
    FROM "CVR_CAMPAIGN_DISCLOSURE_CD"
    UNION
    SELECT "FILING_ID"
    FROM "CVR_E530_CD"
    UNION
    SELECT "FILING_ID"
    FROM "CVR_F470_CD"
    UNION
    SELECT "FILING_ID"
    FROM "CVR_LOBBY_DISCLOSURE_CD"
    UNION
    SELECT "FILING_ID"
    FROM "CVR_REGISTRATION_CD"
    UNION
    SELECT "FILING_ID"
    FROM "CVR_SO_CD"
    UNION
    SELECT "FILING_ID"
    FROM "DEBT_CD"
    UNION
    SELECT "FILING_ID"
    FROM "EXPN_CD"
    UNION
    SELECT "FILING_ID"
    FROM "F495P2_CD"
    UNION
    SELECT "FILING_ID"
    FROM "F501_502_CD"
    UNION
    SELECT "FILING_ID"
    FROM "F690P2_CD"
    UNION
    SELECT "FILING_ID"
    FROM "FILINGS_CD"
    UNION
    SELECT "FILING_ID"
    FROM "FILER_FILINGS_CD"
    UNION
    SELECT "FILING_ID"
    FROM "HDR_CD"
    UNION
    SELECT "FILING_ID"
    FROM "LATT_CD"
    UNION
    SELECT "FILING_ID"
    FROM "LCCM_CD"
    UNION
    SELECT "FILING_ID"
    FROM "LEMP_CD"
    UNION
    SELECT "FILING_ID"
    FROM "LEXP_CD"
    UNION
    SELECT "FILING_ID"
    FROM "LOAN_CD"
    UNION
    SELECT "FILING_ID"
    FROM "LOBBY_AMENDMENTS_CD"
    UNION
    SELECT "FILING_ID"
    FROM "LOBBYIST_FIRM_EMPLOYER1_CD"
    UNION
    SELECT "FILING_ID"
    FROM "LOBBYIST_FIRM_EMPLOYER2_CD"
    UNION
    SELECT "FILING_ID"
    FROM "LOTH_CD"
    UNION
    SELECT "FILING_ID"
    FROM "LPAY_CD"
    UNION
    SELECT "FILING_ID"
    FROM "RCPT_CD"
    UNION
    SELECT "FILING_ID"
    FROM "RECEIVED_FILINGS_CD"
    UNION
    SELECT "FILING_ID"
    FROM "S401_CD"
    UNION
    SELECT "FILING_ID"
    FROM "S496_CD"
    UNION
    SELECT "FILING_ID"
    FROM "S497_CD"
    UNION
    SELECT "FILING_ID"
    FROM "S498_CD"
    UNION
    SELECT "FILING_ID"
    FROM "SMRY_CD"
    UNION
    SELECT "FILING_ID"
    FROM "SPLT_CD"
    UNION
    SELECT "FILING_ID"
    FROM "TEXT_MEMO_CD"
) as foo;

Results as of 8/29/2016:

count    
-------  
1770380