Campaign contributions data

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.