Insurer negotiated rates

Texas TDI Independent Dispute Resolution (SB 1264) summary data: monthly mediation and arbitration counts, every captured daily edition

medicare_silver.vw_fact_tx_tdi_idr_summary·live·semantic_view

Rows

5,254

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Texas Department of Insurance monthly IDR portal counts (data.texas.gov bn27-65ad) for state-regulated health plans and opted-in ERISA plans since February 2020.
2Mediation (out-of-network facilities) and arbitration (out-of-network providers) requests received, teleconference settlements, facilitator strikes by plan and by provider, both-party facilitator choices, assignments, arbitration decisions, and distinct counts of submitters, providers, involved health plans and assigned facilitators.
3Every captured edition is kept so restatements show; is_current marks the newest held one.

Grain

Key	Grain
N/A	1One row per (edition, request_type, count_type, activity_year, activity_month); read WHERE is_current. 25,254 rows over four held editions (2025-05-16, 2026-01-17, 2026-01-18, 2026-10-23T135729Z); the current edition holds 1,478 rows (Athena 3382bd59, 2026-10-23). 3One edition is added per day TDI refreshes.

Columns (32)

Column	Type	Meaning
`edition_rows_updated_at`	timestamp
`edition_data_version`	int
`request_type`	string
`count_type`	string
`year_raw`	string
`month_raw`	string
`activity_year`	int
`activity_month`	int
`activity_month_start`	date
`count_value`	bigint
`is_distinct_entity_count`	boolean
`is_partial_month`	boolean
`source_format`	string
`source_row_number`	int
`capture_origin`	string
`wayback_capture_url`	string
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`vintage_tag`	string
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_version`	string
`parser_artifact_hash`	string
`source_id`	string
`source_url`	string
`sha256_content_hash`	string
`bronze_object_key`	string
`s3_version_id`	string
`edition`	string
`is_current`	boolean
`effective_period_end`	date

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	N/A
Join	`how_to_join(source_fqn="medicare_silver.vw_fact_tx_tdi_idr_summary")`
Raw door	Athena (read-only via query_substrate): medicare_silver.vw_fact_tx_tdi_idr_summary WHERE is_current (the base table medicare_silver.fact_tx_tdi_idr_summary is internal)
Note	Registered 2026-10-23 under register w1 (tx_tdi_idr_summary) as the only read surface (PR claude/idr-register). Door RAW, World W1. The base table medicare_silver.fact_tx_tdi_idr_summary is internal: no card, World internal, refused NO_COVERAGE (#3612: required_filters do not refuse). Known value: requests received in 2023 (is_current) = 519,095 (arbitration 222,817 + mediation 296,278; TDI's 2025 IDR explainer p.19; Athena 82e42302).

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