About this Dataset

Medicare Physician & Other Practitioners - By Geography And Service

The Medicare Physician & Other Practitioners by Geography and Service dataset contains information on use, payments, submitted charges, and beneficiary demographic and health characteristics organized by geography, Healthcare Common Procedure Coding System (HCPCS) code, and place of service.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-04-26T02:58:05.623429
Tags: health-care-use-payments, medicare, national, original-medicare, physicians-practitioners, states-territories

Tables

Medicare Physician & Other Practitioners - By Geography And Service : 2019-12-31

@usgov.hhs_gov_medicare_physician_other_practitioners_by_geog_31b3dcf4.medicare_physician_other_practitioners_by_geography_an_0106adf0

14.72 MB
273,211 rows
15 columns

CREATE TABLE medicare_physician_other_practitioners_by_geography_an_0106adf0 (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" VARCHAR,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_rndrng_prvdrs" BIGINT,
  "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 Geography And Service : 2017-12-31

@usgov.hhs_gov_medicare_physician_other_practitioners_by_geog_31b3dcf4.medicare_physician_other_practitioners_by_geography_an_0c49ba0c

14.58 MB
269,902 rows
15 columns

CREATE TABLE medicare_physician_other_practitioners_by_geography_an_0c49ba0c (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" VARCHAR,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_rndrng_prvdrs" BIGINT,
  "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 Geography And Service : 2014-12-31

@usgov.hhs_gov_medicare_physician_other_practitioners_by_geog_31b3dcf4.medicare_physician_other_practitioners_by_geography_an_1b74332a

14.22 MB
264,758 rows
15 columns

CREATE TABLE medicare_physician_other_practitioners_by_geography_an_1b74332a (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" VARCHAR,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_rndrng_prvdrs" BIGINT,
  "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 Geography And Service : 2016-12-31

@usgov.hhs_gov_medicare_physician_other_practitioners_by_geog_31b3dcf4.medicare_physician_other_practitioners_by_geography_an_35f5803b

14.51 MB
269,836 rows
15 columns

CREATE TABLE medicare_physician_other_practitioners_by_geography_an_35f5803b (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" VARCHAR,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_rndrng_prvdrs" BIGINT,
  "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 Geography And Service : 2013-12-31

@usgov.hhs_gov_medicare_physician_other_practitioners_by_geog_31b3dcf4.medicare_physician_other_practitioners_by_geography_an_392def6d

14.34 MB
264,682 rows
15 columns

CREATE TABLE medicare_physician_other_practitioners_by_geography_an_392def6d (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" VARCHAR,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_rndrng_prvdrs" BIGINT,
  "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 Geography And Service : 2022-12-01

@usgov.hhs_gov_medicare_physician_other_practitioners_by_geog_31b3dcf4.medicare_physician_other_practitioners_by_geography_an_467c4f71

14.72 MB
270,673 rows
15 columns

CREATE TABLE medicare_physician_other_practitioners_by_geography_an_467c4f71 (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" VARCHAR,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_rndrng_prvdrs" BIGINT,
  "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 Geography And Service : 2018-12-31

@usgov.hhs_gov_medicare_physician_other_practitioners_by_geog_31b3dcf4.medicare_physician_other_practitioners_by_geography_an_56b3339d

14.66 MB
271,742 rows
15 columns

CREATE TABLE medicare_physician_other_practitioners_by_geography_an_56b3339d (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" VARCHAR,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_rndrng_prvdrs" BIGINT,
  "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 Geography And Service : 2020-12-31

@usgov.hhs_gov_medicare_physician_other_practitioners_by_geog_31b3dcf4.medicare_physician_other_practitioners_by_geography_an_71f988cc

14.59 MB
268,149 rows
15 columns

CREATE TABLE medicare_physician_other_practitioners_by_geography_an_71f988cc (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" VARCHAR,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_rndrng_prvdrs" BIGINT,
  "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 Geography And Service : 2023-12-31

@usgov.hhs_gov_medicare_physician_other_practitioners_by_geog_31b3dcf4.medicare_physician_other_practitioners_by_geography_an_7b8e6838

14.51 MB
268,634 rows
15 columns

CREATE TABLE medicare_physician_other_practitioners_by_geography_an_7b8e6838 (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" VARCHAR,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_rndrng_prvdrs" BIGINT,
  "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 Geography And Service : 2015-07-31

@usgov.hhs_gov_medicare_physician_other_practitioners_by_geog_31b3dcf4.medicare_physician_other_practitioners_by_geography_an_d141fd0d

14.32 MB
266,459 rows
15 columns

CREATE TABLE medicare_physician_other_practitioners_by_geography_an_d141fd0d (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" VARCHAR,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_rndrng_prvdrs" BIGINT,
  "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 Geography And Service : 2021-12-31

@usgov.hhs_gov_medicare_physician_other_practitioners_by_geog_31b3dcf4.medicare_physician_other_practitioners_by_geography_an_df7c3ff9

14.78 MB
271,635 rows
15 columns

CREATE TABLE medicare_physician_other_practitioners_by_geography_an_df7c3ff9 (
  "rndrng_prvdr_geo_lvl" VARCHAR,
  "rndrng_prvdr_geo_cd" VARCHAR,
  "rndrng_prvdr_geo_desc" VARCHAR,
  "hcpcs_cd" VARCHAR,
  "hcpcs_desc" VARCHAR,
  "hcpcs_drug_ind" VARCHAR,
  "place_of_srvc" VARCHAR,
  "tot_rndrng_prvdrs" BIGINT,
  "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
);