What Is in the File Businesses by state 9 items California 1,131
Arizona 363
Colorado 222
Washington 182
Utah 182
Nevada 125
Oregon 94
Idaho 72
New Mexico 32
Table view Item Rows Share California 1,131 47.1% Arizona 363 15.1% Colorado 222 9.2% Washington 182 7.6% Utah 182 7.6% Nevada 125 5.2% Oregon 94 3.9% Idaho 72 3.0% New Mexico 32 1.3%
Largest metros Top 12 of 30 Phoenix, AZ 255
Los Angeles, CA 180
Orange County, CA 152
San Diego, CA 140
Denver, CO 123
Seattle, WA 116
Sacramento, CA 103
Las Vegas, NV 94
Inland Empire, CA 93
Salt Lake City, UT 80
East Bay, CA 66
San Jose, CA 65
18 more 677
Table view Item Rows Share Phoenix, AZ 255 11.9% Los Angeles, CA 180 8.4% Orange County, CA 152 7.1% San Diego, CA 140 6.5% Denver, CO 123 5.7% Seattle, WA 116 5.4% Sacramento, CA 103 4.8% Las Vegas, NV 94 4.4% Inland Empire, CA 93 4.3% Salt Lake City, UT 80 3.7% East Bay, CA 66 3.1% San Jose, CA 65 3.0% Portland, OR 65 3.0% Boise, ID 53 2.5% Coachella Valley, CA 50 2.3% Colorado Springs, CO 47 2.2% Tucson, AZ 45 2.1% Fort Collins, CO 44 2.1% Temecula, CA 42 2.0% San Francisco, CA 40 1.9% Fresno, CA 38 1.8% Tacoma, WA 33 1.5% Ogden, UT 32 1.5% Provo, UT 32 1.5% Reno, NV 31 1.4% Santa Clarita, CA 29 1.4% Modesto, CA 27 1.3% Albuquerque, NM 25 1.2% Bakersfield, CA 22 1.0% Antelope Valley, CA 22 1.0%
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. Each company was matched to one of the directory metros and its own website was visited where it had one. The license column counts only companies whose own site we could read. 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 claimed_pctshare with a claimed profile open_24_hour_pctshare open all day, every day service_area_only_pctshare that travel to the customer and show no storefront license_on_own_site_pctshare whose own website names a contractor license (own sites we could read only) Sample Preview First 25 rows of the free sample. The CSV has every field.
Get the Data
Free sample 25 rows, picked at random. No phones, street addresses, ZIPs, coordinates, emails or personal names.
Full file 46 rows with every field, cleaned and deduplicated.