U.S. Optometrists Database v.2.0.0
65,235 Reported optometrist people
AccountWelcome, guestSign in / Register
Current release story
A dated relational release with 65,235 NPPES-listed individual optometrists, 78,505 reported practice locations, and 83,257 taxonomy rows. See the table structure, source limits, and license choices.

Work with 65,235 reported individual optometrist records, 78,505 primary and additional practice-address rows, and 83,257 reported classification rows in practical joinable tables.
The dated October 4, 2026 directory covers people with reported U.S., territory or U.S. military practice addresses. Associated overseas addresses may also appear. A provider can have several locations, and several providers can share a location.
Usage, Publication and Master contain the same CSV, JSON and SQLite data, with schemas, samples, a field dictionary and exact table statistics. Choose internal use, customer-facing publication or permitted client dataset handoff under the applicable license.
Fields include reported names, credentials, addresses, telephone and fax details, classifications and license references where supplied. No email addresses, websites or coordinates are included. The directory does not verify current licensure, credentials, services, contactability or current practice. Confirm important details before relying on a record. Contact information does not establish consent for unsolicited marketing.
Read the records and coverage guide, table import and joining guide, and rights and download guide for version 2.0.0.
USAGE
Import, modify, combine and analyze within one organization, including work by supervised contractors.
Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.
Read the complete Oddity Software Usage License
Choose this package abovePUBLICATION
All Usage rights, plus customer-facing websites, apps, reports and client projects without bulk dataset handoff.
Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.
Read the complete Oddity Software Publication License
Choose this package aboveMASTER
All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.
Unlimited downloads of this purchased version while it remains current. A newer public release needs a separate purchase or offered update.
Read the complete Oddity Software Master License
Choose this package aboveRelease structure
Review the published tables, record coverage, and field names included with release 2.0.0.
Data dictionary
| Table | Records | Fields |
|---|---|---|
| providers | 65235 | npi, last_name, first_name, middle_name, name_prefix, name_suffix, credentials, other_last_name, other_first_name, other_middle_name, other_name_prefix, other_name_suffix, other_credentials, sex_code, sole_proprietor, enumeration_date, last_update_date, certification_date, deactivation_date, reactivation_date, replacement_npi |
| practice_locations | 78505 | location_id, npi, is_primary, address_line_1, address_line_2, city, state, postal_code, country_code, telephone, telephone_extension, fax |
| provider_taxonomies | 83257 | taxonomy_id, npi, slot, taxonomy_code, primary_flag, reported_license_number, reported_license_state, taxonomy_group |
Release at a glance
65,235 reported optometrist people and 78,505 practice-address rows. Related rows are not additional people. Snapshot through October 4, 2026; reported identifier activity is not licensure verification.
Showing the 12 largest groups from 64 represented values.
Select a table to review its schema, record total and fields. Distinct counts exclude nulls. Missing counts include null and blank values where measured.
Inspect the data
Switch tables to review representative fields and rows from every table advertised for this release.
| npi | last_name | first_name | middle_name | name_prefix | name_suffix | credentials | other_last_name | other_first_name | other_middle_name | other_name_prefix | other_name_suffix | other_credentials | sex_code | sole_proprietor | enumeration_date | last_update_date | certification_date | deactivation_date | reactivation_date | replacement_npi |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1003001298 | WARREN | KASEY | O.D. | F | Y | 2007-09-11 | 2007-12-10 | |||||||||||||
| 1053399774 | POST | KRISTINA | LYNN | DR. | O.D. | NELLIS | KRISTINA | L | OD | F | N | 2006-01-03 | 2009-03-12 | |||||||
| 1104849769 | MILLER | TERRI | L | DR. | O.D. | F | Y | 2006-07-25 | 2008-07-24 | |||||||||||
| 1164101200 | SECHI | FRANCESCO | DR. | OD | M | N | 2023-07-17 | 2024-08-02 | 2024-08-02 | |||||||||||
| 1215243365 | CHEN | ANN-CHI | O.D. | F | N | 2010-08-27 | 2022-09-02 | 2022-09-02 | ||||||||||||
| 1265589584 | HELSEL | JOHN | ERNEST | DR. | O.D. | M | Y | 2007-01-05 | 2007-07-08 | |||||||||||
| 1316931694 | RICE | STEPHANIE | MICHELLE | DR. | O.D. | F | N | 2005-09-01 | 2026-05-06 | 2026-05-06 | ||||||||||
| 1376279356 | VERGES | ROBBILYN | DR. | OD | F | N | 2022-08-01 | 2022-08-29 | 2022-08-29 | |||||||||||
| 1427133362 | KROKOFF | MYRA | S. | DR. | O.D. | F | N | 2006-10-26 | 2007-07-08 | |||||||||||
| 1477618148 | AGARTH | VERNON | SANFORD | DR. | JR. | O.D. | M | Y | 2006-12-23 | 2007-07-08 | ||||||||||
| 1528816584 | MAYER | ABBEY | F | N | 2024-05-07 | 2024-11-13 | 2024-11-13 | |||||||||||||
| 1588514194 | BONENFANT | ALEXIS | OD | F | N | 2026-02-02 | 2026-06-04 | 2026-06-04 | ||||||||||||
| 1639265556 | GRIGGS | KRISTEN | SARA | DR. | O.D. | F | N | 2006-10-05 | 2007-07-08 | |||||||||||
| 1689718140 | ARENCIBIA | RAUL | ESTANISLAO | O.D. | M | N | 2007-02-17 | 2007-07-08 | ||||||||||||
| 1730708447 | KIM | RACHEL | Y | DR. | OD | F | N | 2020-04-13 | 2024-05-09 | 2024-05-09 | ||||||||||
| 1790073948 | TREMBLAY | ELIZABETH | ANNE | DR. | OD | F | N | 2011-07-20 | 2025-05-22 | 2025-05-22 | ||||||||||
| 1841241395 | LERNER | MARCIE | MILLER | DR. | O.D. | F | N | 2006-05-12 | 2017-12-19 | |||||||||||
| 1891739066 | GRADEN | TY | M | DR. | OD | M | N | 2006-06-16 | 2026-07-13 | |||||||||||
| 1942524152 | VILLAR-ROMAGUERA | YAMILE | LUCIA | DR. | O.D. | VILLAR | YAMILE | DR. | O.D. | F | Y | 2010-03-16 | 2025-04-11 | 2025-04-11 | ||||||
| 1992999569 | YUEN | JENNY | F | O.D., F.A.A.O | F | Y | 2007-08-28 | 2019-04-11 |
| location_id | npi | is_primary | address_line_1 | address_line_2 | city | state | postal_code | country_code | telephone | telephone_extension | fax |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1003001298-P | 1003001298 | 1 | 5401 SOUTH FM 1626 | SUITE 135 | KYLE | TX | 78640 | US | 2812168193 | 5122683096 | |
| 1053436410-P | 1053436410 | 1 | 10 E STATE ST | REDLANDS | CA | 923734754 | US | 9097922280 | |||
| 1104878032-S1 | 1104878032 | 0 | 7900 Shelbyville Rd Ste A15 | Louisville | KY | 402225463 | US | 5023278568 | 5023270613 | ||
| 1164115622-P | 1164115622 | 1 | 633 MAIN ST | LEWISTON | ME | 042405938 | US | 2077838243 | |||
| 1215379268-P | 1215379268 | 1 | 8751 VALLEY VIEW ST STE A | BUENA PARK | CA | 906203566 | US | 7148277191 | |||
| 1265613186-P | 1265613186 | 1 | 1573 SOUTH WICKHAM ROAD | WEST MELBOURNE | FL | 329043540 | US | 3217238115 | 3217237388 | ||
| 1316902083-P | 1316902083 | 1 | 225 SUNSET RD | WILLINGBORO | NJ | 080461109 | US | 6098772800 | |||
| 1376141549-P | 1376141549 | 1 | 1300 BROADWAY | MARYSVILLE | KS | 665081821 | US | 7855625111 | |||
| 1427180553-P | 1427180553 | 1 | 960 BROOKWAY BLVD | BROOKHAVEN | MS | 396012644 | US | 6018234494 | 6018234551 | ||
| 1477656890-P | 1477656890 | 1 | 1765 CHALLENGE WAY | SUITE 200 | SACRAMENTO | CA | 958155097 | US | 9165670888 | 9165670969 | |
| 1538095245-P | 1538095245 | 1 | 777 E MERRITT ISLAND CSWY | MERRITT ISLAND | FL | 329523576 | US | 4077807303 | |||
| 1588508634-P | 1588508634 | 1 | 870 E CRAFTON ST | TAHLEQUAH | OK | 744643380 | US | 9184582109 | |||
| 1639424633-P | 1639424633 | 1 | 1475 UPPER VALLEY PIKE | SPRINGFIELD | OH | 455044047 | US | 9375259266 | 9375259633 | ||
| 1689773434-S2 | 1689773434 | 0 | 281 Lincoln St | Worcester | MA | 016052138 | US | 5083346855 | 5083346795 | ||
| 1730876467-P | 1730876467 | 1 | 490 ILLINOIS STREET | SAN FRANCISCO | CA | 94158 | US | 4153532020 | |||
| 1790210011-P | 1790210011 | 1 | 742 N 530 E | OREM | UT | 840974104 | US | 8012244799 | |||
| 1841285111-P | 1841285111 | 1 | 700 W KENT AVE | MISSOULA | MT | 598016772 | US | 4065413804 | 4065411810 | ||
| 1891719845-P | 1891719845 | 1 | 3061 N SHARON AMITY RD | CHARLOTTE | NC | 282056600 | US | 7045676755 | 7045670238 | ||
| 1942546676-P | 1942546676 | 1 | 1030 NORWOOD PARK BLVD STE A | AUSTIN | TX | 787536606 | US | 5124919797 | 5124919735 | ||
| 1992999569-S1 | 1992999569 | 0 | 195 Peabody St | San Francisco | CA | 94134 | US | 4152036866 |
| taxonomy_id | npi | slot | taxonomy_code | primary_flag | reported_license_number | reported_license_state | taxonomy_group |
|---|---|---|---|---|---|---|---|
| 1003001298-T01 | 1003001298 | 1 | 152W00000X | Y | 7109TG | TX | |
| 1053394932-T01 | 1053394932 | 1 | 152W00000X | Y | 185T | WY | |
| 1104824473-T01 | 1104824473 | 1 | 152W00000X | Y | OPC2162 | FL | |
| 1154843423-T02 | 1154843423 | 2 | 152WC0802X | N | 10397687-9934 | UT | |
| 1215085204-T01 | 1215085204 | 1 | 152W00000X | Y | OPT11674T | CA | |
| 1265528665-T02 | 1265528665 | 2 | 152WC0802X | N | 734-081T | LA | |
| 1316906373-T01 | 1316906373 | 1 | 152W00000X | Y | TUV007135-1 | NY | |
| 1376105700-T01 | 1376105700 | 1 | 152WC0802X | N | 3576-35 | WI | |
| 1427109099-T01 | 1427109099 | 1 | 152W00000X | Y | 2117 | OK | |
| 1477632065-T01 | 1477632065 | 1 | 152W00000X | Y | 1758 | MN | |
| 1528955051-T01 | 1528955051 | 1 | 152W00000X | Y | OPT.0004124 | CO | |
| 1588595177-T01 | 1588595177 | 1 | 152W00000X | Y | 11758 | TX | |
| 1639297245-T01 | 1639297245 | 1 | 152W00000X | Y | MA 3792 | MA | |
| 1689739005-T01 | 1689739005 | 1 | 152W00000X | Y | 788 | NE | |
| 1740057280-T01 | 1740057280 | 1 | 152W00000X | N | 005844 | NY | |
| 1790205581-T02 | 1790205581 | 2 | 152W00000X | N | 2017017941 | MO | |
| 1841251238-T01 | 1841251238 | 1 | 152W00000X | N | TUV006592-1 | NY | |
| 1891748067-T01 | 1891748067 | 1 | 152W00000X | Y | 3576/T1280 | OH | |
| 1942614813-T01 | 1942614813 | 1 | 152W00000X | Y | OPT.0003052 | CO | |
| 1992999569-T01 | 1992999569 | 1 | 152W00000X | Y | 13357T | CA |
providers: 65,235 rows, 21 fields; practice_locations: 78,505 rows, 12 fields; provider_taxonomies: 83,257 rows, 8 fields. Providers are the primary record count. Related locations and classifications are not additional people.
Need a closer fit?
A clear path from download to project
Understand the files, check the sample coverage, and choose the license that fits your use.