Welcome TO NPIDATASOURCE

The NPI database in Microsoft™ Sql Server®, MySql™, and PostGreSQL.

Database UPDATED: 11-November-2020

We also offer segments of the NPI database exported to Excel or Flat Files upon demand.



Features

easy to implement into your existing healthcare / research database infrastructure.

Monthly Updates.

FULLY RELATIONAL AND PERFORMANT.

OUr flat file extracts can be imported into virtually any system.

Sql-Server Products compatible with 2008-2019 (All Editions except express), and Azure Sql Database V11 and V12.

Practitioner PECOS Registration included.




excellent value.

sAMPLE databases available to download.

MySql Products; Compatible with Release 5.6 and above.

DE-NORMALIZED SEARCH TABLE OPTIMIZED FOR EXPEDIANT SEARCHES.

All data has been de-duplicated and properly cased.



Database Schema

Npi Database Diagram

Faqs


  • What format are the databases in?

    Sql-Server is in a standard ".BAK" file (Ver. 2008). MYSql is in a self-contained export file  (Ver. 5.7).  PostgreSQL is in a ".backup" file (Ver. 10.15).

  • How large are the downloads?

    Sql-Server is zipped into a ~5Gb. file. MYSql is zipped into a ~1.1Gb. file. PostgreSQL is a zipped ~1.2Gb. file.

  • How much database disk space does the NPI database require?

    The Sql-Server product is ~25Gb. The MYSql product is ~17Gb.

  • Is the Express edition of sql-server compatible?

    No, Sql-Server Express has a hard limit of 10Gb. of data file storage.

  • How often is the product updated?

    Every month on the same day the monthly full file is available on the NPPES site. The PECOS data is also updated at that time.

  • I downloaded the sample database...the schema has lots of foreign key constraints and indexes...Is it complicated?

    The schema is straightforward. All of the primary tables use the npi number as the primary key to join to one another. The indexes aid in performance.

  • What are the licensing requirements?

    The databases are distributed using the GPL License.

  • I searched for a provider and the address is incorrect, why?

    The only data manipulation we do is remove duplicates and properly case the names and such. The address is incorrect because that's the way it is in the origonal file. Properly cased columns include; First Name, Middle Name, Last Name, Address components, Organization names, and Contact names. The proper casing is performed so that address labels may be printed. Duplicates are removed from; Practitioner Identifiers, Practitioner Taxonomies, and Practitioner Taxonomy Groups.

  • Is the schema of the sample database the same as the full database?

    Yes.  

  • Who is npidatasource?

    We are a small company owned and operated by Database Professionals who have worked with the NPPES / NPI database since its creation. We have created a set of first class Database Products which any IT shop/ Researcher will find: easy to use, accurate, and performant.

Historical Data


  • NPPES_Data_Dissemination_October_2014

    NPPES_Data_Dissemination_August_2015

    NPPES_Data_Dissemination_September_2015

    NPPES_Data_Dissemination_December_2015

    NPPES_Data_Dissemination_January_2016

    NPPES_Data_Dissemination_February_2016

    NPPES_Data_Dissemination_March_2016

    NPPES_Data_Dissemination_April_2016

    NPPES_Data_Dissemination_November_2016

    NPPES_Data_Dissemination_December_2016

    All 12 Monthly Files 2017

    all 12 Monthly Files 2018

    NPPES_Data_Dissemination_January_2019

    NPPES_Data_Dissemination_February_2019

    NPPES_Data_Dissemination_March_2019

    NPPES_Data_Dissemination_April_2019

    NPPES_Data_Dissemination_May_2019

    NPPES_Data_Dissemination_June_2019

    NPPES_Data_Dissemination_July_2019

    NPPES_Data_Dissemination_August_2019

    NPPES_Data_Dissemination_September_2019

    NPPES_Data_Dissemination_October_2019

    NPPES_Data_Dissemination_November_2019

    NPPES_Data_Dissemination_December_2019

    NPPES_Data_Dissemination_January_2020

    NPPES_Data_Dissemination_February_2020

    NPPES_Data_Dissemination_March_2020

    NPPES_Data_Dissemination_April_2020

    NPPES_Data_Dissemination_May_2020

    NPPES_Data_Dissemination_June_2020

    NPPES_Data_Dissemination_July_2020

    NPPES_Data_Dissemination_August_2020

    NPPES_Data_Dissemination_September_2020

    NPPES_Data_Dissemination_October_2020

    NPPES_Data_Dissemination_November_2020

Purchase The Latest Copy of the NPI Database. 

Once purchased you will receive an Email with links to the database. If you have not received the Email in a reasonable amount of time, Call or text me @ 757-692-5007.

$85.00

Current database revision and record counts

Database Update: 11 November 2020

FIle: NPPES Data Dissemination (November 10, 2020)

Total NPI Records - 6,599,793

Address Records - 13,251,874

Office Contact Records - 1,431,563

Identifier Records - 2,704,493

Taxonomy Group Records - 765,333

Taxonomy Records - 769,892

Telephone Records - 18,410,125

Pecos Registered - 1,604,579


customer Feedback

J. P.     University of South Carolina College of Nursing
"People thoroughly familiar with the NPPES NPI Registry are painfully aware of how clunky and wide the downloadable file actually is. Manipulating such large amounts of error-laden data is quite a time consuming and labor-intensive task. My job as a data analyst requires that I use the data from the NPI Registry often. NPIDatasource saved the day. Their continuously updated databases are built upon a very elegant schema that is easy to understand and use. Their products have saved me a lot of time and effort. Thank you NPIDatasource!" 

J. Rein     ***now.com
"I work as a Data Analyst for a small healthcare consultancy. I have dealt with the NPI file from CMS before, and it has caused me a lot of aggravation. It was much faster this time around and a lot cheaper to get it from NPIDataSource. The data looks great. Ken also provided me with great customer service. He responded very quickly and also had the knowledge and database experience to point me in the right direction for using the .bak file in my SQL Server Express edition. I highly recommend using NPIDataSource and I will definitely re-order next year!" 

Get in touch

Main Office
NPIDATASOURCE
Virginia Beach, VA 23462-1653
Ph:757.692.5007
Email
kenpat5@gmail.com