NATIONAL BUREAU OF ECONOMIC RESEARCH
NATIONAL BUREAU OF ECONOMIC RESEARCH

Medical Loss Ratio Data -- MLR Data

The Center for Consumer Information & Insurance Oversight states the following:

"The Affordable Care Act requires health insurance companies to disclose how much they spend on health care and how much they spend on administrative costs, such as salaries and marketing. If an insurance company spends less than 80% (85% in the large group market) of premium on medical care and efforts to improve the quality of care, they must refund the portion of premium that exceeded this limit. This rule is commonly known as the 80/20 rule or the Medical Loss Ratio (MLR) rule."

Pre-Stata13 had a string length limit of 244 characters. Some files such as Part 4, Part 6, and Additional Responses 2 for some years have long strings ( > 244 characters ). They are saved in full length and length == 244 versions.

CMS offers an MLR reports by State and Company Name searchable database and other helpful resources.

Updates and changes.

Year
All Source
Data Files
and Docs
Doc
In-
struc-
tions
Forms
Row Lookup
Header
Part 1 and 2
Summary of Data
and
Premium and Claims
Part 3
Expense Allocation Methodology
Part 4
MLR and Rebate Calculation
Stata
SAS
CSV
Desc
Stata
SAS
CSV
Desc
Stata
SAS
CSV
Desc
Stata
SAS
CSV
Desc
Stata
SAS
CSV
Desc
2013
mlr.zip
doc
pdf
xls
dta
sas
csv
desc
dta
sas
csv
desc
dta

244
sas
csv
desc
dta
sas
csv
desc
dta

244
sas
csv
desc
2012
mlr.zip
doc
pdf
xls
dta
sas
csv
desc
dta
sas
csv
desc
dta
sas
csv
desc
dta
sas
csv
desc
dta

244
sas
csv
desc
2011
mlr.zip
doc
pdf
xls
xls
xls
dta
sas
csv
desc
dta
sas
csv
desc
dta
sas
csv
desc
dta
sas
csv
desc
dta

244
sas
csv
desc

Year
Part 5
Rebate
Disbursement
Part 6
Additional
Responses
Part 6 Notes
Additional
Responses 1
Additional
Responses 2
Sheet
Lookup
Refund
Stata
SAS
CSV
Desc
Stata
SAS
CSV
Desc
Stata
SAS
CSV
Desc
Stata
SAS
CSV
Desc
Stata
SAS
CSV
Desc
Stata
SAS
CSV
Desc
2013
dta
sas
csv
desc
dta

244
sas
csv
desc
dta
sas
csv
desc
dta
sas
csv
desc
dta

244
sas
csv
desc
dta
sas
csv
desc
pdf
2012
dta
sas
csv
desc
dta

244
sas
csv
desc
dta
sas
csv
desc
dta
sas
csv
desc
dta

244
sas
csv
desc
dta
sas
csv
desc
pdf
pdf
2011
dta
sas
csv
desc
dta
sas
csv
desc
dta
sas
csv
desc
dta
sas
csv
desc
dta
sas
csv
desc
dta
sas
csv
desc
pdf

To report problems or if you have comments or suggestions , e-mail Jean Roth at jroth@nber.org

Last Update: September 8, 2014 Created by Jean Roth September 7, 2014
 
Publications
Activities
Meetings
NBER Videos
Themes
Data
People
About

National Bureau of Economic Research, 1050 Massachusetts Ave., Cambridge, MA 02138; 617-868-3900; email: info@nber.org

Contact Us