Comparison of FEC reports-- at top are a sample of ones where our (separately reported) itemized indiv. contribs exceed the campaign's reported individual contribs, and below are ones where only the (separately reported) itemized indiv. contribs PLUS the campaign's reported individual contribs exceed the campaign's reported total receipts. This …

gistfile1.txt

datacommons=> select * from tmp_fec_total_receipts where total_itemized_contributions > total_individual_contributions limit 15;                                                 
 candidate_id | committee_id |     candidate_name      | chamber | total_receipts | total_individual_contributions | total_itemized_contributions | last_summary_date 
--------------+--------------+-------------------------+---------+----------------+--------------------------------+------------------------------+-------------------
 H0AR01125    | C00480905    | SMITH, PRINCELLA D      | H       |         477.27 |                          57.26 |                       420.00 | 2012-12-31
 H0AR02149    | C00477380    | ADAMS, JOHN             | H       |         730.71 |                           0.00 |                       730.00 | 2011-10-15
 H0AZ03305    | C00468686    | HULBURD, JON            | H       |       13500.00 |                           0.00 |                     13500.00 | 2012-03-31
 H0AZ04501    | C00485995    | PENALOSA, JOSE          | H       |       14007.00 |                         173.00 |                     13832.00 | 2012-12-31
 H0AZ07025    | C00481069    | MYERS, TERRY LON        | H       |        1625.00 |                           0.00 |                       700.00 | 2012-12-31
 H0CA00082    | C00479188    | PORTANTINO, ANTHONY     | H       |      334068.61 |                      239725.28 |                    254145.00 | 2012-12-31
 H0CA07111    | C00516591    | FITZGERALD, JOHN        | H       |       13668.00 |                        5335.00 |                     10750.00 | 2012-12-31
 H0CA15205    | C00476770    | KIRKLAND, SCOTT SPENCER | H       |       10780.28 |                           0.00 |                     10780.00 | 2011-03-31
 H0CA19132    | C00502567    | GOODWIN, LORAINE        | H       |        2139.00 |                           0.00 |                      1855.00 | 2012-12-31
 H0CA19173    | C00473272    | DENHAM, JEFF            | H       |     2756588.82 |                     1284763.56 |                   1373915.00 | 2012-12-31
 H0CA23100    | C00473124    | DAVIDSON, JOHN          | H       |        5500.00 |                         500.00 |                      5500.00 | 2012-12-31
 H0CA29099    | C00473850    | COLBERT, JOHN           | H       |        4383.94 |                           0.00 |                      4327.00 | 2012-03-31
 H0CA30089    | C00471128    | BENNING, DAVID          | H       |        3055.00 |                        1005.00 |                      3250.00 | 2012-10-01
 H0CA46051    | C00474668    | LURIE, BARAK            | H       |       33171.00 |                           0.00 |                     33171.00 | 2011-11-07
 H0CO04114    | C00457879    | LUCERO, THOMAS JOSEPH   | H       |        4785.90 |                           0.00 |                      4783.00 | 2012-09-30
(15 rows)

datacommons=> select * from tmp_fec_total_receipts where (total_itemized_contributions + total_individual_contributions) > total_receipts limit 15;
 candidate_id | committee_id |     candidate_name     | chamber | total_receipts | total_individual_contributions | total_itemized_contributions | last_summary_date 
--------------+--------------+------------------------+---------+----------------+--------------------------------+------------------------------+-------------------
 H0AL01030    | C00459495    | GOUNARES, PETER HUNTER | H       |       15075.00 |                       10545.00 |                      8850.00 | 2012-12-04
 H0AL05155    | C00462481    | PHILLIP, LESTER S      | H       |       14020.88 |                       14020.88 |                      2600.00 | 2011-12-31
 H0AR01109    | C00475384    | CAUSEY, CHAD           | H       |       42780.00 |                       28999.00 |                     15400.00 | 2012-12-31
 H0AR02107    | C00468116    | GRIFFIN, JOHN TIMOTHY  | H       |     1619346.36 |                     1043440.80 |                    940319.00 | 2012-12-31
 H0AR02156    | C00477315    | BOLING, DAVID ALAN     | H       |        5940.00 |                        5940.00 |                      1750.00 | 2011-12-31
 H0AR03063    | C00478172    | BLEDSOE, CECILE H      | H       |        5450.00 |                        4850.00 |                      4300.00 | 2012-12-31
 H0AR04079    | C00478636    | RANKIN, BETH ANNE      | H       |      418028.11 |                      402099.60 |                    260321.00 | 2012-06-29
 H0AS00018    | C00231092    | FALEOMAVAEGA, ENI      | H       |      110570.00 |                       97220.00 |                     93500.00 | 2012-12-31
 H0AZ01184    | C00347260    | FLAKE, JEFF MR.        | H       |     9026951.00 |                     7119692.00 |                   5654442.00 | 2012-12-31
 H0AZ01259    | C00461806    | GOSAR, PAUL ANTHONY    | H       |     1150701.15 |                      690418.83 |                    589098.00 | 2012-12-31
 H0AZ03362    | C00475863    | QUAYLE, BEN            | H       |     2179350.16 |                     1722530.12 |                   1358110.00 | 2012-12-31
 H0AZ08015    | C00460808    | KELLY, JESSE           | H       |     1084859.09 |                      605487.28 |                    490324.00 | 2012-12-31
 H0AZ08031    | C00462721    | MILLER, BRIAN ALLAN    | H       |        4200.00 |                        4200.00 |                      3000.00 | 2012-12-31
 H0AZ08056    | C00474270    | PATON, JONATHAN        | H       |     1477836.14 |                      954249.70 |                    845525.00 | 2012-12-31
 H0CA00082    | C00479188    | PORTANTINO, ANTHONY    | H       |      334068.61 |                      239725.28 |                    254145.00 | 2012-12-31
(15 rows)