About this Dataset

Medicare Fee-For-Service Public Provider Enrollment

The Medicare Fee-For-Service Public Provider Enrollment dataset includes information on providers who are actively approved to bill Medicare or have completed the 855O at the time the data was pulled from the Provider Enrollment, Chain, and Ownership System (PECOS). The release of this provider enrollment data is not related to other provider information releases such as Physician Compare or Data Transparency.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:27:00.933268
Tags: medicare, original-medicare, provider-enrollment

Tables

Medicare Fee-For-Service Public Provider Enrollment : 2024-09-02

@usgov.hhs_gov_medicare_fee_for_service_public_provider_enrol_fd1bd0d3.medicare_fee_for_service_public_provider_enrollment_2024_09_02

100.73 MB
2,907,050 rows
10 columns

CREATE TABLE medicare_fee_for_service_public_provider_enrollment_2024_09_02 (
  "npi" BIGINT,
  "pecos_asct_cntl_id" BIGINT,
  "enrlmt_id" VARCHAR,
  "provider_type_cd" VARCHAR,
  "provider_type_desc" VARCHAR,
  "state_cd" VARCHAR,
  "first_name" VARCHAR,
  "mdl_name" VARCHAR,
  "last_name" VARCHAR,
  "org_name" VARCHAR
);