Home Data Business & Industry Yellow Pages Yellow Pages + US Yellow Pages + Emails + Phones + URLs + Latitudes & Longitudes

US Yellow Pages 22.5 Million Businesses (Email, Phone, URL, Lat & Lon, Reviews)

Name	n3a6_yellow_pages_in_united_states
Data	15.33G (- 1.24G)
Tables	2 (- 1)
Columns	76 (- 37)
Table Rows	22,506,315 (- 1,656,232)
Media	0B (+ 0B)
Files	0 (+ 0)
Last Commit	2023-06-19 19:36:22 (+ 169 d)

This is a continental B2B emails list / phone numbers book / business yellow pages dataset of 22,506,313 local businesses and companies in United States with 37 data fields: business name, phone numbers, business email, street address, city, state, zip code, website URL, categories, overall rating, BBB rating or license, latitude, longitude, cover image, slogan, general info, regular hours, extra phone numbers, services & products, payment methods, price range, aka, other links, other information, and reviews (reviewer / date / rating / text). This could be the perfect United States B2B email list, phone numbers list, and business geolocations (latitude & longitude) dataset, for your marketing goals or any business development applications.

To download a full dump of the entire database in CSV or SQL, see U.S Yellow Pages.

Data Samples

Main List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table

Data APIs

http://n3.datasn.io/data/api/v1/n3a6/yellow_pages_in_united_states/ (By Table)

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
business	22,506,313	business_name	100%
		home_page	52.82%
		email_address	24.38%
		phone	99.97%
		street	94.69%
		city	97.71%
		state	97.7%
		zip_code	97.71%
		full_address	97.71%
		category	99.72%
		rating	6.39%
		number_of_reviews	6.39%
		bbb_rating_or_license	6.92%
		latitude	94.42%
		longitude	94.42%
		cover_image	15.37%
		slogan	6.23%
		general_info	18.76%
		regular_hours	44.71%
		extra_phones	34.25%
		services_products	0.48%
		payment	29.93%
		price_range	0%
		aka	29.28%
		other_links	52.97%
		other_information	17.96%
		review_1_name	6.39%
		review_1_date	6.39%
		review_1_rating	6.39%
		review_1_text	6.2%
		review_2_name	2.62%
		review_2_date	2.62%
		review_2_rating	2.62%
		review_2_text	2.52%

Notes:

Meta columns id and ts are not shown here, but included in columns total.
Some statistical or memo columns are not shown here, but included in columns total.
Non-empty percentage indicates the percent of values that are non-empty for that particular column.

Media Sets

No media sets.

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	15.33G (- 1.24G)	2 (- 1)	76 (- 37)	22,506,315 (- 1,656,232)	0B (+ 0B)	0 (+ 0)
2023-01-01 (+ 95 d)	16.57G (+ 0B)	3 (+ 0)	113 (+ 0)	24,162,547 (+ 0)	0B (+ 0B)	0 (+ 0)
2022-09-27 (+ 271 d)	16.57G (- 38.53M)	3 (+ 0)	113 (+ 1)	24,162,547 (+ 1,656,199)	0B (+ 0B)	0 (+ 0)
2021-12-30 (+ 115 d)	16.61G (+ 96K)	3 (+ 1)	112 (+ 36)	22,506,348 (+ 33)	0B (+ 0B)	0 (+ 0)
2021-09-05 (+ 150 d)	16.61G (+ 0B)	2 (+ 0)	76 (+ 0)	22,506,315 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-04-08 (+ 68 d)	16.61G (+ 0B)	2 (+ 0)	76 (+ 0)	22,506,315 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-01-29 (+ 120 d)	16.61G (+ 912M)	2 (+ 0)	76 (+ 0)	22,506,315 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-10-01	15.72G	2	76	22,506,315	0B	0

Download Latest Commit

In the same time, you can also access this data set via API.

Access Now!

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to build API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.