· Npidatasource provides the CMS NPI database enhanced with two additional CMS products which provides the greatest number of Addresses and Phone Numbers for our customers.
· Data Updated: November 16, 2022
· Our .CSV products are organized by state and all files are ready to open/ import in Microsoft® Excel® 2010 and greater.
· Once purchase is completed you will receive an E-mail with credentials in 10 minutes or less.
We have enriched the NPI database to include the "CMS National Downloadable File" & "Hospital General Information File" which adds millions of addresses and phone numbers to the product. The extra data points are only available in our database products, they are not included in the .CSV's. The record identifier is the NPI number so you can join the data with existing NPI records. Database record counts (Major Tables).
· 2.3 Million extra Phone Numbers for practitioner groups.
· 2.3 Million extra Addresses for practitioner groups.
· 1.2 Million extra Phone Numbers for practitioner hospital affiliations.
· 1.2 Million extra Addresses for practitioner hospital affiliations.
· 1.3 Million practitioner Medical School Attended and graduation year.
We have added a view: "vw_All_Addresses_Phones" which returns all addresses and phones from both the NPI and the National Provider File. Example Output
.CSV Files
The .CSV files are broken down by "State". For example the California file contains practitioners whose "Practice Location" or "Business Location" is "CA". All files will open in Excel 2010 and greater. Once purchased you will have access to all of the .csv files, no limit on number of downloads or state.
MariaDB 10.9.2
Engineered for performance and ease of use. Easily imported into; AWS Aurora, AWS RDS, or any MariaDB 10.9.2 and above database.
Microsoft® Power BI Desktop® 2.108
Easily imported into: powerbi.microsoft.com. Includes all five views which are "Materialized" within the Power BI file. No Installation required.
Microsoft® Sql-Server® 2019
Engineered for performance and ease of querying. Easily imported into a Cloud or On-Prem Database. All of our databases use the same schema which has been refined over the past eight years.
MySql® 8.0
Engineered for performance and ease of use. Easily imported into; AWS Aurora, AWS RDS, or any MySql 8.0 and above database.
PostgreSQL 10.0
Engineered for performance and ease of use. Easily imported into any PostgreSQL 10.0 and above database or AWS RDS.
Custom Format and Filters
We provide custom exports available in many database and text types. We produce custom files for many of our customers. Please use the contact us form and we will get right back to you!