counts of distinct FILER_IDS (by table)

count_filer_ids_by_table.sql

SELECT 'BALLOT_MEASURES_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "BALLOT_MEASURES_CD"
UNION
SELECT 'CVR_CAMPAIGN_DISCLOSURE_CD' as table_name, COUNT(DISTINCT "FILER_ID") as filer_id_count
FROM "CVR_CAMPAIGN_DISCLOSURE_CD"
UNION
SELECT 'CVR_F470_CD' as table_name, COUNT(DISTINCT "FILER_ID") as filer_id_count
FROM "CVR_F470_CD"
UNION
SELECT 'CVR_LOBBY_DISCLOSURE_CD' as table_name, COUNT(DISTINCT "FILER_ID") as filer_id_count
FROM "CVR_LOBBY_DISCLOSURE_CD"
UNION
SELECT 'CVR_REGISTRATION_CD' as table_name, COUNT(DISTINCT "FILER_ID") as filer_id_count
FROM "CVR_REGISTRATION_CD"
UNION
SELECT 'CVR_SO_CD' as table_name, COUNT(DISTINCT "FILER_ID") as filer_id_count
FROM "CVR_SO_CD"
UNION
SELECT 'EFS_FILING_LOG_CD' as table_name, COUNT(DISTINCT "FILER_ID") as filer_id_count
FROM "EFS_FILING_LOG_CD"
UNION
SELECT 'F501_502_CD' as table_name, COUNT(DISTINCT "FILER_ID") as filer_id_count
FROM "F501_502_CD"
UNION
SELECT 'FILERS_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "FILERS_CD"
UNION
SELECT 'FILER_FILINGS_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "FILER_FILINGS_CD"
UNION
SELECT 'FILER_ACRONYMS_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "FILER_ACRONYMS_CD"
UNION
SELECT 'FILER_ADDRESS_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "FILER_ADDRESS_CD"
UNION
SELECT 'FILER_ETHICS_CLASS_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "FILER_ETHICS_CLASS_CD"
UNION
SELECT 'FILER_INTERESTS_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "FILER_INTERESTS_CD"
UNION
SELECT 'FILERNAME_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "FILERNAME_CD"
UNION
SELECT 'FILER_TO_FILER_TYPE_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "FILER_TO_FILER_TYPE_CD"
UNION
SELECT 'FILER_XREF_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "FILER_XREF_CD"
UNION
SELECT 'LOBBYING_CHG_LOG_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "LOBBYING_CHG_LOG_CD"
UNION
SELECT 'LOBBYIST_CONTRIBUTIONS1_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "LOBBYIST_CONTRIBUTIONS1_CD"
UNION
SELECT 'LOBBYIST_CONTRIBUTIONS2_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "LOBBYIST_CONTRIBUTIONS2_CD"
UNION
SELECT 'LOBBYIST_CONTRIBUTIONS3_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "LOBBYIST_CONTRIBUTIONS3_CD"
UNION
SELECT 'RECEIVED_FILINGS_CD' as table_name, COUNT(DISTINCT "FILER_ID"::varchar) as filer_id_count
FROM "RECEIVED_FILINGS_CD"
ORDER BY filer_id_count DESC;

Results as of 8/29/2016:

table_name                  filer_id_count  
--------------------------  --------------  
FILERS_CD                   352042          
FILER_XREF_CD               352008          
FILER_TO_FILER_TYPE_CD      351636          
FILER_ADDRESS_CD            274745          
FILERNAME_CD                256635          
FILER_FILINGS_CD            160721          
RECEIVED_FILINGS_CD         18137           
LOBBYING_CHG_LOG_CD         14573           
CVR_LOBBY_DISCLOSURE_CD     13452           
CVR_CAMPAIGN_DISCLOSURE_CD  11441           
FILER_INTERESTS_CD          10736           
F501_502_CD                 9857            
CVR_REGISTRATION_CD         9246            
EFS_FILING_LOG_CD           7561            
FILER_ETHICS_CLASS_CD       4774            
CVR_SO_CD                   4461            
FILER_ACRONYMS_CD           1738            
LOBBYIST_CONTRIBUTIONS3_CD  593             
LOBBYIST_CONTRIBUTIONS2_CD  593             
LOBBYIST_CONTRIBUTIONS1_CD  593             
BALLOT_MEASURES_CD          109             
CVR_F470_CD                 0