Welcome TO NPIDATASOURCE.com!


Database UPDATED: 16-January-2021

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

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

Engineered for advanced BI work. Additionally return the most common fields with a single query! (Select * from BASIC_Output).



Features

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

PostgreSQL: compatible with release 10 and above.

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. PostgreSQL is about 10Gb.

  • 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.

Change Log


  • December 26, 2020 - Added Schema Creation Scripts (for all databases) to utilize in authoring ERD's.
  • December 19, 2020 - Removed the table "DIMTIME". No time fields in the NPI Database.
  • December 15, 2020 - Removed table "NPI_Search", added table "BASIC_Output". One Record per NPI of the most used fields.
  • December 12, 2020 - PostgreSQL NPI database available. Same schema with several changes to datatypes.
  • December 10, 2020 - One Year Subscription added as a product.
  • January 08, 2020 - Added new field "Certification Date" to Practitioner table.
  • January 04, 2020 - Added "Other Name Reference File" to processing and database.
  • January 04, 2020 - Added "Practice Location Reference File" to processing and database.
  • January 04, 2020 - Added "Endpoint Reference File" to processing and database.

Purchase The Latest Copy of the NPI Database. 

One copy no updates - 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 Us @ 757-692-5007.

$90.00

Latest copy with one year of updates - 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 Us @ 757-692-5007.

$400.00

Current database revision and record counts

Database Update: 12 January 2021

FIle: NPPES Data Dissemination (January 12, 2021)

Total NPI Records - 6,679,785

Address Records - 13,423,809

Office Contact Records - 1,443,440

Identifier Records - 2,712,780

Taxonomy Group Records - 779,303

Taxonomy Records - 8,137,268

Telephone Records - 18,602,156

Pecos Registered - 1,611,566


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
Phone/Text:757.692.5007
Email
kenpat5@gmail.com