django-calaccess-campaign-browser
django-calaccess-campaign-browser copied to clipboard
palewire
Audit of exported CSV and SQL from browser
From @jlagetz:
Contributions:
Count: 6,378,695 Total: $12,620,631,640.70
Top contributors (based on contributor_full_name)
Top ZIP codes (amount desc):
Expenditures:
:warning: It also looks like full name on expenditures isn't really full name. Count: 2,531,071 Total Amount: $13,100,377,232.31
Top by candidate full name (doesn’t appear that these are actually full names) (amount desc)
Top by Payee_last_name (amount desc)
Clearly, we can only sum on the Summary table, but it's got to see how the export worked. Looks like there's an issue with how full_name is loaded on Expenditures
Keep in mind also, when looking at the sums, that the filings include amended filings. One has to be careful to not over-count. If you have {filing_id=x,amend_id=0,amount=1000.00}, {filing_id=x,amend_id=1,amount=1500.00}, and {filing_id=x,amend_id=2,amount=2000.00}, the final amount used needs to be 2000.00, not 4500.00.
