VladaOmega
Sign inStart free
Insurer negotiated rates

CMS CCIIO Transparency in Coverage PUF — QHP claims transparency (multi-sheet XLSX)

medicare_silver.fact_transparency_in_coverage_puf_history·live·silver
Rows
40,222
Columns
37
History
N/A
Card
nocolumns only
Typed tools
0

What it is

  1. 1Per issuer x plan claims transparency (received / denied / resubmitted, in- and out-of-network) from the CMS Transparency in Coverage PUF, across all 3 market-segment sheets (Ind QHP / Ind SADP / SHOP) plus the legacy 2017-2020 combined sheet.
  2. 2Lossless: raw cells preserved in ordered_header_json + raw_values_json with a market_segment dimension.
  3. 3Payer-behavior signal.

Grain

KeyGrain
N/A
  1. 1One publisher row per (business_year, market_segment, sheet source_row_number).
  2. 23 market segments (Ind QHP / Ind SADP / SHOP), lossless multi-sheet XLSX stored as ordered_header_json + raw_values_json.
  3. 340,222 rows across PY2017-2026.

Columns (37)

ColumnTypeMeaning
business_yearint
market_segmentstring
sheet_namestring
source_row_numberbigint
worksheet_row_numberbigint
ordered_header_jsonstring
header_sha256string
column_countint
raw_values_jsonstring
raw_row_sha256string
artifact_idstring
source_zip_sha256string
source_zip_bytesbigint
final_source_urlstring
archive_memberstring
archive_member_sha256string
archive_member_bytesbigint
archive_member_crc32string
archive_inventory_jsonstring
expected_artifact_rowsbigint
publisher_modified_atstring
publisher_etagstring
observed_perioddate
asserted_atdate
effective_period_startdate
effective_period_enddate
cms_vintage_sequenceint
parse_revisionint
parser_artifact_hashstring
source_urlstring
sha256_content_hashstring
source_idstring
is_currentboolean
bronze_object_keystring
s3_version_idstring
vintage_tagstring
drug_source_version_idstring

Query it

describe_data_source(source_fqn="medicare_silver.fact_transparency_in_coverage_puf_history")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_transparency_in_coverage_puf_history WHERE <filter> LIMIT 100")
ItemValue
Typed tools that read itnone; raw SQL
Identity keybusiness_year,market_segment,source_row_number
Joinhow_to_join(source_fqn="medicare_silver.fact_transparency_in_coverage_puf_history")
Raw doorAthena (read-only via query_substrate): medicare_silver.fact_transparency_in_coverage_puf_history

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