About this Dataset

Medicare Physician & Other Practitioners - By Provider And Service

The Medicare Physician & Other Practitioners by Provider and Service dataset provides information on use, payments, and submitted charges organized by National Provider Identifier (NPI), Healthcare Common Procedure Coding System (HCPCS) code, and place of service.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-11-08T13:11:31.431613
Tags: health-care-use-payments, health-equity, medicare, original-medicare, physicians-practitioners

Tables

Medicare Physician & Other Practitioners - By Provider And Service : 2018-12-02

@usgov.hhs_gov_medicare_physician_other_practitioners_by_prov_b17e531e.medicare_physician_other_practitioners_by_provider_and_29062364

476.37 MB
9,961,865 rows
28 columns

CREATE TABLE medicare_physician_other_practitioners_by_provider_and_29062364 (
  "rndrng_npi" BIGINT,
  "rndrng_prvdr_last_org_name" VARCHAR,
  "rndrng_prvdr_first_name" VARCHAR,
  "rndrng_prvdr_mi" VARCHAR,
  "rndrng_prvdr_crdntls" VARCHAR,
  "rndrng_prvdr_ent_cd" VARCHAR,
  "rndrng_prvdr_st1" VARCHAR,
  "rndrng_prvdr_st2" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" DOUBLE,
  "rndrng_prvdr_zip5" VARCHAR,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "rndrng_prvdr_cntry" VARCHAR,
  "rndrng_prvdr_type" VARCHAR,
  "rndrng_prvdr_mdcr_prtcptg_ind" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_benes" BIGINT,
  "tot_srvcs" DOUBLE,
  "tot_bene_day_srvcs" BIGINT,
  "avg_sbmtd_chrg" DOUBLE,
  "avg_mdcr_alowd_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE,
  "avg_mdcr_stdzd_amt" DOUBLE
);

Medicare Physician & Other Practitioners - By Provider And Service : 2016-12-02

@usgov.hhs_gov_medicare_physician_other_practitioners_by_prov_b17e531e.medicare_physician_other_practitioners_by_provider_and_4e2ff379

452.88 MB
9,714,896 rows
28 columns

CREATE TABLE medicare_physician_other_practitioners_by_provider_and_4e2ff379 (
  "rndrng_npi" BIGINT,
  "rndrng_prvdr_last_org_name" VARCHAR,
  "rndrng_prvdr_first_name" VARCHAR,
  "rndrng_prvdr_mi" VARCHAR,
  "rndrng_prvdr_crdntls" VARCHAR,
  "rndrng_prvdr_ent_cd" VARCHAR,
  "rndrng_prvdr_st1" VARCHAR,
  "rndrng_prvdr_st2" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" DOUBLE,
  "rndrng_prvdr_zip5" VARCHAR,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "rndrng_prvdr_cntry" VARCHAR,
  "rndrng_prvdr_type" VARCHAR,
  "rndrng_prvdr_mdcr_prtcptg_ind" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_benes" BIGINT,
  "tot_srvcs" DOUBLE,
  "tot_bene_day_srvcs" BIGINT,
  "avg_sbmtd_chrg" DOUBLE,
  "avg_mdcr_alowd_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE,
  "avg_mdcr_stdzd_amt" DOUBLE
);

Medicare Physician & Other Practitioners - By Provider And Service : 2021-12-02

@usgov.hhs_gov_medicare_physician_other_practitioners_by_prov_b17e531e.medicare_physician_other_practitioners_by_provider_and_5e309c60

462.17 MB
9,886,177 rows
28 columns

CREATE TABLE medicare_physician_other_practitioners_by_provider_and_5e309c60 (
  "rndrng_npi" BIGINT,
  "rndrng_prvdr_last_org_name" VARCHAR,
  "rndrng_prvdr_first_name" VARCHAR,
  "rndrng_prvdr_mi" VARCHAR,
  "rndrng_prvdr_crdntls" VARCHAR,
  "rndrng_prvdr_ent_cd" VARCHAR,
  "rndrng_prvdr_st1" VARCHAR,
  "rndrng_prvdr_st2" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" VARCHAR,
  "rndrng_prvdr_zip5" VARCHAR,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "rndrng_prvdr_cntry" VARCHAR,
  "rndrng_prvdr_type" VARCHAR,
  "rndrng_prvdr_mdcr_prtcptg_ind" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_benes" BIGINT,
  "tot_srvcs" DOUBLE,
  "tot_bene_day_srvcs" BIGINT,
  "avg_sbmtd_chrg" DOUBLE,
  "avg_mdcr_alowd_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE,
  "avg_mdcr_stdzd_amt" DOUBLE
);

Medicare Physician & Other Practitioners - By Provider And Service : 2022-12-02

@usgov.hhs_gov_medicare_physician_other_practitioners_by_prov_b17e531e.medicare_physician_other_practitioners_by_provider_and_eb6b7c4c

488.97 MB
9,755,427 rows
28 columns

CREATE TABLE medicare_physician_other_practitioners_by_provider_and_eb6b7c4c (
  "rndrng_npi" BIGINT,
  "rndrng_prvdr_last_org_name" VARCHAR,
  "rndrng_prvdr_first_name" VARCHAR,
  "rndrng_prvdr_mi" VARCHAR,
  "rndrng_prvdr_crdntls" VARCHAR,
  "rndrng_prvdr_ent_cd" VARCHAR,
  "rndrng_prvdr_st1" VARCHAR,
  "rndrng_prvdr_st2" VARCHAR,
  "rndrng_prvdr_city" VARCHAR,
  "rndrng_prvdr_state_abrvtn" VARCHAR,
  "rndrng_prvdr_state_fips" VARCHAR,
  "rndrng_prvdr_zip5" VARCHAR,
  "rndrng_prvdr_ruca" DOUBLE,
  "rndrng_prvdr_ruca_desc" VARCHAR,
  "rndrng_prvdr_cntry" VARCHAR,
  "rndrng_prvdr_type" VARCHAR,
  "rndrng_prvdr_mdcr_prtcptg_ind" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_benes" BIGINT,
  "tot_srvcs" DOUBLE,
  "tot_bene_day_srvcs" BIGINT,
  "avg_sbmtd_chrg" DOUBLE,
  "avg_mdcr_alowd_amt" DOUBLE,
  "avg_mdcr_pymt_amt" DOUBLE,
  "avg_mdcr_stdzd_amt" DOUBLE
);