Dataset: Medicare Physician & Other Practitioners - By Provider And Service

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.

Note: This full dataset contains more records than most spreadsheet programs can handle, which will result in an incomplete load of data. Use of a database or statistical software is required.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-04-26T02:57:45.099079
Tags: health-care-use-payments, medicare, original-medicare, physicians-practitioners

Tables

Medicare Physician & Other Practitioners - By Provider And Service : 2023-12-31

@usgov.hhs_gov_medicare_physician_other_practitioners_by_prov_e1c98af4.medicare_physician_other_practitioners_by_provider_and_0a919aa5

443.75 MB
9660647 rows
28 columns


CREATE TABLE medicare_physician_other_practitioners_by_provider_and_0a919aa5 (
  "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
);