Home Data Medicine & Health Dentists

US 252,571 Dentists: Address, Phone, Postcode, Lat, Lon w/ Hour, Image Database

Name	n3_chennan_dentist_yellowpages_com
Data	277.42M (+ 0B)
Tables	8 (+ 0)
Columns	49 (+ 0)
Table Rows	1,300,567 (+ 0)
Media	0B (+ 0B)
Files	0 (+ 0)
Last Commit	2019-09-21 09:45:03 (+ 197 d)

This is a fields-rich database of dentists with 252,571 records from 2,537 cities of 51 states in the United States. Each dentist is comprised of title, phone number, street address, address locality, address region, postal code, latitude, longitude, categories, etc. It also comes with 53,766 dentist images in this US dentists database.

The whole United States dentists database has 8 tables.

Data Samples

Main (Desktop) / JSON / XML / Excel / CSV (Download)

Database APIs

http://n3.datasn.io/data/api/v1/n3_chennan/dentists_in_us_1/ (By Table)

Media Files

dentist_image ^{Bytes: 0B / Files: 0}

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
city	2,537	title	100%
		state_id	100%
		state	100%
city_x_dentist	796,453	city_id	100%
city_x_dentist	796,453	dentist_id	100%
dentist	252,571	title	100%
		phone	99.91%
		street_address	98.59%
		address_locality	98.89%
		address_region	98.89%
		postal_code	98.89%
		biography	9.59%
		location	11.49%
		latitude	94.37%
		longitude	94.37%
		extra_phone	35.24%
		service	24.52%
		brand	9.84%
		payment	36.79%
		neighborhood	44.33%
		weblink	32.6%
		categories	92.53%
dentist_x_hour	190,193	dentist_id	100%
dentist_x_hour	190,193	hour_id	100%
hour	4,996	key	100%
hour	4,996	value	100%
image	53,766	alt	100%
image	53,766	dentist_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

dentist_image

Size (Bytes)	Files
0B	0

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2019-09-21 (+ 197 d)	277.42M (+ 0B)	8 (+ 0)	49 (+ 0)	1,300,567 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-03-07 (+ 43 d)	277.42M (+ 0B)	8 (+ 0)	49 (+ 0)	1,300,567 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-01-23 (+ 44 d)	277.42M (+ 0B)	8 (+ 0)	49 (+ 0)	1,300,567 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-12-09 (+ 29 d)	277.42M (+ 0B)	8 (+ 0)	49 (+ 0)	1,300,567 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-11-09 (+ 27 d)	277.42M (+ 49.11M)	8 (+ 0)	49 (+ 0)	1,300,567 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-10-13 (+ 29 d)	228.31M (+ 0B)	8 (+ 0)	49 (+ 0)	1,300,567 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-09-13 (+ 34 d)	228.31M (+ 0B)	8 (+ 0)	49 (+ 0)	1,300,567 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-08-09 (+ 27 d)	228.31M (+ 0B)	8 (+ 0)	49 (+ 0)	1,300,567 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-07-12 (+ 31 d)	228.31M (+ 0B)	8 (+ 0)	49 (+ 0)	1,300,567 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-06-10 (+ 31 d)	228.31M (+ 0B)	8 (+ 0)	49 (+ 0)	1,300,567 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-05-10 (+ 28 d)	228.31M (+ 0B)	8 (+ 0)	49 (+ 0)	1,300,567 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-04-11 (+ 38 d)	228.31M (+ 0B)	8 (+ 0)	49 (+ 0)	1,300,567 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-03-03	228.31M	8	49	1,300,567	0B	0

Download Latest Commit

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

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.