Ready for your workflow

Flexible data delivery

Delivered files
UTF-8 CSV, JSON, SQLite, schemas, samples, statistics, documentation, and tier-specific ZIP bundles.
Updates
Current release 2.0.0 dated October 23, 2026. Update eligibility follows the selected license.
Preview sample data
Choose your licensePurchase once. Download immediately.
Secure checkout
Usage RightsInternal use within your organization, including importing, combining and transforming provider records. The separate restrictions on Health Care Provider Taxonomy values remain in force.
$40.00
Master RightsPublication rights plus permitted raw or transformed dataset handoff within a genuine client engagement, subject to consistent downstream terms. Standalone dataset resale is excluded. The separate restrictions on Health Care Provider Taxonomy values remaiCurrent update offer$10.00For eligible earlier Master purchases
$160.00
Records
65,235
Version
2.0.0
Release date
Oct 23, 2026
Before you choose
Explore the samples

Current release story

Latest update

Version 2.0.0 October 24, 2026 Build #188

U.S. Optometrists Database 2.0.0: Providers, Locations, and Taxonomy

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.

U.S. Optometrists Database List

U.S. Optometrists Database v.2.0.0

65,235 Reported optometrist people


U.S. Optometrists Database catalog icon U.S. Optometrists Database Download
U.S. Optometrists Database artwork

Optometrist people, practice addresses and reported specialties

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.

The same data, the rights your project needs

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.

Useful facts with clear limits

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.

Explore the current release

Read the records and coverage guide, table import and joining guide, and rights and download guide for version 2.0.0.

65,235 Reported optometrist people Records
SAMPLE DATA TABLE STRUCTURE RECORD INFO
Lawyers and Law Firms Dentists Real Estate Agents Dentists Realtors

License Database Purchase Options

PUBLICATION

Publication Rights

$80.00

Publish and build for clients

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 above

MASTER

Master Rights

$160.00

Client dataset handoff

All Publication rights, plus raw or transformed dataset handoff within a genuine client project. Standalone dataset resale requires a separate addendum.

Current Master update offer$10.00For an eligible earlier Master purchase. The fee is checked again when a new release is available.

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 above

Table Schema Database Field Statistics

Release structure

U.S. Optometrists Database

Review the published tables, record coverage, and field names included with release 2.0.0.

Database
#18
Version
2.0.0
Format
XML schema

Data dictionary

Tables and fields

Release-defined structure
TableRecordsFields
providers65235npi, 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_locations78505location_id, npi, is_primary, address_line_1, address_line_2, city, state, postal_code, country_code, telephone, telephone_extension, fax
provider_taxonomies83257taxonomy_id, npi, slot, taxonomy_code, primary_flag, reported_license_number, reported_license_state, taxonomy_group

Release at a glance

What is inside this database

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.

65,235Providers
78,505Practice Locations
83,257Provider Taxonomies

Region

Showing the 12 largest groups from 64 represented values.

  • CA9,946
  • TX6,141
  • FL4,716
  • NY4,385
  • IL3,320
  • PA3,178
  • OH3,148
  • MI2,458
  • VA2,252
  • NC1,993
  • WA1,977
  • NJ1,915

Table and column statistics

Select a table to review its schema, record total and fields. Distinct counts exclude nulls. Missing counts include null and blank values where measured.

providers65,235 records · 21 fields
npi
Distinct
65,235
Missing
0 (0.0%)
last_name
Distinct
29,312
Missing
0 (0.0%)
first_name
Distinct
9,933
Missing
0 (0.0%)
middle_name
Distinct
6,751
Missing
20,397 (31.3%)
name_prefix
Distinct
6
Missing
26,427 (40.5%)
name_suffix
Distinct
10
Missing
64,007 (98.1%)
credentials
Distinct
451
Missing
3,877 (5.9%)
other_last_name
Distinct
3,893
Missing
59,963 (91.9%)
other_first_name
Distinct
1,891
Missing
59,963 (91.9%)
other_middle_name
Distinct
1,022
Missing
61,735 (94.6%)
other_name_prefix
Distinct
6
Missing
62,979 (96.5%)
other_name_suffix
Distinct
7
Missing
65,204 (100.0%)
other_credentials
Distinct
95
Missing
61,495 (94.3%)
sex_code
Distinct
4
Missing
0 (0.0%)
sole_proprietor
Distinct
2
Missing
0 (0.0%)
enumeration_date
Distinct
6,036
Missing
0 (0.0%)
last_update_date
Distinct
6,116
Missing
0 (0.0%)
certification_date
Distinct
2,351
Missing
39,028 (59.8%)
deactivation_date
Distinct
80
Missing
64,990 (99.6%)
reactivation_date
Distinct
102
Missing
64,990 (99.6%)
replacement_npi
Distinct
0
Missing
65,235 (100.0%)

Inspect the data

Representative sample data

Switch tables to review representative fields and rows from every table advertised for this release.

npilast_namefirst_namemiddle_namename_prefixname_suffixcredentialsother_last_nameother_first_nameother_middle_nameother_name_prefixother_name_suffixother_credentialssex_codesole_proprietorenumeration_datelast_update_datecertification_datedeactivation_datereactivation_datereplacement_npi
1003001298WARRENKASEYO.D.FY2007-09-112007-12-10
1053399774POSTKRISTINALYNNDR.O.D.NELLISKRISTINALODFN2006-01-032009-03-12
1104849769MILLERTERRILDR.O.D.FY2006-07-252008-07-24
1164101200SECHIFRANCESCODR.ODMN2023-07-172024-08-022024-08-02
1215243365CHENANN-CHIO.D.FN2010-08-272022-09-022022-09-02
1265589584HELSELJOHNERNESTDR.O.D.MY2007-01-052007-07-08
1316931694RICESTEPHANIEMICHELLEDR.O.D.FN2005-09-012026-05-062026-05-06
1376279356VERGESROBBILYNDR.ODFN2022-08-012022-08-292022-08-29
1427133362KROKOFFMYRAS.DR.O.D.FN2006-10-262007-07-08
1477618148AGARTHVERNONSANFORDDR.JR.O.D.MY2006-12-232007-07-08
1528816584MAYERABBEYFN2024-05-072024-11-132024-11-13
1588514194BONENFANTALEXISODFN2026-02-022026-06-042026-06-04
1639265556GRIGGSKRISTENSARADR.O.D.FN2006-10-052007-07-08
1689718140ARENCIBIARAULESTANISLAOO.D.MN2007-02-172007-07-08
1730708447KIMRACHELYDR.ODFN2020-04-132024-05-092024-05-09
1790073948TREMBLAYELIZABETHANNEDR.ODFN2011-07-202025-05-222025-05-22
1841241395LERNERMARCIEMILLERDR.O.D.FN2006-05-122017-12-19
1891739066GRADENTYMDR.ODMN2006-06-162026-07-13
1942524152VILLAR-ROMAGUERAYAMILELUCIADR.O.D.VILLARYAMILEDR.O.D.FY2010-03-162025-04-112025-04-11
1992999569YUENJENNYFO.D., F.A.A.OFY2007-08-282019-04-11

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.

Designed for business research, directory applications, mapping, and market analysis. Review permitted uses.

Need a closer fit?

Data shaped around your project.

Tell us your topic, geography, and required fields. We can help find a match or scope a custom package.

A clear path from download to project

Get more from your data

Understand the files, check the sample coverage, and choose the license that fits your use.

Oddity Support

How can we help?

Oddity Data Updates

Know when fresh data arrives.

Receive occasional notices about new and substantially updated database releases. No third-party mailing list.

Oddity Software

Details