Total distinct FILER_ID values

total_distinct_filer_ids.sql

SELECT COUNT(*)
FROM (
    SELECT "FILER_ID"::varchar
    FROM "FILER_XREF_CD"
    UNION
    SELECT "FILER_ID"::varchar
    FROM "FILER_FILINGS_CD"
    UNION
    SELECT "FILER_ID"::varchar
    FROM "FILERNAME_CD"
    UNION
    SELECT "FILER_ID"::varchar
    FROM "FILERS_CD"
    UNION
    SELECT "FILER_ID"::varchar
    FROM "FILER_TO_FILER_TYPE_CD"
    UNION
    SELECT "FILER_ID"::varchar
    FROM "BALLOT_MEASURES_CD"
    UNION
    SELECT "FILER_ID"
    FROM "CVR_CAMPAIGN_DISCLOSURE_CD"
    UNION
    SELECT "FILER_ID"
    FROM "CVR_F470_CD"
    UNION
    SELECT "FILER_ID"
    FROM "CVR_LOBBY_DISCLOSURE_CD"
    UNION
    SELECT "FILER_ID"
    FROM "CVR_REGISTRATION_CD"
    UNION
    SELECT "FILER_ID"
    FROM "CVR_SO_CD"
    UNION
    SELECT "FILER_ID"
    FROM "EFS_FILING_LOG_CD"
    UNION
    SELECT "FILER_ID"
    FROM "F501_502_CD"
    UNION
    SELECT "FILER_ID"::varchar
    FROM "FILER_ACRONYMS_CD"
    UNION
    SELECT "FILER_ID"::varchar
    FROM "FILER_ADDRESS_CD"
    UNION
    SELECT "FILER_ID"::varchar
    FROM "FILER_ETHICS_CLASS_CD"
    UNION
    SELECT "FILER_ID"::varchar
    FROM "FILER_INTERESTS_CD"
    UNION
    SELECT "FILER_ID"::varchar
    FROM "LOBBYING_CHG_LOG_CD"
    UNION
    SELECT "FILER_ID"::varchar
    FROM "LOBBYIST_CONTRIBUTIONS1_CD"
    UNION
    SELECT "FILER_ID"::varchar
    FROM "LOBBYIST_CONTRIBUTIONS2_CD"
    UNION
    SELECT "FILER_ID"::varchar
    FROM "LOBBYIST_CONTRIBUTIONS3_CD"
    UNION
    SELECT "FILER_ID"::varchar
    FROM "RECEIVED_FILINGS_CD"
) as foo;

Results as of 8/29/2016:

count   
------  
364195