# States W7 Employer coverage: state_employer_plan_v1

`vlada_curated.state_employer_plan_v1` · Drugs and formularies · status partial · 138,488 rows

State product W7 (Employer coverage) of the States lane: employer health plans filed on Form 5500: sponsor, size, funding, carriers, brokers and premiums. One 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. 11 state(s): CA FL GA IL MI NC NJ NY OH PA TX.

**Grain.** Employer health plans filed on Form 5500: sponsor, size, funding, carriers, brokers and premiums. 138,488 rows (Athena, 2026-10-29). Period 2022 to 2025 (plan_year).

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