Drugs and formularies

ASP — Medicare Part B drug Average Sales Price

drug_silver.fact_drug_asp_quarterly#drug_asp·live·silver

Rows

18,027

Columns

N/A

History

N/A

Card

nocolumns only

Typed tools

What it is

1Medicare Part B quarterly ASP/payment-limit benchmark by HCPCS billing unit.
2This is the denominator for J-code drug markup analysis against commercial infusion rates.

Grain

Key	Grain
N/A	1One row per (HCPCS code, effective quarter).

Columns (0)

Columns are not in the catalog for this source; describe_data_source("drug_silver.fact_drug_asp_quarterly#drug_asp") reads them live.

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`hcpcs_code`
Join	`how_to_join(source_fqn="drug_silver.fact_drug_asp_quarterly#drug_asp")`
Raw door	Tool: asp_pricing_lookup; Athena: drug_silver.fact_drug_asp_quarterly (filter is_current = true).
Note	Logical catalog alias over physical table drug_silver.fact_drug_asp_quarterly; HCPCS<->NDC crosswalk is a separate quarterly drop.

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