Data Dictionary
1. Main Provider File · npidata_pfile_*.csv
One row per NPI. Repeating groups use a _N suffix; positions reflect the CSV column order (330 columns total).
1
NPI
Unique 10-digit National Provider Identifier assigned by CMS. Primary key of the file.
—
2
Entity Type Code
1 = Individual, 2 = Organization. Blank only for deactivated records.
Entity Type
3
Replacement NPI
If this NPI was deactivated and replaced, the replacement NPI. Blank otherwise.
—
4
Employer Identification Number (EIN)
IRS EIN of the provider. SUPPRESSED in the public file for privacy.
—
5
Provider Organization Name (Legal Business Name)
Official legal business name of the organization. V.2 expanded this field's length.
—
6
Provider Last Name (Legal Name)
Legal last (family) name of the individual provider.
—
7
Provider First Name
Legal first (given) name. V.2 expanded this field's length.
—
8
Provider Middle Name
Middle name or initial of the individual provider.
—
9
Provider Name Prefix Text
Name prefix (e.g., Dr., Mr., Ms.).
Name Prefix
10
Provider Name Suffix Text
Name suffix (e.g., Jr., Sr., III).
Name Suffix
11
Provider Credential Text
Professional credential(s), e.g., MD, DO, NP, PA.
—
12
Provider Other Organization Name
Single alternate organization name (DBA, former name, etc.).
—
13
Provider Other Organization Name Type Code
Type of the alternate organization name (3, 4, 5).
Other Name Type
14
Provider Other Last Name (Legal Name)
Alternate last name of an individual provider.
—
15
Provider Other First Name
Alternate first name of an individual provider.
—
16
Provider Other Middle Name
Alternate middle name of an individual provider.
—
17
Provider Other Name Prefix Text
Name prefix for the alternate individual name.
Name Prefix
18
Provider Other Name Suffix Text
Name suffix for the alternate individual name.
Name Suffix
19
Provider Other Credential Text
Professional credential for the alternate individual name.
—
20
Provider Other Last Name Type Code
Type of the alternate individual name (1, 2, 5).
Other Name Type
21
Provider First Line Business Mailing Address
Street address line 1 of the mailing address.
—
22
Provider Second Line Business Mailing Address
Street address line 2 (suite, floor, PO box) of the mailing address.
—
23
Provider Business Mailing Address City Name
City of the mailing address.
—
24
Provider Business Mailing Address State Name
State/territory code of the mailing address.
State Codes
25
Provider Business Mailing Address Postal Code
ZIP/postal code (USPS 9-digit; may include ZIP+4).
—
26
Provider Business Mailing Address Country Code (If outside U.S.)
ISO country code; populated only when outside the U.S.
Country Codes
27
Provider Business Mailing Address Telephone Number
Phone number for the mailing address.
—
28
Provider Business Mailing Address Fax Number
Fax number for the mailing address.
—
29
Provider First Line Business Practice Location Address
Street address line 1 of the primary practice location.
—
30
Provider Second Line Business Practice Location Address
Street address line 2 of the primary practice location.
—
31
Provider Business Practice Location Address City Name
City of the primary practice location.
—
32
Provider Business Practice Location Address State Name
State/territory code of the primary practice location.
State Codes
33
Provider Business Practice Location Address Postal Code
ZIP/postal code of the primary practice location.
—
34
Provider Business Practice Location Address Country Code (If outside U.S.)
ISO country code; populated only when outside the U.S.
Country Codes
35
Provider Business Practice Location Address Telephone Number
Phone number at the primary practice location.
—
36
Provider Business Practice Location Address Fax Number
Fax number at the primary practice location.
—
37
Provider Enumeration Date
Date the NPI was first assigned (MM/DD/YYYY).
—
38
Last Update Date
Most recent date any field on the record changed (MM/DD/YYYY).
—
39
NPI Deactivation Reason Code
Reason the NPI was deactivated, if applicable.
Deactivation Reason
40
NPI Deactivation Date
Date the NPI was deactivated. Blank for active providers.
—
41
NPI Reactivation Date
Date the NPI was reactivated after a prior deactivation.
—
42
Provider Sex Code
Sex of an individual provider (formerly 'Provider Gender Code'). Not used for organizations.
Sex
43
Authorized Official Last Name
Last name of the official authorized to act for the organization.
—
44
Authorized Official First Name
First name of the authorized official.
—
45
Authorized Official Middle Name
Middle name or initial of the authorized official.
—
46
Authorized Official Title or Position
Job title/position of the authorized official (e.g., CEO, CFO).
—
47
Authorized Official Telephone Number
Phone number of the authorized official.
—
48–107
Healthcare Provider Taxonomy Code_N
NUCC taxonomy code classifying provider type/specialization (e.g., 207Q00000X). Interleaved per occurrence with the three fields below.
Taxonomy (NUCC)
48–107
Provider License Number_N
State-issued license number for the taxonomy at the same position.
—
48–107
Provider License Number State Code_N
State that issued the license at the same position.
State Codes
48–107
Healthcare Provider Primary Taxonomy Switch_N
Y if this is the provider's primary taxonomy (only one Y per NPI).
Primary Taxonomy Switch
108–307
Other Provider Identifier_N
Legacy/plan-specific identifier (e.g., Medicaid ID). Masked: SSN=$$$$$$$$$, ITIN=*********, EIN=========.
—
108–307
Other Provider Identifier Type Code_N
Type/issuer system of the identifier at the same position.
Other Provider ID Type
108–307
Other Provider Identifier State_N
State code for the identifier (used when issued by a state Medicaid plan).
State Codes
108–307
Other Provider Identifier Issuer_N
Name of the plan/organization that issued the identifier.
—
308
Is Sole Proprietor
Whether the individual operates as a sole proprietor (Y/N/X).
Sole Proprietor
309
Is Organization Subpart
Whether the organization is a subpart of a larger parent (Y/N/X).
Subpart
310
Parent Organization LBN
Legal Business Name of the parent organization. SUPPRESSED in the public file.
—
311
Parent Organization TIN
Tax ID of the parent organization. SUPPRESSED in the public file.
—
312
Authorized Official Name Prefix Text
Name prefix of the authorized official.
Name Prefix
313
Authorized Official Name Suffix Text
Name suffix of the authorized official.
Name Suffix
314
Authorized Official Credential Text
Professional credential of the authorized official.
—
315–329
Healthcare Provider Taxonomy Group_N
Grouping code for the taxonomy at the same position (e.g., 193200000X).
Group Taxonomy
330
Certification Date
Date the provider certified the application information is accurate.
—
2. Practice Location Reference File · pl_pfile_*.csv
Non-primary practice locations for Type 1 & Type 2 NPIs. Join back to the main file on NPI.
1
NPI
NPI of the provider for this secondary location. Join key to the main file.
2
Provider Secondary Practice Location Address – Address Line 1
Street address line 1 of the secondary location.
3
Provider Secondary Practice Location Address – Address Line 2
Street address line 2 (suite, floor, etc.).
4
Provider Secondary Practice Location Address – City Name
City of the secondary location.
5
Provider Secondary Practice Location Address – State Name
State/territory code of the secondary location.
6
Provider Secondary Practice Location Address – Postal Code
ZIP/postal code (may include ZIP+4).
7
Provider Secondary Practice Location Address – Country Code (If outside U.S.)
ISO country code; populated only when outside the U.S.
8
Provider Secondary Practice Location Address – Telephone Number
Phone number at the secondary location.
9
Provider Secondary Practice Location Address – Telephone Extension
Phone extension at the secondary location.
10
Provider Practice Location Address – Fax Number
Fax number at the secondary location.
3. Other Names Reference File · othername_pfile_*.csv
Additional 'other names' for Type 2 (organization) NPIs beyond the one stored in the main file.
1
NPI
NPI of the organizational provider this name belongs to. Join key to the main file.
2
Provider Other Organization Name
The alternate organization name (DBA, former name, etc.).
3
Provider Other Organization Name Type Code
Type of the alternate name (3 = DBA, 4 = Former Legal Business Name, 5 = Other Name).
4. Endpoint Reference File · endpoint_pfile_*.csv
Health IT endpoints (Direct messaging, FHIR servers, HIE, etc.) associated with NPIs.
1
NPI
NPI of the provider this endpoint belongs to. Join key to the main file.
2
Endpoint Type
Short code/label for the endpoint type (e.g., DIRECT, FHIR).
3
Endpoint Type Description
Full descriptive name of the endpoint type.
4
Endpoint
The actual endpoint address (Direct email, FHIR/web-services URL, etc.).
5
Affiliation
Whether the endpoint is affiliated with another organization (Y/N).
6
Endpoint Description
Free-text description of the endpoint and its purpose.
7
Affiliation Legal Business Name
Legal Business Name of the affiliated organization (when Affiliation = Y).
8
Use Code
Short code for the endpoint's use (e.g., DIRECTMESSAGING).
9
Use Description
Full description of the endpoint's use.
10
Other Use Description
Free-text description when Use Code is 'Other'.
11
Content Type
Short code for content exchanged (e.g., CCD).
12
Content Description
Full description of the content type.
13
Other Content Description
Free-text description when Content Type is 'Other'.
14
Affiliation Address Line One
Street address line 1 of the affiliated organization.
15
Affiliation Address Line Two
Street address line 2 of the affiliated organization.
16
Affiliation Address City
City of the affiliated organization.
17
Affiliation Address State
State of the affiliated organization.
18
Affiliation Address Country
ISO country code of the affiliated organization.
19
Affiliation Address Postal Code
Postal code of the affiliated organization.
Last updated