AHRQ Data Tools
MEPS-IC Data Tools

Please note, pages have been optimized for Chrome, Firefox, Edge, and Safari.

This website is not supported on mobile devices. Use a desktop to access.

Medical Expenditure Panel Survey (MEPS) Insurance Component (IC)

Information from the private sector and State and local governments on the health insurance coverage offered to their employees.

Explore the MEPS-IC Data Tools

The Medical Expenditure Panel Survey Insurance Component (MEPS-IC) is an annual survey of private employers and State and local governments. The MEPS-IC produces national and State level estimates of employer-sponsored insurance, including offered plans, costs, employee eligibility, and number of enrollees. The MEPS-IC is sponsored by the Agency for Healthcare Research and Quality and is fielded by the U.S. Census Bureau.

Release of the private sector visuals occurs during the summer, and public and civilian during the late fall months.

MEPS-IC Data Tables for 1996-current are available on the MEPS website:
Download State Tables in Spreadsheet Format here.
Download all Data Tables in PDF Format here.

Download the AHRQ Data Tools Private National, Public, and Civilian data in MS Excel Format here.

Private Sector – National:

Private Sector – State:

Private Sector – Metropolitan Area:

Public Sector:

Civilian:

Table Series I

Table Series II, V-VIII, X, XII

Table Series IX

Table Series III, IV

Table Series XI

Private Sector - National

Private sector National-level data by firm size, industry group, census region, and other characteristics.

Table Series I
Private Sector - State

Private sector data by firm size, state, industry groupings, ownership type, age of firm, employee characteristics, and average wage quartiles.

Table Series II, V-VIII, X, XII
Private - Metropolitan Area

Private sector data for the 20 largest metro areas by firm size and at least one metro area in each state along with data for the remainder of that state.

Table Series IX
Public Sector

Public sector data by state and local government type, government size, and census division.

Table Series III, IV
Civilian

Civilian estimates incorporating both the private and state and local government sectors.

Table Series XI

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=private-sector-national&dash=19

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=private-sector-national&dash=22

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=private-sector-national&dash=23

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=private-sector-national&dash=24

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=private-sector-national&dash=25

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=private-sector-state&dash=26

Find new visuals for pooled estimates under Map, and Cross-sectional using the 3-year time period. The 3-year estimates are only available for series XII tables.

You can access additional estimates by choosing the 1-year estimates for series II, V-VIII, X tables.

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=private-sector-state&dash=27

Find new visuals for pooled estimates under Map, and Cross-sectional using the 3-year time period. The 3-year estimates are only available for series XII tables.

You can access additional estimates by choosing the 1-year estimates for series II tables.

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=private-sector-state&dash=28

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=private-sector-state&dash=29

Find new visuals for pooled estimates under Map, and Cross-sectional using the 3-year time period. The 3-year estimates are only available for series XII tables.

You can access additional estimates by choosing the 1-year estimates for series II, V-VIII tables.

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=private-metropolitan-area&dash=30

Find new visuals for pooled estimates under Cross-sectional using the 3-year Time Period.

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=private-metropolitan-area&dash=31

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=public-sector&dash=32

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=public-sector&dash=33

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=public-sector&dash=34

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=public-sector&dash=35

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=public-sector&dash=36

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=public-sector&dash=37

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=civilian&dash=38

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=civilian&dash=39

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=civilian&dash=40

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

Direct link to this dashboard: https://datatools.ahrq.gov/meps-ic?tab=civilian&dash=41

Not all estimates have every year’s data. In addition, changes in group definitions across the years may impact estimates and year-to-year comparisons.

Select the Download Data button for an accessible MS Excel version of the data visualization. The file size will depend on parameters selected.

If display is blank, please modify filter selections

ESTIMATE 1

Estimate 1 *

Standard Error 1 *

ESTIMATE 2

Estimate 2 *

Standard Error 2 *

* = required

RESULTS

Standard Error:

z Statistic:

p-value (two-tail):

Contact

MEPS Project Director
Medical Expenditure Panel Survey
Agency for Healthcare Research and Quality
5600 Fishers Lane
Rockville, MD 20857
mepsprojectdirector@ahrq.hhs.gov
(301) 427-1659

Additional Resources

Download accessible data – Public (XLSX, 6,624 KB)

Download accessible data – Private National (XLSX, 50.6 MB)

Download accessible data – Civilian (XLSX, 5,059 KB)