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: $589.00 (USD)

phpMyAdmin Screenshots:

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: $589.00 (USD)

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