| 1 | NPI | number | |
| 2 | Entity Type Code | enumeration_type | |
| 3 | Replacement NPI | basic.replacement_npi | |
| 4 | Employer Identification Number (EIN) | basic.ein | |
| 5 | Provider Organization Name (Legal Business Name) | basic.organization_name | |
| 6 | Provider Last Name (Legal Name) | basic.last_name | |
| 7 | Provider First Name | basic.first_name | |
| 8 | Provider Middle Name | basic.middle_name | |
| 9 | Provider Name Prefix Text | basic.name_prefix | |
| 10 | Provider Name Suffix Text | basic.name_suffix | |
| 11 | Provider Credential Text | basic.credential | |
| 12 to 20 | Provider Other Organization Name | | Not Used |
| 21 | Provider First Line Business Mailing Address | addresses[1].address_1 | |
| 22 | Provider Second Line Business Mailing Address | addresses[1].address_2 | |
| 23 | Provider Business Mailing Address City Name | addresses[1].city | |
| 24 | Provider Business Mailing Address State Name | addresses[1].state | |
| 25 | Provider Business Mailing Address Postal Code | addresses[1]. postal_code | |
| 26 | Provider Business Mailing Address Country Code (If outside U.S.) | addresses[1].country_code | |
| 27 | Provider Business Mailing Address Telephone Number | addresses[1].telephone_number | |
| 28 | Provider Business Mailing Address Fax Number | addresses[1]. fax_number | |
| | CONSTANT VALUE | addresses[1].address_purpose | "MAILING" |
| 29 | Provider First Line Business Practice Location Address | addresses[0].address_1 | |
| 30 | Provider Second Line Business Practice Location Address | addresses[0].address_2 | |
| 31 | Provider Business Practice Location Address City Name | addresses[0].city | |
| 32 | Provider Business Practice Location Address State Name | addresses[0].state | |
| 33 | Provider Business Practice Location Address Postal Code | addresses[0]. postal_code | |
| 34 | Provider Business Practice Location Address Country Code (If outside U.S.) | addresses[0].country_code | |
| 35 | Provider Business Practice Location Address Telephone Number | addresses[0].telephone_number | |
| 36 | Provider Business Practice Location Address Fax Number | addresses[0]. fax_number | |
| | CONSTANT VALUE | addresses[0].address_purpose | "LOCATION" |
| 37 | Provider Enumeration Date | basic.enumeration_date | |
| | DERIVED VALUE | created_epoch | Derived from Col 37 |
| 38 | Last Update Date | basic.last_updated | |
| | DERIVED VALUE | last_updated_epoch | Derived from Col 38 |
| 39 | NPI Deactivation Reason Code | basic.deactivation_reason_code | |
| 40 | NPI Deactivation Date | basic.deactivation_date | |
| 41 | NPI Reactivation Date | basic.reactivation_date | |
| 42 | Provider Sex Code | basic.sex | |
| 43 | Authorized Official Last Name | basic.authorized_official_last_name | |
| 44 | Authorized Official First Name | basic.authorized_official_first_name | |
| 45 | Authorized Official Middle Name | basic.authorized_official_middle_name | |
| 46 | Authorized Official Title or Position | basic.authorized_official_title_or_position | |
| 47 | Authorized Official Telephone Number | basic.authorized_official_telephone_number | |
| 48 | Healthcare Provider Taxonomy Code_1 | taxonomies[0].code | |
| 49 | Provider License Number_1 | taxonomies[0].license | |
| 50 | Provider License Number State Code_1 | taxonomies[0].state | |
| 51 | Healthcare Provider Primary Taxonomy Switch_1 | taxonomies[0].primary | |
| | DERIVED VALUE | taxonomies[0].desc | Derived from code |
| *** | *** | *** | |
| 104 | Healthcare Provider Taxonomy Code_15 | taxonomies[14].code | |
| 105 | Provider License Number_15 | taxonomies[14].license | |
| 106 | Provider License Number State Code_15 | taxonomies[14].state | |
| 107 | Healthcare Provider Primary Taxonomy Switch_15 | taxonomies[14].primary | |
| | DERIVED VALUE | taxonomies[14].desc | Derived from code |
| 108 | Other Provider Identifier_1 | identifiers[0].identifier | |
| 109 | Other Provider Identifier Type Code_1 | identifiers[0].code | |
| 110 | Other Provider Identifier State_1 | identifiers[0].state | |
| 111 | Other Provider Identifier Issuer_1 | identifiers[0].issuer | |
| | DERIVED VALUE | identifiers[0].desc | Derived from code |
| *** | *** | *** | |
| 304 | Other Provider Identifier_50 | identifiers[49].identifier | |
| 305 | Other Provider Identifier Type Code_50 | identifiers[49].code | |
| 306 | Other Provider Identifier State_50 | identifiers[49].state | |
| 307 | Other Provider Identifier Issuer_50 | identifiers[49].issuer | |
| | DERIVED VALUE | identifiers[49].desc | Derived from code |
| 308 | Is Sole Proprietor | basic.sole_proprietor | |
| 309 | Is Organization Subpart | basic.organizational_subpart | |
| 310 | Parent Organization LBN | basic.parent_organization_legal_business_name | |
| 311 | Parent Organization TIN | basic.parent_organization_ein | |
| 312 | Authorized Official Name Prefix Text | basic.authorized_official_name_prefix | |
| 313 | Authorized Official Name Suffix Text | basic.authorized_official_name_suffix | |
| 314 | Authorized Official Credential Text | basic.authorized_official_credential | |
| 315 | Healthcare Provider Taxonomy Group_1 | taxonomies[0].taxonomy_group | |
| *** | *** | *** | |
| 329 | Healthcare Provider Taxonomy Group_15 | taxonomies[14].taxonomy_group | |
| 330 | Certification Date | basic.certification_date | |