Alabama Healthcare Provider Data from CarePrecise
Update released    
December 19, 2019    
Compare All Healthcare Provider Database Products

States, territories and countries available separately

Alabama Healthcare Provider Database


CarePrecise Access Alabama delivers every data point for Alabama healthcare providers contained in the comprehensive CarePrecise Access Complete U.S. Healthcare Provider Database — all 63,536 provider records — including the complete federal NPI healthcare provider registry data, enhanced with data from the federal PECOS (Medicare) database and other sources. These are the same HCP data fields as in CarePrecise Access Complete, but for an individual state, with the added bonus of an easy-to-use Excel file with basic information on all HIPAA-covered healthcare practitioners in Alabama, including physicians, hospitals, etc. See the CarePrecise Access Complete page for additional description, or to review purchasing the full U.S. database instead.


Every HIPAA-covered U.S. healthcare provider in Alabama is included:

  • Physicians and Surgeons (all specialties)
  • Nurses
  • Dentists and Oral Surgeons
  • Physical Therapists
  • Pharmacists
  • Mental Health Practitioners
  • Optometrists and Opticians
  • Technicians and Technologists
  • Hospitals
  • Urgent Care Centers
  • Clinics

Click here to privately send this page (no email addresses are revealed to us).

  • Nursing Facilities
  • Hospices
  • Public Health Departments
  • Nursing Agencies
  • Home Health Agencies
  • Laboratories
  • Pharmacies
  • DME Suppliers
  • Ambulance and Other Transport Providers
  • and all other healthcare providers
    in Alabama


Single download. If you wish to order a subscription, please call (877) 782-2294

1. Choose a Delivery Option:

2. Click to order:

FILE FORMATS: Every order is delivered in all of the following formats:

  • Microsoft Excel file with the most important data fields
  • Microsoft Access 2003, 2007, 2010, 2013, 2016, 365 (.mdb); normalized relational tables, plus an application database that links them for use. A free alternative to Microsoft Access is Open Office.
  • Comma Separated Values (.csv); normalized relational tables; identical data as in the Microsoft Access format.

ORDERING: Use the Order Form at right.

DELIVERY: Most orders can be delivered within one business day via a download link sent by email.


What's in the Microsoft Excel HCP file?

With CarePrecise State, you get both an Excel file with the most important data fields for healthcare providers in Alabama, plus a Microsoft Access file. The Excel file is a bonus available only with CarePrecise State and CarePrecise Select products, because there are more than 6 million records in the full U.S. database, and Excel can handle only about 1 million records.

The Excel file is a single flat file containing all of the facilities and medical providers' demographic information and primary specialty for the approximately 63,536 Alabama state healthcare provider records. The name and address fields are in proper case, ready for professional communications and upload to direct mail services. The phone and fax fields are formatted "888-888-8888" ready for upload to telemarketing and fax marketing services.

Click to download sample Excel and text flat files (samples for specific states are not available; samples are not live updated data)...

Excel Healthcare Provider Data Layout (scroll horizontally to view all columns)

NPI EntityType Salutation AttnName Title CompanyName Addr1 Addr2 City State Zip County Gender PracPhone PracFax MailPhone MailFax EnumDate UpdateDate IsOrgSubpart IsSoleProp InPECOS Warning Group NamePrefix NameLast NameFirst NameMiddle NameSuffix Credential Taxo TaxoDescr Zip5 RuralUrban Wealth Latitude Longitude
National Provider Identifier number 1=Indiv, 2=Org Salutation Full Name Title CompanyName Practice Address 1 Practice Address 2 City State Zip+4 County M, F or unknown Practice Phone Practice Fax Mailing Phone Mailing Fax Date NPI was received Date records was last updated For Type 2: is division of org? Sole Proprietor? Enrolled to bill Medicare? May have infraction Is this a practice group record? Mr., Ms., etc. Last Name First Name Middle Name Jr., III, etc. Credential Taxonomy Code Taxonomy Description (Specialty) 5-digit zip code Rural, urban or other area Wealth level of service area Practice Zip Latitude Practice Zip Longitude


What's in the full Microsoft Access HCP database?

In addition to the easy-to-use Excel file, we include a Microsoft Access database with every one of the up to 390 data points in our CarePrecise Access Complete database, with comprehensive information on Alabama's approximately 63,536 HIPAA-covered healthcare providers.

The CarePrecise State Microsoft Access database is structured as separate normalized relational database tables, each keyed by the National Provider Identifier (NPI) number, plus a core Microsoft Access database that links the ten files together and includes query examples, and CSV versions of the normalized data files.

Click to download sample Microsoft Access and relational CSV files (samples for specific states are not available; samples are not live updated data)...

Microsoft Access Healthcare Provider Database Layout (scroll vertically to view all)

Click for a printer-friendly version of the fields list.

CarePrecise Data Tables & Fields Use scrollbar at right of box to view all tables and fields ¬
TABLE CarePrecise fieldname Description of field, and/or source fieldname Additional information
tAddresses NPI National Provider Identifier (unique National Provider Identifier assigned to healthcare providers by the US Department of Health and Human Services)

Relational Key

The NPI is a unique 10-digit numerical code assigned to every HIPAA-covered healthcare provider, including individuals and organizations, by the U.S. Department of Human Services, Centers for Medicare and Medicaid Services (CMS).


(Provider addresses; MDB and CSV formats) Mail1stAddr Provider First Line Business Mailing Address  
Mail2ndAddr Provider Second Line Business Mailing Address  
MailCity Provider Business Mailing Address City Name
MailState Provider Business Mailing Address State Code  
MailZip Provider Business Mailing Address Postal Code (most are 9-digit Zip Codes)  
MailCountry Provider Business Mailing Address Country Code (If outside U.S.)  
Prac1stAddr Provider First Line Business Practice Location Address  
Prac2ndAddr Provider Second Line Business Practice Location Address  
PracCity Provider Business Practice Location Address City Name  
PracState Provider Business Practice Location Address State Code    
PracZip Provider Business Practice Location Address Postal Code (most are 9-digit Zip Codes)  
PracCountry Provider Business Practice Location Address Country Code (If outside U.S.)


tEntity NPI National Provider Identifier Relational Key
(Provider entity and record information; MDB and CSV formats) EntityType Entity Type Code

Type 1 indicates an individual provider (i.e., physician, psychologist, etc.); Type 2 indicates an organizational provider (i.e., hospital, lab, pharmacy, etc.)


ReplacementNPI Replacement NPI  
EIN Employer Identification Number (EIN) CMS is not yet providing tax numbers of this type
EnumDate Provider Enumeration Date  
UpdateDate Last Update Date Date this provider NPI record was last updated
DeactReason NPI Deactivation Reason Code Not currently populated
DeactDate NPI Deactivation Date Not populated because records in the current dataset are not deactivated. This field IS populated in the separate delta table tEntity_DEACT, described below.
ReactDate NPI Reactivation Date Not currently populated
Gender Provider Gender Code M or F for Type 1 providers
IsSoleProp Is Sole Proprietor Y = provider operates as a sole proprietor. No = not a sole proprietorship. X = question not answered by provider.
IsOrgSubpart Is Organization Subpart

For Type 2 providers, may be one of several organizational units, each with its own NPI number. Y = provider is a subpart. No = not a subpart. X = question not answered.

ParentOrgTIN Parent Organization TIN

CMS is not yet providing tax numbers of this type


InPECOS From monthly CMS PECOS distributions of PECOS-enrolled providers. Source: PECOS file distribution, linkage derived algorithmically* beginning with December 2011 release.

Y = Physicians and non-physician practitioners who are of a type/specialty that is legally eligible to order and refer in the Medicare program and who have current enrollment records in Medicare (i.e., they have enrollment records in PECOS)



From the Office of Inspector General's excluded providers database (LEIE). A warning in this field should not be taken as definitive; the user should check the tExcluded table and consider other sources of provider fraud and exclusion information. (Algorithmically derived*).


Y= elements in the providers record indicated a match with a listing in the federal excluded providers database (see the table tExcluded below)



The exclusion type from the LEIE database, explaining the reason that a provider was barred from billing Medicare. Fields with a Y in the Warning field will display this code.


The code's definition can be found at this link. A CSV file listing these exclusion descriptions is included in the CarePrecise Access Complete CSV download file.


UPIN UPIN is a deprecated identifier, no longer used. CMS has stopped disseminating this data. The field remains here for purposes of backward-compatibility.  
Group From NPPES group taxonomy data.

Y= this provider reported that it operates as either a multi-specialty group or single-specialty group.


tHumanNames NPI National Provider Identifier Relational Key
(Provider human names, esp. Type 1 individual providers; MDB and CSV formats) LN Provider Last Name (Legal Name) The enumerated provider's name
FN Provider First Name
MN Provider Middle Name
PN Provider Name Prefix Text
SN Provider Name Suffix Text
Cred Provider Credential Text
OthLN Provider Other Last Name "AKA" name: Nee name, nickname, etc.
OthFN Provider Other First Name
OthMN Provider Other Middle Name
OthPN Provider Other Name Prefix Text
OthSN Provider Other Name Suffix Text
OthCred Provider Other Credential Text
OthLNType Provider Other Last Name Type Code
AuthLN Authorized Official Last Name

Name of the provider's authorizing official, if other than the listed individual provider. For organizations, this is the contact name.

AuthFN Authorized Official First Name
AuthMN Authorized Official Middle Name
AuthTitle Authorized Official Title or Position
AuthPN Authorized Official Name Prefix Text
AuthSN Authorized Official Name Suffix Text
AuthCred Authorized Official Credential Text


tOID NPI National Provider Identifier Relational Key
(Other identifiers, such as UPIN, OSCAR, PIN, Medicaid, etc., excluding NPI and taxonomy codes; MDB and CSV formats) OtherID Other Provider Identifier  
OtherIDType Other Provider Identifier Type Code
Description OtherIDType
OtherIDState Other Provider Identifier State In the case of a state license code, this is the licensing state
OtherIDIssuer Other Provider Identifier Issuer  
OIDnum Source: Added by CarePrecise to indicate the original NPPES flat file Other Identifiers field number. The number of the NPPES Other Identifier field (1 through 50)


tOrgNames NPI National Provider Identifier Relational Key

(Provider organization names, esp. Type 2 providers; MDB and CSV formats)


OrgName_LBN Provider Organization Name (Legal Business Name) LBN
OthOrgName Provider Other Organization Name Other
OthOrgNameType Provider Other Organization Name Type Code
Description Type
Unexplained (both)
Former Name (indiv)
Professional Name (indiv)
Doing Business As (org)
Former LBN (org)
Other Name (both)
ParentOrgLBN Parent Organization LBN


tPhoneFax NPI National Provider Identifier Relational Key

(Provider phone and fax numbers; MDB and CSV formats)


MailPhone Provider Business Mailing Address Telephone Number  
MailFax Provider Business Mailing Address Fax Number  
PracPhone Provider Business Practice Location Address Telephone Number  
PracFax Provider Business Practice Location Address Fax Number  
AuthPhone Authorized Official Telephone Number


tTaxo NPI National Provider Identifier Relational Key

(Provider Taxonomy codes indicating specialties and subspecialties for Type 1/individual providers, and facility types for Type 2/organization providers; MDB and CSV formats)


Taxo Healthcare Provider Taxonomy Code  
Lic Provider License Number  
LicState Provider License Number State Code  
TaxoSwitch Healthcare Provider Primary Taxonomy Switch  

The number of the NPPES taxonomy field (1 through 15)


TaxoDescr   Taxonomy code description (the specialty/subspecialty in English)


tTaxoGroups NPI National Provider Identifier Relational Key
(Provider Taxonomy codes indicating group practices; MDB and CSV formats) Gnum

The source data (NPPES) permits group codes to be reported in up to 15 fields in this section. CarePrecise creates a 1-to-many table, listing each of a provider's reported taxonomy group codes in a separate record. The Gnum is the NPPES Group Taxonomy field number in which the code was reported, allowing the code be matched with the specific group specialty in the tTaxo table. For instance, a code in tTaxoGroup field Gnum 3 indicates a group practice of the specialty reported in Tnum 3 in the tTaxo table.


This is the newest of the data released by CMS in the NPPES file. This is where the group taxonomy codes are reported. CMS does not report the codes in the taxonomy section (which appear in our tTaxo table) because they represent an additional layer of information on any one or more of the tTaxo codes.


  TaxoGroup Healthcare Provider Taxonomy Group_[1 through 15]

193200000X for a multi-specialty practice
193400000X for a single-specialty practice


tCoLoCode NPI National Provider Identifier Relational Key
(MDB and CSV formats) CoLoCode

Provider CoLoCode™ (co-location code, a CarePrecise algorithmically derived* exclusive). The NPI and CoLoCode comprise the dual relational key for this table. The NPI identifies the provider record, and the CoLoCode identifies the physical location. The CoLoCode is an up to 40-character string that stands in for detailed location data, and is not intended to be sensical to the human viewer.


This code is an algorithmically derived conformation of the provider's practice location, permitting identification of providers who practice at the same location, for instance, physician groups, dental groups, radiology groups, etc. By using this table in conjunction with the tTaxoGroups table, it is possible to visualize the group entity (generally an organization) and its provider members.



Count of providers matching this co-location (algorithmically derived* conformation of the provider's practice location; see tCoLoCodes above). Indicates the number of providers practicing at this co-location.


tAdded NPI National Provider Identifier Relational Key

(MDB and CSV formats)

DateDiscovered   The CarePrecise processing date on which the added provider record was discovered. Corresponds to the most recent previous CMS update date on which the added provider data was included in the NPPES database.


tDropped NPI National Provider Identifier Relational Key

(MDB and CSV formats)


The CarePrecise processing date on which it was discovered that the provider record was dropped from the NPPES database. Corresponds to the most recent previous CMS update date on which the provider data was dropped from the NPPES database.


EntityType Entity Type Code

Type 1 is individual providers (i.e., physicians, psychologists, etc.); Type 2 is organizational providers (i.e., hospitals, labs, etc.)



This is a generated field based on EntityType.


Prac1stAddr Provider First Line Business Practice Location Address  
Prac2ndAddr Provider Second Line Business Practice Location Address  
PracCity Provider Business Practice Location Address City Name  
PracState Provider Business Practice Location Address State Name

The federal data contains variations on state codes, abbreviations and full state names; we conform this field to standard 2-character state codes. A small number of non-US postal addresses remain nonconforming.


PracZip Provider Business Practice Location Address Postal Code  
PracCountry Provider Business Practice Location Address Country Code (If outside U.S.)  
PracPhone Provider Business Practice Location Address Telephone Number  
EnumDate Provider Enumeration Date  
UpdateDate Last Update Date Date this provider NPI record was last updated



LN Last name (Type 1 providers)

This table, sourced from the LEIE, lists all provider records in the federal excluded providers database. A provider may be excluded (barred from billing Medicare) for reasons of a criminal nature, among other reasons. This table contains no relational key; however, it is used to produce the Warning field in the tEntity table, which does include the provider's NPI. This table should be referenced for backup information.


(MDB and CSV formats) FN First name (Type 1 providers)
MN Middle Name (Type 1 providers)
OrgName Organization name (Type 2 providers)
Addr Street address
City City
State State
Zip Zip Code
DOB Date of Birth (currently unpopulated)
General Provider category
Specialty Provider specialty
UPIN Federal physician identifier code (legacy)
ExclType Exclusion type (why provider was excluded)
ExclDesc Exclusion Description
ExclDate Date provider was excluded (YYYYMMDD)


* Algorithmically derived data in the CPAC dataset includes data that is extracted/mined from the source databases, but which has a margin of error and should not be relied upon as conclusive. Record linking algorithms are used to enrich our data when direct correlation (via a unique identifier field) is not available, using available information in name, address, phone, taxonomy, and other fields. In particular, the data on providers excluded from billing Medicare (from the HHS Office of Inspector General's excluded providers database) can only be linked to NPI records by this means. Please note that when matches are found, there may be instances where an individual or firm has the same or similar name and location information as an excluded provider but is actually a different party. Therefore, it is important that you verify a potential match with the debarring agency identified in the record information. In like manner, the available federal data does not provide information on an individual provider's practice group(s); using record-linkage technology, we extract the group information by matching providers sharing the same practice location, and these group data can be corroborated or enriched with the group practice codes provided by CMS.



MORE INFORMATION: Contact sales at (877) 782-2294,


NOTICE: The data contained in CarePrecise® products and services is compiled and processed on an ongoing basis, with monthly update releases, from public and proprietary sources, including the complete National Plan & Provider Enumeration System (NPPES) data submitted by the providers themselves, Medicare Provider Enrollment Chain and Ownership System (PECOS), List of Excluded Individuals/Entities (LEIE), Medicare claims data, and other US federal sources obtainable under the Freedom of Information Act (FOIA) and provided monthly by the U.S. Department of Health and Human Services Services and Office of Inspector General of the U.S. Department of Health and Human Services, and from the U.S. Census Bureau, a division of the U.S. Department of Commerce, agencies of the U.S. federal government, and the United States Postal Service (USPS). Neither CarePrecise nor its shareholders, partners and affiliates are responsible for data maintained by these or other source providers. All HIPAA-covered entity healthcare providers in the U.S. are required under the Federal NPI regulation to provide their information to the NPI Registry, a federal database of healthcare providers, and to update their records within thirty days of any change in that information. Data is provided "as is" and in accordance with the Freedom of Information Act (FOIA) and e-FOIA ammendments, and relevant data dissemination notices. While these sources are considered among the most reliable available, no warranty is expressed or implied as to the accuracy, completeness, timeliness, fitness for any purpose, or absence of processing errors of the information presented here or in any CarePrecise product or service, nor that the data structure will not be changed in the future as necessitated by source data, beyond the diligent effort to include all released data. Nothing in the product descriptions, in writing or verbal, may be construed as a warranty, guarantee, or representation of deliverability, save the deliverability guarantee on email addresses. All data ages between updates, and it is reasonable to expect that a portion of records will contain contact information that is incorrect or for other reasons undeliverable. Not all fields are populated with data for every record except where indicated; some fields are not populated due to restrictions imposed by a data supplier even though a field may be present for later use. Where percent of records populated is quoted, the percent quoted is subject to slight differences upon delivery as data is continuously updated. To determine a provider's eligibility to practice and/or to bill Medicare or other health plans and carriers, or to in any other way perform professional activities, users should not rely solely on data included in CarePrecise datasets, particularly regarding alleged fraudulent or infraction activity given as reason for listing in data on excluded providers (records carrying "sanction", "desanction", "warning" and/or "exclusion" identifiers or flags). Data which has been in-matched using algorithmic rather than direct means will include a percentage of error; such data is labeled as such in the documentation. Algorithmic in-matching logic and processes are proprietary trade secrets. Subscriptions are fullfilled with quarterly or monthly releases containing the most recently released data from all pertinent sources. CarePrecise is a registered trademark, and CarePrecise Access, CarePrecise Select, CarePrecise Gold, CarePrecise Platinum, CP ListMaker, CP ChangeMaker, SharpMail, Authoritative Physician Database, and Authoritative Hospital Database are trademarks of CarePrecise LLC. All CarePrecise products including data, data structures, code, and related materials are the property of CarePrecise LLC and protected by U.S. and international copyright. Other trademarks and copyrights are the property of their respective owners. CarePrecise reserves the right to cease services and/or communication with parties that abuse its services or its personnel, or fail to comply with its terms of service. For additional information on CarePrecise policies see the Policies page. Purchase of a CarePrecise product affirms understanding and acceptance of these policies and this information, and affirms that use will conform to the product's license agreement. Pricing for CarePrecise products published on its website are licensed for a single user. Any form of dissemination, sharing, making public, distribution, or derivative product, whether or not for profit, is strictly forbidden without an alternative licensing arrangement; such licensing arrangements are available - please contact CarePrecise Sales for terms and pricing.

Policies and Terms of Use