I need data on the campaign contributions from United States ambassadorial nominees. These are recorded in the Congressional Record as part of the Executive Reports of the Committee on Foreign Relations. The attached spreadsheet includes the names of about 1587 ambassadorial nominees, and I need the donor (either self or spouse—but not any of the others included, which can be parents, children, or siblings), amount, and recipient for each contribution reported at the time of their nomination. Thus each row should have the following columns:
1. S. No
2. Nomination
3. Date Received
4. Nominee (this includes the country to which they were assigned)
5. Self-contribution1
6. Self-date1
7. Self-recipient1
8. Self-contribution2
9. Self-date2
10. Self-recipient2
…
Spouse-contribution1
Spouse-date1
Spouse-recipient1
…
An example is located here after searching for Andrew H Schapiro (S. No 13), using the full text of the cell and searching in Congressional Record (not “All Legislation”):
[login to view URL]
Relevant section is below, with each column needing to be separated using the commas and semi-colons as delimiters.
Contributions, amount, date, and donee:
1. Self: $1,000, 1/15/10, Martha Coakley for Senate Cmte;
$2,000, 1/29/10, (Michael) Bennet for Colorado; $500, 2/25/
10, Gillibrand for Senate; $250, 5/5/10, Mark Critz for
Congress Cmte; $250, 6/7/10, Bill Foster for Congress;
$2,400, 6/30/10, Alexi (Giannoulias) for Illinois; $250, 8/4/
10, (Michael) Bennet for Colorado; $15,000, 8/4/10, DNC
Services Corporation; $500, 9/20/10, (Tom) Perriello for
Congress; $2,400, 9/21/10, Alexi (Giannoulias) for Illinois;
$500, 10/19/10, Friends for Harry Reid; $500, 10/19/10, Chris
Coons for Delaware; $1,000, 3/30/11, Friends for (John)
Atkinson; $5,000, 4/13/11, Obama Victory Fund 2012; $1,500,
5/18/11, (Tim) Kaine for Virginia; $1,000, 6/30/11, Obama
Victory Fund 2012; $1,000, 9/1/11, (Tim) Kaine for Virginia;
$5,000, 9/19/11, Obama Victory Fund 2012; $10,000, 12/13/11,
Obama Victory Fund 2012; $750, 2/28/12, McCaskill for
Missouri; $10,000, 3/6/12, Obama Victory Fund 2012; $10,000,
3/19/12, Obama Victory Fund 2012; $2,500, 4/16/12, Elizabeth
(Warren) for MA; $1,000, 5/14/12, Tammy Baldwin for Senate;
$10,000, 6/14/12, Obama Victory Fund 2012; $5,000, 7/31/12,
Obama Victory Fund 2012; $500, 8/2/12, (Kathryn) Boockvar for
Congress; $2,500, 917/12, Obama Victory Fund 2012; $2,500, 9/
11/12, Obama Victory Fund 2012; $1,000, 10/10/12, Obama
Victory Fund 2012; $250, 10/29/12, (Shelly) Berkley for
Senate; $1,000, 3/15/13, Cory Booker for Senate; $1,000, 4/
15/13, Chris Coons for Delaware.
2. Spouse: Tamar S. Newberger: $250, 6/8/10, Melissa Bean
for Congress; $2,400, 6/30/10, Alexi (Giannoulias) for
Illinois; $2,400, 10/11/10, Alexi (Giannoulias) for Illinois;
$250, 6/8/12, Friends of David Gill; $10,000, 8/7/12, Obama
Victory Fund 2012; $250, -6/30/13, (Brad) Schneider for
Congress; $1,000, 7/10/13, (Jan) Schakowsky for Congress;
$10,000, 9/9/13, DNC Services Corporation.