U.S. Optometrists Database v.1.0.9
31,157 Optometrists
AccountWelcome, guestSign in / Register
Optometrists are primary care practitioners for vision and ocular health concerns. They are trained to diagnose, manage, and treat a multitude of visual and ocular health-related concerns, i...
Ready for your workflow
![]() |
USAGE RIGHTS USAGE LICENSE $40.00 |
PUBLICATION RIGHTS PUBLICATION LICENSE $80.00 |
MASTER RIGHTS MASTER LICENSE $160.00 |
| Data Tracking Seeds | ![]() |
![]() |
![]() |
| Data Modification | ![]() |
![]() |
![]() |
| Importing | ![]() |
![]() |
![]() |
| Exporting | ![]() |
![]() |
![]() |
| Merge | ![]() |
![]() |
![]() |
| Web Usage | ![]() |
![]() |
![]() |
| Multiple PC's or Websites | ![]() |
![]() |
![]() |
| Mobile Development | ![]() |
![]() |
![]() |
| Updates Available | ![]() |
![]() |
![]() |
| All Data File Formats | ![]() |
![]() |
![]() |
| Custom File Formats | ![]() |
![]() |
![]() |
| Distribution | ![]() |
![]() |
![]() |
| Copyright Endorsement | ![]() |
![]() |
![]() |
| BUY NOW | BUY NOW | BUY NOW |
Release structure
Review the published tables, record coverage, and field names included with release 1.0.9.
Data dictionary
| Field | Records | Percent | Type | Comment |
|---|---|---|---|---|
| id | 31,157 | 100% | int(11) | Unique Identifier |
| biz_name | 31,157 | 100% | varchar(150) | Business Name |
| biz_info | 18,877 | 61% | text | Medicare Provider ID |
| cat_primary | 9,888 | 32% | varchar(75) | Business Primary Category |
| cat_sub | 9,583 | 31% | varchar(75) | Business Secondary/Sub Category |
| biz_phone | 31,102 | 100% | varchar(20) | Business Phone Number |
| biz_phone_ext | 0 | 0% | varchar(8) | Business Phone Number Extension |
| e_address | 31,093 | 100% | varchar(100) | Physical Address |
| e_city | 31,155 | 100% | varchar(50) | Physical Address City |
| e_state | 31,157 | 100% | varchar(20) | Physical Address State / Province |
| e_postal | 31,157 | 100% | varchar(7) | Physical Address Postal Code |
| e_zip_full | 26,787 | 86% | varchar(10) | Zip +4 for US Physical Addresses |
| e_country | 31,157 | 100% | varchar(20) | Physical Address Country |
| loc_county | 28,422 | 91% | varchar(40) | Physical Address County |
| loc_area_code | 28,067 | 90% | varchar(3) | Physical Address Area Code |
| loc_FIPS | 28,067 | 90% | varchar(5) | Federal Information Processing Standard - http://www.epa.gov/enviro/html/codes/state.html |
| loc_MSA | 12,561 | 40% | varchar(5) | Metropolitan Statistical Area - http://www.census.gov/population/www/metroareas/metrodef.html |
| loc_PMSA | 9,150 | 29% | varchar(5) | Primary Metropolitan Statistical Area - http://www.census.gov/epcd/www/g97geo2.htm |
| loc_TZ | 28,067 | 90% | varchar(6) | Location Time Zone |
| loc_DST | 31,157 | 100% | enum('Y','N','U') | Daylight Savings Time (Yes, No, Unknown) |
| loc_LAT_centroid | 28,067 | 90% | varchar(15) | Latitude (Centroid Based) |
| loc_LAT_poly | 31,106 | 100% | varchar(15) | Latitude (Precision Polygon Based) |
| loc_LONG_centroid | 28,067 | 90% | varchar(15) | Longitude (Centroid Based) |
| loc_LONG_poly | 31,106 | 100% | varchar(15) | Longitude (Precision Polygon Based) |
| web_url | 5,110 | 16% | varchar(255) | Website URL |
| web_meta_title | 84 | 0% | varchar(255) | Website Meta Title |
| web_meta_desc | 77 | 0% | varchar(255) | Website Meta Description |
| web_meta_keys | 76 | 0% | varchar(255) | Website Meta Keywords |
| Optometrists Records Information | |||
|---|---|---|---|
| USA | Alaska | 70 | Optometrists |
| USA | Alabama | 499 | Optometrists |
| USA | Arkansas | 352 | Optometrists |
| USA | Arizona | 378 | Optometrists |
| USA | California | 2,950 | Optometrists |
| USA | Colorado | 491 | Optometrists |
| USA | Connecticut | 415 | Optometrists |
| USA | District Of Columbia | 20 | Optometrists |
| USA | Delaware | 164 | Optometrists |
| USA | Florida | 1,683 | Optometrists |
| USA | Georgia | 709 | Optometrists |
| USA | Hawaii | 173 | Optometrists |
| USA | Iowa | 460 | Optometrists |
| USA | Idaho | 213 | Optometrists |
| USA | Illinois | 1,213 | Optometrists |
| USA | Indiana | 880 | Optometrists |
| USA | Kansas | 473 | Optometrists |
| USA | Kentucky | 456 | Optometrists |
| USA | Louisiana | 391 | Optometrists |
| USA | Massachusetts | 710 | Optometrists |
| USA | Maryland | 433 | Optometrists |
| USA | Maine | 219 | Optometrists |
| USA | Michigan | 1,163 | Optometrists |
| USA | Minnesota | 691 | Optometrists |
| USA | Missouri | 698 | Optometrists |
| USA | Mississippi | 279 | Optometrists |
| USA | Montana | 172 | Optometrists |
| USA | North Carolina | 913 | Optometrists |
| USA | North Dakota | 108 | Optometrists |
| USA | Nebraska | 242 | Optometrists |
| USA | New Hampshire | 170 | Optometrists |
| USA | New Jersey | 936 | Optometrists |
| USA | New Mexico | 190 | Optometrists |
| USA | Nevada | 174 | Optometrists |
| USA | New York | 1,612 | Optometrists |
| USA | Ohio | 1,539 | Optometrists |
| USA | Oklahoma | 446 | Optometrists |
| USA | Oregon | 409 | Optometrists |
| USA | Pennsylvania | 1,774 | Optometrists |
| USA | Rhode Island | 139 | Optometrists |
| USA | South Carolina | 388 | Optometrists |
| USA | South Dakota | 133 | Optometrists |
| USA | Tennessee | 705 | Optometrists |
| USA | Texas | 1,968 | Optometrists |
| USA | Utah | 271 | Optometrists |
| USA | Virginia | 799 | Optometrists |
| USA | Vermont | 89 | Optometrists |
| USA | Washington | 737 | Optometrists |
| USA | Wisconsin | 724 | Optometrists |
| USA | West Virginia | 235 | Optometrists |
| USA | Wyoming | 101 | Optometrists |