Home Data Business & Industry Yellow Pages US Yellow Pages

Database of 1,555,381 US Yellow Pages: Address, Zip, Phone NO.

This US yellow pages database is a great one to help people from all over the world check the telephone numbers of US and develop your business. There are 1,555,381 business records from 45,450 cities of 51 states in the United States. Each business record consists of title, address, city, state, zip code, detail introduction, phone number etc.

The whole database consists of 4 tables.

Samples

Browse (Mobile + Desktop) / JSON / Excel / CSV (Download)

APIs & Access

http://n3.datasn.io/data/api/v1/n3zm/business_of_American_1/ (By Table)

Data	270.61M (+ 0B)
Tables	4 (+ 0)
Columns	36 (+ 0)
Table Rows	3,643,529 (+ 0)
Media	0B (+ 0B)
Files	0 (+ 0)
Last Commit	2018-10-13 06:04:26 (+ 30 d)

Tables + Columns
Media Files
Updates

Tables & Columns

Tables	Rows	Columns	Non-empty
business	1,555,381	title	100%
		address	84.17%
		city	96.88%
		state	96.88%
		generation_suffix	1.57%
		zip	96.88%
		lablename	96.88%
		yhpccode	18.98%
		lastname	96.88%
		firstname	96.88%
		secondary	2.56%
		address_number	73.13%
		address_suffix	60.08%
		address_street	84.17%
		phone_number	0%
		detail_introduction	96.88%
		phone	96.88%
city	45,450	title	100%
		state_id	100%
		state	100%
city_x_business	2,042,647	city_id	100%
city_x_business	2,042,647	business_id	100%
state	51	title	100%

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
2018-10-13 (+ 30 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-09-13 (+ 34 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-08-09 (+ 27 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-07-12 (+ 31 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-06-10 (+ 31 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-05-10 (+ 28 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-04-11 (+ 38 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-03-03 (+ 35 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-01-27 (+ 29 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2017-12-29 (+ 20 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2017-12-08 (+ 9 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2017-11-28 (+ 19 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2017-11-09 (+ 10 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2017-10-29 (+ 19 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2017-10-10 (+ 31 d)	270.61M (+ 0B)	4 (+ 0)	36 (+ 0)	3,643,529 (+ 0)	0B (+ 0B)	0 (+ 0)
2017-09-08	270.61M	4	36	3,643,529	0B	0

Request Access

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to generate 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. Make 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.