Usage & Publication License: database price dollar sign669.00

US Yellow Pages & B2B Email List Dataset of 22.5 Million Businesses

Business emails list with phone, website, latitude, longitude, reviews of 22,506,313 business by 33,754 niches & 39,395 cities in United States

database structure screenshot of US Yellow Pages & B2B Email List Dataset of 22.5 Million Businesses

Description: In this US B2B email list and local business directory database, there are 22,506,313 businesses in 39,395 cities, 58 states & territories of United States. They are classified under 33,754 categories. If you are ever in need of a complete email list and yellow pages / phone numbers database of all America businesses and companies, this is THE one.

In table business, each record is comprised of business name (with aka), email (24.39%), home page URL (52.82%), phone number (some with extra phone numbers) (99.97%), address (street, city, state) (97.71%), zip code (97.71%), categories delimited by comma (99.72%), ratings (6.92%), latitude & longitude (94.42%), thumbnail image (15.37%), slogan (6.23%), regular hours (44.71%), services & products (0.48%), payment methods (29.93%), more URL links (52.97%), consumer reviews (6.39%), and more information (17.96%).

The total number of unique phone numbers is 22,499,561, websites 11,887,834, and emails 5,487,039.

Data Samples (JSON, CSV, XML, Excel):
https://songer.datasn.com/data/api/v1/u_2926417bef71d25521f5/yellow_pages_in_united_states/main/list/

Related DBs:

Database Statistics

  • Size: 15.72 GB
  • Tables: 1
  • Records: 22,506,313
  • Formats: MySQL, CSV, MS Excel, MS Access, XML (See Downloads for sure.)

Database Categories

Database Structure

Table Records Fields
business 22,506,313
  1. id
  2. ts
  3. business_name
  4. home_page
  5. email_address
  6. phone
  7. street
  8. city
  9. state
  10. zip_code
  11. full_address
  12. category
  13. rating
  14. number_of_reviews
  15. bbb_rating_or_license
  16. latitude
  17. longitude
  18. cover_image
  19. slogan
  20. general_info
  21. regular_hours
  22. extra_phones
  23. services_products
  24. payment
  25. price_range
  26. aka
  27. other_links
  28. other_information
  29. review_1_name
  30. review_1_date
  31. review_1_rating
  32. review_1_text
  33. review_2_name
  34. review_2_date
  35. review_2_rating
  36. review_2_text

Content Scope

Below are the categories / subjects / topics this database contains record entries about and the number of entries under each of them:

state

category

Miscellaneous

Notes:

  • 99.97% of the records have at least one phone number.
  • 52.82% of the records have a website address.
  • 24.38% of the records have an email address.
  • 94.42% of the records have a latitude.
  • 94.42% of the records have a longitude.
  • 97.71% of the records have a street address.
  • 97.71% of the records have a zip code.
  • 99.72% of the records have at least one category.
  • 6.92% of the records have a BBB rating.
  • 15.37% of the records have a thumbnail image.
  • 6.23% of the records have a slogan.
  • 44.71% of the records have regular hours.
  • 34.25% of the records have extra phone numbers.
  • 52.97% of the records have other links.
  • 6.39% of the records have at least one customer review.

Lifetime Updates (fees may apply)

This database is being constantly updated with regards to both data volume and data structure, once every 0.5 - 5 years depending on niche, and you will be notified via our Blog or Twitter when new versions come out.

Other Formats upon Request

We include the most common, popular and usable formats readily accessible on the download page, but should you need the database in other formats such as:

  • Microsoft SQL Server
  • Microsoft SQL Server Compact Edition
  • Oracle
  • PostgreSQL
  • ODBC
  • Interbase / Firebird
  • WordPress
  • Single Table (multiple tables are combined into one)
  • Microsoft Word .DOC
  • PDF

Let us know and we'll see what we can do. Additional fees may apply.


Share This Page:

Follow us at @UsableDatabases to be notified of database (data sets, lists) releases and updates.

We blog as well. Stay tuned by your preferred means so we can keep you posted on what we are working on!

Contact Us

Need assistance? We can't wait to help you find the perfect database or provide for your custom data needs! Use Custom Data Project form for serious project inquiries. Email: info@UsableDatabases.com

  1. We will get back to you at this email.

  2. What is your inquiry?

  3. What is the opposite of black?

    Please answer the question by common sense.

Back to Top

Subscribe to our Data Press feed to be notified when we release new databases!


Be notified when new data sets are released!
You would also receive running promo discounts and updates to current databases.

Worry Free: We use FeedBurner. You may receive periodic emails / posts from us but you can very easily unsubscribe anytime.