VladaOmega
Sign inStart free
Insurer negotiated rates

CMS Federal IDR (No Surprises Act) bi-monthly operations reports: disputes initiated and closed

medicare_silver.fact_idr_bimonthly_status·live·silver
Rows
169
Columns
33
History
N/A
Card
nocolumns only
Typed tools
0

What it is

  1. 1The Departments' bi-monthly Federal IDR operations snapshot (HTML tables on the CMS IDR reports page, May 31, 2025 onward).
  2. 2Table 1 disputes initiated and Table 2 reasons for closure, each in three windows, plus the narrative's monthly figures.
  3. 3Counts of disputes.
  4. 4The most current public IDR volume: the quarterly PUF and Supplemental Tables stop at 2025 Q4.

Grain

KeyGrain
N/A
  1. 1One row per (report_as_of, measure, window_type, window_start, window_end): disputes initiated, or closed by reason, in the two-month period / year to date / program to date / a month.
  2. 2169 rows, nine editions As of May 31, 2025 ...
  3. 3As of September 30, 2026 (Athena f68def95, 2026-10-23).

Columns (33)

ColumnTypeMeaning
measurestring
window_typestring
window_startdate
window_enddate
dispute_countbigint
unitstring
source_kindstring
table_numberint
table_titlestring
publisher_row_labelstring
publisher_column_headerstring
publisher_value_textstring
publisher_sentencestring
publisher_notestring
edition_titlestring
edition_data_hashstring
page_last_modifiedstring
observed_perioddate
asserted_atdate
asserted_at_evidencestring
effective_period_startdate
effective_period_enddate
cms_vintage_sequenceint
parse_revisionint
parser_versionstring
parser_artifact_hashstring
is_currentboolean
vintage_tagstring
source_idstring
source_urlstring
sha256_content_hashstring
bronze_object_keystring
s3_version_idstring

Query it

describe_data_source(source_fqn="medicare_silver.fact_idr_bimonthly_status")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_idr_bimonthly_status WHERE <filter> LIMIT 100")
ItemValue
Typed tools that read itnone; raw SQL
Identity keyN/A
Joinhow_to_join(source_fqn="medicare_silver.fact_idr_bimonthly_status")
Raw doorAthena (read-only via query_substrate): medicare_silver.fact_idr_bimonthly_status (pin one report_as_of and one window_type; never difference or sum across editions)
NoteAthena external table, Parquet, PARTITIONED BY (report_as_of date); each edition at medicare/silver/fact_idr_bimonthly_status/report_as_of=<d>/<parquet_sha256>/; a new edition appends a partition, an existing one is never rewritten (a changed edition REFUSES). RDS-free loader run via cloud_run (tools/data_tracker/idr_bimonthly_load.sh). Registered 2026-10-23 under register w1 (cms_federal_idr_bimonthly_status), door RAW (PR claude/idr-register).

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