Retirement plan data, by state.
856,046 retirement plans in the latest filing year, organized into one CSV per state. Free 20-row samples; 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_address_line1
- sponsor_city
- sponsor_state
- sponsor_zip
- sponsor_phone
- naics_2digit
- naics_sector_name
- industry
- plan_number
- plan_year
- plan_name
- form_type
- primary_subtype
- is_401k
- is_safe_harbor
- auto_enroll_flag
- first_filing_year
- lifecycle
- total_participants
- participants_active
- total_assets_eoy
- total_assets_boy
- total_contributions
- employer_contributions_total
- participant_contributions_total
- return_percentage
- participation_rate
- assets_per_participant
- admin_expenses_total
- fidelity_bond_amount
- plan_admin_name
- plan_admin_city
- plan_admin_state
- auditor_firm_name
- auditor_opinion_type
- link_5500
Download by state
50 states + the District of Columbia. Click a state to see counts, a 5-row preview, and download links.
50-state pulls and custom slices
Subscribers cap at 5-10 distinct state downloads per month. For bulk pulls, prospect lists, or market sizing, we ship custom datasets through the custom analytics service.
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 5500-SF (small plan) filings?+
Yes. PlanOptica unions Form 5500 and Form 5500-SF into a single canonical filing per plan-year, so the CSV reflects the full universe: large plans, small plans, and 5500-EZ (where reported), without you having to merge them.
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.