WELCOME TO NPIDATASOURCE


Database UPDATED: 15-March-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

Purchase 

The links to download both THE Mysql and Sql-server Versions will be on your paypal receipt. Just copy the link and paste into a browser.

$85.00

Current database revision and record counts

Database Update: 15 March 2020

NPPES Data Dissemination (March 11, 2020)

Total NPI Records - 6,307,338

Address Records - 12,627,253

Office Contact Records - 1,385,035

Identifier Records - 2,693,808

Taxonomy Group Records - 732,870

Taxonomy Records - 7,663,893

Telephone Records - 17,722,648

Pecos Registered - 1,558,415


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!" 

Get in touch

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