Usage & Publication License: database price dollar sign795.00

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

B2B email list with phone, website, latitude, longitude, address, reviews of 22,506,313 business by 33,754 categories & 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 business directory database, there are 22,506,313 businesses across 39,395 cities in 58 states & territories of United States. They are classified under 33,754 categories. If you are ever in need of a complete B2B email list and yellow pages 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, website 11,887,834, and email 5,487,039.

Data Samples (JSON, CSV, Excel):
http://n3.datasn.io/data/api/v1/n3a6/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: [email protected]UsableDatabases.com

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

  2. What is your inquiry?

  3. Is a boy female or male?

    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.