Baselight
Sign In

Medicare Physician & Other Practitioners - By Provider

U.S. Department of Health & Human Services

@usgov.hhs_gov_medicare_physician_other_practitioners_by_prov_0d918d34

Loading...
Loading...

About this Dataset

Medicare Physician & Other Practitioners - By Provider

The Medicare Physician & Other Practitioners by Provider dataset provides information on use, payments, submitted charges and beneficiary demographic and health characteristics organized by National Provider Identifier (NPI).
Organization: U.S. Department of Health & Human Services
Last updated: 2025-11-08T13:08:55.097309
Tags: health-care-use-payments, health-equity, medicare, original-medicare, physicians-practitioners

Tables

Medicare Physician & Other Practitioners - By Provider : 2018-12-18

@usgov.hhs_gov_medicare_physician_other_practitioners_by_prov_0d918d34.medicare_physician_other_practitioners_by_provider_2018_12_18
  • 180.53 MB
  • 1,121,462 rows
  • 81 columns
Loading... 
CREATE TABLE medicare_physician_other_practitioners_by_provider_2018_12_18 (
  "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,
  "tot_hcpcs_cds" BIGINT,
  "tot_benes" BIGINT,
  "tot_srvcs" DOUBLE,
  "tot_sbmtd_chrg" DOUBLE,
  "tot_mdcr_alowd_amt" DOUBLE,
  "tot_mdcr_pymt_amt" DOUBLE,
  "tot_mdcr_stdzd_amt" DOUBLE,
  "drug_sprsn_ind" VARCHAR,
  "drug_tot_hcpcs_cds" DOUBLE,
  "drug_tot_benes" DOUBLE,
  "drug_tot_srvcs" DOUBLE,
  "drug_sbmtd_chrg" DOUBLE,
  "drug_mdcr_alowd_amt" DOUBLE,
  "drug_mdcr_pymt_amt" DOUBLE,
  "drug_mdcr_stdzd_amt" DOUBLE,
  "med_sprsn_ind" VARCHAR,
  "med_tot_hcpcs_cds" DOUBLE,
  "med_tot_benes" DOUBLE,
  "med_tot_srvcs" DOUBLE,
  "med_sbmtd_chrg" DOUBLE,
  "med_mdcr_alowd_amt" DOUBLE,
  "med_mdcr_pymt_amt" DOUBLE,
  "med_mdcr_stdzd_amt" DOUBLE,
  "bene_avg_age" BIGINT,
  "bene_age_lt_65_cnt" DOUBLE,
  "bene_age_65_74_cnt" DOUBLE,
  "bene_age_75_84_cnt" DOUBLE,
  "bene_age_gt_84_cnt" DOUBLE,
  "bene_feml_cnt" DOUBLE,
  "bene_male_cnt" DOUBLE,
  "bene_race_wht_cnt" DOUBLE,
  "bene_race_black_cnt" DOUBLE,
  "bene_race_api_cnt" DOUBLE,
  "bene_race_hspnc_cnt" DOUBLE,
  "bene_race_natind_cnt" DOUBLE,
  "bene_race_othr_cnt" DOUBLE,
  "bene_dual_cnt" DOUBLE,
  "bene_ndual_cnt" DOUBLE,
  "bene_cc_bh_adhd_othcd_v1_pct" DOUBLE,
  "bene_cc_bh_alcohol_drug_v1_pct" DOUBLE,
  "bene_cc_bh_tobacco_v1_pct" DOUBLE,
  "bene_cc_bh_alz_nonalzdem_v2_pct" DOUBLE,
  "bene_cc_bh_anxiety_v1_pct" DOUBLE,
  "bene_cc_bh_bipolar_v1_pct" DOUBLE,
  "bene_cc_bh_mood_v2_pct" DOUBLE,
  "bene_cc_bh_depress_v1_pct" DOUBLE,
  "bene_cc_bh_pd_v1_pct" DOUBLE,
  "bene_cc_bh_ptsd_v1_pct" DOUBLE,
  "bene_cc_bh_schizo_othpsy_v1_pct" DOUBLE,
  "bene_cc_ph_asthma_v2_pct" DOUBLE,
  "bene_cc_ph_afib_v2_pct" DOUBLE,
  "bene_cc_ph_cancer6_v2_pct" DOUBLE,
  "bene_cc_ph_ckd_v2_pct" DOUBLE,
  "bene_cc_ph_copd_v2_pct" DOUBLE,
  "bene_cc_ph_diabetes_v2_pct" DOUBLE,
  "bene_cc_ph_hf_nonihd_v2_pct" DOUBLE,
  "bene_cc_ph_hyperlipidemia_v2_pct" DOUBLE,
  "bene_cc_ph_hypertension_v2_pct" DOUBLE,
  "bene_cc_ph_ischemicheart_v2_pct" DOUBLE,
  "bene_cc_ph_osteoporosis_v2_pct" DOUBLE,
  "bene_cc_ph_parkinson_v2_pct" DOUBLE,
  "bene_cc_ph_arthritis_v2_pct" DOUBLE,
  "bene_cc_ph_stroke_tia_v2_pct" DOUBLE,
  "bene_avg_risk_scre" DOUBLE
);

Medicare Physician & Other Practitioners - By Provider : 2021-12-17

@usgov.hhs_gov_medicare_physician_other_practitioners_by_prov_0d918d34.medicare_physician_other_practitioners_by_provider_2021_12_17
  • 190.86 MB
  • 1,198,754 rows
  • 81 columns
Loading... 
CREATE TABLE medicare_physician_other_practitioners_by_provider_2021_12_17 (
  "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,
  "tot_hcpcs_cds" BIGINT,
  "tot_benes" BIGINT,
  "tot_srvcs" DOUBLE,
  "tot_sbmtd_chrg" DOUBLE,
  "tot_mdcr_alowd_amt" DOUBLE,
  "tot_mdcr_pymt_amt" DOUBLE,
  "tot_mdcr_stdzd_amt" DOUBLE,
  "drug_sprsn_ind" VARCHAR,
  "drug_tot_hcpcs_cds" DOUBLE,
  "drug_tot_benes" DOUBLE,
  "drug_tot_srvcs" DOUBLE,
  "drug_sbmtd_chrg" DOUBLE,
  "drug_mdcr_alowd_amt" DOUBLE,
  "drug_mdcr_pymt_amt" DOUBLE,
  "drug_mdcr_stdzd_amt" DOUBLE,
  "med_sprsn_ind" VARCHAR,
  "med_tot_hcpcs_cds" DOUBLE,
  "med_tot_benes" DOUBLE,
  "med_tot_srvcs" DOUBLE,
  "med_sbmtd_chrg" DOUBLE,
  "med_mdcr_alowd_amt" DOUBLE,
  "med_mdcr_pymt_amt" DOUBLE,
  "med_mdcr_stdzd_amt" DOUBLE,
  "bene_avg_age" BIGINT,
  "bene_age_lt_65_cnt" DOUBLE,
  "bene_age_65_74_cnt" DOUBLE,
  "bene_age_75_84_cnt" DOUBLE,
  "bene_age_gt_84_cnt" DOUBLE,
  "bene_feml_cnt" DOUBLE,
  "bene_male_cnt" DOUBLE,
  "bene_race_wht_cnt" DOUBLE,
  "bene_race_black_cnt" DOUBLE,
  "bene_race_api_cnt" DOUBLE,
  "bene_race_hspnc_cnt" DOUBLE,
  "bene_race_natind_cnt" DOUBLE,
  "bene_race_othr_cnt" DOUBLE,
  "bene_dual_cnt" DOUBLE,
  "bene_ndual_cnt" DOUBLE,
  "bene_cc_bh_adhd_othcd_v1_pct" DOUBLE,
  "bene_cc_bh_alcohol_drug_v1_pct" DOUBLE,
  "bene_cc_bh_tobacco_v1_pct" DOUBLE,
  "bene_cc_bh_alz_nonalzdem_v2_pct" DOUBLE,
  "bene_cc_bh_anxiety_v1_pct" DOUBLE,
  "bene_cc_bh_bipolar_v1_pct" DOUBLE,
  "bene_cc_bh_mood_v2_pct" DOUBLE,
  "bene_cc_bh_depress_v1_pct" DOUBLE,
  "bene_cc_bh_pd_v1_pct" DOUBLE,
  "bene_cc_bh_ptsd_v1_pct" DOUBLE,
  "bene_cc_bh_schizo_othpsy_v1_pct" DOUBLE,
  "bene_cc_ph_asthma_v2_pct" DOUBLE,
  "bene_cc_ph_afib_v2_pct" DOUBLE,
  "bene_cc_ph_cancer6_v2_pct" DOUBLE,
  "bene_cc_ph_ckd_v2_pct" DOUBLE,
  "bene_cc_ph_copd_v2_pct" DOUBLE,
  "bene_cc_ph_diabetes_v2_pct" DOUBLE,
  "bene_cc_ph_hf_nonihd_v2_pct" DOUBLE,
  "bene_cc_ph_hyperlipidemia_v2_pct" DOUBLE,
  "bene_cc_ph_hypertension_v2_pct" DOUBLE,
  "bene_cc_ph_ischemicheart_v2_pct" DOUBLE,
  "bene_cc_ph_osteoporosis_v2_pct" DOUBLE,
  "bene_cc_ph_parkinson_v2_pct" DOUBLE,
  "bene_cc_ph_arthritis_v2_pct" DOUBLE,
  "bene_cc_ph_stroke_tia_v2_pct" DOUBLE,
  "bene_avg_risk_scre" DOUBLE
);

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

@usgov.hhs_gov_medicare_physician_other_practitioners_by_prov_0d918d34.medicare_physician_other_practitioners_by_provider_2022_12_02
  • 194.8 MB
  • 1,230,293 rows
  • 81 columns
Loading... 
CREATE TABLE medicare_physician_other_practitioners_by_provider_2022_12_02 (
  "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,
  "tot_hcpcs_cds" BIGINT,
  "tot_benes" BIGINT,
  "tot_srvcs" DOUBLE,
  "tot_sbmtd_chrg" DOUBLE,
  "tot_mdcr_alowd_amt" DOUBLE,
  "tot_mdcr_pymt_amt" DOUBLE,
  "tot_mdcr_stdzd_amt" DOUBLE,
  "drug_sprsn_ind" VARCHAR,
  "drug_tot_hcpcs_cds" DOUBLE,
  "drug_tot_benes" DOUBLE,
  "drug_tot_srvcs" DOUBLE,
  "drug_sbmtd_chrg" DOUBLE,
  "drug_mdcr_alowd_amt" DOUBLE,
  "drug_mdcr_pymt_amt" DOUBLE,
  "drug_mdcr_stdzd_amt" DOUBLE,
  "med_sprsn_ind" VARCHAR,
  "med_tot_hcpcs_cds" DOUBLE,
  "med_tot_benes" DOUBLE,
  "med_tot_srvcs" DOUBLE,
  "med_sbmtd_chrg" DOUBLE,
  "med_mdcr_alowd_amt" DOUBLE,
  "med_mdcr_pymt_amt" DOUBLE,
  "med_mdcr_stdzd_amt" DOUBLE,
  "bene_avg_age" BIGINT,
  "bene_age_lt_65_cnt" DOUBLE,
  "bene_age_65_74_cnt" DOUBLE,
  "bene_age_75_84_cnt" DOUBLE,
  "bene_age_gt_84_cnt" DOUBLE,
  "bene_feml_cnt" DOUBLE,
  "bene_male_cnt" DOUBLE,
  "bene_race_wht_cnt" DOUBLE,
  "bene_race_black_cnt" DOUBLE,
  "bene_race_api_cnt" DOUBLE,
  "bene_race_hspnc_cnt" DOUBLE,
  "bene_race_natind_cnt" DOUBLE,
  "bene_race_othr_cnt" DOUBLE,
  "bene_dual_cnt" DOUBLE,
  "bene_ndual_cnt" DOUBLE,
  "bene_cc_bh_adhd_othcd_v1_pct" DOUBLE,
  "bene_cc_bh_alcohol_drug_v1_pct" DOUBLE,
  "bene_cc_bh_tobacco_v1_pct" DOUBLE,
  "bene_cc_bh_alz_nonalzdem_v2_pct" DOUBLE,
  "bene_cc_bh_anxiety_v1_pct" DOUBLE,
  "bene_cc_bh_bipolar_v1_pct" DOUBLE,
  "bene_cc_bh_mood_v2_pct" DOUBLE,
  "bene_cc_bh_depress_v1_pct" DOUBLE,
  "bene_cc_bh_pd_v1_pct" DOUBLE,
  "bene_cc_bh_ptsd_v1_pct" DOUBLE,
  "bene_cc_bh_schizo_othpsy_v1_pct" DOUBLE,
  "bene_cc_ph_asthma_v2_pct" DOUBLE,
  "bene_cc_ph_afib_v2_pct" DOUBLE,
  "bene_cc_ph_cancer6_v2_pct" DOUBLE,
  "bene_cc_ph_ckd_v2_pct" DOUBLE,
  "bene_cc_ph_copd_v2_pct" DOUBLE,
  "bene_cc_ph_diabetes_v2_pct" DOUBLE,
  "bene_cc_ph_hf_nonihd_v2_pct" DOUBLE,
  "bene_cc_ph_hyperlipidemia_v2_pct" DOUBLE,
  "bene_cc_ph_hypertension_v2_pct" DOUBLE,
  "bene_cc_ph_ischemicheart_v2_pct" DOUBLE,
  "bene_cc_ph_osteoporosis_v2_pct" DOUBLE,
  "bene_cc_ph_parkinson_v2_pct" DOUBLE,
  "bene_cc_ph_arthritis_v2_pct" DOUBLE,
  "bene_cc_ph_stroke_tia_v2_pct" DOUBLE,
  "bene_avg_risk_scre" DOUBLE
);

Share link

Anyone who has the link will be able to view this.