This product includes data on all actively registered US healthcare providers and on the benefits plans (e.g. healthcare, medical, life insurance) of all large US employers. The dataset is well suited to serve as a spine for any healthcare provider analysis because of the nationally unique NPI (National Provider Identifier) code that is used across HIPAA covered entities.
Example topics covered:
- Insurance providers for specific companies
- Insurance carrier market penetration
- Registered provider name, specialty, location, email, and phone number
- Primary practice location of medical students
- NPI issuance, deactivation and reactivation dates
The healthcare providers data is sourced from the National Plan and Provider Enumeration System (NPPES) and the benefits data is sourced from US Department of Labor Form 5500 filings.
You can experiment with the data at: https://bit.ly/3qjAA6E
All Cybersyn products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, company). Entities may have characteristics (i.e. descriptors of the entity) in an index table and values (i.e. statistics, measure) in a timeseries table. Data is joinable across all Cybersyn products that have a GEO_ID. Visit docs.cybersyn.com for more details.
The healthcare providers data includes the names, licenses, addresses, specialties, business, and practice locations of all healthcare providers actively registered with NPPES and those that deactivated after August 1 2023. It also includes NPI issuance, deactivation and reactivation dates as applicable dating back to 2005. The NPPES is a governing body created by the Centers for Medicare and Medicaid Services (CMS) to issue mandatory National Provider Identifier (NPI) codes to all healthcare providers in the United States. NPI codes are unique 10-digit numbers used to identify healthcare providers. Providers include both individual practitioner (e.g. an individual doctor, nurse) and organization (hospital clinic, doctors office) that have a NPI. The administrative simplification provisions of HIPAA require all covered healthcare providers, plans and clearinghouses use NPIs in administrative and financial transactions (e.g. claim payments, referrals, diagnosis coding, etc.). Providers are classified along a 3-level taxonomy from the National Uniform Claim Committee (NUCC) that includes Provider Grouping, Classification, and Area of Specialization. If a provider is no longer practicing, they are responsible for manually deactivating their NPI with the NPPES.
The Department of Labor requires all large US employers that provide benefits to complete Form 5500. The Form 5500 filing includes basic firmographic data around the sponsor (employer) and the benefit recipients (employees) as well as the benefits plans (if any). The benefits data includes information about the type of plan (i.e. medical, healthcare, annuity), the carrier (i.e. insurance company), and select contractual information such as payments made to brokers and the effective and expiration dates.
Additional form types, schedules, and data sources around medical claims, providers and drug codes may be covered in the future. Email support@cybersyn.com for specific requests.
Original data sources and release frequency can be found at docs.cybersyn.com.
Tables Included
The tables in this product can be split into 3 categories covering Form 5500, US healthcare providers, and reference data as follows:
- us_department_of_labor_form_5500_filing_index_table: Metadata about Form 5500 filings including filing sponsor (company), sponsor industry, filing date, and more
- us_department_of_labor_form_5500_policy_index: Individual plan offerings and insurer information for policies included in Form 5500 filings that have Schedule A insurance information
- us_department_of_labor_form_5500_broker_index: commission and fee amounts received by a broker for an insurance policy
โ nppes_practitioner_attributes: Individual practitioner NPI, name, credentials, relevant dates
โ nppes_organization_attributes: Provider organization NPI, name, ownership, and relevant dates
โ nppes_nucc_taxonomy: Taxonomy codes and practice specializations at three different category levels
โ nppes_provider_addresses: Registered addresses, emails, and telephone numbers associated with NPIs
โ nppes_nucc_medicare_taxonomy_crosswalk: Medicare identifiers by NUCC taxonomies
โ nppes_npi_index - NPI numbers with activation status and effective dates
โ nppes_provider_taxonomy_and_license_numbers: The primary taxonomy of practitioners based on the NUCC taxonomy codes joined with the related license number for each taxonomy level.
โ geography_index: geo_id entity index table for geographic data
-----------------------------------------------------------------------------------------
Disclaimers
The data in this dataset is sourced in Cybersyn Docs available via the right panel nav. Links to provider terms and disclaimers are provided where appropriate:
- Department of Labor: https://www.dol.gov/general/disclaim
- Data Commons: https://creativecommons.org/licenses/by/4.0/
Cybersyn is not endorsed or affiliated with any of these providers.