This is a doctors database with 1,728,217 records from the United States and having physician & surgeon categories.
Each doctor record is comprised of business name, home page URL, email address, phone numbers, street, city, state, zip code, full address, category, 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).
There are 2 tables in the whole America doctors (physicians & surgeons) data set.
| Name | n3a6_doctors_physicians_surgeons_in_united_states |
|---|---|
| Data | 1.27G (+ 0B) |
| Tables | 2 (+ 0) |
| Columns | 76 (+ 0) |
| Table Rows | 1,728,217 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| doctor | 1,728,217 | business_name |
100%
|
| home_page |
47.65%
|
||
| email_address |
12.09%
|
||
| phone |
99.99%
|
||
| street |
99.16%
|
||
| city |
99.61%
|
||
| state |
99.61%
|
||
| zip_code |
99.61%
|
||
| full_address |
99.61%
|
||
| category |
99.83%
|
||
| rating |
3.51%
|
||
| number_of_reviews |
3.51%
|
||
| bbb_rating_or_license |
0.48%
|
||
| latitude |
99%
|
||
| longitude |
99%
|
||
| cover_image |
14.44%
|
||
| slogan |
1.24%
|
||
| general_info |
40.66%
|
||
| regular_hours |
39.02%
|
||
| extra_phones |
58.77%
|
||
| services_products |
1.15%
|
||
| payment |
26.79%
|
||
| price_range |
0%
|
||
| aka |
2.8%
|
||
| other_links |
47.72%
|
||
| other_information |
26.5%
|
||
| review_1_name |
3.51%
|
||
| review_1_date |
3.51%
|
||
| review_1_rating |
3.51%
|
||
| review_1_text |
3.46%
|
||
| review_2_name |
1.29%
|
||
| review_2_date |
1.29%
|
||
| review_2_rating |
1.29%
|
||
| review_2_text |
1.25%
|
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.
