WELCOME TO NPIDATASOURCE

          

DATABASE UPDATED: 3/17/2019

We offer the full CMS NPPES / NPI database / Pecos in ms SQL-SERVER and MYsql at A VERY REASONABLE COST.

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.

Weekly Updates.

FULLY RELATIONAL AND PERFORMANT.

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

Sql-Server Products compatible with 2008, 2008R2, 2012, 2014, 2016 (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.

Faqs


  • What format are the product files in?

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

  • How much disk space do the databases require?

    The Sql-Server product uses about 25Gb. The MYSql product uses about 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.

  • How come there isn't a delta file?

    Every file is a full file so that you may skip a month or any time period for that matter and update to the latest content. 

  • We have changed the schema of our copy of the NPI database, how do we update the database without losing those changes?

    The update script will run without editing in most cases. If you removed objects from the database you may have to edit the update script (It references a dropped object). If you have added extra objects the update script will run without any problems. The update script will need to be changed if you have changed the Procedures and Tables from the initial product download.

  • 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 accurate, expediant, and easy to implement.  

downloads

DOWNLOAD the SAMPLE Database...

Current database revision and record counts

Database Update on 3/17/2019 

NPPES Data Dissemination (March 12, 2019)

Total active NPI Records  - 5,758,975                                                                                                                                                                                                  

Address Records - 11,695,198

Office Contact Records - 1,322,694   

Identifier Records - 4,921,521  

Taxonomy Group Records  - 682,960 

Taxonomy Records  - 7,145,157 

Telephone Records  - 16,667,216

Pecos Registered - 1,455,267


customer Feedback

J. P.     University of South Carolina College of Nursing  01/25/2018
"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
support@npidatasource.com