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




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”):

[url removed, login to view]

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.

Evner: Dataindførsel, Datasøgning, Python, Web Skrabning

Se mere: web scraping part time, web relations, n. c. h. corporation, michael bean, melissa gill, harry & david, harry and david, executive on the web, david tom, david chris, chris bennet, tom warren, michael david, mark gill, david data, chris warren, shelly, Schneider, obama, Melissa

Om arbejdsgiveren:
( 2 bedømmelser ) Nashville, United States

Projekt ID: #6048793

Tildelt til:


Data Mining Sample Work --- [login to view URL] Dear Buyer Greeting from Dream Media Solutions. Thank you very much for giving us an opportunity to bid for your project. I am gua Flere

$180 USD in 3 dage
(43 bedømmelser)

10 freelancere byder i gennemsnit $171 på dette job


Hello Sir, We are a well built set up with excellent skilled operator with lot of experience in this segment/skill,have complete more than 200 similar job in freelancer in last 4 years, i have gone through your proj Flere

$147 USD in 3 dage
(122 bedømmelser)

Hello, Sir I am from vSol CORP. We are 19 people team, worked on more than 500 completed projects. We provide round the clock service. I have checked your project requirement. We are professional web scraping. We h Flere

$250 USD in 6 dage
(77 bedømmelser)

Greetings! Ready to start right away and I am giving you assurance of quality work. Best regards, -Arnob

$155 USD in 3 dage
(18 bedømmelser)

Dear Sir/Madam. I'm highly interested in your project and can start immediately. Have a look at my sample entry for 1-st row for your reviewing here please: [login to view URL] Flere

$150 USD in 5 dage
(15 bedømmelser)

We will help you with: Campaign contributions data Hello, Greetings from "Hire WordPress and Design Experts". We have gone through the information provided by you. We would like to tell you that we have a right expe Flere

$130 USD in 3 dage
(2 bedømmelser)

I am READY for you!!!!!. I consider myself a responsible and creative person, in the future I can bring new ideas to improve the way of your work, I'm a computer engineer. I understood perfectly the job requirements an Flere

$277 USD in 3 dage
(1 bedømmelse)

A proposal has not yet been provided

$144 USD in 3 dage
(0 bedømmelser)

Hi, I have done quite few similar projects (scrapping + data mining) in past and would like to work on yours as well. Good luck and best regards, -Ersan

$120 USD in 4 dage
(0 bedømmelser)

A proposal has not yet been provided

$155 USD in 3 dage
(0 bedømmelser)