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

`medicare_semantic.vw_hix_after_credit_v1` · Insurer negotiated rates · status partial

The credit = the EHB part of the benchmark (benchmark_ehb, 26 CFR 1.36B-3) less the applicable percentage of income (26 U.S.C. 36B), 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.** One row per county x age x income (100-600% of the poverty line) x schedule x plan year, one adult.

| 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: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_hix_after_credit_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_hix_after_credit_v1")` first.