Drugs and formularies

States W7 Employer coverage: state_employer_plan_v1

vlada_curated.state_employer_plan_v1·partial·silver

Rows

138,488

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1State product W7 (Employer coverage) of the States lane: employer health plans filed on Form 5500: sponsor, size, funding, carriers, brokers and premiums.
2One row per filing (ack_id) x plan year. funding_class says insured vs self-funded; premiums and broker commissions come from Schedule A and are blank on self-funded plans.
311 state(s): CA FL GA IL MI NC NJ NY OH PA TX.

Grain

Key	Grain
N/A	1Employer health plans filed on Form 5500: sponsor, size, funding, carriers, brokers and premiums. 2138,488 rows (Athena, 2026-10-29). 3Period 2022 to 2025 (plan_year).

Columns (49)

Column	Type	Meaning
`state_code`	string
`county_fips`	string
`county_status`	string
`plan_year`	int
`plan_year_begin`	string
`plan_year_status`	string
`ack_id`	string
`plan_key`	string
`plan_number`	string
`plan_name`	string
`sponsor_ein`	string
`sponsor_name`	string
`sponsor_zip5`	string
`business_code`	string
`participants_boy`	int
`active_participants_eoy`	int
`total_participants_eoy`	int
`size_band`	string
`funding_insurance_ind`	boolean
`funding_trust_ind`	boolean
`funding_gen_asset_ind`	boolean
`funding_sec412_ind`	boolean
`benefit_insurance_ind`	boolean
`benefit_trust_ind`	boolean
`benefit_gen_asset_ind`	boolean
`medical_insured_ind`	boolean
`stop_loss_ind`	boolean
`funding_class`	string
`funding_method`	string
`medical_persons_covered`	bigint
`medical_premium_usd`	double
`stop_loss_premium_usd`	double
`broker_comm_usd`	double
`broker_fees_usd`	double
`carrier_count`	int
`medical_carrier_count`	int
`tpa_count`	int
`broker_count`	int
`amended_ind`	boolean
`short_plan_year_ind`	boolean
`final_filing_ind`	boolean
`collectively_bargained_ind`	boolean
`multiple_employer_ind`	boolean
`admin_name`	string
`admin_ein`	string
`source_sha256`	string
`source_url`	string
`source_locator`	string
`row_key`	string

Query it

describe_data_source(source_fqn="vlada_curated.state_employer_plan_v1")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.state_employer_plan_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="vlada_curated.state_employer_plan_v1")`
Raw door	Athena (read-only via query_substrate): vlada_curated.state_employer_plan_v1 (filter state_code)

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