WELCOME TO NPIDATASOURCE


Database UPDATED: 18-July-2020



We also offer segments of the NPI database filtered by: geography, taxonomy, Etc... exported to flat file/s.



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 database 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?

    The Sql-Server product is in a standard .BAK file (Ver. 2008). The MYSql product is in a self-contained export file  (Ver. 5.7). 

  • How large are the downloads?

    The Sql-Server product is .zipped into a ~5Gb. file. The MYSql product is .zipped into a ~1Gb. 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

Purchase Latest Copy of the NPI Database 

Once purchased you will be redirected back here and the links to download will be present.

$85.00

Current database revision and record counts

Database Update: 18 July 2020

NPPES Data Dissemination (July 15, 2020)

Total NPI Records - 6,448,360

Address Records - 12,926,388

Office Contact Records - 1,406,165

Identifier Records - 2,701,019

Taxonomy Group Records - 749,976

Taxonomy Records - 7,839,497

Telephone Records - 18,045,095

Pecos Registered - 1,581,274


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.263.4751
Email
npidatasource@gmail.com