Drugs and formularies

Medicare Part D Prescribers by Provider (NPI x year), 2013-2024

medicare_silver.fact_part_d_prescriber_by_provider·live·silver

Rows

14,636,994

Columns

101

History

N/A

Card

nocolumns only

Typed tools

What it is

1One row per Part D prescriber NPI per year, 2013-2024: identity, address, specialty, claims, fills, cost, day supply and beneficiaries, split by 65+, brand / generic, MAPD / PDP and LIS; opioid, antibiotic and antipsychotic prescribing; beneficiary demographics and risk.
22024: 1,416,883 NPIs, 1,709,828,271 claims.

Grain

Key	Grain
N/A	1One row per (publisher_version = data year, prscrbr_npi) per release.

Columns (101)

Column	Type	Meaning
`publisher_version`	string
`data_year`	int
`prscrbr_npi`	string
`prscrbr_last_org_name`	string
`prscrbr_first_name`	string
`prscrbr_mi`	string
`prscrbr_crdntls`	string
`prscrbr_ent_cd`	string
`prscrbr_st1`	string
`prscrbr_st2`	string
`prscrbr_city`	string
`prscrbr_state_abrvtn`	string
`prscrbr_state_fips`	string
`prscrbr_zip5`	string
`prscrbr_ruca`	string
`prscrbr_ruca_desc`	string
`prscrbr_cntry`	string
`prscrbr_type`	string
`prscrbr_type_src`	string
`tot_clms`	bigint
`tot_30day_fills`	double
`tot_drug_cst`	double
`tot_day_suply`	bigint
`tot_benes`	bigint
`ge65_sprsn_flag`	string
`ge65_tot_clms`	bigint
`ge65_tot_30day_fills`	double
`ge65_tot_drug_cst`	double
`ge65_tot_day_suply`	bigint
`ge65_bene_sprsn_flag`	string
`ge65_tot_benes`	bigint
`brnd_sprsn_flag`	string
`brnd_tot_clms`	bigint
`brnd_tot_drug_cst`	double
`gnrc_sprsn_flag`	string
`gnrc_tot_clms`	bigint
`gnrc_tot_drug_cst`	double
`othr_sprsn_flag`	string
`othr_tot_clms`	bigint
`othr_tot_drug_cst`	double
`mapd_sprsn_flag`	string
`mapd_tot_clms`	bigint
`mapd_tot_drug_cst`	double
`pdp_sprsn_flag`	string
`pdp_tot_clms`	bigint
`pdp_tot_drug_cst`	double
`lis_sprsn_flag`	string
`lis_tot_clms`	bigint
`lis_drug_cst`	double
`nonlis_sprsn_flag`	string
`nonlis_tot_clms`	bigint
`nonlis_drug_cst`	double
`opioid_tot_clms`	bigint
`opioid_tot_drug_cst`	double
`opioid_tot_suply`	bigint
`opioid_tot_benes`	bigint
`opioid_prscrbr_rate`	double
`opioid_la_tot_clms`	bigint
`opioid_la_tot_drug_cst`	double
`opioid_la_tot_suply`	bigint
`opioid_la_tot_benes`	bigint
`opioid_la_prscrbr_rate`	double
`antbtc_tot_clms`	bigint
`antbtc_tot_drug_cst`	double
`antbtc_tot_benes`	bigint
`antpsyct_ge65_sprsn_flag`	string
`antpsyct_ge65_tot_clms`	bigint
`antpsyct_ge65_tot_drug_cst`	double
`antpsyct_ge65_bene_suprsn_flag`	string
`antpsyct_ge65_tot_benes`	bigint
`bene_avg_age`	double
`bene_age_lt_65_cnt`	bigint
`bene_age_65_74_cnt`	bigint
`bene_age_75_84_cnt`	bigint
`bene_age_gt_84_cnt`	bigint
`bene_feml_cnt`	bigint
`bene_male_cnt`	bigint
`bene_race_wht_cnt`	bigint
`bene_race_black_cnt`	bigint
`bene_race_api_cnt`	bigint
`bene_race_hspnc_cnt`	bigint
`bene_race_natind_cnt`	bigint
`bene_race_othr_cnt`	bigint
`bene_dual_cnt`	bigint
`bene_ndual_cnt`	bigint
`bene_avg_risk_scre`	double
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`source_id`	string
`is_current`	boolean
`bronze_object_key`	string
`s3_version_id`	string
`vintage_tag`	string
`drug_source_version_id`	string

Query it

describe_data_source(source_fqn="medicare_silver.fact_part_d_prescriber_by_provider")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_part_d_prescriber_by_provider WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`publisher_version,prscrbr_npi`
Join	`how_to_join(source_fqn="medicare_silver.fact_part_d_prescriber_by_provider")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_part_d_prescriber_by_provider
Company names	`prscrbr_last_org_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Register source cms_part_d_prescribers_by_provider (w3, serve raw). RAW. Loaded 2026-09-29 (verify_tracker_loads PASS 2026-09-30: 14,636,994 rows = the publisher API counts per year, 0 duplicate (data year, NPI), NPIs 10 digits; Athena 18df3977, 347f6ce2, 8b8911c8). Cell reconciliation PASS on 2013 and 2024 (every count column summed over the whole file). Registered 2026-09-30 in W3 beside the by-drug prescriber source.

This page as markdown: /docs-md/data/medicare_silver_fact_part_d_prescriber_by_provider.md · every page in one file: /llms-full.txt