Individual Campaign Finance Contributions from FEC Data (updated 10/29/2018)

The following Python code does some preliminary exploration of campaign finance data from the Federal Election Committee (FEC) website. It requires that the following three files be downloaded and unzipped into the specified directories (relative to the notebook). As can be seen, the top-level directory is fecYYMMDD where YYMMDD is the value of fdate and should be set to the date that the zip files are obtained from the FEC website.

Candidate master for 2017-2018 - unzip and place cn.txt in directory fecYYMMDD/cm18/

Committee master for 2017-2018 - unzip and place cm.txt in directory fecYYMMDD/cn18/

Contributions by individuals for 2017-2018 - unzip and place itcont.txt in directory fecYYMMDD/indiv18/

Load all Individual Contributions and Merge Information from Committee and Candidate Tables.

The individual contribution table is very large. It will be loaded into object ii and only reloaded if ii doesn't exist. The following code will create ii if it doesn't exist and output the first row to show all available fields:

In [75]:
import pandas as pd
pd.set_option('display.width', 220)
pd.set_option('max_rows', 200)
#del ii #DEBUG delete to rerun
year = 2018
fdate = "181029"
try:
    ii
except NameError:
    yr = year % 100
    filepath = "fec"+fdate + "/indiv" + str(yr) + "/itcont.txt"
    hdr = pd.read_csv("https://www.fec.gov/files/bulk-downloads/data_dictionaries/indiv_header_file.csv", skiprows=0)
    print("READING "+filepath)
    ii = pd.read_table(filepath, sep='|', header=None, names=hdr)
    print(ii.shape)
    hdr = pd.read_csv("https://www.fec.gov/data/advanced/files/bulk-downloads/data_dictionaries/cm_header_file.csv", skiprows=0)
    cm = pd.read_table("fec"+fdate + "/cm" + str(yr) + "/cm.txt", sep='|', header=None, names=hdr.columns)
    #cm = cm[['CMTE_ID','CMTE_NM','TRES_NM','CMTE_ST1','CMTE_ST2','CMTE_CITY','CMTE_ST','CMTE_ZIP','CMTE_DSGN','CMTE_TP',
    #         'CMTE_PTY_AFFILIATION','CMTE_FILING_FREQ','ORG_TP','CONNECTED_ORG_NM','CAND_ID']]
    cm = cm[['CMTE_ID','CMTE_NM','TRES_NM','CMTE_DSGN','CMTE_TP',
             'CMTE_PTY_AFFILIATION','CMTE_FILING_FREQ','ORG_TP','CONNECTED_ORG_NM','CAND_ID']]
    hdr = pd.read_csv("https://www.fec.gov/data/advanced/files/bulk-downloads/data_dictionaries/cn_header_file.csv", skiprows=0)
    cn = pd.read_table("fec"+fdate + "/cn" + str(yr) + "/cn.txt", sep='|', header=None, names=hdr.columns)
    #cn = cn[['CAND_ID','CAND_NAME','CAND_PTY_AFFILIATION','CAND_ELECTION_YR','CAND_OFFICE_ST','CAND_OFFICE',
    #         'CAND_OFFICE_DISTRICT','CAND_ICI','CAND_STATUS','CAND_PCC','CAND_ST1','CAND_ST2','CAND_CITY','CAND_ST','CAND_ZIP']]
    cn = cn[['CAND_ID','CAND_NAME','CAND_PTY_AFFILIATION','CAND_ELECTION_YR','CAND_OFFICE_ST','CAND_OFFICE',
             'CAND_OFFICE_DISTRICT','CAND_ICI','CAND_STATUS','CAND_PCC']]
    ii=ii.merge(cm, left_on='CMTE_ID', right_on='CMTE_ID')
    ii=ii.merge(cn, left_on='CAND_ID', right_on='CAND_ID', how='left')
    ii['TRANSACTION_DT'] = ii['TRANSACTION_DT'].fillna(0).astype(int)
    ii['TRANSACTION_DT'] = pd.to_datetime(ii['TRANSACTION_DT'],format='%m%d%Y',errors='coerce')
    ii.rename(columns={'TRANSACTION_DT':'DATE', 'TRANSACTION_AMT':'AMT', 'CAND_PTY_AFFILIATION':'PARTY'}, inplace=True)
    #ii['AMOUNT'] = ii['AMT'].apply(lambda x: '{:,}'.format(x))
print(ii.iloc[0,:])
CMTE_ID                                 C00629618
AMNDT_IND                                       N
RPT_TP                                        TER
TRANSACTION_PGI                                 P
IMAGE_NUM                      201701230300133512
TRANSACTION_TP                                15C
ENTITY_TP                                     IND
NAME                                PEREZ, JOHN A
CITY                                  LOS ANGELES
STATE                                          CA
ZIP_CODE                                    90017
EMPLOYER                                PRINCIPAL
OCCUPATION                 DOUBLE NICKEL ADVISORS
DATE                          2017-10-03 00:00:00
AMT                                            40
OTHER_ID                                H6CA34245
TRAN_ID                             SA01251735122
FILE_NUM                                  1141239
MEMO_CD                                       NaN
MEMO_TEXT                                     NaN
SUB_ID                        2012520171368850783
CMTE_NM                 JOHN A PEREZ FOR CONGRESS
TRES_NM                         STEPHEN J KAUFMAN
CMTE_DSGN                                       P
CMTE_TP                                         H
CMTE_PTY_AFFILIATION                          DEM
CMTE_FILING_FREQ                                T
ORG_TP                                        NaN
CONNECTED_ORG_NM                              NaN
CAND_ID                                 H6CA34245
CAND_NAME                           PEREZ, JOHN A
PARTY                                         DEM
CAND_ELECTION_YR                             2017
CAND_OFFICE_ST                                 CA
CAND_OFFICE                                     H
CAND_OFFICE_DISTRICT                           34
CAND_ICI                                        O
CAND_STATUS                                     N
CAND_PCC                                C00629618
Name: 0, dtype: object

Largest Individual Contributions Grouped by the Name, City, and State of the Contributor

The following code aggregates the individual contributions by the name, city, and state of the contributor to get an initial estimate of the total contributions made by each contributor. This is only an initial estimate because, if a single contributor should vary or misspell any of these items, those contributions will be grouped separately. For example, note that items 4, 21, 82, and 113 all appear to be for the same contributor, Richard Uihlein of Lake Forest, IL. The names listed are UIHLEIN, RICHARD; UIHLEIN, RICHARD E.; UIHLEIN, RICHARD; UIHLEIN, RICHARD E. and UIHLEIN, RICHARD E. MR. Of these, only the first and third and the second and fourth appear to be the same. However, the first (item 4) and third (item 68) differ in that the first state is IL and the second state is IN. Then, the second (item 21) and fourth (item 82) differ because the latter item misspells the city as LAKE FORST. Then, the last item (item 113) adds a "MR." to the end of the name for the first time. In any event, the final total following the table shows that over $3.6 billion has already been contributed to federal candidates, PACs, and other committees in the 2017-2018 election cycle.

In [76]:
jj = ii.groupby(['NAME','CITY','STATE'])['AMT'].agg(['sum'])
jj = jj.reset_index(level=['NAME','CITY','STATE'])
jj.columns = ['NAME','CITY','STATE','AMT']
jj['AMOUNT'] = jj['AMT'].apply(lambda x: '{:,}'.format(x))
jj = jj.sort_values(by='AMT',ascending=False)
jj.index = range(1,len(jj)+1)
print(jj[['NAME','CITY','STATE','AMOUNT']].head(200))
print('\nTOTAL = ' + '{:,}'.format(sum(jj['AMT'])))
                                                  NAME               CITY STATE      AMOUNT
1                                    STEYER, THOMAS F.      SAN FRANCISCO    CA  41,576,481
2                                      ADELSON, MIRIAM          LAS VEGAS    NV  27,592,500
3                              AMERICAN ACTION NETWORK         WASHINGTON    DC  20,942,497
4                                     UIHLEIN, RICHARD        LAKE FOREST    IL  19,839,329
5                                          SCOTT, RICK        TALLAHASSEE    FL  19,388,022
6         UNITED BROTHERHOOD OF CARPENTERS AND JOINERS         WASHINGTON    DC  15,650,908
7                                     ADELSON, SHELDON          LAS VEGAS    NV  15,118,300
8                                        SOROS, GEORGE           NEW YORK    NY  14,160,714
9                     REPUBLICAN GOVERNORS ASSOCIATION         WASHINGTON    DC  13,176,173
10                                 ADELSON, SHELDON G.          LAS VEGAS    NV  12,982,200
11                                        TRONE, DAVID           BETHESDA    MD  11,489,671
12                                      EYCHANER, FRED            CHICAGO    IL  11,111,400
13                   NATIONAL ASSOCIATION OF REALTO, .            CHICAGO    IL  10,607,791
14                                         BEZOS, JEFF            SEATTLE    WA  10,129,170
15                                     MELLON, TIMOTHY           SARATOGA    WY  10,015,700
16                                  SUSSMAN, S. DONALD    FORT LAUDERDALE    FL   9,812,800
17                                     SCOTT, RICK GOV        TALLAHASSEE    FL   7,643,595
18                              SCHWARZMAN, STEPHEN A.           NEW YORK    NY   7,391,100
19              DEMOCRATIC GOVERNORS ASSOCIATION (DGA)         WASHINGTON    DC   7,177,000
20                           ENVIRONMENT AMERICA, INC.         WASHINGTON    DC   6,750,000
21                                 UIHLEIN, RICHARD E.        LAKE FOREST    IL   6,711,200
22                                     WALL, KATHALEEN            HOUSTON    TX   6,402,307
23                                    SIMONS, JAMES H.           NEW YORK    NY   6,335,600
24                                  AFT SOLIDARITY 527         WASHINGTON    DC   6,100,000
25                                   MARCUS, GEORGE M.          PALO ALTO    CA   6,092,000
26                                     SUSSMAN, DONALD          RYE BROOK    NY   6,000,000
27                                       MERRILL LYNCH         WASHINGTON    DC   5,650,090
28                                    JURVETSON, KARLA    LOS ALTOS HILLS    CA   5,422,209
29                                 ADELSON, MIRIAM DR.          LAS VEGAS    NV   5,111,000
30                                  ADELSON, SHELDON G          LAS VEGAS    NV   5,029,700
31                        FREEDOM PARTNERS ACTION FUND          ARLINGTON    VA   5,000,000
32                                        GRIFFIN, KEN            CHICAGO    IL   5,000,000
33                                       KLARMAN, SETH             BOSTON    MA   4,814,100
34                                                 SMP         WASHINGTON    DC   4,696,230
35                                 MARCUS, BERNARD MR.            ATLANTA    GA   4,694,500
36                                 AYYADURAI, SHIVA DR          CAMBRIDGE    MA   4,189,384
37                     NATIONAL EDUCATION, ASSOCIATION         WASHINGTON    DC   4,000,000
38                                 PALMER, GEOFFREY H.      BEVERLY HILLS    CA   4,000,000
39                                  BLOOMBERG, MICHAEL           NEW YORK    NY   3,978,525
40                                       KERR, PAUL G.          SAN DIEGO    CA   3,918,102
41                                        BEAL, ANDREW              PLANO    TX   3,617,950
42                                      SIMON, DEBORAH             CARMEL    IN   3,607,446
43                                   MOSKOVITZ, DUSTIN      SAN FRANCISCO    CA   3,518,000
44   GREATER NEW YORK HOSPITAL ASSOCIATION MANAGEME...           NEW YORK    NY   3,500,000
45                                          YASS, JEFF        BALA CYNWYD    PA   3,311,800
46                                       SIMONS, JAMES           NEW YORK    NY   3,182,810
47                               ACTION NOW INITIATIVE             DALLAS    TX   3,100,000
48                                    HOFFMAN, REID G.     PORTOLA VALLEY    CA   3,053,000
49                          CHARLES G. KOCH 1997 TRUST            WICHITA    KS   3,000,000
50                                       LAUFER, HENRY            LANTANA    FL   2,987,300
51                                          DAGA, INC.         WASHINGTON    DC   2,888,297
52                                SCHWARTZ, BERNARD L.           NEW YORK    NY   2,852,800
53                                          MOODY, DAN            ROSWELL    GA   2,803,120
54                             GRIFFIN, KENNETH C. MR.            CHICAGO    IL   2,801,900
55                                 UNITED STEELWORKERS         PITTSBURGH    PA   2,800,195
56                                   SIMON, DEBORAH J.             CARMEL    IN   2,786,950
57                              AFSCME SPECIAL ACCOUNT         WASHINGTON    DC   2,724,532
58                                    SOROS, ALEXANDER           NEW YORK    NY   2,718,363
59                                 HENDRICKS, DIANE M.             BELOIT    WI   2,705,400
60                                  ABRAHAM, S. DANIEL    WEST PALM BEACH    FL   2,655,500
61                               BLOOMBERG, MICHAEL R.           NEW YORK    NY   2,638,516
62                                     SUSSMAN, DONALD    FORT LAUDERDALE    FL   2,621,200
63                       FLINN, GEORGE S DR JR S JR DR            MEMPHIS    TN   2,545,000
64                                     WEXNER, ABIGAIL         NEW ALBANY    OH   2,541,600
65                                       JACOBS, IRWIN           LA JOLLA    CA   2,521,950
66                               SIMON-SKJODT, CYNTHIA             CARMEL    IN   2,505,400
67                              LIUNA BUILDING AMERICA         WASHINGTON    DC   2,500,000
68                                    UIHLEIN, RICHARD        LAKE FOREST    IN   2,400,000
69                   COMMUNICATIONS WORKERS OF AMERICA         WASHINGTON    DC   2,384,137
70       LABORERS' POLITICAL LEAGUE GREAT LAKES REGION            CHICAGO    IL   2,250,000
71           LABORERS' POLITICAL LEAGUE EDUCATION FUND         WASHINGTON    DC   2,250,000
72                    HILLWOOD DEVELOPMENT COMPANY LLC             DALLAS    TX   2,250,000
73                                           DUNN, TIM            MIDLAND    TX   2,228,200
74          INTERNATIONAL UNION OF OPERATING ENGINEERS         WASHINGTON    DC   2,207,485
75                                   MOSKOWITZ, CHERNA        MIAMI BEACH    FL   2,164,400
76                                  ROSENTHAL, RICHARD         CINCINNATI    OH   2,163,800
77                                        JACOBS, SARA            DEL MAR    CA   2,159,653
78                                       HOFFMAN, REID     PORTOLA VALLEY    CA   2,105,300
79                                     TIERNEY, DANIEL            CHICAGO    IL   2,055,998
80                               MCNAIR, ROBERT C. SR.            HOUSTON    TX   2,020,400
81                             BERGAN, MARY ALICE MRS.              FARGO    ND   2,002,500
82                                 UIHLEIN, RICHARD E.         LAKE FORST    IL   2,000,000
83                                COHEN, STEVEN A. MR.           STAMFORD    CT   2,000,000
84                                 MACFARLANE, SETH W.        LOS ANGELES    CA   2,000,000
85                                    SIMON, DEBORAH J             CARMEL    IN   1,945,060
86                               OBERNDORF, WILLIAM E.      SAN FRANCISCO    CA   1,867,500
87                                     ANSARY, HUSHANG            HOUSTON    TX   1,859,904
88                           FEINSTEIN, SENATOR DIANNE         WASHINGTON    DC   1,750,000
89                                  FEINSTEIN, SENATOR         WASHINGTON    DC   1,750,000
90                                   COLLECTIVE FUTURE         WASHINGTON    DC   1,728,572
91                              SIMONS, MARILYN HAWRYS           NEW YORK    NY   1,728,300
92                   PINNACLE WEST CAPITAL CORPORATION            PHOENIX    AZ   1,700,000
93                               SKJODT, CYNTHIA SIMON             CARMEL    IN   1,698,000
94                                         FAISON, JAY          CHARLOTTE    NC   1,689,699
95                                         SABAN, HAIM        LOS ANGELES    CA   1,683,300
96                              SUSSMAN, SELWYN DONALD           PORTLAND    ME   1,674,100
97                              WRIGHT, KAREN BUCHWALD       MOUNT VERNON    OH   1,652,100
98                           IBEW PAC EDUCATIONAL FUND         WASHINGTON    DC   1,650,000
99                                      SHAW, DAVID E.           NEW YORK    NY   1,643,600
100                                       SINGER, PAUL           NEW YORK    NY   1,627,908
101                                    MARCUS, BERNARD            ATLANTA    GA   1,619,800
102                       OHIO ASSOCIATION OF REALTORS           COLUMBUS    OH   1,579,700
103                          MICHIGAN REPUBLICAN PARTY            LANSING    MI   1,550,000
104                              GOLDMAN FOWLER, AMY P          RHINEBECK    NY   1,544,700
105                                JOHNSON, CHARLES B.         PALM BEACH    FL   1,543,200
106                                    FOSTER, PAUL L.            EL PASO    TX   1,508,500
107                                   LAUDER, RONALD S           NEW YORK    NY   1,508,100
108                                   GRANTHAM, ROBERT             BOSTON    MA   1,500,000
109                               VALERO SERVICES INC.        SAN ANTONIO    TX   1,500,000
110                             SOROS COLOMBEL, ANDREA          SCARSDALE    NY   1,500,000
111                            SOLUTIONS FOR WISCONSIN             AUSTIN    TX   1,500,000
112                                       TAYLOR, DALE            CHICAGO    IL   1,494,616
113                            UIHLEIN, RICHARD E. MR.        LAKE FOREST    IL   1,494,400
114                                   REINSDORF, JERRY            CHICAGO    IL   1,477,100
115                             SENATE LEADERSHIP FUND          WARRENTON    VA   1,400,000
116                                       CHC BOLD PAC         WASHINGTON    DC   1,381,266
117                                   JURVETSON, KARLA          LOS ALTOS    CA   1,317,926
118                                 TIERNEY, DANIEL V.            CHICAGO    IL   1,267,966
119                        TARGETED PLATFORM MEDIA LLC          ANNAPOLIS    MD   1,261,553
120                               SONNENFELDT, MICHAEL           NEW YORK    NY   1,256,195
121                               SINGER, PAUL ELLIOTT           NEW YORK    NY   1,250,000
122                                WHEATLAND TUBE, LLC            CHICAGO    IL   1,250,000
123  SEIU CALIFORNIA STATE COUNCIL POLITICAL COMMITTEE         SACRAMENTO    CA   1,250,000
124                                   COHEN, STEVEN A.          GREENWICH    CT   1,248,100
125                                    CAMERON, RONALD        LITTLE ROCK    AR   1,235,800
126                               MCINERNEY, THOMAS E.           WESTPORT    CT   1,229,500
127                                     LINDBERG, GREG             DURHAM    NC   1,205,000
128                                         TUNA, CARI      SAN FRANCISCO    CA   1,203,480
129           METROPOLITAN MILWAUKEE ASSOC OF COMMERCE          MILWAUKEE    WI   1,200,000
130                                 HOUSE MAJORITY PAC         WASHINGTON    DC   1,193,200
131                               KOCH INDUSTRIES INC.            WICHITA    KS   1,175,000
132  UNITED FOOD AND COMMERCIAL WORKERS INTERNATION...         WASHINGTON    DC   1,170,475
133                             HUMPHREYS, DAVID CRAIG             JOPLIN    MO   1,168,190
134                                   HUMPHREYS, DAVID             JOPLIN    MO   1,168,050
135                               FERTITTA, LORENZO J.          LAS VEGAS    NV   1,150,000
136                                KOCH INDUSTRIES INC            WICHITA    KS   1,100,000
137                                  SIMONS, ELIZABETH           ATHERTON    CA   1,092,698
138                         NATIONAL AFGE HEADQUARTERS         WASHINGTON    DC   1,091,297
139                                      HEADLEY, MARK           BERKELEY    CA   1,087,450
140                                       SIMMONS, IAN          CAMBRIDGE    MA   1,087,025
141                               ANSARY, HUSHANG HON.            HOUSTON    TX   1,077,200
142                                SENATE MAJORITY PAC         WASHINGTON    DC   1,077,113
143                     CITIZENS FOR A WORKING AMERICA         ALEXANDRIA    VA   1,075,000
144                                     RASTIN, THOMAS       MOUNT VERNON    OH   1,054,500
145                                     BACON, LOUIS M           NEW YORK    NY   1,047,400
146                                       STRYKER, PAT       FORT COLLINS    CO   1,042,700
147                                     MARCUS, GEORGE          PALO ALTO    CA   1,040,200
148                                 BEKENSTEIN, JOSHUA            WAYLAND    MA   1,030,400
149                                KATZENBERG, JEFFREY        LOS ANGELES    CA   1,028,100
150                                        MAHER, BILL        LOS ANGELES    CA   1,027,700
151                              DEVOS, RICHARD M. MR.       GRAND RAPIDS    MI   1,013,500
152                                      HOFFMAN, REID      SAN FRANCISCO    CA   1,010,108
153                              FERTITTA, FRANK J III          LAS VEGAS    NV   1,008,100
154                                 SCULLY, WILLIAM P.         VERO BEACH    FL   1,006,700
155                              SIMON SKJODT, CYNTHIA             CARMEL    IN   1,005,400
156                                    HOFFMAN, REID G      SAN FRANCISCO    CA   1,005,400
157  AMERICAN FEDERATION OF STATE, COUNTY AND MUNIC...         WASHINGTON    DC   1,002,695
158                                     NEXTERA ENERGY         JUNO BEACH    FL   1,001,000
159                                  HAYDEN, JERRY MR.         SCOTTSDALE    AZ   1,000,400
160                              AI ALTEP HOLDINGS INC           NEW YORK    NY   1,000,000
161                                   TESORO COMPANIES        SAN ANTONIO    TX   1,000,000
162                                     CONOCOPHILLIPS            HOUSTON    TX   1,000,000
163                               MELLON, MATTHEW T II           NEW YORK    NY   1,000,000
164         CHEVRON POLICY GOVERNMENT & PUBLIC AFFAIRS          SAN RAMON    CA   1,000,000
165                                  PILOT CORPORATION          KNOXVILLE    TN   1,000,000
166                            JWC III REVOCABLE TRUST              TULSA    OK   1,000,000
167                           MERCER, ROBERT LEROY MR.          ST. JAMES    NY   1,000,000
168                                   MATHILE, CLAYTON             DAYTON    OH   1,000,000
169                                ALLIED WALLET, INC.     WEST HOLLYWOOD    CA   1,000,000
170                            GILLIAM, RICHARD B. MR.            KESWICK    VA   1,000,000
171                    ACCOUNTABLE JUSTICE ACTION FUND         WASHINGTON    DC   1,000,000
172                             KIEHL FRIEDMAN, ALISON             MCLEAN    VA   1,000,000
173                                 CAMERON, RONALD M.  NORTH LITTLE ROCK    AR   1,000,000
174                                GENERATION NOW INC.           COLUMBUS    OH   1,000,000
175                          MURRAY ENERGY CORPORATION          BEACHWOOD    OH   1,000,000
176                                         YASS, JEFF       BALA CYNWYND    PA   1,000,000
177                              MOUNTAIRE CORPORATION        LITTLE ROCK    AR   1,000,000
178                              JOYCE, CHARLES P. MR.         WELLSVILLE    NY     967,100
179                         CANSECO, FRANCISCO 'QUICO'        SAN ANTONIO    TX     965,091
180                               RYAN, VINCENT JOSEPH         VERO BEACH    FL     960,030
181                                     CENTER FORWARD         WASHINGTON    DC     960,000
182                                      PELTZ, NELSON           NEW YORK    NY     952,700
183                       POARCH BAND OF CREEK INDIANS             ATMORE    AL     949,558
184                              PRIORITIES USA ACTION         WASHINGTON    DC     925,000
185                                  RUSSELL, THOMAS H              JENKS    OK     886,250
186                                 SUSSMAN, S. DONALD     FT. LAUDERDALE    FL     884,800
187                                         CRAFT, JOE              TULSA    OK     873,500
188                          AMERICAN POLICY COALITION        HYATTSVILLE    MD     863,800
189                                     STAVIS, ROBERT          LARCHMONT    NY     862,700
190                   INDEPENDENCE AND FREEDOM NETWORK         WASHINGTON    DC     850,000
191                               THE CHICKASAW NATION                ADA    OK     844,000
192                                       LYNCH, HOLLY           NEW YORK    NY     842,234
193                                BEAL, D. ANDREW MR.              PLANO    TX     833,400
194                    NEXTGEN CLIMATE ACTION COMMITEE         WASHINGTON    DC     831,271
195                                        ECK, DENNIS          LAS VEGAS    NV     822,946
196                                CHILDS, JOHN W. MR.         VERO BEACH    FL     818,700
197                                 CHAZEN, STEPHEN I.           BELLAIRE    TX     806,604
198                           MERCER, ROBERT AND DIANA      EAST SETAUKET    NY     800,000
199                         FERTITTA, FRANK J. MR. III          LAS VEGAS    NV     792,400
200                           FERTITTA, LORENZO J. MR.          LAS VEGAS    NV     792,400

TOTAL = 3,680,314,061

Largest Individual Contributions Grouped by Committees Connected to Specific Candidates

The following code aggregates the individual contributions by the committee name, corresponding candidate name, and party of all committees connected to specific candidates. As can be seen, "Team Ryan" is the top committee despite the fact its candidate, House leader Paul Ryan, is no longer running for reelection. The second committee is "Rick Scott for Florida", connected to Rick Scott, Republican governor of Florida who is running against Democrat Senator Bill Nelson for his Senate seat. As can be seen, the nearly \$32 million that it has raised is nearly three times as much as the nearly $11 raised by Nelson's chief committee, "Bill Nelson for US Senate".

In [77]:
jj = ii[pd.notnull(ii['CAND_ID'])]

jj = jj.groupby(['CMTE_NM','CAND_NAME','PARTY'])['AMT'].agg(['sum'])
jj = jj.reset_index(level=['CMTE_NM','CAND_NAME','PARTY'])
jj.columns = ['CMTE_NM','CAND_NAME','PARTY','AMT']
jj['AMOUNT'] = jj['AMT'].apply(lambda x: '{:,}'.format(x))
jj = jj.sort_values(by='AMT',ascending=False)
jj.index = range(1,len(jj)+1)
print(jj[['CMTE_NM','CAND_NAME','PARTY','AMOUNT']].head(100))
print('\nTOTAL = ' + '{:,}'.format(sum(jj['AMT'])))
                                          CMTE_NM                      CAND_NAME PARTY      AMOUNT
1                                       TEAM RYAN                  RYAN, PAUL D.   REP  53,458,491
2                          RICK SCOTT FOR FLORIDA                    SCOTT, RICK   REP  31,779,004
3                          MCCASKILL FOR MISSOURI              MCCASKILL, CLAIRE   DEM  28,070,115
4                        BOB CASEY FOR SENATE INC             CASEY, ROBERT P JR   DEM  15,737,269
5                 DOUG JONES FOR SENATE COMMITTEE                    JONES, DOUG   DEM  15,073,842
6                                  BETO FOR TEXAS        O'ROURKE, ROBERT (BETO)   DEM  14,250,105
7                             TED CRUZ FOR SENATE       CRUZ, RAFAEL EDWARD  TED   REP  13,881,579
8                           GILLIBRAND FOR SENATE  GILLIBRAND, KIRSTEN ELIZABETH   DEM  12,706,972
9                        TAMMY BALDWIN FOR SENATE                 BALDWIN, TAMMY   DEM  12,367,885
10                          MCCARTHY VICTORY FUND                MCCARTHY, KEVIN   REP  11,972,862
11                  DAVID TRONE FOR CONGRESS, INC                   TRONE, DAVID   DEM  11,714,114
12                           MONTANANS FOR TESTER                    TESTER, JON   DEM  11,183,917
13                        JON OSSOFF FOR CONGRESS            OSSOFF, T. JONATHAN   DEM  11,054,480
14                      BILL NELSON FOR US SENATE                   NELSON, BILL   DEM  10,955,166
15                       FRIENDS OF SHERROD BROWN                 BROWN, SHERROD   DEM   9,492,193
16                      FEINSTEIN FOR SENATE 2018              FEINSTEIN, DIANNE   DEM   8,125,130
17                      CORNYN MAJORITY COMMITTEE                   CORNYN, JOHN   REP   7,791,988
18            DONALD J. TRUMP FOR PRESIDENT, INC.                TRUMP, DONALD J   REP   6,931,317
19                           ELIZABETH FOR MA INC              WARREN, ELIZABETH   DEM   6,913,116
20                               ROSEN FOR NEVADA                   ROSEN, JACKY   DEM   6,542,538
21                             KAINE FOR VIRGINIA         KAINE, TIMOTHY MICHAEL   DEM   6,526,265
22                        FRIENDS OF CHRIS MURPHY       MURPHY, CHRISTOPHER S MR   DEM   6,352,393
23                        SCALISE LEADERSHIP FUND              SCALISE, STEVE MR   REP   6,337,019
24                    KATHALEEN WALL FOR CONGRESS           WALL, KATHALEEN MRS.   REP   6,202,627
25                             SINEMA FOR ARIZONA                SINEMA, KYRSTEN   DEM   6,145,154
26                         STABENOW FOR US SENATE               STABENOW, DEBBIE   DEM   5,839,028
27                               FRIENDS OF MARIA                CANTWELL, MARIA   DEM   5,674,551
28                               HEIDI FOR SENATE                HEITKAMP, HEIDI   DEM   5,602,043
29                     TED CRUZ VICTORY COMMITTEE       CRUZ, RAFAEL EDWARD  TED   REP   5,391,368
30                                 SHIVA 4 SENATE           AYYADURAI, SHIVA  DR   IND   4,942,143
31                              HELLER FOR SENATE                   HELLER, DEAN   REP   4,932,745
32                   OHIO GRASSROOTS VICTORY FUND                 BROWN, SHERROD   DEM   4,924,411
33                              MARSHA FOR SENATE         BLACKBURN, MARSHA MRS.   REP   4,788,645
34                         PAUL KERR FOR CONGRESS                     KERR, PAUL   DEM   4,568,870
35                           DONNELLY FOR INDIANA             DONNELLY, JOSEPH S   DEM   4,562,191
36                            MENENDEZ FOR SENATE               MENENDEZ, ROBERT   DEM   4,443,084
37                       KLOBUCHAR FOR MINNESOTA                  KLOBUCHAR, AMY   DEM   4,414,573
38                        RYAN FOR CONGRESS, INC.                  RYAN, PAUL D.   REP   4,305,086
39                            BREDESEN FOR SENATE               BREDESEN, PHILIP   DEM   4,149,551
40                               GREG FOR MONTANA                GIANFORTE, GREG   REP   3,992,369
41                         MCSALLY FOR SENATE INC                MCSALLY, MARTHA   REP   3,953,671
42                   JOSH GOTTHEIMER FOR CONGRESS               GOTTHEIMER, JOSH   DEM   3,759,962
43                                      TEAM JOSH                   MANDEL, JOSH   REP   3,741,515
44                        RICK SCOTT VICTORY FUND                    SCOTT, RICK   REP   3,732,895
45                   CITIZENS FOR JOSH MANDEL INC               MANDEL, JOSHUA A   REP   3,628,211
46                   HATCH ELECTION COMMITTEE INC                 HATCH, ORRIN G   REP   3,599,904
47            ANGUS KING FOR U.S. SENATE CAMPAIGN         KING, ANGUS STANLEY JR   IND   3,586,335
48                              WICKER FOR SENATE                WICKER, ROGER F   REP   3,545,225
49                   JEFF FLAKE FOR US SENATE INC                    FLAKE, JEFF   REP   3,536,149
50                          WHITEHOUSE FOR SENATE         WHITEHOUSE, SHELDON II   DEM   3,535,350
51                         JOSH HAWLEY FOR SENATE           HAWLEY, JOSHUA DAVID   REP   3,508,027
52                          MENENDEZ VICTORY FUND               MENENDEZ, ROBERT   DEM   3,473,727
53                      HANDEL FOR CONGRESS, INC.        HANDEL, KAREN CHRISTINE   REP   3,466,195
54                   FRIENDS OF RAJA FOR CONGRESS        KRISHNAMOORTHI, S. RAJA   DEM   3,345,383
55                       ANDREW JANZ FOR CONGRESS                   JANZ, ANDREW   DEM   3,243,091
56                      NANCY PELOSI VICTORY FUND                  PELOSI, NANCY   DEM   3,234,633
57                        CONOR LAMB FOR CONGRESS                    LAMB, CONOR   DEM   3,121,417
58                      MANCHIN FOR WEST VIRGINIA               MANCHIN III, JOE   DEM   3,061,724
59                          KEYSTONE VICTORY FUND             CASEY, ROBERT P JR   DEM   3,027,019
60                  JUDGE ROY MOORE FOR US SENATE               MOORE, ROY JUDGE   REP   3,014,350
61                   DAN MOODY FOR CONGRESS, INC.                     MOODY, DAN   REP   2,957,283
62   MCMORRIS RODGERS AMERICAN DREAM PROJECT; THE        MCMORRIS RODGERS, CATHY   REP   2,891,058
63                            ROMNEY FOR UTAH INC        ROMNEY, MITT WILLARD MR   REP   2,890,045
64                     COMMITTEE TO ELECT DAN KOH             KOH, DANIEL ARRIGG   DEM   2,884,783
65                       FRIENDS OF JOHN BARRASSO               BARRASSO, JOHN A   REP   2,825,705
66                       SARA JACOBS FOR CONGRESS                   JACOBS, SARA   DEM   2,805,053
67                     STEPHEN FINCHER FOR SENATE               FINCHER, STEPHEN   REP   2,760,068
68                 DEVIN NUNES CAMPAIGN COMMITTEE            NUNES, DEVIN GERALD   REP   2,728,974
69                    MIKIE SHERRILL FOR CONGRESS     SHERRILL, REBECCA MICHELLE   DEM   2,695,693
70                                 COTTON VICTORY                 COTTON, THOMAS   REP   2,606,119
71                      JOHN JAMES FOR SENATE INC                    JAMES, JOHN   REP   2,598,207
72                     MARTIN HEINRICH FOR SENATE        HEINRICH, MARTIN TREVOR   DEM   2,579,004
73                        FRIENDS OF GEORGE FLINN          FLINN, GEORGE S DR JR   REP   2,547,050
74                            SCHIFF FOR CONGRESS                   SCHIFF, ADAM   DEM   2,533,857
75                          BOOKER SENATE VICTORY                 BOOKER, CORY A   DEM   2,486,358
76                            RO FOR CONGRESS INC                  KHANNA, ROHIT   DEM   2,481,353
77                 BOB CORKER FOR SENATE 2018 INC            CORKER, ROBERT P JR   REP   2,434,233
78                           DELGADO FOR CONGRESS               DELGADO, ANTONIO   DEM   2,425,467
79                            ALISON FOR VIRGINIA               FRIEDMAN, ALISON   DEM   2,377,010
80                            JOHN KENNEDY FOR US            KENNEDY, JOHN NEELY   REP   2,311,258
81                                TEAM GRAHAM INC              GRAHAM, LINDSEY O   REP   2,291,088
82                       TINA SMITH FOR MINNESOTA                    SMITH, TINA   DEM   2,289,501
83                         FRIENDS OF MARK WARNER            WARNER, MARK ROBERT   DEM   2,283,259
84                      HOOSIERS FOR ROKITA, INC.        ROKITA, THEODORE EDWARD   REP   2,236,966
85                              DINO FOR CONGRESS                    ROSSI, DINO   REP   2,219,982
86                                    I LIKE LUKE            MESSER, ALLEN LUCAS   REP   2,196,107
87                       JOE KENNEDY FOR CONGRESS          KENNEDY, JOSEPH P III   DEM   2,184,270
88                         CORY BOOKER FOR SENATE                 BOOKER, CORY A   DEM   2,140,708
89                      MIMI WALTERS VICTORY FUND                  WALTERS, MIMI   REP   2,136,342
90                    BEN CARDIN FOR SENATE, INC.             CARDIN, BENJAMIN L   DEM   2,136,206
91                          MCCREADY FOR CONGRESS               MCCREADY, DANIEL   DEM   2,128,749
92                              MAST FOR CONGRESS                    MAST, BRIAN   REP   2,104,483
93                  ROSKAM FOR CONGRESS COMMITTEE                  ROSKAM, PETER   REP   2,103,918
94                     CHARLIE CRIST FOR CONGRESS          CRIST, CHARLIE JOSEPH   DEM   2,073,500
95                          ROB QUIST FOR MONTANA               QUIST, ROBERT E.   DEM   2,037,947
96                     DEAN PHILLIPS FOR CONGRESS                 PHILLIPS, DEAN   DFL   2,026,397
97                     BILL CASSIDY FOR US SENATE               CASSIDY, WILLIAM   REP   1,995,217
98                       BOB HUGIN FOR SENATE INC                  HUGIN, ROBERT   REP   1,965,289
99                       JOSH HARDER FOR CONGRESS                   HARDER, JOSH   DEM   1,961,159
100                      RANDY BRYCE FOR CONGRESS                   BRYCE, RANDY   DEM   1,959,281

TOTAL = 1,214,951,220

Largest Individual Contributions Grouped by Candidates

The following code aggregates the individual contributions by the candidate name and party of all candidates. As can be seen, the first three candidates are the same as those listed in the prior section and their amounts are relatively close to those listed above, indicating that most of each candidates' fundraising is being done by one main committee. The amounts are simply the sum of all committees supported with that candidate. For example, the $57,763,577 listed for Paul Ryan equals the $53,458,491 listed for "Team Ryan" and the RYAN FOR CONGRESS, INC. $4,305,086 listed for "Ryan for Congress, Inc." in the prior section.

In [78]:
jj = ii.groupby(['CAND_NAME','PARTY'])['AMT'].agg(['sum'])
jj = jj.reset_index(level=['CAND_NAME','PARTY'])
jj.columns = ['CAND_NAME','PARTY','AMT']
jj['AMOUNT'] = jj['AMT'].apply(lambda x: '{:,}'.format(x))
jj = jj.sort_values(by='AMT',ascending=False)
jj.index = range(1,len(jj)+1)
print(jj[['CAND_NAME','PARTY','AMOUNT']].head(100))
print('\nTOTAL = ' + '{:,}'.format(sum(jj['AMT'])))
                         CAND_NAME PARTY      AMOUNT
1                    RYAN, PAUL D.   REP  57,763,577
2                      SCOTT, RICK   REP  35,511,899
3                MCCASKILL, CLAIRE   DEM  30,088,790
4         CRUZ, RAFAEL EDWARD  TED   REP  19,338,147
5               CASEY, ROBERT P JR   DEM  19,199,313
6                      JONES, DOUG   DEM  15,251,542
7                   BROWN, SHERROD   DEM  14,857,704
8                   BALDWIN, TAMMY   DEM  14,575,857
9          O'ROURKE, ROBERT (BETO)   DEM  14,250,105
10   GILLIBRAND, KIRSTEN ELIZABETH   DEM  13,519,271
11                 MCCARTHY, KEVIN   REP  12,472,774
12                     TESTER, JON   DEM  11,868,768
13                    TRONE, DAVID   DEM  11,714,114
14                    NELSON, BILL   DEM  11,416,886
15             OSSOFF, T. JONATHAN   DEM  11,054,480
16               FEINSTEIN, DIANNE   DEM   8,919,230
17                    CORNYN, JOHN   REP   8,779,009
18                MENENDEZ, ROBERT   DEM   7,916,811
19                STABENOW, DEBBIE   DEM   7,854,299
20               WARREN, ELIZABETH   DEM   7,834,205
21          KAINE, TIMOTHY MICHAEL   DEM   7,104,665
22                 MCSALLY, MARTHA   REP   6,992,175
23                 TRUMP, DONALD J   REP   6,931,317
24                 SINEMA, KYRSTEN   DEM   6,926,804
25               SCALISE, STEVE MR   REP   6,756,887
26                    ROSEN, JACKY   DEM   6,695,338
27        MURPHY, CHRISTOPHER S MR   DEM   6,634,993
28            WALL, KATHALEEN MRS.   REP   6,202,627
29                 HEITKAMP, HEIDI   DEM   6,083,913
30              DONNELLY, JOSEPH S   DEM   5,801,121
31                 CANTWELL, MARIA   DEM   5,687,251
32            HAWLEY, JOSHUA DAVID   REP   5,425,377
33                    HELLER, DEAN   REP   5,015,870
34                     FLAKE, JEFF   REP   5,003,881
35            AYYADURAI, SHIVA  DR   IND   4,942,143
36         MCMORRIS RODGERS, CATHY   REP   4,822,889
37          BLACKBURN, MARSHA MRS.   REP   4,788,645
38                  KLOBUCHAR, AMY   DEM   4,651,723
39                  BOOKER, CORY A   DEM   4,627,066
40                   PELOSI, NANCY   DEM   4,582,182
41                      KERR, PAUL   DEM   4,568,870
42                BREDESEN, PHILIP   DEM   4,524,001
43                  HATCH, ORRIN G   REP   4,267,654
44                 GIANFORTE, GREG   REP   3,992,369
45                 WICKER, ROGER F   REP   3,959,725
46                MANCHIN III, JOE   DEM   3,868,013
47                GOTTHEIMER, JOSH   DEM   3,759,962
48                     BRAUN, MIKE   REP   3,758,143
49                    MANDEL, JOSH   REP   3,741,515
50                    SCHIFF, ADAM   DEM   3,667,122
51                MANDEL, JOSHUA A   REP   3,628,211
52          KING, ANGUS STANLEY JR   IND   3,586,335
53          WHITEHOUSE, SHELDON II   DEM   3,535,350
54         HANDEL, KAREN CHRISTINE   REP   3,467,195
55         KRISHNAMOORTHI, S. RAJA   DEM   3,345,383
56                  COTTON, THOMAS   REP   3,268,732
57                    JANZ, ANDREW   DEM   3,243,091
58                     LAMB, CONOR   DEM   3,121,417
59         HEINRICH, MARTIN TREVOR   DEM   3,091,004
60             NUNES, DEVIN GERALD   REP   3,052,874
61                MOORE, ROY JUDGE   REP   3,014,350
62                      MOODY, DAN   REP   2,957,283
63                   WALTERS, MIMI   REP   2,893,819
64         ROMNEY, MITT WILLARD MR   REP   2,890,045
65              KOH, DANIEL ARRIGG   DEM   2,884,783
66             WARNER, MARK ROBERT   DEM   2,881,209
67                BARRASSO, JOHN A   REP   2,825,705
68                    JACOBS, SARA   DEM   2,805,053
69                FINCHER, STEPHEN   REP   2,760,068
70      SHERRILL, REBECCA MICHELLE   DEM   2,695,693
71                     JAMES, JOHN   REP   2,598,207
72             CURBELO, CARLOS MR.   REP   2,562,006
73                   ROSKAM, PETER   REP   2,558,168
74           FLINN, GEORGE S DR JR   REP   2,547,050
75                   ERNST, JONI K   REP   2,523,024
76                     SMITH, TINA   DEM   2,502,001
77                   KHANNA, ROHIT   DEM   2,481,353
78                 CROWLEY, JOSEPH   DEM   2,458,914
79             CORKER, ROBERT P JR   REP   2,434,233
80                DELGADO, ANTONIO   DEM   2,425,467
81                 HIRONO, MAZIE K   DEM   2,405,181
82                MCCONNELL, MITCH   REP   2,377,197
83                FRIEDMAN, ALISON   DEM   2,377,010
84                   PERDUE, DAVID   REP   2,367,070
85                   BARLETTA, LOU   REP   2,312,220
86             KENNEDY, JOHN NEELY   REP   2,311,258
87               GRAHAM, LINDSEY O   REP   2,291,088
88         ROKITA, THEODORE EDWARD   REP   2,236,966
89                     ROSSI, DINO   REP   2,219,982
90             MESSER, ALLEN LUCAS   REP   2,196,107
91           KENNEDY, JOSEPH P III   DEM   2,184,270
92          WALDEN, GREGORY P. MR.   REP   2,143,272
93              CARDIN, BENJAMIN L   DEM   2,136,206
94                MCCREADY, DANIEL   DEM   2,128,749
95                     MAST, BRIAN   REP   2,119,338
96           CRIST, CHARLIE JOSEPH   DEM   2,073,500
97                QUIST, ROBERT E.   DEM   2,037,947
98                    BRADY, KEVIN   REP   2,028,737
99                  PHILLIPS, DEAN   DFL   2,026,397
100               CASSIDY, WILLIAM   REP   1,995,217

TOTAL = 1,214,951,220

Largest Individual Contributions Grouped by Committees Not Connected to Specific Candidates

The following code aggregates the individual contributions by the committee names of all committees that are not connected to a specific candidate. As can be seen, ActBlue has over four times the contributions of the next largest committee, the "Republican National Committee". ActBlue is a liberal money-gathering platform written about in this recent article.

In [79]:
jj = ii[pd.isnull(ii['CAND_ID'])]
jj = jj.groupby(['CMTE_NM'])['AMT'].agg(['sum'])
jj = jj.reset_index(level=['CMTE_NM'])
jj.columns = ['CMTE_NM','AMT']
jj['AMOUNT'] = jj['AMT'].apply(lambda x: '{:,}'.format(x))
jj = jj.sort_values(by='AMT',ascending=False)
jj.index = range(1,len(jj)+1)
print(jj[['CMTE_NM','AMOUNT']].head(100))
print('\nTOTAL = ' + '{:,}'.format(sum(jj['AMT'])))
                                               CMTE_NM       AMOUNT
1                                              ACTBLUE  409,537,411
2                        REPUBLICAN NATIONAL COMMITTEE   99,168,560
3                        CONGRESSIONAL LEADERSHIP FUND   91,867,046
4                                                 DCCC   89,128,311
5                                                  SMP   77,585,814
6                               SENATE LEADERSHIP FUND   61,330,300
7                                                 DSCC   52,556,845
8              DNC SERVICES CORP./DEM. NAT'L COMMITTEE   50,003,481
9                     NEXTGEN CLIMATE ACTION COMMITTEE   42,232,597
10                                                NRSC   38,391,336
11                                  HOUSE MAJORITY PAC   36,812,603
12                          AMERICA FIRST ACTION, INC.   30,435,227
13                                       TRUMP VICTORY   29,967,696
14                                                NRCC   28,076,375
15                                        EMILY'S LIST   25,014,626
16                                         WOMEN VOTE!   21,725,981
17                                   PROTECT THE HOUSE   21,579,790
18                               WITH HONOR FUND, INC.   17,488,196
19                               PRIORITIES USA ACTION   15,815,785
20             WORKING FOR WORKING AMERICANS - FEDERAL   15,650,908
21                             RGA RIGHT DIRECTION PAC   14,828,173
22            TRUMP MAKE AMERICA GREAT AGAIN COMMITTEE   14,396,438
23                               HOUSE VICTORY PROJECT   14,262,853
24                  FREEDOM PARTNERS ACTION FUND, INC.   13,950,750
25                            PLANNED PARENTHOOD VOTES   11,656,674
26                              CLUB FOR GROWTH ACTION   11,449,924
27   NATIONAL ASSOCIATION OF REALTORS CONGRESSIONAL...   11,033,238
28                        AMERICAN BRIDGE 21ST CENTURY   10,929,403
29                                  NEW REPUBLICAN PAC   10,758,547
30   INTERNATIONAL BROTHERHOOD OF ELECTRICAL WORKER...    9,948,595
31                         MOVEON.ORG POLITICAL ACTION    9,089,974
32                                  KAINE VICTORY FUND    8,438,586
33                                    LCV VICTORY FUND    8,024,780
34                                 END CITIZENS UNITED    7,799,711
35                                      FOR OUR FUTURE    7,778,845
36                                          DGA ACTION    7,192,030
37   AMERICANS FOR PROSPERITY ACTION, INC. (AFP ACT...    7,150,000
38                     ENVIRONMENT AMERICA ACTION FUND    6,750,000
39                                     RESTORATION PAC    6,481,965
40                  DEMOCRATIC GRASSROOTS VICTORY FUND    6,332,300
41                              LIUNA BUILDING AMERICA    5,803,892
42                     MASSACHUSETTS VICTORY COMMITTEE    5,509,900
43   HONEYWELL INTERNATIONAL POLITICAL ACTION COMMI...    5,491,111
44                                          SWING LEFT    5,214,257
45                         PROGRESSIVE TURNOUT PROJECT    4,997,957
46                             FORWARD MAJORITY ACTION    4,974,968
47                    NRSC TARGETED STATE VICTORY FUND    4,932,299
48                                        AMERICAS PAC    4,907,500
49    NATIONAL AIR TRAFFIC CONTROLLERS ASSOCIATION PAC    4,903,026
50                         DEMOCRACY ENGINE, INC., PAC    4,750,244
51   NATIONAL ASSOCIATION OF REALTORS POLITICAL ACT...    4,715,026
52                                  WISCONSIN NEXT PAC    4,625,000
53                        ELIZABETH WARREN ACTION FUND    4,600,501
54   AMERICAN ASSOCIATION FOR JUSTICE POLITICAL ACT...    4,582,757
55                             CALIFORNIA VICTORY 2018    4,431,820
56                             SOLUTIONS FOR WISCONSIN    4,402,965
57                                          HIGHWAY 31    4,366,480
58                                   NEA ADVOCACY FUND    4,268,901
59                                        VOTESANE PAC    4,142,350
60                          SERVE AMERICA VICTORY FUND    4,134,949
61   NATIONAL BEER WHOLESALERS ASSOCIATION POLITICA...    4,061,896
62                               JOHN BOLTON SUPER PAC    4,029,658
63       THE BOEING COMPANY POLITICAL ACTION COMMITTEE    3,959,884
64                                          TEXANS ARE    3,854,200
65                 DELOITTE POLITICAL ACTION COMMITTEE    3,776,392
66                   CITIZENS FOR A STRONG AMERICA INC    3,722,000
67   NATIONAL AUTOMOBILE DEALERS ASSOCIATION POLITI...    3,677,287
68                                        GIFFORDS PAC    3,671,499
69                                         WIN JUSTICE    3,600,000
70                                 CLUB FOR GROWTH PAC    3,550,941
71                              MCCASKILL VICTORY FUND    3,360,301
72                                          JSTREETPAC    3,333,523
73                                        CHC BOLD PAC    3,227,824
74   AMERICAN SOCIETY OF ANESTHESIOLOGISTS POLITICA...    3,154,983
75                PATIENTS FOR AFFORDABLE DRUGS ACTION    3,117,239
76               THE COMMITTEE TO DEFEND THE PRESIDENT    3,031,282
77                                                DAGA    3,026,437
78                                  HOUSE FREEDOM FUND    2,988,801
79   LOCKHEED MARTIN CORPORATION EMPLOYEES' POLITIC...    2,982,953
80                                 CFG ACTION MISSOURI    2,961,375
81   KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...    2,954,390
82   COMCAST CORPORATION & NBCUNIVERSAL POLITICAL A...    2,952,744
83   PRICEWATERHOUSECOOPERS POLITICAL ACTION COMMIT...    2,949,075
84            ERNST & YOUNG POLITICAL ACTION COMMITTEE    2,945,131
85           NORTH CAROLINA DEMOCRATIC PARTY - FEDERAL    2,930,134
86                    TEA PARTY PATRIOTS CITIZENS FUND    2,870,629
87   AMERICAN CRYSTAL SUGAR COMPANY POLITICAL ACTIO...    2,836,773
88                                           USW WORKS    2,800,195
89                                   COLOROFCHANGE PAC    2,797,507
90                                 LATINO VICTORY FUND    2,796,124
91                           SENATE CONSERVATIVES FUND    2,785,340
92   UNITEDHEALTH GROUP INCORPORATED PAC (UNITEDHEA...    2,665,329
93   INTERNATIONAL ASSOCIATION OF FIREFIGHTERS INTE...    2,625,101
94       EMPLOYEES OF NORTHROP GRUMMAN CORPORATION PAC    2,593,686
95                           MICHIGAN REPUBLICAN PARTY    2,557,524
96   THE COUNCIL OF INSURANCE AGENTS & BROKERS POLI...    2,528,483
97   NJ STATE LABORERS PAC/ LABORERS' INTERNATIONAL...    2,508,285
98                                CFG ACTION WISCONSIN    2,504,850
99                     OHIO CONSERVATIVES FOR A CHANGE    2,495,240
100  NATIONAL MULTIFAMILY HOUSING COUNCIL POLITICAL...    2,478,328

TOTAL = 2,470,598,642

Summary of Contributions by Specific Individuals

The following code summarizes the contributions given by any specific individual, given their name and, optionally, their city and/or state. The contributions are grouped by the name, city, state, and party of the candidate. If the contribution is to a committee not connected to a candidate, this last item will be "CMTE". The results should be viewed as an estimate, at least until further investigation is done. For example, seaching for "STEYER, THOMAS" did not reveal additional contributions for "STEYER, TOM". Also, both have addresses in Redwood City and San Francisco, CA. It's not clear that these are all for the same person though it is likely that all of the multi-million contribution is from the well-known billionaire. This can be further investigated by looking at the specific contributions (in the next section) and perhaps even referencing the original filings for those contributions on the FEC website.

In any case, the code below looks at the contributions for all of contributors previously shown to have made total contributions of $10 million or more. Note that the search for "ADELSON, SHELDON" included the totals of both "ADELSON, SHELDON", "ADELSON, SHELDON G.", and "ADELSON, SHELDON G" in the third section above. Also, the output reveals a number of misspellings and/or misentries such as for Lake Forest, IL by Richard Uihlein.

In [80]:
def getIndividualSum(name, city, state):
    jj = ii[ii['NAME'].str.contains(name, na=False)]
    if pd.notnull(city):
        jj = jj[jj['CITY'].str.contains(city, na=False)]
    if pd.notnull(state):
        jj = jj[jj['STATE'].str.contains(state, na=False)]
    #if pd.isnull(jj['CAND_ID']):
    #    jj['PARTY'] = jj['CMTE_PTY_AFFILIATION']
    #jj.loc[pd.isnull(jj['CAND_ID']),'PARTY'] = jj.loc[pd.isnull(jj['CAND_ID']),'CMTE_PTY_AFFILIATION']
    #jj.loc[pd.isnull(jj['CAND_ID']),'PARTY'] = jj.loc[pd.isnull(jj['CAND_ID']),'CMTE_NM']
    jj.loc[pd.isnull(jj['CAND_ID']),'PARTY'] = 'CMTE'
    #jj = jj[pd.notnull(jj['CAND_ID'])]
    jj['NAME'] = name
    kk = jj.groupby(['NAME','CITY','STATE','PARTY'])['AMT'].agg(['sum'])
    kk = kk.reset_index(level=['NAME','CITY','STATE','PARTY'])
    kk.columns = ['NAME','CITY','STATE','PARTY','AMT']
    kk['AMOUNT'] = kk['AMT'].apply(lambda x: '{:,}'.format(x))
    #kk.index = range(1,len(jj)+1)
    print(kk[['NAME','CITY','STATE','PARTY','AMOUNT']])
    print('TOTAL = ' + '{:,}'.format(sum(kk['AMT'])))

getIndividualSum('STEYER, THOMAS', '', '')
getIndividualSum('STEYER, TOM', '', '')
getIndividualSum('ADELSON, SHELDON', '', '')
getIndividualSum('ADELSON, MIRIAM', '', '')
getIndividualSum('UIHLEIN, RICHARD', '', '')
#getIndividualSum('UIHLEIN, ELIZABETH', '', '')
getIndividualSum('SCOTT, RICK', '', '')
getIndividualSum('SOROS, GEORGE', '', '')
getIndividualSum('TRONE, DAVID', '', '')
getIndividualSum('EYCHANER, FRED', '', '')
getIndividualSum('BEZOS, JEFF', '', '')
getIndividualSum('MELLON, TIMOTHY', '', '')
             NAME           CITY STATE PARTY      AMOUNT
0  STEYER, THOMAS   REDWOOD CITY    CA  CMTE      55,000
1  STEYER, THOMAS   REDWOOD CITY    CA   DEM      74,551
2  STEYER, THOMAS  SAN FRANCISCO    CA  CMTE  41,674,181
3  STEYER, THOMAS  SAN FRANCISCO    CA   DEM      41,500
TOTAL = 41,845,232
          NAME           CITY STATE PARTY   AMOUNT
0  STEYER, TOM        REDWOOD    CA   DEM    1,000
1  STEYER, TOM   REDWOOD CITY    CA  CMTE  340,100
2  STEYER, TOM   REDWOOD CITY    CA   DEM  172,100
3  STEYER, TOM  SAN FRANCISCO    CA  CMTE   25,000
4  STEYER, TOM  SAN FRANCISCO    CA   DEM    5,400
TOTAL = 543,600
               NAME       CITY STATE PARTY      AMOUNT
0  ADELSON, SHELDON  LAS VEGAS    GA   REP       2,700
1  ADELSON, SHELDON  LAS VEGAS    NV  CMTE  33,037,600
2  ADELSON, SHELDON  LAS VEGAS    NV   REP     176,600
TOTAL = 33,216,900
              NAME       CITY STATE PARTY      AMOUNT
0  ADELSON, MIRIAM  LAS VEGAS    GA   REP       2,700
1  ADELSON, MIRIAM  LAS VEGAS    NV  CMTE  32,587,800
2  ADELSON, MIRIAM  LAS VEGAS    NV   REP     157,700
TOTAL = 32,748,200
                NAME              CITY STATE PARTY      AMOUNT
0   UIHLEIN, RICHARD            HUDSON    WI  CMTE         530
1   UIHLEIN, RICHARD     LAKE   FOREST    IL   REP       2,700
2   UIHLEIN, RICHARD       LAKE FOREST    AL  CMTE       5,400
3   UIHLEIN, RICHARD       LAKE FOREST    IL  CMTE  27,676,200
4   UIHLEIN, RICHARD       LAKE FOREST    IL   REP     460,129
5   UIHLEIN, RICHARD       LAKE FOREST    IL   UNK      10,800
6   UIHLEIN, RICHARD       LAKE FOREST    IN  CMTE   2,400,000
7   UIHLEIN, RICHARD        LAKE FORST    IL  CMTE   2,000,000
8   UIHLEIN, RICHARD        LAKE FORST    IL   REP      -2,600
9   UIHLEIN, RICHARD       MINNEAPOLIS    MN   REP           0
10  UIHLEIN, RICHARD  PLEASANT PRAIRIE    WI   REP       2,700
11  UIHLEIN, RICHARD  PLEASENT PRAIRIE    WI  CMTE     100,000
TOTAL = 32,655,859
          NAME         CITY STATE PARTY      AMOUNT
0  SCOTT, RICK       NAPLES    FL   REP       2,700
1  SCOTT, RICK  TALLAHASSEE    FL   REP  27,050,190
2  SCOTT, RICK      VISALIA    CA  CMTE       2,140
TOTAL = 27,055,030
            NAME      CITY STATE PARTY      AMOUNT
0  SOROS, GEORGE   KATONAH    NY  CMTE     166,400
1  SOROS, GEORGE   KATONAH    NY   DEM       2,700
2  SOROS, GEORGE  NEW YORK    NY  CMTE  14,047,414
3  SOROS, GEORGE  NEW YORK    NY   DEM     113,300
TOTAL = 14,329,814
           NAME      CITY STATE PARTY      AMOUNT
0  TRONE, DAVID  BETHESDA    MD  CMTE     253,800
1  TRONE, DAVID  BETHESDA    MD   DEM  11,235,871
2  TRONE, DAVID   POTOMAC    MD  CMTE     216,410
3  TRONE, DAVID   POTOMAC    MD   DEM      45,200
TOTAL = 11,751,281
             NAME        CITY STATE PARTY      AMOUNT
0  EYCHANER, FRED     CHICAGO    IL  CMTE  10,996,400
1  EYCHANER, FRED     CHICAGO    IL   DEM     135,000
2  EYCHANER, FRED     CHICAGO    IL   DFL       2,700
3  EYCHANER, FRED  WASHINGTON    DC   DEM     247,700
TOTAL = 11,381,800
          NAME      CITY STATE PARTY      AMOUNT
0  BEZOS, JEFF  BELLEVUE    WA  CMTE       5,000
1  BEZOS, JEFF  BELLEVUE    WA   DEM       5,400
2  BEZOS, JEFF  BELLEVUE    WA   REP      13,500
3  BEZOS, JEFF      KENT    WA  CMTE       5,000
4  BEZOS, JEFF   SEATTLE    WA  CMTE  10,139,170
TOTAL = 10,168,070
              NAME      CITY STATE PARTY      AMOUNT
0  MELLON, TIMOTHY  SARATOGA    WY  CMTE  10,012,700
1  MELLON, TIMOTHY  SARATOGA    WY   REP      15,700
TOTAL = 10,028,400

Summary of Contributions by Specific Committees

The following code summarizes the contributions given by any specific committee, given their name and, optionally, their city and/or state. The contributions are grouped by the committee name, city, state, and party of the candidate. As before, if the contribution is to a committee not connected to a candidate, this last item will be "CMTE". Also, the code below looks at the contributions for all of committees previously shown to have made total contributions of $10 million or more.

In [81]:
getIndividualSum('AMERICAN ACTION NETWORK', None, '')
getIndividualSum('UNITED BROTHERHOOD OF CARPENTERS AND JOINERS', None, '')
getIndividualSum('REPUBLICAN GOVERNORS ASSOCIATION', None, '')
getIndividualSum('NATIONAL ASSOCIATION OF REALTO', None, '')
                      NAME        CITY STATE PARTY      AMOUNT
0  AMERICAN ACTION NETWORK  WASHINGTON    DC  CMTE  20,942,497
1  AMERICAN ACTION NETWORK  WASHONGTON    DC  CMTE      60,000
TOTAL = 21,002,497
                                           NAME        CITY STATE PARTY      AMOUNT
0  UNITED BROTHERHOOD OF CARPENTERS AND JOINERS  WASHINGTON    DC  CMTE  15,650,908
TOTAL = 15,650,908
                               NAME        CITY STATE PARTY      AMOUNT
0  REPUBLICAN GOVERNORS ASSOCIATION  WASHINGTON    DC  CMTE  13,176,173
TOTAL = 13,176,173
                             NAME     CITY STATE PARTY      AMOUNT
0  NATIONAL ASSOCIATION OF REALTO  CHICAGO    IL  CMTE  10,635,748
TOTAL = 10,635,748

Top Individual Contributors for OpenSecrets.org on 10/29/18

The following code plots a horizontal bar chart of the top individual contributors according to this page on OpenSecrets.org on 10/29/2018. The top 21 contributors are copied into the code but only the top 17 are charted for readability.

In [5]:
import matplotlib.pyplot as plt
%matplotlib inline
import numpy as np
#import pandas as pd

ind = ['Adelson, Sheldon & Miriam', 'Steyer, Thomas & Kathryn', 'Uihlein, Richard & Elizabeth',
       'Sussman, S. Donald', 'Soros, George', 'Simons, James & Marilyn', 'Eychaner, Fred',
       'Griffin, Kenneth & Anne', 'Bezos, Jeff & Mackenzie', 'Mellon, Timothy',
       'Schwarzman, Steven & Christine','Marcus, George & Judith','Hoffman, Reid','Simon, Deborah',
       'Marcus, Bernard & Billi','Jurvetson, Karla','Bloomberg, Michael','Moskovitz, Dustin & Cari',
       'Skjodt, Paul & Cynthia','Beal, D. Andrew','Mercer, Robert & Diana']
tot = np.array([87.762600, 42.433582, 34.988529, 21.817700, 15.357486, 13.942810, 12.160800, 10.793100, 10.186170, 10.042100,
                8.213800, 8.085825, 8.049133, 7.646186, 7.586125, 6.683146, 6.661024, 5.330730, 5.116000, 5.062774, 4.693524])
per = np.array([0, 1, 0, 1, 1, 1, 1, 0, 0.4, 0, 0, 1, 0.95, 1, 0, 1, 1, 1, 1, 0, 0])
nn = 17 # only go up to Bloomberg for chart
ind = ind[0:nn]
tot = tot[0:nn]
per = per[0:nn]
dem = tot * per
rep = tot - dem
fig, ax = plt.subplots()
fig.set_size_inches(10, 6)
y_pos = np.arange(len(ind))
plt.grid(zorder=0)
ax.barh(y_pos, dem, align='center', color='blue', zorder=3)
ax.barh(y_pos, rep, align='center', color='red', zorder=3, left=dem)
ax.set_yticks(y_pos)
ax.set_yticklabels(ind)
ax.invert_yaxis()
ax.set_xlabel('Millions of Dollars, OpenSecrets 10/29/18 (see http://econdataus.com/camfin181029.html)')
ax.set_title('Top Individual Contributors: All Federal Contributions, 2017-18')
ax.legend(['Democrat','Republican'])
#plt.gcf().subplots_adjust()
plt.tight_layout()
plt.show()
fig.savefig('indcon181029.png')

Top Individual Contributors for OpenSecrets.org on 10/31/18 (updated)

The following code plots a horizontal bar chart of the top individual contributors according to this page on OpenSecrets.org on 10/31/2018, just two days after the prior chart. The top 26 contributors are copied into the code but only the top 17 are charted for readability. As can be seen, the contributions have increased markedly for many of the contributors. For example, the contributions from the Adelsons have increased from over \$87 million to over \$113 million and the contributions from Michael Bloomberg have increased from over \$6 million to over \$38 million. This page shows that the key new contributions from the Adelsons were \$25 million in contributions made on 9/12/18 to the Senate Leadership Fund. [This page](https://www.opensecrets.org/donor-lookup/results?name=Bloomberg%2C+Michael&order=desc&sort=D) shows that the key new contribution by Bloomberg was one for \$20 million made on 10/05/18 to the Senate Majority PAC.

In [3]:
import matplotlib.pyplot as plt
%matplotlib inline
import numpy as np
#import pandas as pd

ind = ['Adelson, Sheldon & Miriam','Steyer, Thomas & Kathryn','Uihlein, Richard & Elizabeth','Bloomberg, Michael',
       'Sussman, S. Donald','Simons, James & Marilyn','Soros, George','Schwarzman, Steven & Christine',
       'Eychaner, Fred','Griffin, Kenneth & Anne','Bezos, Jeff & Mackenzie','Mellon, Timothy',
       'Simon, Deborah','Hoffman, Reid','Marcus, George & Judith','Marcus, Bernard & Billi',
       'Schwab, Charles & Helen','Jurvetson, Karla','Skjodt, Paul & Cynthia','Cameron, Ronald & Nina',
       'Moskovitz, Dustin & Cari','Yass, Jeffrey & Janine','Beal, D. Andrew','Mercer, Robert & Diana',
       'Laufer, Henry & Marsha','Singer, Paul']
tot = np.array([113.036500, 50.773518, 39.095229, 38.229487, 22.876300, 18.918210, 17.365586, 12.814000, 12.173500, 11.070100,
                 10.186170, 10.055600,  8.956980,  8.118533,  8.110125,  7.926725,  7.296840,  7.085505,  6.621000,  6.543879,
                  6.365230,  6.119183,  6.085874,  5.993524,  5.680249,  5.163938])
per = np.array([0, 1, 0, 1,  1, 1, 1, 0,  1, 0, 0.4, 0,  1, 1, 1, 0,  0, 1, 1, 0,  1, 0, 0, 0,  1, 0])
nn = 17 # only go up to Bloomberg for chart
ind = ind[0:nn]
tot = tot[0:nn]
per = per[0:nn]
dem = tot * per
rep = tot - dem
fig, ax = plt.subplots()
fig.set_size_inches(10, 6)
y_pos = np.arange(len(ind))
plt.grid(zorder=0)
ax.barh(y_pos, dem, align='center', color='blue', zorder=3)
ax.barh(y_pos, rep, align='center', color='red', zorder=3, left=dem)
ax.set_yticks(y_pos)
ax.set_yticklabels(ind)
ax.invert_yaxis()
ax.set_xlabel('Millions of Dollars, OpenSecrets 10/31/18 (see http://econdataus.com/camfin181029.html)')
ax.set_title('Top Individual Contributors: All Federal Contributions, 2017-18')
ax.legend(['Democrat','Republican'])
#plt.gcf().subplots_adjust()
plt.tight_layout()
plt.show()
fig.savefig('indcon181031.png')

List of All Contributions by Specific Individuals

The following code lists each contribution made by any specific individual, given their name and, optionally, their city and/or state. The code first lists those contributions made to committees connected to a candidate and then lists those contributions made to committees not connected to a candidate. Both lists are ordered by date and are generated by calling the function getIndividual2All. The two calls below list all contributions by "STEYER, THOMAS" and "STEYER, TOM". Both names show contributions from San Francisco, CA and Redwood City, CA which are about 22 miles apart. The multi-million dollar contributions by STEYER, THOMAS F. in San Francisco suggest that these contributions are made by the well-known billionaire. However, STEYER, TOM in Redwood City, CA can be seen to have made numerous contributions to DEMOCRACY ENGINE, INC., PAC. Looking at the this organization's most recent filing shows that this contributor has "Fahr LLC" listed as their employer and "Advocacy & Philanthropy" listed as their occupation. This suggests that these contributions were made by the same billionaire.

In [83]:
def getIndividual2Candidate(name, city, state):
    jj = ii[ii['NAME'].str.contains(name, na=False)]
    if pd.notnull(city): jj = jj[jj['CITY'].str.contains(city, na=False)]
    if pd.notnull(state): jj = jj[jj['STATE'].str.contains(state, na=False)]
    jj = jj[pd.notnull(jj['CAND_ID'])]
    jj['AMOUNT'] = jj['AMT'].apply(lambda x: '{:,}'.format(x))
    jj = jj.sort_values(by='DATE',ascending=True)
    jj.index = range(1,len(jj)+1)
    kk = jj[['NAME','DATE','AMOUNT','CITY','STATE','CAND_NAME','PARTY']]
    print(kk.head(100))
    print('\nSUBTOTAL = ' + '{:,}'.format(sum(jj['AMT'])))

def getIndividual2Committee(name, city, state):
    jj = ii[ii['NAME'].str.contains(name, na=False)]
    if pd.notnull(city): jj = jj[jj['CITY'].str.contains(city, na=False)]
    if pd.notnull(state): jj = jj[jj['STATE'].str.contains(state, na=False)]
    jj = jj[pd.isnull(jj['CAND_ID'])]
    jj['AMOUNT'] = jj['AMT'].apply(lambda x: '{:,}'.format(x))
    jj = jj.sort_values(by='DATE',ascending=True)
    jj.index = range(1,len(jj)+1)
    kk = jj[['NAME','DATE','AMOUNT','CITY','STATE','CMTE_NM']]
    print(kk.head(100))
    print('\nSUBTOTAL = ' + '{:,}'.format(sum(jj['AMT'])))

def getIndividual2All(name, city, state):
    getIndividual2Candidate(name, city, state)
    getIndividual2Committee(name, city, state)

getIndividual2All('STEYER, THOMAS', None, '')
getIndividual2All('STEYER, TOM', None, '')
                   NAME       DATE AMOUNT           CITY STATE                                        CAND_NAME PARTY
1        STEYER, THOMAS 2017-02-03  1,700  SAN FRANCISCO    CA                                  CANTWELL, MARIA   DEM
2        STEYER, THOMAS 2017-02-03  1,000  SAN FRANCISCO    CA                                  CANTWELL, MARIA   DEM
3   STEYER, THOMAS FAHR 2017-03-23  2,700  SAN FRANCISCO    CA                                     LOFGREN, ZOE   DEM
4   STEYER, THOMAS FAHR 2017-03-23  2,700  SAN FRANCISCO    CA                                     LOFGREN, ZOE   DEM
5        STEYER, THOMAS 2017-04-20  2,700  SAN FRANCISCO    CA                                BARRAGAN, NANETTE   DEM
6        STEYER, THOMAS 2017-09-21  2,700   REDWOOD CITY    CA                                     ROSEN, JACKY   DEM
7        STEYER, THOMAS 2017-09-21  2,700   REDWOOD CITY    CA                                     ROSEN, JACKY   DEM
8        STEYER, THOMAS 2017-09-21  2,700  SAN FRANCISCO    CA                                     GOMEZ, JIMMY   DEM
9        STEYER, THOMAS 2017-09-22  2,700  SAN FRANCISCO    CA                                   KLOBUCHAR, AMY   DEM
10    STEYER, THOMAS F. 2017-10-02  2,700   REDWOOD CITY    CA  CLINTON, HILLARY RODHAM / TIMOTHY MICHAEL KAINE   DEM
11  STEYER, THOMAS FAHR 2017-12-20  2,700   REDWOOD CITY    CA                           WHITEHOUSE, SHELDON II   DEM
12  STEYER, THOMAS FAHR 2017-12-20  2,500   REDWOOD CITY    CA                           WHITEHOUSE, SHELDON II   DEM
13       STEYER, THOMAS 2017-12-21  2,700   REDWOOD CITY    CA                                    RYAN, TIMOTHY   DEM
14       STEYER, THOMAS 2017-12-21  2,700   REDWOOD CITY    CA                                    RYAN, TIMOTHY   DEM
15       STEYER, THOMAS 2017-12-21  2,700   REDWOOD CITY    CA                                   HUFFMAN, JARED   DEM
16  STEYER, THOMAS FAHR 2017-12-28  2,500   REDWOOD CITY    CA                           WHITEHOUSE, SHELDON II   DEM
17       STEYER, THOMAS 2018-02-15  2,700  SAN FRANCISCO    CA                                     NELSON, BILL   DEM
18       STEYER, THOMAS 2018-02-15  2,700   REDWOOD CITY    CA                                WARREN, ELIZABETH   DEM
19       STEYER, THOMAS 2018-02-15  2,700  SAN FRANCISCO    CA                                     NELSON, BILL   DEM
20       STEYER, THOMAS 2018-02-15  2,700   REDWOOD CITY    CA                                WARREN, ELIZABETH   DEM
21       STEYER, THOMAS 2018-03-13  2,700  SAN FRANCISCO    CA                                    EVANS, DWIGHT   DEM
22       STEYER, THOMAS 2018-03-13  2,700  SAN FRANCISCO    CA                                    EVANS, DWIGHT   DEM
23     STEYER, THOMAS F 2018-03-27  2,700  SAN FRANCISCO    CA                                     HARDER, JOSH   DEM
24     STEYER, THOMAS F 2018-04-04  2,700   REDWOOD CITY    CA                           KAINE, TIMOTHY MICHAEL   DEM
25       STEYER, THOMAS 2018-04-04  5,400   REDWOOD CITY    CA                                     ROSEN, JACKY   DEM
26       STEYER, THOMAS 2018-04-04  5,400   REDWOOD CITY    CA                                     ROSEN, JACKY   DEM
27       STEYER, THOMAS 2018-04-04  2,700   REDWOOD CITY    CA                                     ROSEN, JACKY   DEM
28       STEYER, THOMAS 2018-04-04  2,051   REDWOOD CITY    CA                                     ROSEN, JACKY   DEM
29       STEYER, THOMAS 2018-04-05  2,700   REDWOOD CITY    CA                                 GOTTHEIMER, JOSH   DEM
30       STEYER, THOMAS 2018-04-05  2,700   REDWOOD CITY    CA                                 GOTTHEIMER, JOSH   DEM
31       STEYER, THOMAS 2018-05-03  2,700   REDWOOD CITY    CA                                     ROSEN, JACKY   DEM
32       STEYER, THOMAS 2018-05-10  2,700   REDWOOD CITY    CA                                     LEE, BARBARA   DEM
33       STEYER, THOMAS 2018-05-10  2,700   REDWOOD CITY    CA                                     LEE, BARBARA   DEM
34       STEYER, THOMAS 2018-05-29  2,700   REDWOOD CITY    CA                                 STABENOW, DEBBIE   DEM
35       STEYER, THOMAS 2018-06-07  5,400  SAN FRANCISCO    CA                                    RUIZ, RAUL DR   DEM
36       STEYER, THOMAS 2018-06-14  2,700   REDWOOD CITY    CA                           HILL, KATHERINE LAUREN   DEM
37       STEYER, THOMAS 2018-06-29  2,700  SAN FRANCISCO    CA                               KUSTER, ANN MCLANE   DEM
38       STEYER, THOMAS 2018-06-29  1,000  SAN FRANCISCO    CA                                  CANTWELL, MARIA   DEM
39    STEYER, THOMAS F. 2018-06-29  2,700   REDWOOD CITY    CA                           KAINE, TIMOTHY MICHAEL   DEM
40       STEYER, THOMAS 2018-06-29  2,700  SAN FRANCISCO    CA                               KUSTER, ANN MCLANE   DEM
41       STEYER, THOMAS 2018-07-06  2,700   REDWOOD CITY    CA                                 GRIJALVA, RAUL M   DEM
42       STEYER, THOMAS 2018-09-28  2,700   REDWOOD CITY    CA                               BOURDEAUX, CAROLYN   DEM

SUBTOTAL = 116,051
                 NAME       DATE      AMOUNT           CITY STATE                                    CMTE_NM
1      STEYER, THOMAS 2017-02-03       2,700  SAN FRANCISCO    CA  LEAGUE OF CONSERVATION VOTERS ACTION FUND
2      STEYER, THOMAS 2017-03-23       5,400  SAN FRANCISCO    CA  LEAGUE OF CONSERVATION VOTERS ACTION FUND
3      STEYER, THOMAS 2017-03-23       5,400  SAN FRANCISCO    CA  LEAGUE OF CONSERVATION VOTERS ACTION FUND
4   STEYER, THOMAS F. 2017-04-07     500,000  SAN FRANCISCO    CA           NEXTGEN CLIMATE ACTION COMMITTEE
5      STEYER, THOMAS 2017-04-17       2,700  SAN FRANCISCO    CA  LEAGUE OF CONSERVATION VOTERS ACTION FUND
6   STEYER, THOMAS F. 2017-05-04     500,000  SAN FRANCISCO    CA           NEXTGEN CLIMATE ACTION COMMITTEE
7   STEYER, THOMAS F. 2017-06-21      33,900  SAN FRANCISCO    CA                                       DCCC
8   STEYER, THOMAS F. 2017-08-01   4,757,565  SAN FRANCISCO    CA           NEXTGEN CLIMATE ACTION COMMITTEE
9    STEYER, THOMAS F 2017-09-11      33,900  SAN FRANCISCO    CA                                       DSCC
10     STEYER, THOMAS 2017-09-21       2,700  SAN FRANCISCO    CA  LEAGUE OF CONSERVATION VOTERS ACTION FUND
11     STEYER, THOMAS 2017-09-21       2,700  SAN FRANCISCO    CA  LEAGUE OF CONSERVATION VOTERS ACTION FUND
12     STEYER, THOMAS 2017-09-22       2,700  SAN FRANCISCO    CA  LEAGUE OF CONSERVATION VOTERS ACTION FUND
13     STEYER, THOMAS 2017-09-28       5,000   REDWOOD CITY    CA                                  CLEAN PAC
14  STEYER, THOMAS F. 2017-10-18   4,562,022  SAN FRANCISCO    CA           NEXTGEN CLIMATE ACTION COMMITTEE
15     STEYER, THOMAS 2017-12-20      -5,000   REDWOOD CITY    CA                                    ACTBLUE
16     STEYER, THOMAS 2017-12-20       5,200  SAN FRANCISCO    CA  LEAGUE OF CONSERVATION VOTERS ACTION FUND
17     STEYER, THOMAS 2017-12-20       5,000   REDWOOD CITY    CA                      CLIMATE CHAMPIONS PAC
18     STEYER, THOMAS 2017-12-20       5,000   REDWOOD CITY    CA                                    ACTBLUE
19     STEYER, THOMAS 2017-12-20       5,000   REDWOOD CITY    CA                                    ACTBLUE
20     STEYER, THOMAS 2017-12-20       2,700  SAN FRANCISCO    CA  LEAGUE OF CONSERVATION VOTERS ACTION FUND
21     STEYER, THOMAS 2017-12-21       2,700  SAN FRANCISCO    CA  LEAGUE OF CONSERVATION VOTERS ACTION FUND
22     STEYER, THOMAS 2017-12-21       5,000  SAN FRANCISCO    CA                                    ACTBLUE
23     STEYER, THOMAS 2017-12-21       5,000  SAN FRANCISCO    CA                                  ONE VOICE
24     STEYER, THOMAS 2017-12-21       2,700  SAN FRANCISCO    CA  LEAGUE OF CONSERVATION VOTERS ACTION FUND
25     STEYER, THOMAS 2018-02-15       5,000   REDWOOD CITY    CA              PAC FOR A LEVEL PLAYING FIELD
26     STEYER, THOMAS 2018-02-15       5,000   REDWOOD CITY    CA                                    ACTBLUE
27     STEYER, THOMAS 2018-02-15       5,400  SAN FRANCISCO    CA  LEAGUE OF CONSERVATION VOTERS ACTION FUND
28     STEYER, THOMAS 2018-02-15       5,400  SAN FRANCISCO    CA  LEAGUE OF CONSERVATION VOTERS ACTION FUND
29     STEYER, THOMAS 2018-03-13       5,400  SAN FRANCISCO    CA                                    ACTBLUE
30  STEYER, THOMAS F. 2018-04-02  13,504,144  SAN FRANCISCO    CA           NEXTGEN CLIMATE ACTION COMMITTEE
31     STEYER, THOMAS 2018-04-11       5,000   REDWOOD CITY    CA                                  ONE VOICE
32  STEYER, THOMAS F. 2018-06-15     250,000  SAN FRANCISCO    CA                            NEED TO IMPEACH
33  STEYER, THOMAS F. 2018-08-02  12,078,850  SAN FRANCISCO    CA           NEXTGEN CLIMATE ACTION COMMITTEE
34  STEYER, THOMAS F. 2018-08-28      10,000   REDWOOD CITY    CA             NEW HAMPSHIRE DEMOCRATIC PARTY
35     STEYER, THOMAS 2018-08-28       5,000   REDWOOD CITY    CA                                  CLEAN PAC
36  STEYER, THOMAS F. 2018-09-28      10,000   REDWOOD CITY    CA    MINNESOTA DEMOCRATIC-FARMER-LABOR PARTY
37  STEYER, THOMAS F. 2018-12-05   5,390,000  SAN FRANCISCO    CA           NEXTGEN CLIMATE ACTION COMMITTEE

SUBTOTAL = 41,729,181
              NAME       DATE  AMOUNT           CITY STATE                CAND_NAME PARTY
1      STEYER, TOM 2018-03-27   2,700   REDWOOD CITY    CA       ROUDA, HARLEY E JR   DEM
2      STEYER, TOM 2018-03-27   2,700   REDWOOD CITY    CA           MORSE, JESSICA   DEM
3      STEYER, TOM 2018-03-27   2,700   REDWOOD CITY    CA      CAMPA-NAJJAR, AMMAR   DEM
4      STEYER, TOM 2018-03-27   2,700   REDWOOD CITY    CA        CISNEROS, GILBERT   DEM
5      STEYER, TOM 2018-03-27   2,700   REDWOOD CITY    CA             JANZ, ANDREW   DEM
6      STEYER, TOM 2018-03-27   2,700   REDWOOD CITY    CA        PORTER, KATHERINE   DEM
7      STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA         MCCREADY, DANIEL   DEM
8      STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA             BAER, LAUREN   DEM
9      STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA    CRIST, CHARLIE JOSEPH   DEM
10     STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA    CRIST, CHARLIE JOSEPH   DEM
11     STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA    CRIST, CHARLIE JOSEPH   DEM
12     STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA    CRIST, CHARLIE JOSEPH   DEM
13   STEYER, TOM F 2018-03-29   2,700   REDWOOD CITY    CA            ALLRED, COLIN   DEM
14     STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA           NEGUSE, JOSEPH   DEM
15     STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA        MURPHY, STEPHANIE   DEM
16     STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA        MURPHY, STEPHANIE   DEM
17     STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA        ESCOBAR, VERONICA   DEM
18     STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA        ESCOBAR, VERONICA   DEM
19     STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA         SODERBERG, NANCY   DEM
20     STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA                KIM, ANDY   DEM
21     STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA                KIM, ANDY   DEM
22     STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA           PUREVAL, AFTAB   DEM
23     STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA         MCCREADY, DANIEL   DEM
24     STEYER, TOM 2018-03-30   2,700   REDWOOD CITY    CA          CANTWELL, MARIA   DEM
25     STEYER, TOM 2018-03-30   2,700   REDWOOD CITY    CA    CRIST, CHARLIE JOSEPH   DEM
26     STEYER, TOM 2018-03-30   2,700   REDWOOD CITY    CA    CRIST, CHARLIE JOSEPH   DEM
27     STEYER, TOM 2018-04-01   5,400   REDWOOD CITY    CA           BROWN, SHERROD   DEM
28     STEYER, TOM 2018-04-03   2,700   REDWOOD CITY    CA         MCCREADY, DANIEL   DEM
29     STEYER, TOM 2018-04-05   2,700   REDWOOD CITY    CA        ESCOBAR, VERONICA   DEM
30     STEYER, TOM 2018-04-06   2,700   REDWOOD CITY    CA  HEINRICH, MARTIN TREVOR   DEM
31     STEYER, TOM 2018-04-06   2,700   REDWOOD CITY    CA  HEINRICH, MARTIN TREVOR   DEM
32     STEYER, TOM 2018-04-07   2,700   REDWOOD CITY    CA           BROWN, SHERROD   DEM
33     STEYER, TOM 2018-04-07  -2,700   REDWOOD CITY    CA           BROWN, SHERROD   DEM
34     STEYER, TOM 2018-04-11   2,700   REDWOOD CITY    CA     WALLACE, HENRY SCOTT   DEM
35     STEYER, TOM 2018-05-01   2,700   REDWOOD CITY    CA           DE LEON, KEVIN   DEM
36     STEYER, TOM 2018-05-01   2,700   REDWOOD CITY    CA           DE LEON, KEVIN   DEM
37     STEYER, TOM 2018-05-01   2,700   REDWOOD CITY    CA           DE LEON, KEVIN   DEM
38     STEYER, TOM 2018-05-01   2,700   REDWOOD CITY    CA           DE LEON, KEVIN   DEM
39     STEYER, TOM 2018-05-23   2,700   REDWOOD CITY    CA        JONES, GINA ORTIZ   DEM
40  STEYER, TOM F. 2018-06-14   2,700  SAN FRANCISCO    CA  COX, TERRANCE JOHN (TJ)   DEM
41     STEYER, TOM 2018-06-18   2,700   REDWOOD CITY    CA              LEVIN, MIKE   DEM
42     STEYER, TOM 2018-06-25   2,700   REDWOOD CITY    CA          SINEMA, KYRSTEN   DEM
43     STEYER, TOM 2018-06-25   2,700   REDWOOD CITY    CA          SINEMA, KYRSTEN   DEM
44     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA         BREDESEN, PHILIP   DEM
45     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA            STANTON, GREG   DEM
46     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA            STANTON, GREG   DEM
47     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA       DRISKELL, GRETCHEN   DEM
48     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA       DRISKELL, GRETCHEN   DEM
49     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA              WILD, SUSAN   DEM
50     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA         BREDESEN, PHILIP   DEM
51     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA              AXNE, CINDY   DEM
52     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA          SLOTKIN, ELISSA   DEM
53     STEYER, TOM 2018-06-29   1,000   REDWOOD CITY    CA              WATSON, LIZ   DEM
54  STEYER, TOM F. 2018-06-29   2,700  SAN FRANCISCO    CA         FINKENAUER, ABBY   DEM
55     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA          SLOTKIN, ELISSA   DEM
56     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA              BROWN, LISA   DEM
57     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA              BROWN, LISA   DEM
58     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA    MCBATH, LUCIA KAY MS.   DEM
59     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA           DENNEY, AUDREY   DEM
60     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA        DEGETTE, DIANA L.   DEM
61     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA  MUCARSEL-POWELL, DEBBIE   DEM
62     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA            LURIA, ELAINE   DEM
63     STEYER, TOM 2018-06-30   2,700   REDWOOD CITY    CA              TESTER, JON   DEM
64     STEYER, TOM 2018-07-01   2,700   REDWOOD CITY    CA           BALDWIN, TAMMY   DEM
65     STEYER, TOM 2018-07-01   2,700   REDWOOD CITY    CA         JAYAPAL, PRAMILA   DEM
66     STEYER, TOM 2018-08-02   2,700   REDWOOD CITY    CA     O'CONNOR, DANIEL JAY   DEM
67     STEYER, TOM 2018-09-28   1,000        REDWOOD    CA            RING, LISA M.   DEM
68     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA           NEGUSE, JOSEPH   DEM
69     STEYER, TOM 2018-09-28   1,000   REDWOOD CITY    CA         TIPIRNENI, HIRAL   DEM

SUBTOTAL = 178,500
              NAME       DATE  AMOUNT           CITY STATE                                            CMTE_NM
1      STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA                                            ACTBLUE
2      STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA                                            ACTBLUE
3      STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA                                            ACTBLUE
4      STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA                                            ACTBLUE
5      STEYER, TOM 2018-03-29   2,700   REDWOOD CITY    CA                                            ACTBLUE
6      STEYER, TOM 2018-04-11   2,700   REDWOOD CITY    CA                                            ACTBLUE
7      STEYER, TOM 2018-04-11   5,000   REDWOOD CITY    CA                                            ACTBLUE
8      STEYER, TOM 2018-04-23   5,400   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
9      STEYER, TOM 2018-05-01   5,400   REDWOOD CITY    CA                                            ACTBLUE
10     STEYER, TOM 2018-05-29   5,400   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
11     STEYER, TOM 2018-05-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
12     STEYER, TOM 2018-06-25   5,400   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
13     STEYER, TOM 2018-06-25   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
14     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
15     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
16     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
17     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
18     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
19     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
20     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
21     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
22     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
23     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
24     STEYER, TOM 2018-06-29   5,400   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
25     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
26     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
27     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
28     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
29     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
30     STEYER, TOM 2018-06-29   5,400   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
31     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
32     STEYER, TOM 2018-06-29   5,400   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
33     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
34     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
35     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
36     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
37     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
38     STEYER, TOM 2018-06-29   5,400   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
39     STEYER, TOM 2018-06-29   1,000   REDWOOD CITY    CA                                            ACTBLUE
40     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
41     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                                            ACTBLUE
42     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                                            ACTBLUE
43     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
44     STEYER, TOM 2018-06-29   5,400   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
45     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
46     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
47     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
48     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
49     STEYER, TOM 2018-06-29   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
50     STEYER, TOM 2018-06-29   5,400   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
51     STEYER, TOM 2018-08-02   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
52     STEYER, TOM 2018-08-02   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
53     STEYER, TOM 2018-08-02   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
54     STEYER, TOM 2018-08-02   7,300   REDWOOD CITY    CA                               DE LEON VICTORY FUND
55     STEYER, TOM 2018-08-02   2,700   REDWOOD CITY    CA                               DE LEON VICTORY FUND
56     STEYER, TOM 2018-08-02  10,000   REDWOOD CITY    CA                                            ACTBLUE
57     STEYER, TOM 2018-08-28  10,000   REDWOOD CITY    CA                                            ACTBLUE
58     STEYER, TOM 2018-08-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
59     STEYER, TOM 2018-08-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
60     STEYER, TOM 2018-08-28  10,000   REDWOOD CITY    CA                      NEVADA STATE DEMOCRATIC PARTY
61     STEYER, TOM 2018-08-28  10,000   REDWOOD CITY    CA                                            ACTBLUE
62     STEYER, TOM 2018-08-28  10,000   REDWOOD CITY    CA                                            ACTBLUE
63     STEYER, TOM 2018-08-28  10,000   REDWOOD CITY    CA      WASHINGTON STATE DEMOCRATIC CENTRAL COMMITTEE
64     STEYER, TOM 2018-08-29   2,700   REDWOOD CITY    CA                                            ACTBLUE
65     STEYER, TOM 2018-08-29   2,700   REDWOOD CITY    CA                                            ACTBLUE
66     STEYER, TOM 2018-08-30   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
67     STEYER, TOM 2018-08-30   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
68     STEYER, TOM 2018-08-30   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
69     STEYER, TOM 2018-08-30   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
70     STEYER, TOM 2018-08-30   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
71     STEYER, TOM 2018-08-30   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
72     STEYER, TOM 2018-08-30   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
73     STEYER, TOM 2018-08-30   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
74     STEYER, TOM 2018-09-04   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
75  STEYER, TOM F. 2018-09-04  10,000   REDWOOD CITY    CA                              IOWA DEMOCRATIC PARTY
76     STEYER, TOM 2018-09-14  25,000  SAN FRANCISCO    CA  YOUNG DEMOCRATS OF AMERICA POLITICAL ACTION CO...
77     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
78     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
79     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
80     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
81     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
82     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
83     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
84     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
85     STEYER, TOM 2018-09-28   1,000   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
86     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
87     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
88     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
89     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
90     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
91     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
92     STEYER, TOM 2018-09-28   1,000   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
93     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
94     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
95     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
96     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
97     STEYER, TOM 2018-09-28   2,700   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC
98     STEYER, TOM 2018-09-28   1,000   REDWOOD CITY    CA                        DEMOCRACY ENGINE, INC., PAC

SUBTOTAL = 365,100

List of All Contributions for Sheldon and Miriam Adelson

The two calls below list all contributions by "ADELSON, SHELDON" and "ADELSON, MIRIAM". Sheldon Adelson is the billionaire founder, chairman and chief executive officer of Las Vegas Sands Corporation and Miriam Adelson is his wife. The lists show that the two contributed \$160,400, \$32,587,800 \$179,300, and \$33,037,600 for a total of \$65,965,100. However, [a page on OpenSecrets.org](https://www.opensecrets.org/overview/topindivs.php) lists the total contributions to be \$87,762,600. Another page shows the contribution details. Comparing this to the details below shows that it contains \$22 million of contributions for September not contained in the FEC data. That accounts for all but \$202,500 of the difference between \$87,762,600 and \$65,965,100. The cause of that additional \$202,500 could be determined by comparing all of the contribution details. In any case, following are the \$32 million of contributions shown by OpenSecrets for September, including the $22 million not in the FEC data:

Contributor Amount Date Recipient
ADELSON, SHELDON G, LAS VEGAS, NV \$1,000,000 09/14/18 Ending Spending Action Fund
ADELSON, MIRIAM DR, LAS VEGAS, NV \$1,000,000 09/14/18 Ending Spending Action Fund
ADELSON, MIRIAM DR, LAS VEGAS, NV \$5,000,000 09/13/18 America First Action (in FEC on 10/28)
ADELSON, SHELDON G, LAS VEGAS, NV \$5,000,000 09/13/18 America First Action (in FEC on 10/28)
ADELSON, SHELDON, LAS VEGAS, NV \$10,000,000 09/12/18 Congressional Leadership Fund
ADELSON, MIRIAM, LAS VEGAS, NV \$10,000,000 09/12/18 Congressional Leadership Fund

Problem in Using the Bulk Files

The above shows a problem with using the three bulk files listed at the beginning of this notebook. Even though these bulk files were downloaded on October 29th, they still did not yet contain some contributions from September. In fact, the \$10 million to "America First Action" just appeared in the update to the FEC bulk files on October 28th. It is possible to see the other contributions by going to the Filings page on the FEC website, typing type in and selecting the name of the committee or candidate to whom the contribution was made, and finding the filing that contains the contribution.

For example, select the first "Congressional Leadership Fund" entry for the committee (the second is for prior years), order the documents by date, search back in time until you find the document titled "OCTOBER QUARTERLY 2018 | Original", and open the pdf version of the filing. Searching for Adelson then shows the $10,000,000 contributions on page 17 of 396. The same process can be followed to find the \$5,000,000 contributions on page 6 of the October Quarterly filing for "America First Action". However, the same process does not seem able to find the \$1,000,000 contributions.

Problem in Using the Original Filings

A big problem with the original filings is that it's only possible to search them by the committee or candidate to whom the contribution is made. There is apparently no way to automatic way to search by contributor. As a result, some of the reports that use the filings seem to have omissions. For example, the headline of a recent article is Sheldon Adelson Breaks Spending Record on Midterm Elections, Surpassing $100M. The article states:

A new \$25 million donation puts the billionaire benefactors’ total spending toward helping Republicans hold on to both chambers of Congress at \$113 million, Bloomberg reported. The donation was to the Senate Leadership Fund, a super PAC with ties to Senate Majority Leader Mitch McConnell.

The \$113 figure is about \$25 million more than the \$87,762,600 listed by [OpenSecrets.org](https://www.opensecrets.org/overview/topindivs.php). In fact, the table above does not show a recent contribution to the Senate Leadership Fund. Searching their filings, page 9 of the one titled ["OCTOBER MONTHLY 2018"](http://docquery.fec.gov/pdf/691/201810199125775691/201810199125775691.pdf) shows \$12.5 million contributions by each of Sheldon and Miriam Adelson on 9/12/2018. This again suggests that there is no simple, automatic method for searching the filings by contributor. The FEC site does contain a CSV version of the filing that contains the contribution but it may not be a simple matter to check and read this file. Hence, it appears to be easy to miss contributions that are in the original filings but have not yet been added to the FEC bulk files. As can be seen above, it appears that it can sometimes take over a month for all filings to be added. This would seem to be a problem if rapid disclosure of contributions is desired.

In [84]:
getIndividual2All('ADELSON, MIRIAM', None, '')
getIndividual2All('ADELSON, SHELDON', None, '')
#getIndividual2All('ADELSON, SHELLEY', None, '')
                        NAME       DATE  AMOUNT       CITY STATE                   CAND_NAME PARTY
1        ADELSON, MIRIAM DR. 2017-03-10   2,700  LAS VEGAS    NV               ROYCE, ED MR.   REP
2        ADELSON, MIRIAM DR. 2017-03-10   2,700  LAS VEGAS    NV               ROYCE, ED MR.   REP
3        ADELSON, MIRIAM DR. 2017-03-27  10,400  LAS VEGAS    NV    CRUZ, RAFAEL EDWARD  TED   REP
4            ADELSON, MIRIAM 2017-03-31   2,700  LAS VEGAS    NV             BACON, DONALD J   REP
5            ADELSON, MIRIAM 2017-03-31   2,700  LAS VEGAS    NV             BACON, DONALD J   REP
6        ADELSON, MIRIAM DR. 2017-06-12  33,900  LAS VEGAS    NV               RYAN, PAUL D.   REP
7         ADELSON, MIRIAM DR 2017-06-16   2,700  LAS VEGAS    NV            FISCHER, DEBRA S   REP
8      ADELSON, MIRIAM DR DR 2017-06-16   2,700  LAS VEGAS    NV            FISCHER, DEBRA S   REP
9        ADELSON, MIRIAM DR. 2017-06-21   2,700  LAS VEGAS    NV                  ESTES, RON   REP
10           ADELSON, MIRIAM 2017-08-24   5,400  LAS VEGAS    NV  AMODEI, MARK EUGENE EUGENE   REP
11       ADELSON, MIRIAM DR. 2018-02-20   2,700  LAS VEGAS    NV               ROYCE, ED MR.   REP
12           ADELSON, MIRIAM 2018-05-16   2,700  LAS VEGAS    NV               WALTERS, MIMI   REP
13           ADELSON, MIRIAM 2018-05-18   2,700  LAS VEGAS    NV           COMSTOCK, BARBARA   REP
14           ADELSON, MIRIAM 2018-05-22   5,400  LAS VEGAS    NV              HARDY, CRESENT   REP
15           ADELSON, MIRIAM 2018-05-22  -2,700  LAS VEGAS    NV              HARDY, CRESENT   REP
16           ADELSON, MIRIAM 2018-05-22   2,700  LAS VEGAS    NV              HARDY, CRESENT   REP
17           ADELSON, MIRIAM 2018-05-23   2,700  LAS VEGAS    NV                HELLER, DEAN   REP
18           ADELSON, MIRIAM 2018-05-23  -2,700  LAS VEGAS    NV                HELLER, DEAN   REP
19           ADELSON, MIRIAM 2018-05-23   5,400  LAS VEGAS    NV                HELLER, DEAN   REP
20       ADELSON, MIRIAM DR. 2018-05-29   2,700  LAS VEGAS    NV     GALLAGHER, MICHAEL JOHN   REP
21        ADELSON, MIRIAM DR 2018-06-05   2,700  LAS VEGAS    NV        HAWLEY, JOSHUA DAVID   REP
22           ADELSON, MIRIAM 2018-06-05   2,700  LAS VEGAS    NV               WALTERS, MIMI   REP
23     ADELSON, MIRIAM DR DR 2018-06-05  -2,700  LAS VEGAS    NV        HAWLEY, JOSHUA DAVID   REP
24        ADELSON, MIRIAM DR 2018-06-07   2,700  LAS VEGAS    NV                 SCOTT, RICK   REP
25     ADELSON, MIRIAM DR DR 2018-06-07  -2,700  LAS VEGAS    NV                 SCOTT, RICK   REP
26       ADELSON, MIRIAM DR. 2018-06-08   2,700  LAS VEGAS    NV          FITZPATRICK, BRIAN   REP
27       ADELSON, MIRIAM DR. 2018-06-08   2,700  LAS VEGAS    NV          FITZPATRICK, BRIAN   REP
28           ADELSON, MIRIAM 2018-06-11   2,700  LAS VEGAS    NV                   LOVE, MIA   REP
29           ADELSON, MIRIAM 2018-06-11   2,700  LAS VEGAS    NV                   LOVE, MIA   REP
30  ADELSON, MIRIAM DR OTHER 2018-06-12  -2,700  LAS VEGAS    NV           CRAMER, KEVIN MR.   REP
31     ADELSON, MIRIAM DR DR 2018-06-12   5,400  LAS VEGAS    NV           CRAMER, KEVIN MR.   REP
32        ADELSON, MIRIAM DR 2018-06-12   2,700  LAS VEGAS    GA           CRAMER, KEVIN MR.   REP
33       ADELSON, MIRIAM DR. 2018-06-19   5,400  LAS VEGAS    NV      BLACKBURN, MARSHA MRS.   REP
34       ADELSON, MIRIAM DR. 2018-06-19   2,700  LAS VEGAS    NV      BLACKBURN, MARSHA MRS.   REP
35       ADELSON, MIRIAM DR. 2018-06-19  -2,700  LAS VEGAS    NV      BLACKBURN, MARSHA MRS.   REP
36           ADELSON, MIRIAM 2018-06-19   2,700  LAS VEGAS    NV     MCMORRIS RODGERS, CATHY   REP
37           ADELSON, MIRIAM 2018-06-19   2,700  LAS VEGAS    NV     MCMORRIS RODGERS, CATHY   REP
38           ADELSON, MIRIAM 2018-06-19   2,700  LAS VEGAS    NV               ZELDIN, LEE M   REP
39           ADELSON, MIRIAM 2018-06-19   2,700  LAS VEGAS    NV               ZELDIN, LEE M   REP
40           ADELSON, MIRIAM 2018-06-22   2,700  LAS VEGAS    NV           COMSTOCK, BARBARA   REP
41       ADELSON, MIRIAM DR. 2018-06-25   2,700  LAS VEGAS    NV     ROMNEY, MITT WILLARD MR   REP
42       ADELSON, MIRIAM DR. 2018-06-25  -2,700  LAS VEGAS    NV     ROMNEY, MITT WILLARD MR   REP
43       ADELSON, MIRIAM DR. 2018-06-25   5,400  LAS VEGAS    NV     ROMNEY, MITT WILLARD MR   REP
44       ADELSON, MIRIAM DR. 2018-06-26   2,700  LAS VEGAS    NV          STIVERS, STEVE MR.   REP
45       ADELSON, MIRIAM DR. 2018-06-26   2,700  LAS VEGAS    NV          FITZPATRICK, BRIAN   REP
46     ADELSON, MIRIAM DR DR 2018-06-27  -2,700  LAS VEGAS    NV           HYDE-SMITH, CINDY   REP
47        ADELSON, MIRIAM DR 2018-06-27   2,700  LAS VEGAS    NV           HYDE-SMITH, CINDY   REP
48       ADELSON, MIRIAM DR. 2018-06-29   2,700  LAS VEGAS    NV     GALLAGHER, MICHAEL JOHN   REP
49       ADELSON, MIRIAM DR. 2018-06-29   2,700  LAS VEGAS    NV        TAYLOR, SCOTT W. MR.   REP
50       ADELSON, MIRIAM DR. 2018-06-29   2,700  LAS VEGAS    NV               HURD, WILLIAM   REP
51       ADELSON, MIRIAM DR. 2018-06-30   2,700  LAS VEGAS    NV         CURBELO, CARLOS MR.   REP
52       ADELSON, MIRIAM DR. 2018-06-30   2,700  LAS VEGAS    NV                 MAST, BRIAN   REP
53       ADELSON, MIRIAM DR. 2018-06-30   2,700  LAS VEGAS    NV                 MAST, BRIAN   REP
54       ADELSON, MIRIAM DR. 2018-06-30   2,700  LAS VEGAS    NV             KINZINGER, ADAM   REP
55       ADELSON, MIRIAM DR. 2018-06-30   2,700  LAS VEGAS    NV         CURBELO, CARLOS MR.   REP

SUBTOTAL = 160,400
                     NAME       DATE      AMOUNT       CITY STATE                                            CMTE_NM
1     ADELSON, MIRIAM DR. 2017-06-02       5,000  LAS VEGAS    NV  LAS VEGAS SANDS CORP. POLITICAL ACTION COMMITT...
2     ADELSON, MIRIAM DR. 2018-02-09       5,000  LAS VEGAS    NV  LAS VEGAS SANDS CORP. POLITICAL ACTION COMMITT...
3         ADELSON, MIRIAM 2018-05-03  15,000,000  LAS VEGAS    NV                      CONGRESSIONAL LEADERSHIP FUND
4  ADELSON, MIRIAM O. DR. 2018-05-24      33,900  LAS VEGAS    NV                      REPUBLICAN NATIONAL COMMITTEE
5         ADELSON, MIRIAM 2018-06-25      43,900  LAS VEGAS    NV                         HELLER NEVADA VICTORY FUND
6         ADELSON, MIRIAM 2018-07-26  12,500,000  LAS VEGAS    NV                             SENATE LEADERSHIP FUND
7     ADELSON, MIRIAM DR. 2018-09-13   5,000,000  LAS VEGAS    NV                         AMERICA FIRST ACTION, INC.

SUBTOTAL = 32,587,800
                       NAME       DATE  AMOUNT       CITY STATE                   CAND_NAME PARTY
1        ADELSON, SHELDON G 2017-03-10   2,700  LAS VEGAS    NV               ROYCE, ED MR.   REP
2        ADELSON, SHELDON G 2017-03-10   2,700  LAS VEGAS    NV               ROYCE, ED MR.   REP
3   ADELSON, SHELDON G. MR. 2017-03-27  10,400  LAS VEGAS    NV    CRUZ, RAFAEL EDWARD  TED   REP
4        ADELSON, SHELDON G 2017-03-31   2,700  LAS VEGAS    NV             BACON, DONALD J   REP
5        ADELSON, SHELDON G 2017-03-31   2,700  LAS VEGAS    NV             BACON, DONALD J   REP
6          ADELSON, SHELDON 2017-06-12  33,900  LAS VEGAS    NV               RYAN, PAUL D.   REP
7        ADELSON, SHELDON G 2017-06-16   2,700  LAS VEGAS    NV            FISCHER, DEBRA S   REP
8        ADELSON, SHELDON G 2017-06-16   2,700  LAS VEGAS    NV            FISCHER, DEBRA S   REP
9       ADELSON, SHELDON MR 2017-06-21   2,700  LAS VEGAS    NV             WICKER, ROGER F   REP
10      ADELSON, SHELDON MR 2017-06-21   2,700  LAS VEGAS    NV             WICKER, ROGER F   REP
11         ADELSON, SHELDON 2017-06-21   2,700  LAS VEGAS    NV                  ESTES, RON   REP
12         ADELSON, SHELDON 2017-08-24   5,400  LAS VEGAS    NV  AMODEI, MARK EUGENE EUGENE   REP
13       ADELSON, SHELDON G 2018-02-21   2,700  LAS VEGAS    NV               ROYCE, ED MR.   REP
14      ADELSON, SHELDON G. 2018-05-15   5,400  LAS VEGAS    NV                   LOVE, MIA   REP
15      ADELSON, SHELDON G. 2018-05-15  -2,700  LAS VEGAS    NV                   LOVE, MIA   REP
16      ADELSON, SHELDON G. 2018-05-15   2,700  LAS VEGAS    NV                   LOVE, MIA   REP
17  ADELSON, SHELDON G. MR. 2018-05-15   2,700  LAS VEGAS    NV      BLACKBURN, MARSHA MRS.   REP
18  ADELSON, SHELDON G. MR. 2018-05-15  -2,700  LAS VEGAS    NV      BLACKBURN, MARSHA MRS.   REP
19  ADELSON, SHELDON G. MR. 2018-05-15   5,400  LAS VEGAS    NV      BLACKBURN, MARSHA MRS.   REP
20         ADELSON, SHELDON 2018-05-16   2,700  LAS VEGAS    NV               WALTERS, MIMI   REP
21      ADELSON, SHELDON G. 2018-05-18   2,700  LAS VEGAS    NV           COMSTOCK, BARBARA   REP
22         ADELSON, SHELDON 2018-05-22   5,400  LAS VEGAS    NV              HARDY, CRESENT   REP
23         ADELSON, SHELDON 2018-05-22  -2,700  LAS VEGAS    NV              HARDY, CRESENT   REP
24         ADELSON, SHELDON 2018-05-22   2,700  LAS VEGAS    NV              HARDY, CRESENT   REP
25         ADELSON, SHELDON 2018-05-23   5,400  LAS VEGAS    NV                HELLER, DEAN   REP
26         ADELSON, SHELDON 2018-05-23   2,700  LAS VEGAS    NV                HELLER, DEAN   REP
27      ADELSON, SHELDON G. 2018-05-23   2,700  LAS VEGAS    NV             KINZINGER, ADAM   REP
28         ADELSON, SHELDON 2018-05-23  -2,700  LAS VEGAS    NV                HELLER, DEAN   REP
29      ADELSON, SHELDON G. 2018-05-24   2,700  LAS VEGAS    NV                 MAST, BRIAN   REP
30      ADELSON, SHELDON G. 2018-05-24   2,700  LAS VEGAS    NV                 MAST, BRIAN   REP
31         ADELSON, SHELDON 2018-05-29   2,700  LAS VEGAS    NV     GALLAGHER, MICHAEL JOHN   REP
32       ADELSON, SHELDON G 2018-06-05   2,700  LAS VEGAS    NV        HAWLEY, JOSHUA DAVID   REP
33       ADELSON, SHELDON G 2018-06-05  -2,700  LAS VEGAS    NV        HAWLEY, JOSHUA DAVID   REP
34       ADELSON, SHELDON G 2018-06-05   5,400  LAS VEGAS    NV        HAWLEY, JOSHUA DAVID   REP
35         ADELSON, SHELDON 2018-06-05   2,700  LAS VEGAS    NV               WALTERS, MIMI   REP
36    ADELSON, SHELDON G MR 2018-06-07   2,700  LAS VEGAS    NV                 SCOTT, RICK   REP
37    ADELSON, SHELDON G MR 2018-06-07  -2,700  LAS VEGAS    NV                 SCOTT, RICK   REP
38      ADELSON, SHELDON G. 2018-06-08   2,700  LAS VEGAS    NV          FITZPATRICK, BRIAN   REP
39      ADELSON, SHELDON G. 2018-06-08   2,700  LAS VEGAS    NV          FITZPATRICK, BRIAN   REP
40       ADELSON, SHELDON G 2018-06-12  -2,700  LAS VEGAS    NV           CRAMER, KEVIN MR.   REP
41       ADELSON, SHELDON G 2018-06-12   2,700  LAS VEGAS    GA           CRAMER, KEVIN MR.   REP
42       ADELSON, SHELDON G 2018-06-12   5,400  LAS VEGAS    NV           CRAMER, KEVIN MR.   REP
43         ADELSON, SHELDON 2018-06-19   2,700  LAS VEGAS    NV               ZELDIN, LEE M   REP
44         ADELSON, SHELDON 2018-06-19   2,700  LAS VEGAS    NV     MCMORRIS RODGERS, CATHY   REP
45         ADELSON, SHELDON 2018-06-19   2,700  LAS VEGAS    NV               ZELDIN, LEE M   REP
46         ADELSON, SHELDON 2018-06-19   2,700  LAS VEGAS    NV     MCMORRIS RODGERS, CATHY   REP
47      ADELSON, SHELDON G. 2018-06-22   2,700  LAS VEGAS    NV           COMSTOCK, BARBARA   REP
48   ADELSON, SHELDON G MR. 2018-06-25   5,400  LAS VEGAS    NV     ROMNEY, MITT WILLARD MR   REP
49   ADELSON, SHELDON G MR. 2018-06-25   2,700  LAS VEGAS    NV     ROMNEY, MITT WILLARD MR   REP
50   ADELSON, SHELDON G MR. 2018-06-25  -2,700  LAS VEGAS    NV     ROMNEY, MITT WILLARD MR   REP
51     ADELSON, SHELDON MR. 2018-06-26   2,700  LAS VEGAS    NV          STIVERS, STEVE MR.   REP
52      ADELSON, SHELDON G. 2018-06-26   2,700  LAS VEGAS    NV          FITZPATRICK, BRIAN   REP
53       ADELSON, SHELDON G 2018-06-27  -2,700  LAS VEGAS    NV           HYDE-SMITH, CINDY   REP
54       ADELSON, SHELDON G 2018-06-27   2,700  LAS VEGAS    NV           HYDE-SMITH, CINDY   REP
55  ADELSON, SHELDON G. MR. 2018-06-29   2,700  LAS VEGAS    NV        TAYLOR, SCOTT W. MR.   REP
56   ADELSON, SHELDON G MR. 2018-06-29   2,700  LAS VEGAS    NV               HURD, WILLIAM   REP
57         ADELSON, SHELDON 2018-06-29   2,700  LAS VEGAS    NV     GALLAGHER, MICHAEL JOHN   REP
58      ADELSON, SHELDON G. 2018-06-29   5,400  LAS VEGAS    NV          BARR, GARLAND ANDY   REP
59   ADELSON, SHELDON G MR. 2018-06-30   2,700  LAS VEGAS    NV         CURBELO, CARLOS MR.   REP
60   ADELSON, SHELDON G MR. 2018-06-30   2,700  LAS VEGAS    NV         CURBELO, CARLOS MR.   REP
61       ADELSON, SHELDON G 2018-09-11   2,700  LAS VEGAS    NV               KNIGHT, STEVE   REP

SUBTOTAL = 179,300
                      NAME       DATE      AMOUNT       CITY STATE                                            CMTE_NM
1   ADELSON, SHELDON G MR. 2017-06-02       5,000  LAS VEGAS    NV  LAS VEGAS SANDS CORP. POLITICAL ACTION COMMITT...
2   ADELSON, SHELDON G MR. 2018-02-09       5,000  LAS VEGAS    NV  LAS VEGAS SANDS CORP. POLITICAL ACTION COMMITT...
3         ADELSON, SHELDON 2018-05-03  15,000,000  LAS VEGAS    NV                      CONGRESSIONAL LEADERSHIP FUND
4  ADELSON, SHELDON G. MR. 2018-06-01      33,900  LAS VEGAS    NV                      REPUBLICAN NATIONAL COMMITTEE
5         ADELSON, SHELDON 2018-06-25      43,900  LAS VEGAS    NV                         HELLER NEVADA VICTORY FUND
6      ADELSON, SHELDON G. 2018-06-30     371,500  LAS VEGAS    NV                                  PROTECT THE HOUSE
7      ADELSON, SHELDON G. 2018-07-26  12,500,000  LAS VEGAS    NV                             SENATE LEADERSHIP FUND
8      ADELSON, SHELDON G. 2018-09-07      78,300  LAS VEGAS    NV                                  PROTECT THE HOUSE
9       ADELSON, SHELDON G 2018-09-13   5,000,000  LAS VEGAS    NV                         AMERICA FIRST ACTION, INC.

SUBTOTAL = 33,037,600

List of All Contributions for Rick Scott

The call below lists all contributions by "SCOTT, RICK". Rick Scott is the current governor of Florida who is running for the Senate against current Florida Senator Bill Nelson. What is of special interest is that, not only is Rick Scott the federal candidate receiving the most funds after House Speaker Paul Ryan, he appears to be making most of the contributions. Out of the total of \$35,511,899 in contributions, \$27,050,190 appears to be from Scott. According to his Wikipedia page, Scott's net worth stood at \$255 million as of August 2018. That means that Scott has contributed over 10 percent of his net worth to his own campaign.

In [85]:
getIndividual2All('SCOTT, RICK', None, '')
                 NAME       DATE     AMOUNT         CITY STATE        CAND_NAME PARTY
1         SCOTT, RICK 2017-03-06      2,700       NAPLES    FL  GIANFORTE, GREG   REP
2         SCOTT, RICK 2018-02-05     50,613  TALLAHASSEE    FL      SCOTT, RICK   REP
3         SCOTT, RICK 2018-03-01        457  TALLAHASSEE    FL      SCOTT, RICK   REP
4         SCOTT, RICK 2018-03-31      5,132  TALLAHASSEE    FL      SCOTT, RICK   REP
5         SCOTT, RICK 2018-03-31      2,600  TALLAHASSEE    FL      SCOTT, RICK   REP
6         SCOTT, RICK 2018-03-31      7,500  TALLAHASSEE    FL      SCOTT, RICK   REP
7         SCOTT, RICK 2018-04-08      1,496  TALLAHASSEE    FL      SCOTT, RICK   REP
8         SCOTT, RICK 2018-04-09      2,417  TALLAHASSEE    FL      SCOTT, RICK   REP
9         SCOTT, RICK 2018-04-11      6,063  TALLAHASSEE    FL      SCOTT, RICK   REP
10        SCOTT, RICK 2018-04-12  2,500,000  TALLAHASSEE    FL      SCOTT, RICK   REP
11        SCOTT, RICK 2018-04-12      7,521  TALLAHASSEE    FL      SCOTT, RICK   REP
12        SCOTT, RICK 2018-04-14      4,113  TALLAHASSEE    FL      SCOTT, RICK   REP
13        SCOTT, RICK 2018-04-17      3,081  TALLAHASSEE    FL      SCOTT, RICK   REP
14        SCOTT, RICK 2018-04-18      6,168  TALLAHASSEE    FL      SCOTT, RICK   REP
15        SCOTT, RICK 2018-04-19      9,286  TALLAHASSEE    FL      SCOTT, RICK   REP
16        SCOTT, RICK 2018-04-23      5,449  TALLAHASSEE    FL      SCOTT, RICK   REP
17        SCOTT, RICK 2018-04-25      8,289  TALLAHASSEE    FL      SCOTT, RICK   REP
18        SCOTT, RICK 2018-04-26  3,000,000  TALLAHASSEE    FL      SCOTT, RICK   REP
19        SCOTT, RICK 2018-04-28      2,456  TALLAHASSEE    FL      SCOTT, RICK   REP
20        SCOTT, RICK 2018-04-30      6,715  TALLAHASSEE    FL      SCOTT, RICK   REP
21        SCOTT, RICK 2018-05-06     12,126  TALLAHASSEE    FL      SCOTT, RICK   REP
22        SCOTT, RICK 2018-05-08     12,779  TALLAHASSEE    FL      SCOTT, RICK   REP
23        SCOTT, RICK 2018-05-10      5,679  TALLAHASSEE    FL      SCOTT, RICK   REP
24        SCOTT, RICK 2018-05-11  3,000,000  TALLAHASSEE    FL      SCOTT, RICK   REP
25        SCOTT, RICK 2018-05-11      4,528  TALLAHASSEE    FL      SCOTT, RICK   REP
26  SCOTT, RICK OTHER 2018-05-12      4,336  TALLAHASSEE    FL      SCOTT, RICK   REP
27        SCOTT, RICK 2018-05-13      2,456  TALLAHASSEE    FL      SCOTT, RICK   REP
28        SCOTT, RICK 2018-05-16      3,837  TALLAHASSEE    FL      SCOTT, RICK   REP
29        SCOTT, RICK 2018-05-18      3,991  TALLAHASSEE    FL      SCOTT, RICK   REP
30        SCOTT, RICK 2018-05-20      4,451  TALLAHASSEE    FL      SCOTT, RICK   REP
31        SCOTT, RICK 2018-05-22      8,941  TALLAHASSEE    FL      SCOTT, RICK   REP
32        SCOTT, RICK 2018-05-24      7,022  TALLAHASSEE    FL      SCOTT, RICK   REP
33        SCOTT, RICK 2018-05-25  1,500,000  TALLAHASSEE    FL      SCOTT, RICK   REP
34        SCOTT, RICK 2018-05-25      4,988  TALLAHASSEE    FL      SCOTT, RICK   REP
35        SCOTT, RICK 2018-05-27      3,875  TALLAHASSEE    FL      SCOTT, RICK   REP
36        SCOTT, RICK 2018-05-29     12,433  TALLAHASSEE    FL      SCOTT, RICK   REP
37        SCOTT, RICK 2018-05-30      6,562  TALLAHASSEE    FL      SCOTT, RICK   REP
38        SCOTT, RICK 2018-05-31     13,584  TALLAHASSEE    FL      SCOTT, RICK   REP
39        SCOTT, RICK 2018-06-02      3,453  TALLAHASSEE    FL      SCOTT, RICK   REP
40        SCOTT, RICK 2018-06-03      2,916  TALLAHASSEE    FL      SCOTT, RICK   REP
41        SCOTT, RICK 2018-06-05      3,607  TALLAHASSEE    FL      SCOTT, RICK   REP
42        SCOTT, RICK 2018-06-06      3,492  TALLAHASSEE    FL      SCOTT, RICK   REP
43        SCOTT, RICK 2018-06-07      9,210  TALLAHASSEE    FL      SCOTT, RICK   REP
44        SCOTT, RICK 2018-06-08  1,500,000  TALLAHASSEE    FL      SCOTT, RICK   REP
45        SCOTT, RICK 2018-06-10      2,456  TALLAHASSEE    FL      SCOTT, RICK   REP
46        SCOTT, RICK 2018-06-11      5,065  TALLAHASSEE    FL      SCOTT, RICK   REP
47        SCOTT, RICK 2018-06-12      7,291  TALLAHASSEE    FL      SCOTT, RICK   REP
48        SCOTT, RICK 2018-06-13      3,415  TALLAHASSEE    FL      SCOTT, RICK   REP
49        SCOTT, RICK 2018-06-14      6,370  TALLAHASSEE    FL      SCOTT, RICK   REP
50        SCOTT, RICK 2018-06-15      7,790  TALLAHASSEE    FL      SCOTT, RICK   REP
51        SCOTT, RICK 2018-06-18     13,162  TALLAHASSEE    FL      SCOTT, RICK   REP
52        SCOTT, RICK 2018-06-19     15,196  TALLAHASSEE    FL      SCOTT, RICK   REP
53        SCOTT, RICK 2018-06-20      3,185  TALLAHASSEE    FL      SCOTT, RICK   REP
54        SCOTT, RICK 2018-06-21  2,000,000  TALLAHASSEE    FL      SCOTT, RICK   REP
55  SCOTT, RICK OTHER 2018-06-25     14,237  TALLAHASSEE    FL      SCOTT, RICK   REP
56        SCOTT, RICK 2018-06-27      7,790  TALLAHASSEE    FL      SCOTT, RICK   REP
57        SCOTT, RICK 2018-06-29      4,451  TALLAHASSEE    FL      SCOTT, RICK   REP
58        SCOTT, RICK 2018-06-30      2,072  TALLAHASSEE    FL      SCOTT, RICK   REP
59        SCOTT, RICK 2018-07-05      2,149  TALLAHASSEE    FL      SCOTT, RICK   REP
60    SCOTT, RICK GOV 2018-07-05      2,149  TALLAHASSEE    FL      SCOTT, RICK   REP
61        SCOTT, RICK 2018-07-07      1,458  TALLAHASSEE    FL      SCOTT, RICK   REP
62    SCOTT, RICK GOV 2018-07-07      1,458  TALLAHASSEE    FL      SCOTT, RICK   REP
63    SCOTT, RICK GOV 2018-07-20  1,000,000  TALLAHASSEE    FL      SCOTT, RICK   REP
64    SCOTT, RICK GOV 2018-07-20  1,000,000  TALLAHASSEE    FL      SCOTT, RICK   REP
65    SCOTT, RICK GOV 2018-07-27      1,189  TALLAHASSEE    FL      SCOTT, RICK   REP
66    SCOTT, RICK GOV 2018-07-27      1,189  TALLAHASSEE    FL      SCOTT, RICK   REP
67    SCOTT, RICK GOV 2018-07-28     13,815  TALLAHASSEE    FL      SCOTT, RICK   REP
68    SCOTT, RICK GOV 2018-07-28     13,815  TALLAHASSEE    FL      SCOTT, RICK   REP
69    SCOTT, RICK GOV 2018-07-29      6,485  TALLAHASSEE    FL      SCOTT, RICK   REP
70    SCOTT, RICK GOV 2018-07-29      6,485  TALLAHASSEE    FL      SCOTT, RICK   REP
71    SCOTT, RICK GOV 2018-07-30      9,824  TALLAHASSEE    FL      SCOTT, RICK   REP
72        SCOTT, RICK 2018-07-30  4,000,000  TALLAHASSEE    FL      SCOTT, RICK   REP
73    SCOTT, RICK GOV 2018-07-30  4,000,000  TALLAHASSEE    FL      SCOTT, RICK   REP
74    SCOTT, RICK GOV 2018-07-30      9,824  TALLAHASSEE    FL      SCOTT, RICK   REP
75        SCOTT, RICK 2018-07-31      4,835  TALLAHASSEE    FL      SCOTT, RICK   REP
76    SCOTT, RICK GOV 2018-07-31      4,835  TALLAHASSEE    FL      SCOTT, RICK   REP
77        SCOTT, RICK 2018-08-01      5,180  TALLAHASSEE    FL      SCOTT, RICK   REP
78    SCOTT, RICK GOV 2018-08-01      5,180  TALLAHASSEE    FL      SCOTT, RICK   REP
79    SCOTT, RICK GOV 2018-08-02      6,600  TALLAHASSEE    FL      SCOTT, RICK   REP
80    SCOTT, RICK GOV 2018-08-02      6,600  TALLAHASSEE    FL      SCOTT, RICK   REP
81    SCOTT, RICK GOV 2018-08-03      1,343  TALLAHASSEE    FL      SCOTT, RICK   REP
82    SCOTT, RICK GOV 2018-08-03      1,343  TALLAHASSEE    FL      SCOTT, RICK   REP
83    SCOTT, RICK GOV 2018-08-05     22,795  TALLAHASSEE    FL      SCOTT, RICK   REP
84    SCOTT, RICK GOV 2018-08-05     22,795  TALLAHASSEE    FL      SCOTT, RICK   REP
85        SCOTT, RICK 2018-08-06  1,500,000  TALLAHASSEE    FL      SCOTT, RICK   REP
86    SCOTT, RICK GOV 2018-08-06  1,500,000  TALLAHASSEE    FL      SCOTT, RICK   REP
87        SCOTT, RICK 2018-08-08      5,871  TALLAHASSEE    FL      SCOTT, RICK   REP
88    SCOTT, RICK GOV 2018-08-08      5,871  TALLAHASSEE    FL      SCOTT, RICK   REP
89        SCOTT, RICK 2018-10-01     31,000  TALLAHASSEE    FL      SCOTT, RICK   REP

SUBTOTAL = 27,052,890
                 NAME       DATE AMOUNT     CITY STATE                                            CMTE_NM
1   WESCOTT, RICKY E. 2017-02-28    150  VISALIA    CA  CALIFORNIA CITRUS MUTUAL POLITICAL ACTION COMM...
2   WESCOTT, RICKY E. 2017-06-01    150  VISALIA    CA  CALIFORNIA CITRUS MUTUAL POLITICAL ACTION COMM...
3   WESCOTT, RICKY E. 2017-06-22    200  VISALIA    CA  CALIFORNIA CITRUS MUTUAL POLITICAL ACTION COMM...
4   WESCOTT, RICKY E. 2017-08-16    300  VISALIA    CA  CALIFORNIA CITRUS MUTUAL POLITICAL ACTION COMM...
5   WESCOTT, RICKY E. 2017-08-28    150  VISALIA    CA  CALIFORNIA CITRUS MUTUAL POLITICAL ACTION COMM...
6   WESCOTT, RICKY E. 2017-09-15     40  VISALIA    CA  CALIFORNIA CITRUS MUTUAL POLITICAL ACTION COMM...
7   WESCOTT, RICKY E. 2017-09-15     10  VISALIA    CA  CALIFORNIA CITRUS MUTUAL POLITICAL ACTION COMM...
8   WESCOTT, RICKY E. 2017-09-26    240  VISALIA    CA  CALIFORNIA CITRUS MUTUAL POLITICAL ACTION COMM...
9   WESCOTT, RICKY E. 2017-10-25    300  VISALIA    CA  CALIFORNIA CITRUS MUTUAL POLITICAL ACTION COMM...
10  WESCOTT, RICKY E. 2018-09-05    600  VISALIA    CA  CALIFORNIA CITRUS MUTUAL POLITICAL ACTION COMM...

SUBTOTAL = 2,140

For a Specified Committee, List All Individual Contributions

The following fuction getIndividual2Committee1 lists all contributions made to specific committees and sorted by date. The two following calls list the contributions for the committees "Congressional Leadership Fund" and "Senate Leadership Fund".

The most recent contribution shown from Sheldon and Miriam Adelson to the "Senate Leadership Fund" is for \$12.5 million each on 7/26/2018. As mentioned above, page 9 of that committee's filing titled "OCTOBER MONTHLY 2018" shows identical contributions being made on 9/12/2018. The fact that the contributions are otherwise identical may be a reason why the more recent ones were missed by OpenSecrets.

In [86]:
def getIndividual2Committee1(cmte_nm):
    jj = ii[ii['CMTE_NM'].str.contains(cmte_nm, na=False)]
    jj['AMOUNT'] = jj['AMT'].apply(lambda x: '{:,}'.format(x))
    jj = jj.sort_values(by='DATE',ascending=True)
    jj.index = range(1,len(jj)+1)
    kk = jj[['NAME','DATE','AMOUNT','CITY','STATE','CMTE_NM']]
    kk['NAME'] = kk['NAME'].str[0:40]
    print(kk.tail(100))
    print('\nSUBTOTAL = ' + '{:,}'.format(sum(jj['AMT'])))

getIndividual2Committee1('CONGRESSIONAL LEADERSHIP')
getIndividual2Committee1('SENATE LEADERSHIP')
C:\Users\bdavi\Anaconda3\lib\site-packages\ipykernel_launcher.py:3: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
  This is separate from the ipykernel package so we can avoid doing imports until
C:\Users\bdavi\Anaconda3\lib\site-packages\ipykernel_launcher.py:7: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
  import sys
                                         NAME       DATE     AMOUNT            CITY STATE                        CMTE_NM
225                       GOODNIGHT, JAMES H. 2018-05-31     99,999            CARY    NC  CONGRESSIONAL LEADERSHIP FUND
226                            DAY, ROBERT A. 2018-05-31     50,000     LOS ANGELES    CA  CONGRESSIONAL LEADERSHIP FUND
227                     MCCAFFERY, MICHAEL G. 2018-06-04     50,000    HILLSBOROUGH    CA  CONGRESSIONAL LEADERSHIP FUND
228                      HENDRICKS, DIANE MS. 2018-06-04    250,000          BELOIT    WI  CONGRESSIONAL LEADERSHIP FUND
229  PROPERTY CASUALTY INSURERS ASSOCIATION O 2018-06-04     75,000         CHICAGO    IL  CONGRESSIONAL LEADERSHIP FUND
230                          ZAGORIN, GREGORY 2018-06-10      1,500       ARLINGTON    VA  CONGRESSIONAL LEADERSHIP FUND
231                           AIMAN, SCOTT A. 2018-06-11      1,000       LANCASTER    OH  CONGRESSIONAL LEADERSHIP FUND
232          OCCIDENTAL PETROLEUM CORPORATION 2018-06-11    250,000         HOUSTON    TX  CONGRESSIONAL LEADERSHIP FUND
233                              RUFFIN, PHIL 2018-06-11     25,000         WICHITA    KS  CONGRESSIONAL LEADERSHIP FUND
234                        METCALFE, NORMAN J 2018-06-11     25,000  CORONA DEL MAR    CA  CONGRESSIONAL LEADERSHIP FUND
235                           BURNS, KEVIN R. 2018-06-11     50,000        ATHERTON    CA  CONGRESSIONAL LEADERSHIP FUND
236                        SCHWAB, CHARLES R. 2018-06-12    250,000   SAN FRANCISCO    CA  CONGRESSIONAL LEADERSHIP FUND
237                              ZELL, SAMUEL 2018-06-13    100,000         CHICAGO    IL  CONGRESSIONAL LEADERSHIP FUND
238                            DEMARAIS, RIMA 2018-06-16         75        WESTPORT    CT  CONGRESSIONAL LEADERSHIP FUND
239                   CONOCO PHILLIPS COMPANY 2018-06-18    250,000      WASHINGTON    DC  CONGRESSIONAL LEADERSHIP FUND
240                      RAI SERVICES COMPANY 2018-06-20    250,000   WINSTON SALEM    NC  CONGRESSIONAL LEADERSHIP FUND
241                    THE SCOTTS COMPANY LLC 2018-06-22    100,000      MARYSVILLE    OH  CONGRESSIONAL LEADERSHIP FUND
242                        MARRIOTT, J.W. JR. 2018-06-22     30,000        BETHESDA    MD  CONGRESSIONAL LEADERSHIP FUND
243                                    ENCANA 2018-06-26    100,000          DENVER    CO  CONGRESSIONAL LEADERSHIP FUND
244                 C.V. STARR & COMPANY INC. 2018-06-26    100,000        NEW YORK    NY  CONGRESSIONAL LEADERSHIP FUND
245                            RASTIN, THOMAS 2018-06-26    100,000    MOUNT VERNON    OH  CONGRESSIONAL LEADERSHIP FUND
246                         GRUNDHOFER, JERRY 2018-06-26      1,000      SAN MARINO    CA  CONGRESSIONAL LEADERSHIP FUND
247          HILLWOOD DEVELOPMENT COMPANY LLC 2018-06-29    250,000          DALLAS    TX  CONGRESSIONAL LEADERSHIP FUND
248                   AMERICAN ACTION NETWORK 2018-06-29  3,500,000      WASHINGTON    DC  CONGRESSIONAL LEADERSHIP FUND
249                     ALPHA MARINE SERVICES 2018-06-29    100,000        GALLIANO    LA  CONGRESSIONAL LEADERSHIP FUND
250                   AMERICAN ACTION NETWORK 2018-06-30    615,833      WASHINGTON    DC  CONGRESSIONAL LEADERSHIP FUND
251                      AMEDISYS HOLDING LLC 2018-07-02     50,000     BATON ROUGE    LA  CONGRESSIONAL LEADERSHIP FUND
252                          MCMAHON, JOHN M. 2018-07-03     25,000        BETHESDA    MD  CONGRESSIONAL LEADERSHIP FUND
253                               WRIGHT, K B 2018-07-05    100,000    MOUNT VERNON    OH  CONGRESSIONAL LEADERSHIP FUND
254                           BURTON, RICHARD 2018-07-06        300        VAN NUYS    CA  CONGRESSIONAL LEADERSHIP FUND
255                           TROY GROUP INC. 2018-07-09     10,000        WHEELING    WV  CONGRESSIONAL LEADERSHIP FUND
256                               DUCKER, JIM 2018-07-09        800          AURORA    CO  CONGRESSIONAL LEADERSHIP FUND
257                             ALTER, ROBERT 2018-07-11     15,000  CORONA DEL MAR    CA  CONGRESSIONAL LEADERSHIP FUND
258                   GRIFFIN, KENNETH C. MR. 2018-07-12  1,500,000         CHICAGO    IL  CONGRESSIONAL LEADERSHIP FUND
259                            HEDLUND, BRIAN 2018-07-12        500       LA CONNER    WA  CONGRESSIONAL LEADERSHIP FUND
260                           NABORS, CHARLES 2018-07-14      1,000       SUNNYVALE    CA  CONGRESSIONAL LEADERSHIP FUND
261                           POUNDS, RANDALL 2018-07-16        250          SPRING    TX  CONGRESSIONAL LEADERSHIP FUND
262                  ANHEUSER BUSCH COMPANIES 2018-07-16     50,000       ST. LOUIS    MO  CONGRESSIONAL LEADERSHIP FUND
263                            DEMARAIS, RIMA 2018-07-16         75        WESTPORT    CT  CONGRESSIONAL LEADERSHIP FUND
264                             REITZ, EDWARD 2018-07-17      1,000        TEQUESTA    FL  CONGRESSIONAL LEADERSHIP FUND
265                   AMERICAN ACTION NETWORK 2018-07-18  1,300,000      WASHINGTON    DC  CONGRESSIONAL LEADERSHIP FUND
266                   AMERICAN ACTION NETWORK 2018-07-18     31,414      WASHINGTON    DC  CONGRESSIONAL LEADERSHIP FUND
267                                TWIN RIVER 2018-07-18     10,000         LINCOLN    RI  CONGRESSIONAL LEADERSHIP FUND
268                      FIELDWOOD ENERGY LLC 2018-07-18     10,000         HOUSTON    TX  CONGRESSIONAL LEADERSHIP FUND
269                              THOMAS, JEFF 2018-07-19      1,000       LAS VEGAS    NV  CONGRESSIONAL LEADERSHIP FUND
270                         PETERSON, JOEL C. 2018-07-19     50,000  SALT LAKE CITY    UT  CONGRESSIONAL LEADERSHIP FUND
271                               SMITH, BOYD 2018-07-23    100,000       PALO ALTO    CA  CONGRESSIONAL LEADERSHIP FUND
272                     RANDOLPH, CHRISTOPHER 2018-07-23        500          OAKTON    VA  CONGRESSIONAL LEADERSHIP FUND
273                HOBAN REALTY INTERESTS LLC 2018-07-24      2,500         EVERETT    WA  CONGRESSIONAL LEADERSHIP FUND
274                           GRAY, C. BOYDEN 2018-07-24     25,000      WASHINGTON    DC  CONGRESSIONAL LEADERSHIP FUND
275                          HAMILTON, ANDREW 2018-07-26        250         BREVARD    NC  CONGRESSIONAL LEADERSHIP FUND
276                            BRYAN, TIMOTHY 2018-07-26     50,000        SOMERSET    NJ  CONGRESSIONAL LEADERSHIP FUND
277                      KOCH INDUSTRIES INC. 2018-07-26    500,000         WICHITA    KS  CONGRESSIONAL LEADERSHIP FUND
278                               LOW, ROBERT 2018-07-27    100,000     SPRINGFIELD    MO  CONGRESSIONAL LEADERSHIP FUND
279             STRATA PRODUCTS WORLDWIDE LLC 2018-07-27     10,000   SANDY SPRINGS    GA  CONGRESSIONAL LEADERSHIP FUND
280                         BOONE, STEPHEN K. 2018-07-30      5,000         OLYMPIA    WA  CONGRESSIONAL LEADERSHIP FUND
281                          KISTULINEC, MARK 2018-07-31     10,000         ATLANTA    GA  CONGRESSIONAL LEADERSHIP FUND
282                           ROTHERMEL, RICK 2018-08-01      2,700         BOTHELL    WA  CONGRESSIONAL LEADERSHIP FUND
283                          SLIVKA, BENJAMIN 2018-08-01      2,300      CLYDE HILL    WA  CONGRESSIONAL LEADERSHIP FUND
284                            THOMAS, MATHEW 2018-08-02      2,000            KENT    WA  CONGRESSIONAL LEADERSHIP FUND
285                          NEUROSURGERY PAC 2018-08-03     15,000      WASHINGTON    DC  CONGRESSIONAL LEADERSHIP FUND
286                         ATHERTON, JOHN J. 2018-08-03        250    POUGHKEEPSIE    NY  CONGRESSIONAL LEADERSHIP FUND
287                              OSBORNE, G R 2018-08-06      5,000        KIRKLAND    WA  CONGRESSIONAL LEADERSHIP FUND
288              NECA PAC PUGET SOUND CHAPTER 2018-08-06      2,500       SHORELINE    WA  CONGRESSIONAL LEADERSHIP FUND
289                       HAWORTH, RICHARD G. 2018-08-06     25,000       SAUGATUCK    MI  CONGRESSIONAL LEADERSHIP FUND
290                            MAIOCCO, JAMES 2018-08-07      1,000         SEATTLE    WA  CONGRESSIONAL LEADERSHIP FUND
291                             NOEL, RICHARD 2018-08-09      2,700    FLOWER MOUND    TX  CONGRESSIONAL LEADERSHIP FUND
292                            CURRY, BERNARD 2018-08-10      5,000       SCARSDALE    NY  CONGRESSIONAL LEADERSHIP FUND
293                            BROOCK, GERALD 2018-08-10        500        PORTLAND    OR  CONGRESSIONAL LEADERSHIP FUND
294                              GUND, GORDON 2018-08-10     90,000       PRINCETON    NJ  CONGRESSIONAL LEADERSHIP FUND
295                               GUND, LLURA 2018-08-10     90,000       PRINCETON    NJ  CONGRESSIONAL LEADERSHIP FUND
296                          MATTHYS, MICHAEL 2018-08-10      2,700      MENLO PARK    CA  CONGRESSIONAL LEADERSHIP FUND
297                          THOMPSON, DONALD 2018-08-14     25,000       CHARLOTTE    NC  CONGRESSIONAL LEADERSHIP FUND
298                            DEMARAIS, RIMA 2018-08-16         75        WESTPORT    CT  CONGRESSIONAL LEADERSHIP FUND
299                    SCHWARZMAN, STEPHEN A. 2018-08-17  2,250,000        NEW YORK    NY  CONGRESSIONAL LEADERSHIP FUND
300                         BUSH, CHRISTOPHER 2018-08-20      1,500        NEW YORK    NY  CONGRESSIONAL LEADERSHIP FUND
301                               HESS, ALLEN 2018-08-20        250      WICKENBURG    AZ  CONGRESSIONAL LEADERSHIP FUND
302                         PARAMORE, CHARLES 2018-08-22        200         KAUFMAN    TX  CONGRESSIONAL LEADERSHIP FUND
303                         PARAMORE, CHARLES 2018-08-22        200         KAUFMAN    TX  CONGRESSIONAL LEADERSHIP FUND
304                      KOCH INDUSTRIES INC. 2018-08-23    500,000         WICHITA    KS  CONGRESSIONAL LEADERSHIP FUND
305  INTERNATIONAL COUNCIL OF SHOPPING CENTER 2018-08-23     25,000        NEW YORK    NY  CONGRESSIONAL LEADERSHIP FUND
306                           MCCONNELL, JOHN 2018-08-24      1,250  WEST LAFAYETTE    IN  CONGRESSIONAL LEADERSHIP FUND
307                         MCILWAIN, MATTHEW 2018-08-27     12,500         SEATTLE    WA  CONGRESSIONAL LEADERSHIP FUND
308                           SCOTT, HENRY C. 2018-08-27     50,000       ALLENDALE    SC  CONGRESSIONAL LEADERSHIP FUND
309                   AMERICAN ACTION NETWORK 2018-08-27    204,280      WASHINGTON    DC  CONGRESSIONAL LEADERSHIP FUND
310                           MCILWAIN, CAROL 2018-08-27     12,500         SEATTLE    WA  CONGRESSIONAL LEADERSHIP FUND
311                          BRINKMEYER, MARC 2018-08-27     50,000       SANDPOINT    ID  CONGRESSIONAL LEADERSHIP FUND
312                               BOOTH, LYNN 2018-08-27     12,500     LOS ANGELES    CA  CONGRESSIONAL LEADERSHIP FUND
313                          EMMERSON, GEORGE 2018-08-27     50,000         REDDING    CA  CONGRESSIONAL LEADERSHIP FUND
314                                LEE, DAVID 2018-08-27     25,000      SAN MARINO    CA  CONGRESSIONAL LEADERSHIP FUND
315                       MCANDREWS, BRIAN P. 2018-08-27      5,000         SEATTLE    WA  CONGRESSIONAL LEADERSHIP FUND
316                            MCCAW, BRUCE R 2018-08-27     10,000        BELLEVUE    WA  CONGRESSIONAL LEADERSHIP FUND
317                              MURRAY, MARK 2018-08-27     10,000    GRAND RAPIDS    MI  CONGRESSIONAL LEADERSHIP FUND
318                             DICKSON, PAUL 2018-08-27     50,000      SHREVEPORT    LA  CONGRESSIONAL LEADERSHIP FUND
319                   HUBBARD, STANLEY S. MR. 2018-10-05     70,000      SAINT PAUL    MN  CONGRESSIONAL LEADERSHIP FUND
320                     OBERNDORF, WILLIAM E. 2018-11-01    500,000   SAN FRANCISCO    CA  CONGRESSIONAL LEADERSHIP FUND
321                           HERRO, DAVID G. 2018-11-06    250,000         CHICAGO    IL  CONGRESSIONAL LEADERSHIP FUND
322                        RUSSELL, THOMAS H. 2018-11-06    500,000           TULSA    OK  CONGRESSIONAL LEADERSHIP FUND
323                     CASTELLINI, ROBERT H. 2018-12-02    100,000      CINCINNATI    OH  CONGRESSIONAL LEADERSHIP FUND
324                             LYNCH, ROBERT 2018-12-07        300     FORT WRIGHT    KY  CONGRESSIONAL LEADERSHIP FUND

SUBTOTAL = 91,867,046
                                         NAME       DATE      AMOUNT               CITY STATE                 CMTE_NM
55                ALTRIA CLIENT SERVICES INC. 2017-10-10      25,000         WASHINGTON    DC  SENATE LEADERSHIP FUND
56                               GERVAIS, DON 2017-10-16         250        NEW ORLEANS    LA  SENATE LEADERSHIP FUND
57     LOVE'S TRAVEL STOPS AND COUNTRY STORES 2017-10-17      25,000      OKLAHOMA CITY    OK  SENATE LEADERSHIP FUND
58                                LLOYD, JOHN 2017-10-24       1,000         LONG BEACH    CA  SENATE LEADERSHIP FUND
59                        COLBURN, RICHARD W. 2017-10-31     200,000         NORTHBROOK    IL  SENATE LEADERSHIP FUND
60                       BUSCH, AUGUST A. III 2017-11-08      50,000       SAINT PETERS    MO  SENATE LEADERSHIP FUND
61                            FRANCO, ALAN I. 2017-11-08      25,000           METAIRIE    LA  SENATE LEADERSHIP FUND
62                             SMITH, MICHAEL 2017-11-13     250,000            BOULDER    CO  SENATE LEADERSHIP FUND
63                        REYNOLDS, ROBERT L. 2017-11-22     100,000            CONCORD    MA  SENATE LEADERSHIP FUND
64                         RUFFIN, PHILLIP G. 2017-12-04     250,000          LAS VEGAS    NV  SENATE LEADERSHIP FUND
65                       OCCIDENTAL PETROLEUM 2017-12-06     100,000         WASHINGTON    DC  SENATE LEADERSHIP FUND
66   PROPERTY CASUALTY INSURERS ASSOCIATION P 2017-12-08      30,000            CHICAGO    IL  SENATE LEADERSHIP FUND
67                   THE ANSCHUTZ CORPORATION 2017-12-15     250,000             DENVER    CO  SENATE LEADERSHIP FUND
68                         FRALIN, W. HEYWOOD 2017-12-18      50,000            ROANOKE    VA  SENATE LEADERSHIP FUND
69                            HERRO, DAVID G. 2017-12-29     250,000            CHICAGO    IL  SENATE LEADERSHIP FUND
70         ENTERTAINMENT SOFTWARE ASSOCIATION 2017-12-29      50,000         WASHINGTON    DC  SENATE LEADERSHIP FUND
71                        MARCUS, BERNARD MR. 2018-02-01   2,000,000            ATLANTA    GA  SENATE LEADERSHIP FUND
72                           TESORO COMPANIES 2018-02-08   1,000,000        SAN ANTONIO    TX  SENATE LEADERSHIP FUND
73                        CHILDS, JOHN W. MR. 2018-02-09     100,000         VERO BEACH    FL  SENATE LEADERSHIP FUND
74   AMERICAN FUEL AND PETROCHEMICAL MANUFACT 2018-02-21     100,000         WASHINGTON    DC  SENATE LEADERSHIP FUND
75                             NEXTERA ENERGY 2018-02-27     500,000         JUNO BEACH    FL  SENATE LEADERSHIP FUND
76                   DUCHOSSOIS, CRAIG J. MR. 2018-02-28     500,000            CHICAGO    IL  SENATE LEADERSHIP FUND
77                              HERTOG, ROGER 2018-03-01      25,000           NEW YORK    NY  SENATE LEADERSHIP FUND
78                       DUCHOSSOIS, CRAIG J. 2018-03-05     500,000            CHICAGO    IL  SENATE LEADERSHIP FUND
79                                    CHEVRON 2018-03-06     700,000          SAN RAMON    CA  SENATE LEADERSHIP FUND
80    JACKSON NATIONAL LIFE INSURANCE COMPANY 2018-03-06     100,000            LANSING    MI  SENATE LEADERSHIP FUND
81             TANGLEWOOD PROPERTY MANAGEMENT 2018-03-06     500,000            HOUSTON    TX  SENATE LEADERSHIP FUND
82                               CHAO, ALBERT 2018-03-07      50,000            HOUSTON    TX  SENATE LEADERSHIP FUND
83                        JOHNSON, CHARLES B. 2018-03-07     300,000         PALM BEACH    FL  SENATE LEADERSHIP FUND
84                      OBERNDORF, WILLIAM E. 2018-03-07   1,000,000      SAN FRANCISCO    CA  SENATE LEADERSHIP FUND
85                             KEMMERER, JOHN 2018-03-09      25,000            JACKSON    WY  SENATE LEADERSHIP FUND
86                             DEMARAIS, RIMA 2018-03-16          75           WESTPORT    CT  SENATE LEADERSHIP FUND
87                             REYES, M. JUDE 2018-03-19     250,000    WEST PALM BEACH    FL  SENATE LEADERSHIP FUND
88                      REYES, J. CHRISTOPHER 2018-03-19     250,000    WEST PALM BEACH    FL  SENATE LEADERSHIP FUND
89                         CAMERON, RONALD M. 2018-03-20     500,000  NORTH LITTLE ROCK    AR  SENATE LEADERSHIP FUND
90                    JWC III REVOCABLE TRUST 2018-03-23   1,000,000              TULSA    OK  SENATE LEADERSHIP FUND
91                      CASTELLINI, ROBERT H. 2018-04-03      75,000         CINCINNATI    OH  SENATE LEADERSHIP FUND
92                        REYNOLDS, ROBERT L. 2018-04-03     100,000            CONCORD    MA  SENATE LEADERSHIP FUND
93                        SCHWARTZ, MARVIN C. 2018-04-03      50,000           NEW YORK    NY  SENATE LEADERSHIP FUND
94                            DAVIS, JAMES S. 2018-04-05     250,000           BRIGHTON    MA  SENATE LEADERSHIP FUND
95                              PRESERVAS LLC 2018-04-10         500           CHEYENNE    WY  SENATE LEADERSHIP FUND
96                             DEMARAIS, RIMA 2018-04-16          75           WESTPORT    CT  SENATE LEADERSHIP FUND
97                            HERRO, DAVID G. 2018-04-17     150,000        MIAMI BEACH    FL  SENATE LEADERSHIP FUND
98                               PITT, ERNEST 2018-04-24       1,000            ASHLAND    KY  SENATE LEADERSHIP FUND
99                          BOCKRATH, RICHARD 2018-05-13       2,000         WILMINGTON    DE  SENATE LEADERSHIP FUND
100                             AP2 MELALEUCA 2018-05-16     400,000        IDAHO FALLS    ID  SENATE LEADERSHIP FUND
101                            DEMARAIS, RIMA 2018-05-16          75           WESTPORT    CT  SENATE LEADERSHIP FUND
102                         BANKE, BARBARA R. 2018-05-22     100,000        GEYSERVILLE    CA  SENATE LEADERSHIP FUND
103                          ED SMITH AND CO. 2018-05-22      50,000          LAS VEGAS    NV  SENATE LEADERSHIP FUND
104                                H.J.K. LLC 2018-05-22      50,000           NEW YORK    NY  SENATE LEADERSHIP FUND
105                    SCHWARZMAN, STEPHEN A. 2018-06-01   5,000,000           NEW YORK    NY  SENATE LEADERSHIP FUND
106                     MCNAIR, ROBERT C. SR. 2018-06-11   1,000,000            HOUSTON    TX  SENATE LEADERSHIP FUND
107                            KANEB, JOHN A. 2018-06-11     250,000          LYNNFIELD    MA  SENATE LEADERSHIP FUND
108         PINNACLE WEST CAPITAL CORPORATION 2018-06-13      50,000            PHOENIX    AZ  SENATE LEADERSHIP FUND
109                            DEMARAIS, RIMA 2018-06-16          75           WESTPORT    CT  SENATE LEADERSHIP FUND
110                            CONOCOPHILLIPS 2018-06-18   1,000,000            HOUSTON    TX  SENATE LEADERSHIP FUND
111                ANADARKO PETROLEUM COMPANY 2018-06-20     100,000         WASHINGTON    DC  SENATE LEADERSHIP FUND
112                      MCINERNEY, THOMAS E. 2018-06-28     200,000           WESTPORT    CT  SENATE LEADERSHIP FUND
113               RIGHT TO RISE SUPER PAC INC 2018-06-29      50,000         WASHINGTON    DC  SENATE LEADERSHIP FUND
114                            JOHNS, JOHN D. 2018-07-02      50,000         BIRMINGHAM    AL  SENATE LEADERSHIP FUND
115                           NABORS, CHARLES 2018-07-14       1,000          SUNNYVALE    CA  SENATE LEADERSHIP FUND
116                              TULL, THOMAS 2018-07-16      50,000        LOS ANGELES    CA  SENATE LEADERSHIP FUND
117                            DEMARAIS, RIMA 2018-07-16          75           WESTPORT    CT  SENATE LEADERSHIP FUND
118                           HERRO, DAVID G. 2018-07-17     100,000        MIAMI BEACH    FL  SENATE LEADERSHIP FUND
119                             PRESERVAS LLC 2018-07-17         250           CHEYENNE    WY  SENATE LEADERSHIP FUND
120                       KOCH INDUSTRIES INC 2018-07-18     500,000            WICHITA    KS  SENATE LEADERSHIP FUND
121                     ENCANA OIL & GAS INC. 2018-07-19     100,000             DENVER    CO  SENATE LEADERSHIP FUND
122                     RANDOLPH, CHRISTOPHER 2018-07-23         500             OAKTON    VA  SENATE LEADERSHIP FUND
123                           GRAY, C. BOYDEN 2018-07-24      25,000         WASHINGTON    DC  SENATE LEADERSHIP FUND
124                      PAULSON, HENRY M. JR 2018-07-25      30,000            CHICAGO    IL  SENATE LEADERSHIP FUND
125                      FOR A BETTER AMERICA 2018-07-25      40,000         WASHINGTON    DC  SENATE LEADERSHIP FUND
126                           ADELSON, MIRIAM 2018-07-26  12,500,000          LAS VEGAS    NV  SENATE LEADERSHIP FUND
127                       ADELSON, SHELDON G. 2018-07-26  12,500,000          LAS VEGAS    NV  SENATE LEADERSHIP FUND
128                            STERN, MARC I. 2018-07-27      50,000             MALIBU    CA  SENATE LEADERSHIP FUND
129                 MURRAY ENERGY CORPORATION 2018-07-30      15,000    ST. CLAIRSVILLE    OH  SENATE LEADERSHIP FUND
130                            STERN, MARC I. 2018-07-30      50,000             MALIBU    CA  SENATE LEADERSHIP FUND
131        GMS MINE REPAIR & MAINTENANCE INC. 2018-08-07      17,000       MT LAKE PARK    MD  SENATE LEADERSHIP FUND
132                          RESCHINI, JOSEPH 2018-08-07       8,400            INDIANA    PA  SENATE LEADERSHIP FUND
133                            ANDERSON, FRED 2018-08-07       2,500            RALEIGH    NC  SENATE LEADERSHIP FUND
134                        SWANSON INDUSTRIES 2018-08-07      15,000         MORGANTOWN    WV  SENATE LEADERSHIP FUND
135                 MURRAY ENERGY CORPORATION 2018-08-07      15,000    ST. CLAIRSVILLE    OH  SENATE LEADERSHIP FUND
136                 MURRAY ENERGY CORPORATION 2018-08-07      15,000    ST. CLAIRSVILLE    OH  SENATE LEADERSHIP FUND
137                        SWANSON INDUSTRIES 2018-08-07       5,000         MORGANTOWN    WV  SENATE LEADERSHIP FUND
138        GMS MINE REPAIR & MAINTENANCE INC. 2018-08-07       3,000       MT LAKE PARK    MD  SENATE LEADERSHIP FUND
139                            BROOCK, GERALD 2018-08-10         500           PORTLAND    OR  SENATE LEADERSHIP FUND
140                             BLUE, J. NEAL 2018-08-14     100,000           LA JOLLA    CA  SENATE LEADERSHIP FUND
141                        CAMERON, RONALD M. 2018-08-15     500,000  NORTH LITTLE ROCK    AR  SENATE LEADERSHIP FUND
142                            DEMARAIS, RIMA 2018-08-16          75           WESTPORT    CT  SENATE LEADERSHIP FUND
143                       KOCH INDUSTRIES INC 2018-08-20     500,000            WICHITA    KS  SENATE LEADERSHIP FUND
144                        CHAZEN, STEPHEN I. 2018-08-20     200,000           BELLAIRE    TX  SENATE LEADERSHIP FUND
145                         BUSH, CHRISTOPHER 2018-08-20         500           NEW YORK    NY  SENATE LEADERSHIP FUND
146                         ROBERTS, DUANE R. 2018-08-27      50,000      NEWPORT BEACH    CA  SENATE LEADERSHIP FUND
147                      THE RIVERSTONE GROUP 2018-08-28     100,000           RICHMOND    VA  SENATE LEADERSHIP FUND
148                         PILOT CORPORATION 2018-08-28   1,000,000          KNOXVILLE    TN  SENATE LEADERSHIP FUND
149                    THE SCOTTS COMPANY LLC 2018-08-29     100,000         MARYSVILLE    OH  SENATE LEADERSHIP FUND
150        ENTERTAINMENT SOFTWARE ASSOCIATION 2018-08-30      75,000         WASHINGTON    DC  SENATE LEADERSHIP FUND
151                               MGM RESORTS 2018-08-31     250,000          LAS VEGAS    NV  SENATE LEADERSHIP FUND
152                      OCCIDENTAL PETROLEUM 2018-08-31     200,000         WASHINGTON    DC  SENATE LEADERSHIP FUND
153                      RAI SERVICES COMPANY 2018-10-09     250,000      WINSTON SALEM    NC  SENATE LEADERSHIP FUND
154                             LYNCH, ROBERT 2018-12-07         300        FORT WRIGHT    KY  SENATE LEADERSHIP FUND

SUBTOTAL = 61,330,300

For a Specified Candidate, List All Individual Contributions

The following fuction getIndividual2Candidate1 lists all contributions made to a specific candidate and sorted by date. The following call lists the contributions to Rick Scott. As mentioned above, \$27,050,190 of the \$35,511,899 in contributions came from Scott himself but the output shows many of the other contributors.

In [87]:
def getIndividual2Candidate1(cand_name):
    jj = ii[ii['CAND_NAME'].str.contains(cand_name, na=False)]
    jj['AMOUNT'] = jj['AMT'].apply(lambda x: '{:,}'.format(x))
    jj = jj.sort_values(by='DATE',ascending=True)
    jj.index = range(1,len(jj)+1)
    kk = jj[['NAME','DATE','AMOUNT','CITY','STATE','CAND_NAME','PARTY']]
    print(kk.head(100))
    print(kk.tail(100))
    print('\nSUBTOTAL = ' + '{:,}'.format(sum(jj['AMT'])))

getIndividual2Candidate1('SCOTT, RICK')
                              NAME       DATE  AMOUNT             CITY STATE    CAND_NAME PARTY
1                      SCOTT, RICK 2018-02-05  50,613      TALLAHASSEE    FL  SCOTT, RICK   REP
2                      SCOTT, RICK 2018-03-01     457      TALLAHASSEE    FL  SCOTT, RICK   REP
3                      SCOTT, RICK 2018-03-31   5,132      TALLAHASSEE    FL  SCOTT, RICK   REP
4                      SCOTT, RICK 2018-03-31   7,500      TALLAHASSEE    FL  SCOTT, RICK   REP
5                      SCOTT, RICK 2018-03-31   2,600      TALLAHASSEE    FL  SCOTT, RICK   REP
6                 JORDAN, GERALD R 2018-04-04   2,700       PALM BEACH    FL  SCOTT, RICK   REP
7               HEUCHAN, BRECHT MR 2018-04-04   2,700      TALLAHASSEE    FL  SCOTT, RICK   REP
8      JORDAN, DARLENE L MRS OTHER 2018-04-04   2,700       PALM BEACH    FL  SCOTT, RICK   REP
9         HEUCHAN, BRECHT MR OTHER 2018-04-04   2,700      TALLAHASSEE    FL  SCOTT, RICK   REP
10           JORDAN, DARLENE L MRS 2018-04-04   2,700       PALM BEACH    FL  SCOTT, RICK   REP
11                JORDAN, GERALD R 2018-04-04   2,700       PALM BEACH    FL  SCOTT, RICK   REP
12               LOCKWOOD, FRANCES 2018-04-06   2,700       MARBLEHEAD    MA  SCOTT, RICK   REP
13              DEFOSSET, JAN S JR 2018-04-06   2,700            TAMPA    FL  SCOTT, RICK   REP
14             DEFOSSET, DON MR JR 2018-04-06   2,700            TAMPA    FL  SCOTT, RICK   REP
15               LOCKWOOD, FRANCES 2018-04-06   2,700       MARBLEHEAD    MA  SCOTT, RICK   REP
16         KARLINSKY, FRED EVAN MR 2018-04-06   2,700           WESTON    FL  SCOTT, RICK   REP
17    KARLINSKY, AUTUMN VAUGHN MRS 2018-04-06   2,700           WESTON    FL  SCOTT, RICK   REP
18           RUBENSTEIN, BETTY MRS 2018-04-06   2,700       FORT MYERS    FL  SCOTT, RICK   REP
19    KARLINSKY, AUTUMN VAUGHN MRS 2018-04-06   2,700           WESTON    FL  SCOTT, RICK   REP
20          RUBENSTEIN, JAMES H DR 2018-04-06   2,700       FORT MYERS    FL  SCOTT, RICK   REP
21             DEFOSSET, DON MR JR 2018-04-06   2,700            TAMPA    FL  SCOTT, RICK   REP
22              DEFOSSET, JAN S JR 2018-04-06   2,700            TAMPA    FL  SCOTT, RICK   REP
23             LOCKWOOD, STEPHEN J 2018-04-06   2,700       MARBLEHEAD    MA  SCOTT, RICK   REP
24         KARLINSKY, FRED EVAN MR 2018-04-06   2,700           WESTON    FL  SCOTT, RICK   REP
25             LOCKWOOD, STEPHEN J 2018-04-06   2,700       MARBLEHEAD    MA  SCOTT, RICK   REP
26            WHEELER, THOMAS B MR 2018-04-06   2,700    WEST FALMOUTH    MA  SCOTT, RICK   REP
27                     SCOTT, RICK 2018-04-08   1,496      TALLAHASSEE    FL  SCOTT, RICK   REP
28             TAPIA, DON MR OTHER 2018-04-09   2,700  PARADISE VALLEY    AZ  SCOTT, RICK   REP
29           COX, JOHN WAYNE MR JR 2018-04-09   1,500         SARASOTA    FL  SCOTT, RICK   REP
30            GARGIULO, JEFFREY MR 2018-04-09   2,700           NAPLES    FL  SCOTT, RICK   REP
31                  HOWSE, SUZETTE 2018-04-09   2,700            COCOA    FL  SCOTT, RICK   REP
32                  HOWSE, SUZETTE 2018-04-09   2,700            COCOA    FL  SCOTT, RICK   REP
33            GARGIULO, JEFFREY MR 2018-04-09   2,700           NAPLES    FL  SCOTT, RICK   REP
34            MCCULLOUGH, SAMUEL A 2018-04-09   1,000           NAPLES    FL  SCOTT, RICK   REP
35                    MEUSE, DAVID 2018-04-09   2,700         COLUMBUS    OH  SCOTT, RICK   REP
36           FOWLER, JAMES A MR JR 2018-04-09   1,500   LAKEWOOD RANCH    FL  SCOTT, RICK   REP
37      RAJGURU, ARVIND H MR OTHER 2018-04-09   2,700           VIENNA    VA  SCOTT, RICK   REP
38               GONZMART, RICHARD 2018-04-09   2,700            TAMPA    FL  SCOTT, RICK   REP
39             RAJGURU, ARVIND MRS 2018-04-09   2,700           VIENNA    VA  SCOTT, RICK   REP
40                    TOPP, MARK A 2018-04-09   2,700            DOVER    FL  SCOTT, RICK   REP
41         DECKARD, LON WHITMAN MR 2018-04-09   1,000         SARASOTA    FL  SCOTT, RICK   REP
42                     SCOTT, RICK 2018-04-09   2,417      TALLAHASSEE    FL  SCOTT, RICK   REP
43   DECKARD, LON WHITMAN MR OTHER 2018-04-09   1,500         SARASOTA    FL  SCOTT, RICK   REP
44                   PEREZ, BILL D 2018-04-09   2,700           NAPLES    FL  SCOTT, RICK   REP
45               BUTLER, GARY C MR 2018-04-09   1,500         SARASOTA    FL  SCOTT, RICK   REP
46                   TAPIA, DON MR 2018-04-09   2,700  PARADISE VALLEY    AZ  SCOTT, RICK   REP
47               GONZMART, RICHARD 2018-04-09   2,700            TAMPA    FL  SCOTT, RICK   REP
48           RIVERA, JUAN OTHER MD 2018-04-09   2,700      PUNTA GORDA    FL  SCOTT, RICK   REP
49            RAJGURU, ARVIND H MR 2018-04-09   2,700           VIENNA    VA  SCOTT, RICK   REP
50                 HOWSE, RON S MR 2018-04-09   2,700            COCOA    FL  SCOTT, RICK   REP
51                   BOYD, VALERIE 2018-04-09   2,700           NAPLES    FL  SCOTT, RICK   REP
52                PEREZ, CATHERINE 2018-04-09   2,700           NAPLES    FL  SCOTT, RICK   REP
53             KLEIN, MICHAEL H MR 2018-04-09   1,000    BEVERLY HILLS    CA  SCOTT, RICK   REP
54           EVANOFF, TERESA M MRS 2018-04-09     250         SARASOTA    FL  SCOTT, RICK   REP
55                    QUILLEN, M L 2018-04-09   1,500         SARASOTA    FL  SCOTT, RICK   REP
56                   PEREZ, BILL D 2018-04-09   2,700           NAPLES    FL  SCOTT, RICK   REP
57             DORFMAN, RICHARD MR 2018-04-09   1,500         SARASOTA    FL  SCOTT, RICK   REP
58                    MEUSE, DAVID 2018-04-09   2,700         COLUMBUS    OH  SCOTT, RICK   REP
59             SMITH, DARRELL C MR 2018-04-09   2,700           ODESSA    FL  SCOTT, RICK   REP
60                 HOWSE, RON S MR 2018-04-09   2,700            COCOA    FL  SCOTT, RICK   REP
61             RAJGURU, ARVIND MRS 2018-04-09   2,700           VIENNA    VA  SCOTT, RICK   REP
62                    KAPLAN, MARK 2018-04-09   1,000            TAMPA    FL  SCOTT, RICK   REP
63                PEREZ, CATHERINE 2018-04-09   2,700           NAPLES    FL  SCOTT, RICK   REP
64                   BOYD, VALERIE 2018-04-09   2,700           NAPLES    FL  SCOTT, RICK   REP
65               CARLSON, ALLEN MR 2018-04-09     500         SARASOTA    FL  SCOTT, RICK   REP
66                     SCOTT, RICK 2018-04-11   6,063      TALLAHASSEE    FL  SCOTT, RICK   REP
67                   WALTER, CAROL 2018-04-12   2,700           NAPLES    FL  SCOTT, RICK   REP
68               ZAISER, LEN OTHER 2018-04-12     250           NAPLES    FL  SCOTT, RICK   REP
69                  STROUD, MARVIN 2018-04-12     250      PANAMA CITY    FL  SCOTT, RICK   REP
70           CLOUDEN, PATRICK J MR 2018-04-12     500         BELLEAIR    FL  SCOTT, RICK   REP
71                   BEATON, PERRY 2018-04-12     500           NAPLES    FL  SCOTT, RICK   REP
72                  WIGGINS, DAVID 2018-04-12     250           NAPLES    FL  SCOTT, RICK   REP
73            RANGOS, JOHN G MR SR 2018-04-12   2,700       BOCA RATON    FL  SCOTT, RICK   REP
74               ALFONSO, CARLOS J 2018-04-12   1,000            TAMPA    FL  SCOTT, RICK   REP
75                     PEET, GEURT 2018-04-12   1,000      PUNTA GORDA    FL  SCOTT, RICK   REP
76                      MOGG, JEFF 2018-04-12     250           NAPLES    FL  SCOTT, RICK   REP
77                  TANGUAY, SCOTT 2018-04-12   2,700       ALYS BEACH    FL  SCOTT, RICK   REP
78                 SCHMUS, WILLIAM 2018-04-12     250        BRADENTON    FL  SCOTT, RICK   REP
79                  HARKINS, GERRY 2018-04-12   1,000        PENSACOLA    FL  SCOTT, RICK   REP
80                    WALTER, JOHN 2018-04-12   2,700           NAPLES    FL  SCOTT, RICK   REP
81               JOHNSON, ANTHYNEE 2018-04-12     250     THE VILLAGES    FL  SCOTT, RICK   REP
82                     RUSH, JACOB 2018-04-12     250      GAINESVILLE    FL  SCOTT, RICK   REP
83                  JONES, ALLEN F 2018-04-12     250      LAKE PLACID    FL  SCOTT, RICK   REP
84                    SINRUD, JOHN 2018-04-12     250     THE VILLAGES    FL  SCOTT, RICK   REP
85                  WILSON, DANIEL 2018-04-12     250            OCALA    FL  SCOTT, RICK   REP
86           PETRILLO, EDWARD J JR 2018-04-12     100         AVENTURA    FL  SCOTT, RICK   REP
87                   KNIGHT, HARRY 2018-04-12   1,000     LONGBOAT KEY    FL  SCOTT, RICK   REP
88            RANGOS, JOHN G MR SR 2018-04-12   2,700       BOCA RATON    FL  SCOTT, RICK   REP
89               FORTINO, NICHOLAS 2018-04-12     250            TAMPA    FL  SCOTT, RICK   REP
90                  ADAMS, GREGORY 2018-04-12     250           NAPLES    FL  SCOTT, RICK   REP
91                DE ANGEL, ROBERT 2018-04-12     250           HUDSON    FL  SCOTT, RICK   REP
92                      MCMANUS, S 2018-04-12     500           WESTON    MA  SCOTT, RICK   REP
93                     MOON, JASON 2018-04-12   2,700       FORT MYERS    FL  SCOTT, RICK   REP
94                      MOON, LIZY 2018-04-12   2,700       FORT MYERS    FL  SCOTT, RICK   REP
95              TRAVIESA, ANDREINA 2018-04-12   2,700            TAMPA    FL  SCOTT, RICK   REP
96                     MOON, JASON 2018-04-12   2,700       FORT MYERS    FL  SCOTT, RICK   REP
97                SHAFER, PATRICIA 2018-04-12     250          PARRISH    FL  SCOTT, RICK   REP
98              TRAVIESA, ANDREINA 2018-04-12   2,700            TAMPA    FL  SCOTT, RICK   REP
99                 KIRSTEN, REINER 2018-04-12     100      TALLAHASSEE    FL  SCOTT, RICK   REP
100               MISIURA, WILLIAM 2018-04-12     250         SARASOTA    FL  SCOTT, RICK   REP
                                     NAME       DATE   AMOUNT                CITY STATE    CAND_NAME PARTY
6528                   MULLENGER, BARBARA 2018-08-08    1,000  PALM BEACH GARDENS    FL  SCOTT, RICK   REP
6529                      FONSECA, JUAN J 2018-08-08    5,000       BISCAYNE PARK    FL  SCOTT, RICK   REP
6530                  NEWHOUSE, STEPHAN F 2018-08-08    5,400          VERO BEACH    FL  SCOTT, RICK   REP
6531                      GANJAM, RAGHU D 2018-08-08    1,000          WINDERMERE    FL  SCOTT, RICK   REP
6532             BACHSCHMIDT, FOSTER W MR 2018-08-08    2,700               OCALA    FL  SCOTT, RICK   REP
6533                         MATHEWS, DON 2018-08-08      250              OXFORD    FL  SCOTT, RICK   REP
6534             BACHSCHMIDT, FOSTER W MR 2018-08-08    2,700               OCALA    FL  SCOTT, RICK   REP
6535             CONDIE, HERBERT D MR III 2018-08-08    2,000          VERO BEACH    FL  SCOTT, RICK   REP
6536                BACHSCHMIDT, DEBORA J 2018-08-08    2,700              INGLIS    FL  SCOTT, RICK   REP
6537      MALLETTE FONSECA, KELLY COLLEEN 2018-08-08   10,000       BISCAYNE PARK    FL  SCOTT, RICK   REP
6538                      BARRON, BRUCE N 2018-08-08    2,700              NAPLES    FL  SCOTT, RICK   REP
6539                       COLQUITT, ANNE 2018-08-08    2,700           KNOXVILLE    TN  SCOTT, RICK   REP
6540            BACHSCHMIDT, WILLIAM J MR 2018-08-08    5,400              INGLIS    FL  SCOTT, RICK   REP
6541            BACHSCHMIDT, WILLIAM J MR 2018-08-08   -2,700              INGLIS    FL  SCOTT, RICK   REP
6542                      JUNE, ROHLAND A 2018-08-08    1,000          WINDERMERE    FL  SCOTT, RICK   REP
6543                  KAHLERT, HERBERT MR 2018-08-08      250     WEST PALM BEACH    FL  SCOTT, RICK   REP
6544                  PRINCE, TAMMY J MRS 2018-08-08    2,700         GAINESVILLE    FL  SCOTT, RICK   REP
6545            BACHSCHMIDT, WILLIAM J MR 2018-08-08    2,700              INGLIS    FL  SCOTT, RICK   REP
6546                  PRINCE, TAMMY J MRS 2018-08-08    2,300         GAINESVILLE    FL  SCOTT, RICK   REP
6547                 BACKA, RICHARD F, MR 2018-08-08      500    REDINGTON SHORES    FL  SCOTT, RICK   REP
6548                   COLQUITT, DAVID MR 2018-08-08    2,700           KNOXVILLE    TN  SCOTT, RICK   REP
6549                       TIEN, YIFE MR. 2018-08-08   25,000        CORAL GABLES    FL  SCOTT, RICK   REP
6550                    PITTMAN, ANDREW V 2018-08-08      500               TAMPA    FL  SCOTT, RICK   REP
6551                   BUSCH, AUGUST A MR 2018-08-08    5,400           ST PETERS    MO  SCOTT, RICK   REP
6552              COURIEL, JOHN DANIEL MR 2018-08-08   -2,700        CORAL GABLES    FL  SCOTT, RICK   REP
6553              COURIEL, JOHN DANIEL MR 2018-08-08    5,400        CORAL GABLES    FL  SCOTT, RICK   REP
6554                  SHAKHAMOORI, NAGESH 2018-08-08      700          WINDERMERE    FL  SCOTT, RICK   REP
6555                       SORBO, ALLEN J 2018-08-08      250  PALM BEACH GARDENS    FL  SCOTT, RICK   REP
6556                  DODSON, JOHN A. MR. 2018-08-08    2,500              MOBILE    AL  SCOTT, RICK   REP
6557              MERRELL, MICHELLE M MRS 2018-08-08    1,000     FORT LAUDERDALE    FL  SCOTT, RICK   REP
6558                          SCOTT, RICK 2018-08-08    5,871         TALLAHASSEE    FL  SCOTT, RICK   REP
6559                  NEWHOUSE, STEPHAN F 2018-08-08    2,700          VERO BEACH    FL  SCOTT, RICK   REP
6560                         SMITH, STEVE 2018-08-08      500              NAPLES    FL  SCOTT, RICK   REP
6561  MALLETTE FONSECA, KELLY COLLEEN MRS 2018-08-08   -5,000       BISCAYNE PARK    FL  SCOTT, RICK   REP
6562                  NEWHOUSE, STEPHAN F 2018-08-08   -2,700          VERO BEACH    FL  SCOTT, RICK   REP
6563            SCHWAB, HELEN O'NEILL MRS 2018-08-08    2,700            WOODSIDE    CA  SCOTT, RICK   REP
6564                 GROSS, DIETRICH M MR 2018-08-08    2,500            WILMETTE    IL  SCOTT, RICK   REP
6565            SCHWAB, HELEN O'NEILL MRS 2018-08-08   -2,700            WOODSIDE    CA  SCOTT, RICK   REP
6566                 VECELLIO, MICHAEL MR 2018-08-08    2,700          PALM BEACH    FL  SCOTT, RICK   REP
6567                    TOONER, LEONARD M 2018-08-08    1,000            AVENTURA    FL  SCOTT, RICK   REP
6568             THOMPSON, MICHAEL D. MR. 2018-08-08    2,500          BIRMINGHAM    AL  SCOTT, RICK   REP
6569                     PRASAD, ANANTH K 2018-08-08    1,000         TALLAHASSEE    FL  SCOTT, RICK   REP
6570                  VICKERS, DINA J MRS 2018-08-08    1,000        JACKSONVILLE    FL  SCOTT, RICK   REP
6571                  JAMES, BRUCE A. MR. 2018-08-21    1,000           LITTLETON    CO  SCOTT, RICK   REP
6572              STEVINSON, TERRY J. MR. 2018-08-21   10,000              GOLDEN    CO  SCOTT, RICK   REP
6573                          JABS, JACOB 2018-08-28    2,700           LONE TREE    CO  SCOTT, RICK   REP
6574                CHOATE, ARTHUR B. MR. 2018-09-08    4,000        CORAL GABLES    FL  SCOTT, RICK   REP
6575                      WORKMAN, ANGELA 2018-09-11   25,000          WINDERMERE    FL  SCOTT, RICK   REP
6576                   MCCORMICK, MICHAEL 2018-09-11    5,400       MIRAMAR BEACH    FL  SCOTT, RICK   REP
6577                       HOLM, ERIC MR. 2018-09-11   25,000         WINTER PARK    FL  SCOTT, RICK   REP
6578                      AGGARWAL, NITIN 2018-09-11    1,000          TITUSVILLE    FL  SCOTT, RICK   REP
6579                 HOLTON, JAMES W. MR. 2018-09-19   25,000      ST. PETERSBURG    FL  SCOTT, RICK   REP
6580                         WHEAT, LAURA 2018-09-19    2,700            WESTLAKE    TX  SCOTT, RICK   REP
6581                          WHEAT, DOUG 2018-09-19    2,700            WESTLAKE    TX  SCOTT, RICK   REP
6582                         VALECHE, HAL 2018-09-19    1,000  PALM BEACH GARDENS    FL  SCOTT, RICK   REP
6583                   ECKLER, DONALD MR. 2018-09-19    1,000            PARKLAND    FL  SCOTT, RICK   REP
6584                        PODNOS, SCOTT 2018-09-19    1,000         GULF STREAM    FL  SCOTT, RICK   REP
6585                CRISORIO, RANDALL MR. 2018-09-19    1,000      TARPON SPRINGS    FL  SCOTT, RICK   REP
6586            CRAWFORD, ANTONIA K. MRS. 2018-09-19   10,000   PONTE VEDRA BEACH    FL  SCOTT, RICK   REP
6587             COOPER, FREDERICK E. MR. 2018-09-19    5,400          VERO BEACH    FL  SCOTT, RICK   REP
6588                 LAUFER, WAYNE L. MR. 2018-09-19   25,000             SANIBEL    FL  SCOTT, RICK   REP
6589                      AGGARWAL, NITIN 2018-09-19    1,000          TITUSVILLE    FL  SCOTT, RICK   REP
6590                  PEREZ, JORGE J. MR. 2018-09-19    1,000        CORAL GABLES    FL  SCOTT, RICK   REP
6591                   BISHOP, ROBERT MR. 2018-09-19   10,000          PALM BEACH    FL  SCOTT, RICK   REP
6592                  RUST, ROBERT W. MR. 2018-09-19    2,700        CORAL GABLES    FL  SCOTT, RICK   REP
6593                   KEEN, ALLAN E. MR. 2018-09-19   25,000         WINTER PARK    FL  SCOTT, RICK   REP
6594                  SENEFF, MARTHA MRS. 2018-09-19   12,500      WINTER SPRINGS    FL  SCOTT, RICK   REP
6595               SENEFF, JIM M. MR. JR. 2018-09-19   12,500      WINTER SPRINGS    FL  SCOTT, RICK   REP
6596                 KLAWSNIK, JOHANNA P. 2018-09-22    1,000    ROYAL PALM BEACH    FL  SCOTT, RICK   REP
6597                    BEYROUTI, JAY MR. 2018-09-22    2,700  EAST REDINGTON DR.    FL  SCOTT, RICK   REP
6598               DEARDOFF, R. BRUCE MR. 2018-09-22   25,000      MERRITT ISLAND    FL  SCOTT, RICK   REP
6599              DIAMOND, WILLIAM J. MR. 2018-09-22    1,000          PALM BEACH    FL  SCOTT, RICK   REP
6600                     ZALUPSKI, NICOLE 2018-09-22    1,000     FORT LAUDERDALE    FL  SCOTT, RICK   REP
6601               YATHAM, VENKATA K. MR. 2018-09-22    4,000               MIAMI    FL  SCOTT, RICK   REP
6602                     GAINES, GAY HART 2018-09-22   25,000          PALM BEACH    FL  SCOTT, RICK   REP
6603              WILLIAMS, JOSEPH M. MR. 2018-09-22    9,000               TAMPA    FL  SCOTT, RICK   REP
6604                      JOHNSON, ROBERT 2018-09-25    5,400              MCLEAN    VA  SCOTT, RICK   REP
6605                  HENDERSON, REYNOLDS 2018-09-25    1,000      ROSEMARY BEACH    FL  SCOTT, RICK   REP
6606               YATHAM, VENKATA K. MR. 2018-09-26   15,000               MIAMI    FL  SCOTT, RICK   REP
6607                  LAISHLEY, BRUCE MR. 2018-09-26    5,000    NORTH FORT MYERS    FL  SCOTT, RICK   REP
6608                SPULAK, GARY JOHN MR. 2018-09-26    1,700       CORAL SPRINGS    FL  SCOTT, RICK   REP
6609                    KIRTLEY, JOHN MR. 2018-09-26   25,000               TAMPA    FL  SCOTT, RICK   REP
6610                    WHITE, JOE C. MR. 2018-09-26   25,000               LARGO    FL  SCOTT, RICK   REP
6611                   DODSON, THOMAS MR. 2018-09-26   25,000         PONTE VEDRA    FL  SCOTT, RICK   REP
6612                FITERRE, JORGE E. MR. 2018-09-26    5,400               MIAMI    FL  SCOTT, RICK   REP
6613                    PEPIN, TOM A. MR. 2018-09-26   10,000               TAMPA    FL  SCOTT, RICK   REP
6614               FERBER, ALISON SHIELDS 2018-09-26    5,400         OCEAN RIDGE    FL  SCOTT, RICK   REP
6615                 SPULAK, MARY E. MRS. 2018-09-26    1,000       CORAL SPRINGS    FL  SCOTT, RICK   REP
6616          MCGILLICUDDY, DENNIS J. MR. 2018-09-26   25,000            SARASOTA    FL  SCOTT, RICK   REP
6617                       FITERRE, ISELA 2018-09-27    2,700               MIAMI    FL  SCOTT, RICK   REP
6618                       JOHNSON, JOYCE 2018-09-27    2,700              MCLEAN    VA  SCOTT, RICK   REP
6619                        WHITE, JO ANN 2018-09-27   12,500               LARGO    FL  SCOTT, RICK   REP
6620                    WHITE, JOE C. MR. 2018-09-27  -12,500               LARGO    FL  SCOTT, RICK   REP
6621          MCGILLICUDDY, DENNIS J. MR. 2018-09-27  -12,500            SARASOTA    FL  SCOTT, RICK   REP
6622             MCGILLICUDDY, GRACI MRS. 2018-09-27   12,500            SARASOTA    FL  SCOTT, RICK   REP
6623                  BISHOP, ROBERT MRS. 2018-09-27    5,000          PALM BEACH    FL  SCOTT, RICK   REP
6624                   BISHOP, ROBERT MR. 2018-09-27   -5,000          PALM BEACH    FL  SCOTT, RICK   REP
6625                      JOHNSON, ROBERT 2018-09-27   -2,700              MCLEAN    VA  SCOTT, RICK   REP
6626                FITERRE, JORGE E. MR. 2018-09-27   -2,700               MIAMI    FL  SCOTT, RICK   REP
6627                          SCOTT, RICK 2018-10-01   31,000         TALLAHASSEE    FL  SCOTT, RICK   REP

SUBTOTAL = 35,511,899
C:\Users\bdavi\Anaconda3\lib\site-packages\ipykernel_launcher.py:3: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
  This is separate from the ipykernel package so we can avoid doing imports until

List All Individual Contributions above a Specific Amount

The following fuction getAllFromDate lists all contributions more than a specific amount and made after a specific date. The following call lists all contributions of \$500,000 or more.

In [88]:
from datetime import datetime
#import pandas as pd
#pd.options.display.max_colwidth = 99

def getCandidateFromDate(date, minamt):
    #jj = ii[ii['NAME'].str.contains(name, na=False)]
    #if pd.notnull(city): jj = jj[jj['CITY'].str.contains(city, na=False)]
    #if pd.notnull(state): jj = jj[jj['STATE'].str.contains(state, na=False)]
    jj = ii[ii['AMT'] >= minamt]
    jj = jj[jj['DATE'] < datetime.now()]
    jj = jj[pd.notnull(jj['CAND_ID'])]
    jj['AMOUNT'] = jj['AMT'].apply(lambda x: '{:,}'.format(x))
    jj = jj.sort_values(by='DATE',ascending=True)
    jj.index = range(1,len(jj)+1)
    kk = jj[['NAME','DATE','AMOUNT','CITY','STATE','CAND_NAME','PARTY']]
    print(kk.tail(100))
    print('\nSUBTOTAL = ' + '{:,}'.format(sum(jj['AMT'])))

def getCommitteeFromDate(date, minamt):
    #jj = ii[ii['NAME'].str.contains(name, na=False)]
    #if pd.notnull(city): jj = jj[jj['CITY'].str.contains(city, na=False)]
    #if pd.notnull(state): jj = jj[jj['STATE'].str.contains(state, na=False)]
    jj = ii[ii['AMT'] >= minamt]
    jj = jj[jj['DATE'] < datetime.now()]
    jj = jj[pd.isnull(jj['CAND_ID'])]
    jj['AMOUNT'] = jj['AMT'].apply(lambda x: '{:,}'.format(x))
    jj = jj.sort_values(by='DATE',ascending=True)
    jj.index = range(1,len(jj)+1)
    kk = jj[['NAME','DATE','AMOUNT','CITY','STATE','CMTE_NM']]
    kk['NAME'] = kk['NAME'].str[0:35]
    kk['CMTE_NM'] = kk['CMTE_NM'].str[0:35]
    print(kk.tail(100))
    print('\nSUBTOTAL = ' + '{:,}'.format(sum(jj['AMT'])))

def getAllFromDate(date, minamt):
    getCandidateFromDate(date, minamt)
    getCommitteeFromDate(date, minamt)

getAllFromDate(None, 500000)
                             NAME       DATE     AMOUNT            CITY STATE              CAND_NAME PARTY
1   FLINN, GEORGE S DR JR S JR DR 2017-03-22  2,450,000         MEMPHIS    TN  FLINN, GEORGE S DR JR   REP
2               BARTOS, JEFFREY A 2017-06-21    500,000  MERION STATION    PA      BARTOS, JEFFREY A   REP
3                      MOODY, DAN 2017-09-30  2,803,120         ROSWELL    GA             MOODY, DAN   REP
4          BROWN, SHAUN DENISE MS 2017-09-30    674,157  VIRGINIA BEACH    VA    BROWN, SHAUN DENISE   DEM
5                    TRONE, DAVID 2017-10-01    573,939        BETHESDA    MD           TRONE, DAVID   DEM
6                    LYNCH, HOLLY 2017-10-13    500,000        NEW YORK    NY           LYNCH, HOLLY   DEM
7                    TRONE, DAVID 2017-11-13    500,000        BETHESDA    MD           TRONE, DAVID   DEM
8                    JACOBS, SARA 2017-12-22  1,000,000         DEL MAR    CA           JACOBS, SARA   DEM
9                    LYNCH, HOLLY 2017-12-29    500,000        NEW YORK    NY           LYNCH, HOLLY   DEM
10                WALL, KATHALEEN 2017-12-29  2,500,000         HOUSTON    TX   WALL, KATHALEEN MRS.   REP
11                WALL, KATHALEEN 2018-01-30    800,000         HOUSTON    TX   WALL, KATHALEEN MRS.   REP
12                WALL, KATHALEEN 2018-01-31  1,300,000         HOUSTON    TX   WALL, KATHALEEN MRS.   REP
13            AYYADURAI, SHIVA DR 2018-02-21    989,400       CAMBRIDGE    MA   AYYADURAI, SHIVA  DR   IND
14            AYYADURAI, SHIVA DR 2018-02-21  1,484,100       CAMBRIDGE    MA   AYYADURAI, SHIVA  DR   IND
15                   TRONE, DAVID 2018-02-28  1,000,000        BETHESDA    MD           TRONE, DAVID   DEM
16                  KERR, PAUL G. 2018-03-08    500,000       SAN DIEGO    CA             KERR, PAUL   DEM
17                   TRONE, DAVID 2018-03-19  2,000,000        BETHESDA    MD           TRONE, DAVID   DEM
18                  KERR, PAUL G. 2018-04-02    500,000       SAN DIEGO    CA             KERR, PAUL   DEM
19                    SCOTT, RICK 2018-04-12  2,500,000     TALLAHASSEE    FL            SCOTT, RICK   REP
20                  KERR, PAUL G. 2018-04-16    500,000       SAN DIEGO    CA             KERR, PAUL   DEM
21         KIEHL FRIEDMAN, ALISON 2018-04-19  1,000,000          MCLEAN    VA       FRIEDMAN, ALISON   DEM
22                   TRONE, DAVID 2018-04-23  2,000,000        BETHESDA    MD           TRONE, DAVID   DEM
23                  KERR, PAUL G. 2018-04-26    500,000       SAN DIEGO    CA             KERR, PAUL   DEM
24                    SCOTT, RICK 2018-04-26  3,000,000     TALLAHASSEE    FL            SCOTT, RICK   REP
25                  KERR, PAUL G. 2018-05-04    500,000       SAN DIEGO    CA             KERR, PAUL   DEM
26                   JACOBS, SARA 2018-05-08    500,000         DEL MAR    CA           JACOBS, SARA   DEM
27                    SCOTT, RICK 2018-05-11  3,000,000     TALLAHASSEE    FL            SCOTT, RICK   REP
28                   TRONE, DAVID 2018-05-18  1,000,000        BETHESDA    MD           TRONE, DAVID   DEM
29                   JACOBS, SARA 2018-05-21    500,000         DEL MAR    CA           JACOBS, SARA   DEM
30                   TRONE, DAVID 2018-05-24  2,000,000        BETHESDA    MD           TRONE, DAVID   DEM
31                    SCOTT, RICK 2018-05-25  1,500,000     TALLAHASSEE    FL            SCOTT, RICK   REP
32                    SCOTT, RICK 2018-06-08  1,500,000     TALLAHASSEE    FL            SCOTT, RICK   REP
33                   TRONE, DAVID 2018-06-13    950,000        BETHESDA    MD           TRONE, DAVID   DEM
34                    SCOTT, RICK 2018-06-21  2,000,000     TALLAHASSEE    FL            SCOTT, RICK   REP
35      FEINSTEIN, SENATOR DIANNE 2018-06-27  1,750,000      WASHINGTON    DC      FEINSTEIN, DIANNE   DEM
36             FEINSTEIN, SENATOR 2018-06-27  1,750,000      WASHINGTON    DC      FEINSTEIN, DIANNE   DEM
37                SCOTT, RICK GOV 2018-07-20  1,000,000     TALLAHASSEE    FL            SCOTT, RICK   REP
38                SCOTT, RICK GOV 2018-07-20  1,000,000     TALLAHASSEE    FL            SCOTT, RICK   REP
39                SCOTT, RICK GOV 2018-07-30  4,000,000     TALLAHASSEE    FL            SCOTT, RICK   REP
40                    SCOTT, RICK 2018-07-30  4,000,000     TALLAHASSEE    FL            SCOTT, RICK   REP
41                SCOTT, RICK GOV 2018-08-06  1,500,000     TALLAHASSEE    FL            SCOTT, RICK   REP
42                    SCOTT, RICK 2018-08-06  1,500,000     TALLAHASSEE    FL            SCOTT, RICK   REP
43                MAURO, EDDIE J. 2018-09-28    515,000      DES MOINES    IA        MAURO, EDDIE J.   DEM

SUBTOTAL = 60,539,716
                                    NAME       DATE      AMOUNT               CITY STATE                              CMTE_NM
255            MICHIGAN REPUBLICAN PARTY 2018-06-29     800,000            LANSING    MI              RGA RIGHT DIRECTION PAC
256                       MORIARTY, MARY 2018-06-29     500,000           CHATHAMP    NJ                         INTEGRITY NJ
257                   SIMONS, MARILYN H. 2018-06-29     500,000           NEW YORK    NY                          WIN JUSTICE
258             MERCER, ROBERT AND DIANA 2018-06-29     500,000      EAST SETAUKET    NY                             KELLIPAC
259                      TIERNEY, DANIEL 2018-06-29     666,666            CHICAGO    IL          MOVEON.ORG POLITICAL ACTION
260              AMERICAN ACTION NETWORK 2018-06-30     615,833         WASHINGTON    DC        CONGRESSIONAL LEADERSHIP FUND
261                  HENDRICKS, DIANE M. 2018-07-05     500,000             BELOIT    WI                   WISCONSIN NEXT PAC
262                                  SMP 2018-07-06   1,500,000         WASHINGTON    DC          MOVEON.ORG POLITICAL ACTION
263                     JURVETSON, KARLA 2018-07-10   1,003,869          LOS ALTOS    CA                                  SMP
264                  UIHLEIN, RICHARD E. 2018-07-11     900,000        LAKE FOREST    IL                      RESTORATION PAC
265               SOROS COLOMBEL, ANDREA 2018-07-11   1,000,000          SCARSDALE    NY             PLANNED PARENTHOOD VOTES
266              GRIFFIN, KENNETH C. MR. 2018-07-12   1,500,000            CHICAGO    IL        CONGRESSIONAL LEADERSHIP FUND
267     REPUBLICAN GOVERNORS ASSOCIATION 2018-07-16     610,000         WASHINGTON    DC              RGA RIGHT DIRECTION PAC
268                     SIMONS, JAMES H. 2018-07-17   1,700,000           NEW YORK    NY                   HOUSE MAJORITY PAC
269                   ROSENTHAL, RICHARD 2018-07-17   1,000,000         CINCINNATI    OH             PLANNED PARENTHOOD VOTES
270              AMERICAN ACTION NETWORK 2018-07-18   1,300,000         WASHINGTON    DC        CONGRESSIONAL LEADERSHIP FUND
271                  KOCH INDUSTRIES INC 2018-07-18     500,000            WICHITA    KS               SENATE LEADERSHIP FUND
272                       SIMON, DEBORAH 2018-07-19     500,000             CARMEL    IN         AMERICAN BRIDGE 21ST CENTURY
273                  UIHLEIN, RICHARD E. 2018-07-23     500,000        LAKE FOREST    IL                  WOMEN SPEAK OUT PAC
274                  HENDRICKS, DIANE M. 2018-07-23     500,000             BELOIT    WI                   WISCONSIN NEXT PAC
275                      JACOBS, JOAN K. 2018-07-24     500,000           LA JOLLA    CA                                  SMP
276                     JACOBS, IRWIN M. 2018-07-24     500,000           LA JOLLA    CA                                  SMP
277  GREATER NEW YORK HOSPITAL ASSOCIATI 2018-07-25   1,000,000           NEW YORK    NY                                  SMP
278     REPUBLICAN GOVERNORS ASSOCIATION 2018-07-26   2,500,000         WASHINGTON    DC              RGA RIGHT DIRECTION PAC
279                      ADELSON, MIRIAM 2018-07-26  12,500,000          LAS VEGAS    NV               SENATE LEADERSHIP FUND
280                  ADELSON, SHELDON G. 2018-07-26  12,500,000          LAS VEGAS    NV               SENATE LEADERSHIP FUND
281                      SUSSMAN, DONALD 2018-07-26   2,000,000          RYE BROOK    NY                PRIORITIES USA ACTION
282                 KOCH INDUSTRIES INC. 2018-07-26     500,000            WICHITA    KS        CONGRESSIONAL LEADERSHIP FUND
283                    SIMON, DEBORAH J. 2018-07-27     500,000             CARMEL    IN                                  SMP
284                         CHC BOLD PAC 2018-07-27     500,000         WASHINGTON    DC                  LATINO VICTORY FUND
285                         BEAL, ANDREW 2018-07-27   1,000,000              PLANO    TX           AMERICA FIRST ACTION, INC.
286    NATIONAL ASSOCIATION OF REALTO, . 2018-07-30   1,000,000            CHICAGO    IL  NATIONAL ASSOCIATION OF REALTORS CO
287                    COLLECTIVE FUTURE 2018-07-30     505,372         WASHINGTON    DC             THE COLLECTIVE SUPER PAC
288                 STATE VICTORY ACTION 2018-07-31     600,000         WASHINGTON    DC                       FOR OUR FUTURE
289  LABORERS' POLITICAL LEAGUE GREAT LA 2018-07-31     500,000            CHICAGO    IL               LIUNA BUILDING AMERICA
290                     HOFFMAN, REID G. 2018-08-01   3,053,000     PORTOLA VALLEY    CA                   HOUSE MAJORITY PAC
291                     GRANTHAM, ROBERT 2018-08-01     750,000             BOSTON    MA                     LCV VICTORY FUND
292                    STEYER, THOMAS F. 2018-08-02  12,078,850      SAN FRANCISCO    CA     NEXTGEN CLIMATE ACTION COMMITTEE
293                     SCHULER, STEPHEN 2018-08-02     500,000           OAK PARK    IL                                  SMP
294                          BEZOS, JEFF 2018-08-02  10,129,170            SEATTLE    WA                WITH HONOR FUND, INC.
295                      MARCUS, BERNARD 2018-08-03     500,000            ATLANTA    GA                   NEW REPUBLICAN PAC
296                     UIHLEIN, RICHARD 2018-08-07     900,000        LAKE FOREST    IN              SOLUTIONS FOR WISCONSIN
297                   ABRAHAM, S. DANIEL 2018-08-07   1,000,000    WEST PALM BEACH    FL                   HOUSE MAJORITY PAC
298              DUKE ENERGY CORPORATION 2018-08-07     501,053          CHARLOTTE    NC  COMMITTEE FOR CHARLOTTE/CHARLOTTE D
299     REPUBLICAN GOVERNORS ASSOCIATION 2018-08-07     500,000         WASHINGTON    DC              RGA RIGHT DIRECTION PAC
300                  SANDLER, HERBERT M. 2018-08-07     500,000      SAN FRANCISCO    CA                                  SMP
301                       EYCHANER, FRED 2018-08-13   2,000,000            CHICAGO    IL                                  SMP
302  UNITED BROTHERHOOD OF CARPENTERS AN 2018-08-13     902,354         WASHINGTON    DC  WORKING FOR WORKING AMERICANS - FED
303  AMERICAN FEDERATION OF STATE, COUNT 2018-08-13     500,000         WASHINGTON    DC                                  SMP
304                   TIERNEY, DANIEL V. 2018-08-13     566,666            CHICAGO    IL                   HOUSE MAJORITY PAC
305                        SIMONS, JAMES 2018-08-14     500,000           NEW YORK    NY                         RED AND GOLD
306                   AFT SOLIDARITY 527 2018-08-15     500,000         WASHINGTON    DC                   HOUSE MAJORITY PAC
307                   CAMERON, RONALD M. 2018-08-15     500,000  NORTH LITTLE ROCK    AR               SENATE LEADERSHIP FUND
308                     HEISING, MARK W. 2018-08-15     500,000           ATHERTON    CA                   HOUSE MAJORITY PAC
309  LABORERS' POLITICAL LEAGUE EDUCATIO 2018-08-15   1,000,000         WASHINGTON    DC               LIUNA BUILDING AMERICA
310                   BLOOMBERG, MICHAEL 2018-08-16   2,000,000           NEW YORK    NY                     LCV VICTORY FUND
311                   BLOOMBERG, MICHAEL 2018-08-16   1,500,000           NEW YORK    NY                          WOMEN VOTE!
312                       EYCHANER, FRED 2018-08-16   2,000,000            CHICAGO    IL                   HOUSE MAJORITY PAC
313                          FAISON, JAY 2018-08-17     500,000          CHARLOTTE    NC               CLEARPATH ACTION, INC.
314                       EYCHANER, FRED 2018-08-17   2,000,000            CHICAGO    IL                                  SMP
315               SCHWARZMAN, STEPHEN A. 2018-08-17   2,250,000           NEW YORK    NY        CONGRESSIONAL LEADERSHIP FUND
316                   CAMERON, RONALD M. 2018-08-18     500,000        LITTLE ROCK    AR               CLUB FOR GROWTH ACTION
317                  KOCH INDUSTRIES INC 2018-08-20     500,000            WICHITA    KS               SENATE LEADERSHIP FUND
318                          MAHER, BILL 2018-08-20   1,000,000        LOS ANGELES    CA                                  SMP
319                           YASS, JEFF 2018-08-22     500,000        BALA CYNWYD    PA               CLUB FOR GROWTH ACTION
320                 KOCH INDUSTRIES INC. 2018-08-23     500,000            WICHITA    KS        CONGRESSIONAL LEADERSHIP FUND
321                   SANDLER, HERBERT M 2018-08-24     600,000      SAN FRANCISCO    CA                         POWERPACPLUS
322                       MARCUS, GEORGE 2018-08-27   1,000,000          PALO ALTO    CA                                  SMP
323                        KLARMAN, SETH 2018-08-28   2,000,000             BOSTON    MA                   HOUSE MAJORITY PAC
324                    PILOT CORPORATION 2018-08-28   1,000,000          KNOXVILLE    TN               SENATE LEADERSHIP FUND
325                           YASS, JEFF 2018-08-28   1,000,000        BALA CYNWYD    PA               CLUB FOR GROWTH ACTION
326                        KLARMAN, SETH 2018-08-28   1,000,000             BOSTON    MA                                  SMP
327                    SIMONS, ELIZABETH 2018-08-29     500,000           ATHERTON    CA                   HOUSE MAJORITY PAC
328                SIMON-SKJODT, CYNTHIA 2018-08-29     500,000             CARMEL    IN                                  SMP
329                        SOROS, GEORGE 2018-08-30   1,400,000           NEW YORK    NY                                  SMP
330                        SOROS, GEORGE 2018-08-30     600,000           NEW YORK    NY                         RED AND GOLD
331                          BURKLE, RON 2018-08-31     500,000     WEST HOLLYWOOD    CA                                  SMP
332                BLOOMBERG, MICHAEL R. 2018-08-31   1,184,200           NEW YORK    NY                 INDEPENDENCE USA PAC
333    NATIONAL ASSOCIATION OF REALTO, . 2018-08-31   9,401,487            CHICAGO    IL  NATIONAL ASSOCIATION OF REALTORS CO
334                            DUNN, TIM 2018-09-04   1,000,000            MIDLAND    TX                   SENATE REFORM FUND
335            MICHIGAN REPUBLICAN PARTY 2018-09-06     750,000            LANSING    MI              RGA RIGHT DIRECTION PAC
336                        KLARMAN, SETH 2018-09-11     500,000             BOSTON    MA             AMERICAN VALUES PAC INC.
337                         BEAL, ANDREW 2018-09-11   1,000,000              PLANO    TX           AMERICA FIRST ACTION, INC.
338         FREEDOM PARTNERS ACTION FUND 2018-09-11   5,000,000          ARLINGTON    VA  AMERICANS FOR PROSPERITY ACTION, IN
339                  HENDRICKS, DIANE M. 2018-09-12     500,000             BELOIT    WI                   WISCONSIN NEXT PAC
340                      CAMERON, RONALD 2018-09-13   1,000,000        LITTLE ROCK    AR  AMERICANS FOR PROSPERITY ACTION, IN
341                  ADELSON, MIRIAM DR. 2018-09-13   5,000,000          LAS VEGAS    NV           AMERICA FIRST ACTION, INC.
342                   ADELSON, SHELDON G 2018-09-13   5,000,000          LAS VEGAS    NV           AMERICA FIRST ACTION, INC.
343     REPUBLICAN GOVERNORS ASSOCIATION 2018-09-13   1,500,000         WASHINGTON    DC              RGA RIGHT DIRECTION PAC
344                    MOSKOWITZ, CHERNA 2018-09-13   1,000,000        MIAMI BEACH    FL           AMERICA FIRST ACTION, INC.
345    REPUBLICAN GOVERNOR'S ASSOCIATION 2018-09-13     500,000         WASHINGTON    DC  SECURING OHIO'S FUTURE ACTION FUND,
346                       CENTER FORWARD 2018-09-21     930,000         WASHINGTON    DC             CENTER FORWARD COMMITTEE
347                         STONE, ROGER 2018-09-24     500,000         NORTHBROOK    IL  AMERICANS FOR PROSPERITY ACTION, IN
348  LABORERS' POLITICAL LEAGUE EDUCATIO 2018-09-24     500,000         WASHINGTON    DC               LIUNA BUILDING AMERICA
349  SEIU CALIFORNIA STATE COUNCIL POLIT 2018-09-26   1,250,000         SACRAMENTO    CA  PROTECT OUR KIDS AND OUR HEALTHCARE
350                        LAUFER, WAYNE 2018-09-26     500,000            SANIBEL    FL  AMERICANS FOR PROSPERITY ACTION, IN
351                     LAUDER, RONALD S 2018-09-27   1,500,000           NEW YORK    NY                     NATIONAL HORIZON
352                  HENDRICKS, DIANE M. 2018-09-28     500,000             BELOIT    WI                   WISCONSIN NEXT PAC
353     REPUBLICAN GOVERNORS ASSOCIATION 2018-09-28     500,000         WASHINGTON    DC              RGA RIGHT DIRECTION PAC
354                     SIMONS, JAMES H. 2018-10-02   1,500,000           NEW YORK    NY                                  SMP

SUBTOTAL = 497,727,785
C:\Users\bdavi\Anaconda3\lib\site-packages\ipykernel_launcher.py:30: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy
C:\Users\bdavi\Anaconda3\lib\site-packages\ipykernel_launcher.py:31: SettingWithCopyWarning: 
A value is trying to be set on a copy of a slice from a DataFrame.
Try using .loc[row_indexer,col_indexer] = value instead

See the caveats in the documentation: http://pandas.pydata.org/pandas-docs/stable/indexing.html#indexing-view-versus-copy

List All Contributions from the Koch Brothers

The following calls simply attempt to list all of the contributions connected with the Koch brothers, Charles and David. As can be seen, \$3,308,900 is connected to Charles Koch, \$109,772 is connected to David Koch, and \$2,335,000 is connected to Koch Industries. This adds up to \$5,753,672 a relatively small amount compared to the other top contributors. However, this does not include any "dark money" which is not disclosed to the FEC for any of the contributors.

In [89]:
getIndividual2All('KOCH, CHARLES', None, 'KS')
getIndividual2All('KOCH, DAVID ', None, 'NY')
getIndividual2All('KOCH INDUSTRIES', None, '')
getIndividual2All('CHARLES G. KOCH', None, '')
                   NAME       DATE   AMOUNT     CITY STATE               CAND_NAME PARTY
1       KOCH, CHARLES G 2017-06-30    2,700  WICHITA    KS          HATCH, ORRIN G   REP
2       KOCH, CHARLES G 2017-06-30    2,700  WICHITA    KS          HATCH, ORRIN G   REP
3         KOCH, CHARLES 2017-11-27    2,700  WICHITA    KS  BLACKBURN, MARSHA MRS.   REP
4  KOCH, CHARLES G. MR. 2017-11-29  247,700  WICHITA    KS           RYAN, PAUL D.   REP
5      KOCH, CHARLES MR 2017-12-01    2,700  WICHITA    KS        BARRASSO, JOHN A   REP
6      KOCH, CHARLES MR 2017-12-01    2,700  WICHITA    KS    MORRISEY, PATRICK MR   REP
7       KOCH, CHARLES G 2018-02-26    2,700  WICHITA    KS          HATCH, ORRIN G   REP
8  KOCH, CHARLES G. MR. 2018-05-07    2,700  WICHITA    KS           RYAN, PAUL D.   REP

SUBTOTAL = 266,600
                 NAME       DATE   AMOUNT     CITY STATE                                            CMTE_NM
1       KOCH, CHARLES 2017-06-30    5,000  WICHITA    KS  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
2     KOCH, CHARLES G 2017-06-30   33,900  WICHITA    KS                                               NRSC
3  KOCH, CHARLES G MR 2017-06-30  101,700  WICHITA    KS                                               NRSC
4  KOCH, CHARLES G MR 2017-06-30  101,700  WICHITA    KS                                               NRSC

SUBTOTAL = 242,300
             NAME       DATE   AMOUNT      CITY STATE       CAND_NAME PARTY
1  KOCH, DAVID H. 2017-04-13  100,000  NEW YORK    NY  HATCH, ORRIN G   REP
2   KOCH, DAVID H 2018-02-26    2,700  NEW YORK    NY  HATCH, ORRIN G   REP

SUBTOTAL = 102,700
             NAME       DATE AMOUNT      CITY STATE                                            CMTE_NM
1   KOCH, DAVID H 2017-01-31    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
2   KOCH, DAVID H 2017-02-15    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
3   KOCH, DAVID H 2017-02-28    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
4   KOCH, DAVID H 2017-03-15    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
5   KOCH, DAVID H 2017-03-31    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
6   KOCH, DAVID H 2017-04-14    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
7   KOCH, DAVID H 2017-04-28    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
8   KOCH, DAVID H 2017-05-15    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
9   KOCH, DAVID H 2017-05-31    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
10  KOCH, DAVID H 2017-06-15    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
11  KOCH, DAVID H 2017-06-30    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
12  KOCH, DAVID H 2017-07-14    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
13  KOCH, DAVID H 2017-07-31    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
14  KOCH, DAVID H 2017-08-15    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
15  KOCH, DAVID H 2017-08-31    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
16  KOCH, DAVID H 2017-09-15    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
17  KOCH, DAVID H 2017-09-29    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
18  KOCH, DAVID H 2017-10-13    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
19  KOCH, DAVID H 2017-10-31    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
20  KOCH, DAVID H 2017-11-03    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
21  KOCH, DAVID H 2017-11-15    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
22  KOCH, DAVID H 2017-11-30    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
23  KOCH, DAVID H 2017-12-15    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
24  KOCH, DAVID H 2017-12-29    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
25  KOCH, DAVID H 2018-01-31    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
26  KOCH, DAVID H 2018-02-15    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
27  KOCH, DAVID H 2018-02-28    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
28  KOCH, DAVID H 2018-03-15    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
29  KOCH, DAVID H 2018-03-30    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
30  KOCH, DAVID H 2018-04-13    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
31  KOCH, DAVID H 2018-04-30    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
32  KOCH, DAVID H 2018-05-15    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
33  KOCH, DAVID H 2018-05-31    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...
34  KOCH, DAVID H 2018-11-02    208  NEW YORK    NY  KOCH INDUSTRIES, INC. POLITICAL ACTION COMMITT...

SUBTOTAL = 7,072
Empty DataFrame
Columns: [NAME, DATE, AMOUNT, CITY, STATE, CAND_NAME, PARTY]
Index: []

SUBTOTAL = 0
                     NAME       DATE   AMOUNT     CITY STATE                            CMTE_NM
1   KOCH INDUSTRIES, INC. 2017-06-30   10,000  WICHITA    KS                         35TH, INC.
2     KOCH INDUSTRIES INC 2017-09-18  100,000  WICHITA    KS             SENATE LEADERSHIP FUND
3    KOCH INDUSTRIES INC. 2018-03-29   50,000  WICHITA    KS                         35TH, INC.
4    KOCH INDUSTRIES INC. 2018-05-03   25,000  WICHITA    KS                         35TH, INC.
5    KOCH INDUSTRIES INC. 2018-06-29   50,000  WICHITA    KS                         35TH, INC.
6    KOCH INDUSTRIES INC. 2018-06-30   50,000  WICHITA    KS  TENNESSEANS FOR A BETTER TOMORROW
7         KOCH INDUSTRIES 2018-07-13   25,000  WICHITA    KS     NEW PROSPERITY FOUNDATION; THE
8     KOCH INDUSTRIES INC 2018-07-18  500,000  WICHITA    KS             SENATE LEADERSHIP FUND
9    KOCH INDUSTRIES INC. 2018-07-26  500,000  WICHITA    KS      CONGRESSIONAL LEADERSHIP FUND
10    KOCH INDUSTRIES INC 2018-08-20  500,000  WICHITA    KS             SENATE LEADERSHIP FUND
11   KOCH INDUSTRIES INC. 2018-08-23  500,000  WICHITA    KS      CONGRESSIONAL LEADERSHIP FUND
12        KOCH INDUSTRIES 2018-09-06   25,000  WICHITA    KS     NEW PROSPERITY FOUNDATION; THE

SUBTOTAL = 2,335,000
Empty DataFrame
Columns: [NAME, DATE, AMOUNT, CITY, STATE, CAND_NAME, PARTY]
Index: []

SUBTOTAL = 0
                         NAME       DATE     AMOUNT     CITY STATE                             CMTE_NM
1  CHARLES G. KOCH 1997 TRUST 2017-09-06  3,000,000  WICHITA    KS  FREEDOM PARTNERS ACTION FUND, INC.

SUBTOTAL = 3,000,000

Note: The Jupyter Notebook from which this post is generated can be found at http://econdataus.com/camfin181029.ipynb. It is based on bulk data downloaded from the FEC website on 10/29/2018. Links to additional Jupyter Notebooks can be found at http://econdataus.com/jupyter.html.