Home / Method
Method
Every count on this site is computed from a full public file, never a sample. The rolls were pulled on 15 September 2026.
Rows read, kept and dropped
| Source | File | Rows read | Rows kept | What was kept | Dropped and why |
|---|---|---|---|---|---|
| NPPES full replacement, September 2026 | npi_slim_202609.csv |
9,798,758 | 2,409,308 | person-profession pairs across five professions | 355,329 rows with a blank entity type; 1,972,058 organisations; 5,072,571 individuals whose 15 taxonomy slots hold no in-scope code |
| CMS Doctors and Clinicians national file | dac_national.csv |
3,388,628 | 2,270,109 | rows, 1,011,505 distinct physicians and NPs | 1,118,519 rows for 615,963 NPIs that are not an NPPES physician or nurse practitioner |
| Texas TDI producers | tx_tdi_producers.csv |
967,312 | 967,312 | licence rows | none |
| Texas TREC licence holders | tx_trec.csv |
324,715 | 324,715 | licence holders | none |
| Texas TBPELS PE roster | pe_roster.csv |
79,590 | 70,955 | active PEs | 8,635 inactive |
| Illinois IDFPR | il_idfpr.csv |
4,282,409 | 511,060 | active rows in the 13 in-scope board types | 3,771,349 rows in other boards or not active |
| Washington L&I contractors | wa_contractors.csv |
161,242 | 75,837 | active registrations | 85,405 expired, suspended, out of business, re-licensed or deceased |
| Florida DFS individual licences | fl_licenses_individual.csv |
1,236,929 | 972,132 | distinct National Producer Numbers | none |
| Florida DFS active appointments, six files | fl_appt_*.csv |
3,150,536 | 3,150,536 | appointment rows | none |
| California DRE current licensees | CurrList.csv |
429,119 | 429,119 | current licences | none |
| BLS OEWS May 2025, national | national_M2025_dl.xlsx |
1,401 | 76 | in-scope SOC rows | out-of-scope occupations |
| BLS OEWS May 2025, state | state_M2025_dl.xlsx |
37,408 | 2,494 | in-scope SOC by area rows | out-of-scope occupations |
| NUCC provider taxonomy 26.1 | nucc_taxonomy_261.csv |
883 | 290 | in-scope taxonomy codes | codes outside the five professions |
Source: ProfessionLens, September 2026.
Checks against published figures
| Profession | Our count | Published figure | Published by |
|---|---|---|---|
| Dentists | 275,976 on NPPES | 205,088 professionally active dentists | ADA Health Policy Institute, 2025 |
| Physicians | 1,272,256 on NPPES | 1,082,187 actively licensed physicians | FSMB physician census, 2024 |
| Nurse practitioners | 530,577 on NPPES | more than 461,000 NPs | AANP, November 2025 |
| Pharmacists | 328,832 on NPPES | 321,970 employed | BLS OEWS, May 2025 |
| Architects | 10,501 active in Illinois | 9,804 in Illinois | NCARB, 2025 |
| CPAs | 40,044 active in Illinois | 650,667 actively licensed CPAs nationally | NASBA, August 2026 |
NPPES keeps a provider until the identifier is deactivated, so it sits above a count of people working in the profession.
Rules
- A count of fewer than 5 prints <5.
- A share whose base is under 20 prints n/a.
- Licence rows and people are labelled separately wherever one roll gives more rows than people.
- Every number on a page is in a sentence or a table cell, with the source and the count date next to it.
Not counted
| Not built | Reason |
|---|---|
| Attorneys | no open person-level roll was found in any state probed |
| CPAs outside Illinois | no bulk export |
| Financial advisers | the SEC and FINRA APIs answer name queries only |
| Executive titles | no open person-level roll was pulled, and there is no SOC code for COO, CFO, CMO, CTO or CHRO |
| Veterinarians | 1,667 of about 133,000 US vets hold an NPI, so NPPES covers 1.2% of the profession |
| Washington contractors by county | the dataset carries city and ZIP, no county |
| Florida boards other than insurance | the DBPR data mart is login-gated |
| California boards other than real estate | the DCA public information files are behind a Box share a script cannot reach |