Allan Baumgarten's Managed Care Reviews

OHIO

CONVENTIONS AND NOTES:

* The data set is a series of spreadsheets developed in preparing Ohio Health Market Review 2009

* Files are organized using Microsoft Excel for Macintosh computers and are copied onto a CD. The files can be used for PC/Windows personal computers although formatting may be slightly different.

* Most data are taken from the annual statements that each HMO submits to the Ohio Department of Insurance, which follow the standard HMO blank of the National Association of Insurance Commissioners. However, some HMOs operate as a line of business of an insurer, and do not file the full NAIC HMO blank. Currently that includes Health Maintenance Plan (Anthem). The detailed financial (balance sheet and income-expense) and enrollment data are generally included for 1995-2008. The spreadsheets also include some second quarter of 2009 data and some summary numbers for 1992-1994 that appear in the five-year summary table of the NAIC report. My research was selective, and these files do not include every data item that could be gleaned from the reports.

* The spreadsheets include hospital information that was gathered from a variety of stage agencies and Medicare cost reports. In addition, we requested that HMOs provide supplementary data regarding their enrollment by region of the state. The returns were limited to a few HMOs, but we have included that in the data set.

* Most of the files include additional analysis which begins below the base data tables or in other sheets within the workbook.

Spreadsheets in the first set are bolded.

	FILENAME	CONTENTS	YEARS
1.	Balance Sheet.xls	Balance sheet data and analysis for HMOs	1995-2008
2.	HMO Capitation.xls	HMO capitation payments to major medical groups and IPAs	1995-2008
3.	HMO Enrollment.xls	HMO enrollment (end of year members, member months) by line of business (Medicaid, Medicare, commercial); trend analysis.	1994-2008
4.	Hospitals.xls	Revenues, net income, occupancy and payer mix information for selected urban hospitals from Medicare cost reports	1998-2008
5.	Income Statement.xls	Expense and revenue items, multi-year surplus/ (loss) analysis, administrative cost analysis, medical cost analysis. Summary data from earlier years	1995- 2008
6.	Income by Line of Business.xls	Revenue and expense items allocated to Commercial, Medicare and Medicaid lines of business	1998-2008
7.	Inpatient Utilization (Inpatient)	HEDIS format data on inpatient hospital use for HMOs	1998 (later years only in annual reports)
8.	Medicaid info.xls	Summary items from CMS reports on Medicaid beneficiaries and vendor payments	1998, 2001-2004
9.	Medical Mutual (MedMut.xls)	Annual statement items for Medical Mutual of Ohio	1994-1998

OHIO