I need a list of all test preparation companies, with their contact information, listed in Yelp for the 387 metropolitan areas listed at https://en.wikipedia.org/wiki/Metropolitan_statistical_area.
For example, in the St. Louis metropolitan area, Yelp lists 52 companies at https://www.yelp.com/search?find_desc=Test+Preparation&find_loc=Saint+Louis%2C+MO&start=50. You will need to click the "Test Preparation" button that appears just below the company name to filter the list to only companies that offer that service. You will need to click the company name and then the company website link on the right side to access those websites.
The company information must include the URL of the Yelp page, company name, phone number, website address, any physical address broken down into Address, City, State and Zip Code fields, and email address listed anywhere on the site, especially in the Contact Us page if that exists.
Before you respond to this post, please make sure that your software can access the company websites by clicking the appropriate buttons on the Yelp page for each company.