This is a fields-rich dentists database with 252,571 records from 2,537 cities of 51 states in America. 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 data set has 8 tables.
| 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) |
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%
|
| 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%
|
| hour_id |
100%
|
||
| hour | 4,996 | key |
100%
|
| value |
100%
|
||
| image | 53,766 | alt |
100%
|
| 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 |
|---|---|
| 0P | 0 |
