What Is in the File Businesses by state 2 items Table view Item Rows Share Ohio 4,790 91.7% Arizona 431 8.3%
Businesses by trades 2 items Handyman 4,804
Appliance repair 633
Table view Item Rows Share Handyman 4,804 88.4% Appliance repair 633 11.6%
Largest cities Top 12 of 30 Columbus, OH 373
Cincinnati, OH 199
Toledo, OH 191
Cleveland, OH 169
Dayton, OH 141
Akron, OH 97
Canton, OH 91
Westerville, OH 87
Middletown, OH 84
Youngstown, OH 83
Hamilton, OH 64
Phoenix, AZ 63
18 more 975
Table view Item Rows Share Columbus, OH 373 14.3% Cincinnati, OH 199 7.6% Toledo, OH 191 7.3% Cleveland, OH 169 6.5% Dayton, OH 141 5.4% Akron, OH 97 3.7% Canton, OH 91 3.5% Westerville, OH 87 3.3% Middletown, OH 84 3.2% Youngstown, OH 83 3.2% Hamilton, OH 64 2.4% Phoenix, AZ 63 2.4% Warren, OH 63 2.4% Mason, OH 60 2.3% Delaware, OH 59 2.3% Lakewood, OH 58 2.2% Parma, OH 58 2.2% Mentor, OH 58 2.2% Hilliard, OH 56 2.1% North Royalton, OH 54 2.1% Gahanna, OH 54 2.1% Glendale, AZ 53 2.0% Dublin, OH 53 2.0% Grove City, OH 53 2.0% Mesa, AZ 52 2.0% Beavercreek, OH 52 2.0% Tucson, AZ 51 1.9% Newark, OH 48 1.8% Barberton, OH 47 1.8% Medina, OH 46 1.8%
How It Was Checked Only businesses that passed the directory check were counted. Raw pulls, dropped, closed and thin listings are left out. Listings a business asked us to remove, and listings the directory suppressed, were taken out before counting. This is aggregate data only. There are no business names, phones, street addresses, ZIPs, coordinates or place ids in the sample or the full file. Every row covers 15 or more businesses. A group smaller than 15 is not published, and rating and review figures need 15 rated businesses. Handymen counted are the ones that passed Handyrank's listing check (Google listing, name and city search, own website). Appliance repair companies are the ApplianceRank set, classified by service type. Emergency service applies to appliance repair only. Fields levelwhat the row groups by: National, State, City or Metro, Category, or a mix areastate, city or metro the row covers statestate or country code categorybusiness category businessesbusinesses in the group (15 or more, always) with_website_pctshare of the group with a website listed median_ratingmedian public star rating, shown when 15 or more in the group are rated rated_4_5_plus_pctshare of rated businesses at 4.5 stars or better median_reviewsmedian public review count among rated businesses reviews_100_plus_pctshare of rated businesses with 100 or more reviews emergency_service_pctappliance repair only: share that offer emergency service Sample Preview First 25 rows of the free sample. The CSV has every field.
Get the Data
Free sample 20 rows, picked at random. No phones, street addresses, ZIPs, coordinates, emails or personal names.
Full file 179 rows with every field, cleaned and deduplicated.