Florida Health Market Data Set

  • ID: 4455196
  • Database
  • Region: United States
  • Allan Baumgarten
1 of 3
A Series of Spreadsheets with Multiple Years of Detailed Data on the Finances and Enrollment of Health Insurers in the State and the Finances and Inpatient Utilization of Hospitals

The Florida Health Market Data Set is a series of spreadsheets with multiple years of detailed data on the finances and enrollment of health insurers in the state and the finances and inpatient utilization of hospitals. The health plan data is from annual NAIC statements and CMS downloads. The hospital data is from an annual survey administered by the Agency for Health Care Administration.'

Conventions and Notes:

  • The data set is a series of spreadsheets developed in preparing Florida Health Market Review.
  • Files are organized using Microsoft Excel and are copied onto a CD.
  • Most data are taken from the annual statements that each HMO submits to the Florida Department of Insurance, which follow the standard HMO blank of the National Association of Insurance Commissioners. The detailed financial (balance sheet and income-expense) and enrollment data are generally included for 1995-2010. The spreadsheets also include 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.
  • Most of the files include additional analysis which begins below the base data tables or in other sheets within each workbook.
Note: Product cover images may vary from those shown
2 of 3

17 FL Medicare: Enrollment by insurer and county in Medicare Advantage and Part D PDP plans - 2017

Balance Sheet.xls: Risk Based Capital analysis, balance sheet data and analysis for Florida health plans - 1995-2016

Capitation.xls: HMO capitation payments to major medical groups and IPAs - 1995-2012, 2014, 2016

Enrollment.xls: HMO enrollment (end of year members, member months) by line of business (Medicaid, Medicare, commercial); trend analysis. - 1994-2016

Enroll by county.xls: HMO enrollment by county and by line of business    1999-March 2005, June 2008, December - 2009, 2012, 2014, 2016

Income Statement.xls: Expense and revenue items, multi-year surplus/ (loss) analysis, administrative cost analysis, medical cost analysis. Summary data from earlier years - 1995-2016

Income by Line of Business: Revenue and expense items allocated to Commercial, Medicare and Medicaid lines of business - 1999-2012, 2014, 2016

Medicaid info (medicaid.xls): Summary items from CMS reports on Medicaid beneficiaries and vendor payments - 1996, 1998, 2001, 2002, 2004, 2008, 2009, 2010

Hospital data: Excerpted data from annual hospital survey and calculations - 2012-2016

Note: Product cover images may vary from those shown
3 of 3


4 of 3
Note: Product cover images may vary from those shown