Investors Database – Scraping Investors Data from Opensecrets.org
Project Title: Scraping Investors Data from http://www.opensecrets.org/indivs/
I am interested in your services.
The project involves collecting data verified from this website and putting it into Excel.
When I go to that web site and under occupation put in the word “investor”
I get the following results
160,355 records found in 0.094 seconds.
The very first result that comes up is this:
WACO, TX 76714 INVESTOR 7/18/05 $1,100 Edwards, Chet (D)
unfortunately, the name and address
are all together in the first column.
I would want the first name, last name, city, state, and ZIP Code to each be in their own column.
Also, the last column, of the result, like the first column of the results may need to be broken up into separate columns as well.
We could start more simply by doing this one:
Occupation = Angel Investors
then, you only get:
271 records found in 0.094 seconds.
Where there is a (D) (R) (L) in the last column, it needs to be put in a separate column at the right end as well.
For your review scraping from any website feel free to contact us on firstname.lastname@example.org.