Download Employee Benefit (Welfare) plan data, one CSV per state.
114,905 employee benefit plans in the latest filing year, organized into one CSV per state. Free 20-row samples, no signup required. Subscribers get 5-10 full state files per month.
What’s in the file
One row per plan, plain UTF-8 CSV with a header row. Fields below ship as named columns; download a sample to see the exact layout.
- sponsor_ein
- sponsor_name
- sponsor_dba_name
- sponsor_address1
- sponsor_city
- sponsor_state
- sponsor_zip
- sponsor_phone
- naics_2
- plan_number
- plan_year
- plan_name
- form_type
- funding_type
- is_mewa
- has_schedule_a
- has_stop_loss
- first_filing_year
- bnft_health
- bnft_dental
- bnft_vision
- bnft_life
- bnft_std
- bnft_ltd
- bnft_drug
- bnft_stop_loss
- bnft_other
- benefit_breadth_count
- primary_carrier_name
- primary_broker_name
- carrier_count
- broker_count
- total_premiums
- premium_health
- premium_dental
- premium_vision
- premium_life
- total_welfare_charges
- total_broker_compensation
- broker_comp_pct_of_premium
- premium_per_participant
Download by state
50 states + the District of Columbia. Click a state to see counts, a 5-row preview, and download links.
Need 50 states, custom slices, or recurring pulls?
Subscribers cap at 5-10 distinct state downloads per month. For bulk needs, prospect lists, or market sizing — we build custom datasets in days, not weeks.
Questions
Where does this data come from?+
Every row is sourced from the U.S. Department of Labor's public Form 5500 series — the annual report ERISA-covered plans file with the EBSA. PlanOptica downloads the bulk dataset directly from the DOL, parses it through dbt, and republishes it with cleaned field names, normalized NAICS, and resolved sponsor identifiers.
How often is the data refreshed?+
Monthly. The Department of Labor republishes the bulk Form 5500 dataset about once a month; PlanOptica refreshes within a few days of each republish.
Why are the sample files limited to 20 rows?+
Samples are designed to validate the schema and let you see real data before you commit. We pick the 20 largest plans in the state by participant count so the sample is interesting rather than alphabetic. The full file is available to subscribers in one click.
Does the file include MEWA and association plans?+
Yes. The is_mewa flag distinguishes Multiple Employer Welfare Arrangements; association and trust filings are included as filed.
Can I use this commercially?+
Yes. The underlying Form 5500 data is in the public domain. PlanOptica's derived columns (cleaned field names, normalized NAICS, resolved carrier/broker names, etc.) are licensed for personal and commercial use under attribution — link back to PlanOptica when you publish.
Is there a national / all-states file?+
Not today. Each state ships separately so individual files stay manageable. For bulk or programmatic access, see /data/custom.
What about historical years?+
The current file reflects the most recent filing year per plan. Multi-year history is available inside the app on each plan page; a historical CSV bundle is available via custom analytics.