Insurer negotiated rates

Premium tax credit applicable percentages 2014-2027 (hix_credit_schedule_v1)

medicare_silver.hix_credit_schedule_v1·partial·silver

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The applicable percentage table each year (statute 2014, IRS Rev.
2Procs 2015-2020 and 2026-2027, the enhanced schedule 2021-2025) with the document and URL on every row.

Grain

Key	Grain
N/A	1One row per plan year x income band x regime: 114 rows.

Columns (8)

Column	Type	Meaning
`plan_year`	string
`fpl_low`	string
`fpl_high`	string
`initial_pct`	string
`final_pct`	string
`regime`	string
`source_doc`	string
`source_url`	string

Query it

describe_data_source(source_fqn="medicare_silver.hix_credit_schedule_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.hix_credit_schedule_v1 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.hix_credit_schedule_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.hix_credit_schedule_v1 (filter plan_year and regime; percentages are percent values)

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