Lifetime updates. Come back once in a while to stay updated of new versions of this database.

22.5 Million US Business Yellow Pages Dataset: Phone No., Emails, Website, Latitude & Longitude, etc.

Database Description:

This database (15.72GB) contains all the 22.5 million companies & businesses across United States, with important data fields such as phone number (99.97%), email (24.38%), website URL (52.82%), latitude (94.42%), longitude (94.42%), street address (94.69%), zip code (97.71%), city (97.71%), state / province (97.7%), category (99.72%), reviews & ratings (6.39%), small cover image (15.37%), regular_hours (44.71%), payment method (29.93%), and slogan (6.23%).

If you are in need of a complete database of America based businesses / organizations / companies / corporations and B2B emails + phone numbers, this one is it. The total number of unique phone numbers is 16,436,015, websites 7,154,922, and emails 4,142,833. See Data Samples and API.

This is the 4th edition / major update of this database. Download link will be manually sent to your PayPal email in 24 hours as this database is pretty large. Here's also the 3rd edition from a different data source.

Database Meta:

  • Size: 15.72 GB
  • Last updated: October 20th, 2020
  • Formats Included: MySQL SQL, CSV
  • Tables: 1

Buy Now & Download: $795.00 (USD)


phpMyAdmin Screenshots:

MySQL Database: 22.5 Million US Business Yellow Pages Dataset: Phone No., Emails, Website, Latitude & Longitude, etc. for Sale

Table Details (Data Structure / Schema):

  • business
    Records:22,506,313

    Data fields

    1. id: bigint(20) unsigned
    2. ts: timestamp
    3. _source_url: varchar(255)
    4. business_name: varchar(255)
    5. home_page: mediumtext
    6. email_address: varchar(127)
    7. phone: varchar(63)
    8. street: varchar(255)
    9. city: varchar(127)
    10. state: varchar(63)
    11. zip_code: varchar(63)
    12. full_address: mediumtext
    13. category: mediumtext
    14. rating: varchar(63)
    15. number_of_reviews: varchar(63)
    16. bbb_rating_or_license: varchar(63)
    17. latitude: varchar(63)
    18. longitude: varchar(63)
    19. cover_image: varchar(255)
    20. slogan: mediumtext
    21. general_info: mediumtext
    22. regular_hours: mediumtext
    23. extra_phones: mediumtext
    24. services_products: mediumtext
    25. payment: mediumtext
    26. price_range: varchar(63)
    27. aka: mediumtext
    28. other_links: mediumtext
    29. other_information: mediumtext
    30. review_1_name: varchar(255)
    31. review_1_date: varchar(63)
    32. review_1_rating: varchar(63)
    33. review_1_text: mediumtext
    34. review_2_name: varchar(63)
    35. review_2_date: varchar(63)
    36. review_2_rating: varchar(127)
    37. review_2_text: mediumtext

Buy Now & Download: $795.00 (USD)



Download link will be sent to your PayPal email. Please check spam folder in case you didn't see it in your inbox. Do contact us if you didn't receive it 10 minutes after payment. We will manually send you the download details in 24 hours. Our support staff work in the time zone of GMT+8.

Instant download upon payment success, just press return button on PayPal website after finishing payment.

Potential Applications / Usage:

  • US yellow pages site by zip codes
  • Direct marketing / Phone marketing / Email marketing / Email lists
  • Marketing intelligence
  • US business directory / Business information site or application
  • Business maps, search and comparison site or app
  • Business reverse phone lookup

Other Available Formats:

Some of these formats are available on extra charge, depending on the database.

  • Plain CSV
  • CSV for Microsoft Excel
  • Microsoft Excel .XLS file (2008, 2007, 2003, 2000)
  • Microsoft Word .DOC file (2008, 2007, 2003, 2000)
  • LaTeX
  • Open Document Spreadsheet
  • Open Document Text
  • PDF
  • XML
  • YAML
  • WordPress Category / Post Database
  • Single Table Format

As we frequently enhance our databases for sale, make sure you revisit once in a while to stay updated of the databases you have purchased. Simply by clicking through the same URL we sent to you, you can download updated versions.