License Database Purchase Options
USAGE RIGHTS $40.00 |
PUBLICATION RIGHTS $80.00 |
MASTER RIGHTS $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 |
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, including, but not limited to, fitting and prescribing spectacles and contact lenses, treating minor ocular injuries, diagnosing and treating diseases such as glaucoma and diagnosing others such as diabetic retinopathy. In some states in the United States, optometrists are allowed to perform certain laser procedures. In the United States, ophthalmologist and optometrist are specific terms referring to specific state licensing and courses of professional study. Optometrists receive the Doctor of Optometry (OD) degree, and some go on to complete residencies. Ophthalmologists are medical doctors (MD or DO) who have completed medical school followed by a 3-4 year residency in ophthalmology and have received board certification.
Table Schema Database Field Statistics
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 |