Medicare Advantage, Part D, Medicaid

CMS Clinical Laboratory Fee Schedule national limitation amounts, quarterly releases 2019-2026, stamped

medicare_silver.fact_clfs_national_rate·live·silver·Medicare Clinical Laboratory Fee Schedule (CLFS)

Rows

55,116

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Every quarterly CLFS release since 2019 re-collected through the provenance envelope on 2026-09-07: indicator and national_limit_amount as published, modifier rows kept (the legacy medicare_clfs_rates held a single release, 2025 Q1, unmodified rows only).
2The 2019 files come from CMS's old Downloads path;
32023Q4 and later sit behind the AMA CPT click-through license, accepted openly with the license page kept in bronze.
4CPT descriptors are not stored. release = the publisher slug (e.g.
526clabq3);
620clabq2 is a publisher gap (the release page names a file CMS no longer serves).

Grain

Key	Grain
N/A	1One row per calendar_year x quarter x HCPCS x modifier as published; natural key (calendar_year, quarter, row_seq); 255,116 rows over 29 releases (2019Q1-2026Q3) on 2026-09-07.

Columns (24)

Column	Type	Meaning
`calendar_year`	int
`quarter`	string
`row_seq`	bigint
`hcpcs_code`	string
`modifier`	string
`effective_date`	string
`indicator`	string
`national_limit_amount`	double
`release`	string
`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_clfs_national_rate")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_clfs_national_rate WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	medicare_allowed
Identity key	`hcpcs_code`
Join	`how_to_join(source_fqn="medicare_silver.fact_clfs_national_rate")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_clfs_national_rate
Note	CERTIFIED (product1-cert-clfs-v2); Source Truth repaired for modern row-oriented CLFS releases through 2026 Q3 including recovered 20CLABQ2. Accepted legacy locality leg loaded 2008-2017 into medicare_silver.medicare_clfs_locality_rates; 2005-2007 remain a residual source-recovery gate.

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