Medicare Advantage, Part D, Medicaid

AHRQ Quality Indicator national benchmark tables

medicare_silver.ahrq_qi_benchmark·live·silver

Rows

7,031

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Public IQI, PDI, PQI, and PSI national benchmark and stratified reference tables across modern and legacy layouts, retaining raw metrics, nullable numeric values, suppression/range state, page/table identity, and content lineage.

Grain

Key	Grain
N/A	1One row per observed release, source PDF page/table, indicator, group, and row ordinal.

Columns (37)

Column	Type	Meaning
`release_version`	string
`schema_era`	string
`module`	string
`table_number`	int
`benchmark_scope`	string
`indicator_id`	string
`indicator_label`	string
`group_label`	string
`numerator_raw`	string
`denominator_raw`	string
`observed_rate_raw`	string
`numerator`	double
`denominator`	double
`observed_rate`	double
`rate_multiplier`	int
`is_suppressed`	boolean
`source_asset_id`	string
`source_page`	int
`row_ordinal`	bigint
`raw_row_text`	string
`quality_flags`	string
`is_analytics_eligible`	boolean
`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.ahrq_qi_benchmark")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ahrq_qi_benchmark WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`observed_period,source_asset_id,source_page,table_number,row_ordinal`
Join	`how_to_join(source_fqn="medicare_silver.ahrq_qi_benchmark")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ahrq_qi_benchmark

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