Insurer negotiated rates

Marketplace premium tax credit by county, age and income (vw_hix_after_credit_v1)

medicare_semantic.vw_hix_after_credit_v1·partial·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The credit = the EHB part of the benchmark (benchmark_ehb, 26 CFR 1.36B-3) less the applicable percentage of income (26 U.S.C.
236B), never below zero, beside the lowest silver, bronze and gold premiums. schedule 'in force' or 'without the enhancement' (2021-2025 where the IRS published it).

Grain

Key	Grain
N/A	1One row per county x age x income (100-600% of the poverty line) x schedule x plan year, one adult.

Columns (17)

Column	Type	Meaning
`year`	int
`state`	string
`county`	string
`rating_area`	string
`age`	string
`income_pct_poverty`	double
`annual_income`	double
`schedule`	varchar(23)
`regime`	string
`applicable_pct`	double
`benchmark`	double
`benchmark_ehb`	double
`lowest_silver`	double
`lowest_bronze`	double
`lowest_gold`	double
`credit`	double
`schedule_source`	string

Query it

describe_data_source(source_fqn="medicare_semantic.vw_hix_after_credit_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_hix_after_credit_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_semantic.vw_hix_after_credit_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_hix_after_credit_v1 (filter year, state, age, income_pct_poverty and schedule = 'in force')

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