WHAT MUST BE DELIVERED:
A CSV file for each US state (50 total) with all businesses listed in it.
There are about 38,000 cities in US so I expect a huge list for each state.
You can use Yelp Fusion API to get the data but it limits 50 entries per request so you may have to find a work around it. And has 25,000 request calls limit.(https://www.yelp.com/developers/documentation/v3/business_search)
See attached CSV example for what data i need from each business entry. Most important ones: Name, ID, URL, Categories (all), Address (full), Phone, Review Count, Rating, Business Website URL (this one is optional. not available via API request)
Yelp outputs business entries by city so you will need to go through each one and combine them by state. I've attached a CSV with all cities & states in USA
January 28, 2018
I am looking for a mix of experience and value