Web scraping for insurance.
The jobs insurance teams run with Simplescraper, done on a real site with the data it returns and the steps to repeat it.
Pick the job you have
Every agent becomes a spreadsheet row.
List every insurance agent in a city with their office phone.
| Agent | Licence | Office address | City | Office phone | Agent page |
|---|---|---|---|---|---|
| Janna Bidlack | Lic: OH-958303 | 2500 W Dublin Granville Road | Columbus, OH 43235-5701 | 614-764-2411 | https://www.statefarm.com/agent/us/oh/columbus/janna-bidlack-932wd4b0000 |
| Ted Briggs | Lic: OH-81988 | 2545 Petzinger Road | Columbus, OH 43209-3498 | 614-235-6667 | https://www.statefarm.com/agent/us/oh/columbus/ted-briggs-m9vhs1ys000 |
| Beau Burton | Lic: OH-666993 | 991 Schrock Road | Columbus, OH 43229-1163 | 614-436-6991 | https://www.statefarm.com/agent/us/oh/columbus/beau-burton-cl9dm452000 |
| Fallon Chambers | Lic: OH-1539701 | 4018 Alum Creek Drive | Columbus, OH 43207-5137 | 614-409-9196 | https://www.statefarm.com/agent/us/oh/columbus/fallon-chambers-jjnzcbw91al |
| Gianna Cone | Lic: OH-30461 | 1495 Morse Road | Columbus, OH 43229-6434 | 614-267-7865 | https://www.statefarm.com/agent/us/oh/columbus/gianna-cone-5zzmp1ys000 |
| Adam Deel | Lic: OH-1430439 | 1288 Bethel Road | Columbus, OH 43220-2612 | 614-451-3800 | https://www.statefarm.com/agent/us/oh/columbus/adam-deel-464667rmmge |
| Jerry Doherty | Lic: OH-42978 | 20 E Broad St Ste 244 | Columbus, OH 43215 | 614-461-7833 | https://www.statefarm.com/agent/us/oh/columbus/jerry-doherty-qbv701ys000 |
| Kyle Elkins | Lic: OH-1552093 | 3492 Snouffer Road Suite 125 | Columbus, OH 43235-5714 | 614-846-2886 | https://www.statefarm.com/agent/us/oh/columbus/kyle-elkins-kjf307byjak |
| Jack Gilkerson | Lic: OH-86549 | 4232 E Main Street | Columbus, OH 43213-3028 | 614-237-4256 | https://www.statefarm.com/agent/us/oh/columbus/jack-gilkerson-0cfdf1ys000 |
| David Grant | Lic: OH-27135 | 4612 North High Street | Columbus, OH 43214-2002 | 614-262-1055 | https://www.statefarm.com/agent/us/oh/columbus/david-grant-bjz2m1ys000 |
| Danny Hilton | Lic: OH-36431 | 3276 Morse Rd | Columbus, OH 43231-6134 | 614-475-8808 | https://www.statefarm.com/agent/us/oh/columbus/danny-hilton-tlk8p1ys000 |
| Vic Jimenez | Lic: OH-597761 | 35 N Wilson Road | Columbus, OH 43204-1215 | 614-272-5456 | https://www.statefarm.com/agent/us/oh/columbus/vic-jimenez-3p8f32pf000 |
| Amie Kim | Lic: OH-696486 | 1246 North High Street | Columbus, OH 43201 | 614-586-8701 | https://www.statefarm.com/agent/us/oh/columbus/amie-kim-twj7z45l000 |
| Dennis Koon | Lic: OH-982025 | 5144 Morse Rd. Ste 100 | Columbus, OH 43230 | 614-476-1260 | https://www.statefarm.com/agent/us/oh/columbus/dennis-koon-0vzyy2tn000 |
| Pam Lewis-Kidder | Lic: OH-1076229 | 2510 Billingsley Road | Columbus, OH 43235-1990 | 614-698-0028 | https://www.statefarm.com/agent/us/oh/columbus/pam-lewis-kidder-1v5m148v000 |
| Larry Noll | Lic: OH-48290 | 2648 Billingsley Road | Columbus, OH 43235-1924 | 614-889-1156 | https://www.statefarm.com/agent/us/oh/columbus/larry-noll-gbfx31ys000 |
| Nikki Ogunduyile | Lic: OH-691832 | 21 E State St | Columbus, OH 43215-5747 | 614-274-7130 | https://www.statefarm.com/agent/us/oh/columbus/nikki-ogunduyile-gycx14fm000 |
| Alex Ottney | Lic: OH-1091086 | 3468 N High Street Suite A | Columbus, OH 43214-4031 | 614-754-9855 | https://www.statefarm.com/agent/us/oh/columbus/alex-ottney-bnyy97zsval |
| Steve Rider | Lic: OH-1490811 | 3250 Henderson Road Suite 101 | Columbus, OH 43220-2398 | 614-457-5070 | https://www.statefarm.com/agent/us/oh/columbus/steve-rider-y8cm06t7sge |
| Suzanne Rizer | Lic: OH-84760 | 2930 Hayden Run Plaza | Columbus, OH 43235-7261 | 614-874-2900 | https://www.statefarm.com/agent/us/oh/columbus/suzanne-rizer-kl4nk1ys000 |
| Gregg Rothermund | Lic: OH-48421 | 50 Northwoods Boulevard | Columbus, OH 43235-4717 | 614-436-9015 | https://www.statefarm.com/agent/us/oh/columbus/gregg-rothermund-0phkv1ys000 |
| Bruce Rothermund | Lic: OH-976734 | 50 Northwoods Blvd | Columbus, OH 43235-4717 | 614-888-5830 | https://www.statefarm.com/agent/us/oh/columbus/bruce-rothermund-sdml01ys000 |
| Wendy Sams | Lic: OH-41002 | 8740 Orion Place | Columbus, OH 43240 | 614-985-6123 | https://www.statefarm.com/agent/us/oh/columbus/wendy-sams-qr0rg39v000 |
| Matt Simonds | Lic: OH-30467 | 3244 N High St | Columbus, OH 43202 | 614-262-6700 | https://www.statefarm.com/agent/us/oh/columbus/matt-simonds-fglwj1ys000 |
Download, pull via API, sync to Google Sheets, or send to any app, webhook and data store.
What insurance teams use it for
Find agents
Build contact lists of agents and agencies by state and city from carrier and association directories.
Look up payer IDs
Collect insurer names and payer IDs from claims directories into one table.
Watch reputation
Collect what customers say about insurers across review sites.
Scrape the most popular insurance sites
State Farm
Farmers Insurance
Allstate
Lloyd's- Trustpilot
ResellerRatings