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.

Every agent becomes a spreadsheet row.

List every insurance agent in a city with their office phone.
Simplescraper
simplescraper.io/dashboard/recipes/insurance-agents/results
State FarmInsurance agents
AgentLicenceOffice addressCityOffice phoneAgent page
Janna BidlackLic: OH-9583032500 W Dublin Granville RoadColumbus, OH 43235-5701614-764-2411https://www.statefarm.com/agent/us/oh/columbus/janna-bidlack-932wd4b0000
Ted BriggsLic: OH-819882545 Petzinger RoadColumbus, OH 43209-3498614-235-6667https://www.statefarm.com/agent/us/oh/columbus/ted-briggs-m9vhs1ys000
Beau BurtonLic: OH-666993991 Schrock RoadColumbus, OH 43229-1163614-436-6991https://www.statefarm.com/agent/us/oh/columbus/beau-burton-cl9dm452000
Fallon ChambersLic: OH-15397014018 Alum Creek DriveColumbus, OH 43207-5137614-409-9196https://www.statefarm.com/agent/us/oh/columbus/fallon-chambers-jjnzcbw91al
Gianna ConeLic: OH-304611495 Morse RoadColumbus, OH 43229-6434614-267-7865https://www.statefarm.com/agent/us/oh/columbus/gianna-cone-5zzmp1ys000
Adam DeelLic: OH-14304391288 Bethel RoadColumbus, OH 43220-2612614-451-3800https://www.statefarm.com/agent/us/oh/columbus/adam-deel-464667rmmge
Jerry DohertyLic: OH-4297820 E Broad St Ste 244Columbus, OH 43215614-461-7833https://www.statefarm.com/agent/us/oh/columbus/jerry-doherty-qbv701ys000
Kyle ElkinsLic: OH-15520933492 Snouffer Road Suite 125Columbus, OH 43235-5714614-846-2886https://www.statefarm.com/agent/us/oh/columbus/kyle-elkins-kjf307byjak
Jack GilkersonLic: OH-865494232 E Main StreetColumbus, OH 43213-3028614-237-4256https://www.statefarm.com/agent/us/oh/columbus/jack-gilkerson-0cfdf1ys000
David GrantLic: OH-271354612 North High StreetColumbus, OH 43214-2002614-262-1055https://www.statefarm.com/agent/us/oh/columbus/david-grant-bjz2m1ys000
Danny HiltonLic: OH-364313276 Morse RdColumbus, OH 43231-6134614-475-8808https://www.statefarm.com/agent/us/oh/columbus/danny-hilton-tlk8p1ys000
Vic JimenezLic: OH-59776135 N Wilson RoadColumbus, OH 43204-1215614-272-5456https://www.statefarm.com/agent/us/oh/columbus/vic-jimenez-3p8f32pf000
Amie KimLic: OH-6964861246 North High StreetColumbus, OH 43201614-586-8701https://www.statefarm.com/agent/us/oh/columbus/amie-kim-twj7z45l000
Dennis KoonLic: OH-9820255144 Morse Rd. Ste 100Columbus, OH 43230614-476-1260https://www.statefarm.com/agent/us/oh/columbus/dennis-koon-0vzyy2tn000
Pam Lewis-KidderLic: OH-10762292510 Billingsley RoadColumbus, OH 43235-1990614-698-0028https://www.statefarm.com/agent/us/oh/columbus/pam-lewis-kidder-1v5m148v000
Larry NollLic: OH-482902648 Billingsley RoadColumbus, OH 43235-1924614-889-1156https://www.statefarm.com/agent/us/oh/columbus/larry-noll-gbfx31ys000
Nikki OgunduyileLic: OH-69183221 E State StColumbus, OH 43215-5747614-274-7130https://www.statefarm.com/agent/us/oh/columbus/nikki-ogunduyile-gycx14fm000
Alex OttneyLic: OH-10910863468 N High Street Suite AColumbus, OH 43214-4031614-754-9855https://www.statefarm.com/agent/us/oh/columbus/alex-ottney-bnyy97zsval
Steve RiderLic: OH-14908113250 Henderson Road Suite 101Columbus, OH 43220-2398614-457-5070https://www.statefarm.com/agent/us/oh/columbus/steve-rider-y8cm06t7sge
Suzanne RizerLic: OH-847602930 Hayden Run PlazaColumbus, OH 43235-7261614-874-2900https://www.statefarm.com/agent/us/oh/columbus/suzanne-rizer-kl4nk1ys000
Gregg RothermundLic: OH-4842150 Northwoods BoulevardColumbus, OH 43235-4717614-436-9015https://www.statefarm.com/agent/us/oh/columbus/gregg-rothermund-0phkv1ys000
Bruce RothermundLic: OH-97673450 Northwoods BlvdColumbus, OH 43235-4717614-888-5830https://www.statefarm.com/agent/us/oh/columbus/bruce-rothermund-sdml01ys000
Wendy SamsLic: OH-410028740 Orion PlaceColumbus, OH 43240614-985-6123https://www.statefarm.com/agent/us/oh/columbus/wendy-sams-qr0rg39v000
Matt SimondsLic: OH-304673244 N High StColumbus, OH 43202614-262-6700https://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 FarmState Farm
  • Farmers InsuranceFarmers Insurance
  • AllstateAllstate
  • Lloyd'sLloyd's
  • Trustpilot
  • ResellerRatingsResellerRatings

Start building your agent list today.

Start scraping free