counts of distinct FILING_IDs (by table)

count_filing_ids_by_table.sql

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

Results as of 8/29/2016:

table_name                   filing_id_count  
---------------------------  ---------------  
FILINGS_CD                   1770162          
FILER_FILINGS_CD             1767011          
HDR_CD                       624632           
CVR_CAMPAIGN_DISCLOSURE_CD   325530           
SMRY_CD                      321701           
RECEIVED_FILINGS_CD          320820           
CVR_LOBBY_DISCLOSURE_CD      271764           
LPAY_CD                      173308           
S497_CD                      173139           
CVR3_VERIFICATION_INFO_CD    131277           
EXPN_CD                      114120           
TEXT_MEMO_CD                 114005           
RCPT_CD                      80955            
CVR2_CAMPAIGN_DISCLOSURE_CD  55903            
SPLT_CD                      44252            
CVR2_LOBBY_DISCLOSURE_CD     43156            
DEBT_CD                      39920            
CVR_REGISTRATION_CD          30526            
F690P2_CD                    16719            
S496_CD                      15982            
LOAN_CD                      15891            
F501_502_CD                  14235            
LCCM_CD                      13782            
LEXP_CD                      13255            
LATT_CD                      9956             
CVR2_REGISTRATION_CD         4842             
S498_CD                      4693             
CVR_SO_CD                    4505             
LOTH_CD                      4394             
CVR2_SO_CD                   4339             
S401_CD                      2703             
LOBBY_AMENDMENTS_CD          2150             
LEMP_CD                      2053             
F495P2_CD                    676              
CVR_E530_CD                  160              
LOBBYIST_FIRM_EMPLOYER1_CD   24               
LOBBYIST_FIRM_EMPLOYER2_CD   24               
CVR_F470_CD                  0