Audit of exported CSV and SQL from browser

[aboutaaron]

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:

⚠️ 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)

[aboutaaron]

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

[rkiddy]

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.