Insurer negotiated rates

Marketplace county benchmark at every age (vw_hix_county_benchmark_ages_v1)

medicare_semantic.vw_hix_county_benchmark_ages_v1·partial·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The same plans as vw_hix_county_benchmark_v1 (one age curve per state, so the plans do not change by age), priced at every age; materialized as medicare_silver.hix_county_benchmark_ages_v1 (materialize_ages.py) so one county answers in seconds.

Grain

Key	Grain
N/A	1One row per county x age x plan year: 2,085,501 rows, 42,896 county-years. 2The benchmark, lowest silver, bronze and gold plans at each age in the plan's own rate table.

Columns (17)

Column	Type	Meaning
`year`	int
`state`	string
`county`	string
`rating_area`	string
`age`	string
`slcsp_plan`	string
`slcsp`	double
`slcsp_ehb`	double
`lcsp_plan`	string
`lcsp`	double
`low_bronze_plan`	string
`low_bronze`	double
`low_gold_plan`	string
`low_gold`	double
`slcsp_age40`	double
`source`	string
`premium_source`	string

Query it

describe_data_source(source_fqn="medicare_semantic.vw_hix_county_benchmark_ages_v1")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_hix_county_benchmark_ages_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_county_benchmark_ages_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_hix_county_benchmark_ages_v1 (filter year, state and age)

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