This is a database of doctors having 153,898 records with title, phone number, street address, address locality, address region & postal code fields in each. All these doctors are throughout 2,537 cities of 51 states in the United States. The whole US doctors data set has 4 tables.
| Name | n3_chennan_doctor_yellowpages_com |
|---|---|
| Data | 410.88M (+ 0B) |
| Tables | 4 (+ 0) |
| Columns | 25 (+ 0) |
| Table Rows | 3,364,725 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 2,537 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| city_x_doctor | 3,208,239 | city_id |
100%
|
| doctor_id |
100%
|
||
| doctor | 153,898 | title |
100%
|
| phone |
99.98%
|
||
| street_address |
94.54%
|
||
| address_locality |
95.38%
|
||
| address_region |
95.38%
|
||
| postal_code |
95.38%
|
||
| 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.
